Skip to main content
SpringerLink
Log in

Database to Ontology Mapping Patterns in RDB2OWL Lite

  • Conference paper
  • First Online:
Databases and Information Systems (DB&IS 2016)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 615))

Included in the following conference series:

Abstract

We describe the RDB2OWL Lite language for relational database to RDF/OWL mapping specification and discuss the architectural and content specification patterns arising in mapping definition. RDB2OWL Lite is a simplification of original RDB2OWL with aggregation possibilities and order-based filters removed, while providing in-mapping SQL view definition possibilities. The mapping constructs and their usage patterns are illustrated on mapping examples from medical domain: medicine registries and hospital information system. The RDB2OWL Lite mapping implementation is offered both via translation into D2RQ and into standard R2RML mapping notations.

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

Access this chapter

Log in via an institution
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 EPUB and 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

Notes

  1. 1.

    We use rdb2owl:DBExpr as the annotation property, where rdb2owl:   =   < http://rdb2owl.lumii.lv/2012/1.0/rdb2owl# >.

  2. 2.

    The ontology editor can be downloaded from http://owlgred.lumii.lv/ .

  3. 3.

    The ontology with annotations in a standard OWL RDF/XML format is available at http://rdb2owl.lumii.lv/demo/UnivExample.owl .

  4. 4.

    http://rdb2owl.lumii.lv/.

  5. 5.

    http://d2rq.org/.

References

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

  2. Motik, B., Patel-Schneider P.F., Parsia B. (eds.): OWL 2 Web Ontology Language Structural Specification and Functional-Style Syntax (2009). https://www.w3.org/TR/2009/REC-owl2-syntax-20091027/

  3. Linked Data. http://linkeddata.org

  4. Berners-Lee, T., Hendler, J., Lassila, O.: The semantic Web. Sci. Am. 5, 29–37 (2001)

    Google Scholar 

  5. D2RQ. Accessing Relational Databases as Virtual RDF Graphs. http://d2rq.org/

  6. Blakeley, C.: RDF views of SQL data (declarative SQL schema to RDF mapping). OpenLink Software (2007)

    Google Scholar 

  7. 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 (ISWC2009), Chantilly, VA, USA (2009)

    Google Scholar 

  8. Revelytix Spyder Tool. http://www.revelytix.com/content/spyder

  9. R2RML: RDB to RDF Mapping Language. http://www.w3.org/TR/r2rml/

  10. Calvanese, D., Cogrel, B., Komla-Ebri, S., Lanti, D., Rezk, M., Xiao, G.: How to stay ontop of your data. In: Databases, Ontologies and More. ESWC (Satellite Events), pp. 20–25 (2015)

    Google Scholar 

  11. Čerāns, K., Būmans, G.: RDB2OWL: a RDB-to-RDF/OWL mapping specification language. In: Barzdins, J., Kirikova, M. (eds.), Databases and Information Systems VI, IOS Press, pp. 139–152 (2011)

    Google Scholar 

  12. Būmans, G., Čerāns, K.: Advanced RDB-to-RDF/OWL mapping facilities in RDB2OWL. In: Grabis, J., Kirikova, M. (eds.) BIR 2011. LNBIP, vol. 90, pp. 142–157. Springer, Heidelberg (2011)

    Chapter  Google Scholar 

  13. SPARQL 1.1 Overview. W3C Recommendation, 21 March 2013. http://www.w3.org/TR/sparql11-overview/

  14. Čerāns, K.; Ovčiņņikova, J., Zviedris, M.: SPARQL aggregate queries made easy with diagrammatic query language ViziQuer. In: Proceedings of ISWC 2015 PD. http://ceur-ws.org/Vol-1486/paper_68.pdf

  15. R2RML Parser . https://github.com/nkons/r2rml-parser

  16. Barzdins, G., Liepins, E., Veilande, M., Zviedris, M.: Semantic latvia approach in the medical domain. In: Proceedings of 8th International Baltic Conference on Databases and Information Systems. Haav, H.M., Kalja, A. (eds.), pp. 89–102. TUT Press (2008)

    Google Scholar 

  17. Čerāns, K., Barzdins, G., Būmans, G., Ovcinnikova, J., Rikacovs, S., Romane, A., Zviedris, M.: A relational database semantic re-engineering technology and tools. Baltic J. Mod. Comput. (BJMC) 3(3), 183–198 (2014)

    Google Scholar 

  18. Barzdins, J., Rencis, E., Sostaks, A.: Fast ad hoc queries based on data ontologies. In: Frontiers in Artificial Intelligence and Applications, Databases and Information Systems VIII, vol. 270, pp. 43–56. IOS Press (2014)

    Google Scholar 

  19. Barzdins, J., Barzdins, G., Cerans, K., Liepins, R., Sprogis, A.: OWLGrEd: a UML style graphical notation and editor for OWL 2. In: Proceedings of OWLED 2010 (2010)

    Google Scholar 

  20. Čerāns, K., Ovčiņņikova, J., Liepiņš, R., Sproģis, A.: Advanced OWL 2.0 ontology visualization in OWLGrEd. In: Caplinskas, A., Dzemyda, G., Lupeikiene, A., Vasilecas, O. (eds.) Databases and Information Systems VII, Frontiers in Artificial Intelligence and Applications, vol. 249, pp. 41–54. IOS Press (2013)

    Google Scholar 

  21. Čerāns, K., Būmans, G.: RDB2OWL: a language and tool for database to ontology mapping. In: Proceedings of CAiSE FORUM (2015). http://ceur-ws.org/Vol-1367/paper-11.pdf

  22. Zviedris, M., Barzdins, G.: ViziQuer: a tool to explore and query SPARQL endpoints. In: Antoniou, G., Grobelnik, M., Simperl, E., Parsia, B., Plexousakis, D., De Leenheer, P., Pan, J. (eds.) ESWC 2011, Part II. LNCS, vol. 6644, pp. 441–445. Springer, Heidelberg (2011)

    Chapter  Google Scholar 

  23. Zviedris, M., Romane, A., Barzdins, G., Cerans, K.: Ontology-based information system. In: Kim, W., Ding, Y., Kim, H.-G. (eds.) JIST 2013. LNCS, vol. 8388, pp. 33–47. Springer, Heidelberg (2014)

    Chapter  Google Scholar 

Download references

Acknowledgements

This research has been supported by Latvian State Research program (2014-2017) NexIT project No. 1 ‘Technologies of ontologies, semantic web and security’.

Author information

Authors and Affiliations

  1. Institute of Mathematics and Computer Science, University of Latvia, Raina Blvd. 29, Riga, LV-1459, Latvia

    Kārlis Čerāns & Guntars Būmans

Authors
  1. Kārlis Čerāns
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Guntars Būmans
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Kārlis Čerāns .

Editor information

Editors and Affiliations

  1. University of Latvia, Riga, Latvia

    Guntis Arnicans

  2. University of Latvia, Riga, Latvia

    Vineta Arnicane

  3. University of Latvia, Riga, Latvia

    Juris Borzovs

  4. University of Latvia, Riga, Latvia

    Laila Niedrite

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Čerāns, K., Būmans, G. (2016). Database to Ontology Mapping Patterns in RDB2OWL Lite. In: Arnicans, G., Arnicane, V., Borzovs, J., Niedrite, L. (eds) Databases and Information Systems. DB&IS 2016. Communications in Computer and Information Science, vol 615. Springer, Cham. https://doi.org/10.1007/978-3-319-40180-5_3

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-40180-5_3

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-40179-9

  • Online ISBN: 978-3-319-40180-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation