Publishing the Norwegian Petroleum Directorate’s FactPages as Semantic Web Data

  • Martin G. Skjæveland
  • Espen H. Lian
  • Ian Horrocks
Part of the Lecture Notes in Computer Science book series (LNCS, volume 8219)


This paper motivates, documents and evaluates the process and results of converting the Norwegian Petroleum Directorate’s FactPages, a well-known and diverse set of tabular data, but with little and incomplete schema information, stepwise into other representations where in each step more semantics is added to the dataset. The different representations we consider are a regular relational database, a linked open data dataset, and an ontology. For each conversion step we explain and discuss necessary design choices which are due to the specific shape of the dataset, but also those due to the characteristics and idiosyncrasies of the representation formats. We additionally evaluate the output, performance and cost of querying the different formats using questions provided by users of the FactPages.


Relational Database Resource Description Framework Database Schema SPARQL Query Query Answer 
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.


  1. 1.
    Arenas, M., et al. (eds.): A Direct Mapping of Relational Data to RDF. W3C Recommendation (September 2012),
  2. 2.
    Berners-Lee, T.: Linked Data (2006),
  3. 3.
    Calvanese, D., De Giacomo, G., Lembo, D., Lenzerini, M., Poggi, A., Rodriguez-Muro, M., Rosati, R.: Ontologies and Databases: The DL-Lite Approach. In: Tessaris, S., Franconi, E., Eiter, T., Gutierrez, C., Handschuh, S., Rousset, M.-C., Schmidt, R.A. (eds.) Reasoning Web 2009. LNCS, vol. 5689, pp. 255–356. Springer, Heidelberg (2009)CrossRefGoogle Scholar
  4. 4.
    Das, S., Sundara, S., Cyganiak, R. (eds.): R2RML: RDB to RDF Mapping Language (September 2012),
  5. 5.
    FactPages - Norwegian Petroleum Directorate (2013),
  6. 6.
    The W3C SPARQL Working Group (ed.): SPARQL 1.1 Overview. W3C Recommendation (March 2013),
  7. 7.
    Han, L., Finin, T.W., Parr, C.S., Sachs, J., Joshi, A.: RDF123: From Spreadsheets to RDF. In: Sheth, A.P., Staab, S., Dean, M., Paolucci, M., Maynard, D., Finin, T., Thirunarayan, K. (eds.) ISWC 2008. LNCS, vol. 5318, pp. 451–466. Springer, Heidelberg (2008)CrossRefGoogle Scholar
  8. 8.
    Hayes, P.: RDF Semantics. W3C Recommendation. W3C (February 2004),
  9. 9.
    Heath, T., Bizer, C.: Linked Data: Evolving the Web into a Global Data Space, 1st edn. Morgan & Claypool (2011)Google Scholar
  10. 10.
    Klyne, G., Carroll, J.J.: Resource Description Framework (RDF): Concepts and Abstract Syntax. W3C Recommendation. W3C (February 2004),
  11. 11.
    Langegger, A., Wöß, W.: XLWrap – Querying and Integrating Arbitrary Spreadsheets with SPARQL. In: Bernstein, A., Karger, D.R., Heath, T., Feigenbaum, L., Maynard, D., Motta, E., Thirunarayan, K. (eds.) ISWC 2009. LNCS, vol. 5823, pp. 359–374. Springer, Heidelberg (2009)CrossRefGoogle Scholar
  12. 12.
    Motik, B., Patel-Schneider, P.F., Parsia, B. (eds.): OWL 2 Web Ontology Language Structural Specification and Functional-Style Syntax, 2nd edn. W3C Recommendation (December 2012),
  13. 13.
    Motik, B., et al. (eds.): OWL 2 Web Ontology Language Profiles, 2nd edn. W3C Recommendation (December 2012),
  14. 14.
    Perry, M., Herring, J. (eds.): OGC GeoSPARQL - A Geographic Query Language for RDF Data. OGC Implementation Standard (September 2012),
  15. 15.
    Sahoo, S.S., et al.: A Survey of Current Approaches for Mapping of Relational Databases to RDF. Tech. rep. W3C (2009),
  16. 16.
    Spanos, D.-E., Stavrou, P., Mitrou, N.: Bringing relational databases into the Semantic Web: A survey. Semantic Web 3(2), 169–209 (2012)Google Scholar
  17. 17.
    The Norwegian Petroleum Directorate - Norwegian Petroleum Directorate (2011), (accessed April 23, 2013)

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  • Martin G. Skjæveland
    • 1
  • Espen H. Lian
    • 1
  • Ian Horrocks
    • 2
    • 1
  1. 1.Department of InformaticsUniversity of OsloNorway
  2. 2.Department of Computer ScienceUniversity of OxfordUK

Personalised recommendations