ACID protects your database’s information
The ACID model ofdatabase designis an important concept of database theory.
A relational database that fails to meet any of these four goals cannot be considered reliable.
Conversely, a database that possesses these characteristics is considered ACID-compliant.
The query’s updates are written to the shadow page rather than to the real data in the database.
The database is modified only when the edit is complete.
Another strategy is called thetwo-phase commitprotocol, especially useful in distributed database systems.
This protocol separates a request to modify data into two phases: a commit-request phase and a commit phase.
Once confirmation is received from all relevant DBMSs, the commit phase completes in which the data is modified.
The ACID model isn’t the only approach to managing data.
TheBASE modelworks well with unstructured data.
