24S114BP2 - Databases 2

Course specification
Course title		Databases 2
Acronym		24S114BP2
Study programme		Software Engineering
Module
Type of study		bachelor academic studies
Lecturer (for classes)		professor PhD Miloš Cvetanović
Lecturer/Associate (for practice)		asst. MA Tamara Šekularac Obradović, electrical and computer engineer
Lecturer/Associate (for OTC)		asst. MA Tamara Šekularac Obradović, electrical and computer engineer
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.
Contents
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.
Literature
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) Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery, G. Weikum, G. Vossen, Morgan Kaufmann, 2001 (Original title) 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			Test paper	30
Practical lessons		15	Oral examination
Projects
Colloquia		25
Seminars		30