.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> SQL Query >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Transaction

Posted By:Athira Sreejith       Posted Date: December 31, 2008    Points: 10    Category: SQL Query    URL: http://www.dotnetspark.com  
 

Transaction:

A transaction is a logical unit of work ,that must either be completely executed or aborted ,no intermediate states are acceptable.

1.Atomicity:
A transaction is a single logical unit of work.
2.Consistency:
A transaction must take a DB from one consistent state to 
another consistent state.
3.Isolation:
Every transaction should execute as if it is the only transaction existing
in the system.
4.Durability:
Once a transaction has completed successfully,the updated tuples
must be available for all other transaction on a permanent basis.

This is calles ACID Property
 

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend