A Pay-as-you-go Methodology to Design and Build Enterprise Knowledge Graphs from Relational Databases

Business users must answer business questions quickly to address Business Intelligence (BI) needs. The bottleneck is to understand the complex databases schemas. Only few people in the IT department truly understand them. A holy grail is to empower business users to ask and answer their own questions with minimal IT support. Semantic technologies, now dubbed as Knowledge Graphs, become useful here. Even though the research and industry community has provided evidence that semantic technologies works in the real world, our experience is that there continues to be a major challenge: the engineering of ontologies and mappings covering enterprise databases containing thousands of tables with tens of thousands of attributes. In this paper, we present a novel and unique pay-as-you-go methodology that addresses the aforementioned difficulties. We provide a case study with a large scale e-commerce company where Capsenta’s Ultrawrap has been deployed in production for over 3 years.

[1]  Daniel P. Miranker,et al.  A Pay-As-You-Go Methodology for Ontology-Based Data Access , 2017, IEEE Internet Computing.

[2]  Robert Stevens,et al.  Towards Competency Question-Driven Ontology Authoring , 2014, ESWC.

[3]  Michael Uschold,et al.  Ontologies: principles, methods and applications , 1996, The Knowledge Engineering Review.

[4]  Daniel P. Miranker,et al.  OBDA: Query Rewriting or Materialization? In Practice, Both! , 2014, SEMWEB.

[5]  Michael Gruninger,et al.  Methodology for the Design and Evaluation of Ontologies , 1995, IJCAI 1995.

[6]  Daniel P. Miranker,et al.  On directly mapping relational databases to RDF and OWL , 2012, WWW.

[7]  C. Maria Keet,et al.  Test-Driven Development of Ontologies , 2016, ESWC.

[8]  Evgeny Kharlamov,et al.  Ontology Based Data Access in Statoil , 2017, J. Web Semant..

[9]  Asunción Gómez-Pérez,et al.  METHONTOLOGY: From Ontological Art Towards Ontological Engineering , 1997, AAAI 1997.

[10]  Asunción Gómez-Pérez,et al.  Introduction: Ontology Engineering in a Networked World , 2012, Ontology Engineering in a Networked World.

[11]  Barbara Zdrazil,et al.  Scientific competency questions as the basis for semantically enriched open pharmacological space development. , 2013, Drug discovery today.

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

[13]  Daniel P. Miranker,et al.  Ultrawrap: SPARQL execution on relational data , 2013, J. Web Semant..

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