Terminated in academic year 2022/2023

Database Applications in Geology

Type of study	Follow-up Master
Language of instruction	English
Code	541-0003/04
Abbreviation	DBvGeol
Course title	Database Applications in Geology
Credits	5
Coordinating department	Department of Geological Engineering
Course coordinator	Ing. Michal Matloch Porzer, Ph.D.

Subject syllabus

Lectures:

Definition of basic concepts.
Introduction to graph theory.
Levels of data organization.
Data structure.
Structure of data storage.
Forms of data organization.
Data organization in database management systems.
Geological data and their specifics.
Spatial component of data.
Query languages.
Introduction to SQL.
Select command.

Exercises:

Methods of data storage.
Computer representation of geological data.
File Types and relations between them.
Modes of work with the system: the dialogue and the program.
Database structure definition and its reorganization.
Filling the database file and updating the values.
Export of data in geoscientific applications.
Expressions and functions.
The basic output commands.
Commands for systematic data handling.
Interactive screen format.
Interactive output report.
Setting the parameters of the database environment.
Comprehensive display of geological database model.

Literature

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.

Advised literature

back to search page