Improving response time of database systems by semantification of relational data

Improving response time of database systems by semantification of relational data

New generation web technologies present the new problem of intelligent representation of data in semantically structured systems. In this study, data hosted in a relational database system were converted to a new generation of web technologies (i.e. Web 3.0) with the semantic mapping method and semantification of the data was accomplished. The success of the transformation procedure was verified by a cross-comparison of the data between the relational database and the semantic data repository. By comparing the response time for performing SQL queries and equivalent SPARQL queries such as select, insert, update, and delete, operations hold in the semantic data repository was performed. The results show that the obtained speedup for the above operations on a semantic data repository offers a fetching performance that is at least four times better than that of the relational database system. This study may also be considered as an authentic solution to one of the obstacles in the implementation of the new generation of semantic web technology due to relational data that have not yet been semantified.

___

  • [1] Berners-Lee T, Hendler J, Lassila O. The Semantic Web. Sci Am 2001; 5: 34-43.
  • [2] Pollock JT. Semantic Web for Dummies. Hoboken, NJ, USA: Wiley, 2009.
  • [3] Pandey G. The semantic web: an introduction and issues. International Journal of Engineering Research and Applications 2012; 2: 780-786.
  • [4] Erling O, Mikhailov I. RDF support in the virtuoso DBMS. In: Pellegrini T, Auer S, Tochtermann K, Schaffert S, editors. Networked Knowledge-Networked Media. Berlin, Germany: Springer, 2009. pp. 7-24.
  • [5] Auer S, Dietzold S, Lehmann J, Hellmann S, Aumuelle D. Triplify: light-weight linked data publication from relational databases. In: ACM 2009 International Conference on World Wide Web; 20-24 April 2009; Madrid, Spain. New York, NY, USA: ACM. pp. 621-630.
  • [6] Bumans G. Mapping between relational databases and OWL ontologies: an example. Comput Sci Inf Tech 2010; 756: 99-117.
  • [7] Ullrich, C. Description of an instructional ontology and its application in web services for education. In: ISWC 2004 Workshop on Applications of Semantic Web Technologies for E-learning; 7-11 November 2004; Hiroshima, Japan. Berlin, Germany: Springer, pp. 17-23.
  • [8] Johnson DD, Pearson PD. Teaching Reading Vocabulary. 2nd ed. New York, NY, USA: Holt, Rinehart and Winston, 1984.