| Course Unit Code | 541-0059/01 |
|---|
| Number of ECTS Credits Allocated | 5 ECTS credits |
|---|
| Type of Course Unit * | Choice-compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Second Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| POR041 | Ing. 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 database form. 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 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 basic way of professional geoscience data storage in a computer environment - to describe the database systems. |
| Course Contents |
|---|
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.
|
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
| There is no mandatory literature in English. |
Homola, V.: Učební texty na školním serveru. Dostupné na http://homel.vsb.cz/~hom50. Web VŠB, Ostrava, 2007-2013.
Hernandez, M. J.: Návrh databází. ISBN 8024709007. Grada Publishing, Praha, 2006.
|
| Recommended Reading: |
|---|
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.
|
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Graded exercises evaluation | Graded credit | 100 | 51 |