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
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is the use of tempdb? What values does it hold?
explain how to create a new schema in a database? : Sql server database administration
How to count rows with the count(*) function in ms sql server?
What is 4nf in normalization form?
What is purpose of normalization?
explain different levels of normalization? : Sql server database administration
What is the use of stored procedure?
How to generate create procedure script on an existing stored procedure?
How data can be copied from one table to another table?
How do I uninstall sql server 2014?
What is mssql?
role of sql sever 2005 in database rather than any other database
What stored by the master?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?