CFP last date
20 May 2024
Reseach Article

A framework for OWL DL based Ontology Construction from Relational Database using Mapping and Semantic Rules

by C. Ramathilagam, M. L. Valarmathi
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 76 - Number 17
Year of Publication: 2013
Authors: C. Ramathilagam, M. L. Valarmathi
10.5120/13341-0776

C. Ramathilagam, M. L. Valarmathi . A framework for OWL DL based Ontology Construction from Relational Database using Mapping and Semantic Rules. International Journal of Computer Applications. 76, 17 ( August 2013), 31-37. DOI=10.5120/13341-0776

@article{ 10.5120/13341-0776,
author = { C. Ramathilagam, M. L. Valarmathi },
title = { A framework for OWL DL based Ontology Construction from Relational Database using Mapping and Semantic Rules },
journal = { International Journal of Computer Applications },
issue_date = { August 2013 },
volume = { 76 },
number = { 17 },
month = { August },
year = { 2013 },
issn = { 0975-8887 },
pages = { 31-37 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume76/number17/13341-0776/ },
doi = { 10.5120/13341-0776 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T21:48:41.729056+05:30
%A C. Ramathilagam
%A M. L. Valarmathi
%T A framework for OWL DL based Ontology Construction from Relational Database using Mapping and Semantic Rules
%J International Journal of Computer Applications
%@ 0975-8887
%V 76
%N 17
%P 31-37
%D 2013
%I Foundation of Computer Science (FCS), NY, USA
Abstract

World Wide Web (WWW) is capable of retrieving the results only through location finding of search terms, where as Semantic web retrieves by analysing the keywords because of the machine accessible nature of semantic data. One such Semantic data format is Ontology. Ontologies are the web documents generated by Web Ontology Language to provide more precise web content, thus by improving the performance of information retrieval. Semantic web requires data either in terms of manual creation or through conversion from existing data. Ontologies lack semantically rich data because the manual construction of these documents are time consuming and also the domain experts need to understand the syntax and semantics of Ontology development languages. One alternate to compensate for the rich set of data is to take the contents of Relational Data Base (RDB) for domain related applications in the Semantic Web. This is possible by mapping the RDB constructs into Ontology constructs. This paper proposes an RDB to Ontology mapping system framework which can generate an Ontology based on the proposed Mapping Rules for a Banking domain. The Mapping rules are generated both for, 1) direct mapping 2) integrity constraints mapping. Direct mapping is, RDB components like table, attribute, data are mapped to the corresponding Ontology components. Integrity constraints mapping covers primary key, foreign key and column constraints mapped to the relevant Ontology components. This is the direct translation of RDB structure. This paper also proposes additional Semantic Rules for the generated Ontology to provide richer semantics. This in turn provides more expressiveness in Ontology representation and also efficient reasoning power.

References
  1. Grigoris Antoniou and Frank Van Harmelen, 2004, Semantic Web Primer
  2. Silbercharz, Korth, Sudarshan, 2005, Database System Concepts, 4th edition
  3. Shufeng Zhou, Haiyun Ling, Mei Han, Huaiwei Zhang, 2010, Ontology generator from Relational Database Based on Jena, Computer and Information Science
  4. Irina Astrova, Nahum Korda, and Ahto Kalja, 2007, Rule based Transformation of SQL Relational Databases to OWL Ontologies, , World Academy of Science, Engineering and Technology
  5. Quang Trinh, Ken Barker, Reda Alhajj, 2006, RDB2ONT : A tool for generating OWL Ontologies from Relational Database systems, , IEEE
  6. Syed Hamid Tirmizi, Juan Sequeda, and Daniel Miranker, 2008, Translating SQL applications to the Semantic Web, Springer
  7. Zdenka Telnarova, 2010, Relational database as a source of Ontology creation, IEEE
  8. Lei Zhang, Jing Li, 2011, Automatic Generation of Ontology based on Database, Journal of Computational Information Systems
  9. Ouyang Dan-tong, CUI Xian-ji, YE Yu-xin, 2010, Mapping integrity constraint Ontology to Relational databases, The journal of China Universities of Posts and Telecommunication, Elsevier
  10. Ernestas Vysniauskas, Lina Nemuraite, Bronius Paradauskas, 2012, Preserving semantics of OWL2 Ontologies in Relational Databases using Hybrid approach, ISSN 1392, 124X Information Technology And Control, 2012, Vol 41, No. 2
  11. Guntars Bumans, 2010, Mapping between Relational Databases to OWL Ontologies: An example, Computer Science and Information Technologies
  12. Irina Astrova, Ahto Kalja, Nahum Korda 2007, Automatic Transformation of OWL Ontologies to SQL Relational Databases, IADIS European Conference on Data Mining
  13. Raji Ghawi, Nadine Cullot, 2007, Database –to-Ontology mapping generation for Semanitc Interoperability, VLDB'07, ACM
  14. Souripriya Das, Eugene Inseok Chong, George Eadon, Jagannathan Srinivasan, 2004, Supporting Ontology based Semantic matching in RDBMS, VLDB'04
  15. Ernestas Vysniauska, Lina Nemeraite, Rimantas Butleris, Bronius Paradauskas, 2011, Reversible Lossless transformation from OWL2 Ontologies into Relational Databases, Information Technology and Control, Vol 40, ISSN 1392,No 4
  16. Carmen Martinez-Cruz, Ignacio J. Blanco, M. Amparo Vila, 2011, Ontologies versus relational database: are they so different? A comparison, Springer
  17. Ayesha Banu, Syeda Sameen Fatima, Khaleel Ur Rahman Khan, 2011, Semantic-based Querying using Ontology in Relational database of Library Management System, International Journal of Web & Semantic Technology (IJWesT), Vol2, No. 4
  18. Dmitry V. Levshin, 2009, Mapping Relational Databases to the Semantic Web with Original meaning, International Journal of Software Informatics Vol 4, No. 1
  19. Yuan An, Thodoros Topaloglou, 2008, Maintaining Semantic Mappings between Database Schemas and Ontologies, Springer LNCS, Vol 5005
  20. Wei Hu, Yuzhong Qu, 2007, Discovering Simple Mappings between Relational Database Schemas and Ontologies, Springer LNCS, Vol 4825
Index Terms

Computer Science
Information Sciences

Keywords

Semantic web schema mapping Ontology RDF RDFS OWL DL