CIT 214

11 cards·by bhuff988

any action that reads from and/or writes to a database

transaction

the equivalent of a single SQL statement in an application program

database request

a column distribution of values or the number of different values a column could have

data sparsity

condition that exists when two or more transactions wait indefinitely for each other to release the lock on a previously locked data item

deadlock

indicates the level of lock use

lock granularity

a concurrency control problem in which data updates are lost during the concurrent execution of transactions

lost updates

refers to a condition when transaction operations do not immediately update a physical database

deferred update

also known as a deadlock

deadly embrace

in concurrency control a property of time stamping that ensures that no equal time stamp values can exist

uniqueness

a DBMS feature that is used to coordinate the simultaneous execution of transactions in a multiprocessing database system

concurrency control

in transaction management, a technique used in scheduling concurrent transactions that assigns global unique time stamp to each transaction

time stamping