Architecture for Accessing Heterogeneous Databases

Full Text (PDF, 458KB), PP.25-31

Views: 0 Downloads: 0


Mohd Kamir Yusof 1,* Ahmad Faisal Amri Abidin 1 Mohd Nordin Abdul Rahman 1

1. Faculty of Informatics, Universiti Sultan Zainal Abidin, Terengganu, Malaysia

* Corresponding author.


Received: 3 Apr. 2011 / Revised: 10 Aug. 2011 / Accepted: 3 Oct. 2011 / Published: 8 Feb. 2012

Index Terms

Heterogeneous Database, Data warehouse, Ontology, Semantic Web, Web query processing


This paper presents the architecture for accessing heterogeneous databases. Two major processes in this architecture which are extracting SQL statement and ontology. The algorithms for extracting SQL statement was created and tested in order to improve time performance during searching and retrieving process. Ontology approach was implemented and combined with these algorithms. In ontology approach, web semantic was implemented in order to retrieve only relevant data from database. A prototype based on this architecture was developed using JAVA technology. JAVA technology was chosen because this technology have Jena library. This library is provide API and support SPARQL. Several experiments have been executed and tested. The result indicates this architecture able to improve web query processing in term of time. The result also indicates this architecture able to retrieve and displayed more relevant data to web users.

Cite This Paper

Mohd Kamir Yusof, Ahmad Faisal Amri Abidin, Mohd Nordin Abdul Rahman, "Architecture for Accessing Heterogeneous Databases", International Journal of Information Technology and Computer Science(IJITCS), vol.4, no.1, pp.25-31, 2012. DOI:10.5815/ijitcs.2012.01.04


[1]J.Hartman et. al. Ontology based query refinement for semantic portal, in: integrated publication and information system to virtual information and knowledge environment 2005, 2005, pp. 41-50

[2]Samuel Robert Collins, Shamkant Navathe, Leo Mark. XML schema mapping for heteregeneous database access. Information and Software Technology 44(2002), 251-257.

[3]Eui Kyu Park, Dong Yul Ra, Myung Gil Jang. Techniques for Imrpoving Web Retrieval Effectiveness. Information Processing and Management 41(2005), 1207 – 1233.

[4]B. Velez et al. Fast and effective query refinement, in: Proceeding of the 20th annual international ACM SIGIR Conference on Research Development in Information Retrieval, 1997, pp. 6-15.

[5]Timothy J. Miles-Board. Everything Integrated: A Framework for Associative Writing in the Web”, February 2004, University of Southampton.

[6]Jie Cao, Wen Hou, Tingyou Cai. Research of Heterogeneous Database Integration System Based on E-Business, IEEE 2008, 186-189.

[7]Jordi Coness, Veda C.Storey, Vijayan Sugumaran. Improving web-query processing through semantic web knowledge. Data & Knowledge Engineering 66 (2008), 18-34.

[8]Matthias Butenuth, Guido V. Gosseln, Michael Tiedge, Christian Heipke, Udo Lipeck, Monika Sester. Integration of Heterogeneous Geospatial Data in a Federated Database. Journal of Photogrammetry & Remote Sensing 62(2007), 328 – 346.

[9]Walter Sujansky. Heterogeneous Database Integration in Biomedicine. Journal of Biomedical Informatics 34(2001), 285 – 298.

[10]Mostafa E.Saleh. Semantic-Based Query in Relational Database Using Ontology, Canadian Journal on Data, Information and Knowledge Engineering, Vol. 2, No 1, January 2011, pp: 1-16.

[11]Carole Goble, Robert Stevens. State of the Nation in Data Integration for Bioinformatics. Journal of Informatics 41(2008), 687 – 693.

[12]Shi Ming Huang, Tung-Hsiang Chou, Jia-Lang Seng. Data warehouse enhancement: A semantic cube model approach. Information Science 177 (2007), 2238 – 2254.

[13]Jia Lang Seng, I.L Kong. A Schema and Ontology Aided Intelligent Information Integration. Expert System with Application 36(2009), 10538 – 10550.

[14]M. Bright, A. Hurson, S. Pakzad. A taxanomy and current issues in multidatabase system, IEEE Computer 25(3) (1992), 50-60.