Asset Condition Integration from information containers into relational Asset Management databases (icdd2ams)

This repository contains ontologies, data, queries, and source code presented in "BIM-based organization of inspection data using Semantic Web technology for infrastructure asset management" published at EUROSTRUCT 2021 conference. It includes a minimal ABox ontology for integrating asset conditions located using Building Topology Ontology (BOT) within an Information Container for linked document delivery (ICDD) into SQL-based asset management systems. See the following files:

Code

• src/main/java/org/iib/icdd2ams/ToSQL.java: inferring the sample data set with the given rule set to the resulting inferred data set
• src/main/java/org/iib/icdd2ams/ToSQLTemplate.java: generating an SQL insert query form a SPARQL Template (STTL)

Resources [input]

• src/main/resources/ams/input/amsData.ttl: sample data set for inferring SQL Data
• src/main/resources/ams/input/insertData.ttl: sample data set for the generation of SQL INSERT query using STTL
• src/main/resources/ams/input/amsSqlData.ttl: sample data set extracted from SQL database
• src/main/resources/ams/input/sql/20210610_AMS_database_draft.sql: SQL dump of the database used for the extraction of structural information

Resources [mappings]

• src/main/resources/ams/mappings/query.rqg: sample SPARQL template for generating SQL INSERT query using STTL
• src/main/resources/ams/mappings/amsRules.ttl: general mapping rules for inferring bot:Element and eurotl:InspectionActivity into SQL Schema
• src/main/resources/ams/mappings/icdd2ams.ttl : Ontology for adding relations between bot, eurotl and asbing, see Documentation

Third party licenses and dependencies

• this approach makes use of SPARQL-Generate (sparql-generate.jar) extension of Apache Jena for STTL generation provided on https://github.com/sparql-generate/sparql-generate under Apache License, Version 2.0.
• this approach makes use of the R2RML Implementation (r2rml.jar) provided on https://github.com/chrdebru/r2rml-distributions under MIT license.
• implementation is based on the Apache Jena Framework 3.4.0 (minimum) dependency

Acknowledgments

The authors gratefully acknowledge CEDR (Conference of European Directors of Roads) and FFG (Austrian Research Promotion Agency) for funding this research; We would like to thank the consortium of research projects AMSFree and BIM4AMS for their collaboration in the research of asset management for bridges.

Contact information

Liu Liu (liu.liu-m6r@rub.de / ResearchGate profile) and Philipp Hagedorn (philipp.hagedorn-n6v@rub.de / GitHub profile / ResearchGate profile)
Further information on https://www.inf.bi.ruhr-uni-bochum.de/iib/index.html.en