IMPORTANCE OF DATABASE RECOVERY

Requirement

IMPORTANCE OF DATABASE RECOVERY IN DATABASE ADMINISTRATION

Solution

Abstract 

The following paper will illuminate some light on the importance of the option of database recovery in data administration. Database recovery restores the database in to the previous consistent state from a given state whereas the process of transaction recovery helps in ensuring that the transaction logs have been written before the data gets updated. The paper would deal with these two features in detail.

Many students fail to complete database management assignments even after putting in a lot of effort. If you are one of those students who is dealing with the same problems, you have come to the right place. All of your academic writing concerns can be addressed at allassignmenthelp.com. We can provide you with the best affordable assignment help.

Importance of database recovery in database administration

Database recovery is a process for restoring data to previous stable state and it is based on the atomic transaction property. According to this property, each and every proportion of transaction is considered as a single unit of work i.e. single logical unit.  In order to produce, consistent databases all the operations are applied and completed (On the importance of data backup & recovery, N.D.).
It is easy to say that everything is running smoothly when some new database is created and is used but then within a certain period of time with the inclusion of newer users, services and data it becomes hard to handle the database and deliver services. Hence, DBA must be totally prepared for such scenarios.
Database management need to feel the importance of recovery because it does not matter how fast the data can be accessed because if data cannot be recovered then it does not matter how fast or slow is the process of extraction.
In today’s world, storing data as terabyte and gigabyte has become a common phenomenon and companies tend to store more than a terabyte on one single server hence it becomes highly important to have an option of recovery and sound backup as an insurance policy for the data
The process of transaction recovery
It is one of the most used techniques for data recovery in a DBMS. It is often referred as transaction log or journal. It consists of logs which keeps a record of all the information of the progress of transactions from the time since last consistent state. Hence, the database management knows the exact state of the database after and before each and every transaction. Whenever the database returns to a consistent state, the log truncates in order to remove all the omitted transactions. The point at which the database reaches a consistent state is referred as “check pointing” (recovery, N.D.).
The process of transaction recovery includes:-
If transaction is done before the checkpoint: nothing is done
If the transaction is done after the checkpoint: then the transaction log is used for redoing the transaction
If ROLLBACK option is available then: nothing is done

Place Order For A Top Grade Assignment Now

We have some amazing discount offers running for the students

Place Your Order

References 

  • On the importance of database backup and recovery (no date) Available at: https://googleweblight.com/?lite_url=https://datatechnologytoday.wordpress.com/2014/08/04/on-the-importance-of-database-backup-recovery/&ei=SYT-J-ZF&lc=en-IN&s=1&m=32&ts=1450156078&sig=ALL1Aj7OIzk2otwd6F84oxnjZRdZpMcH6Q (Accessed: 15 December 2015)

  • Recovery (no date) Available at: http://db.grussell.org/section015.html (Accessed: 15 December 2015)

Get Quality Assignment Without Paying Upfront

Hire World's #1 Assignment Help Company

Place Your Order