What Are the General Rules on Data Consistency?
Page 1 of 1
What Are the General Rules on Data Consistency?
by Micheal Sun Jan 17, 2010 3:38 am
All SQL statements always work with a snapshot of the database to provide data consistency.
For READ WRITE transactions, the snapshot is taken when each statement starts.
For READ ONLY transactions, the snapshot is taken when the transaction starts.
The snapshot never include uncommitted changes from other transactions.
The snapshot always include uncommitted changes from its own transaction.
For READ WRITE transactions, the snapshot is taken when each statement starts.
For READ ONLY transactions, the snapshot is taken when the transaction starts.
The snapshot never include uncommitted changes from other transactions.
The snapshot always include uncommitted changes from its own transaction.
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» What Is a Data Lock?
» How Data Locks Are Respected?
» How To Experiment a Data Lock?
» What Is an Oracle Data File?
» What Happens If You Lost a Data File?
» How Data Locks Are Respected?
» How To Experiment a Data Lock?
» What Is an Oracle Data File?
» What Happens If You Lost a Data File?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL