Query processing
AssigneeEntit Software LLC
InventorsCharles Edward Bear, Sreenath Bodagala, Matthew Steven Fuller, Andrew Allinson Lamb
Life of this patent
Estimating the term…
Abstract
A method for query processing includes receiving a query, and determining a query type by determining if the query is a structured query language (SQL) query including multiple distinct aggregates (MDAs), or a SQL query including cube, rollup or grouping sets operations. Based on the determination, the method includes processing the query to generate an output, and performing a predetermined number of maximum group by operations on the output based on the query type to generate a response to the query.
Claims15
A method for query processing, the method comprising:
- receiving a query;
- determining a query type by determining if the query is a structured query language (SQL) query including multiple distinct aggregates (MDAs), or a SQL query including cube, rollup or grouping sets operations;
- based on the determination, processing the query to generate an output;
- and
- performing, by a processor, a predetermined number of maximum group by operations on the output based on the query type to generate a response to the query.
The method of claim I, further comprising:
- if the query type is a SQL query including the grouping sets operation, generating n groupings, where n is a number of grouping sets in the grouping sets operation.
A query processing apparatus comprising:
- a memory storing a module comprising machine readable instructions to:
- receive a query;
- determine a query type by determining if the query is a structured query language (SQL) query including multiple distinct aggregates (MDAs), or a SQL query including cube, rollup or grouping sets operations;
- based on the determination, process the query to generate an output;
- and
- perform a single or two successive group by operations on the output based on the query type to generate a response to the query;
- and
- a processor to implement the module.
A non-transitory computer readable medium having stored thereon machine readable instructions for query processing, the machine readable instructions when executed cause a computer system to:
- receive a query;
- determine a query type by determining if the query is a structured query language (SQL) query including multiple distinct aggregates (MDAs), or a SQL query including cube, rollup or grouping sets operations;
- based on the determination, process the query to generate an output;
- and
- perform, by a processor, two successive group by operation on the output if the query type is the SQL query including MDAs, or one group by operation on the output if the query type is the SQL query including the cube, rollup or grouping sets operations to generate a response to the query.
Dependencies are inferred from the claim text.