13S113BP2 - Databases 2
Course specification | ||||
---|---|---|---|---|
Course title | Databases 2 | |||
Acronym | 13S113BP2 | |||
Study programme | Software Engineering | |||
Module | ||||
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. | |||
Contents | ||||
URL to the subject page | https://bp2.etf.bg.ac.rs/ | |||
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 | ||||
| ||||
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 |