Calculating count distinct using vertical unions
US9305065B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 26, 2012 |
| Grant date | Apr 5, 2016 |
| Priority date | — |
| Expiry date | Jul 15, 2033 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24524
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A query statement is received that specifies a count distinct. Thereafter, a data flow graph that comprises a plurality of nodes for executing the query is generated. The nodes provide aggregation operations, sorting of results on join attributes and vertically appending columns of count distinct results with intermediate results from at least one of the aggregation operations. Thereafter, execution of the query is initiated using the data flow graph. Related apparatus, systems, techniques and articles are also described.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.