Semester:
5th
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 (S1):
-
Data and Knowledge Management (S2):
Υ Υποχρεωτικό
Software (S3):
Υ Υποχρεωτικό
Hardware and Architecture (S4):
-
Communications and Networking (S5):
-
Signal and Information Processing (S6):
-
Related Courses
Detailed Description
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.