System, method, and computer-readable medium for optimizing database queries which use spools during query execution
AssigneeTeradata US, Inc.
InventorsHeng Yuan, Mark Sirek
Life of this patent
Estimating the term…
Abstract
A database system comprises a processing module, and a storage device communicatively coupled with the processing module and allocated thereto. The storage device stores a base table allocated to the processing module. The processing module receives a database query from a client computer system, and generates a spool based upon a number of columns of a table, and partitions at least one column of the spool based upon the database query received from the client computer system.
Claims11
A database system comprising:
- a processing module;
- and
- a storage device communicatively coupled with the processing module and allocated thereto that stores a base table allocated to the processing module, wherein the processing module receives a database query from a client computer system, generates a spool based upon a number of columns of a table, and partitions at least one column of the spool based upon the database query received from the client computer system;
- and
- wherein the processing module estimates saving of compression based upon statistics associated with the table, and compresses certain columns when the estimated saving of compression is greater than a predetermined value.
A method of optimizing of an aggregation type of database query which uses spools in a computer system, the method comprising:
- receiving an aggregation type of database query from a client computer system;
- generating a spool based upon a number of columns of a table;
- and
- electronically by a processor, partitioning at least one column of the spool based upon the aggregation type of database query received from the client computer system;
- estimating saving of compression based upon statistics associated with the table;
- and
- compressing certain columns when the estimated saving of compression is greater than a predetermined value.
A method of optimizing of a sub-select type of database query which uses spools in a computer system, the method comprising:
- receiving a sub-select type of database query from a client computer system;
- generating a spool based upon a number of columns of a table;
- electronically by a processor, partitioning at least one column of the spool based upon the sub-select type of database query received from the client computer system;
- estimating saving of compression based upon statistics associated with the table;
- and
- compressing certain columns when the estimated saving of compression is greater than a predetermined value.
Dependencies are inferred from the claim text.