Tuesday, August 14, 2012

ACID properties

    Atomic
    • Any database Transaction is all or nothing
    • If one part of the transaction fails it all fails
    • An incomplete transaction cannot exist
    • eg: Order & Shipment - Mark order as complete & mark as shipped at the same time.
    Consistent
    • Any transaction will take the data from one consistent state to another
    • Only consistent data is allowed to be written
    Isolated
    • No transaction should be able to interfere with another transaction
    • The same field cannot be updated by two sources at the exact same time
    Durable
    • Once  a transaction is committed it will stay that way
    • Save it once, read it forever unless modified / deleted

No comments:

Post a Comment