Skip to main content
Skip header

Database Applications in Geology

* Exchange students do not have to consider this information when selecting suitable courses for an exchange stay.

Course Unit Code541-0003/05
Number of ECTS Credits Allocated4 ECTS credits
Type of Course Unit *Choice-compulsory type B
Level of Course Unit *Second Cycle
Year of Study *First Year
Semester when the Course Unit is deliveredWinter Semester
Mode of DeliveryFace-to-face
Language of InstructionCzech
Prerequisites and Co-Requisites There are no prerequisites or co-requisites for this course unit
Name of Lecturer(s)Personal IDName
POR041Ing. Michal Matloch Porzer, Ph.D.
Summary
The course introduces the basic way of professional geoscience data storage generally in a computer environment - with databases. In practice, it focuses only on the relational database as the currently most widely used format. It explains the data types in terms of computer forms, their ranges, and operations with them. It deals with the display options and ways to convert real-world geological data on these basic types of computer. An essential part of the course, there are query languages, particularly SQL. The practical part of the course takes place in a computer lab environment and database system to model the data representation of geological objects and their properties both descriptive and spatial.
Learning Outcomes of the Course Unit
To introduce the data organization in relational databases and give the basics of SQL query language.
Course Contents
1. Definition of basic concepts.
2. Introduction to graph theory.
3. Levels of data organization.
4. Data structure.
5. Structure of data storage.
6. Forms of data organization.
7. Data organization in database management systems.
8. Geological data and their specifics.
9.Spatial component of data.
10. Spatial component of data.
11. Query languages.
12. Introduction to SQL.
13. Select command.
Recommended or Required Reading
Required Reading:
DECKER, D.: GIS Data Sources. New York, Wiley, 2001.
HERNANDEZ, M. J.: Návrh databází. ISBN 8024709007. Grada Publishing, Praha, 2006.
MILLER, H. J. - HAN, J.: Geographic Data Mining and Knowledge Discovery . ISBN 203468023. Taylor & Francis, London, 2001.
PONNIAH, P.: Database Design and Development. John Wiley & Sons, London, 2003.
HOMOLA, V.: Učební texty na školním serveru. Dostupné na http://homel.vsb.cz/~hom50. Web VŠB, Ostrava, 2005-2013.
HERNANDEZ, M. J.: Návrh databází. ISBN 8024709007. Grada Publishing, Praha, 2006.
ČERNÝ, J.: Excel 2000, 2002, 2003, záznam úprava a programování maker, Grada 2004.
JACOBSON, R.: Microsoft Excel 2000/Visual Basic for Applications. Fundamentals. Microsoft Press, 1999.
Recommended Reading:
DECKER, D.: GIS Data Sources. New York, Wiley, 2001.
HERNANDEZ, M. J.: Návrh databází. ISBN 8024709007. Grada Publishing, Praha, 2006.
MILLER, H. J. - HAN, J.: Geographic Data Mining and Knowledge Discovery . ISBN 203468023. Taylor & Francis, London, 2001.
PONNIAH, P.: Database Design and Development. John Wiley & Sons, London, 2003.
OPPEL, A. J.: Databáze bez předchozích znalostí. ISBN 8025111997. Computer Press, Brno, 2006.
PÍSEK, S.: Databáze v Accessu. ISBN 8024705729. Grada Publishing, Praha, 2003.
DECKER, D.: GIS Data Sources. New York, Wiley, 2001.
HERNANDEZ, M. J.: Návrh databází. ISBN 8024709007. Grada Publishing, Praha, 2006.
Planned learning activities and teaching methods
Lectures, Tutorials
Assesment methods and criteria
Task TitleTask TypeMaximum Number of Points
(Act. for Subtasks)
Minimum Number of Points for Task Passing
Credit and ExaminationCredit and Examination100 (100)51
        CreditCredit33 17
        ExaminationExamination67 18