Y4. Data Management

Instructors: Ioannis Kotidis, Chrysostomos Kapetis

Mandatory, Teaching Period B, ECTS: 6


Entity-Relationship model and relational databases. The SQL language (DDL and DML commands). Using SQL SERVER to create, query and manage a relational database. Hierarchical data models, XML language, XML document validation (DTD and XML schemas).  Semantic Web, Resource Description Framework Language (RDF/XML & RDF/TTL), RDF Query Language (SPARQL). Graph data management: introduction to the property graph model. Linked data analysis using neo4j.  Introduction to the Cypher language.  NoSQL systems for big data management. Application examples: social data analysis, document databases.



Target Learning Outcomes

Upon successful completion of this course, students will be able to:

  • Understand, appreciate and effectively explain the underlying concepts of data management.
  • Apply conceptual database modeling methods to design a relational database.
  • Use SQL language in conjunction with a modern RDBMS to define, query and manage a relational database.
  • Use methods and tools to represent and manage linked data.
  • Be familiar with the underlying concepts of big data systems.

Recommended Bibliography

  • Silberschatz, Korth, Sudarsham. Database system concepts. 6th ed., McGraw-Hill, 2010.
  • Γιαννακουδάκης, Εμμανουήλ I. Συστήματα βάσεων δεδομένων, Αθήνα: Μπένος, 2009.
  • Grigoris Antoniou & Frank van Harmelen. Εισαγωγή στον Σημασιολογικό Ιστό, Αθήνα:Κλειδάριθμος,2009.
  • Bob DuCharme, Learning SPARQL. 2th ed, O’Reilly, 2013.

Teaching and Learning Activities

One three-hour lecture per week, study exercises and programming exercises as homework (some to be submitted).

Assessment and Grading Methods

The final grade is the average of the final examination grade (50%) and the grade of the study and programming exercises to be submitted (50%).