What is a transaction and what are ACID properties?
Answer Posted / ajith
In computer science, ACID (atomicity, consistency,
isolation, durability) is a set of properties that
guarantee database transactions are processed reliably. In
the context of databases, a single logical operation on the
data is called a transaction. For example, a transfer of
funds from one bank account to another, even though that
might involve multiple changes (such as debiting one
account and crediting another), is a single transaction.
Jim Gray defined these properties of a reliable transaction
system in the late 1970s and developed technologies to
automatically achieve them.[1] In 1983, Andreas Reuter and
Theo Haerder coined the acronym ACID to describe them.[2]
Contents [hide]
1 Characteristics
1.1 Atomicity
1.2 Consistency
1.3 Isolation
1.4 Durability
2 Examples
2.1 Atomicity failure
2.2 Consistency failure
2.3 Isolation failure
2.4 Durability failure
3 Implementation
3.1 Locking vs multiversioning
3.2 Distributed transactions
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the differences between decimal and float in ms sql server?
tell me the disaster recovery plan
Differentiate between a having clause and a where clause.
Can we use having clause without group by?
Explain steps of normalization?
what is sql server? : Sql server database administration
What is indexing a document?
How to read data in a table with "select" statements?
What is a db view?
How you can change a cross join into an inner join?
where can you add custom error messages to sql server? : Sql server administration
Do you know what are the steps to process a single select statement?
How can we delete Duplicate row in table?
How to change the system date and time from SQL Plus Terminal ?
What is master database? : SQL Server Architecture