Course details
Advanced Database Systems
Guarantor
Language of instruction
Completion
Time span
- 26 hrs lectures
- 6 hrs exercises
- 6 hrs pc labs
- 14 hrs projects
Department
Study literature
- Kim, W. (ed.): Modern Database Systems, ACM Press, 1995, ISBN 0-201-59098-0
- Melton, J.: Advanced SQL: 1999 - Understanding Object-Relational and Other Advanced. Morgan Kaufmann, 2002, p. 562, ISBN 1-558-60677-7
- Shekhar, S., Chawla, S.: Spatial Databases: A Tour, Prentice Hall, 2002/2003, p. 262, ISBN 0-13-017480-7
- Dunckley, L.: Multimedia Databases: An Object-Relational Approach. Pearson Education, 2003, p. 464, ISBN 0-201-78899-3
Fundamental literature
- Kim, W. (ed.): Modern Database Systems, ACM Press, 1995, ISBN 0-201-59098-0
- Melton, J.: Advanced SQL: 1999 - Understanding Object-Relational and Other Advanced. Morgan Kaufmann, 2002, p. 562, ISBN 1-558-60677-7
- Shekhar, S., Chawla, S.: Spatial Databases: A Tour, Prentice Hall, 2002/2003, p. 262, ISBN 0-13-017480-7
- Dunckley, L.: Multimedia Databases: An Object-Relational Approach. Pearson Education, 2003, p. 464, ISBN 0-201-78899-3
- Gaede, V., Günther, O.: Multidimensional Access Methods, ACM Computing Surveys, Vol. 30, No. 2, 1998, pp. 170-231.
Syllabus of lectures
- Introduction, post-relational database definition, used terms
- Object-relational database systems, standard SQL/99
- Spatial database systems, introduction
- Modelling of spatial database systems
- Querying in spatial database systems
- Algorithms used in spatial database systems
- Image and multimedia database systems
- Temporal database systems, introduction
- Temporal data models
- Algorithms used in temporal database systems
- Deductive databases, introduction
- Models and implementation of deductive database systems
- Conclusion, comparison of various database systems, open items discussion
Syllabus of computer exercises
- Introduction to used DB system (Oracle), simple post-relational database creation
- Manipulation techniques for post-relational data - simple queries
- More complicated queries
- Another kind of queries
- Connection to DB via JDBC
- Demonstration of Java client
- Project demonstration
Course inclusion in study plans