ACID
Quick Definition
Properties guaranteeing reliable transaction processing
Full Definition
Properties Atomicity, Consistency, Isolation, Durability guaranteeing reliable transactions.
Examples
transaction management, data integrity, consistency guarantees
Related Terms
transaction
relational-database
More Database Terms
Trigger
Special procedure that auto-executes on table events
Materialized View
Physical stored copy of query results refreshed periodically
Foreign Key
Field referencing primary key to establish table relationships
B-Tree Index
Self-balancing tree index for efficient sorted data operations
CAP Theorem
Theorem on Consistency, Availability, Partition tolerance trade-offs
Isolation Level
Degree of visibility between concurrent transactions