Discussion and student respones below

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

SQL Commit And Rollback | DigitalOcean