CN102521318A - General data exchange device based on extensible markup language (XML) - Google Patents
General data exchange device based on extensible markup language (XML) Download PDFInfo
- Publication number
- CN102521318A CN102521318A CN2011103960269A CN201110396026A CN102521318A CN 102521318 A CN102521318 A CN 102521318A CN 2011103960269 A CN2011103960269 A CN 2011103960269A CN 201110396026 A CN201110396026 A CN 201110396026A CN 102521318 A CN102521318 A CN 102521318A
- Authority
- CN
- China
- Prior art keywords
- module
- xml
- data
- mentioned
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a general data exchange device based on an extensible markup language (XML). The general data exchange device is characterized by comprising a database (DB) 2 XML module and an XML2DB module, wherein the DB2XML module is used for importing data in an original system and generating an XML document; the XML2DB module is used for importing the XML document which is generated by the DB2XML module into a database of a new system; and the DB2XML module is connected with the XML2DB module. By adoption of the general data exchange device based on the XML, when a database table interface of the new system is not compatible with a database interface of the original system during upgrading or replacement of the system, by using the characteristic that the XML is a data description language which is widely used in a network, XML data serve as intermediate data, and data import and export interfaces of the XML and the database are provided, so that the problem that a source database interface is not compatible with a destination database interface is effectively solved, and inter-system seamless migration of all databases is realized.
Description
Technical field
The utility model relates to computer realm, relates in particular to a kind of conventional data switch based on XML.
Background technology
Along with computer application is popularized, mass data is stored in the database, then when computer system updating or replacing, often needs each data of original system are moved.Data migtation is meant each data in the old system is cleaned, changed, and is loaded in the new system.Yet; When system upgrade or replacing, some usually can take place for the interface of the database in the new system or data memory format changes, incompatible with the interface or the data memory format of source database; Thereby cause the data of source database to move, and then cause system upgrade or change failure.
Summary of the invention
The object of the present invention is to provide a kind of conventional data switch based on XML, with solve in the prior art system in upgrading or when changing because of the interface between source database and the destination data storehouse or the data memory format compatibility problem that causes the source database data to move mutually.
In order to reach above-mentioned purpose, technical scheme of the present invention is such:
A kind of conventional data switch based on XML is characterized in that, comprises following assembly:
DB2XML module: be responsible for the data importing in the old system and generate XML document;
XML2DB module: be responsible for the XML document that above-mentioned DB2XML module generates is imported in the database of new system;
Above-mentioned DB2XML module is connected with above-mentioned XML2DB module successively.
Above-mentioned DB2XML module comprises the data acquisition module of the database data that are used for gathering old system; And the mapping block that is used for the data of data acquisition module are shone upon and generated XML document, the input end of above-mentioned data acquisition module is provided with the ODBC interface.
Above-mentioned XML2DB module comprises the XML importing module that is used for the XML document importing of above-mentioned DB2XML module generation; Be used for the XML document of above-mentioned XML importing module is shone upon and generates the generation module of SQL statement; And the database that is used for the SQL statement that above-mentioned generation module generates is sent to new system; And the data conversion module of generation relation table and XSL style sheet, and the output terminal of above-mentioned data conversion module is provided with the ODBC interface.
A kind of conventional data switch of the present invention based on XML; When the database table interface of new system is not compatible mutually with the database interface of old system when system upgrade or in changing; Utilizing XML is the DDL that is widely used in the network, as intermediate data, the importing of XML and data of database, export interface is provided the XML data; Efficiently solve the source database interface problem not compatible mutually, realized the seamless migration of each database between system with the destination data bank interface.
Description of drawings
Fig. 1 is a structured flowchart of the present invention;
Fig. 2 is the process flow diagram of DB2XML module among the present invention;
Fig. 3 is the process flow diagram of XML2DB module among the present invention.
Among the figure:
XML imports module 21 generation modules 22
Embodiment
Of the present invention a kind of based on XML conventional data switch, as shown in Figure 1, comprise following assembly:
DB2XML module 1: be responsible for each data importing of source database 100 and generate XML document;
XML2DB module 2: be responsible for the XML document that DB2XML module 1 generates is imported in the destination data storehouse 101;
This DB2XML module 1 is connected with XML2DB module 2 successively.
Wherein: as shown in Figure 2; DB2XML module 1 comprises the data acquisition module 11 of the data of the database that is used for gathering old system; And the mapping block 12 that is used for the data of data acquisition module 11 are shone upon and generated XML document, and the input end of data acquisition module 11 is provided with the ODBC interface.The idiographic flow of this DB2XML module 1; During work, the ODBC interface transmission SQL statement through data acquisition module 11 obtains data and handles through mapping block 12 then from source database 100; At first select the table that shines upon during processing; Select again whether relation table to be shone upon, when selecting " being ", just the communication center between option table and the relation table is shone upon the XDR pattern that generates; When selecting " denying ", just relation table is independently shone upon the XDR pattern that generates, at last the XDR pattern that generates is generated XML document through data conversion module.
As shown in Figure 3; XML2DB module 2 comprises that the XML that is used for the XML document that DB2XML module 1 generates imports imports module 21; Be used for the XML document of XML importing module 21 is shone upon and generates the generation module 22 of SQL statement; And be used for the SQL statement that generation module 22 generates is sent to destination data storehouse 101, and generate the data conversion module 23 of relation table and XSL style sheet, and the output terminal of this data conversion module 23 is provided with the ODBC interface.The idiographic flow of this XML2DB module 2; Import module 21 through XML XML document is imported in the XML2DB module 2, the XML document through 22 pairs of inputs of the generation module in the XML2DB module 2 detected this XML document and whether comprised the XDR pattern this moment, when detecting " denying "; XML document is generated the XDR pattern; When detecting " being ", the XML document that reaches that will contain the XDR pattern shines upon, and generates corresponding SQL statement; ODBC interface through data conversion module 23 transmits the destination data storehouse with corresponding SQL statement at last; And generating relation table and XSL style sheet, use this CSS can walk around relational database management system this moment, directly the form of source XML document at browser Sino-Israel relations table shown.
Among the present invention, generally all are ODBC interfaces, so this DB2XML module 1 and XML2DB module 2 can realize alternately with any relational database, have versatility, portability and platform-neutral because system adopts.
The foregoing description and graphic and non-limiting product form of the present invention and style, the those of ordinary skill of any affiliated technical field all should be regarded as not breaking away from patent category of the present invention to its suitable variation or modification of doing.
Claims (3)
1. the conventional data switch based on XML is characterized in that, comprises following assembly:
DB2XML module: be responsible for the data importing in the old system and generate XML document;
XML2DB module: be responsible for the XML document that above-mentioned DB2XML module generates is imported in the database of new system;
Above-mentioned DB2XML module is connected with above-mentioned XML2DB module successively.
2. a kind of conventional data switch according to claim 1 based on XML; It is characterized in that: above-mentioned DB2XML module comprises the data acquisition module of the database data that are used for gathering old system; And the mapping block that is used for the data of data acquisition module are shone upon and generated XML document, the input end of above-mentioned data acquisition module is provided with the ODBC interface.
3. a kind of conventional data switch according to claim 1 based on XML; It is characterized in that: above-mentioned XML2DB module comprises the XML importing module that is used for the XML document importing of above-mentioned DB2XML module generation; Be used for the XML document of above-mentioned XML importing module is shone upon and generates the generation module of SQL statement; And the database that is used for the SQL statement that above-mentioned generation module generates is sent to new system; And the data conversion module of generation relation table and XSL style sheet, and the output terminal of above-mentioned data conversion module is provided with the ODBC interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103960269A CN102521318A (en) | 2011-12-02 | 2011-12-02 | General data exchange device based on extensible markup language (XML) |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103960269A CN102521318A (en) | 2011-12-02 | 2011-12-02 | General data exchange device based on extensible markup language (XML) |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102521318A true CN102521318A (en) | 2012-06-27 |
Family
ID=46292235
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011103960269A Pending CN102521318A (en) | 2011-12-02 | 2011-12-02 | General data exchange device based on extensible markup language (XML) |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102521318A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105117447A (en) * | 2015-08-13 | 2015-12-02 | 浪潮(北京)电子信息产业有限公司 | Processing method and system of XML (Extensive Markup Language) document data |
| CN105808539A (en) * | 2014-12-29 | 2016-07-27 | 北京航天测控技术有限公司 | Data import and export method and device |
| CN106649788A (en) * | 2016-12-28 | 2017-05-10 | 深圳启润德管理咨询有限公司 | Database data transmission method and device |
| CN106933763A (en) * | 2017-02-22 | 2017-07-07 | 中国银行股份有限公司 | Data processing method and device |
| WO2020000725A1 (en) * | 2018-06-29 | 2020-01-02 | 平安科技（深圳）有限公司 | Electronic apparatus, data migration method, and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1464435A (en) * | 2002-06-26 | 2003-12-31 | 联想(北京)有限公司 | Process of data exchange between a flush type system and external data base |
| CN101739452A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Data exchange interface and realizing method thereof |
-
2011
- 2011-12-02 CN CN2011103960269A patent/CN102521318A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1464435A (en) * | 2002-06-26 | 2003-12-31 | 联想(北京)有限公司 | Process of data exchange between a flush type system and external data base |
| CN101739452A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Data exchange interface and realizing method thereof |
Non-Patent Citations (1)
| Title |
|---|
| 洪欣等: "基于XML的通用数据交换系统", 《计算机系统应用》, vol. 20, no. 11, 30 November 2011 (2011-11-30) * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105808539A (en) * | 2014-12-29 | 2016-07-27 | 北京航天测控技术有限公司 | Data import and export method and device |
| CN105117447A (en) * | 2015-08-13 | 2015-12-02 | 浪潮(北京)电子信息产业有限公司 | Processing method and system of XML (Extensive Markup Language) document data |
| CN106649788A (en) * | 2016-12-28 | 2017-05-10 | 深圳启润德管理咨询有限公司 | Database data transmission method and device |
| CN106649788B (en) * | 2016-12-28 | 2020-12-08 | 深圳启润德科技有限公司 | Database data transmission method and device |
| CN106933763A (en) * | 2017-02-22 | 2017-07-07 | 中国银行股份有限公司 | Data processing method and device |
| WO2020000725A1 (en) * | 2018-06-29 | 2020-01-02 | 平安科技（深圳）有限公司 | Electronic apparatus, data migration method, and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104376068B (en) | A kind of data exhibiting system and method based on dynamic statement template | |
| CN102521318A (en) | General data exchange device based on extensible markup language (XML) | |
| CN102750358B (en) | Mapping method and system of system data model to common information model (CIM) | |
| CN104123392A (en) | Tool and method for transferring relational database to HBase | |
| CN102855271A (en) | Storage and traceable management method for multi-version power grid model | |
| CN104182911A (en) | Calibration method for realizing CIM (Common Information Model) consistency of power distribution network system | |
| CN106951552A (en) | A kind of user behavior data processing method based on Hadoop | |
| CN204046642U (en) | A kind of communication gate supporting multi-protocols | |
| CN101944128A (en) | Data export and import method and device | |
| CN101876984A (en) | Data management system and data relation query method and device thereof | |
| CN103049431B (en) | ICD (IED Capability Description) inspection method based on objectified module semantics | |
| CN102779156A (en) | Configuration method for database of communication device in digital substation | |
| CN104216961A (en) | Method and device for data processing | |
| CN103810171B (en) | Method and system for generating random test data within limited range | |
| CN106156227A (en) | A kind of data transmission method and device | |
| CN105975489A (en) | Metadata-based online SQL code completion method | |
| CN108256820A (en) | A kind of PBOM methods of adjustment under three-dimensional assembled view based on MBD | |
| CN101257402A (en) | Method and system for equipment to realize user-defined order | |
| CN101667124A (en) | System and method for configuring monitoring device based on object model | |
| CN102148702B (en) | Method for managing network by utilizing network configuration protocol | |
| CN101714087A (en) | System and method for mapping C language structure to relation database table | |
| CN202650008U (en) | Real-time device standing book information inquiring and sub-screen display system | |
| CN102207980A (en) | Data exchange method based on extensive makeup language (XML) and database (DB), and data adapter | |
| CN202364244U (en) | Processing device of distributed log analysis system | |
| CN101516086A (en) | Service matching method for mobile communication |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20120627 |