Подробное описание документа

Tishin N. R.
   Development and Implementation of a Geological Laboratory Test Data Storage System / Tishin N. R. // Наука, технологии и бизнес : материалы 6-ой Межвузовской конференции аспирантов, соискателей и молодых учёных, Москва, 16-18 апреля 2024 года / МГТУ им. Н. Э. Баумана (национальный исследовательский университет). - М., 2024. - С. 453-457.

The storage and organization of experimental results in the field of laboratory research is one of the critical issue that requires careful consideration. The article presents the development of a novel approach to address this issue, taking into account the specifics of subsequent data processing. The proposed approach treats laboratory experiments as structured data with unstructured components, which enables efficient storage and retrieval of the data. The development of the system involved a thorough analysis of the specifics of storing and processing laboratory experiments data. This analysis led to the formulation of basic system requirements, which were used to define the main data models and database entities. A standard relational data model was chosen for storing structured data, while the storage of unstructured information, such as experiments results or experiments parameters, was implemented through the BJSON field. To ensure secure access and provide an API for the system, the asynchronous FastAPI framework was selected. The implementation of storing additional experimental files, located in the object storage and associated with the experience in the relational model through an additional entity, was also considered. The proposed approach offers several advantages, including flexibility to the structure of stored laboratory experiments, consideration of the specifics of geological laboratory tests, and opportunities for complex meta-analysis of large amounts of data. The system was tested and implemented in the technological process of the geotechnical laboratory of JSC MOSTDORGEOTREST, demonstrating its effectiveness and practicality.