What is a transaction and what are ACID properties?

Ads
 

What is a transaction and what are ACID properties?

What is a transaction and what are ACID properties?

View Answers

November 15, 2010 at 6:01 PM

Hi,

Here is the answer,

A transaction is an atomic unit of work that must be completed in its entirety.The transaction succeeds if it committed and fails if it is aborted.

Database theory has a more rigorous definition of a transaction and states that a transaction has four fundamental properties, known as ACID properties:

A(Atomicity):-The sequence of operations must be atomic, either all or no operations are performed.

C(Consistency):- When completed, the sequence of operations must leave data in consistent mode. All the defined relations/constraints must me Maintained.

I(Isolation): A Transaction must be isolated from all other transactions. A transaction sees the data defore the operations are performed , or after all the operations has performed, it can't see the data in between.

D(Durability): All oprtaions must be permanently placed on the system. Even in the event of system failure , all the operations must be exhibit.

Thanks.

Ads









Related Tutorials/Questions & Answers:
What is a transaction and what are ACID properties?
what is Set Transaction?
Advertisements
JDBC Transaction ACID property
what is bit
What is procedure
what is hibernate.archive.autodetection
What is JDBC?
What is FBT
What is ActionServlet?
What is Trigger?
What is VLR ?
What's PHP ?
What is an interface?
What is DML?
What is Index?
What is SQLLoader?
What is a "constraint"?
what is Savepoint ?
What is this keyword?
what is collections?
what are indices?
What is Hibernate
What is an Abstract Class and what is it's purpose?
What is Externalizable?
What is the % operator?
What is casting?
What is DataAccessException?
What is IOC ?
What is SQLExceptionTranslator?
What are Struts?
What is WAP?

Ads