Skip to main content
Skip header
Terminated in academic year 2022/2023

Database and Information Systems II

Type of study Follow-up Master
Language of instruction English
Code 460-4068/02
Abbreviation DAIS II
Course title Database and Information Systems II
Credits 4
Coordinating department Department of Computer Science
Course coordinator prof. Ing. Michal Krátký, Ph.D.

Subject syllabus

Lectures:
1. Introduction, data storages, RAID
2. Data modelling and functional analysis
3. Physical database design I
4. Physical database design II
5. Physical database design III
6. Compression in DBMS
7. Data Layer of IS - ORM, implementation, and benchmarking
8. Spatial data and Spatial extensions of DBMS
9. Distributed and NoSQL DBMS
10. NoSQL, BigData storages
11. Distributed transactions, eventual consistency
12. Data integration, ERP systems
13. Native XML databases

Practices include samples and tasks related to the topics of lectures.

Literature

H. Garcia-Molina, J. D. Ullman, J. Widom: Database Systems: The Complete Book (2nd Edition). Prentice Hall; 2 edition (June 15, 2008).

Advised literature

S. S. Lightstone, T. J. Teorey (Author), T. Nadeau: Physical Database Design, 1st Edition. Morgan Kaufmann; 4th edition (April 4, 2007).