Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2010
    Posts
    1

    Locking granularity.. help please!

    Hi there,
    could someone help me with a question on locking granularity please? I am revising for an exam on database design and concurrency and am trying to answer this question: http://i43.tinypic.com/mjtnox.png
    I know that the end answer will be that table level locking granularity is required instead of tuple level granularity.. but I just can't think of an example of where the tuple level granularity won't guarantee serialisability.
    thanks for any help!
    Last edited by fadax; 04-22-10 at 14:34.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    For example, tuple-level locks won't prevent another transaction from inserting a new Accounts tuple while the first transaction computes a total for that branch.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •