Locking partitioned database tables
US6728709B1 · kind B1 · utility
13Cited by
8References
10Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jun 22, 2001 |
| Grant date | Apr 27, 2004 |
| Priority date | — |
| Expiry date | May 9, 2022 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99942
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and apparatus for locking a database table having a plurality of partitions. In various embodiments, lock status codes are maintained for both a database table and for the partitions of the database table. The partition locks do not need to be updated when a lock is granted for the database table since a separate table lock status code is maintained. The separate table lock status code improves database application performance and simplifies programming of explicit lock operations.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.