13S113BP2 - Databases 2

Course specification
Course title Databases 2
Acronym 13S113BP2
Study programme Software Engineering
Type of study bachelor academic studies
Lecturer (for classes)
Lecturer/Associate (for practice)
Lecturer/Associate (for OTC)
ESPB 6.0 Status elective
Condition Databases 1
The goal Physical Database Design. Query Execution. Query Optimisation. Transaction management. Parallel and Distributed databases. Extensible Markup Language (XML).
The outcome Students will be able to exploit indexes, views, storage, and other aspects of physical design, and understanding transaction management, parallel and distributed database.
URL to the subject page
Contents of lectures Physical Database Design. Indexes. Materialized Views. Partitioning. Multidimensional Clustering. Transaction execution. Crash Recovery. Extensible Markup Language (XML). DTD and XML Schemas. XPath. XQuery.
Contents of exercises Conduct and evaluate relational DB system, database optimisation, discuss the properties of good DB systems, implement XML queries.
  1. Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more, 4th edition. S. Lightstone, T. Teorey, T. Nadeau, Morgan Kaufmann, 2010 (Original title)
  2. Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery, G. Weikum, G. Vossen, Morgan Kaufmann, 2001 (Original title)
  3. XQuery: Search Across a Variety of XML Data, 2nd edition, P. Walmsley, O'Reilly Media, 2016 (Original title)
Number of hours per week during the semester/trimester/year
Lectures Exercises OTC Study and Research Other classes
2 2 1
Methods of teaching 30 hours of lectures + 30 hours of supervised problem classes + 15 hours of supervised laboratory classes, midterm tests and project. Approximately 75 hours of personal study and exercise (3 hours per week during semester, and approximately 30 hours of preparation during exam term).
Knowledge score (maximum points 100)
Pre obligations Points Final exam Points
Activites during lectures 0 Test paper 30
Practical lessons 15 Oral examination 0
Projects 30
Colloquia 25