What is a transaction and what are ACID properties?

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.









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 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 procedure
what is hibernate.archive.autodetection
What is Hibernate
What is Hibernate
What is Hibernate
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 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 SPOOL?
What is CRM?
What is webservices?
What is Ajax?
What is NSRangeException
What is portal
what is posting?
What is a tuple?
What is workflow
what is RUP?
What was ENIAC
What is an Iterator?

Ads