Using a table to track whether a dynamic partitioning condition evaluates to true
US8943040B1 · kind B1 · utility
3Cited by
4References
24Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Mar 25, 2010 |
| Grant date | Jan 27, 2015 |
| Priority date | — |
| Expiry date | Dec 10, 2032 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/968
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.