Advanced RDB-to-RDF/OWL Mapping Facilities in RDB2OWL

  • Guntars Būmans
  • Kārlis Čerāns
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 90)


We present advanced features of RDB2OWL mapping specification language that allows expressing RDB-to-RDF/OWL mappings in a concise and human comprehensible way. The RDB2OWL mappings can be regarded as documentation of the database-to-ontology relation. The RDB2OWL language uses the OWL ontology structure as a backbone for mapping specification by placing the database link information into the annotations for ontology classes and properties. Its features include reuse of database table key information, user defined scalar and aggregate functions, table-based functions and multiclass conceptualization that is essential to keep mappings compact in case when large tables are mapped onto several classes on the table field value existence basis.


Relational databases RDF OWL ontologies mappings 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Resource Description Framework (RDF),
  2. 2.
  3. 3.
    OWL 2 Web Ontology Language, Structural Specification and Functional-Style Syntax,
  4. 4.
    RDF Vocabulary Description Language 1.0: RDF Schema,
  5. 5.
    Barrasa, J., Corcho, O., Shen, G., Gomez-Perez, A.: R2O: An extensible and semantically based database-to-ontology mapping language. In: SWDB 2004, 2nd Workshop on Semantic Web and Databases (2004)Google Scholar
  6. 6.
  7. 7.
    Blakeley, C.: RDF Views of SQL Data (Declarative SQL Schema to RDF Mapping), OpenLink Software (2007)Google Scholar
  8. 8.
    Hu, W., Qu, Y.: Discovering Simple Mappings Between Relational Database Schemas and Ontologies. In: Aberer, K., Choi, K.-S., Noy, N., Allemang, D., Lee, K.-I., Nixon, L.J.B., Golbeck, J., Mika, P., Maynard, D., Mizoguchi, R., Schreiber, G., Cudré-Mauroux, P. (eds.) ASWC 2007 and ISWC 2007. LNCS, vol. 4825, pp. 225–238. Springer, Heidelberg (2007)CrossRefGoogle Scholar
  9. 9.
    Sequeda, J.F., Cunningham, C., Depena, R., Miranker, D.P. Ultrawrap: Using SQL Views for RDB2RDF. In: Poster Proceedings of the 8th International Semantic Web Conference (ISWC 2009), Chantilly, VA, USA. (2009)Google Scholar
  10. 10.
    Auer, S., Dietzold, S., Lehmann, J., Hellmann, S., Aumueller, D.: Triplify: Light-weight linked data publication from relational databases. In: Proceedings of the 18th International Conference on World Wide Web (2009)Google Scholar
  11. 11.
    R2RML: RDB to RDF Mapping Language,
  12. 12.
    A Direct Mapping of Relational Data to RDF,
  13. 13.
    de Laborda, C.P., Conrad, S.: Database to Semantic Web Mapping Using RDF Query Languages. In: Embley, D.W., Olivé, A., Ram, S. (eds.) ER 2006. LNCS, vol. 4215, pp. 241–254. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  14. 14.
    Bizer, C., Schultz, A.: The R2R Framework: Publishing and Discovering Mappings on the Web. In: 1st International Workshop on Consuming Linked Data (COLD 2010), Shanghai (November 2010)Google Scholar
  15. 15.
    Rikacovs, S., Barzdins, J.: Export of Relational Databases to RDF Databases: A Case Study. In: Forbrig, P., Günther, H. (eds.) BIR 2010. LNBIP, vol. 64, pp. 203–211. Springer, Heidelberg (2010)CrossRefGoogle Scholar
  16. 16.
    Būmans, G., Čerāns, K.: RDB2OWL: Mapping Relational Databases into OWL Ontologies - a Practical Approach. In: Databases and Information Systems: Proc. of the Ninth International Baltic Conference, Baltic DB&IS 2010, Latvia, Riga, July 5-7, pp. 393–408. Riga, University of Latvia, Riga (2010)Google Scholar
  17. 17.
    Čerāns, K., Būmans, G.: RDB2OWL: a RDB-to-RDF/OWL Mapping Specification Language, vol. 224, pp. 139–152. IOS Press, Amsterdam (2011)Google Scholar
  18. 18.
    Bumans, G.: Mapping between Relational Databases and OWL Ontologies: an Example. To Appear in Scientific Papers of University of Latvia, Computer Science and Information Technologies (2010)Google Scholar
  19. 19.
    Būmans, G., Čerāns, K.: RDB2OWL: a Practical Approach for Transforming RDB Data into RDF/OWL. In: Proceedings of the 6th International Conference on Semantic Systems, Graz, Austria, ACM International Conference Proceeding Series, Article No.25 (September 2010); ISBN 9781450300148Google Scholar
  20. 20.
    Barzdins, G., Liepins, E., Veilande, M., Zviedris, M.: Semantic Latvia Approach in the Medical Domain. In: Haav, H.M., Kalja, A. (eds.) Proc. 8th International Baltic Conference on Databases and Information Systems, pp. 89–102. Tallinn University of Technology Press (2008)Google Scholar
  21. 21.
    Barzdins, G., Rikacovs, S., Veilande, M., Zviedris, M.: Ontological Re-engineering of Medical Data-bases. Proc. of the Latvian Academy of Sciences, Section B 63(4/5) (663/664), 20–30 (2009)Google Scholar
  22. 22.
    Barzdins, G., Barzdins, J., Cerans, K.: From Databases to Ontologies, Semantic Web Engineering in the Knowledge Society. In: Cardoso, J., Lytras, M. (eds.) IGI Global, pp. 242–266 (2008) ISBN: 978-1-60566-112-4Google Scholar
  23. 23.
  24. 24.
    Moden, J.: The ”Numbers” or ”Tally” Table: What it is and how it replaces a loop,

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Guntars Būmans
    • 1
  • Kārlis Čerāns
    • 2
  1. 1.Department of ComputingUniversity of LatviaRigaLatvia
  2. 2.Institute of Mathematics and Computer ScienceUniversity of LatviaRigaLatvia

Personalised recommendations