CIT 381 Chapter 10, Database Systems: Design, Implementation, and Management
1. Atomicity: The transaction property that requires all parts of a transaction to be treated as a single, indivisible
logical unit of work All parts of a transaction must be completed or the entire transaction is aborted.
2. Atomic Transaction Property: A property that required all parts of a transaction to be treated as a
single, logical unit of work in which all operations must be completed(committed) to produce a consistent database.
3. Binary Lock: A lock that has only two states: locked(1) and unlocked(0). If a data item is locked by a transaction,
no other transaction can use that data item.
4. Buffer: Temporary storage area in primary memory used to speed up disk operations.
5. Checkpoint: In transaction management, an operation in which the database management system writes all
of its updated buffers to disk.
6. Concurrency Control: A DBMS feature that coordinates the simultaneous execution of transaction in a
1/4
, multiprocessing database system while preserving data integrity.
7. Consistency: A database condition in which all data integrity constraints are satisfied, To ensure consistency
of a database, every transaction must begin with the database in a known consistent state. If not, the transaction will
yield an inconsistent database that violate its integrity and business rules.
8. Consisten Database State: A database state in which all data integrity constraints are satisfied.
9. Database-Level Lock: A type of lock that restricts database access to the owner of the lock and allows only
one user at a time to access the database, This lock works for batch processes but is unsuitable for online multiuser
DMBSs.
10. Database Recovery: The process of restoring a database to a previous consistent state.
11. Database Request: The equivalent of a single SQL statement in an application program or a transaction.
12. Deadlock: A condition in which two or more transactions wait indefinitely for the other to release the lock on
2/4
1. Atomicity: The transaction property that requires all parts of a transaction to be treated as a single, indivisible
logical unit of work All parts of a transaction must be completed or the entire transaction is aborted.
2. Atomic Transaction Property: A property that required all parts of a transaction to be treated as a
single, logical unit of work in which all operations must be completed(committed) to produce a consistent database.
3. Binary Lock: A lock that has only two states: locked(1) and unlocked(0). If a data item is locked by a transaction,
no other transaction can use that data item.
4. Buffer: Temporary storage area in primary memory used to speed up disk operations.
5. Checkpoint: In transaction management, an operation in which the database management system writes all
of its updated buffers to disk.
6. Concurrency Control: A DBMS feature that coordinates the simultaneous execution of transaction in a
1/4
, multiprocessing database system while preserving data integrity.
7. Consistency: A database condition in which all data integrity constraints are satisfied, To ensure consistency
of a database, every transaction must begin with the database in a known consistent state. If not, the transaction will
yield an inconsistent database that violate its integrity and business rules.
8. Consisten Database State: A database state in which all data integrity constraints are satisfied.
9. Database-Level Lock: A type of lock that restricts database access to the owner of the lock and allows only
one user at a time to access the database, This lock works for batch processes but is unsuitable for online multiuser
DMBSs.
10. Database Recovery: The process of restoring a database to a previous consistent state.
11. Database Request: The equivalent of a single SQL statement in an application program or a transaction.
12. Deadlock: A condition in which two or more transactions wait indefinitely for the other to release the lock on
2/4
