Data Mining and Knowledge Engineering

Open Access Open Access  Restricted Access Subscription Access
Open Access Open Access Open Access  Restricted Access Restricted Access Subscription Access

Transforming Relational Database to Ontology Using Multiple Tables


Affiliations
1 Department of Computer Applications, S. A. Engineering College, India
     

   Subscribe/Renew Journal


Ontology is a data model for sharing knowledge and the general information on the concept or word. Data are sharable, repeatedly used in ontology. Ontology is a programming language using the database component for triggering and transforming relational database to ontology model to increase the power of data. Ontology is using OWL (WEB ONTOLOGY LANGUAGE) it is like SQL (STRUCTURE QUERY LANGUAGE). Reason for moving relational database to ontology is to map each table to class, each column mapping to the database property and each row are mapping to an instance. It can be used to only move the data. Transforming table is only possible in Relational database to ontology and not use in reverse direction. ONTOLOGY is used for developing the set of data and their structure of data for other programs. Program is solved by the method of application software agent using ontology. Ontology files are stored in relational database for continuing storage of data, so it can avoid the lacking of data. Reason for moving relational database to ontology is mapping of each table to class.


Keywords

Ontology, Relational Database, Tables to Table, Table To Table, Rows and Column, Multiple Tables.
User
Subscription Login to verify subscription
Notifications
Font Size

  • Mona Dadjoo, EsmaeilKherikhah, “An Approach for Transforming of Relational database to OWL Ontology", International Journal of Web & Semantic Technology (IJWest) Vol.6, No.1, January 2015.

  • Irina Astrova, NahumKorda, and AhtoKalja, “Storing OWL Ontologies in SQL Relational Database”, International Journal of Electrical, Computer and Systems Engineering Vol.1ISSN 1307-5179.

  • Su-Cheng Haw,JiaweiMay,Samini Subramanian, “Mapping Relational Database to Ontology Representation A Review”,Permissions@acm.org,ICDTE 17,Aug 6-8,2017Taipei, Taiwan 2017.

  • Aman Achpal, Vinayshekhar Bannihatti Kumar and Kavi Mahesh, “Modelling Ontology Semantic Constraints in Relational Database Management System”, Vol .1, March 2016.

  • DiptikalyanSaha, Avriliaa Floratou, Karthik Sankaranarayanan, UmarFarooq Minhas, Ashish R. Mittal, Fatma Ozcan, “ATHENA: An Ontology-Driven System for Natural Language Querying Over Relational Data Stores”, Vol.9 2016.

  • LeilaZemmouchi- Ghomari, “ Cohabitation of Relational Database and Ontologies in the Semantic Web Context”, Journal of System Integration 2018

  • F.Song, G.Zacharewicz, D.Chen, “An ontology-driven framework towards building enterprise semantic information layer”, Elsevier 2013.

  • J. Bakkas, M.orBahaj, “Generating of RDF graph from a relational database using Jena API”, International Journal of Engineering and Technology, 2013.

  • J. Bakkas, M. Bahaj, A. Marzouk, “Direct Migration Method of RDB to Ontology while Keeping Semantics”. International Journal of Computer Applications (0975 – 8887) Volume 65– No.3, March 2013.

  • Diego Calvanese, Marco Montali, Alifah Syamsiyah, Wil M.P. van der Aalst“Ontology-Driven Extraction of Event Logsfrom Relational Databases”.

  • Irina Astrova, Nahum Korda, and Ahto Kalja, "Rule-Based. Transformation of SQL Relational Databases to OWL Ontologies".

  • Shalom Tsurt and Carlo Zanrolo, "An implementation of GEM, supporting a semantic model on a relational backend".

  • Monika Rani*, Amit Kumar Dhar and O. P. Vyas “Semi-Automatic Terminology Ontology Learning Based on Topic Modeling”.

  • Chun-hua Liao,” Research on Learning OWL Ontology from Relational Database”.

  • Ricardo Giuliani Martini, Giovani Rubert Librelotto, Pedro Rangel Henriques,” Formal Description and Automatic Generation of Learning Spaces based on Ontologies”


Abstract Views: 522

PDF Views: 1




  • Transforming Relational Database to Ontology Using Multiple Tables

Abstract Views: 522  |  PDF Views: 1

Authors

R. Priyanka
Department of Computer Applications, S. A. Engineering College, India
V. Sujatha
Department of Computer Applications, S. A. Engineering College, India

Abstract


Ontology is a data model for sharing knowledge and the general information on the concept or word. Data are sharable, repeatedly used in ontology. Ontology is a programming language using the database component for triggering and transforming relational database to ontology model to increase the power of data. Ontology is using OWL (WEB ONTOLOGY LANGUAGE) it is like SQL (STRUCTURE QUERY LANGUAGE). Reason for moving relational database to ontology is to map each table to class, each column mapping to the database property and each row are mapping to an instance. It can be used to only move the data. Transforming table is only possible in Relational database to ontology and not use in reverse direction. ONTOLOGY is used for developing the set of data and their structure of data for other programs. Program is solved by the method of application software agent using ontology. Ontology files are stored in relational database for continuing storage of data, so it can avoid the lacking of data. Reason for moving relational database to ontology is mapping of each table to class.


Keywords


Ontology, Relational Database, Tables to Table, Table To Table, Rows and Column, Multiple Tables.

References