Database Systems

Professors George Vassilacopoulos
Maria Halkidi
Christos Manousopoulos
Course category CM/SDS
Course ID DS-505
Credits 5
Lecture hours 3 hours
Lab hours 2 hours
Digital resources View on Evdoxos (Open e-Class)

Learning Outcomes

The students upon the successful completion of the course will be able:

  • to apply the appropriate techniques for programming and managing database systems
  • to know the basic storage and data organization structures.
  • to apply query processing, query optimization and transaction management mechanisms.
  • to understand the mechanisms that ensure the integrity of the system in the case of multiple concurrent users with access to the same data and database recovery methods in case of failure.

Course Contents

  • Introduction to Database Management Systems (DBMSs). Fundamental concepts of DBMSs, database applications, overview of data models.
  • Data storage and file organization.
  • Query processing methods
  • Query optimization methods.
  • Transaction management: characteristics of a transaction management system.
  • Concurrency Control.
  • Database recovery methods.
  • Parallel and Distributed databases: design, query processing and transaction management in distributed systems.

Recommended Readings

  • Ramakrishnan R. & Gehrke J. (2002): Database Management Systems (3rd Edition), McGraw Hill.
  • Elmasri R. & Navathe S.B. (2007): Fundamentals of Database Systems (5th Edition), Addison-Wesley.