37 - SQL Transaction Concurrency
-
About SQL Transaction Concurrency
Although there is never more than one current SQL transaction between your ...
-
Isolation Phenomena
What sort of errors and inconsistencies can creep in during concurrent
oper...
-
Pessimistic Concurrency: LOCKING
The most common and best-known way to eliminate some or all of the transact...
-
Optimistic Concurrency: TIMESTAMPING
There are several ways to control concurrency without locking. The most com...
-
SET TRANSACTION Statement
By now, we've come to expect that SQL statements aren't used to specify
met...
-
Access Mode
If the transaction's isolation level is READ UNCOMMITTED,
then READ ONLY is...
-
Isolation level
The <isolation level> characteristic you specify in a SET TRANSACTION
state...
-
SET LOCAL TRANSACTION
If your DBMS supports transaction that may affect more than one SQL-server,...
-
START TRANSACTION Statement
In SQL3, you don't need the SET TRANSACTION statement, except for setting
t...
-
Special Problems
The SQL-Schema change statements (CREATE, ALTER, DROP, GRANT,
REVOKE) requi...
-
Transactions and Constraint Checking
There is one other SQL transaction management statement: SET CONSTRAINTS.
W...
-
Dialects
Some DBMSs support locking, some support timestamping, some support both.
B...
-
Goodies
The OCELOT DBMS that comes with this book supports concurrency. These are t...
