Back to results
US 8,046,394 B1Granted
Dynamic partitioning for an ordered analytic function
AssigneeTeradata US, Inc.
InventorAmbuj Shatdal
Life of this patent
Estimating the term…
Abstract
In a database system, a query to perforin an ordered analytic function is received. The query contains a clause specifying creation of dynamic partitions, where the clause contains a partitioning condition to specify the dynamic partitions. During processing of the query, the dynamic partitions are identified based on evaluating the partitioning condition.
Claims19
A method executed by a computer system, comprising:
- receiving a query to perform an ordered analytic function, wherein the query contains a clause specifying creation of dynamic partitions, wherein the clause contains a partitioning condition to specify the dynamic partitions, and wherein receiving the query comprises receiving a Structured Query Language (SQL) query;
- and
- during processing of the query, identifying the dynamic partitions based on evaluating the partitioning condition, wherein processing the query comprises:
- redistributing input data across plural access modules;
- after redistributing, performing at each of the plural access modules:
- sorting the input data according to at least one attribute specified in a clause in the query that specifies ordering of the input data;
- and
- identifying the dynamic partitions in the sorted input data.
5 more elements
An article comprising at least one computer-readable storage medium containing instructions that when executed cause a database system having a processor to:
- receive a query to perform an ordered analytic function, wherein the query contains a clause specifying creation of dynamic partitions, and wherein the clause contains a partitioning condition to specify the dynamic partitions;
- and
- during processing of the query, identify the dynamic partitions based on evaluating the partitioning condition, wherein processing the query comprises:
- redistributing input data across plural access modules;
- after redistributing, performing at each of the plural access modules:
- sorting the input data according to at least one attribute specified in a clause in the query that specifies ordering of the input data;
- and
- identifying the dynamic partitions in the sorted input data.
5 more elements
A database system comprising:
- a processor;
- and
- database software executable on the processor to:
- receive a Structured Query Language (SQL) query to perform an ordered analytic function, wherein the query contains a clause specifying creation of dynamic partitions, and wherein the clause contains a partitioning condition to specify the dynamic partitions;
- and
- during processing of the query, identify the dynamic partitions based on evaluating the partitioning condition, wherein processing the query comprises:
- redistributing input data across plural access modules;
- after redistributing, performing at each of the plural access modules:
- sorting the input data according to at least one attribute specified in a clause in the query that specifies ordering of the input data;
- and
- identifying the dynamic partitions in the sorted input data.
8 more elements
A database system comprising:
- a processor;
- and
- database software executable on the processor to:
- receive a query to perform an ordered analytic function, wherein the query contains a clause specifying creation of dynamic partitions, and wherein the clause contains a partitioning condition to specify the dynamic partitions;
- and
- during processing of the query, identify the dynamic partitions based on evaluating the partitioning condition, wherein processing the query comprises:
- redistributing input data across plural access modules;
- after redistributing, performing at each of the plural access modules:
- sorting the input data according to at least one attribute specified in a clause in the query that specifies ordering of the input data;
- and identifying the dynamic partitions in the sorted input data.
7 more elements
Dependencies are inferred from the claim text.