Advanced Database Concepts

Course Description:
The course focuses generally on the advanced concepts prevail in databases. This course covers: (a) files storage and structures; (b) query processing component of a relational database system; (c) Fundamental knowledge of concurrency control and database recovery; (d) Fundamental knowledge about Information retrieval; (e) fundamental knowledge of XML data management.

Objectives and Outcomes
Databases are at the heart of modern commercial application development. The objective of the course is to familiarize students with the concepts and applications of advanced techniques in database systems. At the completion of the course, students will be able to:

  • apply advanced database concepts for complex issues

  • manage and manipulate advanced database processing

Course Description:

  • Database basics concepts
  • File storage and structures
  • query processing in RDBMS
  • Fundamentals of concurrency control
  • Fundamentals of database recovery
  • Fundamentals of Information Retrieval
  • Fundamentals of XML data Management
     

Text Books:

  • Fundamentals of Database Systems. By R. Elmasri and S. Navathe, 4th Edition, 2004
  • Database Systems: The Complete Book. By H. Garcia-Molina, J. D. Ullman, and J. Widom; Prentice Hall, 2002.
  • Database Management Systems, By R. Ramakrishnan, J. Gehrke, 3rd Edition, 2003.

Furthermore, a collection of papers addressing specific topics will be distributed in class.

Related Links
Course Name Location
74.783 Distributed Database Systems Department of Computer Science, University of Manitoba Canada
   
 

For more information click here