Acid fundamental and transactions in sql server, DOT NET Programming

What is ACID fundamental? What are transactions in SQL SERVER?

The transaction is a sequence of operations performed as a single logical unit of work..The logical unit of work should exhibit 4 properties, Known as the ACID (Isolation , Atomicity, Consistency, and Durability) properties, to qualify for the transaction:

1)Atomicity:

The transaction should be an atomic unit of work; either all of its data modifications are performed or none of them is performed.

2)Consistency:

When done, a transaction should leave all its data in a consistent state. In a relational database, all rules should be applied to the transaction's modifications to maintain all data integrity. All internal data structures, like B-tree indexes or doubly-linked lists, must be correct at the end of the transaction.

3)Isolation:

The Modifications made by concurrent transactions should be isolated from the modifications made by any other concurrent transactions. A transaction either see data in the state it was before another concurrent transaction modified it, or it views the data after the second transaction has done, but it does not see an intermediate state. This is known as serializability as it results in the ability to reload the starting data and replay a series of transactions to end up with the data in the same state it was in after the original transactions were performed.

4)Durability

After the transaction has done, its effects are permanently in the place in the system. The changes persist even in the event of a system failure.

Posted Date: 9/24/2012 4:01:50 AM | Location : United States







Related Discussions:- Acid fundamental and transactions in sql server, Assignment Help, Ask Question on Acid fundamental and transactions in sql server, Get Answer, Expert's Help, Acid fundamental and transactions in sql server Discussions

Write discussion on Acid fundamental and transactions in sql server
Your posts are moderated
Related Questions
I need to Develop a real state website We want a programmer who can create a website using html5, css3, jQuery, php, MySQL. All connected to a CRM to accomplish all the informat

What is Manual Reset Event and Auto Reset Event? The Threads that call one of the wait methods of a synchronization event should wait until other thread signals the event by ca

How can you raise custom errors from stored procedure? The RAISERROR statements are  used to produce an ad hoc error message or to retrieve acustom message which is stored in t

Djvu view and setup,  sourcecode with nice UI Project Description: i want an application build for viewing djvu files -must include setup -must include source code -

Have you ever worked with Microsoft Application Blocks, if yes then which? The Application Blocks are C# & the VB.NET classes distributed as the Visual Studio projects which ca

Delay signing During the development process you  need strong keys name  to be exposed to the developer which is not a good practice from security aspect .In such situations yo

Create a Calculator application using Web Form with the following functions: 1.  Add 2.  Minus 3.  Multiply 4.  Divide Each of the above has to be a Web Service

how to create log in form using vb 2010

Explain the WSDL. WSDL is a short form for Web Services Description Language, which is used to explain a Web service in terms of the messages that it forms and accepts. The WS

What are the features of ADO.Net ?  ADO.NET features: 1. Disconnected Data Architecture 2. Data cached in Datasets 3. Data transfer in XML format 4. Interaction wit