XML-Based Heterogeneous Database Integration For Data Warehouse Creation
Frank S. C. Tseng · Journal of the Association for Information Systems · 2005
In the past decade, research works in heterogeneous database integration have established a good and solid framework to alleviate this task.However, there are still works need to be accomplished to bring these achievements to be easily implemented and integrated to Internet applications.In this paper, by employing the metadata of participate sites, we propose using XML, together with XSLT, as a general platform to achieve this task.We first define the formal definitions for the problems of semantic conflicts among heterogeneous databases and present their solutions.Then, some illustrative examples are presented to show that, by requesting local sites to transform the data into XML format and prepare the corresponding XSLT files on the global site, various kinds of schema integration problems can be unified and integrated into a global view seamlessly.The proposed methodology is not only suitable for heterogeneous database integration, but is also suitable for data warehouse creation and World-Wide Web presentation.