header

Ontology Based Data Access in Statoil

42 Pages Posted: 10 Jul 2018 First Look: Accepted

See all articles by Evgeny Kharlamov

Evgeny Kharlamov

University of Oxford - Information Systems Group

Dimitris Bilidas

National and Kapodistrian University of Athens

Dag Hovland

University of Oslo - Department of Informatics (UiO)

Ernesto Jimenez-Ruiz

University of Oslo - Department of Informatics (UiO)

Davide Lanti

Free University of Bozen-Bolzano - KRDB Research Centre

Hallstein Lie

Statoil

Martin Rezk

Free University of Bozen-Bolzano - KRDB Research Centre

Martin G. Skjæveland

University of Oslo - Department of Informatics (UiO)

Ahmet Soylu

Norwegian University of Science and Technology (NTNU)

Guohui Xiao

Free University of Bozen-Bolzano - KRDB Research Centre

Dimitriy Zheleznyakov

University of Oxford - Information Systems Group

Martin Giese

University of Oslo - Department of Informatics (UiO)

Yannis Ioannidis

National and Kapodistrian University of Athens - Department of Informatics and Telecommunications

Yannis Kotidis

Athens University of Economics and Business

Manolis Koubarakis

National and Kapodistrian University of Athens - Department of Informatics and Telecommunications

Arild Waaler

University of Oslo - Department of Informatics (UiO)

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; a query processing module to perform and optimise the process of translating ontological queries into data queries and their execution over either a single DB of federated DBs; and a query formulation module to support query construction for engineers with a limited IT background. Our modules have been integrated in one OBDA system, deployed at Statoil, integrated with Statoil's infrastructure, and evaluated with Statoil's engineers and data.

Keywords: Ontology Based Data Access, Statoil, Optique Platform, System Deployment, Evaluation, Bootstrapping, Optimisations

Suggested Citation

Kharlamov, Evgeny and Bilidas, Dimitris and Hovland, Dag and Jimenez-Ruiz, Ernesto and Lanti, Davide and Lie, Hallstein and Rezk, Martin and Skjæveland, Martin G. and Soylu, Ahmet and Xiao, Guohui and Zheleznyakov, Dimitriy and Giese, Martin and Ioannidis, Yannis and Kotidis, Yannis and Koubarakis, Manolis and Waaler, Arild, Ontology Based Data Access in Statoil (2017). Journal of Web Semantics First Look . Available at SSRN: https://ssrn.com/abstract=3199136 or http://dx.doi.org/10.2139/ssrn.3199136

Evgeny Kharlamov (Contact Author)

University of Oxford - Information Systems Group ( email )

Wolfson Building
Parks Road
Oxford
United Kingdom

Dimitris Bilidas

National and Kapodistrian University of Athens ( email )

5 Stadiou Strt
Athens, 12131
Greece

Dag Hovland

University of Oslo - Department of Informatics (UiO) ( email )

P.O box 1080
Oslo
Norway

Ernesto Jimenez-Ruiz

University of Oslo - Department of Informatics (UiO) ( email )

P.O box 1080
Oslo
Norway

Davide Lanti

Free University of Bozen-Bolzano - KRDB Research Centre ( email )

Italy

Hallstein Lie

Statoil ( email )

Norway

Martin Rezk

Free University of Bozen-Bolzano - KRDB Research Centre ( email )

Italy

Martin G. Skjæveland

University of Oslo - Department of Informatics (UiO) ( email )

P.O box 1080
Oslo
Norway

Ahmet Soylu

Norwegian University of Science and Technology (NTNU) ( email )

Trondheim NO-7491
Norway

Guohui Xiao

Free University of Bozen-Bolzano - KRDB Research Centre ( email )

Italy

Dimitriy Zheleznyakov

University of Oxford - Information Systems Group ( email )

Wolfson Building
Parks Road
Oxford
United Kingdom

Martin Giese

University of Oslo - Department of Informatics (UiO) ( email )

P.O box 1080
Oslo
Norway

Yannis Ioannidis

National and Kapodistrian University of Athens - Department of Informatics and Telecommunications ( email )

Panepistimiopolis
Ilisia
Athens, GR15784
Greece

Yannis Kotidis

Athens University of Economics and Business ( email )

76 Patission Street
Athens, 104 34
Greece

Manolis Koubarakis

National and Kapodistrian University of Athens - Department of Informatics and Telecommunications ( email )

Panepistimiopolis
Ilisia
Athens, GR15784
Greece

Arild Waaler

University of Oslo - Department of Informatics (UiO) ( email )

P.O box 1080
Oslo
Norway

Register to save articles to
your library

Register

Paper statistics

Abstract Views
137
Downloads
7