Invention Grant
- Patent Title: Database query execution tracing and data generation for diagnosing execution issues
-
Application No.: US16436171Application Date: 2019-06-10
-
Publication No.: US10970279B2Publication Date: 2021-04-06
- Inventor: James A. Ford , Lakshman R. Sakaray , Paul-John A. To
- 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
- Agent Anthony V. S. England; Richard Wilhelm; Susan M. Maze
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/242 ; G06F11/36

Abstract:
Trace data is received that was captured for an execution of a query on first tables when execution trouble occurs during an execution of the query on the first tables. Trace data includes counts of evaluation states caused by the execution and includes identifications of portions of the query that reference variables of the first tables and that correspond with the evaluation states. Second tables are generated from the evaluation state counts and the identifications of the trace data without accessing data values of the first tables, so that the first tables are kept private. Evaluation states are reproduced from the execution of the query on the first tables by executing the query on the second tables without accessing the data values of the first tables.
Public/Granted literature
- US20190294607A1 DATABASE QUERY EXECUTION TRACING AND DATA GENERATION FOR DIAGNOSING EXECUTION ISSUES Public/Granted day:2019-09-26
Information query