An Example Of Solution To Heterogeneous Data Integration

Along with the computer network technology rapid development, the enterprise establishes own in abundance information management system. But as a result of various companies informationization advancement right and wrong synchronization, between cannot mutually the direct exchange data. In addition, enterprise information management system itself also in non-periodically carries on the promotion. As a result of software exploiter generally not to enterprise public code, but between the enterprise and the customer, supplier's data integration must realize. This system unifies this enterprise energy demand analysis, uses cross technologies and so on platform Java, JSP, XML proposes a set of solution.But after the actual demand analysis, existing customer quantity many the single customer service scale quite is generally small, demand randomness is big, we decided uses the existing business management software Kangtai system the backstage database table, uses cross technologies and so on platform Java language, JSP language, JavaBean establishes a dynamic website to collect customer's service demand. When the customer visits this website, may carry on the additional service, the inquiry service, the editor revises, the deletion service operation, reads in the Kangtai software directly the database, then company's operator will carry on the following handling of traffic through the Kangtai software. How regardless of the Kangtai software does promote, so long as its backstage DBMS and the table structure is invariable, the website can adapt the Kangtai software promotion throughout. We hand over the service initial data after the customer input, lightened servicer's data input burden, speaking of the customer realizes on the net to edit own directly service demand, did not use the worry the holiday influence.When realization and boating company's data integration, because the boating companyall has the suitable economic potentiality major industry or the financial group, I take charge of and opposite party service relation am the regularity, long-term, the core business also take here as a key, because various boating companies application software also carries on the promotion frequently, 11 development application program interface does not have the significance in the application software level, therefore we through use the XML middleware technology to solve this problem.Because the profession characteristic is close, in various boating company's database contains the table, the field content are mostly the same except for minor differences, only is the table name, the field name different, the Kangtai database also has the corresponding field naturally. In view of each boating company, we according to the XML documents form which opposite party database can induct, subscribes beforehand for its quantity body makes a set of XSL cascading style sheet. We leave through the SQL order from the Kangtai database Intermediate-range contain the service information the unified form XML documents, transforms with the XSL cascading style sheet it mis boating company to need the form the XML documents, transmits to the boating company, inducts by opposite party operator it the database to carry on again the data processing, this operating procedure biggest merit has overcome the adverse effect which the bilateral software system promotion brings, becomes one kind "all-weather" the interactive method, only is on simple also needs near one step in the operation diligently.The present paper take solves the enterprise the cross platform data exchange as a goal, take does not touch the existing information management system as the principle, respects the existing service operation flow, the goal which the realization enterprise informationization upward downstream extends, has realized and the customer and boating company's non-barrier data exchange.Thus causes inside and outside the enterprise theinformation flow unimpeded to be unimpeded. After the actual use proof, the solution which this article designs may solve the present data exchange difficult problem.