Automatic and dynamic design of cache groups
US8812492B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Dec 20, 2011 |
| Grant date | Aug 19, 2014 |
| Priority date | — |
| Expiry date | Dec 31, 2032 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24552
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method is provided for automatic and dynamic adaptation of cache groups in a database system having one or more processors. The method includes analyzing a database query and determining if a set of predicates in a predicate pattern are suitable for inclusion in one or more cache groups, with the one or more cache groups having one or more cache tables; mapping value-based predicates in the predicate pattern to a filling column in the one or more cache tables; and mapping equi-join predicates in the predicate pattern to a referential cache constraint in the one or more cache tables. New cache groups can be created for predicate patterns occurring more frequently and existing cache groups can be deleted if the frequency of the predicate pattern falls below a predetermined threshold value.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.