Explain the timestamps for read operations, Database Management System

Timestamps For Read operations:

If TS (T) < W-timestamp (Q), then the transaction T is trying to read a value of data item Q which has already been overwritten by some other transaction. As the value which T wanted to read from Q does not be there anymore, and T would be rolled back.

If TS (T) >= W-timestamp (Q), then the transaction T is trying to read a value of data item Q which has been written and committed by some other transaction earlier. As T will be allowed to read the value of Q, and the R-timestamp of Q should be updated to TS (T).

 

Posted Date: 7/26/2013 7:19:31 AM | Location : United States







Related Discussions:- Explain the timestamps for read operations, Assignment Help, Ask Question on Explain the timestamps for read operations, Get Answer, Expert's Help, Explain the timestamps for read operations Discussions

Write discussion on Explain the timestamps for read operations
Your posts are moderated
Related Questions
Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai

Hot Backup: Some sites cannot terminate the database while creating a backup copy of the files. The cold backup is not a reliable option. So different kinds of backing up database

What is known as a search key? An attribute or set of attributes used to look up records in a file is known as a search key.

explain concept of decomposition?

What is E-R model? This data model is based on real world that having of basic objects called entities and of relationship between these objects. Entities are explained in a da

Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is

What are the ways of obtaining the connection parameters?  Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters

With the help of a diagram defines the typical element modules of a DBMS? The functional elements of a database system can be widely divided into: 1) Storage manager and 2) q

Discuss the types of integrity constraints in which must be checked for the update operations - Insert and Delete. Give examples. Insert operation can violet any of the subse

What type of view of total database content? Data base content Conceptual view of total database contain.