1 Replies - 511 Views - Last Post: 11 May 2017 - 06:52 AM Rate Topic: -----

#1 kyle01  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 197
  • Joined: 26-November 14

Help with a transaction possible conflict

Posted 11 May 2017 - 06:16 AM

Hi, first of all, this is NOT HOMEWORK. I have a exam coming up and I'm revising but I've come across a question which I have answered but not 100% sure on whether it is right, the problem I am having is that there is no commit in the transaction so I'm not sure whether there is any Lost Update problem or conflict.

Question(image): [url]https://ibb.co/j5xUD5[/url]

My answer: "The above is invalid as it's a lost update problem. There is a conflict of writing to item(Z), this can be avoided by not allowing t1 to read item(Z) until after the t5 write."

Have i fully answered the question and/or is there anything wrong with the answer? - does it need more detail etc?


Thanks.

Is This A Good Question/Topic? 0
  • +

Replies To: Help with a transaction possible conflict

#2 Dormilich  Icon User is offline

  • 痛覚残留
  • member icon

Reputation: 4135
  • View blog
  • Posts: 13,056
  • Joined: 08-June 10

Re: Help with a transaction possible conflict

Posted 11 May 2017 - 06:52 AM

Quote

Have i fully answered the question and/or is there anything wrong with the answer?

I don't think the missing commit is the problem here as you are asked if the two transactions are valid (and in my understanding you can only commit a valid transaction) with their schedule as given.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1