Sliding window view group constructs in relational database query language
US9460128B1 · kind B1 · utility
Assignee
Inventor
Key dates
| Filing date | May 30, 2013 |
| Grant date | Oct 4, 2016 |
| Priority date | — |
| Expiry date | Nov 19, 2034 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2445
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
This disclosure relates to populating an aggregated sliding window view group comprising one or more internal views, and each of the internal views in group has its own interval. In some implementations of this disclosure, the aggregated sliding window view group can store the history of previous view results and each row in a view inside the aggregated sliding window view group can correspond to a fixed interval of time. In various implementations, a view inside the aggregated sliding window view group can be populated from lower-level sliding window views based on a relationship between the aggregated sliding window view and the lower-level sliding window views. In some implementations, a sliding window view can store a constant number of view results. The aggregated sliding window view group can provide a user with a convenient and efficient means for displaying multiple data aggregates associated with multiple periods of time simultaneously.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.