Advanced Topics in Databases

Academic Semester:
Course TypeReference NumberSubprogram
Compulsory in SubprogramTheory: ΤΠ60Λ1
Software Engineering
SemesterAcademic YearHours per week
Spring3rdTheory: 3 Lab: 2
Theory: Final written exam in the whole material (100%). The test includes five theory questions (1 point each) and three exercises (2.50 points each) from which the student selects and performs two. Laboratory: The final grade is subsumed under the eval69
PrerequisitesTeaching methodTeaching Language
DatabasesLectures with parallel laboratory classesGreek

Academic Staff

Faculty in charge: 
da's picture
ακουμιανάκης δημοσθένης
Akoumianakis Demosthenes


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.

Head of the Department οf Informatics Engineering

Deputy Head of the Department οf Informatics Engineering

Address: Department of Informatics Engineering, School of EngineeringTEI of Crete, Heraklion, Crete, P.O Box: 71500
Tel: 2810-379716, 2810-379795, 2810-379853
Fax: 2810-379717

Tel: 2810-379776