ADaMaP: Automatic Alignment of Relational Data Sources using Mapping Patterns (Abstract)

We propose a method for automatically extracting semantics from data sources. The availability of multiple data sources on the one hand and the lack of proper semantic documentation of such data sources on the other hand call for new strategies in integrating data sources by extracting semantics from the data source itself rather than from its documentation. In this work we focus on relational databases, observing they are created from semantically-rich designs such as ER diagrams, which are often not conveyed together with the database itself. While the relational model may be semantically-poor with respect to ontological models, the original semantically-rich design of the application domain leaves recognizable footprints that can be converted into ontology mapping patterns. In this work, we offer an algorithm to automatically detect and map a relational schema to ontology mapping patterns and offer an empirical evaluation using two benchmark datasets.

[1]  Diego Calvanese,et al.  Tractable Reasoning and Efficient Query Answering in Description Logics: The DL-Lite Family , 2007, Journal of Automated Reasoning.

[2]  Marco Montali,et al.  ADaMaP: Automatic Alignment of Data Sources using Mapping Patterns , 2020 .

[3]  Nikolas Mitrou,et al.  Bringing relational databases into the Semantic Web: A survey , 2012, Semantic Web.

[4]  Remco M. Dijkman,et al.  Probabilistic Optimization of Semantic Process Model Matching , 2012, BPM.

[5]  Wil M. P. van der Aalst,et al.  Object-Centric Process Mining: Dealing with Divergence and Convergence in Event Data , 2019, SEFM.

[6]  Aldo Gangemi,et al.  Ontology Engineering with Ontology Design Patterns - Foundations and Applications , 2016, Studies on the Semantic Web.

[7]  Craig A. Knoblock,et al.  Karma: A System for Mapping Structured Sources into the Semantic Web , 2012, ESWC.

[8]  Diego Calvanese,et al.  Mapping Patterns for Virtual Knowledge Graphs , 2020, ArXiv.

[9]  Kenneth L. Clarkson,et al.  Schema covering: a step towards enabling reuse in information integration , 2010, 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010).

[10]  Ian Horrocks,et al.  Optique 1.0: Semantic Access to Big Data: The Case of Norwegian Petroleum Directorate's FactPages , 2013, International Semantic Web Conference.

[11]  Dirk Fahland,et al.  Artifact-Centric Process Mining , 2019, Encyclopedia of Big Data Technologies.

[12]  Daniel P. Miranker,et al.  Ultrawrap Mapper: A Semi-Automatic Relational Database to RDF (RDB2RDF) Mapping Tool , 2015, International Semantic Web Conference.

[13]  Diego Calvanese,et al.  Ontop: Answering SPARQL queries over relational databases , 2016, Semantic Web.

[14]  Marco Montali,et al.  Modeling and Reasoning over Declarative Data-Aware Processes with Object-Centric Behavioral Constraints , 2019, BPM.

[15]  Freddy Priyatna,et al.  MIRROR: Automatic R2RML Mapping Generation from Relational Databases , 2015, ICWE.

[16]  Freddy Priyatna,et al.  Relational Database to RDF Mapping Patterns , 2012, WOP.

[17]  Beng Chin Ooi,et al.  On multi-column foreign key discovery , 2010, Proc. VLDB Endow..

[18]  Mathias Weske,et al.  Discovering Data Models from Event Logs , 2020, ER.

[19]  Bernardo Cuenca Grau,et al.  OWL 2 Web Ontology Language: Profiles , 2009 .

[20]  Erhard Rahm,et al.  A survey of approaches to automatic schema matching , 2001, The VLDB Journal.

[21]  Diego Calvanese,et al.  Linking Data to Ontologies , 2008, J. Data Semant..

[22]  Carsten Binnig,et al.  IncMap: pay as you go matching of relational schemata to OWL ontologies , 2013, OM.

[23]  Diego Calvanese,et al.  The NPD Benchmark: Reality Check for OBDA Systems , 2015, EDBT.

[24]  Ian Horrocks,et al.  BootOX: Practical Mapping of RDBs to OWL 2 , 2015, SEMWEB.