541-0059/01 – Database Application in Geosciences (DBvGeoV)

Gurantor departmentDepartment of Geological EngineeringCredits5
Subject guarantorIng. Michal Matloch Porzer, Ph.D.Subject version guarantorIng. Michal Matloch Porzer, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year2Semestersummer
Study languageCzech
Year of introduction2007/2008Year of cancellation2022/2023
Intended for the facultiesHGFIntended for study typesFollow-up Master, Master, Bachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
POR041 Ing. Michal Matloch Porzer, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 2+2
Part-time Graded credit 6+6

Subject aims expressed by acquired skills and competences

To introduce the basic way of professional geoscience data storage in a computer environment - to describe the database systems.

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

Compulsory literature:

There is no mandatory literature in English.

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

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

The student will create a final database according to specifications.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

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.

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester, validity until: 2011/2012 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Graded exercises evaluation Graded credit 100 (100) 0 3
        Other task type Other task type 100  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
2022/2023 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Choice-compulsory study plan
2021/2022 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Choice-compulsory study plan
2020/2021 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Choice-compulsory study plan
2020/2021 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Choice-compulsory study plan
2019/2020 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Choice-compulsory study plan
2019/2020 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Choice-compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Choice-compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Choice-compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Choice-compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Choice-compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Choice-compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Choice-compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Choice-compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Choice-compulsory study plan
2014/2015 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Compulsory study plan
2014/2015 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Compulsory study plan
2013/2014 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Compulsory study plan
2013/2014 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Compulsory study plan
2012/2013 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Compulsory study plan
2012/2013 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Compulsory study plan
2011/2012 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Compulsory study plan
2011/2012 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Compulsory study plan
2008/2009 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering K Czech Ostrava 2 Compulsory study plan
2008/2009 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 2 Compulsory study plan
2008/2009 (B2102) Mineral Raw Materials (3904R005) Environmental Engineering P Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2015/2016 Summer
2014/2015 Summer
2012/2013 Summer
2011/2012 Summer
2010/2011 Summer
2009/2010 Summer