Terminated in academic year 2021/2022

Database Systems

Type of study	Follow-up MasterBachelor
Language of instruction	Czech
Code	548-0007/08
Abbreviation	DBS
Course title	Database Systems
Credits	6
Coordinating department	Department of Geoinformatics
Course coordinator	prof. Ing. Jiří Horák, Dr.

Subject syllabus

Reality modelling, data processing.
Advantages of DB technology.
Information system. Data types. DBS. DBMS.
3 layers of structure description.
Architecture of DBS. Internal forms of data storing.
Conceptual scheme. ERA diagram. Relationships. UML. Functional analysis, DFD.
Network data model, hierarchical data model. Relational data model. RDBMS.
Keys, referential integrity.Functional dependency. Normalisation process.
Querying. Relational algebra. SQL. QBE.
Object-oriented DBMS.
Protection of DBS. Parallel processes.
Data warehousing. OLAP, multidimensional DB. Trends.

Literature

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
Manolopoulos Y., Papadopoulos, Vassilakopoulos M.: Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1.
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

Ricardo C.M.: Database systems: principles, design, and implementation. Macmillan Publ.Comp. New York 1990.
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. .

back to search page