Title:

Post-Relational Databases

Code:PRD
Ac.Year:ukončen 2004/2005
Sem:Summer
Language of Instruction:Czech
Public info:http://www.fit.vutbr.cz/study/courses/PRD/public/
Private info:http://www.fit.vutbr.cz/study/courses/PRD/private/
Credits:6
Completion:examination (written)
Type of
instruction:
Hour/semLecturesSeminar
Exercises
Laboratory
Exercises
Computer
Exercises
Other
Hours:26002613
 ExamsTestsExercisesLaboratoriesOther
Points:60200020
Guarantor:Kolář Dušan, doc. Dr. Ing. (DIFS)
Lecturer:Kolář Dušan, doc. Dr. Ing. (DIFS)
Instructor:Kolář Dušan, doc. Dr. Ing. (DIFS)
Faculty:Faculty of Information Technology BUT
Department:Department of Information Systems FIT BUT
Prerequisites: 
Data Modelling and Database Design (DSI), DCSY
 
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.
Description:
  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.
Learning outcomes and competencies:
  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.
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
Syllabus - others, projects and individual work of students:
 
  • Creation and feture demonstration of database in a post-relational database system (used spatial, temporal, or deductive DBS)
Fundamental literature:
 
  • Kim, W. (etd.): Modern Database Systems, ACM Press, 1995, ISBN 0-201-59098-0
  • Gaede, V., Günther, O.: Multidimensional Access Methods
Study literature:
 
  • Lecture notes in eletronic form
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)
Progress assessment:
  
  • Mid-term exam, for which there is only one schedule and, thus, there is no possibility to have another trial - 20 points.
  • One project should be solved and delivered in a given date during a term - 20 points.
Exam prerequisites:
  Not designated.
 

Your IPv4 address: 54.196.208.187
Switch to https

DNSSEC [dnssec]