Concurrency control for transactions that update base tables of a materialized view using different types of locks
US6353828B1 · kind B1 · utility
65Cited by
13References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 14, 1999 |
| Grant date | Mar 5, 2002 |
| Priority date | — |
| Expiry date | May 14, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99952
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Concurrency control for maintenance of materialized view defined as a join on a plurality of base tables is provided by obtaining different types of locks. The base table being updated is locked with one type of lock, and the other base tables of the materialized view is locked with a different type of lock. These lock types are defined so that another process attempting to update another base table simultaneously is blocked until the update on the base table is committed. On the other hand, another process attempting to update the same base table is allowed to perform that update concurrently.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.