-2

I am newer in database design ,i want to know some features of locking protocol in dbms .

My features are:

  • Deadlock Free
  • View/conflict serializable
  • Recoverable
  • Cascadeless

And my protocols are :

  • 2pl
  • Strict 2pl
  • Graph based
  • Timestamp
  • Validation
  • Basedmulti granularity

I want to know every protocols features value(that is said before). For example for 2pl :

  • Is it deadlock Free?
  • Is itVeiw/conflict serializable?
  • Is it recoverable?
  • Is it cascadeless?
Kevin Brechbühl
  • 4,717
  • 3
  • 24
  • 47
Spadsystem.com
  • 3
  • 3

1 Answers1

0

Basically you want someone to write a book for you. I suggest you break this question down to a number of questions that someone can answer in less than 10 or 15 minutes. Also, I suggest you ask them in the Stack Exchange site devoted to Computer Science since these seem theoretical rather than linked to any implementation.

Cheers -

simon at rcl
  • 7,326
  • 1
  • 17
  • 24