The course aims to present current methods and recent trends regarding advanced database systems. Both theoretical and laboratory parts of the course, require familiarity with classical data models, such as relational model & tools and computer systems (Database Management Systems) that support them.
The specific objectives of the course are focused in four main themes: (a) deepening the theory behind using classical models and database management systems, (b) the design theories of relational schemas using theoretical and practical tools and methods, (c) understanding and familiarity with alternative data models, and (d) the use of advanced tools (e.g. object-relational systems) and models (e.g. XML, XQuery).
In a series of laboratory exercises, the student gets familiar with:
- The theory of functional dependencies
- The basic shape decomposition algorithms and decomposition control
- The UML and the profile for databases
- Object-relational systems such as PostgreSQL, SQL3, ORACLE
- Graph data management and property graphs
- The deductive database approach using a logic programming language like Prolog
- The use of XML as a data model and the technology to create and manage XML schemas
Finally, students undertake in small groups to complete and implement small-scale (mini-projects) and present the results of their work by the use of audiovisual media.
- C.J. Date (2002): Εισαγωγή στα Συστήματα Βάσεων Δεδομένων – Τόμοι Α' & Β', Μετάφραση στα Ελληνικά από τις εκδόσεις "Κλειδάριθμος".
- A. Silberschatz, H. F. Korth & S. Sudarshan (2001): Database System Concepts (4th Edition), McGraw-Hill ISBN 0-07-255481-9.
- R. Elmasri & S. Navathe (1996): Fundamentals of Database Systems, Μετάφραση στα Ελληνικά από τις εκδόσεις "ΔΙΑΥΛΟΣ".
- M. Liu, G. Dobbie, T. W. Ling (2002): A Logical Foundation for Deductive Object-Oriented Databases, ACM Transactions on Database Systems, Vol. 27, No. 1, Pages 117–151.
- J. Grant and J. Minker (1992): The impact of Logic Programming on Databases, Communications of the ACM, Vol.35, No.3, March.