Automatically restoring data replication consistency without service interruption during parallel apply
US10229152B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jun 27, 2016 |
| Grant date | Mar 12, 2019 |
| Priority date | — |
| Expiry date | Jan 4, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/284
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A data replication method can begin with the detection of an inconsistency between records of a target table and corresponding records of a source table of a relational database management system (RDBMS) performing a parallel apply replication by an improved data replication manager. The target table can be a copy of the source table, both of which include multiple unique constraints and indexes. A timeframe that encompasses the records of the target table having the inconsistency can be determined. The timeframe can utilize a commit timestamp or a log sequence number. Consistency between the target table and the source table can be automatically restored for the determined timeframe through use of a reactive-apply process. Data suppression for updates is automatically restored once the copy is consistent. Transactions performed upon the target table by the reactive-apply process can be performed in parallel. Service at the source table and the target table can be uninterrupted.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.