Course detail

Advanced Database Systems

FIT-PDBAcad. year: 2009/2010

The course offers broader introduction into the following modern database systems: object-relational databases, deductive databases, spatial databases, temporal databases, multimedia databases, and advanced relational databases. There are also discussed priciples of the modern database systems, their scheme, and techniques for efficient usage of such systems. In the lectures, there are also introduced implementation principles of the modern database systems and data manipulation techniques.

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

doc. Dr. Ing. Dušan Kolář

Department

Department of Information Systems (UIFS)

Learning outcomes of the course unit

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.

Prerequisites

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.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Not applicable.

Assesment methods and criteria linked to learning outcomes

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.

Course curriculum

  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

Work placements

Not applicable.

Aims

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

Specification of controlled education, way of implementation and compensation for absences

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

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

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

Recommended reading

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

Classification of course in study plans

  • Programme IT-MSC-2 Master's

    branch MBI , 1 year of study, winter semester, compulsory
    branch MBS , 0 year of study, winter semester, elective
    branch MGM , 0 year of study, winter semester, compulsory-optional
    branch MGM , 1 year of study, winter semester, compulsory
    branch MIN , 0 year of study, winter semester, compulsory-optional
    branch MIN , 1 year of study, winter semester, compulsory
    branch MIS , 1 year of study, winter semester, compulsory
    branch MIS , 1 year of study, winter semester, compulsory
    branch MMI , 1 year of study, winter semester, compulsory-optional
    branch MMM , 0 year of study, winter semester, elective
    branch MPS , 1 year of study, winter semester, compulsory
    branch MPV , 0 year of study, winter semester, elective
    branch MSK , 1 year of study, winter semester, compulsory-optional

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

doc. Dr. Ing. Dušan Kolář

Syllabus

  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

Fundamentals seminar

6 hod., optionally

Teacher / Lecturer

doc. Dr. Ing. Dušan Kolář

Exercise in computer lab

6 hod., optionally

Teacher / Lecturer

doc. Dr. Ing. Dušan Kolář

Syllabus

  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

Project

14 hod., optionally

Teacher / Lecturer

doc. Dr. Ing. Dušan Kolář