Determining integrity of database workload transactions
US10678775B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Dec 20, 2016 |
| Grant date | Jun 9, 2020 |
| Priority date | — |
| Expiry date | Dec 28, 2038 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2343
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Evaluating integrity of database workloads includes receiving transactional database lock commands from concurrent users and identifying a usage pattern of lock actions when results of an execution of the transactional database lock commands match a usage pattern for a data integrity rule. The data integrity rule is added to a set of one or more data integrity rules for the transactional database lock commands. The transactional database lock commands and the set of one or more data integrity rules are forwarded from a primary database server to a duplicate database server that is equivalent to the primary database server and configured to execute the transactional database lock commands while applying the one or more data integrity rules. Anomalies indicating a data integrity problem may be detected based on a comparison of the results of the executions at the primary database server and the duplicate database server.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.