Abstract
Ontology Based Data Access (OBDA) is a prominent approach to query databases which uses an ontology to expose data in a conceptually clear manner by abstracting away from the technical schema-level details of the underlying data. The ontology is ‘connected’ to the data via mappings that allow to automatically translate queries posed over the ontology into data-level queries that can be executed by the underlying database management system. Despite a lot of attention from the research community, there are still few instances of real world industrial use of OBDA systems. In this work we present data access challenges in the data-intensive petroleum company Statoil and our experience in addressing these challenges with OBDA technology. In particular, we have developed a deployment module to create ontologies and mappings from relational databases in a semi-automatic fashion, and a query processing module to perform and optimise the process of translating ontological queries into data queries and their execution. Our modules have been successfully deployed and evaluated for an OBDA solution in Statoil.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Arenas, M., et al.: Enabling faceted search over OWL 2 with semfacet. In: OWLED (2014)
Arenas, M., et al.: Faceted search over ontology-enhanced RDF data. In: CIKM (2014)
Arenas, M., et al.: SemFacet: semantic faceted search over Yago. In: WWW, Companion Volume (2014)
Arenas, M., et al.: Towards semantic faceted search. In: WWW, Companion Volume (2014)
Calvanese, D., et al.: The MASTRO system for ontology-based data access. In: Semantic Web 2.1 (2011)
Calvanese, D., et al.: Tractable Reasoning and Efficient Query Answering in Description Logics: The DL-Lite Family. JAR 39(3) (2007)
Console, M., et al.: Efficient approximation in DL-Lite of OWL 2 ontologies. In: DL (2013)
Crompton, J.: Keynote talk at the W3C Workshop on Sem. Web in Oil & Gas Industry (2008)
Doan, A., et al.: Principles of Data Integration. Kaufmann (2012)
Grau, B.C., et al.: Controlled query evaluation for datalog and OWL 2 profile ontologies. In: IJCAI (2015)
Cuenca Grau, B., Kharlamov, E., Kostylev, E.V., Zheleznyakov, D.: Controlled query evaluation over OWL 2 RL ontologies. In: Alani, H., Kagal, L., Fokoue, A., Groth, P., Biemann, C., Parreira, J.X., Aroyo, L., Noy, N., Welty, C., Janowicz, K. (eds.) ISWC 2013, Part I. LNCS, vol. 8218, pp. 49–65. Springer, Heidelberg (2013)
Jimenez-Ruiz, E., et al.: Large-scale interactive ontology matching: algorithms and implementation. In: ECAI (2012)
Jiménez-Ruiz, E., et al.: BootOX: practical mapping of RDBs to OWL 2. In: ISWC (2015)
Kharlamov, E., et al.: Optique 1.0: semantic access to big data: the case of Norwegian petroleum directorate factpages. In: ISWC Posters & Demos (2013)
Kharlamov, E., et al.: Optique: towards OBDA systems for industry. In: Cimiano, P., Fernández, M., Lopez, V., Schlobach, S., Völker, J. (eds.) ESWC 2013. LNCS, vol. 7955, pp. 125–140. Springer, Heidelberg (2013)
Kharlamov, E., et al.: How semantic technologies can enhance data access at siemens energy. In: Mika, P., Tudorache, T., Bernstein, A., Welty, C., Knoblock, C., Vrandečić, D., Groth, P., Noy, N., Janowicz, K., Goble, C. (eds.) ISWC 2014, Part I. LNCS, vol. 8796, pp. 601–619. Springer, Heidelberg (2014)
Kontchakov, R., Rezk, M., Rodríguez-Muro, M., Xiao, G., Zakharyaschev, M.: Answering SPARQL queries over databases under OWL 2 QL entailment regime. In: Mika, P., Tudorache, T., Bernstein, A., Welty, C., Knoblock, C., Vrandečić, D., Groth, P., Noy, N., Janowicz, K., Goble, C. (eds.) ISWC 2014, Part I. LNCS, vol. 8796, pp. 552–567. Springer, Heidelberg (2014)
Lanti, D., et al.: The NPD benchmark: reality check for OBDA systems. In: EDBT (2015)
Pinkel, C., et al.: RODI: a benchmark for automatic mapping generation in relational-to-ontology data integration. In: Gandon, F., Sabou, M., Sack, H., d’Amato, C., Cudré-Mauroux, P., Zimmermann, A. (eds.) ESWC 2015. LNCS, pp. 21–37. Springer, Heidelberg (2015)
Pinkel, C., et al.: IncMap: pay as you go matching of relational schemata to OWL ontologies. In: OM (2013)
Poggi, A., Lembo, D., Calvanese, D., De Giacomo, G., Lenzerini, M., Rosati, R.: Linking data to ontologies. In: Spaccapietra, S. (ed.) Journal on Data Semantics X. LNCS, vol. 4900, pp. 133–173. Springer, Heidelberg (2008)
Priyatna, F., et al.: Formalisation and experiences of R2RML-based SPARQL to SQL query translation using Morph. In: WWW (2014)
Rodriguez-Muro, M., Calvanese, D.: High performance query answering over DL-Lite ontologies. In: KR (2012)
Rodríguez-Muro, M., Kontchakov, R., Zakharyaschev, M.: Ontology-based data access: ontop of databases. In: Alani, H., Kagal, L., Fokoue, A., Groth, P., Biemann, C., Parreira, J.X., Aroyo, L., Noy, N., Welty, C., Janowicz, K. (eds.) ISWC 2013, Part I. LNCS, vol. 8218, pp. 558–573. Springer, Heidelberg (2013)
Sequeda, J., et al.: Survey of directly mapping SQL databases to the semantic web. Knowledge Eng. Review 26(4) (2011)
Skjæveland, M.G., Lian, E.H., Horrocks, I.: Publishing the norwegian petroleum directorate’s factpages as semantic web data. In: Alani, H., Kagal, L., Fokoue, A., Groth, P., Biemann, C., Parreira, J.X., Aroyo, L., Noy, N., Welty, C., Janowicz, K. (eds.) ISWC 2013, Part II. LNCS, vol. 8219, pp. 162–177. Springer, Heidelberg (2013)
Solimando, A.: Detecting and correcting conservativity principle violations in ontology mappings. In: Mika, P., Tudorache, T., Bernstein, A., Welty, C., Knoblock, C., Vrandečić, D., Groth, P., Noy, N., Janowicz, K., Goble, C. (eds.) ISWC 2014, Part II. LNCS, vol. 8797, pp. 545–552. Springer, Heidelberg (2014)
Soylu, A., et al.: OptiqueVQS: towards an ontology-based visual query system for big data. In: MEDES (2013)
Soylu, A., Giese, M., Jimenez-Ruiz, E., Kharlamov, E., Zheleznyakov, D., Horrocks, I.: Towards exploiting query history for adaptive ontology-based visual query formulation. In: Closs, S., Studer, R., Garoufallou, E., Sicilia, M.-A. (eds.) MTSR 2014. CCIS, vol. 478, pp. 107–119. Springer, Heidelberg (2014)
Soylu, A., et al.: Why not simply Google? In: NordiCHI (2014)
Soylu, A., Skjæveland, M.G., Giese, M., Horrocks, I., Jimenez-Ruiz, E., Kharlamov, E., Zheleznyakov, D.: A preliminary approach on ontology-based visual query formulation for big data. In: Garoufallou, E., Greenberg, J. (eds.) MTSR 2013. CCIS, vol. 390, pp. 201–212. Springer, Heidelberg (2013)
Spanos, D.-E., et al.: Bringing relational databases into the semantic web: a survey. In: Semantic Web 3.2 (2012)
Stoilos, G., Stamou, G., Kollias, S.D.: A string metric for ontology alignment. In: Gil, Y., Motta, E., Benjamins, V.R., Musen, M.A. (eds.) ISWC 2005. LNCS, vol. 3729, pp. 624–637. Springer, Heidelberg (2005)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Kharlamov, E. et al. (2015). Ontology Based Access to Exploration Data at Statoil. In: Arenas, M., et al. The Semantic Web - ISWC 2015. ISWC 2015. Lecture Notes in Computer Science(), vol 9367. Springer, Cham. https://doi.org/10.1007/978-3-319-25010-6_6
Download citation
DOI: https://doi.org/10.1007/978-3-319-25010-6_6
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-25009-0
Online ISBN: 978-3-319-25010-6
eBook Packages: Computer ScienceComputer Science (R0)