Concept of unification of mutually incompatible information models and data stored in relational databases of road administrations

• Autorzy: Pospisil Karel , Janku Michal , Stryk Josef , Pospisil Vitezslav , Pospisilova Dagmar

Identyfikatory

DOI

10.7409/rabdim.024.003

Warianty tytułu

PL

Koncepcja ujednolicenia wzajemnie niekompatybilnych modeli informacyjnych oraz danych przechowywanych w relacyjnych bazach danych zarządców dróg

• Języki publikacji: EN PL

Abstrakty

EN

Road Administrations (RAs) implement Building Information Modelling (BIM) through pilot projects developed for new or reconstructed structures. Each model is processed with respect to BIM standards and practices valid at the time of its creation. Consequently, models are incompatible and cannot be interconnected to create a combined model of the managed network or even its selected parts. Existing structures are often not included in the BIM effort until some major repair is planned. In addition, RAs usually store data on fixed and variable parameters of structures in relational databases. This results in a situation in which a relatively small number of structures are included in mutually incompatible models and data regarding the majority of structures is contained in relational databases. It creates a heterogeneous data environment for RAs. The goals of the paper are as follows: to analyse the described problem, to propose a method of model unification models, a method of creation of simplified compatible information models using data on existing structures stored in relational databases and a method of storing data at the level of the managed network, to support RA asset management systems which can be treated as a dynamic part of BIM.

PL

Zarządcy dróg wprowadzają rozwiązania BIM (modelowanie informacji o budowli) w programach pilotażowych dotyczących nowo budowanych oraz przebudowywanych odcinków dróg. Każdy z takich modeli jest przetwarzany zgodnie z normami i praktykami BIM obowiązującymi w momencie jego powstania. W związku z tym uzyskane modele są niekompatybilne i nie mogą być połączone w większy model sieci drogowej czy nawet jej wybranych części. Istniejące konstrukcje często nie są w ogóle brane pod uwagę w BIM, dopóki nie zostanie zaplanowana ich przebudowa. Ponadto zarządcy dróg zwykle przechowują dane jako stałe i zmienne wartości parametrów obiektu w relacyjnych bazach danych. W zaistniałej sytuacji stosunkowo niewielka liczba obiektów jest opisana we wzajemnie niekompatybilnych modelach, a dane większości obiektów znajdują się w relacyjnych bazach danych. Zarządcy dróg funkcjonują więc w heterogenicznych środowiskach informatycznych. Celem niniejszej pracy jest analiza opisanego problemu oraz przedstawienie proponowanych metod: metody ujednolicenia modeli, metody tworzenia kompatybilnych uproszczonych modeli informacyjnych z wykorzystaniem informacji już przechowywanych w relacyjnych bazach danych, jak również metody przechowywania danych na poziomie zarządzanej sieci drogowej celem wsparcia zarządców dróg i potraktowania ich systemów zarządzania zasobami jako dynamicznej części BIM.

Słowa kluczowe

EN

asset management system; BIM; BMS; PMS; relational database; road network model

PL

BIM; BMS; model sieci drogowej; PMS; relacyjna baza danych; system zarządzania zasobami

• Wydawca: Instytut Badawczy Dróg i Mostów
• Czasopismo: Roads and Bridges - Drogi i Mosty
• Rocznik: 2024
• Tom: Vol. 23, no. 1
• Strony: 45--72
• Opis fizyczny: Bibliogr. 43 poz., rys., tab.

Twórcy

autor

Pospisil Karel

• Brno University of Technology, Institute of Forensic Engineering, 118 Purkynova St., Brno, 61200

autor

Janku Michal

• Transport Research Centre (CDV), 33a Lisenska St., Brno, 63600

autor

Stryk Josef

• Transport Research Centre (CDV), 33a Lisenska St., Brno, 63600

autor

Pospisil Vitezslav

• Janeway, Limited Liability Company, 79 Kainarova St., Brno, 61600

autor

Pospisilova Dagmar

• Transport Research Centre (CDV), 33a Lisenska St., Brno, 63600

Bibliografia

• 1. Borrmann A., Konig M., Koch C., Beetz J.: Building Information Modeling: Why? What? How? In: Borrmann A., Konig M., Koch C., Beetz J. (Eds.): Building Information Modeling, Springer, Cham, 2018, 1-24, DOI: 10.1007/978-3-319-92862-3_1
• 2. Wang J., Zhang S., Fenn P., Luo X., Liu Y., Zhao L.: Adopting BIM to facilitate dispute management in the construction industry: A conceptual framework development. Journal of Construction Engineering and Management, 149, 1, 2023, ID article: 03122010, DOI: 10.1061/(ASCE)CO.1943-7862.0002419
• 3. Eneyew D.D., Capretz M.A.M., Bitsuamlak G.T.: Toward Smart-Building Digital Twins: BIM and IoT Data Integration. IEEE Access, 10, 2022, 130487-130506, DOI: 10.1109/ACCESS.2022.3229370
• 4. Lu Q., Xie X., Heaton J., Parlikad A.K., Schooling J.: From BIM Towards Digital Twin: Strategy and Future Development for Smart Asset Management. In: Borangiu T., Trentesaux D., Leiăto P., Giret Boggino A., Botti V. (Eds.): Service Oriented, Holonic and Multi-agent Manufacturing Systems for Industry of the Future, Springer, Cham, 2020, 392-404, DOI: 10.1007/978-3-030-27477-1_30
• 5. Wernerova E., Endel S., Kuta D.: Implementation of the BIM Method at the VSB – Technical University of Ostrava. International Journal of Engineering Research in Africa, 47, 2020, 133-138, DOI: 10.4028/www.scientific.net/JERA.47.133
• 6. Munir M., Kiviniemi A., Finnegan S., Jones S.W.: BIM business value for asset owners through effective asset information management. Facilities, 38, 3/4, 2020, 181-200, DOI: 10.1108/F-03-2019-0036
• 7. Farghaly K., Abanda F.H., Vidalakis C., Wood G.: Taxonomy for BIM and Asset Management Semantic Interoperability. Journal of Management in Engineering, 34, 4, 2018, DOI: 10.1061/(ASCE)ME.1943-5479.0000610
• 8. Farghaly K., Abanda F.H., Vidalakis C., Wood G.: BIM-linked data integration for asset management. Built Environment Project and Asset Management, 9, 4, 2019, 489-502, DOI: 10.1108/BEPAM-11-2018-0136
• 9. Ait-Lamallam S., Yaagoubi R., Sebari I., Doukari O.: Extending the IFC Standard to Enable Road Operation and Maintenance Management through OpenBIM. ISPRS International Journal of Geo-Information, 10, 8, 2021, ID article: 496, DOI: 10.3390/ijgi10080496
• 10. PIARC – World Road Association: Indicators for bridge performance and prioritization of bridge actions. PIARC, La Défense, 2003
• 11. PIARC – World Road Association: Indicators representative of the condition of geotechnical structures for road asset management. PIARC, La Défense, 2008
• 12. PIARC – World Road Association: Asset Management Manual. PIARC, La Défense, 2023, https://road-asset.piarc.org/en, 03.10.2023
• 13. Federal Highway Administration (FHWA): Asset management. 2023, https://www.fhwa.dot.gov/asset/, 02.10.2023
• 14. Ředitelství silnic a dálnic (RSD): Overall summary of data monitored in the Information System on the Road and Motorway Network of the Czech Republic as of 1 July 2021. RSD, Prague, 2022 (in Czech)
• 15. Arndt W., Doge N., Fathejalali A., Kämpfer R.: Erstellung einer Geodatenbank aller Brücken und Straßen Deutschlands in kommunaler Baulast auf Basis von Open-Street-Map-Daten. Deutsches Institut für Urbanistik, Berlin, 2015
• 16. Ředitelství silnic a dálnic (RSD): Geoportal of road and highway network, https://geoportal.rsd.cz/web, 03.10.2023, (in Czech)
• 17. Andriejauskas T., Biswas S., Wright A.: Call 2018 Building Information Modelling (BIM) Final Programme Report. Conference of European Directors of Roads (CEDR), Brussels, 2022, https://cedr.eu/docs/view/639748b2a936c-en, 03.10.2023
• 18. Sejnoha J.: Use of the BIM method on road infrastructure projects of the Czech Road Directorate. Presentation to the Technical Board of the Czech Road Directorate, Prague, 2023
• 19. Seitner M., Probst R., Borrmann A., Vilgertshofer S.: Building Information Modeling (BIM) im Brückenbau. Berichte der Bundesanstalt für Straßenwesen, Brücken- und Ingenieurbau Heft B 182. Bundesanstalt für Straßenwesen (BASt), Bergisch Gladbach, 2022
• 20. Jiang S., Jiang L., Han Y., Wu Z., Wang N.: OpenBIM: An Enabling Solution for Information Interoperability. Applied Sciences, 9, 24, 2019, ID article: 5358, DOI: 10.3390/app9245358
• 21. Musella C., Serra M., Salzano A., Menna C., Asprone D.: Open BIM Standards: A Review of the Processes for Managing Existing Structures in the Pre- and Post-Earthquake Phases. CivilEng, 1, 3, 2020, 291-309, DOI: 10.3390/civileng1030019
• 22. BuildingSmart: IFC Specifications Database, https://technical.buildingsmart.org/standards/ifc/ifc-schema-specifications/, 03.10.2023
• 23. ISO 16739-1:2018 Industry Foundation Classes (IFC) for data sharing in the construction and facility management industries – Part 1: Data schema
• 24. ISO 10303-11:2004 Industrial automation systems and integration – Product data representation and exchange – Part 11: description methods: The EXPRESS Language Reference Manual
• 25. W3C Recommendation, https://www.w3.org/TR/xmlschema-0/, 03.10.2023
• 26. ISO 10303-28:2007 Industrial automation systems and integration – Product data representation and exchange – Part 28: Implementation methods: XML representations of EXPRESS schemas and data, using XML schemas
• 27. ISO 10303-21:2002 Industrial automation systems and integration – Product data representation and exchange – Part 21: Implementation methods: Clear text encoding of the exchange structure
• 28. Beck F., Borrmann A., Kolbe T.H.: The need for a differentiation between heterogenous information integration approaches in the field of “BIM-GIS integration”: A Literature review. ISPRS Annals of the Photogrammetry, Remote Sensing and Spatial Information Sciences, VI-4/W1-2020, 2020, 21-28, DOI: 10.5194/isprs-annals-VI-4-W1-2020-21-2020
• 29. Winkels H., Meerkerk J., Koehorst B.: Technical report 2017-05: Utilising BIM for NRAs. Conference of European Directors of Roads (CEDR), Brussels, 2017, https://cedr.eu/docs/view/6063251879c9a-en, 03.10.2023
• 30. Winkels H.: Fact sheet 2016: Open information exchange (BIM) of National Road Authorities is of vital importance for Asset management. Conference of European Directors of Roads (CEDR), Brussels, 2016, https://cedr.eu/docs/view/6063218af2184-en, 03.10.2023
• 31. Státní Fond Dopravní Infrastruktury (SFDI): Regulation of Building Information Modeling of structures of transport infrastructure. Data Standard for documentation for zoning proceedings, building permits, public tendering and construction execution. SFDI, Prague, 2022, https://www.sfdi.cz/bim-informacni-modelovani-staveb/ 03.10.2023, (in Czech)
• 32. Pospisil K., Pospisilova D., Brychtova L.: BIM and Pavement Management System (analysis and recommendation). Janeway, Brno, 2021 (in Czech)
• 33. Pospisil K.: Opinion on Strategic plan of further development of Czech Road Administration Road Databank of with a 10-year outlook. Janeway, Brno, 2021 (in Czech)
• 34. McArthur J.J.: A Building Information Management (BIM) Framework and Supporting Case Study for Existing Building Operations, Maintenance and Sustainability. Procedia Engineering, 118, 2015, 1104-1111, DOI: 10.1016/j.proeng.2015.08.450
• 35. Borrmann A., Konig M., Hochmuth M., Liebich T., Elixmann R.: Die INFRABIM-Reifegradmetrik. Bautechnik, 94, 4, 2017, 215-219, DOI: 10.1002/bate.201700004
• 36. Urbański M., Świtała M., Liszewski W., Ślusarczyk B., Piechowicz K.: Road and bridge construction price indexation illustrated with an example of a selected project. Roads and Bridges - Drogi i Mosty, 21, 4, 2022, 365-378, DOI: 10.7409/rabdim.022.021
• 37. Pospisil K., Zednik P., Stryk J.: Relationship between deformation moduli obtained using light falling weight deflectometer and static plate test on various types of soil. Baltic Journal of Road and Bridge Engineering, 9, 4, 2014, 251-259, DOI: 10.3846/bjrbe.2014.31
• 38. Glinicki M.A., Jóźwiak-Niedźwiedzka D., Antolik A., Dziedzic K., Dąbrowski M., Bogusz K., Lisowski P.: Analysis of causes of damage to single-layer concrete highway pavement. Roads and Bridges - Drogi i Mosty, 21, 3, 2022, 183-201, DOI: 10.7409/rabdim.022.011
• 39. Pospisil K., Manychova M., Stryk J., Korenska M., Matula R., Svoboda V.: Diagnostics of Reinforcement Conditions in Concrete Structures by GPR, Impact-Echo Method and Metal Magnetic Memory Method. Remote Sensing, 13, 5, 2021, ID article: 952, DOI: 10.3390/rs13050952
• 40. Chmielewski R., Wesołowski M., Waliszewski D.: Review of subgrade bearing capacity tests for airfield pavements. Roads and Bridges - Drogi i Mosty, 21, 2, 2022, 117-131, DOI: 10
• 41. Burghardt T.E., Köck B., Pashkevich A., Fasching A.: Skid resistance of road markings: literature review and field test results. Roads and Bridges - Drogi i Mosty, 22, 2, 2023, 141-165, DOI: 10.7409/rabdim.023.007
• 42. Korenska M., Pazdera L., Pospisil K., Stryk J., Vyroubal P.: Detection of the reinforcement corrosion in prestressed concrete girders. In: Grum, J. (Ed.): 8th International Conference of the Slovenian Society for Non-Destructive Testing, Conference Proceedings: Application of contemporary non-destructive testing in engineering, Portoroz, Slovenia, 2005, 317-322
• 43. Arshad M., Fahad M., Khan A., Adil M., Khan A.: Fatigue load effects on highway bridges of Pakistan using Weigh-In-Motion data. Roads and Bridges - Drogi i Mosty, 21, 1, 2022, 19-37, DOI: 10.7409/rabdim.022.002