Year 2017, Volume 5 , Issue 1, Pages 234 - 239 2017-06-30

EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES

Ylber Januzaj [1] , Samedin Krrabaj [2] , Artan Luma [3] , Arben Hajra [4] , Besnik Selimi [5]


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. 

Linked data, semantic technologies, RDF, Protégé
  • 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.
  • 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.
  • 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.
  • 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.
  • 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 .
  • Adam Jurcik,”Development of Visualization Plug-in for Protege” in Masarykova Univerzita Fakulta In-formatiky, Brno, 2010.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Rai Ghawi, Nadine Cullot, “Database-to-Ontology Mapping Generation for Semantic Interoperability” in Laboratory LE2I, University of Burgundy, Dijon France, 2007.
  • 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.
  • 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.
Subjects Humanities, Multidisciplinary
Journal Section Articles
Authors

Author: Ylber Januzaj

Author: Samedin Krrabaj

Author: Artan Luma

Author: Arben Hajra

Author: Besnik Selimi

Dates

Publication Date : June 30, 2017

Bibtex @research article { pap371665, journal = {PressAcademia Procedia}, issn = {}, eissn = {2459-0762}, address = {Siteler Sok. No.12/18 Maltepe, 34843, Istanbul}, publisher = {PressAcademia}, year = {2017}, volume = {5}, pages = {234 - 239}, doi = {10.17261/Pressacademia.2017.594}, title = {EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES}, key = {cite}, author = {Januzaj, Ylber and Krrabaj, Samedin and Luma, Artan and Hajra, Arben and Selimi, Besnik} }
APA Januzaj, Y , Krrabaj, S , Luma, A , Hajra, A , Selimi, B . (2017). EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES. PressAcademia Procedia , 5 (1) , 234-239 . DOI: 10.17261/Pressacademia.2017.594
MLA Januzaj, Y , Krrabaj, S , Luma, A , Hajra, A , Selimi, B . "EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES". PressAcademia Procedia 5 (2017 ): 234-239 <https://dergipark.org.tr/en/pub/pap/issue/33433/371665>
Chicago Januzaj, Y , Krrabaj, S , Luma, A , Hajra, A , Selimi, B . "EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES". PressAcademia Procedia 5 (2017 ): 234-239
RIS TY - JOUR T1 - EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES AU - Ylber Januzaj , Samedin Krrabaj , Artan Luma , Arben Hajra , Besnik Selimi Y1 - 2017 PY - 2017 N1 - doi: 10.17261/Pressacademia.2017.594 DO - 10.17261/Pressacademia.2017.594 T2 - PressAcademia Procedia JF - Journal JO - JOR SP - 234 EP - 239 VL - 5 IS - 1 SN - -2459-0762 M3 - doi: 10.17261/Pressacademia.2017.594 UR - https://doi.org/10.17261/Pressacademia.2017.594 Y2 - 2020 ER -
EndNote %0 PressAcademia Procedia EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES %A Ylber Januzaj , Samedin Krrabaj , Artan Luma , Arben Hajra , Besnik Selimi %T EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES %D 2017 %J PressAcademia Procedia %P -2459-0762 %V 5 %N 1 %R doi: 10.17261/Pressacademia.2017.594 %U 10.17261/Pressacademia.2017.594
ISNAD Januzaj, Ylber , Krrabaj, Samedin , Luma, Artan , Hajra, Arben , Selimi, Besnik . "EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES". PressAcademia Procedia 5 / 1 (June 2017): 234-239 . https://doi.org/10.17261/Pressacademia.2017.594
AMA Januzaj Y , Krrabaj S , Luma A , Hajra A , Selimi B . EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES. PAP. 2017; 5(1): 234-239.
Vancouver Januzaj Y , Krrabaj S , Luma A , Hajra A , Selimi B . EXPANSION OF A RELATIONAL DATABASE TO SUPPORT SEMANTIC WEB QUERIES. PressAcademia Procedia. 2017; 5(1): 239-234.