Course detail

Advanced Database Systems

FIT-PDBAcad. year: 2010/2011

Not applicable.

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

Not applicable.

Prerequisites

Not applicable.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Not applicable.

Assesment methods and criteria linked to learning outcomes

Not applicable.

Course curriculum

Not applicable.

Work placements

Not applicable.

Aims

Not applicable.

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

Not applicable.

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-MGR-2 Master's

    branch MPV , any year of study, winter semester, elective
    branch MGM , any year of study, winter semester, compulsory-optional
    branch MBS , any year of study, winter semester, elective
    branch MIN , any year of study, winter semester, compulsory-optional
    branch MMM , any year of study, winter semester, elective
    branch MBI , 1. year of study, winter semester, compulsory
    branch MSK , 1. year of study, winter semester, compulsory-optional
    branch MPS , 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

Type of course unit

 

Lecture

26 hours, 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 hours, optionally

Teacher / Lecturer

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

Exercise in computer lab

6 hours, 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 hours, optionally

Teacher / Lecturer

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