International Semantic Web Conference

The Semantic Web - ISWC 2015 pp 93-112 | Cite as

Ontology Based Access to Exploration Data at Statoil

  • Evgeny Kharlamov
  • Dag Hovland
  • Ernesto Jiménez-Ruiz
  • Davide Lanti
  • Hallstein Lie
  • Christoph Pinkel
  • Martin Rezk
  • Martin G. Skjæveland
  • Evgenij Thorstensen
  • Guohui Xiao
  • Dmitriy Zheleznyakov
  • Ian Horrocks
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 9367)

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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Arenas, M., et al.: Enabling faceted search over OWL 2 with semfacet. In: OWLED (2014)Google Scholar
  2. 2.
    Arenas, M., et al.: Faceted search over ontology-enhanced RDF data. In: CIKM (2014)Google Scholar
  3. 3.
    Arenas, M., et al.: SemFacet: semantic faceted search over Yago. In: WWW, Companion Volume (2014)Google Scholar
  4. 4.
    Arenas, M., et al.: Towards semantic faceted search. In: WWW, Companion Volume (2014)Google Scholar
  5. 5.
    Calvanese, D., et al.: The MASTRO system for ontology-based data access. In: Semantic Web 2.1 (2011)Google Scholar
  6. 6.
    Calvanese, D., et al.: Tractable Reasoning and Efficient Query Answering in Description Logics: The DL-Lite Family. JAR 39(3) (2007)Google Scholar
  7. 7.
    Console, M., et al.: Efficient approximation in DL-Lite of OWL 2 ontologies. In: DL (2013)Google Scholar
  8. 8.
    Crompton, J.: Keynote talk at the W3C Workshop on Sem. Web in Oil & Gas Industry (2008)Google Scholar
  9. 9.
    Doan, A., et al.: Principles of Data Integration. Kaufmann (2012)Google Scholar
  10. 10.
    Grau, B.C., et al.: Controlled query evaluation for datalog and OWL 2 profile ontologies. In: IJCAI (2015)Google Scholar
  11. 11.
    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) CrossRefGoogle Scholar
  12. 12.
    Jimenez-Ruiz, E., et al.: Large-scale interactive ontology matching: algorithms and implementation. In: ECAI (2012)Google Scholar
  13. 13.
    Jiménez-Ruiz, E., et al.: BootOX: practical mapping of RDBs to OWL 2. In: ISWC (2015)Google Scholar
  14. 14.
    Kharlamov, E., et al.: Optique 1.0: semantic access to big data: the case of Norwegian petroleum directorate factpages. In: ISWC Posters & Demos (2013)Google Scholar
  15. 15.
    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) CrossRefGoogle Scholar
  16. 16.
    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) Google Scholar
  17. 17.
    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) Google Scholar
  18. 18.
    Lanti, D., et al.: The NPD benchmark: reality check for OBDA systems. In: EDBT (2015)Google Scholar
  19. 19.
    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) CrossRefGoogle Scholar
  20. 20.
    Pinkel, C., et al.: IncMap: pay as you go matching of relational schemata to OWL ontologies. In: OM (2013)Google Scholar
  21. 21.
    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) CrossRefGoogle Scholar
  22. 22.
    Priyatna, F., et al.: Formalisation and experiences of R2RML-based SPARQL to SQL query translation using Morph. In: WWW (2014)Google Scholar
  23. 23.
    Rodriguez-Muro, M., Calvanese, D.: High performance query answering over DL-Lite ontologies. In: KR (2012)Google Scholar
  24. 24.
    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) CrossRefGoogle Scholar
  25. 25.
    Sequeda, J., et al.: Survey of directly mapping SQL databases to the semantic web. Knowledge Eng. Review 26(4) (2011)Google Scholar
  26. 26.
    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) CrossRefGoogle Scholar
  27. 27.
    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) Google Scholar
  28. 28.
    Soylu, A., et al.: OptiqueVQS: towards an ontology-based visual query system for big data. In: MEDES (2013)Google Scholar
  29. 29.
    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) Google Scholar
  30. 30.
    Soylu, A., et al.: Why not simply Google? In: NordiCHI (2014)Google Scholar
  31. 31.
    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) CrossRefGoogle Scholar
  32. 32.
    Spanos, D.-E., et al.: Bringing relational databases into the semantic web: a survey. In: Semantic Web 3.2 (2012)Google Scholar
  33. 33.
    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) CrossRefGoogle Scholar

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  • Evgeny Kharlamov
    • 1
  • Dag Hovland
    • 2
  • Ernesto Jiménez-Ruiz
    • 1
  • Davide Lanti
    • 3
  • Hallstein Lie
    • 4
  • Christoph Pinkel
    • 5
  • Martin Rezk
    • 3
  • Martin G. Skjæveland
    • 2
  • Evgenij Thorstensen
    • 2
  • Guohui Xiao
    • 3
  • Dmitriy Zheleznyakov
    • 1
  • Ian Horrocks
    • 1
  1. 1.University of OxfordOxfordUK
  2. 2.University of OsloOsloNorway
  3. 3.Free University of Bozen-BolzanoBolzanoItaly
  4. 4.Statoil ASAStavangerNorway
  5. 5.fluid Operations AGWalldorfGermany

Personalised recommendations