Driving massive scale out through rewrites of analytical functions
US11455303B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 19, 2019 |
| Grant date | Sep 27, 2022 |
| Priority date | — |
| Expiry date | Jun 12, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2456
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
According to an embodiment, a method includes rewriting a particular query to generate a rewritten query. The particular query specifies a window function operator, a particular input to the window function operator, and an analytical function. Rewriting the particular query includes assigning the particular input to an intermediate relation and replacing the window function operator with a replacement operator. The method further includes assigning to the replacement operator an aggregate function corresponding to the analytical function, and the intermediate relation. In this embodiment, the method also includes placing a join operator that joins the intermediate relation with an output of the replacement operator.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.