| Transactions - What's it all about? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| l | Far more than
just locking |
|||||||||||||
| l | The A.C.I.D. test |
|||||||||||||
| l | True transactions
give true safety |
|||||||||||||
| – | even from power
failures and system crashes! |
|||||||||||||
| – | Incomplete
transactions are automatically rolled-back by the |
|||||||||||||
| database server
when it's restarted. |
||||||||||||||
| l | Also removes
burden of undoing incomplete changes |
|||||||||||||
| l | Hard to
implement (for the vendor) and has significant |
|||||||||||||
| performance cost |
||||||||||||||
| l | A very large
topic worthy of an entire tutorial |
|||||||||||||
| 21 |