Transactions and Concurrency. Edel Sherratt. Overview. What is a Transaction Transaction Integrity Transactions and SQL Concurrency Control. What is a transaction. A useful piece of work For example: record customer order record a lodgement to a bank account record a withdrawal
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Transactions and Concurrency
For example, a business to business customer order
… other code, part of the application program …
SQL – the next statements are SQL
SET name = ‘Jones’ WHERE card_no =‘C12’
… other code …
if (some condition)
then SQL COMMIT
else SQL ROLLBACK
What if the steps of these transactions were interleaved so that their execution order were ADBCEF?