Advanced Database Systems

• 26 hrs lectures
• 6 hrs exercises
• 6 hrs pc labs
• 14 hrs projects

Students will be able identify clearly post-relational DB systems and, for selected categories, they will also be able to discuss issues of implementation and usage of such systems.

• Student learns terminology in Czech and English language
• Student improves in participation on a small project as a member of a small team

The aim of course is to give a broader introduction into post-relational database systems (object-relational, temporal, spatial, deductive multimedia, and XML). Various systems and their implementation techniques are discussed.

Fundamentals of the relational model. Normalization-based design of a relational database. Organization of data at an internal level. Data security and integrity. Transactions. Relational database design from a conceptual model. SQL language.

• 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

• 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.

1. Introduction, post-relational database definition, used terms
2. Object-relational database systems, standard SQL/99
3. Spatial database systems, introduction
4. Modelling of spatial database systems
5. Querying in spatial database systems
6. Algorithms used in spatial database systems
7. Image and multimedia database systems
8. Temporal database systems, introduction
9. Temporal data models
10. Algorithms used in temporal database systems
11. Deductive databases, introduction
12. Models and implementation of deductive database systems
13. Conclusion, comparison of various database systems, open items discussion

1. Introduction to used DB system (Oracle), simple post-relational database creation
2. Manipulation techniques for post-relational data - simple queries
3. More complicated queries
4. Another kind of queries
5. Connection to DB via JDBC
6. Demonstration of Java client
7. Project demonstration

At the end of a term, a student should have at least 50% of points that he or she could obtain during the term; that means at least 20 points out of 40.
Plagiarism and not allowed cooperation will cause that involved students are not classified and disciplinary action can be initiated.

The course uses teaching methods in form of Lecture - 2 teaching hours per week, Exercise - 1 teaching hour per week, Computer exercise - 1 teaching hour per week, Projects - 1 teaching hour per week.

• Mid-term exam - written form, questions, where answers are given in full sentences, no possibility to have a second/alternative trial. (20 points)
• Projects realization - 1 project (program development according to a given specification) with appropriate documentation. (20 points)
• Final exam - written form, questions, where answers are given in full sentences, 2 another corrections trials possible. (60 points - the minimal number of points which can be obtained from the final exam is 25, otherwise, no points will be assigned to a student.)