Faculty of Information Technology, BUT

Course details

Advanced Database Systems

PDB Acad. year 2011/2012 Winter semester 5 credits

Current academic year

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.

Guarantor

Language of instruction

Czech

Completion

Credit+Examination (written)

Time span

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

Assessment points

60 exam, 20 half-term test, 20 projects

Department

Lecturer

Instructor

Subject specific learning outcomes and competences

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.

Learning objectives

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.

Prerequisite kwnowledge 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

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 - others, projects and individual work of students

  1. Creation and feature demonstration of database in a post-relational database system (used spatial, temporal, or deductive DBS)

Progress assessment

  • Mid-term exam, for which there is only one schedule and, thus, there is no possibility to have another trial.
  • One project should be solved and delivered in a given date during a term.

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 - the minimal number of points which can be obtained from the final exam is 25, otherwise, no points will be assigned to a student.)

Exam prerequisites

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.

Course inclusion in study plans

  • Programme IT-MSC-2, field MBI, MGM., MIN., MIS, MIS., MPS, 1st year of study, Compulsory
  • Programme IT-MSC-2, field MBS, MMM, MPV, any year of study, Elective
  • Programme IT-MSC-2, field MGM, any year of study, Compulsory-Elective group I
  • Programme IT-MSC-2, field MIN, any year of study, Compulsory-Elective group S
  • Programme IT-MSC-2, field MMI, any year of study, Compulsory-Elective group O
  • Programme IT-MSC-2, field MSK, 1st year of study, Compulsory-Elective group N
Back to top