A New OWL2 Based Approach for Relational Database Description

Full Text (PDF, 204KB), PP.48-53

Views: 0 Downloads: 0


Naima S. Ougouti 1,* Hafida Belbachir 1 Youssef Amghar 2

1. University of Sciences and Technology of Oran-Mohamed Boudiaf (USTO-MB) Faculty of Mathematics and Computer Science, LSSD Laboratory, Oran, 31000, Algeria

2. LIRIS UMR 5205, Insa of Lyon, 69000, France

* Corresponding author.

DOI: https://doi.org/10.5815/ijitcs.2015.01.06

Received: 27 Apr. 2014 / Revised: 3 Aug. 2014 / Accepted: 17 Sep. 2014 / Published: 8 Dec. 2014

Index Terms

Semantic Web, Ontologies, Relational Databases, Web Ontology Language (OWL2), Schema Representation


Nowadays, the scientific community is more and more interested by the mediation problem within Peer-to-Peer (P2P) systems and by data sources migration within the semantic web. Data integration and interoperability become a necessity to meet the need for information exchange between heterogeneous information systems. They reflects the ability of an information system to collaborate with other systems sometimes of a very different nature and aims at developing architectures and tools for sharing, exchanging and controlling data. In this context we have proposed a new heterogeneous and distributed data management system in a P2P environment called MedPeer. Among this system functions, we have focused in this article on relational databases description through the use of ontologies. We thus propose Relational.OWL2E, a new approach that, starting from the relational schema, generates an ontology based on the OWL2 language. Our main contribution lies in the semantics we have added to relational databases concepts in representing attributes by rich XML schema datatypes, primary keys, unique keys, foreign keys and by associating to each class a set of synonyms in order to guide the process of discovering semantic correspondences.

Cite This Paper

Naïma S. Ougouti, Hafida Belbachir, Youssef Amghar, "A New OWL2 Based Approach for Relational Database Description", International Journal of Information Technology and Computer Science(IJITCS), vol.7, no.1, pp.48-53, 2015. DOI:10.5815/ijitcs.2015.01.06


[1]G. Yang, J. Feng, “Database Semantic Interoperability based on Information Flow Theory and Formal Concept Analysis”, International journal of information technology and computer science, PP.33-42, 2012, DOI: 10.5815/ijitcs.2012.07.05. 

[2]C. Batini, M. Lenzerini and S.B. Navathe, “A Comparative Analysis of Methodologies for Database Schema Integration”, In ACM Computing Surveys, Vol.18, No.4, 1986.

[3]V. Jain , M. Singh, “Ontology Based Information Retrieval in Semantic Web: A Survey”, International journal of information technology and computer science,PP.62-69, 2013, DOI: 10.5815/ijitcs.2013.10.06

[4]N.S. Ougouti, H. Belbachir, Y. Amghar and A.N. Benharkat, “Architecture Of MedPeer : A New P2P-based System for Integration of Heterogeneous Data Sources”, Proceedings of the International Conference on Knowledge Management and Information Sharing (KMIS), Paris,pp. 351-354, 2011.

[5]C. Golbreich and K. Wallace, “OWL2 Web Ontology Language New Features and Rationale”, W3C Recommendation, 2009.

[6]C. Perez de Laborda and S. Conrad, “Relational.OWL – A Data and Schema Representation Format Based on OWL”, Second Asia-Pacific Conference on Conceptual Modelling (APCCM), Newcastle, volume 43 of CRPIT, pp. 89–96. 2005.

[7]D. Dejing, P. LePendu, K. Shiwoong and Q. Peishen, “Integrating Databases into the Semantic Web through an Ontology-Based Framework”, Proceedings of the 22nd International Conference on Data Engineering Workshops (ICDEW’06), Washington, 2006.

[8]Intellidimension Company, “RDF Gateway”, http://www.intellidimension.com, 2000.

[9]T.D.T. Nguyen, “A Dl-Based Approch To Integrate Relational Data Sources Into The Semantic Web”, PHD thesis, Sophia Antipolis university, France 2008.

[10]N. Cullot, R. Ghawi and K. Yetongnon, “DB2OWL: A Tool for Automatic Database to Ontology Mapping”, Proc. of 15th Italian Symposium on Advanced Database Systems (SEBD 2007), Torre Canne, pp. 491-494, 2007.

[11]J. Barrasa, O. Corcho, and A. Gomez-Perez, “R2O, an Extensible and Semantically Based Database-to-Ontology Mapping Language”, Second Workshop on Semantic Web and Databases, 2004.

[12]J.F. Sequeda, S.H. Tirmizi, O. Corcho and D.P. Miranker, “Survey of Directly Mapping Sql Databases to the Semantic Web”, Knowledge Eng. Review, 2012.

[13]M. Arenas, E. Prud’hommeaux, J. Sequeda, “Direct Mapping of Relational Data to RDF”, W3C Working, 2011.

[14]I. Astrova, N. Korda, and A. Kalja, “Rule-Based Transformation of SQL Relational Databases to OWL Ontologies” , 2nd International Conference on Metadata & Semantic Research, 2007.

[15]F. Barbancon and D. P. Miranker, “SPHINX: Schema integration by example”, Journal of Intelligent Information Systems , 29 (2), 2007.