| With the popularity of database and the Web technology, information management has become the main way of data management in the world. However, the phenomenon of "islands of information" is popular due to several factors. How to share these different data become a hot research topic in computer science and technology.Heterogeneous data sources are data dispersed on the physical or logical, from different sources, which have different formats and characteristics. Data integration technology is to share data among heterogeneous data sources. The RDBMS and XML are complementary because of their respective features and their occasions of application. So the combination of them has become the most common data management solution in the current information systems.Therefore, it is important to solve the data integration of heterogeneous RDBMS. The data integration of heterogeneous RDBMS has the following ihree types:the federated database system, the data warehouse system and the Mediator-Wrapper system. The Mediator-Wrapper system is a kind of middleware system based on mediation models. In this paper, we research the Mediator-Wrapper system architecture, design and implement an e-commerce data integration system using RDBMS as the heterogeneous data sources, XML as the mediation model and XQuery as the XML query language.First, the paper introduces the research background, objectives, significance, the related work of data integration technology and their industrial applications. Second, we study e-commerce data integration technologies, including RDBMS, XML. Then we emphasis on mapping technology between relational data and XML, and proposes an implementation of conversion between RDBMS data and XML document. Finally, we use an e-commerce company’s data integration system as the background, start from the system requirements and complete the design of the system and the implementation of the experimental system. The experimental results and analysis are given in the last. |
PDF Full Text Request