Export of Relational Databases to RDF Databases by Model Transformations

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


The Semantic Web is a Web of Data. To fulfill this web with data we need methods how to transfer business data from existing relational databases. In most cases, textual mapping languages are used for the specification of correspondences between relational DB schema and OWL ontology. These languages generally are rather awkward and not well-suited for the specification of mappings in cases when there is a substantial semantic gap between the source ER schema and the target OWL ontology. At the same time specification of mappings is a classical use case for graphical model transformation languages. In our previous work [10] we have proposed a new, model transformation-based method for the specification of correspondences between the elements of DB schema and OWL ontology. During practical approbation of this method it became clear that the proposed method can be improved with respect to RAM usage and execution performance. In this paper we describe improvements of the previously proposed method that allows us to overcome these problems.


OWL RDF relational database migration 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Barzdins, G., Rikacovs, S., Veilande, M., Zviedris, M.: Ontological Re-engineering of Medical Databases. Proceedings of the Latvian Academy of Sciences. Section B, 63(4/5) (663/664), 156–158 (2009)Google Scholar
  2. 2.
    Kalnins, A., Barzdins, J., Celms, E.: Model Transformation Language MOLA. In: Aßmann, U., Aksit, M., Rensink, A. (eds.) MDAFA 2003. LNCS, vol. 3599, pp. 62–76. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  3. 3.
    Hillairet, G., Bertrand, F., Lafaye, J.-Y.: MDE for Publishing Data on the Semantic Web. In: Proceedings of the First International Workshop on Transforming and Weaving Ontologies in Model Driven Engineering (TWOMDE 2008), pp. 32–46 (2008)Google Scholar
  4. 4.
    Sahoo, S.S., Halb, W., Hellmann, S., Idehen, K., Thibodeau Jr, T., Auer, S., Ezzat, A.: A survey of current approaches for mapping of relational databases to RDF. Technical report, W3C RDB2RDF Incubator Group (January 2008)Google Scholar
  5. 5.
  6. 6.
    Blakeley, C.: RDF Views of SQL Data (Declarative SQL Schema to RDF Mapping), OpenLink Software (2007)Google Scholar
  7. 7.
    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
  8. 8.
    Sostaks., A., Kalnins, A.: The implementation of MOLA to L3 compiler, Scientific Papers University of Latvia. Computer Science and Information Technologies (2008)Google Scholar
  9. 9.
    Opmanis, M., Cerans K.: JR: A Multilevel Data Repository. In: Proceedings of the 9th International Baltic Conference on Databases and Information Systems (Baltic DB&IS 2010), Riga, Latvia, July 5-7, pp. 375–390 (2010)Google Scholar
  10. 10.
    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
  11. 11.
    Čerāns, K., Būmans, G.: RDB2OWL: a RDB-to-RDF/OWL Mapping Specification Language. In: Barzdins, J., Kirikova, M. (eds.) Proceeding of the 2011, Conference on Databases and Information Systems VI: Selected Papers from the Ninth International Baltic Conference, DB&IS 2010, pp. 139–152. IOS Press, Amsterdam (2011)Google Scholar
  12. 12.
    Request for Proposal:MOF 2.0 Query / Views / Transformations RFP,
  13. 13.
    Vysniauskas, E., Nemuraite, L., Sukys, A.: A Hybrid Approach for Relating OWL 2 Ontologies and Relational Databases. In: Forbrig, P., Günther, H. (eds.) BIR 2010. LNBIP, vol. 64, pp. 86–101. Springer, Heidelberg (2010)CrossRefGoogle Scholar
  14. 14.
    Rikacovs, S.: The base transformation language L0+ and its implementation, Scientific Papers, University of Latvia. Computer Science and Information Technologies, Latvia, Riga, pp. 75–102 (2008)Google Scholar
  15. 15.
    Barzdins, J., Kalnins, A., Rencis, E., Rikacovs, S.: Model Transformation Languages and their Implementation by Bootstrapping Method. LNCS, pp. 130–145. Springer, Heidelberg (2008)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Sergejs Rikacovs
    • 1
  1. 1.Institute of Mathematics and Computer ScienceUniversity of LatviaRigaLatvia

Personalised recommendations