1 / 14

Lecture 1 Intro Databases and Information Systems DT210

Lecture 1 Intro Databases and Information Systems DT210. Contact. Susan McKeever Room K201 Susan.mckeever@dit.ie www.comp.dit.ie/smckeever. Times. Lectures and labs times Lectures – Monday 7:30 – 9:30 pm Labs – A portion of the Monday night session. Course Content.

nola
Download Presentation

Lecture 1 Intro Databases and Information Systems DT210

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lecture 1 Intro Databases and Information SystemsDT210

  2. Contact Susan McKeever Room K201 Susan.mckeever@dit.ie www.comp.dit.ie/smckeever Advanced Databases

  3. Times Lectures and labs times Lectures – Monday 7:30 – 9:30 pm Labs– A portion of the Monday night session Advanced Databases

  4. Course Content • This course covers advanced database management system design principles and techniques. • Topics will include • Database management • Database modelling • Database security • Distributed Databases • Data and database integration • Optimisation and tuning, concurrency, recovery and integrity Advanced Databases

  5. Books and resources Book titles Fundamentals of Database Systems -5th Ed,Elmasri & Navathe(Main Book) Database Systems -4th Ed. Connolly & Begg (Good book for introduction and advanced topics) Various research papers Web SQL: http://www.w3schools.com/sql SQL: http://www.sqlzoo.com/ Advanced Databases

  6. Assessment for this course • Assignments – 40% - will have about 5 weeks to do • Written exam – 60% • Past papers will be available on website Advanced Databases

  7. Labs Hands on experience with data modelling and setting up databases Various available – Oracle …. Access Who has used what? Advanced Databases

  8. Databases What is a database ? Shared collection of logically related data (and a description of this data), designed to meet the information needs of an organization. So… Advanced Databases

  9. Data and Databases • Why are Databases important? • Can’t have a system without persistent data storage (usually) • An organisation’s data is stored in databases (usually) • Databases are important to you because.. • A critical part of any organisation’s IT infrastructure • A fundamental part of an IT professional’s knowledge Advanced Databases

  10. Who has used a dB today? Advanced Databases

  11. Examples of dB applications • Purchases from the supermarket • Purchases using your credit card • Booking a holiday at the travel agents • Using the local library • Taking out insurance • Renting a video • Using the Internet • Studying at university Advanced Databases

  12. Databases Who’s doing what? Commercial Market Share $ Oracle - Oracle IBM – DB2, Informix Microsoft SQL Server – limited to Windows ….. ….. Open source Postgresql SQLlite .. What about MySQL? Advanced Databases

  13. Database Vendors Advanced Databases

  14. Quiz Advanced Databases

More Related