Design And Implementation Of Enterprise Heterogeneous Data Integration&Query System Based On XML

The enterprise business is an important everyday task in Administration for Industry&Commerce and the Bank sector. Because of the application system is independent between the two units, so there is not an integrated query platform which forms a unified set of data between Administration for Industry&Commerce and the Bank.The thesis realizes the integration of heterogeneous database by XML based on the current enterprise information integration between Administration for Industry&Commerce and the Bank, forming a unified database which achieves enterprise unified shared information. Then the staffs of two units have a comprehensive understanding of the current enterprise information, screening the false, expired paper material which provided important basis for two units. So that improve the work effectively, efficiency, reduce risk and realize the office of preciseness and justice. The thesis research on heterogeneous data integration and exchange technology based on the XML document, designs the route of data integration process of the system by the analysis of application requirements of Administration for Industry&Commerce and the Bank. The thesis designs the mapping and transformation model between database and the documents between the XML by the relational database with XML technology, and design the heterogeneous data integration algorithm by the XML-QL query language. The thesis designs the data source integration route, designs Use case diagram、Activity diagram、Class diagram、Sequence diagram of the Enterprise Information Queries、Annual Inspection and Information Queries、Industrial&Business Enterprises Blacklist Queries、Corporate Capital&Credit Queries and system logic structure diagram and system function module.Finally, according to system design, the thesis implements enterprise heterogeneous data integration by XML based on requirement of two units by J2EE technology. After the test, the function of the system can achieved system design target and meet the Administration for Industry&Commerce and the Bank handling the daily business work demand, improve the level of information sharing.