Database for Monitoring the Technical Condition of Structures as an Integral Part of Industrial Safety
DOI:
https://doi.org/10.15802/stp2024/302553Keywords:
database, information systems, exploitation of structures, technical condition monitoring, technical condition assessment, industrial safetyAbstract
Purpose. Development of a database designed to systematization and store information on the technical condition of industrial structures based on the results of periodic visual and instrumental surveys. Methodology. The information system includes a database, a database management system and an application programme. The most appropriate type of database for monitoring the technical condition of structures is a relational structure. The database model covers owners, buildings, structures, quantitative and qualitative parameters of defects and damage, strength indicators of building structures and tilt of industrial structures. Findings. Structural query language was used in the process of developing a database for monitoring the technical condition of industrial facilities. The created database "Monitoring" includes interconnected tables that provide holistic and efficient storage of information. The tables are linked using foreign keys, which provides easy access and data management. The tables are conditionally divided into those that users fill in and those that are filled in in accordance with legislative and regulatory documents at the stage of database creation. This approach to building a database ensures structured storage of information on the technical condition of buildings, taking into account regulations and legislation. The integration of tables filling in by users and pre-filled tables creates a system that increases the efficiency of monitoring the technical condition of industrial structures. Originality. The scientific novelty of the proposed database lies in an innovative approach to structuring and integrating various types of data related to the technical condition of industrial structures. The system offers an effective combination of data from different formats and sources into a single information space and will further provide a comprehensive analysis of the condition of building structures, which is one of the key factors of industrial safety. Practical value. It is intended to improve the efficiency of industrial structures maintenance and exploitation safety, and provides tools for storing the results of monitoring the condition of building structures.
References
Systema zabezpechennia nadiinosti ta bezpeky budivelnykh obiektiv. Navantazhennia i vplyvy. Normy proektuvannia. Zi Zminoiu No 1, 77 DBN V.1.2-2:2006 (2006). (in Ukrainian)
Systema zabezpechennia nadiinosti ta bezpeky budivelnykh obiektiv. Zahalni pryntsypy zabezpechennia nadiinosti ta konstruktyvnoi bezpeky budivel i sporud. Zi Zminoiu No 1,30 DBN V.1.2-14:2018 (2018). (in Ukrainian)
Zakhyst vid nebezpechnykh heolohichnykh protsesiv, shkidlyvykh ekspluatatsiinykh vplyviv, vid pozhezhi. Budivelna klimatolohiia,127 DSTU-N B V.1.1-27:2010. (2011). (in Ukrainian)
Informatsiini tekhnolohii. Slovnyk terminiv,464 DSTU ISO/IEC 2382-15:2017 (ISO/IEC 2382:2015, IDT). (2017). (in Ukrainian)
Klasyfikator budivel i sporud, 17 NK 018:2023 (2023). (in Ukrainian)
Popruga, D. V., & Valovoi, O. I. (2013). Problems of monitoring the technical condition of buildings and structures. Visnyk Kryvori-zjkogho nacionaljnogho universytetu, 34, 186-190. (in Ukrainian)
Pro zatverdzhennia formy pasporta obiekta budivnytstva. Ministerstvo rehionalnoho rozvytku, budivnytstva ta zhytlovo-komunalnoho hospodarstva Ukrainy. Retrieved from https://zakon.rada.gov.ua/laws/show/z1460-17#Text (in Ukrainian)
Tsyvilnyi kodeks Ukrainy. Kyiv. Retrieved from http://zakon2.rada.gov.ua/laws/show/435-15 (in Ukrainian)
Li, X., Xie, L., Lu, W., Xue, S., Hong, C., Lan, W., & Shi, Q. (2023). Structural health monitoring of a historic building during uplifting process: system design and data analysis. Structural Health Monitoring, 22(5), 3165-3188. DOI: https://doi.org/10.1177/14759217221135351 (in English)
Nielsen, J. S. (2021). Value of information of structural health monitoring with temporally dependent observations. Structural Health Monitoring, 21(1), 165-184. DOI: https://doi.org/10.1177/14759217211030605 (in English)
Zhu, Y.-F., Ren, W.-X., & Wang, Y.-F. (2022). Structural health monitoring on Yangluo Yangtze River Bridge: Implementation and demonstration. Advances in Structural Engineering, 25(7), 1431-1448. DOI: https://doi.org/10.1177/13694332211069508 (in English)
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2024 Science and Transport Progress
This work is licensed under a Creative Commons Attribution 4.0 International License.
Copyright and Licensing
This journal provides open access to all of its content.
As such, copyright for articles published in this journal is retained by the authors, under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0). The CC BY license permits commercial and non-commercial reuse. Such access is associated with increased readership and increased citation of an author's work. For more information on this approach, see the Public Knowledge Project, the Directory of Open Access Journals, or the Budapest Open Access Initiative.
The CC BY 4.0 license allows users to copy, distribute and adapt the work in any way, provided that they properly point to the author. Therefore, the editorial board of the journal does not prevent from placing published materials in third-party repositories. In order to protect manuscripts from misappropriation by unscrupulous authors, reference should be made to the original version of the work.
