Autonomous caching for views
US11734308B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 19, 2020 |
| Grant date | Aug 22, 2023 |
| Priority date | — |
| Expiry date | Sep 29, 2041 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/282
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques are provided for autonomous caching of hierarchical data. In one technique, query log data is stored that comprises multiple entries, each entry (a) corresponding to a different instance of a query that was executed against a database and (b) indicating a tuple (or level grouping) comprising a set of hierarchy levels corresponding to a set of dimensions. Multiple tuples indicated in the query log data are identified. For each tuple: (1) a set of entries that indicate the tuple is identified and the set of entries is associated with the tuple; (2) aggregated performance data is generated for the tuple based on performance data associated with each entry in the set of entries that is associated with the tuple; and (3) based on the aggregated performance data, it is determined whether to create a new auto-cache table or to delete an existing auto-cache table associated with the tuple.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.