In this paper we start with a brief summary of the existing approaches commonly used in heterogeneous database integration followed by a new and unique approach of integration of heterogeneous databases based on XML. Compared to conventional models, this model is simple, efficient and cost effective and hence can be widely used in businesses spread across multiple locations. | ISSN:2249-5789 Venciya A , International Journal of Computer Science & Communication Networks,Vol 4(6),216-220 Integration of Heterogeneous Databases based on XML Student, Department Of Computer Science And Engineering, SRM University,Kattankulathur, Abstract As companies grow bigger and bigger the need to integrate data stored across the various departments becomes crucial for the proper functioning of the company as a whole. In this paper we start with a brief summary of the existing approaches commonly used in heterogeneous database integration followed by a new and unique approach of integration of heterogeneous databases based on XML. Compared to conventional models, this model is simple, efficient and cost effective and hence can be widely used in businesses spread across multiple locations. Keywords: XML, Heterogeneous database, Template Mapping, Model Mapping, Data Type Mapping. 1. Introduction. With the rapid growth of technology and the constant need to derive information through processing of data, many enterprises are currently facing the problem of sharing data across its various departments. Most industries start as a small-scale project with a single department but as the necessity to extend the functionality of the organization and establish various other inter-related departments arise; they face various challenges in integrating databases across multiple sources. The isolated database that was once sufficient to run the company is no longer effective in compiling data across the different departments or geographical location of the organization. For example, initially the company spends a lot of money developing a well operated financial, production and management system but these systems are developed by the company at different times, the platforms used are also different. This leads to increasingly isolated chunks of data that requires a common platform in order to be converted into a processed form. Thus there
