Back to results
US 2012/0072413 A1Published application
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.
Claims14
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;
- 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;
- and
- recording each difference in an output file.
1 more element
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;
- and
- a processor accepting the first database query plan and the second database query plan, comparing 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, and recording each difference in an output file.
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 the data managed by the database management system:
- comparing corresponding operators in the first database query plan and the second database query plan to determine a set of changes;
- and
- providing the changes to a user.
2 more elements
Dependencies are inferred from the claim text.