Answer / swapna

The term ACID conveys the role transactions play in mission-
critical applications. Coined by transaction processing
pioneers, ACID stands for atomicity, consistency,
isolation, and durability.

These properties ensure predictable behavior, reinforcing
the role of transactions as all-or-none propositions
designed to reduce the management load when there are many
variables.

Atomicity

A transaction is a unit of work in which a series of
operations occur between the BEGIN TRANSACTION and END
TRANSACTION statements of an application. A transaction
executes exactly once and is atomic ? all the work is done
or none of it is.

Operations associated with a transaction usually share a
common intent and are interdependent. By performing only a
subset of these operations, the system could compromise the
overall intent of the transaction. Atomicity eliminates the
chance of processing a subset of operations.

Consistency

A transaction is a unit of integrity because it preserves
the consistency of data, transforming one consistent state
of data into another consistent state of data.
Consistency requires that data bound by a transaction be
semantically preserved. Some of the responsibility for
maintaining consistency falls to the application developer
who must make sure that all known integrity constraints are
enforced by the application. For example, in developing an
application that transfers money, you should avoid
arbitrarily moving decimal points during the transfer.

Isolation


A transaction is a unit of isolation ? allowing concurrent
transactions to behave as though each were the only
transaction running in the system.
Isolation requires that each transaction appear to be the
only transaction manipulating the data store, even though
other transactions may be running at the same time. A
transaction should never see the intermediate stages of
another transaction.
Transactions attain the highest level of isolation when
they are serializable. At this level, the results obtained
from a set of concurrent transactions are identical to the
results obtained by running each transaction serially.
Because a high degree of isolation can limit the number of
concurrent transactions, some applications reduce the
isolation level in exchange for better throughput.


Durability

A transaction is also a unit of recovery. If a transaction
succeeds, the system guarantees that its updates will
persist, even if the computer crashes immediately after the
commit. Specialized logging allows the system's restart
procedure to complete unfinished operations, making the
transaction durable.

Answer / ravikumar

ACID properties
When a transaction processing system creates a transaction,
it will ensure that the transaction will have certain
characteristics. The developers of the components that
comprise the transaction are assured that these
characteristics are in place. They do not need to manage
these characteristics themselves. These characteristics are
known as the ACID properties. ACID is an acronym for
atomicity, consistency, isolation, and durability.

Atomicity
The atomicity property identifies that the transaction is
atomic. An atomic transaction is either fully completed, or
is not begun at all. Any updates that a transaction might
affect on a system are completed in their entirety. If for
any reason an error occurs and the transaction is unable to
complete all of its steps, the then system is returned to
the state it was in before the transaction was started. An
example of an atomic transaction is an account transfer
transaction. The money is removed from account A then
placed into account B. If the system fails after removing
the money from account A, then the transaction processing
system will put the money back into account A, thus
returning the system to its original state. This is known
as a rollback, as we said at the beginning of this chapter..

Consistency
A transaction enforces consistency in the system state by
ensuring that at the end of any transaction the system is
in a valid state. If the transaction completes
successfully, then all changes to the system will have been
properly made, and the system will be in a valid state. If
any error occurs in a transaction, then any changes already
made will be automatically rolled back. This will return
the system to its state before the transaction was started.
Since the system was in a consistent state when the
transaction was started, it will once again be in a
consistent state.

Looking again at the account transfer system, the system is
consistent if the total of all accounts is constant. If an
error occurs and the money is removed from account A and
not added to account B, then the total in all accounts
would have changed. The system would no longer be
consistent. By rolling back the removal from account A, the
total will again be what it should be, and the system back
in a consistent state.

Isolation
When a transaction runs in isolation, it appears to be the
only action that the system is carrying out at one time. If
there are two transactions that are both performing the
same function and are running at the same time, transaction
isolation will ensure that each transaction thinks it has
exclusive use of the system. This is important in that as
the transaction is being executed, the state of the system
may not be consistent. The transaction ensures that the
system remains consistent after the transaction ends, but
during an individual transaction, this may not be the case.
If a transaction was not running in isolation, it could
access data from the system that may not be consistent. By
providing transaction isolation, this is prevented from
happening.

Durability
A transaction is durable in that once it has been
successfully completed, all of the changes it made to the
system are permanent. There are safeguards that will
prevent the loss of information, even in the case of system
failure. By logging the steps that the transaction
performs, the state of the system can be recreated even if
the hardware itself has failed. The concept of durability
allows the developer to know that a completed transaction
is a permanent part of the system, regardless of what
happens to the system later on.

Answer / srilekha

ACID properties are:
Atomacity,
consistency,
Isolation,Durability.

Answer / 1647264

The term ACID conveys the role transactions play in mission-critical applications. Coined by transaction processing pioneers, ACID stands for atomicity, consistency, isolation, and durability.

These properties ensure predictable behavior, reinforcing the role of transactions as all-or-none propositions designed to reduce the management load when there are many variables.

Atomicity

A transaction is a unit of work in which a series of operations occur between the BEGIN TRANSACTION and END TRANSACTION statements of an application. A transaction executes exactly once and is atomic � all the work is done or none of it is.

Operations associated with a transaction usually share a common intent and are interdependent. By performing only a subset of these operations, the system could compromise the overall intent of the transaction. Atomicity eliminates the chance of processing a subset of operations.

Consistency

A transaction is a unit of integrity because it preserves the consistency of data, transforming one consistent state of data into another consistent state of data.

Consistency requires that data bound by a transaction be semantically preserved. Some of the responsibility for maintaining consistency falls to the application developer who must make sure that all known integrity constraints are enforced by the application. For example, in developing an application that transfers money, you should avoid arbitrarily moving decimal points during the transfer.

Isolation

A transaction is a unit of isolation � allowing concurrent transactions to behave as though each were the only transaction running in the system.

Isolation requires that each transaction appear to be the only transaction manipulating the data store, even though other transactions may be running at the same time. A transaction should never see the intermediate stages of another transaction.

Transactions attain the highest level of isolation when they are serializable. At this level, the results obtained from a set of concurrent transactions are identical to the results obtained by running each transaction serially. Because a high degree of isolation can limit the number of concurrent transactions, some applications reduce the isolation level in exchange for better throughput.

Durability

A transaction is also a unit of recovery. If a transaction succeeds, the system guarantees that its updates will persist, even if the computer crashes immediately after the commit. Specialized logging allows the system's restart procedure to complete unfinished operations, making the transaction durable.

Which method do you invoke on the DataAdapter control to load your generated dataset with data?

5 Answers   IBM, Veegyapan Impacts,

---

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

0 Answers  

---

What do you mean by performing asynchronous operation using command object?

0 Answers  

---

Which object of ado contains datarow datacolumn collection?

0 Answers  

---

Define Execute Reader?

0 Answers  

---

---

What is the difference between oledbreader and datasetwhile connecting?

1 Answers  

---

What is the usage of the dataset object in ado.net?

0 Answers  

---

The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

0 Answers  

---

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  

---

When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors?

5 Answers   HCL,

---

How to identify the updated rows in a dataset?

0 Answers  

---

What does connection string consists of ?

4 Answers   Digital GlobalSoft,

---