CFP last date
20 January 2025
Reseach Article

Direct Migration Method of RDB to Ontology while Keeping Semantics

by Jamal Bakkas, Mohamed Bahaj, Abderrahim Marzouk
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 65 - Number 3
Year of Publication: 2013
Authors: Jamal Bakkas, Mohamed Bahaj, Abderrahim Marzouk
10.5120/10902-5829

Jamal Bakkas, Mohamed Bahaj, Abderrahim Marzouk . Direct Migration Method of RDB to Ontology while Keeping Semantics. International Journal of Computer Applications. 65, 3 ( March 2013), 6-10. DOI=10.5120/10902-5829

@article{ 10.5120/10902-5829,
author = { Jamal Bakkas, Mohamed Bahaj, Abderrahim Marzouk },
title = { Direct Migration Method of RDB to Ontology while Keeping Semantics },
journal = { International Journal of Computer Applications },
issue_date = { March 2013 },
volume = { 65 },
number = { 3 },
month = { March },
year = { 2013 },
issn = { 0975-8887 },
pages = { 6-10 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume65/number3/10902-5829/ },
doi = { 10.5120/10902-5829 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T21:17:40.400605+05:30
%A Jamal Bakkas
%A Mohamed Bahaj
%A Abderrahim Marzouk
%T Direct Migration Method of RDB to Ontology while Keeping Semantics
%J International Journal of Computer Applications
%@ 0975-8887
%V 65
%N 3
%P 6-10
%D 2013
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The lack of semantic richness is one of the biggest drawbacks of the data stored in the classic relational databases (RDB). This paper provides a method that gives a meaning to these data to serve the semantic web. This method allows a direct and automatic conversion of RDB to ontology, it operates on two levels: The first one is based on the principle of reverse engineering; its purpose is to extract the RDB schema and convert it directly to an ontology model (TBOX). The second level aims to populate the ontology by individuals (ABOX) using data of different records of the RDB and basing on the model of the ontology. Our approach takes into account the relationships established via foreign keys between tables, and the semantic of integrity constraints during the conversion, which allows keeping the consistency and integrity of data.

References
  1. Chimene Fankam, Stephane Jean, and Guy Pierra: "Numeric reasoning in the Semantic Web" In ESWC First International Workshop on Semantic Metadata Management and Applications (SeMMA), volume 346, pages 84–103. CEURWorkshop Proceedings. 2008.
  2. Hondjack Dehainsala, Guy Pierra, and Ladjel Bellatreche: "OntoDB: An Ontology-Based Database for Data Intensive Applications". In Proceedings of the 12th international conference on Database systems for advanced applications, Bangkok, Thailand, April 09-12. 2007
  3. Cristian Pérez de Laborda and Stefan Conrad : "Database to Semantic Web Mapping using RDF Query Languages ". 25th International Conference on Conceptual Modelling, Tucson Arizona. November 2006.
  4. Christian Bizer, Andy Seaborne : "D2RQ – Treating Non-RDF Databases as Virtual RDF Graphs ". In Proceedings of the 3rd International Semantic Web Conference (ISWC2004). 2004.
  5. Christian Bizer : "D2R MAP - A Database to RDF Mapping Language ". In WWW2003, The Twelfth International World Wide Web Conference, Budapest, HUNGARY. Poster presentation. 2003
  6. Martin Šeleng, Michal Laclavík, Zoltán Balogh, Ladislav Hluchý "RDB2Onto: Approach for creating semantic metadata from relational database data". In: Informatics 2007, the ninth international conference on informatics. 2007
  7. Csongor Nyulas, Martin O'Connor and Samson Tu " DataMaster – a Plug-in for Importing Schemas and Data from Relational Databases into Protégé ". In: 10th international Protégé conference. 2007.
  8. Chimene Fankam : "OntoDB2 : Support of Multiple Ontology Models within Ontology Based Database ". In ACM International Conference Proceeding Series. Volume 326, pp. 21-27. 2008
Index Terms

Computer Science
Information Sciences

Keywords

RDB Ontology Mapping Semantic web