Database to Semantic Web Mapping Using RDF Query Languages

  • Cristian Pérez de Laborda
  • Stefan Conrad
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4215)


One of the main drawbacks of the Semantic Web is the lack of semantically rich data, since most of the information is still stored in relational databases. In this paper, we present an approach to map legacy data stored in relational databases into the Semantic Web using virtually any modern RDF query language, as long as it is closed within RDF. Consequently, a Semantic Web developer does not need to learn and adopt a new mapping language, but he may perform the mapping task using his preferred RDF query language.


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


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    XSL Transformations (XSLT) (1999),
  2. 2.
    Jena - A Semantic Web Framework for Java (2006),
  3. 3.
  4. 4.
  5. 5.
    An, Y., Borgida, A., Mylopoulos, J.: Inferring Complex Semantic Mappings Between Relational Tables and Ontologies from Simple Correspondences. In: Meersman, R., Tari, Z. (eds.) OTM 2005. LNCS, vol. 3761, pp. 1152–1169. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  6. 6.
    Berners-Lee, T., Hendler, J., Lassila, O.: The Semantic Web. Scientific American (May 2001)Google Scholar
  7. 7.
    Bizer, C.: D2R MAP-A Database to RDF Mapping Language. In: WWW 2003, The Twelfth International World Wide Web Conference, Budapest, Hungary (poster presentation, 2003)Google Scholar
  8. 8.
    Bizer, C., Seaborne, A.: D2RQ -Treating Non-RDF Databases as Virtual RDF Graphs. In: The Semantic Web - ISWC 2004: Third International Semantic Web Conference ISWC (2004) (poster presentation)Google Scholar
  9. 9.
    Boag, S., Chamberlin, D., Fernández, M.F., Florescu, D., Robie, J., Siméon, J.: XQuery 1.0: An XML Query Language. W3C Candidate Recommendation (2005),
  10. 10.
    Doan, A., Madhavan, J., Domingos, P., Halevy, A.Y.: Ontology Matching: A Machine Learning Approach. In: Staab, S., Studer, R. (eds.) Handbook on Ontologies. International Handbooks on Information Systems, pp. 385–404. Springer, Heidelberg (2004)Google Scholar
  11. 11.
    Harris, S., Shadbolt, N.: SPARQL Query Processing with Conventional Relational Database Systems. In: Dean, M., Guo, Y., Jun, W., Kaschek, R., Krishnaswamy, S., Pan, Z., Sheng, Q.Z. (eds.) WISE 2005 Workshops. LNCS, vol. 3807, pp. 235–244. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  12. 12.
    Iannella, R.: Representing vCard Objects in RDF/XML. W3C Note (2001),
  13. 13.
    Karvounarakis, G., Christophides, V., Plexousakis, D., Alexaki, S.: Querying RDF Descriptions for Community Web Portals. In: 17èmes Journées Bases de Données Avancées, BDA 2001, Agadir, Maroc, pp. 133–144 (2001)Google Scholar
  14. 14.
    McGuinness, D.L., van Harmelen, F.: OWL Web Ontology Language Overview (2004),
  15. 15.
    Melnik, S.: Storing RDF in a Relational Database (2001),
  16. 16.
    Pan, Z., Heflin, J.: DLDB: Extending Relational Databases to Support Semantic Web Queries. In: PSSS1 - Practical and Scalable Semantic Systems, Proceedings of the First International Workshop on Practical and Scalable Semantic Systems. CEUR Workshop Proceedings, vol. 89 (2003)Google Scholar
  17. 17.
    de Laborda, C.P., Conrad, S.: A Semantic Web based Identification Mechanism for Databases. In: Proceedings of the 10th International Workshop on Knowledge Representation meets Databases (KRDB 2003), Hamburg, Germany, September 15-16, 2003. CEUR, vol. 79, pp. 123–130. RWTH Aachen (2003)Google Scholar
  18. 18.
    de Laborda, C.P., Conrad, S.: Querying Relational Databases with RDQL. In: Eckstein, R., Tolksdorf, R. (eds.) Berliner XML Tage, pp. 161–172 (2005)Google Scholar
  19. 19.
    de Laborda, C.P., Conrad, S.: Relational.OWL - A Data and Schema Representation Format Based on OWL. In: Second Asia-Pacific Conference on Conceptual Modelling (APCCM 2005), Newcastle, Australia. CRPIT, vol. 43, pp. 89–96. ACS (2005)Google Scholar
  20. 20.
    de Laborda, C.P., Conrad, S.: Bringing Relational Data into the Semantic Web using SPARQL and Relational.OWL. In: Semantic Web and Databases, Third International Workshop, SWDB 2006, Co-located with ICDE, Atlanta, USA, April 2006. IEEE Computer Society, Los Alamitos (2006)Google Scholar
  21. 21.
    Petrini, J., Risch, T.: Processing Queries over RDF views of Wrapped Relational Databases. In: 1st International Workshop on Wrapper Techniques for Legacy Systems, WRAP 2004, Delft, Holland (2004)Google Scholar
  22. 22.
    Prud’hommeaux, E., Seaborne, A.: SPARQL Query Language for RDF. W3C Working Draft (2006),
  23. 23.
    Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. VLDB J. 10(4), 334–350 (2001)MATHCrossRefGoogle Scholar
  24. 24.
    Seaborne, A.: RDQL - A Query Language for RDF (2004),

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Cristian Pérez de Laborda
    • 1
  • Stefan Conrad
    • 1
  1. 1.Institute of Computer ScienceHeinrich-Heine-Universität DüsseldorfDüsseldorfGermany

Personalised recommendations