Sign in to save your progress, vote, and build your own decks.Sign in
CIT214 Stuff
:D
15 cards·by theguy1
The coordination of the simultaneous execution of transactions in a multiuser database
system
concurrency control
Ensures that the schedule for concurrent execution of the transactions yields consistent
results
serializibility
Requires that all operations of a transactions be completed
atomicity
Eqivalent of a single SQL statement in an application program/ transaction
database request
manages lock information
lock manager
indicates the level of lock use
lock granularity
lock with two states: locked/ unlocked
binary lock
Exists when access is reserved specifically for the transaction that locked the object
exclusive lock
Only one transaction at a time can own an exclusive lock on the same object
mutual exclusive rule
caused when two or more transactions wait for each other to unlock data
deadlock
the older transaction waits for the younger to complete and release its locks
wait/die
the older transaction rolls back the younger transaction and reschedules it
wound/ wait
a set of activities and procedures designed to reduce the response time of the database system
database performance tuning
a low-level data access operation to and from computer devices
I/O request
refers to the number of different values a column could possibly have
data sparsity