Y4. Data Management

    Instructors: Ioannis Kotidis, Chrysostomos Kapetis

    Mandatory, Teaching Period B, ECTS: 6

    Contents

    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.

    Prerequisites

    None

    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%).

    Back