Course details
Post-Relational Databases
PRD Acad. year 2004/2005 Summer semester 6 credits
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
Language of instruction
Completion
Time span
- 26 hrs lectures
- 26 hrs pc labs
- 13 hrs projects
Department
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
There are no prerequisites
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
- Introduction, post-relational database definition, used terms
- Spatial database systems, introduction
- Modelling of spatial database systems
- Querying in spatial database systems
- Algorithms used in spatial database systems
- Temporal database systems, introduction
- Temporal data models
- Querying in and usage of spatial database systems
- Algorithms used in temporal database systems
- Deductive databases, introduction
- Models and implementation of deductive database systems
- Algorithms used in deductive database systems
- Conclusion, comparison of various database systems, open items discussion
Syllabus of computer exercises
- Introduction to used DB system (Oracle)
- Simple database creation
- Manipulation techniques for post-relational data - simple queries
- More complicated queries
- Another kind of queries
- Connection to DB via JDBC
- Ukázkové řešení klienta in Java
- Demonstration of other post-relational DB system
- Data definition and manipulation
- Queries in the DB system
- Demonstration of other post-relational DB system
- Discussion
- Project demonstration
Progress assessment
Study evaluation is based on marks obtained for specified items. Minimimum number of marks to pass is 50.
Not designated.
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. (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. (60 points)