CN111198920B - Method and device for determining comparison table snapshot based on database synchronization - Google Patents
Method and device for determining comparison table snapshot based on database synchronization Download PDFInfo
- Publication number
- CN111198920B CN111198920B CN201911400338.5A CN201911400338A CN111198920B CN 111198920 B CN111198920 B CN 111198920B CN 201911400338 A CN201911400338 A CN 201911400338A CN 111198920 B CN111198920 B CN 111198920B
- Authority
- CN
- China
- Prior art keywords
- time point
- snapshot
- library
- source
- source library
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 28
- 230000008569 process Effects 0.000 claims abstract description 10
- 230000008859 change Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 5
- 238000012795 verification Methods 0.000 description 2
- 238000010276 construction Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000013508 migration Methods 0.000 description 1
- 230000005012 migration Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 238000010187 selection method Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a device for synchronously determining comparison table snapshots based on a database, wherein the method comprises the following steps: step S1, determining a snapshot time point T1 of a source library table; step S2, a snapshot time point T1 of the source library is sent to a target library end, and a plurality of transactions of the source library containing the snapshot time point T1 are sent to the target library end; step S3, the target library end serially executes the transactions, and determines which time point T1 in the executed transactions is proper in the executing process; and S4, determining a time point T2 of the corresponding target library table according to the time point determined in the step S3, and accurately finding the corresponding snapshot time point of the corresponding target library table according to the snapshot time point of the source library table so as to improve the efficiency of verifying the database synchronization result.
Description
Technical Field
The invention relates to the field of computer database synchronization, in particular to a method and a device for determining comparison table snapshots based on database synchronization.
Background
With the rapid development of informatization construction, an information system has become a key for enterprises to maintain business operation, the enterprises are urgent to improve the usability of the information system, ensure the continuity of business, and reduce the loss caused by disasters or faults to the greatest extent. On the other hand, the diversified business types lead to the increasing complexity of data access requirements, the rapid increase of data volume also leads to the overwhelming of database servers, and enterprises are also in urgent need of improving the operation efficiency of information systems.
The database real-time synchronization system is based on a mature relational data model and a standard interface, can realize real-time synchronization of second data with little system expense, and can be widely applied to the business fields of emergency systems, disaster recovery backup, load balancing, data migration, online maintenance, multi-business centers and the like.
In database synchronization, it is necessary to verify whether the synchronization data of a table in the source library and a table in the target library are consistent, that is, it is necessary to compare the data of the table in the source library and the corresponding table in the target library. Because the data of the source library table and the target library table are in real-time change, a time point is required to be selected to determine whether the data of the source library table and the target library table at the time point are consistent, and the snapshot of the source library table and the snapshot of the target library table are determined according to the time point, so that whether the data of the source library table and the target library table are different at the time point can be determined through the data comparison of the two snapshots.
Because of the data synchronization characteristic, in many cases, the source library is operated in parallel by a plurality of transactions, and the target library is operated in series after the plurality of transactions at the source end are ordered according to the sequence of the transactions submitted, so that a proper snapshot time point in the plurality of transactions which are executed in parallel in the source library is needed to be found out in the snapshot time points of the plurality of transactions which are executed in series corresponding to the target library. In the prior art, the selection is generally required to be performed in a period of no operation, and if the comparison is performed under the condition of operation, the result that the data in the source library and the data in the target library are inconsistent can be obtained with high probability, and errors occur.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention aims to provide a method and a device for determining comparison table snapshots based on database synchronization, so as to accurately find the corresponding snapshot time point of a target library corresponding table according to the snapshot time point of a source library table, thereby improving the efficiency of verifying database synchronization results.
In order to achieve the above purpose, the present invention provides a method for determining a comparison table snapshot based on database synchronization, comprising the following steps:
step S1, randomly selecting a time point, judging whether the operation is executed on a source library table or not at the time point, if no operation is executed on the source library table, determining the time point as a snapshot time point T1 of the source library table, if the operation is executed on the source library table, acquiring the snapshot time point, and re-selecting the time point for retry until the time point when no operation is executed on the source library table is found;
step S2, a snapshot time point T1 of the source library is sent to a target library end, and a plurality of transactions of the source library containing the snapshot time point T1 are sent to the target library end;
step S3, the target library end serially executes the transactions, and determines which time point T1 in the executed transactions is proper in the executing process;
and S4, determining a time point T2 of the corresponding target library table according to the time point determined in the step S3.
Preferably, the time point T1 and the time point T2 are timestamp information of the corresponding database.
Preferably, after step S4, the method further comprises the steps of:
step S5, snapshot data D1 of the source library table at the time point of the source library T1 and snapshot data D2 of the target library table at the time point of the target library T2 are obtained, and compared to generate a comparison report.
Preferably, the data D1 is data obtained by taking a T1 time point as a snapshot of a source library table in the source library, and the data D2 is data obtained by taking a T2 time point as a snapshot of a target library table in the target library.
Preferably, in step S3, the time point T1 is the latest time point when all operations on the source library table have not been performed yet.
In order to achieve the above object, the present invention further provides a device for determining a comparison table snapshot based on database synchronization, including:
the source library snapshot time point determining unit is used for determining a snapshot time point T1 of the source library table; randomly selecting a time point, judging whether the operation is executed on the source library table or not at the time point, if the operation is not executed on the source library table, determining the time point as a snapshot time point T1 of the source library table, if the operation is executed on the source library table, acquiring the snapshot time point, and re-selecting the time point for retry until the time point that the operation is not executed on the source library table is found;
the sending unit is used for sending the snapshot time point T1 of the source library to the target library end and sending a plurality of transactions of which the source library contains the snapshot time point T1 to the target library end;
a judging unit, configured to determine, in a process of serially executing the transactions at the target library, which of the executed transactions is appropriate at a time point T1;
and the target library snapshot time point determining unit is used for determining a time point T2 of the corresponding target library table according to the time point determined by the judging unit.
Preferably, the time point T1 and the time point T2 are timestamp information of the corresponding database.
Preferably, the apparatus further comprises:
the snapshot comparison unit is used for acquiring snapshot data D1 of the source library table at the time point of the source library T1 and snapshot data D2 of the target library table at the time point of the target library T2, comparing the snapshot data and generating a comparison report.
Preferably, the data D1 is data obtained by taking a T1 time point as a snapshot of a source library table in the source library, and the data D2 is data obtained by taking a T2 time point as a snapshot of a target library table in the target library.
Preferably, the time point T1 determined by the determination unit is the latest time point at which all operations on the source library table have not been performed.
Compared with the prior art, the method and the device for synchronously determining the comparison table snapshot based on the database determine whether the data difference exists between the source library table and the target library table at the time point through the data comparison of the two snapshots by determining the time point T1 of the source library snapshot and transmitting the plurality of transactions of which time point T1 is contained in the source library to the target end for serial execution, judging which time point T1 in the plurality of transactions is proper in the serial execution process, acquiring the time point T2 of the target library table according to the time point, and taking the snapshot of the source library table according to the time point T1 and taking the snapshot of the target library table according to the time point T2.
Drawings
FIG. 1 is a flowchart illustrating steps of a method for determining a comparison table snapshot based on database synchronization according to the present invention;
FIG. 2 is a system architecture diagram of an apparatus for determining contrast table snapshots based on database synchronization according to the present invention;
FIG. 3 is a diagram illustrating an example of a case where a source library table time point T1 and a source library execute a transaction in parallel according to an embodiment of the present invention;
FIG. 4 is a diagram illustrating a case where a transaction is executed serially between a source library table time point T1 and a target library in an embodiment of the present invention;
FIG. 5 is a diagram illustrating a change between a source library table snapshot time point and a target library snapshot time point according to an embodiment of the present invention.
Description of the embodiments
Other advantages and effects of the present invention will become readily apparent to those skilled in the art from the following disclosure, when considered in light of the accompanying drawings, by describing embodiments of the present invention with specific embodiments thereof. The invention may be practiced or carried out in other embodiments and details within the scope and range of equivalents of the various features and advantages of the invention.
FIG. 1 is a flowchart illustrating steps of a method for determining a comparison table snapshot based on database synchronization according to the present invention. As shown in fig. 1, the method for determining the comparison table snapshot based on database synchronization of the present invention comprises the following steps:
step S1, keeping the synchronous task from the source database to the target database in an execution state, determining a snapshot time point T1 of a source database table, wherein the time point T1 is contained in a plurality of transactions which are being executed in parallel by the source database. In a specific embodiment of the present invention, the change data of the source database needs to carry the change time point, and the snapshot time point T1 is the timestamp information SCN. In the present invention, the selection of the time point T1 needs to be performed on the source library table without any operation at that time, and the specific selection method is as follows: randomly selecting a time point, judging whether the operation is executed on the source library table or not at the time point, if no operation is executed on the source library table, determining the time point as a snapshot time point T1 of the source library table, if the operation is executed on the source library table, acquiring the snapshot time point, and re-selecting the time point for retry until the time point that no operation is executed on the source library table is found.
Typically, the database has its own time axis and each operation has an execution time, i.e. the timestamp information SCN. The timestamp information will be different for different database platforms. For the Oracle database, the timestamp information available for verification is SCN. The so-called SCN, collectively System Change Number, is an internal timestamp of the Oracle database that identifies a certain exact committed version of the database. When a transaction commits or rolls back, it is assigned a unique SCN that identifies the transaction to ensure data consistency, as a logical clock within the database, the database transactions are ordered by SCN, which is unique in the database and increases over time, and the value of SCN is never reset to 0 unless the database is rebuilt.
Step S2, the snapshot time point T1 of the source library is sent to the target library side, and a plurality of transactions of the source library including the snapshot time point T1 are sent to the target library side.
Step S3, the target library end serially executes the transactions, and determines which of the executed transactions is appropriate at the time point T1. In general, some of the transactions executed in parallel in the source library are operations related to the source library table, and in the serial execution process of the target library, the earliest time point T1 in all the transactions including the time point T1 is not related to the operation of the source library table and is separated from the operation related to the source library table, so that the time point is proper, that is, the time point T1 is judged when the transactions are executed by the target library, and the judgment condition is that the time point is not related to the operation of the source library table before the time point and all the operations related to the source library table are after the time point. That is, the time point T1 should be the latest time point when all operations on the source library table have not been performed, as in fig. 3, operation 1, operation 2, and operation 3 are operations not related to the source library table, operation 4 is an operation related to the source library table, operation 1 and operation 2 are operations not related to the source library table, operation 3 is an operation related to the source library table, and thus the time point T1, i.e., the time point of T1 in the transaction 3, is determined. The reason for determining the time point is that the operation after the time point T1 is related to the operation of the table to be compared, once the operation is performed on the target library, the operation of the target library on the table is more than the operation of the source library on the table, and at this time, the acquired time point corresponds to the time point of the source library in error, and the comparison result is incorrect.
And S4, determining a time point T2 of the corresponding target library table according to the time point determined in the step S3.
According to the steps, the corresponding snapshot time point of the corresponding table of the target library can be accurately found according to the snapshot time point of the source library table.
Preferably, after step S4, the method further comprises the following steps:
step S5, snapshot data D1 of a source library table at the time point of the source library T1 and snapshot data D2 of a target library at the time point of the target library T2 are obtained and compared, and a comparison report is generated. Specifically, snapshots of the source library table and the target library table are respectively determined according to a time point T1 and a time point T2, then data comparison is carried out on the source library table snapshot and the target library table snapshot, and a comparison report is generated according to a comparison result.
FIG. 2 is a system architecture diagram of an apparatus for determining contrast table snapshots based on database synchronization according to the present invention. As shown in fig. 2, the apparatus for determining a comparison table snapshot based on database synchronization according to the present invention includes:
the source library snapshot time point determining unit 201 is configured to determine a snapshot time point T1 of the source library table. In a specific embodiment of the present invention, a synchronization task from a source database to a target database is kept in an execution state, a snapshot time point T1 of a source database table is determined, and a plurality of transactions being executed in parallel by the source database all contain the time point T1. In general, the change data of the source database needs to carry the change time point, and the snapshot time point T1 is the timestamp information SCN. In the present invention, the selection of the time point T1 needs that no operation is performed on the source library table at this time, and the specific determination method of the source library snapshot time point determining unit 201 is as follows: randomly selecting a time point, judging whether the operation is executed on the source library table or not at the time point, if the operation is not executed on the source library table, determining the time point as a snapshot time point T1 of the source library table, if the operation is executed on the source library table, acquiring the snapshot time point, failing, re-selecting the time point for retry until the time point when the operation is not executed on the source library table is found.
Typically, the database has its own time axis and each operation has an execution time, i.e. the timestamp information SCN. The timestamp information will be different for different database platforms. For the Oracle database, the timestamp information available for verification is SCN. The so-called SCN, collectively System Change Number, is an internal timestamp of the Oracle database that identifies a certain exact committed version of the database. When a transaction commits or rolls back, it is assigned a unique SCN that identifies the transaction to ensure data consistency, as a logical clock within the database, the database transactions are ordered by SCN, which is unique in the database and increases over time, and the value of SCN is never reset to 0 unless the database is rebuilt.
The sending unit 202 is configured to send a snapshot time point T1 of the source repository to the target repository, and send a plurality of transactions including the snapshot time point T1 of the source repository to the target repository.
The determining unit 203 is configured to determine, in the process of serially executing the transactions at the target repository, which of the executed transactions is appropriate at the time point T1.
The target library snapshot time point determining unit 204 is configured to determine a time point T2 of the corresponding target library table according to the time point determined by the determining unit 203.
According to the device, the corresponding snapshot time point of the corresponding table of the target library can be accurately found according to the snapshot time point of the source library table.
Preferably, the apparatus further comprises:
the snapshot comparison unit is used for acquiring snapshot data D1 of the source library table at the time point of the source library T1 and snapshot data D2 of the target library table at the time point of the target library T2, comparing the snapshot data and generating a comparison report. Specifically, snapshots of the source library table and the target library table are respectively determined according to a time point T1 and a time point T2, then data comparison is carried out on the source library table snapshot and the target library table snapshot, and a comparison report is generated according to a comparison result.
Examples
The present invention will be described below with reference to fig. 3-5 (fig. 5 is a combination of fig. 3 and 4):
1. as shown in fig. 3, the source library is executing a plurality of transactions (transactions 1 to 3) in parallel, each transaction comprises a transaction head and a transaction tail, a plurality of operations are included between the transaction head and the transaction tail, and each transaction is parallel on a source library time axis, wherein operation 1, operation 2 and operation 3 in the transaction 1 are operations not related to the source library table, and operation 4 is an operation related to the source library table; operation 1 and operation 2 in transaction 3 are operations not related to the source library table, and operation 3 is an operation related to the source library table; since the transactions of the target library serial execution source library are arranged according to the sequence of the transaction heads, since in the embodiment, the transaction 2, the transaction 3 and the transaction 1 are executed in this way, the transaction head of the transaction 2 is changed to be the transaction head of the transaction 3 and the transaction head of the transaction 1 in the following way, as shown in fig. 4.
2. The source library table snapshot time point T1 is determined, and as shown in fig. 3, the time point T1 is contained in a plurality of transactions (transaction 3, transaction 1) which are being executed in parallel by the source library.
3. The snapshot time point T1 of the source library table is sent to the target library end, and a plurality of transactions (transaction 3, transaction 1) including the snapshot time point T1 of the source library are sent to the target library end (it should be noted that all the transactions of the source end are sent to the target library end in the database synchronization, and the target library end filters the transactions to be executed, namely filters the transaction 2).
4. As shown in fig. 4, the target bank end executes the transaction 3 serially, the transaction 1 is parallel on the source bank time axis, the transaction is serial on the target bank time axis, the source bank table time point T1 and the plurality of transactions cross with each other to form only one point on the source bank time axis, and the source bank table time point T1 and the plurality of transactions cross with each other to form a plurality of points on the target bank time axis;
5. and (3) finding out which drop point is most suitable on the time axis of the target library, and determining the time point T2 of the corresponding target library table according to the determined time point. Some of the transactions executed in parallel in the source library are operations related to the source library table, and in the serial execution process of the target library, the earliest time point T1 in all the transactions containing the time point T1 is not related to the operation of the source library table and is separated from the operation related to the source library table, so that the time point is proper, when the transactions are executed in serial, the time point T2 when the transactions are executed to the time point of T1 in the transaction 3 can be confirmed to be proper; because transaction 3 operation 4 is an operation with respect to the table, once it is executed, the point in time at which the target library is again acquired, the number of operations on the table for the subsequently acquired source library snapshot and the number of operations on the table for the target library snapshot are inconsistent, and the comparison result is incorrect.
6. And respectively determining snapshots of the source library table and the target library table according to the time point T1 and the time point T2, comparing the data of the source library table snapshot and the target library table snapshot, determining a database synchronization result according to the comparison result, and generating a comparison report.
In summary, according to the method and the device for determining the comparison table snapshot based on database synchronization, by determining the time point T1 of the source library snapshot, transmitting a plurality of transactions including the time point T1 of the source library to the target end for serial execution, judging which time point T1 in the plurality of transactions is suitable in the serial execution process, acquiring the time point T2 of the target library table according to the time point, and taking the snapshot of the source library table according to the time point T1 and taking the snapshot of the target library table according to the time point T2, whether the data difference exists between the source library table and the target library table at the time point is determined through the data comparison of the two snapshots, so that the efficiency of verifying the database synchronization result is improved.
The above embodiments are merely illustrative of the principles of the present invention and its effectiveness, and are not intended to limit the invention. Modifications and variations may be made to the above-described embodiments by those skilled in the art without departing from the spirit and scope of the invention. Accordingly, the scope of the invention is to be indicated by the appended claims.
Claims (6)
1. A method for determining a comparison table snapshot based on database synchronization, comprising the steps of:
step S1, randomly selecting a time point, judging whether the operation is executed on a source library table or not at the time point, if no operation is executed on the source library table, determining the time point as a snapshot time point T1 of the source library table, if the operation is executed on the source library table, acquiring the snapshot time point, and re-selecting the time point for retry until the time point when no operation is executed on the source library table is found;
step S2, a snapshot time point T1 of the source library is sent to a target library end, and a plurality of transactions of the source library containing the snapshot time point T1 are sent to the target library end;
step S3, the target library end serially executes the transactions, and in the execution process, determines which time point T1 in the executed transactions is proper, wherein the time point T1 is the latest time point when all operations related to the source library table are not executed yet;
step S4, determining a time point T2 of the corresponding target library table according to the time point determined in the step S3;
step S5, snapshot data D1 of the source library table at the time point of the source library T1 and snapshot data D2 of the target library table at the time point of the target library T2 are obtained, and compared to generate a comparison report.
2. The method for determining a comparison table snapshot based on database synchronization of claim 1, wherein: the time point T1 and the time point T2 are timestamp information of the corresponding database.
3. The method for determining a comparison table snapshot based on database synchronization of claim 2, wherein: the data D1 is data obtained by taking a T1 time point as a snapshot of a source library table of the source library, and the data D2 is data obtained by taking a T2 time point as a snapshot of a target library table of the target library.
4. An apparatus for determining a comparison table snapshot based on database synchronization, comprising:
the source library snapshot time point determining unit is used for determining a snapshot time point T1 of the source library table; randomly selecting a time point, judging whether the operation is executed on the source library table or not at the time point, if the operation is not executed on the source library table, determining the time point as a snapshot time point T1 of the source library table, if the operation is executed on the source library table, acquiring the snapshot time point, and re-selecting the time point for retry until the time point that the operation is not executed on the source library table is found;
the sending unit is used for sending the snapshot time point T1 of the source library to the target library end and sending a plurality of transactions of which the source library contains the snapshot time point T1 to the target library end;
a judging unit, configured to determine, in a process of serially executing the transactions at the target repository, a time point T1 in which one of the executed transactions is appropriate, where the time point T1 determined by the judging unit is a latest time point at which all operations related to the source repository table have not been executed yet;
a target library snapshot time point determining unit, configured to determine a time point T2 of a corresponding target library table according to the time point determined by the determining unit;
the snapshot comparison unit is used for acquiring snapshot data D1 of the source library table at the time point of the source library T1 and snapshot data D2 of the target library table at the time point of the target library T2, comparing the snapshot data and generating a comparison report.
5. The apparatus for determining a comparison table snapshot based on database synchronization of claim 4, wherein: the time point T1 and the time point T2 are timestamp information of the corresponding database.
6. The apparatus for determining a comparison table snapshot based on database synchronization of claim 5, wherein: the data D1 is data obtained by taking a T1 time point as a snapshot of a source library table of the source library, and the data D2 is data obtained by taking a T2 time point as a snapshot of a target library table of the target library.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911400338.5A CN111198920B (en) | 2019-12-30 | 2019-12-30 | Method and device for determining comparison table snapshot based on database synchronization |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911400338.5A CN111198920B (en) | 2019-12-30 | 2019-12-30 | Method and device for determining comparison table snapshot based on database synchronization |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111198920A CN111198920A (en) | 2020-05-26 |
| CN111198920B true CN111198920B (en) | 2024-01-23 |
Family
ID=70747122
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911400338.5A Active CN111198920B (en) | 2019-12-30 | 2019-12-30 | Method and device for determining comparison table snapshot based on database synchronization |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111198920B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113220788A (en) * | 2021-05-31 | 2021-08-06 | 上海英方软件股份有限公司 | Snapshot selection method and device based on Oracle database full synchronization |
| CN113282643B (en) * | 2021-06-04 | 2023-03-21 | 上海英方软件股份有限公司 | Table comparison method and system under ORACLE database synchronization environment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105684377A (en) * | 2013-10-31 | 2016-06-15 | 华为技术有限公司 | System and method for creating a distributed transaction manager supporting repeatable read isolation level in a mpp database |
| 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 |
| CN110196760A (en) * | 2018-07-12 | 2019-09-03 | 腾讯科技（深圳）有限公司 | Distributed transaction consistency implementation method and device |
| CN110347746A (en) * | 2019-06-13 | 2019-10-18 | 武汉达梦数据库有限公司 | A kind of heterogeneous database synchrodata consistency desired result method and device |
| CN110413693A (en) * | 2019-07-31 | 2019-11-05 | 上海英方软件股份有限公司 | A kind of method of inspection and device of database real-time synchronization system data consistency |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8996465B2 (en) * | 2012-03-08 | 2015-03-31 | Sap Ag | Replicating data to a database |
-
2019
- 2019-12-30 CN CN201911400338.5A patent/CN111198920B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105684377A (en) * | 2013-10-31 | 2016-06-15 | 华为技术有限公司 | System and method for creating a distributed transaction manager supporting repeatable read isolation level in a mpp database |
| 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 |
| CN110196760A (en) * | 2018-07-12 | 2019-09-03 | 腾讯科技（深圳）有限公司 | Distributed transaction consistency implementation method and device |
| CN110347746A (en) * | 2019-06-13 | 2019-10-18 | 武汉达梦数据库有限公司 | A kind of heterogeneous database synchrodata consistency desired result method and device |
| CN110413693A (en) * | 2019-07-31 | 2019-11-05 | 上海英方软件股份有限公司 | A kind of method of inspection and device of database real-time synchronization system data consistency |
Non-Patent Citations (3)
| Title |
|---|
| 一种实时数据库事务处理策略的应用;罗健等;《计算机技术与发展》;20060710(第07期);全文 * |
| 一种嵌入式移动实时数据库的并发控制策略;吴海等;《计算机科学》;20090215(第02期);全文 * |
| 一种应用于实时数据库系统的并发控制协议;韩辉;《信息工程大学学报》;19980630(第02期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111198920A (en) | 2020-05-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7200626B1 (en) | System and method for verification of a quiesced database copy | |
| US8719232B2 (en) | Systems and methods for data integrity checking | |
| US8364636B2 (en) | Real time data replication | |
| US10452515B2 (en) | Automated root cause detection using data flow analysis | |
| CN110413693B (en) | Method and device for checking data consistency of database real-time synchronization system | |
| CN110008129B (en) | Reliability test method, device and equipment for storage timing snapshot | |
| US20140108349A1 (en) | Merging an out of synchronization indicator and a change recording indicator in response to a failure in consistency group formation | |
| US10365978B1 (en) | Synchronization of snapshots in a distributed consistency group | |
| US20130246358A1 (en) | Online verification of a standby database in log shipping physical replication environments | |
| CN104252481A (en) | Dynamic check method and device for consistency of main and salve databases | |
| CN103077108B (en) | A kind of method and system browser collapse being carried out to early warning | |
| CN111198920B (en) | Method and device for determining comparison table snapshot based on database synchronization | |
| US10223205B2 (en) | Disaster recovery data sync | |
| CN112765126B (en) | Database transaction management method, device, computer equipment and storage medium | |
| CN115587048A (en) | Regression testing method, terminal device and computer readable storage medium | |
| US9152630B1 (en) | Modified database transaction scopes during software testing | |
| JP5497210B1 (en) | Job re-execution support system | |
| US8326808B2 (en) | Information processing apparatus, and information processing method, program, and recording medium | |
| US11768855B1 (en) | Replicating data across databases by utilizing validation functions for data completeness and sequencing | |
| CN112860492B (en) | Automatic regression testing method and system suitable for core system | |
| CN113391884B (en) | Transaction processing method, device, equipment, storage medium and database system | |
| CN117632984A (en) | Distributed transaction rollback method, device, equipment and medium | |
| CN116226284A (en) | Data synchronization method, device, equipment and storage medium | |
| CN116560715A (en) | Database version control method, device, equipment and storage medium | |
| CN118113622A (en) | Detection and repair method, device and equipment applied to batch operation scheduling |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |