Purchase Solution

This post addresses reprocessing and two-phase locking.

Not what you're looking for?

Ask Custom Question

Question 1.
Distinguish between reprocessing and rollforward as database recovery techniques.

Question 2.
Discuss the strategy of two-phased locking. Use examples to help explain the concept.

Purchase this Solution
Solution Summary

The solution provides a very detailed examination of the two following questions:
Question 1.
Distinguish between reprocessing and rollforward as database recovery techniques.

Question 2.
Discuss the strategy of two-phased locking. Use examples to help explain the concept.

APA references are also provided.

Solution Preview

Question 1.
Distinguish between reprocessing and rollforward as database recovery techniques.
In reprocessing, the database is recovered from backups that have been saved since the last time of regular backup by the company. This is an ideal database recovery technique because "if the system crashes, the latest database save is restored and all of the transactions are reapplied to bring the database back up to the point just before the crash" (CUNY.edu, 2012). Although there is some work involved in bringing the system current from the time of the crash to the present moment because some data will be lost after the restore, it is a very effective method for database recovery. In contrast, a roll-forward database recovery technique brings the database back to the current state pre-crash, by redoing all completed transactions and storing the completed transactions into a separate log file on a part of the database where backups are stored.

A roll-forward recovery is used when "the transaction log ...

Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

View More Free Quizzes
Related BrainMass Solutions

  • Eye Movement Desensitization and Reprocessing Phases

    Phase 4: Desensitization To appropriately assist the patient the clinician must ensure that disturbing emotions and sensations are measured in this phase on an SUD rating.

  • Multiuser database applications

    The two-phase locking has been accepted as standard solution.

  • Molecular weight and mole concept

    However, I agree that chances should not be taken until the mechanisms of these two phenomena are understood and their effects become predictable.

  • Separation Processes

    This method is employed in number of industries like battery, iron, leather etc. Solvent extraction is a method to separate compounds based on their relative solubilities in two different immiscible liquids, usually water and an organic solvent.

  • channel noise

    This process is called carrier recovery and can be implemented through various techniques. Channel noise is one of the largest impairments to carrier recovery and that significant noise can prevent carrier locking from occurring successfully.

  • Nuclear Power Considerations

    Answer gives a perspective on global use of nuclear power and issues pertaining thereto. Addresses local considerations as well. Hyperlinked refs in attachment.

  • Security of website

    Consider some of the elements from the first two Tasks of this Phase. The response addresses the queries posted in 449 words with references. //The paper addresses the concern of website security for GrandMa's Treats.

  • Multi-User Databases Management

    Explain the difference between optimistic locking and pessimistic locking. Optimistic locking assumes no transaction conflict will occur and deals with the consequences if it does.

  • Assessment of Impact of Trauma, Counseling, Personal Counseling

    Also, if the intensity of Post-Traumatic Stress Disorder (PTSD) is very strong, I will incorporate "eye movement desensitization and reprocessing" into the treatment.

View More Related Solutions