Configurable docking method for computing software database
1. A method of computing software database configurable docking, comprising the steps of:
s1, mode registration: storing the XML modes in the source database and the target database into an XML mode library of a central database;
s2, pattern matching: the user appoints the corresponding relation between the source XML mode and the target XML mode, and requests the central database to complete the XML mode matching of both data exchange sides;
s3, data exchange: and completing data exchange between the source database and the target database.
2. The method for configurable docking of computing software database according to claim 1, wherein in said step S2, the method comprises the following steps:
s201, a target database sends a pattern matching request to a central database;
s202, the central database inquires and returns all available XML mode name lists of the source data source and the target data source in the XML mode library according to the data source name in the request;
s203, the target party database selects the XML mode name list of the two parties to be carried out
The XML mode of data exchange, and send XML mode name of both sides to the central database as the parameter;
s204, the central database queries and returns the source XML mode document and the target XML mode document from the XML mode library of the central database according to the XML mode name in the request;
s205, the target database receives a source XML mode document and a target XML mode document;
s206, the target party database requests the central database to complete the matching of the XML modes of the two parties.
3. The method of claim 2, wherein in step S205, after receiving the source XML schema document and the target XML schema document, the target database displays the XML schemas of both parties in the application interface in a tree form, and a user determines a corresponding relationship between the XML schemas of both parties.
4. The method of claim 2, wherein in step S206, the matching result is a matching rule document.
5. The method according to claim 2, wherein in step S206, after completing the matching between the XML schemas of the two parties, the generated matching rule document is stored in the rule base of the central database.
6. The method for configurable docking of computing software database according to claim 1, wherein in said step S3, the method comprises the following steps:
s301, calling a data exchange service of a central database by a target database, and initiating a data exchange request;
s302, the central database requests the database of the source party to obtain an XML data document of the source party;
s303, the source database extracts data from the database according to the request of the central database and returns the data to the central database;
s304, the central database converts the returned source XML data document into a target XML data document;
s305, after the target side database receives the target XML data document, storing the data in the target XML data document into the database.
7. The method of claim 6, wherein in step S303, when data is extracted from the database, the extracted data is packaged into a source XML data document.
8. The method of claim 6, wherein in step S304, the central database extracts the matching rule document between the source XML schema and the target XML schema from the matching rule library as a basis for data exchange, and converts the returned source XML data document into the target XML data document under the action of the matching rule document.
Background
With the rapid development of network communication and information industry, the amount of information data is increasing explosively, and database technology is widely used. Many enterprises, institutions, and organizations have progressively enabled computerized management of information. Most information data are stored by a database. However, due to different application requirements, the selected system operating environment and the used database model have various differences, so that the data sources are different, a huge heterogeneous database environment is formed, and an information island is also formed. The information isolated island refers to computer application systems which are not related and mutual aid in function, information is not shared and exchanged, and information, service flow and application are mutually disjointed.
Although the dynamic management method and device for data docking provided by the patent document have a certain data docking effect, the docking effect is not good, and meanwhile, heterogeneous data conflicts occur during use, so that the switching device has problems in flexibility and cannot meet the use requirements of users.
In summary, the development of a configurable docking method for a computing software database remains a key problem to be solved urgently in the technical field of database docking.
Disclosure of Invention
Aiming at the defects in the prior art, the invention provides a configurable docking method for a computing software database, which comprises the steps of respectively creating a local XML (extensive Makeup language) mode by a source party and a destination party according to a relation mode, then carrying out heterogeneous database exchange of data between the two XML modes, separating the conversion process between the relation data and the XML data from the data process for eliminating heterogeneous conflicts between the two XML modes, reducing the realization difficulty, fully loosening and combining the two exchange parties due to the self-defining of the XML modes for data exchange by the source party and the destination party, and effectively improving the flexibility and reusability of data exchange.
In order to achieve the purpose, the invention provides the following technical scheme:
a method of computing software database configurable docking, comprising the steps of:
s1, mode registration: and storing the XML schema in the source database and the target database into an XML schema library of the central database.
S2, pattern matching: the user designates the corresponding relation between the source XML mode and the target XML mode, and requests the central database to complete the XML mode matching of both data exchange sides.
S3, data exchange: and completing data exchange between the source database and the target database.
The invention is further configured to: in the step S2, the method includes the steps of:
s201, the target database sends a pattern matching request to the central database.
S202, the central database inquires and returns all available XML mode name lists of the source data source and the target data source in the XML mode library according to the data source name in the request.
S203, the target database selects the XML schema needing data exchange from the XML schema name lists of the two parties, and sends the XML schema names of the two parties as parameters to the central database.
And S204, the central database inquires and returns the source XML mode document and the target XML mode document from the XML mode library of the central database according to the XML mode name in the request.
S205, the target side database receives the source XML mode document and the target XML mode document.
S206, the target party database requests the central database to complete the matching of the XML modes of the two parties.
The invention is further configured to: in step S205, after receiving the source XML schema document and the target XML schema document, the target database displays the XML schemas of both parties in the application interface in a tree form, and the user determines the corresponding relationship between the XML schemas of both parties.
The invention is further configured to: in the step S206, the result of the matching is a matching rule document.
The invention is further configured to: in step S206, after completing the matching between the XML schemas of the two parties, the generated matching rule document is stored in the rule base of the central database.
The invention is further configured to: in the step S3, the method includes the steps of:
s301, the target database calls the data exchange service of the central database, and a data exchange request is initiated.
S302, the central database requests the database of the source side to obtain the XML data document of the source side.
And S303, the source database extracts data from the database according to the request of the central database and returns the data to the central database.
S304, the central database converts the returned source XML data document into a target XML data document.
S305, after the target side database receives the target XML data document, storing the data in the target XML data document into the database.
The invention is further configured to: in step S303, when data is extracted from the database, the called data is packaged into a source XML data document.
The invention is further configured to: in step S304, the central database extracts a matching rule document between the source XML schema and the target XML schema from the matching rule library as a basis for data exchange, and converts the returned source XML data document into the target XML data document under the action of the matching rule document.
Advantageous effects
Compared with the known public technology, the technical scheme provided by the invention has the following beneficial effects:
the invention stores XML modes in a source database and a target database into an XML mode database of a central database, a corresponding relation between the source XML mode and the target XML mode is appointed by a user, the central database is requested to complete XML mode matching of two data exchange sides, data exchange between the source database and the target database is completed, a source side and a target side respectively establish a local XML mode according to the relation mode, then a heterogeneous database exchange scheme of data is carried out between the two XML modes, a conversion process between the relation data and the XML data is separated from a data process for eliminating heterogeneous conflicts between the two XML modes, the realization difficulty can be reduced, and the source side and the target side can define the XML mode for data exchange, the two exchange sides are fully loose and conflicted, and the flexibility and reusability of data exchange are effectively improved.
Drawings
FIG. 1 is a flow chart of a method of computing a configurable docking of a software database;
FIG. 2 is a flow chart of a second step in a method of computing configurable docking of a software database;
FIG. 3 is a flow chart of step three of a method of computing a configurable docking of a software database.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below. It is to be understood that the embodiments described are only a few embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The present invention will be further described with reference to the following examples.
Example 1
Referring to fig. 1-3, fig. 1 is a flowchart illustrating a method for configurable docking of a computing software database, fig. 2 is a flowchart illustrating a second step in the method for configurable docking of the computing software database, fig. 3 is a flowchart illustrating a third step in the method for configurable docking of the computing software database, and the method for configurable docking of the computing software database includes the following steps:
step one, mode registration: and storing the XML schema in the source database and the target database into an XML schema library of the central database.
Step two, pattern matching: the user designates the corresponding relation between the source XML mode and the target XML mode, and requests the central database to complete the XML mode matching of both data exchange sides.
The method comprises the following steps:
201) and the target database sends a pattern matching request to the central database.
202) And the central database inquires and returns a name list of all available XML modes of the source data source and the target data source in the XML mode library according to the name of the data source in the request.
203) And the target party database selects the XML modes needing data exchange from the XML mode name lists of the two parties, and sends the XML mode names of the two parties as parameters to the central database.
204) And the central database inquires and returns the source XML mode document and the target XML mode document from the XML mode library of the central database according to the XML mode name in the request.
205) And the target side database receives the source XML schema document and the target XML schema document.
206) And the target party database requests the central database to complete the matching of the XML modes of the two parties.
After receiving the source XML schema document and the target XML schema document, the target side database displays the XML schemas of the two sides in a tree form in an application interface, and a user determines the corresponding relation between the XML schemas of the two sides.
The result of the matching is a matching rule document.
And after the XML modes of the two parties are matched, storing the generated matching rule document into a rule base of the central database.
Step three, data exchange: and completing data exchange between the source database and the target database.
The method comprises the following steps:
301) and calling the data exchange service of the central database by the target database, and initiating a data exchange request.
302) And the central database requests the database of the source side to obtain the XML data document of the source side.
303) And the source side database extracts data from the database according to the request of the central database and returns the data to the central database.
304) And the central database converts the returned source XML data document into a target XML data document.
S305), after the target side database receives the target XML data document, storing the data in the target XML data document into the database.
And when data is extracted from the database, packaging the called data into a source XML data document.
The central database extracts a matching rule document between the source XML mode and the target XML mode from the matching rule base to serve as a basis of data exchange, and the returned source XML data document is converted into the target XML data document under the action of the matching rule document.
The invention stores XML modes in a source database and a target database into an XML mode database of a central database, a corresponding relation between the source XML mode and the target XML mode is appointed by a user, the central database is requested to complete XML mode matching of two data exchange sides, data exchange between the source database and the target database is completed, a source side and a target side respectively establish a local XML mode according to the relation mode, then a heterogeneous database exchange scheme of data is carried out between the two XML modes, a conversion process between the relation data and the XML data is separated from a data process for eliminating heterogeneous conflicts between the two XML modes, the realization difficulty can be reduced, and the source side and the target side can define the XML mode for data exchange, the two exchange sides are fully loose and conflicted, and the flexibility and reusability of data exchange are effectively improved.
The above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not depart from the spirit and scope of the corresponding technical solutions.
- 上一篇:石墨接头机器人自动装卡簧、装栓机
- 下一篇:多云异构数据处理方法、装置及电子设备