Multiple aggregates in a single user-defined function
US10282449B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 26, 2015 |
| Grant date | May 7, 2019 |
| Priority date | — |
| Expiry date | Sep 28, 2036 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2457
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A data store system may include a persistent storage device that may store a plurality of data tables. The data store system may further include a processor array in communication with the persistent storage device. The processor array may receive a query comprising a call to a user-defined function (UDF) that may determine a plurality of aggregates for at least one data table from the plurality of data tables. The processor array may determine a number of the plurality of aggregates in the UDF. The processor array may perform a single read of rows associated with the plurality aggregates from the at least one data table. At least one row of the rows may be commonly associated with more than one of the plurality of aggregates. The processor array may generate each aggregate of the plurality of aggregates using the rows according to the UDF. A method and computer-readable medium may also be implemented.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.