Databases usually have a lot of operations happening in parallel throughout the life of an application after it has been deployed. These operations can be as simple as retrieval of information from the database, or can be operations that modify the state of the database by inserting new records, updating existing ones, or deleting others. Most of the databases that are currently being used in production by large organizations have been built with quite a lot of resilience, in terms of dealing with errors and crashes that can happen in the environment to disturb the normal functioning of a database. These methods prevent the corruption of data and downtime.
But this does not relieve the application developer completely of the fact that they still need to be careful about maintaining the consistency of the data inside the database. Let's try...
