ended3월 25일· 3 sources
Consistency
ACID의 일관성(Consistency) 속성
Why it matters
The article explores the Consistency property of ACID through a wallet system example using PostgreSQL. It demonstrates how CHECK constraints prevent invalid states such as negative balances, and shows that both direct updates and transactional operations are rejected when they violate these rules. It also discusses enforcing consistency at the application level by adding balance verification conditions within transactions.
3
Sources
+0
24h
—
Growth
180d
Active
acid consistencybalance validationcheck constraintconsistencypostgresqlsql transactiontransactionwallet system데이터 무결성