Fast refresh of snapshots containing subqueries
US6289335A · kind A · utility
73Cited by
5References
33Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jun 23, 1997 |
| Grant date | Sep 11, 2001 |
| Priority date | — |
| Expiry date | Jun 23, 2017 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99943
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and apparatus for fast refreshing a subquery snapshot creates the snapshot based on a first table and a second table according to a snapshot definition query, which contains one or more subqueries. Information about modifications to the first and second tables is stored in first and second log, respectively. When a refresh operation is initiated, the snapshot is refreshed by reconciling differences between the snapshot, the first table and second table according to the snapshot definition query, the first log, the second log, the first table, and the second table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.