Approximate query execution system that bounds query execution based on runtime conditions
US12393591B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 16, 2024 |
| Grant date | Aug 19, 2025 |
| Priority date | — |
| Expiry date | Apr 16, 2044 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/287
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Systems and methods are disclosed to implement a bounded group by query system that computes approximate time-sliced statistics for groups of records in a dataset according to a group by query. In embodiments, a single pass scan of the dataset is performed to accumulate exact results for a maximum number of groups in a result grouping structure (RGS) and approximate results for additional groups in an approximate result grouping structure (ARGS). RGSs and ARGSs are accumulated by a set of accumulator nodes and provided to an aggregator node, which combines the received structures to generate exact or approximate statistical results for at least a subset of the groups in the dataset. Advantageously, the disclosed query system is able to produce approximate results for at least some of the groups in a single pass of the dataset using size-bounded data structures, without predetermining the actual number of groups in the dataset.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.