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

Gurantor departmentDepartment of Geological EngineeringCredits4
Subject guarantorIng. Michal Matloch Porzer, Ph.D.Subject version guarantorIng. Michal Matloch Porzer, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory type B
Year1Semesterwinter
Study languageCzech
Year of introduction2019/2020Year of cancellation
Intended for the facultiesHGFIntended for study typesFollow-up Master
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 Credit and Examination 2+2
Part-time Credit and Examination 8+8

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

Vytvoření závěrečné databáze podle zadání vyučujícího. Ústní zkouška.

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:

1. Definition of basic concepts. 2. Introduction to graph theory. 3. Levels of data organization. 4. Data structure. 5. Structure of data storage. 6. Forms of data organization. 7. Data organization in database management systems. 8. Geological data and their specifics. 9.Spatial component of data. 10. Spatial component of data. 11. Query languages. 12. Introduction to SQL. 13. Select command.

Conditions for subject completion

Full-time form (validity from: 2019/2020 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)		Min. number of pointsMax. počet pokusů
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 33  17
        Examination Examination 67  18 3
Mandatory attendence participation: Attendance on 70% of seminars during the semester.

Show history

Conditions for subject completion and attendance at the exercises within ISP: Student will gain seminar credit by completing a project according to specifications given by his lecturer. The project has to be completed before the start of the exam period. Attendance on seminars isn't compulsory. Student will be preparing for the exam individually by studying materials given by the lecturer. The exam has to be attended in person on a regular exam term given by the lecturer.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2024/2025 (N0724A290003) Petroleum Engineering P Czech Ostrava 1 Choice-compulsory type B study plan
2024/2025 (N0724A290003) Petroleum Engineering K Czech Ostrava 1 Choice-compulsory type B study plan
2023/2024 (N0724A290003) Petroleum Engineering K Czech Ostrava 1 Choice-compulsory type B study plan
2023/2024 (N0724A290003) Petroleum Engineering P Czech Ostrava 1 Choice-compulsory type B study plan
2022/2023 (N0724A290003) Petroleum Engineering P Czech Ostrava 1 Choice-compulsory type B study plan
2022/2023 (N0724A290003) Petroleum Engineering K Czech Ostrava 1 Choice-compulsory type B study plan
2021/2022 (N0724A290003) Petroleum Engineering K Czech Ostrava 1 Choice-compulsory type B study plan
2021/2022 (N0724A290003) Petroleum Engineering P Czech Ostrava 1 Choice-compulsory type B study plan
2020/2021 (N0724A290003) Petroleum Engineering K Czech Ostrava 1 Choice-compulsory type B study plan
2020/2021 (N0724A290003) Petroleum Engineering P Czech Ostrava 1 Choice-compulsory type B 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í.