Z3104 Geodatabases

Faculty of Science
Autumn 2012
Extent and Intensity
1/2. 3 credit(s). Type of Completion: graded credit.
Teacher(s)
Mgr. Karel Staněk, Ph.D. (lecturer)
Mgr. Radka Báčová, Ph.D., MPA (seminar tutor)
Mgr. Hana Dvořáková (seminar tutor)
Mgr. et Mgr. Tereza Gimunová (seminar tutor)
Mgr. Helena Řezníková (seminar tutor)
Mgr. Vilém Walter (seminar tutor)
Ing. Lucie Homolová (assistant)
Guaranteed by
prof. RNDr. Rudolf Brázdil, DrSc.
Department of Geography – Earth Sciences Section – Faculty of Science
Contact Person: Mgr. Karel Staněk, Ph.D.
Supplier department: Department of Geography – Earth Sciences Section – Faculty of Science
Timetable
Mon 17:00–17:50 A,01026
  • Timetable of Seminar Groups:
Z3104/01: Thu 18:00–19:50 Z1,01001b, T. Gimunová
Z3104/02: Wed 14:00–15:50 Z1,01001b, R. Báčová
Z3104/03: Thu 14:00–15:50 Z1,01001b, H. Řezníková
Z3104/04: Thu 8:00–9:50 Z1,01001b, H. Dvořáková
Z3104/05: Mon 8:00–9:50 Z1,01001b, T. Gimunová, V. Walter
Z3104/06: Mon 10:00–11:50 Z1,01001b, T. Gimunová, V. Walter
Prerequisites (in Czech)
( Z0262 Geoinformatics && ! Z8104 Geoinformation technologies 1 ) || Z0062 Cartography and Geoinformatics
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.
fields of study / plans the course is directly associated with
there are 6 fields of study the course is directly associated with, display
Course objectives
The main objectives of the course are the following: acquainting students with the database basic with respect to their role in GIS. students acquire query and definition language SQL in relational and post-relational databases making students aware of manipulation with spatial data in above mentioned databases making students aware of document oriented databases
Syllabus
  • 1. Base database models 2. Principles of realtional and postrelational DBMS 3. Relational database design (Chen diagram, data types, keys, normální formy) 4. Definition part of SQL 5. Query part of SQL - introduction 6. Query part of SQL - functions and aggregates 7. Query part of SQL - theta join 8. Object databases 9. Document oriented databases 10. Document oriented databases query languages 11. Spatial data in databases 12. DBMS engines 13. Standards and metadata Exercises 1. Database creation and management 2. Database definition 3. INSERT command 4. UPDATE, Constrains a ALTER TABLE 5. Base of querrying SQL 6. GROUP BY and Aggregating functions 7. Selections from multiple tables I. 8. elections from multiple tables II. 9. Nested queries 10. Database design
Literature
  • POKORNY, Jaroslav. Konstrukce databázových systémů. Praha: Vydavatelství ČVUT, 1999, 166 pp. ISBN 80-01-01935-7. info
  • LAURINI, Robert and Derek THOMPSON. Fundamentals of spatial information systems. San Diego: Academic Press, 1998, xxiii, 680. ISBN 0124383807. info
Teaching methods
lectures and practical exercises
Assessment methods
final written exam
Language of instruction
Czech
Further comments (probably available only in Czech)
Study Materials
The course is taught annually.
The course is also listed under the following terms Autumn 2007 - for the purpose of the accreditation, Autumn 2010 - only for the accreditation, Spring 2003, Autumn 2003, Autumn 2004, Autumn 2005, Autumn 2007, Autumn 2008, Autumn 2009, Autumn 2010, Autumn 2011, Autumn 2011 - acreditation, Autumn 2013, Autumn 2014, Autumn 2015, Autumn 2016, autumn 2017, Autumn 2018, Autumn 2019, Autumn 2020, autumn 2021, Autumn 2022, Autumn 2023, Autumn 2024.
  • Enrolment Statistics (Autumn 2012, recent)
  • Permalink: https://is.muni.cz/course/sci/autumn2012/Z3104