|
|
|
||
Last update: T_KSI (09.03.2007)
|
|
||
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í. |
|
||
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. |
|
||
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. |
|
||
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í. |
|
||
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. |