week 7 key terms
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
100
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
2
Uploaded by hi5on3andonly
after image: a record that the database management system (DBMS) adds to the journal or log
to document how the data in a row appeared in the database following a transaction
modification.
backward recovery: Backward recovery is the process of restoring a database to a usable
condition by examining the log for problematic transactions and using the prior images to roll
back their modifications.
batch processing:
updating a database or another file by processing a transaction file that
contains a batch of records.
before image: a record that the database management system (DBMS) inserts into the journal
or log to demonstrate how the data in a row appeared in the database prior to a transaction
modification.
Biometrics: a method for identifying database or other resource users by physical traits
including voiceprints, handwritten signatures, fingerprints, and facial features
Commit:
a unique entry in the journal or log of a database that signifies the successful
conclusion of a transaction.
concurrent update:
a circumstance where numerous users simultaneously edit the same
database
deadlock
/
deadly embrace:
Also known as a "deadly embrace," this situation involves two or
more database users who are all waiting to use resources that the other(s) is/are holding.
decrypting:
a procedure that undoes a database's encryption. is also known as decryption.
encryption:
forward recovery:
a security mechanism that changes a database's contents into a format that
regular applications cannot read. For every authorized user who accesses the database, the
DBMS decrypts or decodes the data to restore it to its original form.
growing phase:
a stage of a database update during which the database management system
locks all the data required for a transaction and does not release any locks.
journaling:
keeping a record or log of each database change.
locking:
While a DBMS is processing one user's modifications to the database, other users are
denied access to the data.
metadata:
Information in a database about the data
nonprocedural language:
a language wherein the user specifies the task that the machine
should do rather than the actions that must be taken to complete it.
procedural language:
a language that allows users to specify the steps necessary to complete a
task rather than just describing the task itself.
shrinking phase:
a stage of a database update during which the DBMS releases all locks that
have been held for a transaction and makes no new lock acquisitions.
timestamp:
the specific moment when a database management system (DBMS) begins a
transaction update.
two-phase locking:
a locking strategy that has two phases: a growing phase during which the
DBMS locks more rows while not releasing any locks, and a shrinking phase during which the
DBMS releases all locks while not acquiring any new ones. This strategy is used to manage
concurrent updates.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help