Google Answers Logo
View Question
 
Q: Database 1 ( Answered 5 out of 5 stars,   0 Comments )
Question  
Subject: Database 1
Category: Computers
Asked by: eksolutions-ga
List Price: $5.00
Posted: 04 Dec 2002 14:10 PST
Expires: 03 Jan 2003 14:10 PST
Question ID: 119313
I need examples of complete schedules (all transactions must be either
committed or aborted) for all these areas:
a. Recoverable but not ACA (avoid cascading aborts).
b. ACA but not strict.
c. Recoverable but not conflict serializable.
d. View serializable but not conflict serializable.
Answer  
Subject: Re: Database 1
Answered By: maniac-ga on 04 Dec 2002 16:43 PST
Rated:5 out of 5 stars
 
Hello Eksolutions,

Perhaps the best answer to your question is the answer to #2 at
  http://www.cse.unsw.edu.au/~cs9315/ass/ass3solution.html
which clearly lists responses to
  a - #12 listed as "...it is recoverable, but not avoid cascading
aborts, not strict"
  b - #1 listed as "It is recoverable and avoid cascading aborts; not
strict"
  c - #11 listed as "It is ... not conflict-serializable; it is
recoverable..."
  d - #6 listed as "It is serializable and view-serializable, not
conflict-serializable"

The examples I listed are four of 12 problems / solutions for this
particular question with a variety of combinations of these
characteristics.

To search for further examples, a phrase like
  database conflict view serializable avoid cascading aborts
provides a number of other references. 

  --Maniac
eksolutions-ga rated this answer:5 out of 5 stars

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy