Research On Heterogeneous Database Sharing System Based On Web Services Technology

Database becomes one of the most widely adopted methods by people to manage information. As one of the most fast developed and most extensively used branch of computer science and technology, database has been regarded as the key technology basis and pillar, not only for computer information system, but also computer application system. Among the developing technology of database, isomeric database and relative research is becoming the focus of this research field.During the procedure of enterprise informatization, there are a lot of application system based on various business process and isomeric data source. These systems have their own attributes which can meets the requirement for some specific demand of business, but the data can not be shared between different sub systems. This caused the existence of isolated island of information, which holds back the process of informatization for the corporation. As the growing up of the data source, the total volume of various data also increases on an astonishing rate. However, these data sources are allocated in different networks, serving for specific application, and its management system also differs from one to the others. To better utilize these data information, a uniform and transparent data accessing interface is required by the users to integrate the data from various distributed, isometric and independent data sources, and to block the diversity of different data. At the same time, it needs to also maintain the integrity and conformity of the data when applied in different system.The aggregation and share of the corporate isomeric data sources via network, together with the quality improvement of network information service by utilizing the network resource, is the effective method of eliminating the existence of the"isolated information island". Web Services a newly developed distributed computer technology, it has incomparable advantage over the other technologies in terms of cross-platform aspect, so it can provide powerful technical support for internet-distributed aggregation of isomeric data information.This paper is based on the practical application in projects, discussing about the solution for realization of the aggregation of data between isomeric databases in real corporation cases. A integrated framework of isomeric database based on Web Services technology is adopted and is analyzed to generate a prototype: Super Brand Mall Tenants Integrated Information System. It performs the information exchange between distributed isomeric system by XML and Web Services technology. This system realizes data aggregation by increasing Web Services interfaces, without changing the configuration of the original one.The system includes the following core parts: pre-treatment and standardization of data, aggregated design of isomeric data, mapping from relationship mode to XML mode, mapping from XML mode to relationship mode, building up of Web Services and release of service, and client-side recalling of Web Services and information acceptance. The design of the system is based on the XML and Web Services technology, combining the internal requirement of Super Brand Mall. How to solve the problem of isomeric database relies on the abidance to the united data standard by both the provider and the user, transferring the data in means of calling XML using SOAP over the network. In this paper, I will describe the data standard by Schema method, such as the provide get the data from database, transferring it into XML, XML will then be sent to the user; the user will call for Web Services, receiving XML from the provider, and then perform analyses and the relative data processing. The system in this paper will be integrating the collected various information from the over 100 tenants in Super Brand Mall, inquire and evaluate on flexible basis.