Back to results
US 8,898,146 B2Granted
System and method for comparing database query plans
AssigneeHewlett-Packard Development Company, L.P.
InventorsMaria G. Castellanos, Perla Ruiz
Life of this patent
Estimating the term…
Abstract
A method and device may accept a first database query plan including a plurality of rows and a second database query plan including a plurality of rows, compare each row in the first database query plan with a corresponding row in the second database query plan, and based on each comparison, calculate a difference between the compared rows. Each difference may be recorded in an output file.
Claims16
A method comprising:
- accepting a first database query plan comprising a plurality of rows and a second database query plan comprising a plurality of rows, wherein the first database query plan is based on a query applied to a database management system and the second database query plan is based on the query applied to the database management system after a change has been made to an optimizer which produces an execution plan;
- comparing by a processor each row in the first database query plan with a corresponding row in the second database query plan, and based on each comparison, calculating a difference between the compared rows,
- wherein the comparison comprises a comparison of a cardinality of the rows and of an operator within the rows;
- and
- recording each difference in an output file.
2 more elements
A system comprising:
- a memory to store at least a first database query plan comprising a plurality of rows and a second database query plan comprising a plurality of rows, wherein the first database query plan is based on a query applied to a database management system and the second database query plan is based on the query applied to the database management system after a change has been made to the data managed by the database management system;
- and
- a processor configured to accept the first database query plan and the second database query plan, compare each row in the first database query plan with a corresponding row in the second database query plan, and based on each comparison, calculate a difference between the compared rows, and record each difference in an output file,
- wherein the comparison comprises a comparison of a cardinality of the rows and of an operator within the rows.
1 more element
A method comprising:
- for a first database query plan comprising a plurality of operators, the first database query plan produced by a database management system from a query;
- and a second database query plan comprising a plurality of operators, the second database query plan produced by the database management system from the query after a change has been made to the database management system or an optimizer which produces an execution plan:
- comparing, by a processor, corresponding operators in the first database query plan and the second database query plan to determine a set of changes,
- wherein the comparison comprises a comparison of a cardinality of rows of the first and the second database query plans and of an operator within the rows;
- and
- providing the changes to a user.
3 more elements
Dependencies are inferred from the claim text.