, () () .
, . . . ? , ? , , , . , , , . , , , . : BOOKS, EXEMPLAR , . , , .
, . , . , :
, ; , .
, . , , . : , , , , - . .
.
, , , , . .
: , .
, , , : , , , () ACID (Atomicity, Consistency, Isolation, Durability). ACID-. :
- (Atomicity) , .
- (Consistency) , .
- (Isolation) , , , , .
- (Durability) : , , , ( ).
. , .
, , .
, , , . , . , . , , "" .
, , . , , SQL .
, . , , .
ANSI/ISO SQL COMMIT ROLLBACK. , SQL-, , . SQL- . (. 1):
. 1. ANSI/ISO
- COMMIT ; , ;
- ROLLBACK , , ; ROLLBACK;
- , , ( COMMIT);
- ( ROLLBACK).
, , , .
ANSI/ISO. SYBASE , . SYBASE :
- BEGIN TRANSACTION . ANSI/ISO, , SYBASE .
- COMMIT TRANSACTION . COMMIT ANSI/ISO. , COMMIT, , .
- SAVE TRANSACTION , , . SAVE TRANSACTION . , .
- ROLLBACK . , , ROLLBACK ANSI/ISO. ROLLBACK B, B.
|