What is database consistency?

Most database systems have rules for what kinds of data can and cannot be stored (among other rules). Consistency is the term used to describe a database in which those rules are always enforced. A database is said to have consistency when no transaction can violate the integrity of the database – all transactions must leave the database in a valid state.

It is one of the four ACID properties that are desirable for databases dealing with transactional workloads.

Subscribe to our newsletter
Get the latest tutorials, blogs, and case studies sent directly to your inbox