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
Define multivalued dependency.  What do understand by trivial multivalued dependency?  Ans: A multivalued dependency is a full constraint among two sets of attributes in a rela

State the Component Diagram A component diagram represents a set of component and relationships among them. In a dynamic model, component diagram is used to model physical com

Components of database manager The above functions are reached by the database manager. The major elements of a database manager are: Authorisation control: This mod

Explain the rules for creating a labelled precedence graph for testing view serializability.            Ans: A schedule S is view serializable if it is view equivalent to a ser

Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap

What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet

Advantages And Drawbacks Of Ddbms  There are various reasons for building distributed database systems, with sharing of data, reliability and availability, and speedup of query

Write a query to define tables students and teachers as sub tables of people? Create table students of student under people Create table teachers of teacher under people

Change the city of First Bank Corporation to ‘New Delhi' UPDATE COMPANY SET CITY = ‘New Delhi' WHERE COMPANY_NAME = ‘First Bank Corporation';

A database named yourusernameFMA has been set up for you to use for this assignment.  For the FMA you must create the required tables and run the queries using this database.  If y