CN112000684B - 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
- CN112000684B CN112000684B CN202010864404.0A CN202010864404A CN112000684B CN 112000684 B CN112000684 B CN 112000684B CN 202010864404 A CN202010864404 A CN 202010864404A CN 112000684 B CN112000684 B CN 112000684B
- Authority
- CN
- China
- Prior art keywords
- dream
- database
- incremental data
- slave
- master database
- 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
- 230000002457 bidirectional effect Effects 0.000 title claims abstract description 43
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000001914 filtration Methods 0.000 claims abstract description 10
- 238000012216 screening Methods 0.000 claims description 11
- 230000010076 replication Effects 0.000 claims description 5
- 230000001360 synchronised effect Effects 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect 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
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 method for realizing bidirectional synchronization of a database based on TRXID (TRXID) loop control, which relates to the technical field of data synchronization and comprises the following steps: based on the dream master database and the dream slave database, temporary tables are respectively built in the two databases; collecting incremental data of a master library by using a flashback log, transmitting the incremental data to a slave library service table, receiving the incremental data from the slave library, updating a temporary table, uniformly submitting the incremental data, wherein the service table operation of the slave library and the temporary table updating operation have the same TRXID, 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; and the master library receives the incremental data and updates the temporary table, after unified submission, the business table operation of the master library and the temporary table updating operation have the same TRXID, the incremental data only belonging to the master library is filtered according to the TRXID, and the incremental data is transmitted to the slave library, so that bidirectional synchronization of the incremental data in the dream master database and the dream slave database is realized. The invention also discloses a tool, which realizes the method through the acquisition module and the warehouse-in 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 control based on TRXID.
Background
With the rapid development of modern information technology, human society is moving into the internet and the big data age. The information is deeply changing the thinking, production and life style of people, and is deeply fused with various industries, thus generating huge social and commercial values. Artificial intelligence technology is rapid, 5G is rapidly developed, and the result is 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 a network environment, the instability of equipment, the artificial misoperation and the like can bring about small potential safety hazards to the data, so that the data synchronization and the backup are very important.
The CMSP is a high-performance message middleware in cloud and big data age, provides high-performance and high-reliability message queue service in a cloud service and cluster mode, and supports 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, has the function of being unground for getting rid of the dependence on foreign technology in China, and is more important in the current complex world situation. The dream database has huge market and commercial value in China and internationally, and has great value for research and discovery related to the dream database.
By inquiring the flashback log, the incremental operation of the dream database can be acquired, and the acquired incremental operation is repeatedly executed in another dream database, so that the incremental synchronization of the databases is realized. Referring to fig. 1, dream 1 is a master database, dream 2 is a slave database, incremental operations are obtained by querying a flashback log of dream 1, and then the incremental operations are repeated in dream 2, so that synchronization of dream 2 and dream 1, namely master-slave database synchronization, is realized.
However, two-way synchronization of two dream databases cannot be achieved by querying the flashback log. As shown in fig. 2, incremental data reaching dream 1 arrives at dream 2 synchronously, and at the same time, incremental data reaching dream 2 arrives at dream 1 synchronously; when the incremental data of the dream 1 synchronously arrives at the dream 2, the incremental data can be generated for the dream 2 after the incremental operation is repeated, then the incremental data can synchronously arrive at the dream 1 again, and then the incremental data synchronously arrives at the dream 2 from the dream 1, and the incremental data is circularly reciprocated to form a dead cycle. For this purpose, loop control is required based on the dream database transaction ID.
Disclosure of Invention
Aiming at the needs and the shortcomings of the prior art, the invention provides a method and a tool for realizing bidirectional synchronization of a database based on TRXID (TRXID) loop control based on a dream database transaction ID.
Firstly, the invention provides a method for realizing bidirectional synchronization of a database based on TRXID loop control, which solves the technical problems and adopts the following technical scheme:
a method for implementing bidirectional synchronization of a database for loop control based on TRXID, the method comprising the steps of:
step 1, based on a dream master database and a dream slave database, respectively establishing temporary tables;
step 2, utilizing a dream master database to flash back a log, collecting incremental data of the dream master database, and transmitting the incremental data to a business table of a dream slave database through a CMSP;
step 3, inserting incremental data from the dream master database into a business table of the dream slave database, updating a temporary table of the dream slave database by utilizing the incremental data from the dream master database, and uniformly submitting the temporary table, wherein the business table operation and the temporary table updating operation of the dream slave database belong to the same transaction, namely TRXID is the same;
step 4, filtering incremental data only belonging to the dream slave database according to the TRXID screening of the step 3, collecting the incremental data by using a flashback log of the dream slave database, and transmitting the incremental data to a dream master database through a CMSP;
step 5, inserting incremental data from the dream slave database into the business table of the dream master database, updating the temporary table of the dream master database by utilizing the incremental data from the dream slave database, and uniformly submitting the temporary table, wherein the business table operation and the temporary table updating operation of the dream master database belong to the same transaction, namely TRXID is the same;
step 6, filtering incremental data only belonging to the dream master database according to the TRXID screening of the step 5, collecting the incremental data by using a flashback log of the dream master database, and transmitting the incremental data to the dream slave database through a CMSP;
and 7, after the step 1-6 is executed, bidirectional synchronization of incremental data in the dream master database and the dream slave database can be realized.
Optionally, when the incremental data of the dream master database and the dream slave database are synchronized bidirectionally, the dream master database and the dream slave database have business incremental data and copy incremental data from the dream slave database/the dream master database.
Optionally, when the incremental data of the dream master database and the dream slave database begin to be synchronized bidirectionally, it is assumed that the dream master database and the dream slave database have no incremental data, at this time, two columns of table_name and table_value are respectively in temporary TABLEs of the dream master database and the dream slave database, the table_name is used for storing service TABLE NAMEs, the table_value is used for storing time stamps, and one record corresponds to one service TABLE.
Optionally, in step 3, the incremental data from the dream master database is used to update the temporary table of the dream slave database, that is, to update the timestamp of the temporary table of the dream slave database corresponding to the record of the business table.
Optionally, in step 5, the temporary table of the dream master database is updated by using incremental data from the dream slave database, that is, the timestamp of the temporary table in the dream master database corresponding to the record of the service table is updated.
Optionally, when the incremental data of the dream master database and the dream slave database realize bidirectional synchronization, the data of the business tables corresponding to the dream master database and the dream slave database cannot be modified at the same time.
Optionally, when incremental data of the dream master database and the dream slave database realize bidirectional synchronization, a master key is required in the service table, and a self-increment field cannot be provided.
Optionally, the dream master database and the dream slave database are respectively provided with at least one service table, and a temporary table is respectively established in the dream master database and the dream slave database.
Secondly, the invention provides a tool for realizing bidirectional synchronization of a database based on TRXID loop control, which solves the technical problems and adopts the following technical scheme:
a tool for realizing bidirectional synchronization of a database for loop control based on TRXID is based on a dream master database and a dream slave database, temporary tables respectively established in the dream master database and the dream slave database, and at least one service table respectively contained in the dream master database and the dream slave database. The tool comprises an acquisition module and a warehouse-in module, wherein the specific process for realizing bidirectional synchronization of incremental data of a dream master database and a dream slave database is as follows:
(1) For the business table of the dream main database, the acquisition module acquires incremental data of the dream main database by using a flashback log and transmits the incremental data to the business table of the dream slave database through a CMSP;
(2) The warehousing module inserts the incremental data from the dream master database into the business table of the dream slave database, and simultaneously updates the temporary table of the dream slave database by utilizing the incremental data from the dream master database and uniformly submits the temporary table, and at the moment, the business table operation and the temporary table updating operation of the dream slave database belong to the same transaction, namely TRXID is the same;
(3) For the business table of the dream slave database, the acquisition module filters incremental data only belonging to the dream slave database according to the TRXID screening of (2), acquires the incremental data by using the flashback log of the dream slave database, and transmits the incremental data to the dream master database through the CMSP;
(4) The warehousing module inserts the incremental data from the dream slave database into the business table of the dream master database, and simultaneously updates the temporary table of the dream master database by utilizing the incremental data from the dream slave database and uniformly submits the temporary table, and at the moment, the business table operation and the temporary table updating operation of the dream master database belong to the same transaction, namely TRXID is the same;
(5) And (3) filtering incremental data only belonging to the dream master database according to the TRXID screening of the step (4) for the business table of the dream master database, collecting the incremental data by using a flashback log of the dream master database, and transmitting the incremental data to the dream slave database through the CMSP.
Optionally, when the incremental data of the dream master database and the dream slave database are in bidirectional synchronization,
the data of the business tables corresponding to the dream master database and the dream slave database cannot be modified at the same time,
requiring a primary key in the service table and not having a self-increment field,
the dream master database and the dream slave database have business increment data and replication increment data from the dream slave database/the dream master database.
The method and the tool for realizing bidirectional synchronization of the database based on TRXID control have the beneficial effects that compared with the prior art:
1) The invention utilizes the flashback log to inquire, filters out the incremental data belonging to the business operation based on TRXID, combines the efficient transmission of CMSP, and can realize the real-time synchronization of the incremental data between the dream databases;
2) The invention has wide application prospect in service scenes with higher requirements for bidirectional synchronization of the application CMSP and the dream database.
Drawings
FIG. 1 is a diagram of unidirectional synchronization of incremental data of a master-slave database in accordance with the present invention;
FIG. 2 is a schematic diagram of bidirectional synchronization of incremental data of a master-slave database in accordance with the present invention;
FIG. 3 is a schematic diagram of bidirectional synchronization of incremental data of a master database and a slave database according to the present invention;
FIG. 4 is a diagram of an implementation architecture for bidirectional synchronization of incremental data of a master-slave database in accordance with the present invention.
Detailed Description
In order to make the technical scheme, the technical problems to be solved and the technical effects of the invention more clear, the technical scheme of the invention is clearly and completely described below by combining specific embodiments.
Embodiment one:
referring to fig. 3 and 4, this embodiment proposes a method for implementing bidirectional synchronization of a database for loop control based on TRXID, where the method includes the following steps:
step 1, based on a dream master database and a dream slave database, respectively establishing temporary TABLEs sys_TWOWAYSYNC_TABLE; it is assumed that the dream master database and the dream slave database have no incremental data at this time, and the temporary TABLEs of the dream master database and the dream slave database have two columns of table_name and table_value, respectively, the table_name is used for storing service TABLE NAMEs, the table_value is used for storing time stamps, and one record corresponds to one service TABLE.
And step 2, utilizing a flash log of the dream master database to collect incremental data of the dream master database, and transmitting the incremental data to a business table of the dream slave database through the CMSP.
And 3, inserting incremental data from the dream master database into a business table of the dream slave database, updating a timestamp of a temporary table corresponding to the business table record in the dream slave database by utilizing the incremental data from the dream master database, and uniformly submitting the timestamp, wherein at the moment, the business table operation and the temporary table updating operation of the dream slave database belong to the same transaction, namely TRXID is the same.
And 4, filtering incremental data only belonging to the dream slave database according to the TRXID screening of the step 3, collecting the incremental data by using a flashback log of the dream slave database, and transmitting the incremental data to a dream master database through a CMSP.
And 5, inserting incremental data from the dream slave database into a business table of the dream master database, updating a timestamp of a temporary table corresponding to the business table record in the dream master database by utilizing the incremental data from the dream slave database, and uniformly submitting the timestamp, wherein at the moment, business table operation and temporary table updating operation of the dream master database belong to the same transaction, namely TRXID is the same.
And 6, filtering the business table of the dream master database according to the TRXID in the step 5, collecting incremental data only belonging to the dream master database by using a flashback log of the dream master database, and transmitting the incremental data to the dream slave database through the CMSP.
And 7, after the step 1-6 is executed, bidirectional synchronization of incremental data in the dream master database and the dream slave database can be realized.
In this embodiment, the dream master database and the dream slave database have N service tables, respectively, and a temporary table is established in each of the dream master database and the dream slave database.
In the embodiment, when the incremental data of the dream master database and the dream slave database realize bidirectional synchronization,
a) The dream master database and the dream slave database have business increment data and replication increment data from the dream slave database/the dream master database;
b) The data of the business table corresponding to the dream master database and the dream slave database cannot be modified at the same time;
c) A primary key is required in the service table and no self-increment field can be provided.
Embodiment two:
the embodiment provides a tool for realizing bidirectional synchronization of a database for loop control based on TRXID, which is based on a dream master database and a dream slave database, temporary tables respectively established in the dream master database and the dream slave database, and N business tables respectively contained in the dream master database and the dream slave database. The tool comprises an acquisition module and a warehouse-in module, wherein the specific process for realizing bidirectional synchronization of incremental data of a dream master database and a dream slave database is as follows:
(1) For the business table of the dream main database, the acquisition module acquires incremental data of the dream main database by using a flashback log and transmits the incremental data to the business table of the dream slave database through a CMSP;
(2) The warehousing module inserts the incremental data from the dream master database into the business table of the dream slave database, and simultaneously updates the temporary table of the dream slave database by utilizing the incremental data from the dream master database and uniformly submits the temporary table, and at the moment, the business table operation and the temporary table updating operation of the dream slave database belong to the same transaction, namely TRXID is the same;
(3) For the business table of the dream slave database, the acquisition module filters incremental data only belonging to the dream slave database according to the TRXID screening of (2), acquires the incremental data by using the flashback log of the dream slave database, and transmits the incremental data to the dream master database through the CMSP;
(4) The warehousing module inserts the incremental data from the dream slave database into the business table of the dream master database, and simultaneously updates the temporary table of the dream master database by utilizing the incremental data from the dream slave database and uniformly submits the temporary table, and at the moment, the business table operation and the temporary table updating operation of the dream master database belong to the same transaction, namely TRXID is the same;
(5) And (3) filtering incremental data only belonging to the dream master database according to the TRXID screening of the step (4) for the business table of the dream master database, collecting the incremental data by using a flashback log of the dream master database, and transmitting the incremental data to the dream slave database through the CMSP.
In this embodiment, when the incremental data of the dream master database and the dream slave database are synchronized in both directions,
a) The data of the business tables corresponding to the dream master database and the dream slave database cannot be modified at the same time,
b) Requiring a primary key in the service table and not having a self-increment field,
c) The dream master database and the dream slave database have business increment data and replication increment data from the dream slave database/the dream master database.
In summary, by adopting the method and the tool for realizing bidirectional synchronization of the database based on TRXID (remote control unit) loop control, the invention utilizes flashback log inquiry, filters out incremental data belonging to service operation based on TRXID, combines CMSP (central management unit) efficient transmission, and can realize real-time synchronization of the incremental data among dream-reaching databases.
Based on the above-mentioned embodiments of the present invention, any improvements and modifications made by those skilled in the art without departing from the principles of the present invention should fall within the scope of the present invention.
Claims (10)
1. A method for realizing bidirectional synchronization of a database based on TRXID loop control is characterized by comprising the following steps:
step 1, based on a dream master database and a dream slave database, respectively establishing temporary tables;
step 2, utilizing a dream master database to flash back a log, collecting incremental data of the dream master database, and transmitting the incremental data to a business table of a dream slave database through a CMSP;
step 3, inserting incremental data from the dream master database into a business table of the dream slave database, updating a temporary table of the dream slave database by utilizing the incremental data from the dream master database, and uniformly submitting the temporary table, wherein the business table operation and the temporary table updating operation of the dream slave database belong to the same transaction, namely TRXID is the same;
step 4, filtering incremental data only belonging to the dream slave database according to the TRXID screening of the step 3, collecting the incremental data by using a flashback log of the dream slave database, and transmitting the incremental data to a dream master database through a CMSP;
step 5, inserting incremental data from the dream slave database into the business table of the dream master database, updating the temporary table of the dream master database by utilizing the incremental data from the dream slave database, and uniformly submitting the temporary table, wherein the business table operation and the temporary table updating operation of the dream master database belong to the same transaction, namely TRXID is the same;
step 6, filtering incremental data only belonging to the dream master database according to the TRXID screening of the step 5, collecting the incremental data by using a flashback log of the dream master database, and transmitting the incremental data to the dream slave database through a CMSP;
and 7, after the step 1-6 is executed, bidirectional synchronization of incremental data in the dream master database and the dream slave database can be realized.
2. The method for realizing bidirectional synchronization of databases based on TRXID loop control according to claim 1, wherein when bidirectional synchronization is realized on incremental data of a dream master database and a dream slave database, the dream master database and the dream slave database have both business incremental data and replication incremental data from the dream slave database/the dream master database.
3. The method for realizing bidirectional synchronization of databases based on TRXID according to claim 1, wherein when the dream master database and the dream slave database start to perform bidirectional synchronization with respect to incremental data of the databases, it is assumed that the dream master database and the dream slave database have no incremental data, and at this time, two columns of table_name and table_value are respectively provided in temporary TABLEs of the dream master database and the dream slave database, the table_name is used for storing service TABLE NAMEs, the table_value is used for storing time stamps, and one record corresponds to one service TABLE.
4. The method for implementing bidirectional synchronization of a database for loop control based on TRXID as claimed in claim 3, wherein in step 3, incremental data from a dream master database is used to update a temporary table of a dream slave database, i.e. to update a timestamp of a temporary table of a dream slave database corresponding to the service table record.
5. The method for implementing bidirectional synchronization of a database for loop control based on TRXID according to claim 4, wherein in step 5, the temporary table of the dream master database is updated with incremental data from the dream slave database, i.e. the timestamp of the temporary table in the dream master database corresponding to the service table record is updated.
6. The method for realizing bidirectional synchronization of databases based on TRXID loop control according to claim 1, wherein when incremental data of a dream master database and a dream slave database are bidirectional synchronized, data of service tables corresponding to the dream master database and the dream slave database cannot be modified at the same time.
7. The method for realizing bidirectional synchronization of databases based on TRXID for loop control according to claim 1, wherein when incremental data of a dream master database and a dream slave database are realized in bidirectional synchronization, a primary key is required in a service table, and a self-increment field cannot be provided.
8. The method for realizing bidirectional synchronization of a database based on TRXID loop control according to claim 1, wherein the dream master database and the dream slave database each have at least one service table, and wherein the dream master database and the dream slave database each establish a temporary table.
9. A tool for realizing bidirectional synchronization of a database for loop control based on TRXID, which is characterized in that the tool is based on a dream master database and a dream slave database, temporary tables respectively established in the dream master database and the dream slave database, and at least one service table respectively contained in the dream master database and the dream slave database;
the tool comprises an acquisition module and a warehouse-in module, wherein the specific process for realizing bidirectional synchronization of incremental data of a dream master database and a dream slave database is as follows:
(1) For the business table of the dream main database, the acquisition module acquires incremental data of the dream main database by using a flashback log and transmits the incremental data to the business table of the dream slave database through a CMSP;
(2) The warehousing module inserts the incremental data from the dream master database into the business table of the dream slave database, and simultaneously updates the temporary table of the dream slave database by utilizing the incremental data from the dream master database and uniformly submits the temporary table, and at the moment, the business table operation and the temporary table updating operation of the dream slave database belong to the same transaction, namely TRXID is the same;
(3) For the business table of the dream slave database, the acquisition module filters incremental data only belonging to the dream slave database according to the TRXID screening of (2), acquires the incremental data by using the flashback log of the dream slave database, and transmits the incremental data to the dream master database through the CMSP;
(4) The warehousing module inserts the incremental data from the dream slave database into the business table of the dream master database, and simultaneously updates the temporary table of the dream master database by utilizing the incremental data from the dream slave database and uniformly submits the temporary table, and at the moment, the business table operation and the temporary table updating operation of the dream master database belong to the same transaction, namely TRXID is the same;
(5) And (3) filtering incremental data only belonging to the dream master database according to the TRXID screening of the step (4) for the business table of the dream master database, collecting the incremental data by using a flashback log of the dream master database, and transmitting the incremental data to the dream slave database through the CMSP.
10. The tool for bidirectional synchronization of a database based on TRXID for loop control according to claim 9, wherein when incremental data of a dream master database and a dream slave database are bidirectional synchronized,
the data of the business tables corresponding to the dream master database and the dream slave database cannot be modified at the same time,
requiring a primary key in the service table and not having a self-increment field,
the dream master database and the dream slave database have business increment data and replication increment data from the dream slave database/the dream 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 CN112000684A (en) | 2020-11-27 |
| CN112000684B true 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) |
Families Citing this family (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 |
| CN117473021B (en) * | 2023-12-28 | 2024-03-12 | 广州睿帆科技有限公司 | Incremental synchronization realization method for dream database based on CDC mode |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6873995B2 (en) * | 2002-04-23 | 2005-03-29 | International Business Machines Corporation | Method, system, and program product for transaction management in a distributed content management application |
| US10275401B2 (en) * | 2016-11-30 | 2019-04-30 | Sap Se | Write access control in a database |
-
2020
- 2020-08-25 CN CN202010864404.0A patent/CN112000684B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
|---|
| 基于事务日志的数据同步模型研究;钟容;;科技创新与应用(第10期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112000684A (en) | 2020-11-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112000684B (en) | Method and tool for realizing bidirectional synchronization of database of loop control based on TRXID | |
| EP3602341B1 (en) | Data replication system | |
| US20150032695A1 (en) | Client and server integration for replicating data | |
| WO2018080843A1 (en) | Facilitating operations on pluggable databases using separate logical timestamp services | |
| CN103067483A (en) | Remote data increment synchronization method and device based on data package | |
| CN102917020A (en) | Mobile terminal based on data packet and method for synchronizing business system data | |
| CN113468170B (en) | System for automatically realizing real-time synchronization of data | |
| CN106802905B (en) | Collaborative data exchange method of isomorphic PLM system | |
| CN111327446B (en) | Configuration data processing method, software defined network device, system and storage medium | |
| CN105447054A (en) | Data synchronization method, device and system for database | |
| CN108228755A (en) | The data of MySQL database based on daily record analytic technique to Hadoop platform synchronize clone method | |
| CN101710336A (en) | Method for accelerating data processing by using relational middleware | |
| CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
| CN104216970B (en) | A kind of synergistic data exchange method | |
| Gu et al. | Analysis of data replication mechanism in NoSQL database MongoDB | |
| CN108228756A (en) | Data based on the PG databases of daily record analytic technique to Hadoop platform synchronize clone method | |
| CN108090056B (en) | Data query method, device and system | |
| CN109657000B (en) | Real-time data synchronization method and device of rail transit comprehensive monitoring system | |
| CN103853748A (en) | Database synchronizing method | |
| CN112883118A (en) | Method and system for synchronously acquiring incremental data based on sql | |
| CN109491988A (en) | A kind of data real time correlation method for supporting full dose to update | |
| Hossain et al. | SQL query based data synchronization in heterogeneous database environment | |
| CN116431635A (en) | Lake and warehouse integrated-based power distribution Internet of things data real-time processing system and method | |
| Lu et al. | A method of data synchronization based on message oriented middleware and xml in distributed heterogeneous environments | |
| CN115630122A (en) | Data synchronization method and device, storage medium and computer equipment |
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 |