Atomicity-transaction , Database Management System

Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1 & 2 please note that transaction two is reading and writing more than one data items, the atomicity property needs either operations on both the data item be done or not at all.

 

 

Posted Date: 3/11/2013 5:20:12 AM | Location : United States







Related Discussions:- Atomicity-transaction , Assignment Help, Ask Question on Atomicity-transaction , Get Answer, Expert's Help, Atomicity-transaction Discussions

Write discussion on Atomicity-transaction
Your posts are moderated
Related Questions
Representing complex relationship among data A database may contain varieties of data interrelated to each other in numerous ways. A DBMS must have the capability to represent

Describe the definition of a transaction in SQL  Ans: The SQL transaction starts implicitly. Transactions are finished by either Commit work that commits the transaction and st

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


Most computer systems authenticate users by asking them for the user name and password. However, the user names and passwords often can be guessed by hackers. Suggest an automated,

What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

Problem 1. Write the SQL queries using Data Manipulation Language (DML) statements. Insert values into student table with field names using insert command Display the

What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be

Write short notes on relational model   The  relational  model  uses a  collection of  tables  to show  both data  and the relationships between those  data.  The relational mo

Consider the table student and list names of students in the departments other than maths and computer. SELECT std_name FRM student WHERE dept_name NOT IN (‘Maths','Computer);