Explain the timestamp ordering protocol, Database Management System

Timestamp Ordering Protocol

A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item had been activated in any way. We, who use computers, must all be familiar with the methods of "Date Created" or "Last Modified" properties of files and folders. Well, timestamps are things like that.

A timestamp can be executed in two ways. The simplest one is to directly assign the current value of the clock to the transaction or the data item. The other policy is to attach the value of a logical counter that keeps incrementing as new timestamps are needed.

The timestamp of a transaction shows the time when it was first activated. The timestamp of a data item can be of the following two types:

W-timestamp (Q): This means the latest time when the data item Q has been written into.

R-timestamp (Q): This means the latest time when the data item Q has been read from.

 

Posted Date: 7/26/2013 7:15:12 AM | Location : United States







Related Discussions:- Explain the timestamp ordering protocol, Assignment Help, Ask Question on Explain the timestamp ordering protocol, Get Answer, Expert's Help, Explain the timestamp ordering protocol Discussions

Write discussion on Explain the timestamp ordering protocol
Your posts are moderated
Related Questions
What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the

Discuss the methods for a hash file to expand and shrink dynamically. What are the advantages and disadvantages of each? The hashing methods that permit dyanamic file expansi

01a_Broadway_LastFirst_yyyy-mm-dd Capstone Exercises You work as a production assistant in the office of the Green Man Theatre. One of your duties is to maintain the company datab

What is bucket overflow and how bucket overflow is handled through Over Flow Chaining or Closed Hashing? Ans: Bucket: unit of storage holding records. Bucket is a disk block

The traffic data mgmt. systems infrastructure plan describes the software, hardware, data network, and other elements that will support the TDMS. The infrastructure plan is based o

Ask questApollo Hospitals (AH) is a popular medical service provider in Oman. AH wants to automate its business functions into an information system. The proposed information syst

I want a script that will run, and update my virtual machine's LAN settings (proxy server and port), and also re-configure the Firefox User Agent. I want a script that will run,

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

With the help of an example display how records can be deleted and updated in QBE. (i) Increase Pay_Rate of employees along with the skill of ‘cook' by 10%. (ii) Delete employee

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.