Implementation of database systems 1000-2M25IBD
1. DBMS architectures. The CAP theorem. SQL / NoSQL / NewSQL.
2. Concurrency: process models, memory coordination.
3. Query processing, query planner.
4. Query optimizer.
5. Access paths. Types of indexes.
6. OLTP vs. OLAP. Data warehousing. Materialized views.
7. Data storage management. Buffer management.
8. Transactions, concurrency, locking.
9. Failure recovery.
10. Memory management.
11. Data dictionary.
12. Administration, monitoring, supporting tools.
13. Data integration.
14. Stream processing engines.
15. Web data.
Main fields of studies for MISMaP
Type of course
Mode
Requirements
Course coordinators
Assessment criteria
As part of the laboratory, a team-based programming project will be carried out with the goal of developing a new or extending an existing database management system using the modern open-source tools and software engineering techniques. Participation in this project, the quality of the produced artifacts, and the ability to collaborate effectively within a team will form the basis for the final grade in the course.
Bibliography
Garcia-Molina, Hector, Jeffrey D. Ullman, and Jennifer Widom. Database Systems: The Complete Book, Second Edition. Peason Education 2013.
.
Garcia-Molina, Hector, Jeffrey D. Ullman, and Jennifer Widom. Database system implementation. Prentice Hall, 2000.
Bailis, Peter, Joseph Hellerstein, Micheal Stonebraker, Readings in database systems. 2017.
Hellerstein, Joseph M., Michael Stonebraker, and James Hamilton. Architecture of a database system. Foundations and Trends® in Databases 1.2 (2007): 141-259.
Petrov, Alex. Database Internals: A deep dive into how distributed data systems work. O'Reilly Media, 2019.
Abadi, Daniel, Boncz, Peter., Harizopoulos, Stavros., Idreos, Stratos., & Madden, Samuel. "The design and implementation of modern column-oriented database systems." Foundations and Trends® in Databases 5.3 (2013): 197-280.
Additional information
Information on level of this course, year of study and semester when the course unit is delivered, types and amount of class hours - can be found in course structure diagrams of apropriate study programmes. This course is related to the following study programmes:
- Bachelor's degree, first cycle programme, Computer Science
- Master's degree, second cycle programme, Computer Science
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: