Database query execution tracing and data generation for diagnosing execution issues

A system comprising:

• a processor;
• and
• a computer readable storage medium connected to the processor, wherein the computer readable storage medium has stored thereon a program for controlling the processor, and wherein the processor is operative with the program to execute the program for:
• receiving trace data captured for an execution of a first query on first input data, wherein the trace data associates clauses of the query with respective evaluation states that arise during the execution;
• generating second input data from the trace data without accessing the first input data, so that the first input data is kept private;
• and
• performing an execution of a second query on the second input data, wherein performing the execution of the second query on the second input data reproduces evaluation states from the first execution of the first query on the first input data.

A computer program product, the computer program product including a computer readable storage medium having instructions stored thereon for execution by a computer system, wherein the instructions, when executed by the computer system, cause the computer system to implement a method comprising:

• receiving trace data captured for an execution of a first query on first input data, wherein the trace data associates clauses of the query with respective evaluation states that arise during the first execution;
• generating second input data from the trace data without accessing the first input data, so that the first input data is kept private;
• and
• performing an execution of a second query 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.