Locking data in a database after an operation has begun
AssigneeTeradata US, Inc.
InventorsPaul L. Sinclair, Albert Maghbouleb
Life of this patent
Estimating the term…
Abstract
A database management system receives a request to perform an operation on a set of target data and, at some point after it begins executing that operation, places a lock on the target data to prevent concurrent execution of other operations on the target data. In some embodiments, the system receives an instruction from a user to perform a data-definition operation on a set of target data; places an initial lock on the target data at a level that allows at least one concurrent operation on the target data; begins executing the operation; and then places a final lock on the target data at a level that excludes all other concurrent operations on the target data.
Claims25
A method for use in managing data in a database system, comprising:
- receiving a request to perform an operation on a set of target data residing in the database;
- executing the operation in the database on the set of target data;
- during the execution of the operation, placing an initial lock on the target data to prevent concurrent execution of at least one operation on the target data;
- and
- during the executing of the operation, placing a final lock on the target data at a level that prevents concurrent execution of a larger set of operations.
A database system comprising:
- at least one storage device;
- at least one computing node configured to deliver data to and retrieve data from the storage device;
- and
- a database-management component configured to:
- receive a request to perform an operation on a set of target data residing in the database;
- execute the operation in the database on the set of target data;
- during the execution of the operation, place an initial lock on the target data to prevent concurrent execution of at least one but not all operations on the target data;
- and
- during the executing of the operation, place a final lock on the target data at a level that prevents concurrent execution of a larger set of operations.
A computer program, stored on at least one computer-readable storage medium, for use in managing data in a database system, comprising executable instructions that, when executed by a computer, cause the computer to:
- receive a request to perform an operation on a set of target data residing in the database;
- execute the operation in the database on the set of target data;
- during the executing of the operation, place an initial lock on the target data to prevent concurrent execution of at least one but not all operations on the target data;
- and
- during the executing of the operation, place a final lock on the target data at a level that prevents concurrent execution of a larger set of operations.
A method for use in managing data in a database system, comprising:
- receiving an instruction from a user to perform a data-definition operation on a set of target data residing in the database;
- placing an initial lock on the target data at a level that allows at least one concurrent operation on the target data;
- executing the operation in the database on the set of target data;
- during the execution of the operation, placing an initial lock on the target data to prevent concurrent execution of at least one but not all operations on the target data;
- and
- during the execution of the operation, placing a final lock on the target data at a level that excludes all other concurrent operations on the target data.
A method for use in managing data in a database system, comprising:
- receiving an instruction from a user to perform a data-definition operation on a set of target data;
- placing an initial lock on the target data at a level that prevents at least one but not all types of concurrent operation on the target data;
- initiating execution of the operation on the target data;
- and
- during the execution of the operation, placing a final lock on the target data at a level that excludes all types of concurrent operations on the target data.
Dependencies are inferred from the claim text.