Система комплексного хранения данных геологических лабораторных испытаний
Работая с нашим сайтом, вы даете свое согласие на использование файлов cookie. Это необходимо для нормального функционирования сайта, показа целевой рекламы и анализа трафика. Статистика использования сайта отправляется в «Яндекс» и «Google»
Научный журнал Моделирование, оптимизация и информационные технологииThe scientific journal Modeling, Optimization and Information Technology
Online media
issn 2310-6018

Integrated data storage system for geological laboratory experiments

idTishin N.R. Ozmidov O.R.   idProletarsky A.V.

UDC 004.9+624.131.37
DOI: 10.26102/2310-6018/2024.44.1.007

  • Abstract
  • List of references
  • About authors

The article examines the development of a new approach to storing and organizing the results of laboratory experiments with consideration to the features of their subsequent processing. To solve this problem, laboratory experiments are considered as structured data with unstructured parts. During the development of the system, the features of storing and processing laboratory test data were analyzed, after which the basic requirements for the system were formulated. The main data models were defined as well as the database entities. A standard relational data model has been chosen for storing structured data, and the storage of unstructured information such as experiment results or experiment parameters is implemented through the BJSON field. To solve the problem of providing secure access and creating an API for the system, the asynchronous FastAPI framework was chosen. The implementation of storing additional experiment files, which are located in the object storage and are associated with the experiment in the relational model through an additional entity, is also considered. The presented approach is notable for its flexibility to the structure of stored laboratory experiments, takes into account the features of geological laboratory experiments and also provides opportunities for complex meta-analysis of large volume of data. The system was tested and implemented into the technological process of the geotechnical laboratory at JSC MOSTDORGEOTREST.

Tishin Nikita Romanovich

Email: tnick1502@mail.ru

ORCID | eLibrary |

Bauman Moscow State University
JSC MOSTDORGEOTREST

Moskow, the Russian Federation

Ozmidov Oleg Rostislavovich
Candidate of Geological and Mineralogical Sciences Academician of the Russian Academy of Natural Sciences
Email: ozmidov@mail.ru

JSC MOSTDORGEOTREST

Moscow, the Russian Federation

Proletarsky Andrey Viktorovich
Doctor of Engineering Sciences Professor

ORCID |

Bauman Moscow State Technical University

Moscow, the Russian Federation

Keywords: storage of geological laboratory experiment data, unstructured data, experiment results storage system, geoinformation system, database, geological environment, information resource, engineering geology

For citation: Tishin N.R. Ozmidov O.R. Proletarsky A.V. Integrated data storage system for geological laboratory experiments. Modeling, Optimization and Information Technology. 2024;12(1). Available from: https://moitvivt.ru/ru/journal/pdf?id=1495 DOI: 10.26102/2310-6018/2024.44.1.007 (In Russ).

61

Full text in PDF

Received 22.12.2023

Revised 22.01.2024

Accepted 31.01.2024

Published 01.02.2024