Platform-independent method and system for graphically presenting the evaluation of a query in a database management system
First Claim
Patent Images
1. A method for graphically representing a plan for an input query for a relational database management system comprising the steps of:
- a) receiving an input query;
b) processing the input query to form a plurality of plans;
c) selecting at least one plan of the plurality of plans;
d) transforming the selected plan into a self-describing formatted file, wherein the self-describing formatted file is platform independent; and
e) generating a graph representing the selected plan from the self-describing formatted file.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system for graphically representing a plan for a query in a relational database management system is disclosed. The method includes receiving and processing an input query to form a plurality of plans, selecting at least one plan of the plurality of plans, and transforming the selected plan into a self-describing formatted file which is platform independent. The method further includes generating a graph representing the selected plan from the self-describing formatted file.
-
Citations
42 Claims
-
1. A method for graphically representing a plan for an input query for a relational database management system comprising the steps of:
-
a) receiving an input query;
b) processing the input query to form a plurality of plans;
c) selecting at least one plan of the plurality of plans;
d) transforming the selected plan into a self-describing formatted file, wherein the self-describing formatted file is platform independent; and
e) generating a graph representing the selected plan from the self-describing formatted file. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A computer readable medium containing programming instructions for graphically representing a plan for an input query for a relational database management system, the programming instructions for:
-
a) receiving an input query;
b) processing the input query to form a plurality of plans;
c) selecting at least one plan of the plurality of plans;
d) transforming the selected plan into a self-describing formatted file, wherein the self-describing formatted file is platform independent; and
e) generating a graph representing the selected plan from the self-describing formatted file. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
-
27. A system for graphically representing a plan for an input query to a relational database management system (RDBMS), the system comprising:
-
a query compiler in the RDBMS for processing the input query and generating a plurality of plans for the input query;
means for selecting at least one plan of the plurality of plans;
a self-describing formatted file generator coupled to the query optimizer for transforming the selected plan into a self-describing formatted file, wherein the self-describing formatted file is platform independent; and
means for generating a graph representing the selected plan from the self-describing formatted file. - View Dependent Claims (28, 29, 30, 31, 32, 33, 34, 35, 36, 37)
-
-
38. A method for graphically representing a query execution plan for an input query for a relational database management system comprising the steps of:
-
a) receiving an input query;
b) compiling the input query to form a query execution plan;
c) transforming the query execution plan into a file written in Extensible Markup Language (XML), wherein the XML file is platform independent;
d) reading the XML file by an XML file processor;
e) creating a plurality of nodes according to the XML file;
f) collecting detailed information related to each node and associating the related information with each corresponding node, such that the related information is available if requested; and
g) connecting the plurality of nodes with a plurality of arcs to generate a graph representing the query execution plan from the XML file. - View Dependent Claims (39, 40, 41, 42)
-
Specification