APPROACH FOR QUERY IN HETEROGENEOUS DATABASES

Mohammed Qasim Yaseen

Abstract: Developed in the information Tec., data management and multi-database, cloud computing that introduce problem in data integration. The one of data integration problem in database is heterogeneous database query. In the end how can join and representation data from multi-database although the differences in DBMS, Data Structure, and data type. In this research built set of algorithm to retrieval and integration data from databases such as (Oracle, SQL Server) by create virtual tables and join its to solution the heterogeneous in DBMS, Data Structure, and data type problem. system create new scheme for the tables (columns use in query) without all columns in database, after apply condition (on each tables database). This system rather than design a new database with new structure and new virtual programming for coordinated to solve integration data. the system can use also to re-fragmentation tables and re-arrangement fields in tables.

Keywords: federation Databases, Distributed database, Homogenous and Heterogeneous database, Data Integration

DOI: https://doi.org/10.15623/ijret.2017.0603017