CN102207980A - Data exchange method based on extensive makeup language (XML) and database (DB), and data adapter - Google Patents
Data exchange method based on extensive makeup language (XML) and database (DB), and data adapter Download PDFInfo
- Publication number
- CN102207980A CN102207980A CN2011101929878A CN201110192987A CN102207980A CN 102207980 A CN102207980 A CN 102207980A CN 2011101929878 A CN2011101929878 A CN 2011101929878A CN 201110192987 A CN201110192987 A CN 201110192987A CN 102207980 A CN102207980 A CN 102207980A
- Authority
- CN
- China
- Prior art keywords
- schema
- processing module
- data
- xml
- 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
Abstract
The invention discloses a data exchange method based on an extensive makeup language (XML) and a database (DB). By the method, a corresponding data exchange relation is established between metadata XML of a sheet and the DB; and the method comprises the following steps of: (1) preparing a data adapter based on the XML and the DB, wherein the data adapter comprises a DB processing module, a sheet data model Schema processing module and a DB and Schema mapping processing module; and the DB processing module and the sheet data model Schema processing module are connected with the DB and Schema mapping processing module respectively; (2) selecting the DB, selecting a service DB needing to exchange data with the XML, wherein a data structure in the DB forms a tree catalog; (3) installing a sheet data model Schema and generating a tree catalog; and (4) displaying all nodes in the DB tree catalog and the Schema tree catalog, establishing a mapping relation between corresponding nodes in the DB tree catalog and the Schema tree catalog, and generating a mapping connecting line. The invention also discloses a data adapter.
Description
Technical field
The present invention relates to data adapter unit, particularly a kind of method for interchanging data and a kind of data adapter unit by this method for interchanging data of enforcement based on XML and DB.
Background technology
In the prior art, coming by traditional form in the application of image data, as JSP, ASP or based on the list of Word, workload more than 60% all concentrates on data-switching and puts in storage on this link, and this link is without any simplifying the possibility that realizes with robotization for the programmer, it needs the programmer to carry out conversion and the work such as warehouse-in and renewal that the hand-coding program is finished data respectively at each business, can only describe this mode of operation with " time-consuming, effort, transfer ability of data extreme difference " at this situation.So as the intelligent list of forms application of new generation, can be implemented in operations such as the conversion of finishing data under the situation of " zero " code automatically and warehouse-in? the applicant is by unremitting effort, wish to provide a kind of exchanges data means and methods and data adapter unit, finish this data exchange process based on XML and DB data exchange standard data adapter unit by this based on XML and DB.
Summary of the invention
The objective of the invention is to, provide a kind of based on the method for interchanging data of XML and DB and the data adapter unit of this method of enforcement, by corresponding functional modules rationally is set, realize that DB is connected with the automatic mapping of the whole nodes of directory tree of Schema, the data that realize XML and DB effectively exchange automatically, raise the efficiency, reduce working strength.
The technical scheme that the present invention is adopted for achieving the above object is:
A kind of method for interchanging data based on XML and DB, it is used for the metadata XML of list and database D B are set up the corresponding data commutative relation, and it may further comprise the steps:
(1) preparation one data adapter unit based on XML and DB, this data adapter unit comprises a database D B processing module, a form data model Schema processing module and a DB and Schema mapping processing module, and this database D B processing module is connected with Schema mapping processing module with this DB respectively with form data model Schema processing module;
(2) select database D B, selection need be carried out the Service Database DB of exchanges data with XML, and data structure generates directory tree among the database D B;
(3) the form data model Schema that packs into, and generate directory tree;
(4) the whole nodes in DB directory tree and the Schema directory tree are shown, corresponding node in this DB directory tree and the Schema directory tree is set up mapping relations, and generate the mapping connecting line;
(5) after database D B and form data model Schema set up mapping relations, the user can carry out the definition of data behavior.
As a further improvement on the present invention, described form data model Schema is generated by the definition of the model view in the form design tools.
As a further improvement on the present invention, be provided with DB selected cell and the DB directory tree generation unit that is connected in this database D B processing module.
As a further improvement on the present invention, be provided with form data model Schema loading location and the Schema directory tree generation unit that is connected in this form data model Schema processing module.
As a further improvement on the present invention, this DB shines upon with Schema and is provided with directory node map unit and the mapping connecting line generation unit that is connected in the processing module.
As a further improvement on the present invention, described DB directory tree generation unit is connected with the directory node map unit respectively with Schema directory tree generation unit.
A kind of data adapter unit of implementing aforementioned method for interchanging data based on XML and DB, it comprises a database D B processing module, a form data model Schema processing module and a DB and Schema mapping processing module, and this database D B processing module is connected with Schema mapping processing module with this DB respectively with form data model Schema processing module.
As a further improvement on the present invention, described form data model Schema is generated by the definition of the model view in the form design tools.
As a further improvement on the present invention, comprise the DB selected cell and the DB directory tree generation unit that are connected in this database D B processing module, this form data model Schema processing module comprises form data model Schema loading location and the Schema directory tree generation unit that is connected, this DB comprises directory node map unit and the mapping connecting line generation unit that is connected with Schema mapping processing module, and described DB directory tree generation unit is connected with the directory node map unit respectively with Schema directory tree generation unit.
Beneficial effect of the present invention is: the present invention realizes that by corresponding functional modules rationally is set DB is connected with the automatic mapping of the whole nodes of directory tree of Schema, realizes that effectively the data of XML and DB exchange automatically, raises the efficiency, and reduces working strength.
Below in conjunction with accompanying drawing and embodiment, the present invention is further described.
Description of drawings
Fig. 1 is a work synoptic diagram of the present invention.
Embodiment
Embodiment: see Fig. 1, a kind of method for interchanging data of the present invention based on XML and DB, it is used for the metadata XML of list and database D B are set up the corresponding data commutative relation, and it may further comprise the steps:
(1) preparation one data adapter unit based on XML and DB, this data adapter unit comprises a database D B processing module, a form data model Schema processing module and a DB and Schema mapping processing module, and this database D B processing module is connected with Schema mapping processing module with this DB respectively with form data model Schema processing module;
(2) select database D B, selection need be carried out the Service Database DB of exchanges data with XML, and data structure generates directory tree among the database D B;
(3) the form data model Schema that packs into, and generate directory tree;
(4) the whole nodes in DB directory tree and the Schema directory tree are shown, corresponding node in this DB directory tree and the Schema directory tree is set up mapping relations, and generate the mapping connecting line;
(5) after database D B and form data model Schema set up mapping relations, the user can carry out the definition of data behavior.
Described form data model Schema is generated by the definition of the model view in the form design tools.
Be provided with the DB selected cell and the DB directory tree generation unit that are connected in this database D B processing module.
Be provided with form data model Schema loading location and the Schema directory tree generation unit that is connected in this form data model Schema processing module.
This DB shines upon with Schema and is provided with directory node map unit and the mapping connecting line generation unit that is connected in the processing module.
Described DB directory tree generation unit is connected with the directory node map unit respectively with Schema directory tree generation unit.
A kind of data adapter unit of implementing aforementioned method for interchanging data based on XML and DB, it comprises a database D B processing module, a form data model Schema processing module and a DB and Schema mapping processing module, and this database D B processing module is connected with Schema mapping processing module with this DB respectively with form data model Schema processing module.
Described form data model Schema is generated by the definition of the model view in the form design tools.
Comprise the DB selected cell and the DB directory tree generation unit that are connected in this database D B processing module, this form data model Schema processing module comprises form data model Schema loading location and the Schema directory tree generation unit that is connected, this DB comprises directory node map unit and the mapping connecting line generation unit that is connected with Schema mapping processing module, and described DB directory tree generation unit is connected with the directory node map unit respectively with Schema directory tree generation unit.
The present invention realizes that by corresponding functional modules rationally is set DB is connected with the automatic mapping of the whole nodes of directory tree of Schema, realizes that effectively the data of XML and DB exchange automatically, raises the efficiency, and reduces working strength.
As described in the embodiment of the invention, with other method for interchanging data and data adapter units of the same or similar structure of the present invention, all in protection domain of the present invention based on XML and DB.
Claims (9)
1. method for interchanging data based on XML and DB, it is used for the metadata XML of list and database D B are set up the corresponding data commutative relation, and it is characterized in that: it may further comprise the steps:
(1) preparation one data adapter unit based on XML and DB, this data adapter unit comprises a database D B processing module, a form data model Schema processing module and a DB and Schema mapping processing module, and this database D B processing module is connected with Schema mapping processing module with this DB respectively with form data model Schema processing module;
(2) select database D B, selection need be carried out the Service Database DB of exchanges data with XML, and data structure generates directory tree among the database D B;
(3) the form data model Schema that packs into, and generate directory tree;
(4) the whole nodes in DB directory tree and the Schema directory tree are shown, corresponding node in this DB directory tree and the Schema directory tree is set up mapping relations, and generate the mapping connecting line;
(5) after database D B and form data model Schema set up mapping relations, the user can carry out the definition of data behavior.
2. the method for interchanging data based on XML and DB is characterized in that, described form data model Schema is generated by the definition of the model view in the form design tools.
3. the method for interchanging data based on XML and DB according to claim 1 is characterized in that, is provided with the DB selected cell and the DB directory tree generation unit that are connected in this database D B processing module.
4. the method for interchanging data based on XML and DB according to claim 3 is characterized in that, is provided with form data model Schema loading location and the Schema directory tree generation unit that is connected in this form data model Schema processing module.
5. the method for interchanging data based on XML and DB according to claim 4 is characterized in that, this DB shines upon with Schema and is provided with directory node map unit and the mapping connecting line generation unit that is connected in the processing module.
6. the method for interchanging data based on XML and DB according to claim 5 is characterized in that, described DB directory tree generation unit is connected with the directory node map unit respectively with Schema directory tree generation unit.
7. data adapter unit of implementing the described method for interchanging data based on XML and DB of claim 1, it is characterized in that: it comprises a database D B processing module, a form data model Schema processing module and a DB and Schema mapping processing module, and this database D B processing module is connected with Schema mapping processing module with this DB respectively with form data model Schema processing module.
8. data adapter unit according to claim 7 is characterized in that, described form data model Schema is generated by the definition of the model view in the form design tools.
9. data adapter unit according to claim 8, it is characterized in that, comprise the DB selected cell and the DB directory tree generation unit that are connected in this database D B processing module, this form data model Schema processing module comprises form data model Schema loading location and the Schema directory tree generation unit that is connected, this DB comprises directory node map unit and the mapping connecting line generation unit that is connected with Schema mapping processing module, and described DB directory tree generation unit is connected with the directory node map unit respectively with Schema directory tree generation unit.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2011101929878A CN102207980A (en) | 2011-07-11 | 2011-07-11 | Data exchange method based on extensive makeup language (XML) and database (DB), and data adapter |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2011101929878A CN102207980A (en) | 2011-07-11 | 2011-07-11 | Data exchange method based on extensive makeup language (XML) and database (DB), and data adapter |
Publications (1)
Publication Number | Publication Date |
---|---|
CN102207980A true CN102207980A (en) | 2011-10-05 |
Family
ID=44696812
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2011101929878A Pending CN102207980A (en) | 2011-07-11 | 2011-07-11 | Data exchange method based on extensive makeup language (XML) and database (DB), and data adapter |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102207980A (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102929664A (en) * | 2012-10-16 | 2013-02-13 | 南京通达海信息技术有限公司 | Conventional data exchange method based on XSD structure |
CN103085026A (en) * | 2013-02-21 | 2013-05-08 | 安徽江淮汽车股份有限公司 | Anti-lock brake system (ABS) module and braking pipeline preassembling work table |
CN106326488A (en) * | 2016-09-07 | 2017-01-11 | 国家电网公司 | XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof |
CN107203627A (en) * | 2017-05-27 | 2017-09-26 | 山东浪潮通软信息科技有限公司 | The method of mutual phase transformation between a kind of structural data and Word document |
US11256709B2 (en) | 2019-08-15 | 2022-02-22 | Clinicomp International, Inc. | Method and system for adapting programs for interoperability and adapters therefor |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101710336A (en) * | 2009-12-14 | 2010-05-19 | 浪潮通信信息系统有限公司 | Method for accelerating data processing by using relational middleware |
-
2011
- 2011-07-11 CN CN2011101929878A patent/CN102207980A/en active Pending
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101710336A (en) * | 2009-12-14 | 2010-05-19 | 浪潮通信信息系统有限公司 | Method for accelerating data processing by using relational middleware |
Non-Patent Citations (2)
Title |
---|
刘兴伟等: "基于XML的多层分布式系统", 《计算机工程》, vol. 32, no. 20, 31 October 2006 (2006-10-31), pages 53 - 55 * |
陈鹏等: "保持语义约束的关系模式到XML Schema的映射", 《计算机科学》, vol. 32, no. 7, 31 December 2005 (2005-12-31), pages 319 - 321 * |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102929664A (en) * | 2012-10-16 | 2013-02-13 | 南京通达海信息技术有限公司 | Conventional data exchange method based on XSD structure |
CN103085026A (en) * | 2013-02-21 | 2013-05-08 | 安徽江淮汽车股份有限公司 | Anti-lock brake system (ABS) module and braking pipeline preassembling work table |
CN106326488A (en) * | 2016-09-07 | 2017-01-11 | 国家电网公司 | XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof |
CN107203627A (en) * | 2017-05-27 | 2017-09-26 | 山东浪潮通软信息科技有限公司 | The method of mutual phase transformation between a kind of structural data and Word document |
US11256709B2 (en) | 2019-08-15 | 2022-02-22 | Clinicomp International, Inc. | Method and system for adapting programs for interoperability and adapters therefor |
US11714822B2 (en) | 2019-08-15 | 2023-08-01 | Clinicomp International, Inc. | Method and system for adapting programs for interoperability and adapters therefor |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102207980A (en) | Data exchange method based on extensive makeup language (XML) and database (DB), and data adapter | |
CN103268542B (en) | A kind of machining equipment resource informationization method that facing cloud manufactures | |
CN103093007B (en) | Power transmission iron tower three-dimensional virtual assembly method | |
CN105786912B (en) | Data collecting conversion method and device | |
CN103020360A (en) | Integration design method of intelligent substation based on three-dimensional design platform and professional software | |
CN102646144A (en) | ObjectARX-based standardized intelligent design method for rural power network engineering | |
CN102254053A (en) | Parameterization design method and system based on assembly assembling | |
CN104268298A (en) | Method for creating database index and inquiring data | |
CN102810184A (en) | Method and device for dynamically executing workflow and enterprise system | |
CN104050544A (en) | System for generating workshop working procedure plan and achieving method thereof | |
CN102495916A (en) | Multi-application-system panoramic modeling method based on object matching | |
CN105094984A (en) | Resource scheduling method and system | |
CN104199955A (en) | Information management system and information management method | |
CN101667124A (en) | System and method for configuring monitoring device based on object model | |
CN101980218B (en) | Template-based integrated design platform | |
CN102567334A (en) | Office automation system based on heterogeneous data | |
CN105956748B (en) | More search and rescue robot system task distribution methods | |
CN102436501A (en) | Parallel file managing system based on web | |
CN102208834B (en) | Scheduling system and method of intelligent power grid | |
CN102592251B (en) | The Universal, modular parallel coupling system of earth system pattern | |
CN104008178B (en) | The dynamic load processing method and system of a kind of data | |
CN102521318A (en) | General data exchange device based on extensible markup language (XML) | |
CN102375912A (en) | Data integration device and method among different engineering software systems | |
CN112052987A (en) | Wind power-related comprehensive energy system optimization planning method and system | |
CN101261581A (en) | UG environment parts list development system based on entity attribute |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20111005 |