CN112000684A - Method and tool for realizing bidirectional synchronization of database of loop control based on TRXID - Google Patents
Method and tool for realizing bidirectional synchronization of database of loop control based on TRXID Download PDFInfo
- Publication number
- CN112000684A CN112000684A CN202010864404.0A CN202010864404A CN112000684A CN 112000684 A CN112000684 A CN 112000684A CN 202010864404 A CN202010864404 A CN 202010864404A CN 112000684 A CN112000684 A CN 112000684A
- Authority
- CN
- China
- Prior art keywords
- database
- dreaming
- incremental data
- slave
- master
- 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.)
- Granted
Links
- 230000002457 bidirectional effect Effects 0.000 title claims abstract description 30
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000012216 screening Methods 0.000 claims abstract description 13
- 238000001914 filtration Methods 0.000 claims abstract description 11
- 230000001360 synchronised effect Effects 0.000 claims description 7
- 230000010076 replication Effects 0.000 claims description 3
- 238000003860 storage Methods 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 description 5
- 238000011161 development Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 2
- 238000004220 aggregation Methods 0.000 description 1
- 230000002776 aggregation Effects 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
Images
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/23—Updating
- G06F16/2308—Concurrency control
- G06F16/2315—Optimistic concurrency control
- G06F16/2322—Optimistic concurrency control using timestamps
-
- 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)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a TRXID-based method for realizing bidirectional synchronization of a database under loop control, which relates to the technical field of data synchronization and comprises the following steps: based on a dreaming master database and a dreaming slave database, respectively establishing temporary tables in the two databases; acquiring incremental data of a master library and transmitting the incremental data to a business table of a slave library by using a flashback log, receiving the incremental data from the slave library and updating a temporary table, uniformly submitting the incremental data, wherein the business table operation and the temporary table updating operation of the slave library have the same TRXID, screening and filtering the incremental data only belonging to the slave library according to the TRXID, and transmitting the incremental data to the master library through a CMSP; the main library receives the incremental data and updates the temporary table, after uniform submission, the service table operation and the temporary table updating operation of the main library have the same TRXID, the incremental data only belonging to the main library are filtered according to the TRXID and transmitted to the slave library, and the bidirectional synchronization of the incremental data in the dreaming-reaching database and the dreaming-reaching slave database is realized. The invention also discloses a tool, which realizes the method through the acquisition module and the warehousing module.
Description
Technical Field
The invention relates to the technical field of data synchronization, in particular to a method and a tool for realizing bidirectional synchronization of a database of loop back control based on TRXID.
Background
With the rapid development of modern information technology, the human society has come to the internet and big data era. The information is deeply changing the thinking, production and living modes of people, and is deeply fused with various industries, thereby generating huge social and commercial values. The rapid development of artificial intelligence technology and 5G technology is the result of the long-term development of information technology. Data is also becoming increasingly important as an important component of information. The complexity of information data, the uncertainty of network environment, the instability of equipment, manual misoperation and the like can bring about not small potential safety hazards to the data, so that the data synchronization and backup are very important.
The CMSP is a high-performance message middleware in cloud and big data era, provides high-performance and high-reliability message queue service externally in a cloud service and cluster mode, and supports a big data acquisition, transmission, aggregation and exchange, big data real-time processing and micro-service processing architecture.
The dream database is a domestic database with completely independent intellectual property rights, plays a role in getting rid of the dependence on foreign technologies in China and being incapable of being worn out, and is more important in the current complex world situation. The Dameng database has huge market and commercial values at home and abroad, and has great value for research and discovery related to the Dameng database.
By querying the flashback log, incremental operations of the dream database can be obtained, and the obtained incremental operations are repeatedly executed in another dream database, so that the incremental synchronization of the databases is realized. Referring to fig. 1, dreams 1 is a master database, and dreams 2 is a slave database, and increment operations are obtained by querying a flashback log of dreams 1, and then the increment operations are repeated in dreams 2, so that synchronization between dreams 2 and dreams 1, i.e. synchronization between master and slave databases, is realized.
However, the two-way synchronization of the two dreams database cannot be realized by querying the flashback log. As shown in FIG. 2, the incremental data up to dream 1 arrives synchronously at dream 2, and at the same time, the incremental data up to dream 2 arrives synchronously at dream 1; after the incremental data of dream 1 synchronously reaches dream 2, the incremental data is generated for dream 2 after the incremental operation is repeated, then the incremental data synchronously reaches dream 1 again, then the incremental data synchronously reaches dream 2 from dream 1, and the steps are repeated in such a way to form an endless loop. For this reason, loop back control is required based on the Daemon database transaction ID.
Disclosure of Invention
Aiming at the requirements and the defects of the prior art development, the invention provides a method and a tool for realizing bidirectional synchronization of a database based on TRXID (true return to true) loop control based on transaction ID of a database in Daemon.
Firstly, the invention provides a method for realizing bidirectional synchronization of a database of loop back control based on TRXID, and the technical scheme adopted for solving the technical problems is as follows:
a method for realizing bidirectional synchronization of a database of loop back control based on TRXID comprises the following steps:
step 1, respectively establishing temporary tables based on a dreaming master database and a dreaming slave database;
step 2, acquiring incremental data of the dreaming master database by utilizing the flashback log of the dreaming master database, and transmitting the incremental data to a business table of the dreaming slave database through the CMSP;
step 3, inserting the incremental data from the dreaming master database into the business table of the dreaming slave database, updating the temporary table of the dreaming slave database by using the incremental data from the dreaming master database, and uniformly submitting the temporary table, wherein the business table operation and the temporary table updating operation of the dreaming slave database belong to the same transaction, namely TRXID is the same;
step 4, for the business table of the Daemon slave database, screening and filtering the incremental data only belonging to the Daemon slave database according to the TRXID in the step 3, collecting the incremental data by using a flashback log of the Daemon slave database, and transmitting the incremental data to the Daemon master database through the CMSP;
step 5, inserting the incremental data from the dreaming slave database into the business table of the dreaming master database, updating the temporary table of the dreaming master database by using the incremental data from the dreaming slave database, and uniformly submitting the temporary table, wherein the business table operation and the temporary table updating operation of the dreaming master database belong to the same transaction, namely TRXID is the same;
step 6, for the business table of the dreaming database, screening and filtering incremental data only belonging to the dreaming database according to the TRXID in the step 5, collecting the incremental data by using a flashback log of the dreaming database, and transmitting the incremental data to the dreaming database through the CMSP;
and 7, after the steps 1-6 are executed, the bidirectional synchronization of incremental data in the dreaming master database and the dreaming slave database can be realized.
Optionally, when the incremental data of the dreaming master database and the dreaming slave database are synchronized bidirectionally, the dreaming master database and the dreaming slave database have business incremental data and copy incremental data from the dreaming slave database/dreaming master database.
Optionally, when bidirectional synchronization is performed on incremental data of the dreaming master database and the dreaming slave database, it is assumed that the dreaming master database and the dreaming slave database have no incremental data, at this time, two rows of TABLE _ NAME and TABLE _ VALUE are respectively located in temporary TABLEs of the dreaming master database and the dreaming slave database, TABLE _ NAME is used for storing a service TABLE NAME, TABLE _ VALUE is used for storing a timestamp, and one record corresponds to one service TABLE.
Optionally, in step 3, the temporary table in the dreaming slave database is updated with the incremental data from the dreaming master database, that is, the timestamp of the record of the service table in the temporary table in the dreaming slave database is updated.
Optionally, in step 5, the temporary table in the dreaming master database is updated by using the incremental data from the dreaming slave database, that is, the timestamp of the record of the business table in the temporary table in the dreaming master database is updated.
Optionally, when the incremental data of the dreaming master database and the dreaming slave database are synchronized bidirectionally, the data of the business tables corresponding to the dreaming master database and the dreaming slave database cannot be modified simultaneously.
Optionally, when the incremental data of the dreaming master database and the dreaming slave database are synchronized bidirectionally, a master key is required in the service table, and no self-increment field is required.
Optionally, the dreaming master database and the dreaming slave database have at least one business table respectively, and a temporary table is established in the dreaming master database and the dreaming slave database respectively.
Secondly, the invention provides a tool for realizing bidirectional synchronization of a database of loop back control based on TRXID, and the technical scheme adopted for solving the technical problems is as follows:
a tool for realizing bidirectional synchronization of a database of loop back control based on TRXID is based on temporary tables respectively established in a Dameng master database and a Dameng slave database, the Dameng master database and the Dameng slave database, and at least one business table respectively contained in the Dameng master database and the Dameng slave database. The tool comprises an acquisition module and a storage module, and the specific process of realizing bidirectional synchronization of incremental data of a dreaming master database and a dreaming slave database comprises the following steps:
(1) for the business table of the dreaming master database, the acquisition module acquires the incremental data of the dreaming master database by using the flashback log and transmits the incremental data to the business table of the dreaming slave database through the CMSP;
(2) the warehousing module inserts the incremental data from the dreaming master database into the business table of the dreaming slave database, meanwhile, updates the temporary table of the dreaming slave database by using the incremental data from the dreaming master database, and submits the incremental data in a unified way, at the moment, the business table operation and the temporary table updating operation of the dreaming slave database belong to the same transaction, namely TRXID is the same;
(3) for the business table of the Daemon slave database, the acquisition module filters the incremental data only belonging to the Daemon slave database according to the TRXID screening in the step (2), acquires the incremental data by using a flashback log of the Daemon slave database, and transmits the incremental data to the Daemon master database through the CMSP;
(4) the warehousing module inserts the incremental data from the dreaming slave database into the business table of the dreaming master database, meanwhile, updates the temporary table of the dreaming master database by using the incremental data from the dreaming slave database, and submits the incremental data in a unified way, at the moment, the business table operation of the dreaming master database and the operation of updating the temporary table belong to the same transaction, namely TRXID is the same;
(5) and (4) for the business table of the dreamin database, filtering the incremental data only belonging to the dreamin database according to the TRXID screening in the step (4), collecting the incremental data by using a flashback log of the dreamin database, and transmitting the incremental data to the dreamin database through the CMSP.
Optionally, when the incremental data of the dreaming database and the dreaming slave database are synchronized bidirectionally,
data of the corresponding business tables of the dreaming master database and the dreaming slave database cannot be modified simultaneously,
the service table is required to have a primary key and cannot have an incremental field,
the dreaming database and the dreaming slave database have business incremental data as well as replication incremental data from the dreaming slave database/dreaming master database.
Compared with the prior art, the method and the tool for realizing the bidirectional synchronization of the loop-back control database based on the TRXID have the beneficial effects that:
1) the method utilizes the flashback log to inquire, screens out the incremental data belonging to the business operation based on TRXID filtering, and combines the CMSP high-efficiency transmission to realize the real-time synchronization of the incremental data between the dream databases;
2) the invention has wide application prospect in the service scene with higher requirement on the bidirectional synchronization of the application CMSP and the Dameng database.
Drawings
FIG. 1 is a schematic diagram of one-way synchronization of incremental data of a prior master-slave database according to the present invention;
FIG. 2 is a schematic diagram of bi-directional synchronization of incremental data of a prior master-slave database according to the present invention;
FIG. 3 is a schematic diagram of bi-directional synchronization of incremental data of a master-slave database according to the present invention;
FIG. 4 is an architecture diagram for implementing bidirectional synchronization of incremental data of a master database and a slave database according to the present invention.
Detailed Description
In order to make the technical scheme, the technical problems to be solved and the technical effects of the present invention more clearly apparent, the following technical scheme of the present invention is clearly and completely described with reference to the specific embodiments.
The first embodiment is as follows:
referring to fig. 3 and 4, the present embodiment provides a method for implementing bidirectional synchronization of a database of loop back control based on TRXID, where the method includes the following steps:
step 1, based on a dreamin database and a dreamin slave database, respectively establishing temporary TABLEs sys _ TWOWAYSYNC _ TABLE in the dreamin database and the dreamin slave database; assuming that the dreaming database and the dreaming slave database have no incremental data at this time, two rows of TABLE _ NAME and TABLE _ VALUE are respectively arranged in the temporary TABLEs of the dreaming database and the dreaming slave database, the TABLE _ NAME is used for storing the business TABLE NAME, the TABLE _ VALUE is used for storing the time stamp, and one record corresponds to one business TABLE.
And 2, acquiring incremental data of the dreaming master database by using the flashing logs of the dreaming master database, and transmitting the incremental data to a business table of the dreaming slave database through the CMSP.
And 3, inserting the incremental data from the dreaming master database into the business table of the dreaming slave database, updating the timestamp of the temporary table in the dreaming slave database corresponding to the business table record by using the incremental data from the dreaming master database, and uniformly submitting the timestamp, wherein at the moment, the operation of the business table in the dreaming slave database and the operation of updating the temporary table belong to the same transaction, namely TRXID is the same.
And 4, for the business table of the Daemon slave database, screening and filtering incremental data only belonging to the Daemon slave database according to the TRXID in the step 3, collecting the incremental data by using a flashback log of the Daemon slave database, and transmitting the incremental data to the Daemon master database through the CMSP.
And 5, inserting the incremental data from the dreaming slave database into the business table of the dreaming master database, updating the timestamp of the temporary table in the dreaming master database corresponding to the record of the business table by using the incremental data from the dreaming slave database, and uniformly submitting the timestamp, wherein the business table operation and the temporary table updating operation of the dreaming master database belong to the same transaction, namely TRXID is the same.
And 6, for the business table of the dreaming database, screening and filtering incremental data only belonging to the dreaming database according to the TRXID in the step 5, collecting the incremental data by using a flashback log of the dreaming database, and transmitting the incremental data to the dreaming slave database through the CMSP.
And 7, after the steps 1-6 are executed, the bidirectional synchronization of incremental data in the dreaming master database and the dreaming slave database can be realized.
In this embodiment, the dreaming master database and the dreaming slave database have N service tables, respectively, and a temporary table is established in the dreaming master database and the dreaming slave database, respectively.
In this embodiment, when the incremental data of the dreaming master database and the dreaming slave database are synchronized in two directions,
a) the dreaming master database and the dreaming slave database have business incremental data and copy incremental data from the dreaming slave database/dreaming master database;
b) the data of the business tables corresponding to the dreaming master database and the dreaming slave database cannot be modified simultaneously;
c) the service table is required to have a primary key and cannot have an incremental field.
Example two:
the present embodiment proposes a tool for implementing bidirectional synchronization of a loop-back control database based on TRXID, where the tool is based on temporary tables respectively built in a dreaming master database and a dreaming slave database, the dreaming master database and the dreaming slave database, and N service tables respectively contained in the dreaming master database and the dreaming slave database. The tool comprises an acquisition module and a storage module, and the specific process of realizing bidirectional synchronization of incremental data of a dreaming master database and a dreaming slave database comprises the following steps:
(1) for the business table of the dreaming master database, the acquisition module acquires the incremental data of the dreaming master database by using the flashback log and transmits the incremental data to the business table of the dreaming slave database through the CMSP;
(2) the warehousing module inserts the incremental data from the dreaming master database into the business table of the dreaming slave database, meanwhile, updates the temporary table of the dreaming slave database by using the incremental data from the dreaming master database, and submits the incremental data in a unified way, at the moment, the business table operation and the temporary table updating operation of the dreaming slave database belong to the same transaction, namely TRXID is the same;
(3) for the business table of the Daemon slave database, the acquisition module filters the incremental data only belonging to the Daemon slave database according to the TRXID screening in the step (2), acquires the incremental data by using a flashback log of the Daemon slave database, and transmits the incremental data to the Daemon master database through the CMSP;
(4) the warehousing module inserts the incremental data from the dreaming slave database into the business table of the dreaming master database, meanwhile, updates the temporary table of the dreaming master database by using the incremental data from the dreaming slave database, and submits the incremental data in a unified way, at the moment, the business table operation of the dreaming master database and the operation of updating the temporary table belong to the same transaction, namely TRXID is the same;
(5) and (4) for the business table of the dreamin database, filtering the incremental data only belonging to the dreamin database according to the TRXID screening in the step (4), collecting the incremental data by using a flashback log of the dreamin database, and transmitting the incremental data to the dreamin database through the CMSP.
In this embodiment, when the incremental data of the dreaming database and dreaming slave database are synchronized in two ways,
a) data of the corresponding business tables of the dreaming master database and the dreaming slave database cannot be modified simultaneously,
b) the service table is required to have a primary key and cannot have an incremental field,
c) the dreaming database and the dreaming slave database have business incremental data as well as replication incremental data from the dreaming slave database/dreaming master database.
In summary, by adopting the method and the tool for realizing bidirectional synchronization of the loop control database based on TRXID, the invention utilizes the flashback log query, screens out the incremental data belonging to the business operation based on the TRXID filter, and combines the CMSP high-efficiency transmission to realize the real-time synchronization of the incremental data among dreams databases.
Based on the above embodiments of the present invention, those skilled in the art should make any improvements and modifications to the present invention without departing from the principle of the present invention, and therefore, the present invention should fall into the protection scope of the present invention.
Claims (10)
1. A method for realizing bidirectional synchronization of a database of loop back control based on TRXID is characterized by comprising the following steps:
step 1, respectively establishing temporary tables based on a dreaming master database and a dreaming slave database;
step 2, acquiring incremental data of the dreaming master database by utilizing the flashback log of the dreaming master database, and transmitting the incremental data to a business table of the dreaming slave database through the CMSP;
step 3, inserting the incremental data from the dreaming master database into the business table of the dreaming slave database, updating the temporary table of the dreaming slave database by using the incremental data from the dreaming master database, and uniformly submitting the temporary table, wherein the business table operation and the temporary table updating operation of the dreaming slave database belong to the same transaction, namely TRXID is the same;
step 4, for the business table of the Daemon slave database, screening and filtering the incremental data only belonging to the Daemon slave database according to the TRXID in the step 3, collecting the incremental data by using a flashback log of the Daemon slave database, and transmitting the incremental data to the Daemon master database through the CMSP;
step 5, inserting the incremental data from the dreaming slave database into the business table of the dreaming master database, updating the temporary table of the dreaming master database by using the incremental data from the dreaming slave database, and uniformly submitting the temporary table, wherein the business table operation and the temporary table updating operation of the dreaming master database belong to the same transaction, namely TRXID is the same;
step 6, for the business table of the dreaming database, screening and filtering incremental data only belonging to the dreaming database according to the TRXID in the step 5, collecting the incremental data by using a flashback log of the dreaming database, and transmitting the incremental data to the dreaming database through the CMSP;
and 7, after the steps 1-6 are executed, the bidirectional synchronization of incremental data in the dreaming master database and the dreaming slave database can be realized.
2. The method of claim 1, wherein when bidirectional synchronization is performed on incremental data of the dreaming master database and the dreaming slave database, the dreaming master database and the dreaming slave database have both business incremental data and duplicate incremental data from the dreaming slave database/the dreaming master database.
3. The method of claim 1, wherein when bidirectional synchronization is performed between the dreaming database and the dreaming slave database, assuming that the dreaming database and the dreaming slave database have no incremental data, there are two columns of TABLE _ NAME and TABLE _ VALUE in the temporary TABLEs of the dreaming database and the dreaming slave database, respectively, the TABLE _ NAME is used to store the service TABLE NAME, the TABLE _ VALUE is used to store the timestamp, and one record corresponds to one service TABLE.
4. The method of claim 3, wherein in step 3, the temporary table in the Daemon slave database is updated with incremental data from the Daemon master database, i.e. the temporary table in the Daemon slave database is updated with the timestamp of the service table record.
5. The method of claim 4, wherein in step 5, the temporary table in the Darmman database is updated with incremental data from the Darmman database, i.e. the timestamp of the temporary table in the Darmman database corresponding to the business table record is updated.
6. The method of claim 1, wherein when bidirectional synchronization is performed on incremental data of the dreaming master database and the dreaming slave database, data of corresponding business tables of the dreaming master database and the dreaming slave database cannot be modified simultaneously.
7. The method of claim 1, wherein the incremental data of the daemon database and the daemon slave database are synchronized bidirectionally, requiring a main key and not having self-increment fields in the service table.
8. The method of claim 1, wherein the dreams main database and the dreams sub database have at least one service table respectively, and the dreams main database and the dreams sub database respectively have a temporary table respectively.
9. A tool for realizing bidirectional synchronization of a database of loop back control based on TRXID is characterized in that the tool is based on a Darmmer database and a Darmmer slave database, temporary tables respectively established in the Darmmer database and the Darmmer slave database, and at least one service table respectively contained in the Darmmer database and the Darmmer slave database;
the tool comprises an acquisition module and a storage module, and the specific process of realizing bidirectional synchronization of incremental data of a dreaming master database and a dreaming slave database comprises the following steps:
(1) for the business table of the dreaming master database, the acquisition module acquires the incremental data of the dreaming master database by using the flashback log and transmits the incremental data to the business table of the dreaming slave database through the CMSP;
(2) the warehousing module inserts the incremental data from the dreaming master database into the business table of the dreaming slave database, meanwhile, updates the temporary table of the dreaming slave database by using the incremental data from the dreaming master database, and submits the incremental data in a unified way, at the moment, the business table operation and the temporary table updating operation of the dreaming slave database belong to the same transaction, namely TRXID is the same;
(3) for the business table of the Daemon slave database, the acquisition module filters the incremental data only belonging to the Daemon slave database according to the TRXID screening in the step (2), acquires the incremental data by using a flashback log of the Daemon slave database, and transmits the incremental data to the Daemon master database through the CMSP;
(4) the warehousing module inserts the incremental data from the dreaming slave database into the business table of the dreaming master database, meanwhile, updates the temporary table of the dreaming master database by using the incremental data from the dreaming slave database, and submits the incremental data in a unified way, at the moment, the business table operation of the dreaming master database and the operation of updating the temporary table belong to the same transaction, namely TRXID is the same;
(5) and (4) for the business table of the dreamin database, filtering the incremental data only belonging to the dreamin database according to the TRXID screening in the step (4), collecting the incremental data by using a flashback log of the dreamin database, and transmitting the incremental data to the dreamin database through the CMSP.
10. The tool for realizing bidirectional synchronization of database based on TRXID loop-back control as claimed in claim 9, wherein when bidirectional synchronization is realized by incremental data of Dameng master database and Dameng slave database,
data of the corresponding business tables of the dreaming master database and the dreaming slave database cannot be modified simultaneously,
the service table is required to have a primary key and cannot have an incremental field,
the dreaming database and the dreaming slave database have business incremental data as well as replication incremental data from the dreaming slave database/dreaming master database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010864404.0A CN112000684B (en) | 2020-08-25 | 2020-08-25 | Method and tool for realizing bidirectional synchronization of database of loop control based on TRXID |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010864404.0A CN112000684B (en) | 2020-08-25 | 2020-08-25 | Method and tool for realizing bidirectional synchronization of database of loop control based on TRXID |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112000684A true CN112000684A (en) | 2020-11-27 |
| CN112000684B CN112000684B (en) | 2023-12-26 |
Family
ID=73471640
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010864404.0A Active CN112000684B (en) | 2020-08-25 | 2020-08-25 | Method and tool for realizing bidirectional synchronization of database of loop control based on TRXID |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112000684B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113157813A (en) * | 2021-05-27 | 2021-07-23 | 山东新一代信息产业技术研究院有限公司 | Synchronous node device for realizing bidirectional synchronization of database |
| CN117473021A (en) * | 2023-12-28 | 2024-01-30 | 广州睿帆科技有限公司 | Incremental synchronization realization method for dream database based on CDC mode |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030200212A1 (en) * | 2002-04-23 | 2003-10-23 | International Business Machiness Corporation | Method, system, and program product for transaction management in a distributed content management application |
| US20180150504A1 (en) * | 2016-11-30 | 2018-05-31 | Sap Se | Write Access Control in a Database |
| CN109241185A (en) * | 2018-08-27 | 2019-01-18 | 武汉达梦数据库有限公司 | A kind of method and data synchronization unit that data are synchronous |
| CN109684327A (en) * | 2018-11-23 | 2019-04-26 | 武汉达梦数据库有限公司 | A kind of data capture method of database external linkage |
-
2020
- 2020-08-25 CN CN202010864404.0A patent/CN112000684B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030200212A1 (en) * | 2002-04-23 | 2003-10-23 | International Business Machiness Corporation | Method, system, and program product for transaction management in a distributed content management application |
| US20180150504A1 (en) * | 2016-11-30 | 2018-05-31 | Sap Se | Write Access Control in a Database |
| CN109241185A (en) * | 2018-08-27 | 2019-01-18 | 武汉达梦数据库有限公司 | A kind of method and data synchronization unit that data are synchronous |
| CN109684327A (en) * | 2018-11-23 | 2019-04-26 | 武汉达梦数据库有限公司 | A kind of data capture method of database external linkage |
Non-Patent Citations (1)
| Title |
|---|
| 钟容;: "基于事务日志的数据同步模型研究", 科技创新与应用, no. 10 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113157813A (en) * | 2021-05-27 | 2021-07-23 | 山东新一代信息产业技术研究院有限公司 | Synchronous node device for realizing bidirectional synchronization of database |
| CN117473021A (en) * | 2023-12-28 | 2024-01-30 | 广州睿帆科技有限公司 | Incremental synchronization realization method for dream database based on CDC mode |
| CN117473021B (en) * | 2023-12-28 | 2024-03-12 | 广州睿帆科技有限公司 | Incremental synchronization realization method for dream database based on CDC mode |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112000684B (en) | 2023-12-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3602341B1 (en) | Data replication system | |
| US8224860B2 (en) | Database management system | |
| CN107729366A (en) | A kind of pervasive multi-source heterogeneous large-scale data synchronization system | |
| US20070255763A1 (en) | Database replication method and system | |
| CN112000684A (en) | Method and tool for realizing bidirectional synchronization of database of loop control based on TRXID | |
| CN103067483A (en) | Remote data increment synchronization method and device based on data package | |
| CN106802905B (en) | Collaborative data exchange method of isomorphic PLM system | |
| CN113468170B (en) | System for automatically realizing real-time synchronization of data | |
| CN102724304A (en) | Information warehouse federation in subscription/release system and data synchronization method | |
| CN103345502A (en) | Transaction processing method and system of distributed type database | |
| CN104516989A (en) | Incremental data pushing system and method | |
| CN105447054A (en) | Data synchronization method, device and system for database | |
| CN107786355A (en) | A kind of method and apparatus of smart city information sharing | |
| CN110556182A (en) | Hospital data circulation tracing method | |
| CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
| CN111930768A (en) | Incremental data acquisition method, incremental data transmission method, incremental data acquisition device, incremental data transmission device and computer storage medium | |
| CN112988702A (en) | Heterogeneous data source real-time data transmission method and system, storage medium and terminal | |
| CN106055723A (en) | Database data synchronization device, system and method | |
| CN111913933B (en) | Power grid historical data management method and system based on unified support platform | |
| CN115481110A (en) | Resource sharing exchange design method based on metadata | |
| CN108228756A (en) | Data based on the PG databases of daily record analytic technique to Hadoop platform synchronize clone method | |
| CN109657000B (en) | Real-time data synchronization method and device of rail transit comprehensive monitoring system | |
| Gu et al. | Analysis of data replication mechanism in NoSQL database MongoDB | |
| Hossain et al. | SQL query based data synchronization in heterogeneous database environment | |
| CN103853748A (en) | Database synchronizing method |
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 |