In a ‘‘Shared something’’ environment, ACID is wanted for forcing
Consistency at the end of the transaction, whereas in a ‘‘Shared
Nothing’’ environment, BASE is implemented. The features of ACID
and BASE are given in Table 1.
The technical mechanism for ‘‘Commit’’ and ‘‘Transactions processing’’, etc. does not differ much in ACID and BASE, but the usage differs.
ACID comes from a paradigm of one database with ‘‘Many users’’ and that transaction on datasets are made only one at the time having the ability to change a value. For ACID deadlocks are a challenge. Some NoSQL solutions such as CouchDB are fully ACID and some can be configured to behave as ACID [3].
But, BASE comes from the paradigm where data is distributed and synchronization of data is not feasible. In BASE the exact values are not utterly necessary. A challenge for BASE is how to update distributed data while the data takes many unforeseen routes.