Consistency (database systems)
From Wikipedia, the free encyclopedia
 |
This article relies largely or entirely upon a single source. (December 2008) |
For other uses, see Consistency (disambiguation).
In database systems, a consistent transaction is one that does not violate any integrity constraints during its execution. If a transaction leaves the database in an illegal state, it is aborted and an error is reported.[1]
Consistency is one of the ACID properties that ensures that any changes to values in an instance are consistent with changes to other values in the same instance. A consistency constraint is a predicate on data which serves as a precondition, post-condition, and transformation condition on any transaction. The database management system (DBMS) assumes that the consistency holds for each transaction in instances. On the other hand, ensuring this property of the transaction is the responsibility of the user.
See also[edit]
References[edit]
 |
This database-related article is a stub. You can help Wikipedia by expanding it. |
