Skip to main content

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

  • Conference paper
Perspectives in Business Informatics Research (BIR 2011)

Part of the book series: Lecture Notes in Business Information Processing ((LNBIP,volume 90))

Included in the following conference series:

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Resource Description Framework (RDF), http://www.w3.org/RDF/

  2. SPARQL 1.1 Query Language, http://www.w3.org/TR/2010/WD-sparql11-query-20100601/

  3. OWL 2 Web Ontology Language, Structural Specification and Functional-Style Syntax, http://www.w3.org/TR/2009/REC-owl2-syntax-20091027/

  4. RDF Vocabulary Description Language 1.0: RDF Schema, http://www.w3.org/TR/rdf-schema/

  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. D2RQ Platform, http://www4.wiwiss.fu-berlin.de/bizer/D2RQ/spec/

  7. Blakeley, C.: RDF Views of SQL Data (Declarative SQL Schema to RDF Mapping), OpenLink Software (2007)

    Google Scholar 

  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)

    Chapter  Google Scholar 

  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. 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. R2RML: RDB to RDF Mapping Language, http://www.w3.org/TR/r2rml/

  12. A Direct Mapping of Relational Data to RDF, http://www.w3.org/TR/2011/WD-rdb-direct-mapping-20110324/

  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)

    Chapter  Google Scholar 

  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. 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)

    Chapter  Google Scholar 

  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. Č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. 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. 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 9781450300148

    Google Scholar 

  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. 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. 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-4

    Google Scholar 

  23. OWLGrEd, http://owlgred.lumii.lv/

  24. Moden, J.: The ”Numbers” or ”Tally” Table: What it is and how it replaces a loop, http://www.sqlservercentral.com/articles/T-SQL/62867/

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2011 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Būmans, G., Čerāns, K. (2011). Advanced RDB-to-RDF/OWL Mapping Facilities in RDB2OWL. In: Grabis, J., Kirikova, M. (eds) Perspectives in Business Informatics Research. BIR 2011. Lecture Notes in Business Information Processing, vol 90. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-24511-4_11

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-24511-4_11

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-24510-7

  • Online ISBN: 978-3-642-24511-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics