541-0003/01 – Database Applications in Geology (DBvGeol)

Gurantor departmentDepartment of Geological EngineeringCredits5
Subject guarantorIng. Michal Matloch Porzer, Ph.D.Subject version guarantorDoc. PaedDr. Vladimír Homola, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year2Semesterwinter
Study languageCzech
Year of introduction2004/2005Year of cancellation2009/2010
Intended for the facultiesHGFIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
HOM50 Doc. PaedDr. Vladimír Homola, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2

Subject aims expressed by acquired skills and competences

To introduce the data organization in relational databases and give the basics of SQL query language.

Teaching methods

Lectures
Tutorials

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.

Compulsory 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.

Recommended 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.

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Přednášky: Definice základních pojmů. Úvod do teorie grafů. Úrovně organizace dat. Struktura dat. Struktura uložení. Formy organizace dat. Organizace dat v systémech řízení báze dat. Geologická data a jejich specifika. Prostorová složka dat. Dotazovací jazyky. Úvod do SQL. Příkaz Select. Cvičení: Způsoby uložení dat, počítačová reprezentace geologickcýh dat. Typy souborů a vazby mezi nimi. Režimy práce se systémem; dialog a program. Definice struktury databázového souboru a její změna. Naplnění databázového souboru a změny hodnot. Export dat do geovědních aplikací. Výrazy a funkce. Základní výstupní příkazy. Příkazy pro hromadnou manipulaci s daty. Interaktivní tvorba formátu obrazovky. Interaktivní tvorba výstupní sestavy. Nastavení parametrů databázového prostředí. Komplexní ukázka geologického databázového modelu.

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)		Min. number of pointsMax. počet pokusů
Exercises evaluation and Examination Credit and Examination 100 (100) 51 3
        Exercises evaluation Credit 33 (33) 0 3
                Other task type Other task type 33  0 3
        Examination Examination 67 (67) 0 3
                Oral Oral examination 67  0 3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2006/2007 (N2110) Geological Engineering (2101T003) Geological Engineering (00) Geologické inženýrství P Czech Ostrava 2 Choice-compulsory study plan
2005/2006 (N2110) Geological Engineering (2101T003) Geological Engineering (00) Geologické inženýrství P Czech Ostrava 2 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.