Course Details

Course Code (English)*

Semester*

Title (English)*

Lecture Hours (Weekly)

ECTS Credits*

Course Type (English)

Prerequisites (English)

Course URL (e.g., on e-class)

Learning Outcomes (English) The course aims to familiarize students with issues concerning the operation of databases and their efficient design. Such issues comprise: data redundancy, data integrity, query processing, security, recovery and concurrency control of transactions. At the same time the objective is to improve the students skills in programming languages for databases and teach them the basic concepts of data management and information mining from databases. At the end of the course the students must be able to: - Know the basic principles of database systems, the design process of a database. - Engage in the collaborative design of a database that optimizes query execution - Activate and manipulate the appropriate access control mechanisms, transaction management etc.

General Competencies (English) - Independent work - Team work - Adaptation in new conditions

Course Content (English) Introduction to Database Design. Criteria for the quality of DB design. Functional Dependencies. Schema Normalization. Physical design. Storage and Indexing Structures. Query Processing and optimization. Transaction Processing, time-scheduling and serialization. Concurrency Control. Database recovery techniques. Distributed Databases and Databases on the Web. Object-oriented and Object-relational databases. Semi-structured data. Data warehouses and data mining.

Use of ICT (English) - Specific software for query execution optimization - Specific software for database programming - Dissemination and organization of course material using OpenClass - Communication via OpenClass and emails

Is it elective? Άγνωστο Ναι Όχι

Load within semester (Hours)

Lecture Hours

Lab Hours

Independent Study*

Project Work*

Lab Report*