Basic HTML version of Foils prepared 7 October 97

Foil 43 Data Concurrency and Consistency in Oracle -I

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
Locking - control concurrent access to data
Intended to prevent destructive interaction between users accessing table data
Locks are used to achieve two important database goals
  • Consistency - ensure that the data a user is viewing or changing is not changed (by other users) until the user is finished with the data
  • Integrity - ensures that the database's data and structures reflect all changes made to them in the correct sequence

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Jan 27 1998