Patent ID: 9563538
Date: 2017-02-07
CPC Classifications: G06F

Claim:
1. A computer-implemented method for code path tracking, the method comprising: identifying, at a decision point, a trace point in software code to be path-tracked, wherein the decision point is a section, in the software code to be path-tracked, for executing a SQL function, wherein the SQL function is a sequence of one or more database operations for implementing an access plan; instrumenting, after identifying the trace point at the decision point, the trace point; identifying, by a code path tracking module of a SQL query optimizer executing on a recording computer, the instrumented trace point in the software code to be path-tracked; identifying, by the code path tracking module, the SQL function in the software code to be path-tracked, wherein the SQL function is executed in the software code at the instrumented trace point; identifying, by the code path tracking module, parameters corresponding to the SQL function executed at the instrumented trace point, the parameters being at least one of values and data structures upon which the SQL function operates; recording, by the code path tracking module, a description of the SQL function, the parameters, and the result of the execution of the SQL function using the parameters; and transferring, from the recording computer to a replay computer, the recorded description of the SQL function, the parameters, and the result of the execution of the SQL function using the parameters, wherein the replay computer is configured to: