Data Integration of Separated Databases Using Schema Based Approach

Abstract

Today, many business applications continue the ongoing creation of separated data stores; data mining often requires data integration for those data. This process becomes significant in a variety of situations both commercial and scientific. The main contribution of data integration system is that user can focus on specifying what data they want rather than on describing how to obtain it. This paper proposes a system for integrated access to data that are related, but exist in separated databases. In this system, a data integration tool is created for different data that are stored in different databases. This system will make integrated access based on participant databases' export schemas by using data dictionary and type dictionary. Each export schema contains information about attributes containing in each database. This system also defines attribute names, attribute types, and attribute length for tables that user wants to integrate and gives integrated results to user.