Development of the structure and creation of a database of the Geological Museum of the Taras Shevchenko National University of Kyiv

3d Modelling & Visualization for Geology & Mining

Authors

First and Last Name	Academic degree	E-mail	Affiliation
Zhurakovsky Dmytro	No	zhurakovsky.dima [at] gmail.com	Taras Shevchenko National University of Kyiv Brovary, Ukraine
Hryhorii Ostapenko	No	grishakelvin [at] gmail.com	Taras Shevchenko National University of Kyiv Kremenchuk, Ukraine
Mykola Shyts	No	m.shyts [at] campus.uniurb.it	Taras Shevchenko National University of Kyiv Novovolynsk, Ukraine
Daniil Tovstonog	No	d.tovstonoh [at] campus.uniurb.it	Taras Shevchenko National University of Kyiv Chernihiv, Ukraine
Anzhelina Mienasova	Ph.D.	mangelina [at] ukr.net	Taras Shevchenko National University of Kyiv Kyiv, Ukraine

I and my co-authors (if any) authorize the use of the Paper in accordance with the Creative Commons CC BY license

First published on this website: 24.08.2023 - 18:11

Abstract

This article presents a comprehensive study on the development of a geological museum database at the Kyiv National University, aimed at digitizing and managing information about mineral exhibits. As the global geological data registration continues to increase, digitalization becomes crucial for efficient data management. The paper outlines a systematic approach, including website development, data storage methodologies, and automation tools. The chosen "Materialized Path" algorithm for structured data storage in relational databases and the JSON approach in MongoDB are highlighted for their efficiency. The integration of Flask framework, Python programming, and Telegram application supports the creation of a user-friendly website and tools. The results showcase the successful implementation of the database, which enables staff to manage and update exhibit details, news, and event information. The paper underscores the potential for wider accessibility, collaboration, and preservation of geological data, contributing to the advancement of earth sciences. Despite resource limitations, this project signifies a pivotal step in digitalizing geological museums and promoting geological heritage understanding.

Keywords

References

Bougie, R., & Sekaran, U. (2019). Research methods for business: A skill building approach.

Dinyak, O. V., & Koshlyakova, I. E. (2013). Use of geo-informational databases for optimization of engineering and geological research in urbanized areas. Bulletin of Odessa National University. Geographical and geological sciences, 18(1 (17)), 96-101. (in Ukrainian)

Gard, M., Hasterok, D., & Halpin, J. A. (2019). Global whole-rock geochemical database compilation. Earth System Science Data, 11(4), 1553-1566.

Jeovano, J. (2020). 2D Data Visualization Tools Menggunakan Flask dan AngularJS. INSYST: Journal of Intelligent System and Computation, 2(2), 91-97.

Ostapenko, H., Zatserkovnyi, V., & de Donatis, M. (2022, November). Analysis of the Correlation between Lineaments and Earthquake Epicenters in the Marche Region (Italy) Using Remote Sensing Tools. In 16th International Conference Monitoring of Geological Processes and Ecological Condition of the Environment (Vol. 2022, No. 1, pp. 1-5). European Association of Geoscientists & Engineers.

Zhu, B. (2017). SubtiWiki 3.0: A Relational Database for the Functional Genome Annotation of the Model Organism (Bacillus Subtilis) (Doctoral dissertation, Georg-August-Universität Göttingen).

Zidianakis, E., Partarakis, N., Ntoa, S., Dimopoulos, A., Kopidaki, S., Ntagianta, A., ... & Stephanidis, C. (2021). The invisible museum: A user-centric platform for creating virtual 3D exhibitions with VR support. Electronics, 10(3), 363.