Implementation of Database Management Systems

Semester:
5ο
Course Type:
Track Compulsory courses (EYM)
Track:
CS (Computer Science)
Code:
Κ18
ECTS:
6
TEACHING HOURS per week
Theory:
3
Seminar:
1
Laboratory:
-
Specializations
Foundations of Computer Science (Ε1):
-
Data and Knowledge Management (Ε2):
Υ Υποχρεωτικό
Software (Ε3):
Υ Υποχρεωτικό
Hardware and Architecture (Ε4):
-
Communications and Networking (Ε5):
-
Signal and Information Processing (Ε6):
-
Related Courses
Course Content

Introduction to Database Management Systems, differences from File Management Systems, physical characteristics of external storage units (mostly disks), data organization on disks, the concept of a file, buffer management, primary file organizations, secondary file organizations, static and dynamic data structures, ISAM, B+ trees, static and dynamic hashing, external file sorting, relational algebra, processing of relational-algebra operators and corresponding algorithms, processing cost according to the type of index used, optimization of relational algebra queries, the concept of transaction, concurrency control, crash recovery.