Materialized view maintenance and change tracking
US7930297B2 · kind B2 · utility
18Cited by
10References
31Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Dec 3, 2004 |
| Grant date | Apr 19, 2011 |
| Priority date | — |
| Expiry date | Jun 16, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2393
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A technique for refreshing materialized views in a database is disclosed. The detail table is partitioned, and changes made to the detail table are tracked with information stored, for example. Only sections in the materialized view which correspond to the partitions which include modifications made to the detail table are refreshed, thus avoiding the need of a complete refresh to overcome staleness.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.