Query execution using materialized tables
US12189616B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 17, 2023 |
| Grant date | Jan 7, 2025 |
| Priority date | — |
| Expiry date | Jul 17, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24539
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method includes retrieving a plurality of materialized tables (MTs). Each of the plurality of MTs includes a lag duration and refers to a corresponding base table of a plurality of base tables. The lag duration indicates a maximum time period that a result of a prior refresh of a query on the corresponding base table can lag behind a current time instance. A plurality of time instances for the MT is determined based on the lag duration and a number of prior refreshes of the corresponding base table. A plurality of aligned time instances for the plurality of MTs is determined based on the plurality of time instances for each of the plurality of MTs. Refresh operations are scheduled for the plurality of MTs at one or more of the plurality of aligned time instances that are within the maximum time period.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.