Database Systems

Learning Outcomes

  1. application of the acquired knowledge about database system architecture
  2. application of the acquired knowledge about physical data organization in database systems
  3. application of the acquired knowledge about principles of query optimization
  4. application of the acquired knowledge about recovery in database systems
  5. application of the acquired knowledge about concurrency control
  6. application of the acquired knowledge about distributed database systems characteristics

Forms of Teaching

Lectures

Students are presented with theoretical settings of selected topics.

Week by Week Schedule

  1. DBMS architecture. Core DBMS components and their functions (e.g., query mechanisms, transaction management, buffer management, access methods). Memory hierarchy.
  2. Access methods. The impact of indices on query performance, B-trees, R-Trees.
  3. Physical implementation of relational algebra operators
  4. Query optimization
  5. Query optimization
  6. Transactions
  7. Failure and recovery
  8. Midterm exam
  9. Concurrency control
  10. Concurrency control
  11. Concurrency control
  12. Concurrency control
  13. Distributed database systems
  14. Distributed database systems
  15. Final exam

Study Programmes

University graduate
Audio Technologies and Electroacoustics (profile)
Free Elective Courses (2. semester)
Communication and Space Technologies (profile)
Free Elective Courses (2. semester)
Computational Modelling in Engineering (profile)
Free Elective Courses (2. semester)
Computer Engineering (profile)
Free Elective Courses (2. semester)
Computer Science (profile)
Free Elective Courses (2. semester)
Control Systems and Robotics (profile)
Free Elective Courses (2. semester)
Data Science (profile)
Free Elective Courses (2. semester)
Electrical Power Engineering (profile)
Free Elective Courses (2. semester)
Electric Machines, Drives and Automation (profile)
Free Elective Courses (2. semester)
Electronic and Computer Engineering (profile)
Free Elective Courses (2. semester)
Electronics (profile)
Free Elective Courses (2. semester)
Information and Communication Engineering (profile)
Free Elective Courses (2. semester)
Network Science (profile)
Free Elective Courses (2. semester)
Software Engineering and Information Systems (profile)
(2. semester)

Literature

H. Garcia-Molina, J. D. Ullman, J. D. Widom (2000.), Database System Implementation, Prentice Hall
Abraham Silberschatz, Henry F. Korth, S. Sudarshan (2011.), Database System Concepts, McGraw-Hill
Philip A. Bernstein, Vassos Hadzilacos, Nathan Goodman (1987.), Concurrency Control and Recovery in Database Systems, Addison-Wesley
M. Tamer Özsu, Patrick Valduriez (1999.), Principles of Distributed Database Systems, Prentice Hall

For students

General

ID 222788
  Summer semester
5 ECTS
L0 English Level
L1 e-Learning
45 Lectures

Grading System

Excellent
Very Good
Good
Acceptable