CN101187888A - Method for coping database data in heterogeneous environment - Google Patents
Method for coping database data in heterogeneous environment Download PDFInfo
- Publication number
- CN101187888A CN101187888A CNA2007101150970A CN200710115097A CN101187888A CN 101187888 A CN101187888 A CN 101187888A CN A2007101150970 A CNA2007101150970 A CN A2007101150970A CN 200710115097 A CN200710115097 A CN 200710115097A CN 101187888 A CN101187888 A CN 101187888A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- sql statement
- source client
- 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
- 238000000034 method Methods 0.000 title claims abstract description 31
- 230000010485 coping Effects 0.000 title claims description 3
- 238000004458 analytical method Methods 0.000 claims abstract description 13
- 230000009897 systematic effect Effects 0.000 claims abstract description 4
- 230000005540 biological transmission Effects 0.000 claims description 19
- 230000015572 biosynthetic process Effects 0.000 claims description 7
- 238000013507 mapping Methods 0.000 claims description 6
- 238000012545 processing Methods 0.000 claims description 4
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000009795 derivation Methods 0.000 claims description 3
- 238000007689 inspection Methods 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 description 15
- 230000010076 replication Effects 0.000 description 5
- 238000004519 manufacturing process Methods 0.000 description 3
- 238000009825 accumulation Methods 0.000 description 1
- 239000000654 additive Substances 0.000 description 1
- 230000000996 additive effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005538 encapsulation Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 238000013519 translation Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method which realizes data reproduction of a database in an isomeric environment, which gains SQL sentences which cause changes of a source end database through analysis of journals of the source end database, and the SQL sentences are organized according to work, then the SQL sentences which are organized are transmitted to a target end database, and the SQL sentences are executed according to the sequence which is executed in the source end database in the target end database to realize reproduction of the database. The method can suit isomeric environments, and has no isomorphic requirements of storing devices, servers, operating systems, and database software of the source end and the target end, and the method has the advantages of excellent adaptability, which occupies little systematic resource and network bandwidth resource.
Description
1, technical field
The present invention relates to computer realm, specifically a kind of method that the fulfillment database data are duplicated in isomerous environment.
2, background technology
Be accompanied by informatization, the user more and more payes attention to for data, to also more and more higher with the continuity requirement of business, generally all operation system can be based upon on the basis of database software, and can set up disaster tolerance system.In disaster tolerance system, the data in production data storehouse need be copied in the backup database, at present from storage, SAN, operating system, to operation layer, the reproduction technology that oneself is all arranged at all levels.
1) based on the reproduction technology of storing
All there is the disaster recovery solution based on memory device in the memory device manufacturer of main flow on its storage products at present, such as the SRDF of EMC, and the PPRC of IBM.This solution is a kind of physics mirror image of data storage, it on physical layer, is made data in two cover memory devices or generates two sets of data mirror images by SAN, when the production system of this locality breaks down, the standby system main frame can connect backup storage system, opens professional.
2) based on the reproduction technology of SAN
The reproduction technology of SAN is at SAN level intercepted data write operation by virtual memory technique, and carry out remote copy, all data that leave on the LUN (disk volume) of virtual memory management can both be replicated automatically, and irrelevant with business, application even server, simplified disaster tolerance design and enforcement greatly.But duplicate similarly with the storage data, the data replication bandwidth of SAN layer requires higher, and relatively poor for the protection of accumulation increment, may therefore need more bandwidth to remove copy data because data be overflowed.
3) based on the reproduction technology of operating system
Itself just has the image feature that data are striden memory device some operating system such as AIX.With this machine hard disk list mirror image be provided with different, this calamity is equipped with mode can initiate to preserve two parts of identical data by SAN by operating system between two memory devices.When the production system of this locality broke down, the standby system main frame can connect backup storage system, opened professional.Such as the GEORM of IBM, Storage Replicator, the VolumeReplicator etc. of VERITAS are exactly to adopt this technology.
4) based on the reproduction technology of business
Be fit to the application of three-tier architecture based on the Data Replication Technology in Mobile of business, except storage, outside the host computer system, also need the middleware server the same with the production center at disaster recovery center.Based on the Data Replication Technology in Mobile of business is so that identical input to be provided, and identical processing guarantees identical output, thereby reaches the purpose that data are duplicated.Therefore,,, need and business procedure exploitation combination, realize complexity, be not suitable for molded business though trade identity is good based on the Data Replication Technology in Mobile of business.
In sum,, memory device is required height, can not support the storage platform and the database host of isomery based on the reproduction technology of storage; Based on the reproduction technology of business,, be not suitable for ripe service application environment because it combines closely with business procedure; Based on the Data Replication Technology in Mobile of SAN and operating system, its database is in and returns to form, and realizes relatively difficulty of application switching, needs the startup of a start-up course and database can not successfully start owing to inconsistent causing of data such as database.
3, summary of the invention
The clone method that the purpose of this invention is to provide a kind of database data solves the heterogeneous platform support, system resource takies and the problem of real-time.
The invention provides a kind of reproduction technology based on platform software, a kind of clone method of database data specifically, method of the present invention realizes in the following manner, by the daily record of source client database is analyzed, obtain the SQL statement that causes that the source client database changes, and these SQL statement are organized according to affairs, the SQL statement that these are organized is transferred to the destination end database then, and carry out these SQL statement according to its order of carrying out in the source client database at the destination end database, duplicating of fulfillment database data, the data copy step is as follows.
1) log acquisition and analysis
Reading the control documents of source client database in real time by the log analysis module, and analyze, whether have the SQL statement execution that cause source client database change, and will cause that the SQL statement that the source client database changes is kept in the file if checking.To obtaining of data is type of transaction and the data of obtaining the database source end by the proxy module timing analysis database redo log that is installed in the database source end.The agency judges by making regular check on current SCN number of writing down in the database control documents whether the source client database has new transaction to produce, and avoids each inspection all by reading the systematic influence that journal file judges whether that new transaction causes when producing like this.When in control documents, confirming to have new transaction to produce, can obtain current redo log group simultaneously, and up-to-date day aims at the latest position of journal file.The daily record position of record and the daily record between this latest position that reads were read and are analyzed when proxy module will obtain according to these information last time.These data are kept in the online daily record Cache file then, wait for next step synthetic processing of transacting business.
2) SQL statement is synthetic: the SQL statement that will obtain after will analyzing is recombinated.For the controllability that improves system, guarantee the logic integrality, avoid loss of data that SQL statement is organized according to affairs, to guarantee only to duplicate the transaction SQL statement of submission.
3) Cao Zuo transmission: data at first deposited the Cache of source client database in before transmission in transmission course, and the transmission process reads transaction data according to the principle of first in first out and is encapsulated as the importing process that the TCP/IP packet sends the destination end database to from Cache.The characteristic information of bag has been described in the header part of the packet that encapsulates.At the destination end database, the importing process is after receiving the transaction data package of transmission, at first the validity checking that the characteristic information of bag transmits is described according to packet header, judge whether to transmit complete, if transmit complete, then deposit formation in, then from formation, load Transaction Information in strict accordance with its execution sequence in the source client database by the importing process; If transmit imperfectly, send a repeat requests then for source client database derivation process.
When source client database and destination end database are the database of disparate databases brand, can on the agency, its type of database be set in advance, to carry out the SQL statement conversion in destination end after the convenient end of transmission (EOT).
SQL statement in the trade transactions exists a large amount of Where clause's operations, when the standard of employing SQL statement is carried out these operations, system needs the at first positional information of the data file at localizing objects record place, this will bring a large amount of search index expenses, when thousands of instructions of concurrent execution, it is very huge that the expense of system will become.The mode of the present invention by row mapping realizes the quick location of writing down: when reading SQL statement from source first day of the lunar year will file, will obtain the rowid of this statement corresponding record simultaneously; When this SQL statement when destination end is carried out, system is not translated as Where clause, but obtain the rowid of the position of corresponding this record of destination end by the capable mapping table that is kept at destination end, thereby can directly be positioned the position that these data need write in destination end by rowid, avoid a large amount of index search time.
The invention has the beneficial effects as follows: 1) can support isomerous environment, comprise the server of isomery, the memory device of isomery, the operating system of isomery, the Database Systems of isomery.2) adopt the present invention to carry out duplicating of database data, the data that need duplicate have been saved the system resource and the network bandwidth far fewer than additive method.
4, description of drawings
Fig. 1 is the isomerous environment system construction drawing
5, embodiment
The present invention can be used in the disaster tolerance system of isomerous environment, the method for duplicating as data.In the reproduction process, by the daily record of source client database is analyzed, obtain the SQL statement that causes that the source client database changes, and these SQL statement are organized according to affairs, the SQL statement that these are organized is transferred to the destination end database then, and carry out these SQL statement according to its order of carrying out in the source client database at the destination end database, and the duplicating of fulfillment database data, concrete copy step is as follows:
A) at first carrying out log analysis, read the control documents of source client database in real time by the log analysis module, and analyze, whether have the SQL statement execution that causes that the source client database changes, and will cause the source terminal number if checking
B) SQL statement that changes according to the storehouse is kept in the file;
C) SQL statement that obtains after will analyzing is organized according to affairs;
D) SQL statement of organizing is encapsulated, be packaged into the TCP/IP bag, the characteristic information of bag is described in the header part of the packet of encapsulation, to be used for data consistent check;
E) after destination end receives data packets for transmission, the at first validity checking transmitted of the characteristic information of the bag of describing according to packet header, judge whether to transmit complete, if transmit completely, then deposit in the formation, then load affairs at the trading order of source end at the destination end database in strict accordance with affairs, promptly carry out the SQL statement in the affairs, if transmit imperfectly, send a repeat requests then for the source client database, retransmit problematic affairs.
Affairs described in the step b) is characterized in that all SQL statement that affairs comprise do as a wholely, perhaps all complete, perhaps all do not carry out.
Carry out SQL statement in destination end described in the step d), further comprise, after the destination end database received affairs, according to the type of destination end database software, will convert to from the SQL statement that the source end sends can be in the SQL statement of destination end database execution.
Embodiment
Method of the present invention is to carry out data in the database aspect to duplicate, the transaction copy mode of logic-based is provided at database, by directly catching the transaction of source client database, with the change logic copy of database in the destination end database, the consistance of realization source client database and destination end database data
In the reproduction process, when carrying out log analysis, for update and insert statement, obtain the rowid of the performed concrete database data record of this statement simultaneously, when the destination end database is carried out these SQL statement, directly on the rowid of the destination end data-base recording of correspondence, carry out, no longer need to carry out complicated positioning action, can reduce the expense of system resource to greatest extent.
At first carry out log analysis, read the control documents of source client database in real time by the log analysis module, and analyze, whether have the SQL statement execution that cause source client database change, and will cause that the SQL statement that the source client database changes is kept in the file if checking.To obtaining of data is type of transaction and the data of obtaining the database source end by the proxy module timing analysis database redo log that is installed in the database source end.The agency judges by making regular check on current SCN number of writing down in the database control documents whether the source client database has new transaction to produce, and avoids each inspection all by reading the systematic influence that journal file judges whether that new transaction causes when producing like this.When in control documents, confirming to have new transaction to produce, can obtain current redo log group simultaneously, and up-to-date day aims at the latest position of journal file.The daily record position of record and the daily record between this latest position that reads were read and are analyzed when proxy module will obtain according to these information last time.These data are kept in the online daily record Cache file then, wait for next step synthetic processing of transacting business.
The SQL statement that will obtain after will analyzing is then recombinated.For the controllability that improves system, guarantee the logic integrality, avoid loss of data that SQL statement is organized according to affairs, to guarantee only to duplicate the transaction SQL statement of submission.
Then carry out the transmission of data.Data at first deposited the Cache of source client database in before transmission in transmission course, and the transmission process reads transaction data according to the principle of first in first out and is encapsulated as the importing process that the TCP/IP packet sends the destination end database to from Cache.The characteristic information of bag has been described in the header part of the packet that encapsulates.At the destination end database, the importing process is after receiving the transaction data package of transmission, at first the validity checking that the characteristic information of bag transmits is described according to packet header, judge whether to transmit complete, if transmit complete, then deposit formation in, then from formation, load Transaction Information in strict accordance with its execution sequence in the source client database by the importing process; If transmit imperfectly, send a repeat requests then for source client database derivation process.
When source client database and destination end database are the database product of different vendor, can on the agency, its type of database be set in advance, to carry out the SQL statement conversion in destination end after the convenient end of transmission (EOT).Translation function can realize by revising nested code.
SQL statement in the trade transactions exists a large amount of Where clause's operations, when the standard of employing SQL statement is carried out these operations, system needs the at first positional information of the data file at localizing objects record place, this will bring a large amount of search index expenses, when thousands of instructions of concurrent execution, it is very huge that the expense of system will become.The mode of the present invention by row mapping realizes the quick location of writing down: when reading SQL statement from source first day of the lunar year will file, will obtain the rowid of this statement corresponding record simultaneously; When this SQL statement when destination end is carried out, system is not translated as Where clause, but obtain the rowid of the position of corresponding this record of destination end by the capable mapping table that is kept at destination end, thereby can directly be positioned the position that these data need write in destination end by rowid, avoid a large amount of index search time.
Claims (2)
1. the method for coping database data in the isomerous environment, be characterised in that, by the daily record of source client database is analyzed, obtain the SQL statement that causes that the source client database changes, and these SQL statement are organized according to affairs, the SQL statement that these are organized is transferred to the destination end database then, and carries out these SQL statement at the destination end database according to its order of carrying out in the source client database, duplicating of fulfillment database data, the data copy step is as follows:
1) log acquisition and analysis: read the control documents of source client database in real time by the log analysis module, analytical review causes that the SQL statement that the source client database changes carries out, if having, just will cause that the SQL statement of source client database change is kept in the file; To obtaining of data is type of transaction and the data of obtaining the database source end by the proxy module timing analysis database redo log that is installed in the database source end, the agency judges by making regular check on current SCN number of writing down in the database control documents whether the source client database has new transaction to produce, avoid each inspection all by reading the systematic influence that journal file judges whether that new transaction causes when producing like this, when in control documents, confirming to have new transaction to produce, can obtain current redo log group simultaneously, and up-to-date day aims at the latest position of journal file, the daily record position of record and the daily record between this latest position that reads were read and are analyzed when proxy module will obtain according to these information last time, these data are kept in the online daily record Cache file then, wait for next step synthetic processing of transacting business;
2) SQL statement is synthetic: the SQL statement that will obtain after will analyzing is recombinated, for the controllability that improves system, guarantee the logic integrality, avoid loss of data that SQL statement is organized according to affairs, only duplicates the transaction SQL statement of submission with assurance;
3) Cao Zuo transmission: data at first deposited the Cache of source client database in before transmission in transmission course, the transmission process reads transaction data according to the principle of first in first out and is encapsulated as the importing process that the TCP/IP packet sends the destination end database to from Cache, the characteristic information of bag has been described in the header part of the packet that encapsulates, at the destination end database, the importing process is after receiving the transaction data package of transmission, at first the validity checking that the characteristic information of bag transmits is described according to packet header, judge whether to transmit complete, if transmit complete, then deposit formation in, then from formation, load Transaction Information in strict accordance with its execution sequence in the source client database by the importing process; If transmit imperfectly, send a repeat requests then for source client database derivation process;
4) when source client database and destination end database are the database of disparate databases brand, on the agency, its type of database is set in advance, after end of transmission (EOT), carry out the SQL statement conversion in destination end.
2. require 1 described method according to reason, be characterised in that, adopt the standard SQL statement to carry out Where clause's operation in the trade transactions, the positional information of the data file at system queries localizing objects record place is that the mode by the row mapping realizes the quick location of writing down: when reading SQL statement from source first day of the lunar year will file, will obtain the rowid of this statement corresponding record simultaneously; When this SQL statement when destination end is carried out, obtain the rowid of the position of corresponding this record of destination end by the capable mapping table that is kept at destination end, thereby directly be positioned the position that these data need write by rowid in destination end.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2007101150970A CN101187888A (en) | 2007-12-11 | 2007-12-11 | Method for coping database data in heterogeneous environment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2007101150970A CN101187888A (en) | 2007-12-11 | 2007-12-11 | Method for coping database data in heterogeneous environment |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101187888A true CN101187888A (en) | 2008-05-28 |
Family
ID=39480293
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNA2007101150970A Pending CN101187888A (en) | 2007-12-11 | 2007-12-11 | Method for coping database data in heterogeneous environment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101187888A (en) |
Cited By (32)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101944114A (en) * | 2010-09-16 | 2011-01-12 | 深圳天源迪科信息技术股份有限公司 | Data synchronization method between memory database and physical database |
CN101807314B (en) * | 2009-02-17 | 2011-09-14 | 同济大学 | Method for processing embedded vehicle working condition hybrid heterogeneous data information in real time |
CN101488960B (en) * | 2009-03-04 | 2012-02-01 | 哈尔滨工程大学 | Apparatus and method for TCP protocol and data recovery based on parallel processing |
CN102346775A (en) * | 2011-09-26 | 2012-02-08 | 苏州博远容天信息科技有限公司 | Method for synchronizing multiple heterogeneous source databases based on log |
CN102402562A (en) * | 2010-09-14 | 2012-04-04 | 中兴通讯股份有限公司 | Database remote disaster tolerant method and system |
CN102855314A (en) * | 2012-08-27 | 2013-01-02 | 济南大学 | Real-time database backup system and method based on FPGA (field programmable gate array) |
CN102930035A (en) * | 2011-11-10 | 2013-02-13 | 微软公司 | Driving content items from multiple different content sources |
CN103064976A (en) * | 2013-01-14 | 2013-04-24 | 浙江水利水电专科学校 | Data for exchanging data among homogenous and heterogenous DBMSs (database management systems) on basis of active database technology |
CN102073640B (en) * | 2009-11-19 | 2013-12-18 | 阿里巴巴集团控股有限公司 | Method, system and server for testing structured query language (SQL) statements |
CN103870357A (en) * | 2012-12-17 | 2014-06-18 | 中国移动通信集团河南有限公司 | Method and system for carrying out data replication |
CN105005618A (en) * | 2015-07-21 | 2015-10-28 | 杭州合众数据技术有限公司 | Data synchronization method and system among heterogeneous databases |
CN105045678A (en) * | 2015-07-09 | 2015-11-11 | 小米科技有限责任公司 | Database recovery method and apparatus |
CN105589924A (en) * | 2015-11-23 | 2016-05-18 | 江苏瑞中数据股份有限公司 | Transaction granularity synchronizing method of database |
CN106021593A (en) * | 2016-06-07 | 2016-10-12 | 浪潮电子信息产业股份有限公司 | Replication processing method in takeover process of first database and second database |
CN106155835A (en) * | 2015-04-07 | 2016-11-23 | 北京中科同向信息技术有限公司 | A kind of disaster recovery method based on synchronization replication technology |
CN106412071A (en) * | 2016-10-08 | 2017-02-15 | 中国工商银行股份有限公司 | Data synchronization method and apparatus |
CN106777270A (en) * | 2016-12-28 | 2017-05-31 | 中国民航信息网络股份有限公司 | A kind of Heterogeneous Database Replication parallel execution system and method based on submission point time line locking |
CN106970920A (en) * | 2016-01-14 | 2017-07-21 | 阿里巴巴集团控股有限公司 | A kind of method and apparatus for database data migration |
CN107004010A (en) * | 2014-12-08 | 2017-08-01 | 国际商业机器公司 | Controlling multiple database systems |
US9817898B2 (en) | 2011-11-14 | 2017-11-14 | Microsoft Technology Licensing, Llc | Locating relevant content items across multiple disparate content sources |
CN107678888A (en) * | 2017-09-30 | 2018-02-09 | 北京九桥同步软件有限公司 | database data backup method and device |
CN108228756A (en) * | 2017-12-21 | 2018-06-29 | 江苏瑞中数据股份有限公司 | Data based on the PG databases of daily record analytic technique to Hadoop platform synchronize clone method |
CN109634972A (en) * | 2018-11-12 | 2019-04-16 | 武汉达梦数据库有限公司 | A kind of method positioned when data are synchronous using ROWID |
CN109905475A (en) * | 2019-02-28 | 2019-06-18 | 上海浪潮云计算服务有限公司 | A method of cloud computing monitoring data is exported with prescribed form based on SQL |
US10360236B2 (en) | 2015-09-25 | 2019-07-23 | International Business Machines Corporation | Replicating structured query language (SQL) in a heterogeneous replication environment |
CN110263057A (en) * | 2019-06-12 | 2019-09-20 | 上海英方软件股份有限公司 | A kind of storage/the querying method and device of ROWID mapping table |
CN110543513A (en) * | 2018-05-29 | 2019-12-06 | 中兴通讯股份有限公司 | incremental data synchronization method, equipment and storage medium for distributed database |
CN111444278A (en) * | 2020-04-01 | 2020-07-24 | Oppo(重庆)智能科技有限公司 | Data synchronization method and device and transfer server |
CN113157807A (en) * | 2021-04-19 | 2021-07-23 | 南京南瑞继保工程技术有限公司 | Data copying method, device and storage medium |
CN113220711A (en) * | 2021-05-19 | 2021-08-06 | 李坚白 | Method and system for synchronizing heterogeneous robot controller databases |
CN113326318A (en) * | 2021-05-28 | 2021-08-31 | 广州市炬元互联网科技有限公司 | Method and system for data synchronization between two systems |
CN113396407A (en) * | 2018-12-04 | 2021-09-14 | 泽乌科技公司 | System and method for augmenting database applications using blockchain techniques |
-
2007
- 2007-12-11 CN CNA2007101150970A patent/CN101187888A/en active Pending
Cited By (45)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101807314B (en) * | 2009-02-17 | 2011-09-14 | 同济大学 | Method for processing embedded vehicle working condition hybrid heterogeneous data information in real time |
CN101488960B (en) * | 2009-03-04 | 2012-02-01 | 哈尔滨工程大学 | Apparatus and method for TCP protocol and data recovery based on parallel processing |
CN102073640B (en) * | 2009-11-19 | 2013-12-18 | 阿里巴巴集团控股有限公司 | Method, system and server for testing structured query language (SQL) statements |
CN102402562A (en) * | 2010-09-14 | 2012-04-04 | 中兴通讯股份有限公司 | Database remote disaster tolerant method and system |
CN101944114A (en) * | 2010-09-16 | 2011-01-12 | 深圳天源迪科信息技术股份有限公司 | Data synchronization method between memory database and physical database |
CN101944114B (en) * | 2010-09-16 | 2012-07-25 | 深圳天源迪科信息技术股份有限公司 | Data synchronization method between memory database and physical database |
CN102346775A (en) * | 2011-09-26 | 2012-02-08 | 苏州博远容天信息科技有限公司 | Method for synchronizing multiple heterogeneous source databases based on log |
CN102930035A (en) * | 2011-11-10 | 2013-02-13 | 微软公司 | Driving content items from multiple different content sources |
US9996618B2 (en) | 2011-11-14 | 2018-06-12 | Microsoft Technology Licensing, Llc | Locating relevant content items across multiple disparate content sources |
US9817898B2 (en) | 2011-11-14 | 2017-11-14 | Microsoft Technology Licensing, Llc | Locating relevant content items across multiple disparate content sources |
CN102855314B (en) * | 2012-08-27 | 2015-04-08 | 济南大学 | Real-time database backup system and method based on FPGA (field programmable gate array) |
CN102855314A (en) * | 2012-08-27 | 2013-01-02 | 济南大学 | Real-time database backup system and method based on FPGA (field programmable gate array) |
CN103870357A (en) * | 2012-12-17 | 2014-06-18 | 中国移动通信集团河南有限公司 | Method and system for carrying out data replication |
CN103064976B (en) * | 2013-01-14 | 2015-10-28 | 浙江水利水电学院 | Based on active database technology same isomery DBMS between method for interchanging data |
CN103064976A (en) * | 2013-01-14 | 2013-04-24 | 浙江水利水电专科学校 | Data for exchanging data among homogenous and heterogenous DBMSs (database management systems) on basis of active database technology |
US11176171B2 (en) | 2014-12-08 | 2021-11-16 | International Business Machines Corporation | Controlling a multi-database system |
CN107004010A (en) * | 2014-12-08 | 2017-08-01 | 国际商业机器公司 | Controlling multiple database systems |
CN107004010B (en) * | 2014-12-08 | 2020-08-11 | 国际商业机器公司 | Controlling multiple database systems |
CN106155835A (en) * | 2015-04-07 | 2016-11-23 | 北京中科同向信息技术有限公司 | A kind of disaster recovery method based on synchronization replication technology |
CN105045678A (en) * | 2015-07-09 | 2015-11-11 | 小米科技有限责任公司 | Database recovery method and apparatus |
CN105045678B (en) * | 2015-07-09 | 2018-10-26 | 小米科技有限责任公司 | Database restoring method and device |
CN105005618A (en) * | 2015-07-21 | 2015-10-28 | 杭州合众数据技术有限公司 | Data synchronization method and system among heterogeneous databases |
US10360236B2 (en) | 2015-09-25 | 2019-07-23 | International Business Machines Corporation | Replicating structured query language (SQL) in a heterogeneous replication environment |
US10366105B2 (en) | 2015-09-25 | 2019-07-30 | International Business Machines Corporation | Replicating structured query language (SQL) in a heterogeneous replication environment |
CN105589924A (en) * | 2015-11-23 | 2016-05-18 | 江苏瑞中数据股份有限公司 | Transaction granularity synchronizing method of database |
CN106970920A (en) * | 2016-01-14 | 2017-07-21 | 阿里巴巴集团控股有限公司 | A kind of method and apparatus for database data migration |
CN106021593A (en) * | 2016-06-07 | 2016-10-12 | 浪潮电子信息产业股份有限公司 | Replication processing method in takeover process of first database and second database |
CN106412071A (en) * | 2016-10-08 | 2017-02-15 | 中国工商银行股份有限公司 | Data synchronization method and apparatus |
CN106777270A (en) * | 2016-12-28 | 2017-05-31 | 中国民航信息网络股份有限公司 | A kind of Heterogeneous Database Replication parallel execution system and method based on submission point time line locking |
CN107678888A (en) * | 2017-09-30 | 2018-02-09 | 北京九桥同步软件有限公司 | database data backup method and device |
CN108228756A (en) * | 2017-12-21 | 2018-06-29 | 江苏瑞中数据股份有限公司 | Data based on the PG databases of daily record analytic technique to Hadoop platform synchronize clone method |
CN110543513B (en) * | 2018-05-29 | 2024-03-15 | 金篆信科有限责任公司 | Incremental data synchronization method, equipment and storage medium for distributed database |
CN110543513A (en) * | 2018-05-29 | 2019-12-06 | 中兴通讯股份有限公司 | incremental data synchronization method, equipment and storage medium for distributed database |
CN109634972A (en) * | 2018-11-12 | 2019-04-16 | 武汉达梦数据库有限公司 | A kind of method positioned when data are synchronous using ROWID |
CN113396407A (en) * | 2018-12-04 | 2021-09-14 | 泽乌科技公司 | System and method for augmenting database applications using blockchain techniques |
CN109905475A (en) * | 2019-02-28 | 2019-06-18 | 上海浪潮云计算服务有限公司 | A method of cloud computing monitoring data is exported with prescribed form based on SQL |
CN109905475B (en) * | 2019-02-28 | 2022-03-15 | 上海浪潮云计算服务有限公司 | Method for outputting cloud computing monitoring data in specified format based on SQL |
CN110263057B (en) * | 2019-06-12 | 2020-04-17 | 上海英方软件股份有限公司 | Storage and query method and device for ROWID mapping table |
CN110263057A (en) * | 2019-06-12 | 2019-09-20 | 上海英方软件股份有限公司 | A kind of storage/the querying method and device of ROWID mapping table |
CN111444278A (en) * | 2020-04-01 | 2020-07-24 | Oppo(重庆)智能科技有限公司 | Data synchronization method and device and transfer server |
CN111444278B (en) * | 2020-04-01 | 2023-08-29 | Oppo(重庆)智能科技有限公司 | Data synchronization method and device and transfer server |
CN113157807A (en) * | 2021-04-19 | 2021-07-23 | 南京南瑞继保工程技术有限公司 | Data copying method, device and storage medium |
CN113157807B (en) * | 2021-04-19 | 2022-09-23 | 南京南瑞继保工程技术有限公司 | Data copying method, device and storage medium |
CN113220711A (en) * | 2021-05-19 | 2021-08-06 | 李坚白 | Method and system for synchronizing heterogeneous robot controller databases |
CN113326318A (en) * | 2021-05-28 | 2021-08-31 | 广州市炬元互联网科技有限公司 | Method and system for data synchronization between two systems |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101187888A (en) | Method for coping database data in heterogeneous environment | |
US10956601B2 (en) | Fully managed account level blob data encryption in a distributed storage environment | |
US11153380B2 (en) | Continuous backup of data in a distributed data store | |
US10929428B1 (en) | Adaptive database replication for database copies | |
US11120152B2 (en) | Dynamic quorum membership changes | |
US10764045B2 (en) | Encrypting object index in a distributed storage environment | |
US10659225B2 (en) | Encrypting existing live unencrypted data using age-based garbage collection | |
US11321291B2 (en) | Persistent version control for data transfer between heterogeneous data stores | |
US9507843B1 (en) | Efficient replication of distributed storage changes for read-only nodes of a distributed database | |
US8874512B2 (en) | Data replication method and system for database management system | |
US9146934B2 (en) | Reduced disk space standby | |
US9280591B1 (en) | Efficient replication of system transactions for read-only nodes of a distributed database | |
US20190361913A1 (en) | Data replication technique in database management system | |
CN107209704A (en) | Detect the write-in lost | |
CN101888405B (en) | Cloud computing file system and data processing method | |
CN104813276A (en) | Streaming restore of a database from a backup system | |
CN107423452A (en) | A kind of power network heterogeneous database synchronously replicates moving method | |
US7991783B2 (en) | Apparatus, system, and method for supporting storage functions using an embedded database management system | |
RU2711348C1 (en) | Method and system for processing requests in a distributed database | |
CN100486345C (en) | Business system based on PC server | |
CN111581227A (en) | Event pushing method and device, computer equipment and storage medium | |
US11169728B2 (en) | Replication configuration for multiple heterogeneous data stores | |
Tomášek | Design and implementation of Archival Storage component of OAIS Reference Model | |
US12093239B2 (en) | Handshake protocol for efficient exchange of transactional information for a hybrid transactional and analytical processing architecture | |
WO2018061070A1 (en) | Computer system and analysis source data management method |
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 |
Open date: 20080528 |