System and method for selective partition locking
US7480653B2 · kind B2 · utility
3Cited by
21References
24Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Apr 2, 2004 |
| Grant date | Jan 20, 2009 |
| Priority date | — |
| Expiry date | Mar 14, 2025 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99938
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for controlling concurrency of access to data in a database system, includes: partitioning a table in the database system into a plurality of partitions; receiving a request for access to data; determining a partition of the plurality of partitions that contains the data; determining if the data has been committed; and if so, avoiding locking the partition in response to the request. By avoiding locking the partition when the data has been committed, the number of partition locks that need to be requested from a local resource lock manager is reduced, improving performance.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.