Editing Databases
Editing Databases
•
•
Database editing relies on transactions
Database editing relies on transactions
•
•
Database transactions often conform to the ACID standards
Database transactions often conform to the ACID standards
•
•
Transactions have
Transactions have
“
“
ACID
ACID
”
”
standards
standards
–
–
A
A
tomic
tomic
—
—
A transaction exhibits "all or nothing" behavior.
A transaction exhibits "all or nothing" behavior.
–
–
C
C
onsistent
onsistent
—
—
A transaction leaves the database in a consistent state.
A transaction leaves the database in a consistent state.
–
–
I
I
solation
solation
—
—
Changes are isolated from other transactions is committed.
Changes are isolated from other transactions is committed.
–
–
D
D
urable
urable
—
—
Once a transaction commits, its results are persistent.
Once a transaction commits, its results are persistent.
Comments to this Manuals