Sign in to save your progress, vote, and build your own decks.Sign in
CIT214
Final Whatnots
20 cards·by caseybrockman
haha
caused when two or more transactions wait for each other to unlock data
deadlock
deadlock
caused when two or more transactions wait for each other to unlock data
equivalent of a single sql statement in an application program/transaction
database request
database request
equivalent of a single sql statement in an application program/transaction
a set of activities and procedures designed to reduce the response time of of the database
system
database performance tuning
database performance tuning
a set of activities and procedures designed to reduce the response time of of the
databasesystem
the older transaction rolls back the younger transaction and reschedules it
wound/wait
wound/wait
the older transaction rolls back the younger transaction and reschedules it
the older transaction waits for the younger to complete and release its locks
wait/die
wait/die
the older transaction waits for the younger to complete and release its locks
only one transaction at a time can own an exclusive lock on the same object
mutual exclusive rule
mutual exclusive rule
only one transaction at a time can own an exclusive lock on the same object
Exists when access is reserved specifically for the transaction that locked the object
exclusive lock
exclusive lock
Exists when access is reserved specifically for the transaction that locked the object
lock with two states: lock/unlock
binary lock
binary lock
lock with two states: lock/unlock
indicates the level of lock use
lock granularity
lock granularity
indicates the level of lock use
manages lock information
lock manager
lock manager
manages lock information