CN102262662A - System, device and method for realizing database data migration in heterogeneous platform - Google Patents
System, device and method for realizing database data migration in heterogeneous platform Download PDFInfo
- Publication number
- CN102262662A CN102262662A CN2011102059152A CN201110205915A CN102262662A CN 102262662 A CN102262662 A CN 102262662A CN 2011102059152 A CN2011102059152 A CN 2011102059152A CN 201110205915 A CN201110205915 A CN 201110205915A CN 102262662 A CN102262662 A CN 102262662A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- analysis engine
- change
- destination end
- 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 system, a device and a method for realizing database data migration in a heterogeneous platform. The system comprises a source end database, a data migration device and a target end database which are sequentially connected with one another, wherein the source end database is used for recording changed data of each application service in a log stream; the data migration device is used for acquiring the changed data of the application service from the log stream recorded by the source end database, transforming the changed data and the corresponding application service into a standard database query language through corresponding interpretation and transmitting the standard database query language to the target end database; and the target end database is used for completing data synchronization with the source end database by executing the standard database query language. By the invention, the problem of difference in database description grammar such as triggering of service between different databases, data storage and the like is solved, and the data consistency between a source end and a target end is ensured.
Description
Technical field
The present invention relates in the computer technology method of data migtation between the disparate databases, relate in particular to system, the device and method of realizing database data migration under the heterogeneous platform.
Background technology
Infotech (IT, Information Technology) system is through operation over a long time, one side has been brought bigger complicacy because of information upgrading and the management that its isomery turns to enterprise, also big on the other hand because of being user-friendly to role, cause data volume also huger, and also more variation of type of service.So, make every running of enterprise all depend on the normal operation of IT system strongly, make a lot of IT personnel all be faced with similar the following problem thus:
(1) how to realize the migration of the client traffic under the different platform framework
For example, the client traffic under the non-X86 framework is moved under the X86 framework that can not stop to expand and expand, can provide more flexibility for the service application upgrading and the migration in later stage.
(2) data smoothing how to guarantee the client traffic under the different platform framework is seamlessly moved, and guarantees security and reliability in the data migration process
For example, guarantee with the user service data smooth and seamless in the database under the non-X86 framework move in the database of X86 framework, and guarantee that the customer service under the non-X86 framework is not interrupted because of the machine of delaying in the data migration process.
(3) how to realize data sync between the database under the different platform framework
The scheme of data in real time migration under the present widely used tool heterogeneous platform framework, the high applicable components that carries of data copy solution (Shareplex), database disaster-tolerant recovery scheme (RealSync) and database for example, though these schemes can satisfy part client traffic demands of applications to a certain extent, but also there are many deficiencies simultaneously, mainly show the following aspect:
1) owing to require the type of database of source end and destination end must be consistent, thus be difficult to satisfy the seamless migration of data in the database under the heterogeneous platform, for example as the seamless migration of data between SharePlex framework and the RealSync framework.
2) can not guarantee that the destination end database is in state of activation, thereby need long stop time when causing data migtation, such as self assemblies physical of Oracle is equipped with storehouse mechanism etc.
Because above-mentioned technical deficiency makes that the IT personnel are difficult to solve the above-mentioned variety of problems that it faces, cause occurring the bottleneck that the technology that is unfavorable for continues development.
Summary of the invention
Technical matters to be solved by this invention provides a kind of system, device and method of realizing database data migration under the heterogeneous platform, can guarantee that the client traffic data smoothing under the isomery is seamlessly moved.
In order to solve the problems of the technologies described above, the invention provides a kind of system that realizes database data migration under the heterogeneous platform, it is characterized in that, comprise the source client database, data migration device and the destination end database that connect successively, wherein:
The source client database is used for the data that each applied business takes place to change are documented in daily record stream;
Data migration device, be used for catching the data that change takes place applied business from the daily record stream of source client database record, convert the data of change to the standard database query statement with the application corresponding business by corresponding decipher, and pass to the destination end database;
The destination end database is used for finishing data sync with the source client database by the query sentence of database of operative norm.
Further, data migration device comprises general journal analysis engine module, dedicated log analysis engine module and the professional interpretation module that connects successively, and the destination end database is built-in with normal data query engine module; Wherein:
General journal analysis engine module is used for the daily record stream of source client database record is assigned to the corresponding private database log analysis engine of dedicated log analysis engine module;
Dedicated log analysis engine module, be used for catching from daily record stream according to database feature and journal format the data of described generation change by corresponding private database log analysis engine, and triggering, data storage and the operation of applied business in the client database of source, export to professional interpretation module;
Professional interpretation module, be used for source client database applied business triggering, data storage and the operation of the data of change and applied business is taken place by decipher, convert the Structured Query Language (SQL) statement of standard to, and pass to normal data query engine module in the destination end database by the internet;
Normal data query engine module is used for by normal structure query language engine the Structured Query Language (SQL) statement of the standard of decipher being offered the application process execution of destination end database.
In order to solve the problems of the technologies described above, the invention provides a kind of device of realizing database data migration under the heterogeneous platform, comprise interconnective dedicated log analysis engine module and professional interpretation module, wherein:
Dedicated log analysis engine module is used for catching the data that change takes place applied business from the daily record stream of source client database record, and exports to professional interpretation module with applied business;
Professional interpretation module is used for applied business the data of change and applied business is taken place by decipher, converts the Structured Query Language (SQL) statement of standard to, and passes to the destination end database.
Further, before dedicated log analysis engine module, also comprise general journal analysis engine module, wherein:
General journal analysis engine module is used for the daily record stream of source client database record is assigned to the corresponding private database log analysis engine of dedicated log analysis engine module;
Dedicated log analysis engine module is caught the data that change takes place according to database feature and journal format by corresponding private database log analysis engine from daily record stream, and exports to professional interpretation module with triggering, data storage and the operation of applied business;
Triggering, data storage and the operation of the data of change and applied business take place by decipher with applied business in professional interpretation module, convert the Structured Query Language (SQL) statement of standard to, and carry out decipher by the normal data query engine module that the internet passes in the destination end database.
In order to solve the problems of the technologies described above, the invention provides a kind of method that realizes database data migration under the heterogeneous platform, relate to source client database and data migration device and destination end database, this method comprises:
The source client database is documented in the data that change takes place each applied business in the daily record stream;
Data migration device is caught the data that change takes place applied business from the daily record stream of source client database record, convert the data of changing to the standard database query statement with the application corresponding business, and be delivered to the destination end database.
Further, catch in data migration device before the data of applied business generation change, also comprise:
For formation and transmit queue are caught in client database foundation in source, and set up process, decipher process and the transmission process of catching.
Further, data migration device is caught the data that change takes place applied business from the daily record stream of source client database record, convert the data of change to the standard database query statement with the application corresponding business, and arrive the destination end database, specifically comprise by network delivery:
The process of catching is being caught formation when free space is arranged, after the filing switching takes place in the online daily record of source client database, continue daily record is analyzed from the daily record position that stops to analyze of daily record stream record by corresponding private database log analysis engine, and the change data that will capture are documented in and catch in the formation;
The decipher process will be caught after change data interpretation in the formation becomes the Structured Query Language (SQL) statement of standard successively by corresponding application specific architecture query language interpreter when transmit queue has free space, be documented in the transmit queue;
The transmission process is given the destination end database with the Structured Query Language (SQL) statement of the standard in the transmit queue by internet transmission.
Further, this method also comprises:
The destination end database is finished data sync with the source client database by the query sentence of database of operative norm.
Further, the destination end database is finished data sync with the source client database by the query sentence of database of operative norm, specifically comprises:
The destination end database listens to the Structured Query Language (SQL) statement of the standard of transmission, from the Structured Query Language (SQL) statement of standard, separate the data that translate applied business and change thereof by built-in normal structure query language engine, and offer the execution of application corresponding process.
The present invention is based on database journal and excavate mechanism, add log analysis engine and Structured Query Language (SQL) (SQL simultaneously, Structured Query Language) the compiler engine is analyzed daily record, and the change of the data in the interpret data storehouse, thereby finish cross-platform, the seamless migration of the business datum between the integration across database type, the pressure and the network burden of database have been alleviated greatly, and utilize trigger mechanism to guarantee breakpoint transmission and prevent that buffer queue from overflowing, avoid occurring data re-transmission and dig problem, and whole analysis, decipher and application process are transparent to using per family, thereby can realize that the seamless migration of data is with synchronously.
Description of drawings
Fig. 1 is the structured flowchart of the system embodiment of database data migration under the realization heterogeneous platform of the present invention;
Fig. 2 is the process flow diagram of the method embodiment of database data migration under the realization heterogeneous platform of the present invention.
Embodiment
Below in conjunction with accompanying drawing and preferred embodiment technical scheme of the present invention is at length set forth.The embodiment that below exemplifies only is used for description and interpretation the present invention, and does not constitute the restriction to technical solution of the present invention.
As shown in Figure 1, represent the system embodiment of database data migration under the realization heterogeneous platform of the present invention, comprised the source client database, data migration device embodiment of the present invention and the destination end database that connect successively, wherein:
The source client database is used for the data that change at each applied business of daily record stream record;
Data migration device, be used for catching the data that each applied business changes from the daily record stream of source client database record, convert each applied business of source client database to the standard database query statement by corresponding decipher, and arrive the destination end database by network delivery;
The destination end database is used for finishing data sync with the source client database by the query sentence of database of operative norm.
In said system embodiment, data migration device embodiment comprises general journal analysis engine module, dedicated log analysis engine module and the professional interpretation module that connects successively, the built-in normal data query engine of destination end database module; Wherein:
General journal analysis engine module is used for the daily record stream of source client database record is assigned to the corresponding private database log analysis engine of dedicated log analysis engine module;
Dedicated log analysis engine module, be used for that (1～n) catches the data that applied business changes according to database feature and journal format from the daily record stream of source client database record by a plurality of private database log analysis engines, and triggering, data storage and the operation of applied business in the client database of source, export to professional interpretation module;
Professional interpretation module, be used for data that source client database applied business is changed and triggering, data storage and operation by decipher, convert standard SQL sentence to, and pass to the built-in normal data query engine module of destination end database by the internet;
Normal data query engine module is used for by standard SQL engine the application process that the standard SQL sentence of decipher offers the destination end database being carried out, thereby finishes the data sync with the source client database.
Above-mentioned system embodiment and device embodiment thereof of the present invention based on log analysis mechanism, its main design philosophy is, utilize support and the rolling back action of relevant database to the standard SQL statement, the change of final data is recorded in the daily record, the behavior that comes the acquisition database applied business by the change of analyzing data in the daily record, and be interpreted as standard SQL sentence by standard SQL interpreter engine, solved triggering professional between the disparate databases, data storage and operation wait the phraseological difference of some database descriptions, realizing the transmission of logical signal between the applied business between the disparate databases type, thereby guarantee the data consistency of source end and destination end.
The present invention is directed to above system embodiment and device embodiment thereof, the method embodiment that realizes database data migration under the heterogeneous platform correspondingly also is provided, its flow process comprises the steps: as shown in Figure 2
110:, and set up process, decipher process and the transmission process of catching for formation and transmit queue are caught in client database foundation in source;
Data migration device of the present invention is that the change data capture was caught formation and transmit queue with transmitting to set up respectively during the daily record of all kinds of sources client database was flowed, and process, decipher process and transmission process are caught in foundation simultaneously.
120: judge whether have free space, be then to carry out the following step if catching formation, otherwise execution in step 180;
130: the change data that the process of catching will be caught from source client database daily record stream are documented in successively catches in the formation;
After the filing switching takes place in the online daily record of source client database, as long as specify the path of archive log, catching process can continue daily record is analyzed by corresponding private database log analysis engine from the daily record position that stops to analyze of source client database daily record stream record, capture the data of change, thereby guarantee the consistance of data change.
140: judge whether transmit queue has free space, is then to carry out the following step, otherwise execution in step 190;
In case when the transmit queue space is full, can triggers the decipher process and stop decipher, when transmit queue has clearance spaces, trigger the decipher process again and carry out decipher.
150: the change data interpretation that the decipher process will be caught in the formation successively becomes standard SQL sentence, is documented in then in the transmit queue;
The decipher process will be caught after change data interpretation in the formation becomes standard SQL sentence successively by corresponding special-purpose SQL interpreter, be documented in the transmit queue.
160: the transmission process is transferred to the destination end database with the standard SQL sentence of putting down in writing in the transmit queue;
The transmission process can guarantee the strange land long-distance transmissions by based on ICP/IP protocol transmission SQL statement; And because the occupied bandwidth of SQL statement own is less, so can alleviate network pressure.
170: the destination end database is separated the data that translate applied business and change thereof by built-in standard SQL engine from standard SQL sentence, and offers the execution of application corresponding process, returns step 120 and carries out;
The destination end database is perceived the standard SQL sentence of transmission by monitoring, and moves the standard SQL sentence of decipher by application process in the destination end database, thereby realizes the real-time seamless migration of data between the heterogeneous platform.
180: the process of catching stops to catch, execution in step 140;
190: the decipher process stops decipher, execution in step 160.
In the whole implementation of said method embodiment, by in data migration device embodiment of the present invention, introduce the process of catching, decipher process, and the transmission process come to the data of changing in the client database of source catch, analysis and decipher, and it be transferred to the destination end database carry out by application process.These four processes all can not have any impact to the source client database, trigger relation by process work built-in among the data migration device embodiment of the present invention, even because accidental cause down falls, also can not cause the dig of the data of changing in the client database of source in certain process.
Said method embodiment of the present invention starts with from the operation logic of common relevant database, log analysis engine and SQL interpreter engine have been introduced, journal format difference between the distinct type data-base and SQL grammer difference are abstracted into and the irrelevant standard SQL sentence of type of database, and utilize the built-in standard SQL engine of destination end database that standard SQL sentence is interpreted as the statement that application process is carried out, thereby guarantee under the heterogeneous platform data synchronization between the heterogeneous database.
In addition,, coordinate synchronized relation between the process of catching, decipher process, the transmission process, to guarantee the not dig of data of source client database change by built-in trigger mechanism among the device embodiment.By analyzing the mechanism of daily record, do not influence the normal operation of source client database, very little to source client database performance impact simultaneously, and the data time-delay is less.
For those skilled in the art; after having understood content of the present invention and principle; can be under the situation that does not deviate from the principle and scope of the present invention; the method according to this invention is carried out various corrections and the change on form and the details, but these are based on correction of the present invention with change still within claim protection domain of the present invention.
Claims (9)
1. a system that realizes database data migration under the heterogeneous platform is characterized in that, comprises the source client database, data migration device and the destination end database that connect successively, wherein:
The source client database is used for the data that each applied business takes place to change are documented in daily record stream;
Data migration device, be used for catching the data that change takes place described applied business from the daily record stream of source client database record, convert the data of described change to the standard database query statement with the application corresponding business by corresponding decipher, and pass to the destination end database;
The destination end database is used for finishing data sync with the source client database by the query sentence of database of operative norm.
2. according to the described system of claim 1, it is characterized in that, described data migration device comprises general journal analysis engine module, dedicated log analysis engine module and the professional interpretation module that connects successively, and described destination end database is built-in with normal data query engine module; Wherein:
General journal analysis engine module is used for the daily record stream of described source client database record is assigned to the corresponding private database log analysis engine of dedicated log analysis engine module;
Dedicated log analysis engine module, be used for catching from described daily record stream according to database feature and journal format the data of described generation change by corresponding private database log analysis engine, and triggering, data storage and the operation of applied business in the client database of described source, export to professional interpretation module;
Professional interpretation module, be used for source client database applied business triggering, data storage and the operation of the data of change and described applied business is taken place by decipher, convert the Structured Query Language (SQL) statement of standard to, and pass to normal data query engine module in the described destination end database by the internet;
Normal data query engine module is used for by normal structure query language engine the Structured Query Language (SQL) statement of the standard of decipher being offered the application process execution of described destination end database.
3. a device of realizing database data migration under the heterogeneous platform comprises interconnective dedicated log analysis engine module and professional interpretation module, wherein:
Dedicated log analysis engine module is used for catching the data that change takes place applied business from the daily record stream of source client database record, and exports to professional interpretation module with described applied business;
Professional interpretation module is used for described applied business the data of change and described applied business is taken place by decipher, converts the Structured Query Language (SQL) statement of standard to, and passes to described destination end database.
4. according to the described device of claim 3, it is characterized in that, before described dedicated log analysis engine module, also comprise general journal analysis engine module, wherein:
General journal analysis engine module is used for the daily record stream of described source client database record is assigned to the corresponding private database log analysis engine of described dedicated log analysis engine module;
Described dedicated log analysis engine module is caught the data that described generation is changed according to database feature and journal format by corresponding private database log analysis engine from described daily record stream, and exports to described professional interpretation module with triggering, data storage and the operation of described applied business;
Triggering, data storage and the operation of the data of change and described applied business take place by decipher with described applied business in described professional interpretation module, convert the Structured Query Language (SQL) statement of standard to, and carry out decipher by the normal data query engine module that the internet passes in the described destination end database.
5. a method that realizes database data migration under the heterogeneous platform relates to source client database and data migration device and destination end database, and this method comprises:
The source client database is documented in the data that change takes place each applied business in the daily record stream;
Data migration device is caught the data that change takes place described applied business from the daily record stream of described source client database record, convert the data of described change to the standard database query statement with the application corresponding business, and be delivered to the destination end database.
6. in accordance with the method for claim 5, it is characterized in that, catch in described data migration device before the data of described applied business generation change, also comprise:
For formation and transmit queue are caught in client database foundation in described source, and set up process, decipher process and the transmission process of catching.
7. in accordance with the method for claim 6, it is characterized in that, described data migration device is caught the data that change takes place described applied business from the daily record stream of described source client database record, convert the data of described change to the standard database query statement with the application corresponding business, and by network delivery to the destination end database, specifically comprise:
The described process of catching is caught formation when free space is arranged described, after the filing switching takes place in the online daily record of described source client database, continue described daily record is analyzed from the daily record position that stops to analyze of described daily record stream record by corresponding private database log analysis engine, and the change data that will capture are documented in described catching in the formation;
Described decipher process when described transmit queue has free space, successively described change data interpretation of catching in the formation is become the Structured Query Language (SQL) statement of standard by corresponding application specific architecture query language interpreter after, be documented in the described transmit queue;
Described transmission process is given described destination end database with the Structured Query Language (SQL) statement of the described standard in the described transmit queue by internet transmission.
8. in accordance with the method for claim 7, it is characterized in that, also comprise:
Described destination end database is finished data sync with described source client database by the query sentence of database of operative norm.
9. in accordance with the method for claim 8, it is characterized in that described destination end database is finished data sync with described source client database by the query sentence of database of operative norm, specifically comprises:
Described destination end database listens to the Structured Query Language (SQL) statement of the described standard of transmission, from the Structured Query Language (SQL) statement of described standard, separate the data that translate described applied business and described change thereof by built-in normal structure query language engine, and offer the execution of application corresponding process.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011102059152A CN102262662A (en) | 2011-07-22 | 2011-07-22 | System, device and method for realizing database data migration in heterogeneous platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011102059152A CN102262662A (en) | 2011-07-22 | 2011-07-22 | System, device and method for realizing database data migration in heterogeneous platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102262662A true CN102262662A (en) | 2011-11-30 |
Family
ID=45009291
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011102059152A Pending CN102262662A (en) | 2011-07-22 | 2011-07-22 | System, device and method for realizing database data migration in heterogeneous platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102262662A (en) |
Cited By (25)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102508929A (en) * | 2011-12-01 | 2012-06-20 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing data migration of heterogeneous database |
| CN102722571A (en) * | 2012-06-05 | 2012-10-10 | 苏州微逸浪科技有限公司 | Report data processing method based on isomerous database |
| CN102917072A (en) * | 2012-10-31 | 2013-02-06 | 北京奇虎科技有限公司 | Device, system and method for carrying out data migration between data server clusters |
| CN103218402A (en) * | 2013-03-19 | 2013-07-24 | 上海宝信软件股份有限公司 | General database data structure, data migratory system and method thereof |
| CN103631831A (en) * | 2012-08-29 | 2014-03-12 | 阿里巴巴集团控股有限公司 | Data backup method and device |
| CN103685543A (en) * | 2013-12-23 | 2014-03-26 | 中国电子科技集团公司第三十研究所 | Method and system for data synchronism between heterogeneous databases |
| CN104462484A (en) * | 2014-12-18 | 2015-03-25 | 北京奇虎科技有限公司 | Data processing method, data processor and system |
| CN104573122A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool migrating from AIX platform to K-UX platform |
| CN104573123A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Sybase database migration tool migrating from AIX platform to K-UX platform |
| CN104573121A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | DB2 database migration tool migrating from AIX platform to K-UX platform |
| CN104598396A (en) * | 2015-02-03 | 2015-05-06 | 济南大学 | System and method for ensuring caching instantaneity and caching consistency of mass data |
| CN104679841A (en) * | 2015-02-11 | 2015-06-03 | 北京京东尚科信息技术有限公司 | Consumption terminal data flow copying method and system |
| CN104809200A (en) * | 2015-04-24 | 2015-07-29 | 联动优势科技有限公司 | Database synchronization method and device |
| CN104809201A (en) * | 2015-04-24 | 2015-07-29 | 联动优势科技有限公司 | Database synchronization method and device |
| CN104899332A (en) * | 2015-06-24 | 2015-09-09 | 浪潮(北京)电子信息产业有限公司 | Cross-platform migrating method and system for Sybase database |
| CN105447111A (en) * | 2015-11-13 | 2016-03-30 | 铜陵有色金属集团股份有限公司金冠铜业分公司 | Mysql and MongoDB data synchronization method and system |
| WO2016101752A1 (en) * | 2014-12-22 | 2016-06-30 | 北京奇虎科技有限公司 | Method and device for data synchronization |
| CN106412071A (en) * | 2016-10-08 | 2017-02-15 | 中国工商银行股份有限公司 | Data synchronization method and apparatus |
| CN106547892A (en) * | 2016-11-01 | 2017-03-29 | 山东浪潮云服务信息科技有限公司 | A kind of data resource management platform gathered based on internet data |
| CN106649828A (en) * | 2016-12-29 | 2017-05-10 | 中国银联股份有限公司 | Data query method and system |
| CN103761318B (en) * | 2014-01-27 | 2017-08-18 | 中国工商银行股份有限公司 | A kind of method and system of relationship type synchronization of data in heterogeneous database |
| CN108241676A (en) * | 2016-12-26 | 2018-07-03 | 阿里巴巴集团控股有限公司 | Realize the method and apparatus that data synchronize |
| CN109933416A (en) * | 2019-02-01 | 2019-06-25 | 广东安可云科技有限公司 | A kind of moving method, device and storage medium using data |
| CN110597914A (en) * | 2019-09-18 | 2019-12-20 | 北京思维造物信息科技股份有限公司 | Data transmission system, method, device and equipment |
| CN113220711A (en) * | 2021-05-19 | 2021-08-06 | 李坚白 | Method and system for synchronizing heterogeneous robot controller databases |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1201949A (en) * | 1997-05-09 | 1998-12-16 | 美国电报电话公司 | Apparatus and method for maintaining integrated data consistency across multiple databases |
| US6381595B1 (en) * | 1994-09-29 | 2002-04-30 | International Business Machines Corporation | System and method for compensation of functional differences between heterogeneous database management systems |
| CN1407465A (en) * | 2001-08-13 | 2003-04-02 | 深圳市丛文软件技术有限公司 | Data exchanging method and device between different databases with different structure |
| CN101615199A (en) * | 2009-07-31 | 2009-12-30 | 深圳市珍爱网信息技术有限公司 | Heterogeneous database synchronization method and system |
| CN101754221A (en) * | 2008-12-19 | 2010-06-23 | 中国移动通信集团山东有限公司 | Data transmission method between heterogeneous systems and data transmission system |
| CN101957865A (en) * | 2010-10-27 | 2011-01-26 | 杭州新中大软件股份有限公司 | Data exchange and sharing technology among heterogeneous systems |
| CN102063502A (en) * | 2011-01-06 | 2011-05-18 | 天津神舟通用数据技术有限公司 | Method for realizing synchronization of data in heterogeneous database |
| CN102081656A (en) * | 2011-01-12 | 2011-06-01 | 江苏梦兰神彩科技发展有限公司 | Data acquisition and distribution system of cross-platform heterogeneous database |
| CN102129478A (en) * | 2011-04-26 | 2011-07-20 | 广州从兴电子开发有限公司 | Database synchronization method and system thereof |
-
2011
- 2011-07-22 CN CN2011102059152A patent/CN102262662A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6381595B1 (en) * | 1994-09-29 | 2002-04-30 | International Business Machines Corporation | System and method for compensation of functional differences between heterogeneous database management systems |
| CN1201949A (en) * | 1997-05-09 | 1998-12-16 | 美国电报电话公司 | Apparatus and method for maintaining integrated data consistency across multiple databases |
| CN1407465A (en) * | 2001-08-13 | 2003-04-02 | 深圳市丛文软件技术有限公司 | Data exchanging method and device between different databases with different structure |
| CN101754221A (en) * | 2008-12-19 | 2010-06-23 | 中国移动通信集团山东有限公司 | Data transmission method between heterogeneous systems and data transmission system |
| CN101615199A (en) * | 2009-07-31 | 2009-12-30 | 深圳市珍爱网信息技术有限公司 | Heterogeneous database synchronization method and system |
| CN101957865A (en) * | 2010-10-27 | 2011-01-26 | 杭州新中大软件股份有限公司 | Data exchange and sharing technology among heterogeneous systems |
| CN102063502A (en) * | 2011-01-06 | 2011-05-18 | 天津神舟通用数据技术有限公司 | Method for realizing synchronization of data in heterogeneous database |
| CN102081656A (en) * | 2011-01-12 | 2011-06-01 | 江苏梦兰神彩科技发展有限公司 | Data acquisition and distribution system of cross-platform heterogeneous database |
| CN102129478A (en) * | 2011-04-26 | 2011-07-20 | 广州从兴电子开发有限公司 | Database synchronization method and system thereof |
Cited By (36)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102508929A (en) * | 2011-12-01 | 2012-06-20 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing data migration of heterogeneous database |
| CN102722571A (en) * | 2012-06-05 | 2012-10-10 | 苏州微逸浪科技有限公司 | Report data processing method based on isomerous database |
| CN103631831A (en) * | 2012-08-29 | 2014-03-12 | 阿里巴巴集团控股有限公司 | Data backup method and device |
| CN103631831B (en) * | 2012-08-29 | 2016-12-21 | 阿里巴巴集团控股有限公司 | A kind of data back up method and device |
| CN102917072A (en) * | 2012-10-31 | 2013-02-06 | 北京奇虎科技有限公司 | Device, system and method for carrying out data migration between data server clusters |
| CN102917072B (en) * | 2012-10-31 | 2016-07-13 | 北京奇虎科技有限公司 | For carrying out the equipment of Data Migration, system and method between data server cluster |
| CN103218402A (en) * | 2013-03-19 | 2013-07-24 | 上海宝信软件股份有限公司 | General database data structure, data migratory system and method thereof |
| CN103218402B (en) * | 2013-03-19 | 2016-07-06 | 上海宝信软件股份有限公司 | General database data structure and data mover system and method thereof |
| CN103685543A (en) * | 2013-12-23 | 2014-03-26 | 中国电子科技集团公司第三十研究所 | Method and system for data synchronism between heterogeneous databases |
| CN103761318B (en) * | 2014-01-27 | 2017-08-18 | 中国工商银行股份有限公司 | A kind of method and system of relationship type synchronization of data in heterogeneous database |
| CN104462484B (en) * | 2014-12-18 | 2018-05-22 | 北京奇虎科技有限公司 | Data processing method, data processor and system |
| CN104462484A (en) * | 2014-12-18 | 2015-03-25 | 北京奇虎科技有限公司 | Data processing method, data processor and system |
| WO2016101752A1 (en) * | 2014-12-22 | 2016-06-30 | 北京奇虎科技有限公司 | Method and device for data synchronization |
| CN104598396A (en) * | 2015-02-03 | 2015-05-06 | 济南大学 | System and method for ensuring caching instantaneity and caching consistency of mass data |
| CN104598396B (en) * | 2015-02-03 | 2017-06-16 | 济南大学 | A kind of system and method for ensureing mass data caching real-time and uniformity |
| CN104573121A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | DB2 database migration tool migrating from AIX platform to K-UX platform |
| CN104573123A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Sybase database migration tool migrating from AIX platform to K-UX platform |
| CN104573122B (en) * | 2015-02-09 | 2017-10-13 | 浪潮电子信息产业股份有限公司 | It is a kind of from AIX platforms to the oracle database Migration tools of K UX platform migrations |
| CN104573122A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool migrating from AIX platform to K-UX platform |
| CN104679841A (en) * | 2015-02-11 | 2015-06-03 | 北京京东尚科信息技术有限公司 | Consumption terminal data flow copying method and system |
| CN104679841B (en) * | 2015-02-11 | 2018-06-08 | 北京京东尚科信息技术有限公司 | A kind of consumption terminal data flow replication method and system |
| CN104809200B (en) * | 2015-04-24 | 2018-11-16 | 联动优势科技有限公司 | A kind of method and apparatus of database synchronization |
| CN104809201A (en) * | 2015-04-24 | 2015-07-29 | 联动优势科技有限公司 | Database synchronization method and device |
| CN104809200A (en) * | 2015-04-24 | 2015-07-29 | 联动优势科技有限公司 | Database synchronization method and device |
| CN104809201B (en) * | 2015-04-24 | 2018-11-16 | 联动优势科技有限公司 | A kind of method and apparatus of database synchronization |
| CN104899332A (en) * | 2015-06-24 | 2015-09-09 | 浪潮(北京)电子信息产业有限公司 | Cross-platform migrating method and system for Sybase database |
| CN105447111A (en) * | 2015-11-13 | 2016-03-30 | 铜陵有色金属集团股份有限公司金冠铜业分公司 | Mysql and MongoDB data synchronization method and system |
| CN106412071A (en) * | 2016-10-08 | 2017-02-15 | 中国工商银行股份有限公司 | Data synchronization method and apparatus |
| CN106547892A (en) * | 2016-11-01 | 2017-03-29 | 山东浪潮云服务信息科技有限公司 | A kind of data resource management platform gathered based on internet data |
| CN108241676A (en) * | 2016-12-26 | 2018-07-03 | 阿里巴巴集团控股有限公司 | Realize the method and apparatus that data synchronize |
| CN108241676B (en) * | 2016-12-26 | 2022-09-02 | 阿里云计算有限公司 | Method and equipment for realizing data synchronization |
| CN106649828A (en) * | 2016-12-29 | 2017-05-10 | 中国银联股份有限公司 | Data query method and system |
| CN109933416A (en) * | 2019-02-01 | 2019-06-25 | 广东安可云科技有限公司 | A kind of moving method, device and storage medium using data |
| CN109933416B (en) * | 2019-02-01 | 2023-09-05 | 广东安可云科技有限公司 | Application data migration method and device and storage medium |
| CN110597914A (en) * | 2019-09-18 | 2019-12-20 | 北京思维造物信息科技股份有限公司 | Data transmission system, method, device and equipment |
| CN113220711A (en) * | 2021-05-19 | 2021-08-06 | 李坚白 | Method and system for synchronizing heterogeneous robot controller databases |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102262662A (en) | System, device and method for realizing database data migration in heterogeneous platform | |
| CN103699580B (en) | Database synchronization method and device | |
| CN102508929A (en) | System, device and method for realizing data migration of heterogeneous database | |
| CN106462484B (en) | Distributed stream processing in cloud | |
| CN103441900B (en) | Centralized cross-platform automatization test system and control method thereof | |
| CN105005618A (en) | Data synchronization method and system among heterogeneous databases | |
| CN101252471B (en) | Distributed automatization test system and method | |
| CN104809202B (en) | A kind of method and apparatus of database synchronization | |
| CN103455557B (en) | A kind of structural data synchronous method based on daily record | |
| CN102402596B (en) | A kind of reading/writing method of master slave separation database and system | |
| CN105868343B (en) | Database migration method and system | |
| EP2541413A1 (en) | Systems and Methods for Data Integrity Checking | |
| CN100587693C (en) | Method and system for obtaining data from a plurality of data pool | |
| CN101187888A (en) | Method for coping database data in heterogeneous environment | |
| WO2015062181A1 (en) | Method for achieving automatic synchronization of multisource heterogeneous data resources | |
| CN103345502B (en) | Transaction processing method and system of distributed type database | |
| CN104679841A (en) | Consumption terminal data flow copying method and system | |
| CN102662795A (en) | Metadata fault-tolerant recovery method in distributed storage system | |
| CN110309161A (en) | A kind of method of data synchronization, device and server | |
| CN102968339B (en) | System and method for realizing complicated event handling based on cloud computing architecture | |
| US10192177B2 (en) | Automated assignment of errors in deployed code | |
| CN105354328B (en) | A kind of system and method solving the access conflict of NoSQL database concurrency | |
| CN109241156A (en) | The method updated based on ETL tool from relevant database to non-relational database | |
| Waas | Beyond Conventional Data Warehousing—Massively Parallel Data Processing with Greenplum Database: (Invited Talk) | |
| CN102075341B (en) | Method and system for main-standby synchronization |
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: 20111130 |