RDB2RDF: completed transformation from relational database into RDF ontology

ABSTRACT

One of the most advantages of the Semantic Web is to augment the data with a well-defined meaning and linking between data by using the RDF ontology language. Today most of data are stored in relational databases. In order to reuse and infer this data on the Semantic Web, there is a need for converting the data stored in relational databases to the form of RDF. Some approaches have been proposed, however, most of them transform a single table into RDF triples. This paper presents RDB2RDF, a complete method to transform all tables in the relational database into RDF ontology. The transformation makes it possible to reverse RDF ontology to relational tables. Most of all, all the steps in RDB2RDF are done automatically without any user intervention.

References

1. Behm A., Geppert A., Dittrich, K. 1997. On the Migration of Relational Schemas and Data to Object-Oriented Database Systems. In Proceeding of the 5th Int. Conference on Re-Technologies for Information Systems (Klagenfurt, December 1997), pp. 13--33.
2. Chiang R., Barron T., Storey V. 1994. Reverse engineering of relational databases: Extraction of an EER model from a relational database. Journal. of Data and Knowledge Engineering, Vol. 12, No. 2, pp. 107--142.
3. Christian Bizer. 2003. D2R Map - A Database to RDF Mapping Language. WWW 2003, Hungary.
4. Edgard Marx, Percy Salas, Karin Breitman, José Viterbo, Marco A. Casanova. 2013. RDB2RDF: A relational to RDF plug-in for Eclipse. Software. Practice Expert, Vol. 43, No. 4, pp. 435--447, doi:10.1002/spe.2145
5. Graham Klyne, Jeremy Carroll. 2002. Resource Description Framework (RDF): Concepts and Abstract Syntax. W3C Working Draft (work in progress). http://www.w3.org/TR/2002/WD-rdf-concepts-20021108/.
6. Huajun Chen, Zhaohui Wu, Heng Wang and Yuxin Mao. 2006. RDF/RDFS-based relational database integration. In Proceedings of the 22nd International Conference on Data Engineering. pp. 94--104.
7. James Hendler, Tim Berners-Lee, Eric Miller. 2002. Integrating Applications on the Semantic Web. Journal of the Institute of Electrical Engineers of Japan, Vol 122(10), p.676--680.
8. Juan Sequeda, Marcelo Arenas, Daniel P. Miranker. 2012. On directly mapping relational databases to RDF and OWL. WWW 2012, 649--658
9. Kate Byrne. 2006. Tethering cultural data with RDF. In Proceedings of the Jena user conference 2006 (JUC2006), UK.
10. Microsoft. 2011. Northwind database. http://northwinddatabase.codeplex.com/
11. Microsoft. 2013. Pubs sample database. http://technet.microsoft.com/en-us/library/aa238305%28v=sql.80%29.aspx.
12. R. Agrawal, A. Somani, and Y. Xu. 2001. Storage and Querying of E-Commerce Data. In Proceedings of VLDB.
13. Rishe N. 1992. Database Design: The Semantic Modeling Approach. McGraw-Hill.
14. S. Alexaki, V. Christophides, G. Karvounarakis, D. Plexousakis & K. Tolle, 2001. On Storing Voluminous RDF Description: The case of Web Portal Catalogs, In Proc. of WebDB2001 in conjunction with ACM SIGMOD'01 Conference.
15. W3C. 2012. R2RML: RDB to RDF mapping language. http://www.w3.org/TR/r2rml/
16. Wikipedia, "Precision and recall", http://en.wikipedia.org/wiki/Precision_and_recall

Index Terms

• Computing methodologies

  • Artificial intelligence

    • Knowledge representation and reasoning

  • Machine learning

    • Learning paradigms

      • Unsupervised learning

        • Cluster analysis

• Theory of computation

  • Logic