C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !






ACID Properties


Posted Date: 20 Aug 2008    Resource Type: Articles    Category: Databases
Posted By: D.Jeya kumar(JK)       Member Level: Diamond
Rating:     Points: 7



ACID Properties
ACID means Atomicity, Consistency, Isolation, and Durability. It is to ensure the integrity of the Database. It allows safe transaction for the critical money transfers. It will complete the transaction otherwise it will revoke all the changes. ACID properties are important concept for Database.
Atomicity:
For each transaction if any one fails then entire transaction fails. In simple words everything should be atomic.
For example
For a money transfer it should be debited from one account and it should be credited to another account. If one fails then it should be debited or credited.
Consistency:
Consistency should be checked for the Database to check for the valid entries. If some entries are wrong and it is not valid then entire transaction will be revoked and nothing will get affected. Consistency will check for the Valid and check for the DB rules also.
For example:
The amount should be a valid number. It should not have special chars other than Dot
Isolation:
If many transactions occurred at the same time then it should not overlap or it should not affect other transaction. Each should be isolated.
For Example:
If A is transferring money to B and B is transferring money C. and C is transferring money to A. it should not affect until one transaction is completed.
Durability:
It will check for the committed values. Whether the values are correctly stored
For Example:
If some amount is debited and credited to another account. It should match each other.


Attachments

  • Download the Document (20347-20418-ACID Properties.doc)



    • Responses

    No responses found. Be the first to respond and make money from revenue sharing program.

    Feedbacks      
    Popular Tags   What are tags ?   Search Tags  
    ACID Properties  .  

    Post Feedback


    This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
    You must Sign In to post a response.
    Next Resource: Beyond basics in SQL server 2005
    Previous Resource: Constraints in Sql server - part -1
    Return to Discussion Resource Index
    Post New Resource
    Category: Databases


    Post resources and earn money!     		 
    Related Resources


    dotNet Slackers   BizTalk Adaptors    Web Design

    internet fax

    Contact Us    Privacy Policy    Terms Of Use