The Research On Heterogeneous Relational Datasource Integration Based On Web Service

This paper presents a resolution of heterogeneous relational data sources integration of multi-net points based on analysis and research on the nowadays populous integration strategies, helping users to access all the heterogeneous relational data sources in WWW with less cost and high efficiency.The main contributions of the paper are as follows:1. Presenting heterogeneous data sources integration system architecture :combining classical Mediator-Wrapper system architecture and data-cache, realize the plug and play of multi-data sources:access,sql server,mysql ,etc and improves the data access response speed ,we exploit LRU arithmetic to replace the data less used in data-cache;2. Use Web Service to realize the communication between the mediator and wrapper, shielding location differences of data sources in Internet;3. Doing research on java Open-Source application server JBoss, build a message listener of local data sources plug in JBoss, make sure that the change of records in local data sources can be real-time reflected in data cache using less cost and flexible deployment.The meaning of this paper's research is using new technologies (Web Service, JBoss,etc)and novel methods to resolve the location difference and data-cache efficiency problems.