Discuss the difference between pessimistic and optimistic concurrency control?

What will be an ideal response?


Pessimistic concurrency control protocols delay operations to ensure that conflict does not occur.
On the other hand, optimistic concurrency control protocols assume that conflicts are rare and
allow transactions to proceed without imposing any delays (instead checking that serializability
has not been broken at commit time).

Computer Science & Information Technology

You might also like to view...

Treemap charts help to visualize financial data.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Which operator is used to exclude certain records in a search?

A. AND  B. NIX C. NOT D. OR

Computer Science & Information Technology

Chris uses a packet sniffer to capture traffic from a TACACS+ server. What protocol should he monitor, and what data should he expect to be readable?

A. UDP; none—TACACS+ encrypts the full session B. TCP; none—TACACS+ encrypts the full session C. UDP; all but the username and password, which are encrypted D. TCP; all but the username and password, which are encrypted

Computer Science & Information Technology

The role that is responsible for developing overall policies and procedures for database security is:

A) Data Administration. B) Database Administration. C) Database Development. D) Accounting

Computer Science & Information Technology