CN103092873A - XML (Extensive Makeup Language) and Web Service technology based isomerous database integration method - Google Patents

Abstract

The invention discloses an XML (Extensive Makeup Language) and Web Service technology based isomerous database integration method. The XML has the characteristics of being standard, open, plain-text, self-descriptive and extensible; and most databases currently support XML format transformation of data. Therefore, using the XML as a carrier of the data and a bridge of transformation from different formats to the standard format is regarded as a relatively ideal way for unifying data in different formats in the somerous database and realizing conversation among different application programs.

Description

The heterogeneous database integrated approach of a kind of XML-based and Web Service technology

Technical field

The present invention relates to the heterogeneous database integrated approach of an XML-based and Web Service technology, particularly be that XML and WEB SERVERICE integrated combination become a kind of isomerous database access method.

Background technology

What all adopt due to present each application system is different Database Systems, there is very big-difference in data memory format, in order to combine by network transmission and with data from the data in different pieces of information source, need to describe data from the different storage formats in different pieces of information source with a kind of unified data pattern.

XML is the open family of of markup language, utilizes the method that it can the design description data, usually how to process etc. as storage, transmission or program.XML is the meta-language of a descriptive indicia language, it make people can be easily for data definition or expand his Terminology and the structured relations between these terms, the implication that Here it is " can expand " is also the basis of XML.

The desired basic function of dynamic business cooperation and principle have been satisfied in the appearance of Web Service, thereby make Web not only become the platform of information sharing, and become the platform that service is shared.Proposed already application system is abstract in the architectures such as its tangible CORBA and be packaged into the thought of assembly, service, but having compared with traditional distributing mode computer system structure, Web Service advantage is:

(1) Web Service utilizes the Internet agreement (HTTP of standard, SMTP, FTP) solve the Distributed Calculation based on Internet/Intranet, and RMI, the traditional distributed object structure such as CORBA are mainly used in enterprises, are difficult to expand on Internet;

(2) RMI, CORBA, the architectures such as DCOM require just can communicate between peer-to-peer architecture, and namely the application system based on different architecture is can't be co-operating.And Web Service utilizes computer network with standard network protocol and XML form to communicate, and has good universality and dirigibility, and therefore the system of any these standards of support can support Web Service.

SOAP (Simple Object Access Protocol) is to be drafted by DON BOX, and the communications protocol specification supported of the large-scale company such as IBM, Microsoft, SUN, Lotus, HP that obtains.We can know that just it is a kind of communication mechanism that allows the client call remote object serve from the title of SOAP.SOAP calls the form of remote service with the XML standard packaging, be different from the specific format that other Distributed Object Models call, for example the ORPC of the IIOP of CORBA and DCOM.Because SOAP encapsulates call format with XML, so it can transmit with any application layer protocol based on TCP/IP, such as HTTP, TCP or SMTP etc., can with the compatibility of the best degree of the existing communication technology.

In order to realize that the distributed of each database called, need to select a kind of Distributed Object Model, traditional object model such as DCOM (Distributed Component Object Model (DCOM) of Microsoft), CORBA (Common Object Request Broker Architecture of object management group), RMI (remote method invocation (RMI) of SUN) although etc. can call by the complete fraction of realizing remote system, but all require client and service end to have identical architecture, requiring between service itself that service client and system provide must close-coupled; And in the plant information shared system, the operating system of each power plant and database structure are not identical, can't guarantee that called side and the long-range side of being called have same basic structure, called side may be known nothing operating system, database structure and the object model of the long-range side of being called, and therefore can't adopt traditional Distributed Object Model.

Summary of the invention

Based on the problems referred to above, hereby invent the heterogeneous database integrated approach of an XML-based and Web Service technology; XML has standard, opening, plain text, certainly describes, extendible characteristics, and the equal supported data of most database is to the XML format conversion, therefore use XML as the carrier of data, serve as the bridge that different data format transforms to standardized format, the data of unifying the heterogeneous database different-format realize the dialogue between different application.

XML and Web Service have cross-platform characteristic, thereby all can be good at realizing at .NET platform and J2EE platform.Due in most infosystem, what operating system all adopted is windows platform, therefore in concrete exploitation, the Web Service of service layer will adopt the .NET platform, and data Layer Web Service selects .NET platform or J2EE platform according to subordinate's actual conditions.

Specific implementation method

The method general structure design adopts the three-decker mode of client/Web Service middle layer/data Layer, and wherein Web Service middle layer is divided into again Web Service service layer and Web Service data Layer.

(1) client is sent SQL query, and Web Service service layer is that Web Service data Layer is handed in single table inquiry in individual data storehouse with the multiple database query decomposition;

(2) Web Service data Layer is carried out inquiry by database interface and the XML that the result data collection is converted into form up to specification is returned;

(3) Web Service service layer is combined as complete XML data set with a plurality of XML data slots and hands over client to use.

The Web Service of service layer:

(1) authentication module: identifying user identity, could use Web Service after identity validation, and corresponding authority is provided.

(2) global view module: according to user's authority, provide the global view of a virtual global data base for the user, so that the user therefrom selects database, table, the field that can inquire about or safeguard.

(3) share the maintenance of information module: according to user identity, provide and for the information of user's modification and virtual global data base is arrived in amended information updating.

(4) data query module: the SQL query statement of Acceptable criterion to returning to the query results of complete XML form after a plurality of data base queryings, comprises following function sub-modules:

The I.SQL parsing module: will be decomposed into many Simple SQL query statements to the complicated SQL statement of a plurality of databases and a plurality of table inquiry, every statement is the single table query statement for the SNNP of particular data table.

II. enquiry module: the entrance of finding the data Layer Web Service of all databases that will inquire about from virtual global data base, by each data Layer of poll Web Service, SQL statement with after decomposing sends to different data Layer Web Service.

III.XML fragment integration module: a plurality of XML fragments with each data Layer Web Service returns according to relation and field condition between the table of initial SQL statement definition, are reassembled into an XML data set that meets search request.

Data Layer Web Service:

The Web Service of each data Layer is the same method of expression externally, has same method name and parameter type, in order to realize the poll to data Layer Web Service in the Web Service of service layer.Mainly comprise three modules:

(1) SQL translation module: because the defined SQL grammer of the database of different vendor is different, so the SQL statement of standard need to be translated into the SQL grammer that local data base is supported.

(2) enquiry module: accept satisfactory SQL query statement and carry out.

(3) XML generation module: utilize local data bank interface or running environment to the support of XML, Query Result to be converted into XML document.

Claims (2)

1. the heterogeneous database integrated approach of an XML-based and Web Service technology: the method is mainly to utilize advantage in XML and WEBSERVICE to combine to carry out exchanges data.

According to claim 1 XML-based and the heterogeneous database integrated approach of WebService technology, the method adopts the three-decker mode of client/Web Service middle layer/data Layer, and wherein Web Service middle layer is divided into again Web Service service layer and Web Service data Layer.

(1) client is sent SQL query, and Web Service service layer is that Web Service data Layer is handed in single table inquiry in individual data storehouse with the multiple database query decomposition;

(2) Web Service data Layer is carried out inquiry by database interface and the XML that the result data collection is converted into form up to specification is returned;

(3) Web Service service layer is combined as complete XML data set with a plurality of XML data slots and hands over client to use.