SubjectsSubjects(version: 837)
Course, academic year 2018/2019
   Login via CAS
Non-traditional Database Models, Architectures and Languages - NDBI033
Title in English: Netradiční databázové modely, architektury a jazyky
Guaranteed by: Department of Software Engineering (32-KSI)
Faculty: Faculty of Mathematics and Physics
Actual: from 2013
Semester: winter
E-Credits: 3
Hours per week, examination: winter s.:2/0 Ex [hours/week]
Capacity: unlimited
Min. number of students: unlimited
State of the course: taught
Language: Czech
Teaching methods: full-time
Guarantor: prof. RNDr. Jaroslav Pokorný, CSc.
Class: DS, softwarové systémy
Informatika Mgr. - Softwarové systémy
Classification: Informatics > Database Systems
Annotation -
Last update: T_KSI (09.03.2007)
Current relational database systems are not suitable for multidimensional data, XML data, data streams obtained from sensors or a large amount of on-line transactions, spatial data, etc. The goal of the course is to present new database models and architectures, which enables to process mentioned data in a database way.
Aim of the course - Czech
Last update: prof. RNDr. Jaroslav Pokorný, CSc. (02.10.2017)

Předmět je určen pro PhD studenty a je vyučován samostudiem na základě materiálů dodaných

vyučujícím. Zkouška je písemná a ústní.

Course completion requirements -
Last update: prof. RNDr. Jaroslav Pokorný, CSc. (02.10.2017)

The course is designed for PhD students and is taught by self-study based on materials delivered

teachers. The exam is written and oral.

Literature - Czech
Last update: T_KSI (19.02.2007)

1. Abraham Silbershatz, Henry F. Korth and S. Sudarshan: Database System Concepts Edition 5, McGraw Hill, 2005.

2. E. Thomsen: OLAP Solutions: Building Multidimensional Information Systems. 2nd Ed., Wiley, 2002.

3. P. Rigaux, M. Scholl, and A. Voisard Spatial Databases: With Application to GIS.The Morgan Kaufmann Series in Data Management Systems, Morgan Kaufmann, 2001.

4. N. Chaudhry, K. Shaw, M. Abdelguerfi (Eds): Stream Data Management (Advances in Database Systems). 1 ed., Springer; 2006.

Requirements to the exam - Czech
Last update: prof. RNDr. Jaroslav Pokorný, CSc. (02.10.2017)

Předmět je určen pro PhD studenty a je vyučován samostudiem na základě materiálů dodaných

vyučujícím. Zkouška je písemná a ústní.

Syllabus -
Last update: T_KSI (09.03.2007)

1. Why more databases models? Example: from relations in the 1NF to tables with structured values. Application requirements: hierarchies, recursion, spatial data models for OLAP, data streams, etc.

2. Object-relational model: departure from 1NF relations, models standardization in SQL:1999 and SQL:2003. Type system, definition of object-relational databases.

3. Object-relational model: querying over an object-relational database.

4. Data warehouses and OLAP: multidimensional models, star schemas. Conceptual modeling.

5. Data warehouses and OLAP: query languages over a multidimensional model, data warehouses implementation. SQL extensions for OLAP support.

6. Model of semistructured data and their support in SQL standards: texts, still images.

7. Model for spatial databases: basic features of OpenGIS and their application in the standard SpatialSQL

8. Model for spatial databases: querying over spatial objects.

9. Temporal databases: extension of relational database by time dimension. An extension attempt of SQL to time.

10. Temporal databases: querying over a temporal database. The notion of space-time databases.

11. Hierarchical and graph database structures. Recursion in SQL.

12. Semistructured data and their models. Example: XML standard.

13. Querying over XML data.

14. New database architectures. Example: Data streams management systems.

Charles University | Information system of Charles University |