System and Method to Optimize Queries on a View
AssigneeHuawei Technologies Co., Ltd.
InventorsNirmala Sreekantaiah, Dilip Kumar, Kumar Rajeev Rastogi
Life of this patent
Estimating the term…
Abstract
A system and method to optimize queries on a view comprise a processor coupled to a memory storing a plurality of instructions for directing the processor to receive a query comprising a part of query on view, check, based on the part of query on view, in system table, wherein the system table comprises a status associated with the view indicating the compilation of the view, and if the part of query on view found in the system table, fetch a shared object file storing at least one compilation function associated with the part of query on view, use the compilation function as a part of a query execution plan, and execute the query execution plan to display the result.
Claims20
A data processing method for directing a data processing system to process a query against data objects, comprising:
- receiving a view creation query comprising a query definition;
- creating a view based on the view creation query received;
- compiling the query definition to form a structure containing schema of the view and associated elements;
- generating at least one compilation function, wherein the compilation function comprises access methods to access the associated elements based on projections needed by the view;
- changing a status associated with the view in a pre-stored system table;
- and
- storing the schema of the view and the compilation function into a shared object file.
A data processing method for directing a data processing system to process a query against data objects, comprising:
- receiving a query comprising a part of query on view;
- checking in system table based on the part of query on view, wherein the system table comprises a status associated with the view indicating the compilation of the view;
- fetching a shared object file storing at least one compilation function associated with the part of query on view when the status indicates that the view is compiled;
- using the compilation function as a part of a query execution plan;
- and
- executing the query execution plan to display the result.
A data processing system for processing a query against data objects, comprising:
- a processor configured to:
- receive a view creation query comprising a query definition;
- create a view based on the view creation query received;
- compile the query definition to form a structure containing schema of the view and associated elements;
- generate at least one compilation function, wherein the compilation function comprises access methods to access the associated elements based on the projections needed by the view;
- change a status associated with the view in a pre-stored system table, wherein the status is a value indicating the view is compiled or not compiled;
- and
- store the schema of the view and the compilation function into a shared object file.
A data processing system for processing a query against data objects, comprising:
- a processor coupled to a memory and configured to store a plurality of instructions for directing the processor to:
- receive a query comprising a part of query on view;
- check in a system table based on the part of query on view, wherein the system table comprises a status associated with the view indicating the compilation of the view;
- fetch a shared object file storing at least one compilation function associated with the part of query on view when the status indicates that the view is compiled;
- use the compilation function as a part of a query execution plan;
- and
- execute the query execution plan to display the result.
Dependencies are inferred from the claim text.