Using a table to track whether a dynamic partitioning condition evaluates to true
AssigneeTeradota US, Inc.
InventorsAmbuj Shatdal, B. Anantha Subramanian, Ahmad Said Ghazal
Life of this patent
Estimating the term…
Abstract
A query to perform an ordered analytic function 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, dynamic partitions are identified based on evaluating the partitioning condition. To identify the dynamic partitions, a first table is created that contains a first column to track rows of an input table for indicating whether the partitioning condition evaluates to true. The first column of the first table is used to identify the dynamic partitions.
Claims24
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, and wherein the clause contains a partitioning condition to specify the dynamic partitions, where the clause is of a type different from a PARTITION BY clause;
- and
- during processing of the query, identifying, by the computer system, the dynamic partitions based on evaluating the partitioning condition, wherein identifying the dynamic partitions comprises:
- creating a first table containing a first column to track rows of an input table for indicating whether the partitioning condition evaluates to true;
- and
- using the first column of the first table to identify the dynamic partitions.
A database system comprising:
- storage media to store a first relational table and a first derived table;
- a processor configured to:
- receive a query to perform an ordered analytic function with respect to at least the first relational table, wherein the query contains a clause specifying creation of dynamic partitions, and wherein the clause contains a partitioning condition to specify the dynamic partitions, where the clause is of a type different from a PARTITION BY clause;
- use one or more columns contained in the first derived table to track rows of the first relational table for indicating whether the partitioning condition evaluates to true;
- and
- identify the dynamic partitions using the one or more columns of the first derived table.
An article comprising at least one non-transitory computer-readable storage medium containing instructions that upon execution by a processor causes a database system 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, where the clause is of a type different from a PARTITION BY clause:
- and
- during processing of the query, identify the dynamic partitions based on evaluating the partitioning condition, wherein identifying the dynamic partitions comprises:
- creating a first table containing a first column to track rows of an input table for indicating whether the partitioning condition evaluates to true;
- and
- using the first column of the first table to identify the dynamic partitions.
Dependencies are inferred from the claim text.