Spatial Database Systemy 1

Type of study	Bachelor
Language of instruction	English
Code	548-0128/02
Abbreviation	PDBS1
Course title	Spatial Database Systemy 1
Credits	6
Coordinating department	Department of Geoinformatics
Course coordinator	prof. Ing. Jiří Horák, Dr.

Osnova předmětu

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

Povinná literatura

Revesz, P. Introduction to Databases: From Biological to Spatio-Temporal. 2010. Springer; .
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.

Doporučená literatura

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. .

zpět na vyhledávání