1 / 6

Advanced Course on Databases

This course covers advanced topics in database management systems, including query processing, transaction processing, concurrency control, recovery techniques, database security, object-oriented databases, and special database types.

Download Presentation

Advanced Course on Databases

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. Advanced Course on Databases(Tietokantojen jatkokurssi) Jukka Teuhola Dept. of Information Technology University of Turku Fall 2015, period 1 AdvDB-1 J. Teuhola 2015

  2. General • Lecturer: Jukka Teuhola,email: jukka.teuhola (at) utu.fi • Form: Self-study courseStarting lecture: Tue 08.09.2015 at 8:15-10:00 (Beta) • Homework: 10 exercise tasks • Individual solutions must be submitted before the exam • Minimum: 50% of the solutions must be ‘acceptable’ • Examinations: 23.11.2015, Jan 2016, Feb 2016 • Preliminary knowledge: Basic course on databases (Databases I-II in the department’s curriculum). • Course webpage:http://staff.cs.utu.fi/kurssit/advanced_course_on_databases/autumn_2015 AdvDB-1 J. Teuhola 2015

  3. Main themes of the course • Database management systems:Features, functions and implementation(Chapters 2-6) • Database ’trends’:Object-orientation, distribution, data warehouses, semi-structured databases, ...(Chapters 7-) AdvDB-1 J. Teuhola 2015

  4. Assumed preliminary knowledge • General database principles • Relational data model • SQL • Relational algebra • Relational database design • File organizations • Index structures AdvDB-1 J. Teuhola 2015

  5. Course material • Slides:http://staff.cs.utu.fi/kurssit/advanced_course_on_databases/autumn_2015/AdvDBslides2015.zip • Textbook:R. Elmasri, S.B. Navathe: "Fundamentals of Database Systems", 6th ed., Pearson/Addison-Wesley, 2011. (The 4th and 5th editions are suitable, as well.) • The individual chapters are given below. They should be consulted to the extent that is necessary to understand the topics in slides. AdvDB-1 J. Teuhola 2015

  6. Contents and related book sections Lecture chapter Edition 3rd 4th 5th 6th - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 2. Query processing and opt. 18 15 15 18 3. Transaction processing 19 17 17 20 4. Concurrency control 20 18 18 21 5. Recovery techniques 21 19 19 22 6. Database security 22 23 23 25 7. Object-oriented databases 11 20 20 10 12 21 21 13 22 22 8. Special database types 24 25 25 11 26 26 27 23 27 28 29 26 29 30 AdvDB-1 J. Teuhola 2015

More Related