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:
JDBC Transaction ACID property
what is bit
Advertisements
What is procedure
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is collections?
what are indices?
What is Hibernate
What is Hibernate
What is Hibernate
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?
What is CRM?
What is webservices?
What is Ajax?
What is NSRangeException
What is portal
What was ENIAC
What is Java?

Ads