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

Cezary Kraszewski, Leszek Rafalski, Michał Ćwiąkała, Marcin Dreger, Effect of applied stress increments of the secondary deformation modulus and the ratio between the secondary and primary moduli of sandy gravel and crushed aggregate in static plate load tests , Roads and Bridges - Drogi i Mosty: Vol. 19 No. 4 (2020)
Izabela Wójcik-Grząba, Lesław Kwaśniewski, Verification of the hemispherical finite element model of elastic space , Roads and Bridges - Drogi i Mosty: Vol. 14 No. 1 (2015)
Adam Zofka, Dominika Maliszewska, Maciej Maliszewski, Jacek Boratyński, Application of FTIR ATR method to examine the polymer content in the modified bitumen and to assess susceptibility of bitumen to ageing , Roads and Bridges - Drogi i Mosty: Vol. 14 No. 3 (2015)
Leszek Kornalewski, Aleksander Konior, Monika Zapaśnik, Efficiency of information transfer in road traffic by variable message signs , Roads and Bridges - Drogi i Mosty: Vol. 20 No. 2 (2021)
Jan Broda, Andrzej Mitka, Andrzej Gawłowski, Innovative technique for road slope stabilisation , Roads and Bridges - Drogi i Mosty: Vol. 19 No. 3 (2020)
Ewa Wicher, Dawid Kucharski, Comparison of safety barrier parameters in the case of double impact at the same location , Roads and Bridges - Drogi i Mosty: Vol. 20 No. 4 (2021)
Marcin Świtała, Wiesław Liszewski, Typology of city residents’ activity in terms of their mobility , Roads and Bridges - Drogi i Mosty: Vol. 21 No. 4 (2022)
Urszula Kołodziejczyk, Michał Ćwiąkała, Analysis of the results of model investigation of water capillary rise in road embankments , Roads and Bridges - Drogi i Mosty: Vol. 8 No. 4 (2009)
Przemysław Ostrowski, Adam Zofka, Krzysztof Błażejowski, VECD method as a tool for evaluation of pavement structure fatigue performance , Roads and Bridges - Drogi i Mosty: Vol. 20 No. 2 (2021)
Marian Głażewski, Konrad Piechowicz, Construction and strengthening of road slopes , Roads and Bridges - Drogi i Mosty: Vol. 8 No. 2 (2009)

<< < 1 2 3 4 5 6 7 8 9 10 > >>

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

Licence

This work is licensed under a Creative Commons Attribution 4.0 International License.

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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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 DOI: https://doi.org/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

pospisil@vut.cz
https://orcid.org/0000-0002-4773-0428

Affiliation:

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

Michal Janku

https://orcid.org/0000-0003-2588-2655

Affiliation:

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

Josef Stryk

https://orcid.org/0000-0002-8289-6028

Affiliation:

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

Vitezslav Pospisil

https://orcid.org/0009-0006-8895-2429

Affiliation:

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

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

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

Dagmar Pospisilova

https://orcid.org/0000-0002-1300-7290

Affiliation:

Transport Research Centre (CDV), 33a Lisenska St., Brno, 63600, Czechia 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