Please enable JavaScript.

Coggle requires JavaScript to display documents.

Transactions (ACID (Atomicity (All updates or none occur only (Prevent…

- - - - Prevent changes causing corruption of data
      - In a banking example, one transfer may occur while another may not if atomicity is not maintained
  - - - Poor consistency means that multiple actions at the same time would not operate correctly (withdrawing 2x100 but only 100 is removed)
  - - - Any operation cannot be viewed in an intermediate state
        
        Other transaction
        
        Query
  - - - Hardware such as a UPS or backup generator to allow currently accessed records to be written before shutdown.
- - - - Database reverts to the previous state
  - - - database state is updated with the new changes