Strayer University Computer Science Database Discussion
Description
Having Trouble Meeting Your Deadline?
Get your assignment on Strayer University Computer Science Database Discussion completed on time. avoid delay and – ORDER NOW
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.
Please respond to student’s comment below:
A commit and rollback scenario become necessary when you are looking to make permanent changes to a database that can only be reversed through rollback or through processing another transaction in reverse. An example of needing the commit in a business case is when you are looking to make a delete post with cascading impacts. You want to ensure the tables are confirmed. An example of a rollback would be if the transaction was mid stream and the system was disconnected. This failure would cause the transaction to be aborted and returned the the previously state without changes from the transaction.
These transactions are important for a system to allow concurrency controls where multiple users are able to access read and write activity to a table. Without them, the database would need to lock out multiple users from accessing it, which could slow down availability to users or cause transactions to fail due to deadlocking.
Without the ability to rollback, the company would need to apply partial reversal transactions, or upload backups more frequently. This would also mean that they would need to recreate the activity that was intended since the last update was stored. That would likely mean a lot of downtime and coordination to get databases back online. Similarly, if data was corrupted, having the ability to rollback the transaction would prevent the need to go back to the tapes and upload stored backups.
