Skip to main content
Skip header
Terminated in academic year 2022/2023

Database Application in Geosciences

Type of study Follow-up MasterMasterBachelor
Language of instruction Czech
Code 541-0059/01
Abbreviation DBvGeoV
Course title Database Application in Geosciences
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

There is no mandatory literature in English.

Advised literature

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.