Ontology based data access in Statoil
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 al...
| Main Authors: | , , , , , , , , , , , , , , , |
|---|---|
| Format: | Journal article |
| Published: |
Elsevier
2017
|
| _version_ | 1797092629556494336 |
|---|---|
| author | Kharlamov, E Hovland, D Skjæveland, MG Bilidas, D Jiménez-Ruiz, E Xiao, G Soylu, A Lanti, D Rezk, M Zheleznyakov, D Giese, M Lie, H Ioannidis, Y Kotidis, Y Koubarakis, M Waaler, A |
| author_facet | Kharlamov, E Hovland, D Skjæveland, MG Bilidas, D Jiménez-Ruiz, E Xiao, G Soylu, A Lanti, D Rezk, M Zheleznyakov, D Giese, M Lie, H Ioannidis, Y Kotidis, Y Koubarakis, M Waaler, A |
| author_sort | Kharlamov, E |
| collection | OXFORD |
| description | 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. |
| first_indexed | 2024-03-07T03:48:43Z |
| format | Journal article |
| id | oxford-uuid:c077fe8d-7517-4a4c-b6a1-a87f517f91d6 |
| institution | University of Oxford |
| last_indexed | 2024-03-07T03:48:43Z |
| publishDate | 2017 |
| publisher | Elsevier |
| record_format | dspace |
| spelling | oxford-uuid:c077fe8d-7517-4a4c-b6a1-a87f517f91d62022-03-27T05:54:36ZOntology based data access in StatoilJournal articlehttp://purl.org/coar/resource_type/c_dcae04bcuuid:c077fe8d-7517-4a4c-b6a1-a87f517f91d6Symplectic Elements at OxfordElsevier2017Kharlamov, EHovland, DSkjæveland, MGBilidas, DJiménez-Ruiz, EXiao, GSoylu, ALanti, DRezk, MZheleznyakov, DGiese, MLie, HIoannidis, YKotidis, YKoubarakis, MWaaler, AOntology 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. |
| spellingShingle | Kharlamov, E Hovland, D Skjæveland, MG Bilidas, D Jiménez-Ruiz, E Xiao, G Soylu, A Lanti, D Rezk, M Zheleznyakov, D Giese, M Lie, H Ioannidis, Y Kotidis, Y Koubarakis, M Waaler, A Ontology based data access in Statoil |
| title | Ontology based data access in Statoil |
| title_full | Ontology based data access in Statoil |
| title_fullStr | Ontology based data access in Statoil |
| title_full_unstemmed | Ontology based data access in Statoil |
| title_short | Ontology based data access in Statoil |
| title_sort | ontology based data access in statoil |
| work_keys_str_mv | AT kharlamove ontologybaseddataaccessinstatoil AT hovlandd ontologybaseddataaccessinstatoil AT skjævelandmg ontologybaseddataaccessinstatoil AT bilidasd ontologybaseddataaccessinstatoil AT jimenezruize ontologybaseddataaccessinstatoil AT xiaog ontologybaseddataaccessinstatoil AT soylua ontologybaseddataaccessinstatoil AT lantid ontologybaseddataaccessinstatoil AT rezkm ontologybaseddataaccessinstatoil AT zheleznyakovd ontologybaseddataaccessinstatoil AT giesem ontologybaseddataaccessinstatoil AT lieh ontologybaseddataaccessinstatoil AT ioannidisy ontologybaseddataaccessinstatoil AT kotidisy ontologybaseddataaccessinstatoil AT koubarakism ontologybaseddataaccessinstatoil AT waalera ontologybaseddataaccessinstatoil |