This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Distinguish between reprocessing and rollforward as database recovery techniques. What will be an ... (Read 121 times)

09madisonrousseau09

  • Hero Member
  • *****
  • Posts: 559
on: Jul 7, 2018
Distinguish between reprocessing and rollforward as database recovery techniques.
 
  What will be an ideal response?

Question 2

Distinguish between a data model and a database design.
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

strudel15

  • Sr. Member
  • ****
  • Posts: 324
Reply #1 on: Jul 7, 2018
Answer to Question 1

Reprocessing and rollforward both require the use of database saves, which are backups of the database at a known state. Reprocessing as a means of recovery involves recovering the database from the last database save and having the application programs reprocess all the transactions since the save. Rollforward as a means of recovery involves recovering the database from the last save and then reapplying all changes to the database. Reprocessing does not always reproduce the original database contents correctly since minute changes in processing by the application programs may result in changes in data manipulation.

Answer to Question 2

The data model is a representation of the content, relationships, and constraints of the data needed to support the users' requirements for the system. The data model is a logical representation of business requirements. The database design is created from the data model to include tables, relationships, constraints, data types, column properties, and descriptions of primary and foreign keys. The database design is a component design of how database technology can accomplish the support of the system requirements depicted in the data model.


09madisonrousseau09

  • Member
  • Posts: 559
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)

recede

  • Member
  • Posts: 315
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.

Did you know?

The eye muscles are the most active muscles in the whole body. The external muscles that move the eyes are the strongest muscles in the human body for the job they have to do. They are 100 times more powerful than they need to be.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Heap Leach Operations for the Recovery of Gold Heap Leach Operations for the Recovery of Gold
Finishing techniques for the back of the body. With the recipient fully draped, gently rock the body ... Finishing techniques for the back of the body. With the recipient fully draped, gently rock the body ...
Conventions and Techniques of Egyptian Pictorial Relief Conventions and Techniques of Egyptian Pictorial Relief
Ecological Recovery at Mount St. Helens Ecological Recovery at Mount St. Helens
Secondary Recovery of Oil Secondary Recovery of Oil
Two techniques for holding and inserting an otoscope Two techniques for holding and inserting an otoscope
Video: Properties of water -structure of water and polarity (Ionized and polar compounds)

For a complete list of videos, visit our video library