Automated and dynamic management of query views for database workloads
US7716214B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 26, 2008 |
| Grant date | May 11, 2010 |
| Priority date | — |
| Expiry date | May 23, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2454
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The embodiments of the invention provide a method, program storage device, etc. for automated and dynamic management of query views for database workloads. More specifically, a method begins by executing queries, which includes accessing a set of data tables for each of the queries. During the executing of the queries, the method accesses a required data table from a cache if the required data table is present in the cache and creates the required data table if the required data table is not present in the cache. The accessing of the required data table from the cache has a lower processing cost than accessing the required data table from a base table. Also during the executing of the queries, created data tables are stored in the cache, wherein one or more of the created data tables are removed from the cache when the cache becomes full.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.