There are times when a database is accessed by many users across the enterprise. Transaction logs can help maintain concurrency in a multiuser platform.
- Describe at least two business scenarios where “commit” and “rollback” would be required.
- Describe how these functions would be essential for business continuity and concurrency control.
- Identify how these functions would enable an organization to recover from a database corruption event.
- Be sure to respond to at least one of your classmates’ posts.
Reply to student
Yesterday Jun 9 at 10:31pm
Good evening, classmates.
An effective database must be able to store data and of necessary, restore it to a previous state. The COMMIT and ROLLBACK are two statements used to store and revert data within a database. As it applies to manipulating data, the COMMIT and ROLLBACK are performed with transactions, the smallest unit of work that is performed against a database.
One business scenario which illustrates the SQL Commit and Rollback is deleting a row within a Customer table to exclude a particular location. Using the delete such as the one below would edit the table to remove the relevant information.
DELETE from Customer where State = ‘Texas’;
Using the command statement above would not finalize this action because steps have not been taken to save this action. Using the DELETE statement with an updated command with COMMIT would save this action and update the Customer table within a database.
Example of an updated DELETE statement with the COMMIT command.
If a company needed to restore or rollback data to the previous point, the ROLLBACK command would be used un conjunction with the previous command to undo this change. In this business case to undo the previous DELETE command from Customer table, the following statement would be presented.
DELETE from Customer where State = ‘Texas’;
ROLLBACK;
Using this command would revert the data to the state prior to the row being removed.
Utilizing these functions are essential components for business continuity because there is always a need to update, add and delete data within a database. Data management often requires that data be kept current and in state when even if it is removed it can be archived for retrieval at a later date. As part of Incident management, having a back up restoration plan is critical to securing data and preventing the permanent loss of vital records.
Resource
