Achieving Heterogeneous Database Integration

The wide usage of computers to keep records systematically has led to a number of different-specific databases to be developed, which is one of the persistent problems the database and information management communities have to deal with. These great number of databases created, has resulted into incompatibility among databases. Thus,this work proposes an approach in solving the problem of interoperability between heterogeneous databases through the alignment of heterogeneous databases. This can be accomplished by determining one to one mapping between database elements, and thereafter reformulates the query in such a way that will be compatible to different database platforms involved. In this regard, this work provides a framework for integrated heterogeneous database using schema matching as an approach, which can be used to reconcile heterogeneous database systems and further enhance automatic interoperability among database systems.The interoperability between databases will be supported without modifying the database or loosing their autonomy.