Invention Grant
- Patent Title: Determining integrity of database workload transactions
-
Application No.: US15385235Application Date: 2016-12-20
-
Publication No.: US10678775B2Publication Date: 2020-06-09
- Inventor: Pedro M. Barbas , Paddy Burke , Gary F. Murtagh , David M. Tilson
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Edell, Shapiro & Finnan, LLC
- Agent Robert Bunker
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/23

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.
Public/Granted literature
- US20180173744A1 DETERMINING INTEGRITY OF DATABASE WORKLOAD TRANSACTIONS Public/Granted day:2018-06-21
Information query