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 105 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
Wow, this really help

ryhom

  • Member
  • Posts: 366
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

More than 4.4billion prescriptions were dispensed within the United States in 2016.

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Forensic anthropologists working at a temporary morgue following the recovery of remains from a floo Forensic anthropologists working at a temporary morgue following the recovery of remains from a floo
Blocked at every turn by congressional Republicans who hated him, President Obama turned to techniqu Blocked at every turn by congressional Republicans who hated him, President Obama turned to techniqu
Techniques for applying local anesthesia: (a) topical; (b) nerve block; (c) infiltration; (d) ... Techniques for applying local anesthesia: (a) topical; (b) nerve block; (c) infiltration; (d) ...
Apply compression and light effleurage techniques to the foot and ankle to warm the area. Apply compression and light effleurage techniques to the foot and ankle to warm the area.
Two techniques for holding and inserting an otoscope Two techniques for holding and inserting an otoscope
Two techniques for holding and inserting an otoscope Two techniques for holding and inserting an otoscope
Video: Regulation of GFR: autoregulation via myogenic mechanism Myogenic mechanism

For a complete list of videos, visit our video library