Infopaket

Development of Database for Geological Research

OC 8

Вибіркова дисципліна для ОП

Second

2021/2022

3 Semester

6

To know basic data organization models, the main stages of database development, data Integrity Concept, data normalization principles and normal forms, basic SQL Operator Syntax, to be able to formalize data to organize it in a table, to create basic tables and queries when solving tasks, to create key fields and organize relationships between tables, to use database management systems and geographic information systems to enter and use data, including geodata.

Distance form

Basic skills in GIS and Programming.

The geologic database is a special organization of data and contains the evidence needed to make many strategic decisions, including the primary data used to estimate resources and reserves. Building and maintaining a good geological database requires careful planning. Geologists, exploration managers, or database administrators are responsible for collecting large amounts of data that will help improve productivity and efficiency. The course introduces the basics of designing geodatabase structures, the principles of optimization and testing. Students acquire practical skills in maintaining and validating geological databases to ensure their physical and logical integrity, for further data analysis. Familiarity with building geodatabases in GIS by using Python.

1. Coronel C., Morris S., (2018), Database Systems: Design, Implementation, & Management 13th Edition: Cengage Learning, 816 p. ISBN-10: 1337627909. 2. Kroenk D., Auer D., Vandenberg S., Yoder R., (2019), Database Concepts 9th Edition: Pearson, 552 p. 3. Rigaux P., Scholl M., Voisard A., (2001), Spatial Databases: With Application to GIS 1th Edition: Morgan Kaufmann, 410 p. 4. Beaulieu A., (2020), Learning SQL: Generate, Manipulate, and Retrieve Data 3rd Edition: O’Reilly, 384 p. ISBN-13: 978-1492057611. 5. Hsu Leo S., Obe Regina O., (2021), PostGIS in Action, Third Edition, Manning, 600 p. 6. David W. Allen, (2019), Focus on Geodatabases in ArcGIS Pro 1st Edition: Esri Press, 260 p. ISBN-13: 978-1589484450 7. Frank T., Hayes M., Hayes L., (2021), Sediment Database and Geochemical Assessment of Lake Pontchartrain Basin, [url] https://pubs.usgs.gov/pp/p1634j/index.htm#contents

Lectures, practical classes, consultations, self-work. Teaching methods are explanatory-illustrative, research, part-search and heuristic.

Control is carried out according to the modular rating system and provides for: passing 5 practical classes (where students must demonstrate the quality of the acquired knowledge and solve the tasks set using the methods outlined by the teacher) and solving the tasks without limiting the tools and techniques of solving the problem) and passed 2 written tests. The final grading is carried out in the form of a written Exam. Scheme of grading 1. Semester grading: 1) Module 1 - 10 points (passing grade is 6 points) 2) Module 2 - 10 points (passing grade is 6 points) 3) Grading for work at practical classes - 40 points (passing grade is 24 points) 2. Final examination in the form of the written test: maximum grade is 40 points, and the passing grade is 24 points. Results of educational activity of students grading are based on a 100 grading scale.

English