Method for auditing data integrity in a high availability database
US7895501B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Feb 6, 2007 |
| Grant date | Feb 22, 2011 |
| Priority date | — |
| Expiry date | Dec 24, 2029 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2365
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method for maintaining the integrity of a backup database table on a secondary node against a continuously replicated and dynamically changing original database table on a primary node includes generating an original checksum of a segment of the original database table between a beginning record and an ending record. The checksum and identification data may be stored in an original control database table. The original control database table may be replicated to a backup control database table. Thereafter, a backup checksum of a segment of the backup database table between a beginning record and an ending record is generated. A comparison between the backup checksum and the original checksum is made in response to a triggering update to the backup control database table. Collisions by application generate transactions in the source and target databases may be detected despite the use of third party “black box” replication processes.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.