Spatial Database Systemy 1
| Type of study | Bachelor |
|---|---|
| Language of instruction | Czech |
| Code | 548-0128/01 |
| Abbreviation | PDBS1 |
| Course title | Spatial Database Systemy 1 |
| Credits | 6 |
| Coordinating department | Department of Geoinformatics |
| Course coordinator | prof. Ing. Jiří Horák, Dr. |
Subject syllabus
1) Reality modelling, data processing. Advantages of DB technology.
2) Information system. Classification of information systems.
3) Database system. DBMS and its role.
4) Conceptual scheme. ERA diagram. UML class diagram.
5) Review of data types. Internal forms of data storage.
6) Relational data model. RDBMS and requirements.
7) Keys, integrity constraints. Functional dependency. Normalisation process.
8) Querying in RDBMS. Relational algebra. SQL. QBE.
9) SQL. QBE.
10) Object-oriented DBMS. NoSQL databases
11) Concepts of storage spatial data in databases.
12) Spatial querying, spatial operators according to OGC.
13) Architecture of spatial DBS. Application of spatial databases
2) Information system. Classification of information systems.
3) Database system. DBMS and its role.
4) Conceptual scheme. ERA diagram. UML class diagram.
5) Review of data types. Internal forms of data storage.
6) Relational data model. RDBMS and requirements.
7) Keys, integrity constraints. Functional dependency. Normalisation process.
8) Querying in RDBMS. Relational algebra. SQL. QBE.
9) SQL. QBE.
10) Object-oriented DBMS. NoSQL databases
11) Concepts of storage spatial data in databases.
12) Spatial querying, spatial operators according to OGC.
13) Architecture of spatial DBS. Application of spatial databases
E-learning
Literature
Revesz, P. Introduction to Databases: From Biological to Spatio-Temporal. 2010. Springer; ISBN 1447125339 .
Churcher, Clare. Beginning Database Design. Berkeley, CA: Apress, 2007. ISBN 9781590597699.
Teorey T., Lightstone S., Nadeau T: Database modelling and design: Logical design. Elsevier. ISBN 978-0-12-685352-0
Yeung A.K.W, Hall G.B: Spatial Database Systems. Desing, Implementation and Project Management. Springer, Dordrecht, 2007. ISBN 10-1-4020-5393-2. 553 pages.
Churcher, Clare. Beginning Database Design. Berkeley, CA: Apress, 2007. ISBN 9781590597699.
Teorey T., Lightstone S., Nadeau T: Database modelling and design: Logical design. Elsevier. ISBN 978-0-12-685352-0
Yeung A.K.W, Hall G.B: Spatial Database Systems. Desing, Implementation and Project Management. Springer, Dordrecht, 2007. ISBN 10-1-4020-5393-2. 553 pages.
Advised literature
Manolopoulos Y., Papadopoulos, Vassilakopoulos M.: Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1.
Adam Nabil R., Gangopadhyay Aryya: Database Issues in Geographic Information Systems. Kluwer, 2.vydání, 1998.
Rigaux P., Scholl M., Voisard A.: Spatial Databases with Application to GIS. Kaufmann, San Francisco, 2002. ISBN 1-55860-588-6. 410 pages.
Rajaraman A., Ullman J., 2011. Mining of Massive Datasets. Cambridge University Press. ISBN 9781107015357 .
Adam Nabil R., Gangopadhyay Aryya: Database Issues in Geographic Information Systems. Kluwer, 2.vydání, 1998.
Rigaux P., Scholl M., Voisard A.: Spatial Databases with Application to GIS. Kaufmann, San Francisco, 2002. ISBN 1-55860-588-6. 410 pages.
Rajaraman A., Ullman J., 2011. Mining of Massive Datasets. Cambridge University Press. ISBN 9781107015357 .