Issues on concurrency controls in transactional database system: The automatic teller machine (ATM) problem. – F. U. Ogban and P. Asagba
Concurrency control issues like the “isle-of-March” has come but not gone. It is not surprising that several models designed to handle concurrency control in databases; there still exist some overheads in transactional database controls. One of such problems is the incompletion of the execution of necessary codes within the critical region of a lock transaction implementation thus generating data integrity fault (–such as dirty read, non-repeated read and phantom read) and inconsistent data (- such as non-submitted data, late submitted data etc). In this work, the locks paradigms were reappraised to suit situations of usage and recommend particular areas of application of the different locking strategies so designed. New construct of control issues were recreated vis-à-vis the application situation found on ground like the Automatic Teller Machine problem.