13M114BP2 - Selected topics of databases

Course specification
Course title		Selected topics of databases
Acronym		13M114BP2
Study programme		Electrical Engineering and Computing
Module		Applied Mathematics, Audio and Video Technologies, Biomedical and Environmental Engineering, Biomedical and Nuclear Engineering, Computer Engineering and Informatics, Electronics and Digital Systems, Energy Efficiency, Information and communication technologies, Information and Communication Technologies, Microwave Engineering, Nanoelectronics and Photonics, Power Systems - Networks and Systems, Power Systems - Renewable Energy Sources, Power Systems - Substations and Power Equipment, Signals and Systems, Software Engineering
Type of study		master academic studies
Lecturer (for classes)		professor PhD Miloš Cvetanović
Lecturer/Associate (for practice)		asst. professor PhD Stefan Tubić asst. MA Janko Tufegdžić, electrical and computer engineer
Lecturer/Associate (for OTC)		asst. professor PhD Stefan Tubić asst. MA Janko Tufegdžić, 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		0	Test paper	30
Practical lessons		15	Oral examination	0
Projects		30
Colloquia		25
Seminars