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

Karel Pospisil; Michal Janku; Josef Stryk; Vitezslav Pospisil; Dagmar Pospisilova

doi:10.7409/rabdim.024.003

Published: 2024-04-10

Vol. 23 No. 1 (2024)

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

Karel Pospisil , Michal Janku , Josef Stryk , Vitezslav Pospisil , Dagmar Pospisilova

Section: Articles

https://doi.org/10.7409/rabdim.024.003

Abstract

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.

Keywords:

asset management system, BIM, BMS, PMS, relational database, road network model.

Similar Articles

Malwina Spławińska, Analysis of the influence of traffic flow variability on noise level on roads , Roads and Bridges - Drogi i Mosty: Vol. 18 No. 2 (2019)
Jerzy Ejsmont, Grzegorz Ronowski, Simulation of vehicle noise during slow speed maneuvering – CP2009 model , Roads and Bridges - Drogi i Mosty: Vol. 9 No. 1 (2010)
Anna Leniak-Tomczyk, Grażyna Łagoda, Environmental determinants of road construction process in Poland , Roads and Bridges - Drogi i Mosty: Vol. 9 No. 2 (2010)
Maciej Kruszyna, Antoni Szydło, Modelling of urban transport traffic flow on the separated lane between the junctions , Roads and Bridges - Drogi i Mosty: Vol. 2 No. 1 (2003)
Maciej Kowal, Marek Łagoda, Strengthening of steel structures with CFRP strips , Roads and Bridges - Drogi i Mosty: Vol. 16 No. 2 (2017)
Rafał Maciaszek, The bridge over the Ina River – the history and the analysis of capacity , Roads and Bridges - Drogi i Mosty: Vol. 8 No. 3 (2009)
Lidia Więcław-Bator, Wojciech Moćko, Ryszard Chmielewski, Leopold Kruszka, Minimizing the occurrence of factors affecting the acceleration of degradation process of steel bridge structures , Roads and Bridges - Drogi i Mosty: Vol. 15 No. 4 (2016)
Andrzej Plewa, Asphalt mixtures with binders fluidized by addition of vegetable origin oil for applications as flexible anti-crack layers , Roads and Bridges - Drogi i Mosty: Vol. 18 No. 3 (2019)
Jakub Zawieska, Analysis of external costs of transport within the scope of emissions of air pollution and noise , Roads and Bridges - Drogi i Mosty: Vol. 14 No. 3 (2015)
Karol Pietrzak, Zbigniew Tokarski, Karol J. Kowalski, Assessment of the traffic noise reduction when using tramway screening , Roads and Bridges - Drogi i Mosty: Vol. 17 No. 2 (2018)

<< < 11 12 13 14 15 16 17 18 19 20 > >>

You may also start an advanced similarity search for this article.

Download files

PDF

Citation rules

Pospisil, K., Janku, M., Stryk, J., Pospisil, V., & Pospisilova, D. (2024). Concept of unification of mutually incompatible information models and data stored in relational databases of road administrations. Roads and Bridges - Drogi I Mosty, 23(1), 45–72. https://doi.org/10.7409/rabdim.024.003

Cited by / Share

References

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

PIARC – World Road Association: Indicators for bridge performance and prioritization of bridge actions. PIARC, La Défense, 2003
Google Scholar

PIARC – World Road Association: Indicators representative of the condition of geotechnical structures for road asset management. PIARC, La Défense, 2008
Google Scholar

PIARC – World Road Association: Asset Management Manual. PIARC, La Défense, 2023, https://road-asset.piarc.org/en, 03.10.2023
Google Scholar

Federal Highway Administration (FHWA): Asset management. 2023, https://www.fhwa.dot.gov/asset/, 02.10.2023
Google Scholar

Ř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)
Google Scholar

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
Google Scholar

Ředitelství silnic a dálnic (RSD): Geoportal of road and highway network, https://geoportal.rsd.cz/web, 03.10.2023, (in Czech)
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

BuildingSmart: IFC Specifications Database, https://technical.buildingsmart.org/standards/ifc/ifc-schema-specifications/, 03.10.2023
Google Scholar

ISO 16739-1:2018 Industry Foundation Classes (IFC) for data sharing in the construction and facility management industries – Part 1: Data schema
Google Scholar

ISO 10303-11:2004 Industrial automation systems and integration – Product data representation and exchange – Part 11: description methods: The EXPRESS Language Reference Manual
Google Scholar

W3C Recommendation, https://www.w3.org/TR/xmlschema-0/, 03.10.2023
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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)
Google Scholar

Pospisil K., Pospisilova D., Brychtova L.: BIM and Pavement Management System (analysis and recommendation). Janeway, Brno, 2021 (in Czech)
Google Scholar

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)
Google Scholar

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
Google Scholar

Borrmann A., Konig M., Hochmuth M., Liebich T., Elixmann R.: Die INFRABIM-Reifegradmetrik. Bautechnik, 94, 4, 2017, 215-219, DOI: 10.1002/bate.201700004
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

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.7409/rabdim.022.007
Google Scholar

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
Google Scholar

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
Google Scholar

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
Google Scholar

Karel Pospisil

Affiliation:

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

Michal Janku

Michal.Janku@cdv.cz

Affiliation:

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

Josef Stryk

Affiliation:

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

Vitezslav Pospisil

Affiliation:

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

Bio Statement (e.g., department and rank)

Janeway, Sp. z o.o.., ul. Kainarova 79, Brno, 61600, Czechy

Dagmar Pospisilova

Affiliation:

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

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

Abstract

Keywords:

Similar Articles

Downloads

Karel Pospisil

Michal Janku

Josef Stryk

Vitezslav Pospisil

Dagmar Pospisilova