Method, system and program for enabling non-self actuated database transactions to lock onto a database component

Abstract

Disclosed are a data processing system implemented method, an article of manufacture and a data processing system for enabling a non-self actuated database transaction to lock onto a database component. The method includes identifying a self actuated transaction currently locking onto the database component, forcing the identified self actuated database transaction to release their lock on the database component if a lock mode between the non-self actuated database transaction and the identified self actuated database transaction is non-compatible, and permitting the non-self actuated database transaction to lock onto the database component if the lock modes between the non-self actuated database transaction and any database transactions currently locking onto the database component are compatible.

1 . A data processing system implemented method of enabling a non-self actuated database transaction to lock onto a database component, the method comprising: 
 identifying a self actuated transaction currently locking onto the database component;    forcing the identified self actuated database transaction to release its lock on the database component if a lock mode between the non-self actuated database transaction and the identified self actuated database transaction is non-compatible; and    permitting the non-self actuated database transaction to lock onto the database component if the lock modes between the non-self actuated database transaction and any database transactions currently locking onto the database component are compatible.    
   
   
       2 . The data processing system implemented method of  claim 1  further comprising: 
 associating a transaction type identifier identifying whether at least one of the self actuated transaction is a self actuated transaction type and the non-self actuated transaction is a non-self actuated transaction type.    
   
   
       3 . The data processing system implemented method of  claim 1  further comprising: 
 permitting the non-self actuated database transaction to lock onto the database component before other currently lock-waiting self actuated database transactions are permitted to lock onto the database component.    
   
   
       4 . The data processing system implemented method of  claim 1  further comprising: 
 associating a lock-granted indicator with the database transaction component if a non-self actuated database transaction has been allowed to lock onto the database component, the lock-granted indicator indicating that the database component is currently being locked onto by the self-actuated database transaction;    wherein the identifying the self actuated transaction currently locking onto the database component is based on a status of the lock granted indicator.    
   
   
       5 . The data processing system implemented method of  claim 1  further comprising: 
 associating a lock-waiting indicator with the database component if a non-self actuated database transaction has been denied locking onto the database component, the lock-waiting indicator indicating that the database component is waiting to be locked on by the self-actuated transaction; and    determining if the self actuated database transaction is currently waiting to lock onto the database component based on the lock-waiting indicator.    
   
   
       6 . The data processing system implemented method of  claim 1  further comprising: 
 associating a database transaction type indicator with a database transaction, the database transaction indicator indicating whether the database transaction is one of a self actuated transaction type and a non-self actuated transaction type; and    determining the transaction type of a given transaction based on the database transaction type indicator.    
   
   
       7 . A data processing system of enabling a non-self actuated database transaction to lock onto a database component, the data processing system comprising: 
 an identification module for identifying a self actuated transaction currently locking onto the database component;    a forcing module for forcing the identified self actuated database transaction to release its lock on the database component if a lock mode between the non-self actuated database transaction and the identified self actuated database transaction is non-compatible; and    a permitting module for permitting the non-self actuated database transaction to lock onto the database component if the lock modes between the non-self actuated database transaction and any database transactions currently locking onto the database component are compatible.    
   
   
       8 . The data processing system of  claim 7  further comprising: 
 an associating module for associating a transaction type identifier identifying whether at least one of the self actuated transaction is a self actuated transaction type and the non-self actuated transaction is a non-self actuated transaction type.    
   
   
       9 . The data processing system of  claim 7  further comprising: 
 a permission module for permitting the non-self actuated database transaction to lock onto the database component before other currently lock-waiting self actuated database transactions are permitted to lock onto the database component.    
   
   
       10 . The data processing system of  claim 7  further comprising: 
 an association module for associating a lock-granted indicator with the database transaction component if a non-self actuated database transaction has been allowed to lock onto the database component, the lock-granted indicator indicating that the database component is currently being locked onto by the self-actuated database transaction;    wherein the identification module for identifying the self actuated transaction currently locking onto the database component is based on a status of the lock granted indicator.    
   
   
       11 . The data processing system of  claim 7  further comprising: 
 an associating module for associating a lock-waiting indicator with the database component if a non-self actuated database transaction has been denied locking onto the database component, the lock-waiting indicator indicating that the database component is waiting to be locked on by the self-actuated transaction; and    a determining module for determining if the self actuated database transaction is currently waiting to lock onto the database component based on the lock-waiting indicator.    
   
   
       12 . The data processing system of  claim 7  further comprising: 
 an association module for associating a database transaction type indicator with a database transaction, the database transaction indicator indicating whether the database transaction is one of a self actuated transaction type and a non-self actuated transaction type; and    a determination module for determining the transaction type of a given transaction based on the database transaction type indicator.    
   
   
       13 . An article of manufacture for directing a data processing system to enable a non-self actuated database transaction to lock onto a database component, the article of manufacture comprising: 
 a program usable medium embodying one or more instructions executable by the data processing system, the one or more instructions comprising: 
 instructions for identifying a self actuated transaction currently locking onto the database component;  
 instructions for forcing the identified self actuated database transaction to release their lock on the database component if a lock mode between the non-self actuated database transaction and the identified self actuated database transaction is non-compatible; and  
 instructions for permitting the non-self actuated database transaction to lock onto the database component if the lock modes between the non-self actuated database transaction and any database transactions currently locking onto the database component are compatible.  
   
   
   
       14 . The article of manufacture of  claim 13  further comprising: 
 instructions for associating a transaction type identifier identifying whether at least one of the self actuated transaction is a self actuated transaction type and the non-self actuated transaction is a non-self actuated transaction type.    
   
   
       15 . The article of manufacture of  claim 13  further comprising: 
 instructions for permitting the non-self actuated database transaction to lock onto the database component before other currently lock-waiting self actuated database transactions are permitted to lock onto the database component.    
   
   
       16 . The article of manufacture of  claim 13  further comprising: 
 instructions for associating a lock-granted indicator with the database transaction component if a non-self actuated database transaction has been allowed to lock onto the database component, the lock-granted indicator indicating that the database component is currently being locked onto by the self-actuated database transaction;    wherein the instructions for identifying the self actuated transaction currently locking onto the database component is based on a status of the lock granted indicator.    
   
   
       17 . The article of manufacture of  claim 13  further comprising: 
 instructions for associating a lock-waiting indicator with the database component if a non-self actuated database transaction has been denied locking onto the database component, the lock-waiting indicator indicating that the database component is waiting to be locked on by the self-actuated transaction; and    instructions for determining if the self actuated database transaction is currently waiting to lock onto the database component based on the lock-waiting indicator.    
   
   
       18 . The article of manufacture of  claim 13  further comprising: 
 instructions for associating a database transaction type indicator with a database transaction, the database transaction indicator indicating whether the database transaction is one of a self actuated transaction type and a non-self actuated transaction type; and    instructions for determining the transaction type of a given transaction based on the database transaction type indicator.