EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES

Abstract

Nowadays various types of data, especially those with public character, are stored and represented in relational databases. While this way of storing data is a practice for most of the institutions, it turns them into isolated silos with low level of accessibility and interoperability in the web.  Indeed not all datasets are readable from the World Wide Web, therefore to increase their access it is necessary to provide mapping from relational databases to any serialization format of Resource Description Framework (RDF), as one of the best practices for distributing and interlinking data on the web. While there are several ways to accomplish the mapping process, the most appropriate and fastest way is by using the Protégé Plugins application. In this paper we present this mapping method, and describe the complete conversion of a database from SQL Server relational Database to RDF using different scenarios. By using Sesame Repository, as the local repository for our dataset, several SPARQL queries will be generated on top of our data. As a main contribution this paper emphasizes the advantages and performance of querying and using serialized RDF statements versus those stored in the relational databases. 

Keywords

• Linked data,semantic technologies,RDF,Protégé

References

1. Csongor Nyulas, Martin O’Connor and Samson Tu, ”DataMaster – a Plug-in for Importing Schemas and Data from Relational Databases into Protégé,” in Stanford Medical Informatics, Stanford University School of Medicine, Stanford, CA 94305, 2007.
2. Farid Cerbah, “Learning Highly Structured Semantic Repositories from Relational Databases The RDBToOnto Tool” in Dassault Aviation, DPR/ESA, 78 quai Marcel Dassault 92552 Saint-Cloud , France, 2008.
3. Li Ma, Jing Mei, Yue Pan, Krishna Kullkarni, Achille Fokue, Anand Ranganathan, “Semantic Web Technol-ogies and Data Management” in IBM China Research Laboratory, IBM Software Group, Ibm Watson Research Center, Bei Jing 100094, China San Jose, CA, 2012.
4. Juan F. Sequeda, Syed Hamid Tirmizi and Daniel P. Miranker, “SQL Databases are a Moving Target Position Paper for W3C Workshop on RDF Access to Relational Databases” in The University of Texas at Aus-tin, Department of Computer Sciences, Austin, USA, 2007.
5. Simeon Polfliet, Ryutaro Ichise, “Automated Mapping Generation for Converting Databases into Linked Data” in Ensimag engineering school Grenoble Institute of Technology (INPG) Grenoble, France, Principles of Informatics Research Division National Institute of Informatics, Tokyo, Japan, 2010 .
6. Adam Jurcik,”Development of Visualization Plug-in for Protege” in Masarykova Univerzita Fakulta In-formatiky, Brno, 2010.
7. Juan F. Sequeda, Marcelo Arenas and Daniel P. Miranker, “On Directly Mapping Relational Databases to RDF and OWL” in The University of Texas at Austin, PUC Chile, Lyon, France, 2012.
8. Rafael Valencia-García, Francisco García-Sánchez, Dagoberto Castellanos-Nieves, and Jesualdo Tomás Fernández-Breis, ” OWLPath: An OWL Ontology-Guided Query Editor” in Ieee Transactions On Systems, Man, And Cybernetics—Part A: Systems And Humans, 2011.

9. A. Bernstein and E. Kaufmann, “Gino—A guided input natural language ontology editor,” in Proc. Int. Se-mantic Web Conf., vol. 4273, Lecture Notes in Computer Science, I. F. Cruz, S. Decker, D. Allemang, C. Preist, D. Schwabe, P. Mika, M. Uschold, and L. Aroyo, Eds.pp. 144–157, UK, 2006.
10. H. Namgoong and H.-G. Kim, “Ontology-based controlled natural language editor using CFG with lexical dependency” in Proc. ISWC/ASWC, vol. 4825, Lecture Notes in Computer Science, K. Aberer, K.-S. Choi, N. F. Noy, D. Allemang, K.-I. Lee, L. J. B. Nixon, J. Golbeck, P. Mika, D. Maynard, R. Mizoguchi, G. Schreiber, and P. Cudré-Mauroux, Eds., pp. 353–366, Korea, 2007.
11. H.-G. Kim, B.-H. Ha, J.-I. Lee, and M.-K. Kim, “A multi-layered application for the gross description using semantic web technology” in Int. J. Med. Inf., vol. 74, no. 5, pp. 399–407, Hindawi Publishing Corporation, 2005.
12. Lei ZHANG, Jing LI, “Automatic Generation of Ontology Based on Database” in School of Computer Sci-ence and Technology, China University of Mining and Technology, Xuzhou 22111, Jiangsu Province, China, 2012.
13. Rai Ghawi, Nadine Cullot, “Database-to-Ontology Mapping Generation for Semantic Interoperability” in Laboratory LE2I, University of Burgundy, Dijon France, 2007.
14. Nikolaos Konstantinou, Dimitrios-Emmanuel Spanos, Michael Chalas, Emmanuel Solidakis and Nikolas Mitrou,” VisAVis: An Approach to an Intermediate Layer between Ontologies and Relational Database Con-tents” in National Technical University of Athens, Division of Communications, Electronics and Information Systems, Heroon Polytechniou, Athens, Greece, 2006.
15. Martin J. O’Connor, Christian Halaschek-Wiener, Mark A. Musen, “Mapping Master: a Flexible Approach for Mapping Spreadsheets to OWL” in Stanford Center for Biomedical Informatics Research Stanford, USA, 2010.