Atomicity - Definition - Database

Q.  What do you mean by atomicity?
- Published on 25 Aug 15

a. When an update occurs to a database, either all or none of the update becomes available to anyone
b. It determines how the transaction integrity will be visible to the other users and systems
c. The transactions have been committed and will survive permanently
d. All of the above

ANSWER: When an update occurs to a database, either all or none of the update becomes available to anyone

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 04 Nov 15
    Atomicity
    - It is one of the ACID transaction properties.

    - In this a series of database operations either all occur, or nothing occurs.

    - The series of operations cannot be divided apart and executed partially from each other, which makes the series of operations "indivisible", hence the name.

    - A guarantee of this peoperty prevents updates to the database occurring only partially, which can cause greater problems than rejecting the whole series outright.

    - In simpler words, atomicity means indivisibility and irreducibility.

    - As a consequence, the transaction cannot be observed to be in progress by another database client.

    - At one moment in time, it has not yet happened, and at the next it has already occurred in whole (or nothing happened if the transaction was cancelled in progress).

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲