Research on Heterogeneous Data Integration Technology for Personal Public Utility Bills Management Platform

摘要

At present public utility bills systems are independent of each other and data in these systems are heterogeneous. In view of this issue, this paper combines the middleware and Web Service technology to come up with an integrated management platform to integrate heterogeneous data and query public utility bills within one system. After introducing the transformation method between XML schema and relational data models, it uses an XML Schema model as an integrated system framework, transforms the heterogeneous data into a unified XML format. The transformed data will present a unified view in virtual database and provide a consistent view to the application layer, making the upper applications easily access the service. This integration method can shield difference in data structures, make the heterogeneous data sources become transparent to realize the dynamic integration of heterogeneous data in a web environment. This system implements online query, billing, online payment and other functions to achieve the unification of individual utilities information, standardization and shared services.