Back to results
US 10,380,109 B2Granted
Database query execution tracing and data generation for diagnosing execution issues
AssigneeInternational Business Machines Corporation
InventorsJames A. Ford, Lakshman R. Sakaray, Paul-John A. To
Life of this patent
Estimating the term…
Abstract
Trace data is received that was captured for an execution of a first query on first input data. The trace data associates clauses of the first query with respective evaluation states that arise during the execution. Second input data is generated from the trace data without accessing the first input data. An execution of a second query is performed on the second input data, wherein performing the execution of the second query on the second input data reproduces evaluation states from the execution of the first query on the first input data.
Claims10
A method comprising:
- receiving trace data captured for an execution of a query on first tables when execution trouble occurs during an execution of the query on the first tables, where the 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;
- generating, second tables 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, where the generating populates the second tables with data values that are independent of the data values of the first tables, and where the data values of the second tables are such that executing the query on the second tables reproduces the evaluation states caused by the execution of the query on the first tables;
- and
- reproducing the evaluation states 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, so that the reproduced evaluation states reproduce the execution trouble that occurs during the execution of the query on the first tables while keeping the data values of the first tables private.
1 more element
Dependencies are inferred from the claim text.