What is a timestamp? How do timestamp-based protocols for concurrency control differ from locking based protocols?
What will be an ideal response?
Timestamp A unique identifier created by the DBMS that indicates the relative starting
time of a transaction.
The use of locks, combined with the 2PL protocol, guarantees serializability of schedules. The
order of transactions in the equivalent serial schedule is based on the order in which the
transactions lock the items they require. If a transaction needs an item that is already locked, it
may be forced to wait until the item is released.
Timestamp methods for concurrency control are quite different; no locks are involved, and
therefore there can be no deadlock. Locking methods generally prevent conflicts by making
transactions wait. With timestamp methods, there is no waiting; transactions involved in
conflict are simply rolled back and restarted.
You might also like to view...
Data cleansing is the process of validating that the data is correct and accurate
Indicate whether the statement is true or false
The ____________________ data type holds a nondecimal whole number value.
Fill in the blank(s) with the appropriate word(s).
Based upon the contents of the PUBLISHER table, which of the following is not a valid SQL statement??
A) SELECT * FROM publisher; B) SELECT name, contact FROM publisher/ C) SELECT name, phone FROM publisher/ D) SELECT * FROM publisher;
A technician is developing a shortcut sheet for the network to be able to assist in future troubleshooting scenarios. Which of the following should the network devices have to ease manageability efforts?
A. MAC spoofing B. Dynamic IPs C. MAC filtering D. Static IPs