Acquiring locks in wait mode in a deadlock free manner
US8041691B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 30, 2007 |
| Grant date | Oct 18, 2011 |
| Priority date | — |
| Expiry date | Jun 23, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2343
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques for a data definition language (DDL) statement acquiring a lock on a table in wait mode in a deadlock free manner are provided. A DDL statement specifies metadata of a table that is to be modified, whereas a data manipulation language (DML) statement specifies a table to be modified. When a DDL statement is received, a proxy statement is initiated and executed instead of first acquiring an exclusive lock on metadata of a particular table. The proxy statement is similar to a DML statement in that the proxy statement acquires a lock on the particular table. After the proxy statement has been processed, an exclusive lock on the metadata is acquired.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.