Course details

Post-Relational Databases

PRD Acad. year 2006/2007 Winter semester 5 credits

Current academic year

The course explains some technologies and features of deductive, spatial, and temporal databases. It uses realational or object-oriented DB systems as a basis for the explanation. The course concentrates on understanding of philisophy tightly connected with a given database scheme. Moreover, implementation and evaluation techniques are mentioned too.

Guarantor

Kolář Dušan, doc. Dr. Ing. (DIFS)

Language of instruction

Czech

Completion

Credit+Examination

Time span

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

Department

Department of Information Systems (UIFS)

Subject specific learning outcomes and competences

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

Learning objectives

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

Prerequisite knowledge and skills

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.

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
  • Přednášky v elektronické podobě

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

  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

Syllabus of computer exercises

  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

Progress assessment

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.

Controlled instruction

  • Mid-term exam - written form, a test, where answers are given in sentences, by selection of appropriate answer from offered ones, and by combination of both of these possibilities, 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, a test, where answers are given in sentences, by selection of appropriate answer from offered ones, and by combination of both of these possibilities, 2 another corrections trials possible. (60 points)
Back to top