Database Systems
Course Description
Overview of physical data organization. Storage organization in database management systems. Transaction concept. Serializability theory. Concurrency-control schemes. Database recovery. Principles of query optimization. Distributed databases, global transactions, atomic commitment, serializability, distributed deadlock. Data replication, replication protocols, serializability, availability and consistency in replicated databases.
Learning Outcomes
- application of the acquired knowledge about database system architecture
- application of the acquired knowledge about physical data organization in database systems
- application of the acquired knowledge about principles of query optimization
- application of the acquired knowledge about recovery in database systems
- application of the acquired knowledge about concurrency control
- application of the acquired knowledge about distributed database systems characteristics
Forms of Teaching
Lectures
Students are presented with theoretical settings of selected topics.
Grading Method
Continuous Assessment | Exam | |||||
---|---|---|---|---|---|---|
Type | Threshold | Percent of Grade | Threshold | Percent of Grade | ||
Mid Term Exam: Written | 40 % | 35 % | 0 % | |||
Final Exam: Written | 40 % | 45 % | ||||
Final Exam: Oral | 20 % | |||||
Exam: Written | 50 % | 80 % | ||||
Exam: Oral | 20 % |
Week by Week Schedule
- DBMS architecture. Core DBMS components and their functions (e.g., query mechanisms, transaction management, buffer management, access methods). Memory hierarchy.
- Access methods. The impact of indices on query performance, B-trees, R-Trees.
- Physical implementation of relational algebra operators
- Query optimization
- Query optimization
- Transactions
- Failure and recovery
- Midterm exam
- Concurrency control
- Concurrency control
- Concurrency control
- Concurrency control
- Distributed database systems
- Distributed database systems
- Final exam
Study Programmes
University graduate
[FER3-HR] Audio Technologies and Electroacoustics - profile
Elective Courses
(2. semester)
[FER3-HR] Communication and Space Technologies - profile
Elective Courses
(2. semester)
[FER3-HR] Computational Modelling in Engineering - profile
Elective Courses
(2. semester)
[FER3-HR] Computer Engineering - profile
Elective Courses
(2. semester)
[FER3-HR] Computer Science - profile
Elective Courses
(2. semester)
[FER3-HR] Control Systems and Robotics - profile
Elective Courses
(2. semester)
[FER3-HR] Data Science - profile
Elective Courses
(2. semester)
[FER3-HR] Electrical Power Engineering - profile
Elective Courses
(2. semester)
[FER3-HR] Electric Machines, Drives and Automation - profile
Elective Courses
(2. semester)
[FER3-HR] Electronic and Computer Engineering - profile
Elective Courses
(2. semester)
[FER3-HR] Electronics - profile
Elective Courses
(2. semester)
[FER3-HR] Information and Communication Engineering - profile
Elective Courses
(2. semester)
[FER3-HR] Network Science - profile
Elective Courses
(2. semester)
[FER3-HR] Software Engineering and Information Systems - profile
(2. semester)
Theoretical Course
(2. semester)
[FER2-HR] Telecommunication and Informatics - profile
Specialization Course
(2. semester)
Literature
Lecturers
For students
General
ID 222788
Summer semester
5 ECTS
L0 English Level
L1 e-Learning
45 Lectures
0 Seminar
0 Exercises
0 Laboratory exercises
0 Project laboratory
Grading System
87.5 Excellent
75 Very Good
62.5 Good
50 Acceptable