CN1407465A - Data exchanging method and device between different databases with different structure - Google Patents
Data exchanging method and device between different databases with different structure Download PDFInfo
- Publication number
- CN1407465A CN1407465A CN 01127743 CN01127743A CN1407465A CN 1407465 A CN1407465 A CN 1407465A CN 01127743 CN01127743 CN 01127743 CN 01127743 A CN01127743 A CN 01127743A CN 1407465 A CN1407465 A CN 1407465A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- interface
- control circuit
- bus
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Exchange Systems With Centralized Control (AREA)
Abstract
The data exchange method and device between databases with different structures includes establishing data exchange channels, converting the various formats into a basic format and then trasnferring them into the target database. This invention solves some problems such as bidirectional updating for the same data list between databases and system formation in non-special lines, etc. It remains the independence of the original databases and applied programs.
Description
The present invention relates to the exchanges data between database, is the network of feature with the function of exchange between particularly many groups, heterogeneous database.
In the prior art, between different brands different structure database definitely direct swap data.Be not internal agreement difference between database, it is too big that its data structure also differs.For the data consistency in operational process between the one group of database that keeps same use, once adopted thousand and one way.Early stage useful artificial derived data storehouse content is made carrier with disk, does once to load to another database; When this kind way is taken a lot of work again too slowly, also be difficult to be applicable to the Large Volume Data storehouse.Commercial data base possesses certain replication capacity, but must be ideally the working of many restrictions, and design philosophy has big limitation, narrow application range.Also have some independently data propagation softwares, it is characterized in that the architecture of point-to-point coping database, and can not solve data conversion between the storehouse of the complex topology structure that a plurality of heterogeneous databases constitute.The exchanges data software that also has special exploitation in addition, though efficient is higher, its to as if the data of concrete application system duplicate, do not have versatility, and exploitation wastes time and energy, with high costs.
The present invention is directed to the above-mentioned weak point of prior art and propose method for interchanging data and device between a kind of simple, database that applicability is strong, go for the data of database exchange of any kind of structure, keep former database and application program independence separately, need not manual intervention and solve the data synchronization updating problem between database on the same group fast.
Purpose of the present invention can adopt following technical measures to reach:
Design, adopt the method for interchanging data that is suitable between a kind of isomery, heterogeneous database, comprise the data exchange channel of setting up between database, especially the data-switching with specific format in the source database becomes the basic format data, sends into target database after again this basic format data-switching being become another specific format.
Design, make the DEU data exchange unit that is suitable between a kind of isomery, heterogeneous database, comprise and the two-way data exchange channel that is connected of database, especially also comprise can bi-directional conversion specific format data and basic format data and with connection database carry out the interface circuit of exchanges data.
This method and device are applied to exchanges data between isomery, heterogeneous database, to keep the consistance of data between database.
Brief description of drawings of the present invention is as follows:
Fig. 1 is the general illustration of method for interchanging data between database of the present invention;
Fig. 2 is described DEU data exchange unit structural drawing;
Fig. 3 is an outbound data FB(flow block) in the described method for interchanging data;
Fig. 4 is an inbound data FB(flow block) in the described method for interchanging data.
Below in conjunction with accompanying drawing in detail embodiments of the invention are described in detail.
The method for interchanging data that is suitable between a kind of isomery, heterogeneous database, comprise the data exchange channel of setting up between database, especially the data-switching with specific format in the source database becomes the basic format data, sends into target database after again this basic format data-switching being become another specific format.
Described transfer process comprises the identification of each database internal agreement and reconstruct, and to the identification and the reconstruct of data organized formats.For example the internal agreement of DB2 database and data organization form just are different from the database of Oracle fully.
Described method also comprises and being provided with at least one database DEU data exchange unit of linking to each other of DB2 database for example, this DEU data exchange unit also with at least a remote link for example isdn line link to each other; Be provided with the variation trap setting in the described database.
Described DEU data exchange unit is sent to changed content in the station or the outer target database in station according to the variable signal of source database.
Be provided with in the described DEU data exchange unit with the station in the two-way interface that is connected of database with the two-way interface bus that is connected of this interface, two-way successively connection and last and the two-way line control circuit that is connected of remote link, formation control circuit and formation bus also are set;
Data exchange process is in the described station:
I1) source database, the database DB2 for example that promptly produces swap data, the interface that variation trap setting in it promptly links to each other with source database through source interface for example interface 21 sends to controller 1 request and changes data to internal object database, for example oracle database of standing;
I2) source interface 21 is converted to the basic format data with the source format data that change and packs and send into the source interface bus, and for example bus 421;
I3) controller 1 is enabled for example bus 431 and target interface bus bus 422 for example of formation bus, and the basic format data of change are sent into another target interface 22;
I4) target interface for example interface 22 this basic format be converted to the target data form and send into the oracle database that target database for example links to each other with interface 22, this has just finished, and the data between database exchange immediately in the station.
Data exchange process is divided into outbound data flow process and inbound data flow process outside the described station.
Described outbound data flow process is:
J11) source database for example the variation trap setting in the DB2 detect delta data after source interface for example interface 21 send change data target database, for example oracle database of another one DEU data exchange unit to the station to the controller request;
J12) source interface 21 is that the format conversion of DB2 is that 421 buses in the source interface bus 42 are sent in basic format data and packing with the source format data of change;
J13) controller 1 is enabled 433 buses in the formation bus 43 to send into target database through formation control circuit 313 and line control circuit 323 the basic format data of change is the remote link ISDN that the oracle database at another station links to each other;
Described inbound data flow process is:
J21) line control circuit 323 and formation control circuit 313 receive the packing data of basic format from remote link ISDN;
J22) data of target database at our station are unpacked;
J23) the basic format data after controller 1 is enabled formation bus 433 and interface bus 421 and will be unpacked are sent into target interface 21;
J24) the basic format data are converted to the object format data is that the Oracle form is sent into the i.e. oracle database at this station of target database again to target interface 21.So far, finish the exchanges data of disparate databases between the station by remote link, and need not change each database inner tissue structure and application program.Simple and easy to do.
The controller of described DEU data exchange unit also is provided with determining program, and the inbound data bag of the non-our station in destination is retransmitted departures.
The controller 1 of described DEU data exchange unit adopts timesharing control in conjunction with the formation control circuit, the inside and outside multiple goal database manipulation of support station.If many interface buss desire to be sent to same formation bus or many formations bus desires to be sent to same interface bus, adopt time-sharing operation to finish item by item; If many interface buss are sent to same outer wired link, then finish by the queuing of formation control circuit.
The present invention also proposes DEU data exchange unit suitable between a kind of isomery, heterogeneous database, comprise and the two-way data exchange channel that is connected of database, especially also comprise can bi-directional conversion specific format data and basic format data and with the connection interface circuit 2 that exchanges of database.
Described DEU data exchange unit comprises that also the line control circuit 32 that links to each other with remote link reaches and the two-way formation control circuit 31 that is connected of this line control circuit.
But described DEU data exchange unit also comprises two groups of internal buss of quadrature cross-over connection; This bus comprises the interface bus 42 of the described interface circuit 2 of two-way connection again, with the two-way formation bus 43 that is connected described formation control circuit 31;
Described DEU data exchange unit also comprises the controller 1 that links to each other with described interface circuit 2, formation control circuit 31, line control circuit 32 and internal bus.
Described interface circuit 2 and interface bus 42 inside comprise at least one interface 21 or an interface bus 421 respectively, and corresponding one by one linking to each other; Described formation control circuit 31 and formation bus 43 inside comprise at least one formation control circuit 311 or a formation bus 431 respectively, and corresponding one by one linking to each other.
This method and device are applied to exchanges data between isomery, heterogeneous database, to keep the consistance of data between database.
The present invention is with respect to the advantage of prior art: adopt between the database simple, that applicability is strong Method for interchanging data and device, can solve exchanges data problem between a plurality of databases, solve database it Between system in the situation of the problem of same the two-way renewal of tables of data and non-special circuit consist of problem. The present invention Go for the exchanges data of the database of any species structure, keep former Database and application program separately Independence need not manual intervention and the quick solution data synchronization updating problem between database on the same group.
Claims (10)
1. the method for interchanging data that is suitable between an isomery, heterogeneous database comprises the data exchange channel of setting up between database, it is characterized in that:
The data-switching of specific format in the source database is become the basic format data, send into target database after again this basic format data-switching being become another specific format.
2. method for interchanging data according to claim 1 is characterized in that:
Described transfer process comprises the identification of each database internal agreement and reconstruct, and to the identification and the reconstruct of data organized formats.
3. method for interchanging data according to claim 2 is characterized in that:
Described method comprises also the DEU data exchange unit that links to each other with at least one database is set that this DEU data exchange unit also links to each other with at least a remote link; Be provided with the variation trap setting in the described database;
Described DEU data exchange unit is sent to changed content in the station or the outer target database in station according to the variable signal of source database.
4. method for interchanging data according to claim 3 is characterized in that:
Be provided with in the described DEU data exchange unit with the station in the two-way interface that is connected of database with the two-way interface bus that is connected of this interface, two-way successively connection and last and the two-way line control circuit that is connected of remote link, formation control circuit and formation bus also are set;
Data exchange process is in the described station:
I1) the variation trap setting in the source database sends the change data to the station through source interface to the controller request
The internal object database;
I2) source interface is converted to basic format data and packing with the source format data of change to send into source interface total
Line;
I3) controller is enabled formation bus and target interface bus, and the basic format data of change are sent into order
The tag splice mouth;
I4) target interface is converted to this basic format the target data form and sends into target database;
Data exchange process is divided into outbound data flow process and inbound data flow process outside the described station;
Described outbound data flow process is:
J11) the variation trap setting in the source database sends the change data extremely through source interface to the controller request
The outer target database of standing;
J12) source interface is converted to the basic format data with the source format data that change and packs and send into source interface
Bus;
J13) controller enable the formation bus with the change the basic format data through formation control circuit and circuit
Control circuit is sent into the remote link that links to each other with target database;
Described inbound data flow process is:
J21) line control circuit and formation control circuit receive the packing data of basic format from remote link;
J22) data of target database at our station are unpacked;
J23) the basic format data after controller is enabled formation bus and interface bus and will be unpacked are sent into target
Interface;
J24) target interface is converted to the object format data with the basic format data and sends into target database again.
5. method for interchanging data according to claim 4 is characterized in that:
The controller of described DEU data exchange unit also is provided with determining program, and the inbound data bag of non-our station destination is retransmitted departures;
The controller of described DEU data exchange unit adopts timesharing control in conjunction with the formation control circuit, the inside and outside multiple goal database manipulation of support station.
6. the DEU data exchange unit that is suitable between an isomery, heterogeneous database comprises and the two-way data exchange channel that is connected of database, it is characterized in that:
Also comprise can bi-directional conversion specific format data and basic format data and with the connection interface circuit (2) that exchanges of database.
7. DEU data exchange unit according to claim 6 is characterized in that:
Described DEU data exchange unit comprises that also the line control circuit (32) that links to each other with remote link reaches and the two-way formation control circuit (31) that is connected of this line control circuit.
8. DEU data exchange unit according to claim 7 is characterized in that:
But described DEU data exchange unit also comprises two groups of internal buss of quadrature cross-over connection; This bus comprises the interface bus (42) of the described interface circuit of two-way connection (2) again, with the two-way formation bus (43) that is connected described formation control circuit (31);
Described DEU data exchange unit also comprises the controller (1) that links to each other with described interface circuit (2), formation control circuit (31), line control circuit (32) and internal bus.
9. DEU data exchange unit according to claim 8 is characterized in that:
Described interface circuit (2) and interface bus (42) inside comprise at least one interface (21) or an interface bus (421) respectively, and corresponding one by one linking to each other; Described formation control circuit (31) and formation bus (43) inside comprise at least one a formation control circuit (311) or a formation bus (431) respectively, and corresponding one by one linking to each other.
10. according to claim 1 or 6 described method for interchanging data and devices, it is characterized in that:
This method and device are applied to exchanges data between isomery, heterogeneous database, to keep the consistance of data between database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 01127743 CN1407465A (en) | 2001-08-13 | 2001-08-13 | Data exchanging method and device between different databases with different structure |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 01127743 CN1407465A (en) | 2001-08-13 | 2001-08-13 | Data exchanging method and device between different databases with different structure |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1407465A true CN1407465A (en) | 2003-04-02 |
Family
ID=4667660
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 01127743 Pending CN1407465A (en) | 2001-08-13 | 2001-08-13 | Data exchanging method and device between different databases with different structure |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1407465A (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100440206C (en) * | 2003-07-29 | 2008-12-03 | 微软公司 | Synchronizing logical views independent of physical storage representations |
| CN101807210A (en) * | 2010-04-26 | 2010-08-18 | 中兴通讯股份有限公司 | Database data synchronic method, system and device |
| CN102262662A (en) * | 2011-07-22 | 2011-11-30 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing database data migration in heterogeneous platform |
| CN101640587B (en) * | 2008-08-01 | 2012-04-25 | 华为技术有限公司 | Data synchronization method and device |
| CN1906609B (en) * | 2003-10-22 | 2012-05-09 | 英特尔公司 | System for data format conversion for use in data centers |
| CN102495910A (en) * | 2011-12-28 | 2012-06-13 | 畅捷通信息技术股份有限公司 | Device and method for data timing synchronization of heterogeneous system |
| CN102541942A (en) * | 2010-12-31 | 2012-07-04 | 中国银联股份有限公司 | Data bulk transfer system and method thereof |
| CN101232505B (en) * | 2008-01-17 | 2012-07-18 | 中山大学 | Interface system of RIA laminate frame based on MVC architecture |
| CN102945236A (en) * | 2011-11-29 | 2013-02-27 | Ut斯达康通讯有限公司 | Method for synchronizing different databases by triggering events |
| CN103020071A (en) * | 2011-09-22 | 2013-04-03 | 中兴通讯股份有限公司 | Data synchronization method and data synchronization device |
| CN103092980A (en) * | 2013-01-31 | 2013-05-08 | 中国科学院自动化研究所 | Method and system of data automatic conversion and storage |
| CN103297329A (en) * | 2013-06-26 | 2013-09-11 | 北京金和软件股份有限公司 | Quasi-real-time two-way synchronization method for messages between heterogeneous systems |
| CN104090896A (en) * | 2013-12-19 | 2014-10-08 | 深圳市腾讯计算机系统有限公司 | Method, device and system for importing data |
| CN104111834A (en) * | 2014-07-07 | 2014-10-22 | 北京京东尚科信息技术有限公司 | Method and device for exchanging data between heterogeneous databases |
| CN106570314A (en) * | 2016-10-19 | 2017-04-19 | 北京千医健康管理有限公司 | ICCINO (Insurance, Check, Check, Inform, Nursing and Observe) door-to-door nurse service standard |
-
2001
- 2001-08-13 CN CN 01127743 patent/CN1407465A/en active Pending
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100440206C (en) * | 2003-07-29 | 2008-12-03 | 微软公司 | Synchronizing logical views independent of physical storage representations |
| CN1906609B (en) * | 2003-10-22 | 2012-05-09 | 英特尔公司 | System for data format conversion for use in data centers |
| CN101232505B (en) * | 2008-01-17 | 2012-07-18 | 中山大学 | Interface system of RIA laminate frame based on MVC architecture |
| CN101640587B (en) * | 2008-08-01 | 2012-04-25 | 华为技术有限公司 | Data synchronization method and device |
| CN101807210A (en) * | 2010-04-26 | 2010-08-18 | 中兴通讯股份有限公司 | Database data synchronic method, system and device |
| WO2011134231A1 (en) * | 2010-04-26 | 2011-11-03 | 中兴通讯股份有限公司 | Method, system and apparatus for data synchronization between databases |
| CN101807210B (en) * | 2010-04-26 | 2015-04-01 | 中兴通讯股份有限公司 | Database data synchronic method, system and device |
| CN102541942A (en) * | 2010-12-31 | 2012-07-04 | 中国银联股份有限公司 | Data bulk transfer system and method thereof |
| CN102541942B (en) * | 2010-12-31 | 2014-09-17 | 中国银联股份有限公司 | Data bulk transfer system and method thereof |
| CN102262662A (en) * | 2011-07-22 | 2011-11-30 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing database data migration in heterogeneous platform |
| CN103020071A (en) * | 2011-09-22 | 2013-04-03 | 中兴通讯股份有限公司 | Data synchronization method and data synchronization device |
| CN103020071B (en) * | 2011-09-22 | 2017-11-28 | 中兴通讯股份有限公司 | Method of data synchronization and device |
| CN102945236A (en) * | 2011-11-29 | 2013-02-27 | Ut斯达康通讯有限公司 | Method for synchronizing different databases by triggering events |
| CN102495910B (en) * | 2011-12-28 | 2013-09-18 | 畅捷通信息技术股份有限公司 | Device and method for data timing synchronization of heterogeneous system |
| CN102495910A (en) * | 2011-12-28 | 2012-06-13 | 畅捷通信息技术股份有限公司 | Device and method for data timing synchronization of heterogeneous system |
| CN103092980A (en) * | 2013-01-31 | 2013-05-08 | 中国科学院自动化研究所 | Method and system of data automatic conversion and storage |
| CN103297329A (en) * | 2013-06-26 | 2013-09-11 | 北京金和软件股份有限公司 | Quasi-real-time two-way synchronization method for messages between heterogeneous systems |
| CN104090896A (en) * | 2013-12-19 | 2014-10-08 | 深圳市腾讯计算机系统有限公司 | Method, device and system for importing data |
| CN104090896B (en) * | 2013-12-19 | 2016-05-11 | 深圳市腾讯计算机系统有限公司 | A kind of methods, devices and systems that import data |
| CN104111834A (en) * | 2014-07-07 | 2014-10-22 | 北京京东尚科信息技术有限公司 | Method and device for exchanging data between heterogeneous databases |
| CN106570314A (en) * | 2016-10-19 | 2017-04-19 | 北京千医健康管理有限公司 | ICCINO (Insurance, Check, Check, Inform, Nursing and Observe) door-to-door nurse service standard |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1407465A (en) | Data exchanging method and device between different databases with different structure | |
| CN102479182A (en) | Method and device for data exchanging among isomerous and heterogeneous databases | |
| CN103970903B (en) | Large industrial system feedback data real-time processing method and system based on Web | |
| CN100388675C (en) | A method for implementing foreground data configuration in network management system | |
| CN1489052A (en) | Multi-node file syn chronizing system and method | |
| CN1818878A (en) | Information system data consistency detection | |
| CN103676803A (en) | Industrial control system | |
| CN1835445A (en) | Power communicating network administrative system and realizing the same | |
| CN2722303Y (en) | Network controller of cracker set | |
| CN101271331A (en) | Hierarchical real-time data mapping method of macrotype distributed control system | |
| CN101902380B (en) | A ZigBee-based FF fieldbus control system and its protocol conversion method | |
| CN1858730A (en) | Data automatic transfer system and method | |
| CN109446260B (en) | Distributed management method and system for real-time data of mass data points | |
| CN201369723Y (en) | Bluetooth module collector based on Bluetooth chip | |
| CN1419386A (en) | Base station configuration method | |
| CN1477562A (en) | Distributed data processing method on information management system with C/S structure | |
| CN115334173A (en) | MODBUS and CC-Link protocol conversion device and method | |
| CN1432242A (en) | Network management system | |
| CN101592940A (en) | A kind of automation control system that inserts robotization isomery controller and uses thereof | |
| CN2747629Y (en) | Logic input and output device of field bus | |
| CN1183721C (en) | Cluster management method and system for low-end switches | |
| CN1578307A (en) | Method for communicating between telecommunication equipment service terminal and customer terminal | |
| CN201477434U (en) | Automatic control system accessed into automatic heterogeneous controller | |
| CN1968146A (en) | Mapping-based universal data switching method and device | |
| CN1363907A (en) | Distributed universal network system for acquiring and controlling analog and digital information |
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 |