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

more »

... 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 table's 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.