Skip to main content
Skip header
Close

Searching

Database Systems

Database Systems
548-0007/01
čeština Database Systems
548-0007/02
čeština Database Systems
548-0007/04
čeština Database Systems
548-0007/05
čeština Database Systems
548-0007/03
čeština Database Systems
548-0007/06
čeština Database Systems
548-0007/07
čeština Database Systems
548-0007/08
čeština Database Systems
548-0007/09
angličtina Database Systems
548-0007/10
čeština

Summary

Information system. Data types. DBS. DBMS. 3 layers of structure description.
Advantages of DB technology. 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. Protection of DBS. Parallel
processes. DBS and IS construction. OO databases. Data warehousing. OLAP,
multidimensional DB.

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


back to search page
Language of instruction čeština, čeština, čeština, čeština, čeština, čeština, čeština, čeština, angličtina, čeština
Code 548-0007
Abbreviation DBS
Course title Database Systems
Coordinating department Department of Geoinformatics
Course coordinator prof. Ing. Jiří Horák, Dr.