Explain a database lockout and the deadlock phenomenon. Contrast that to concurrency control and the timestamping technique. Describe the importance of these items in relation to database integrity.
What will be an ideal response?
In a centralized database, a lockout is used to ensure data currency. A lockout prevents simultaneous access to individual data elements by different information processing units (IPU). When one IPU requests access to a data element, a lock is put on the file, record, or element. No other IPU can access the file, record, or element until the lock is released.
In a partitioned database, lockouts are also used to ensure data currency. It is possible, however, for multiple sites to place locks on records that results in a deadlock condition which prevents transactions from processing. All transactions are in a wait state until the locks are removed. A deadlock cannot be resolved without outside intervention from the user's application, the DBMS, or the operating system.
In a replicated database, a large volume of data flows between sites, and temporary inconsistencies in the database may occur. Concurrency control ensures that transactions executed at each IPU are accurately reflected in the databases of all other sites. A popular method for concurrency control is to timestamp transactions. Transactions that may be in conflict are assigned a system-wide timestamp. Then, the identified transactions are processed in timestamp order.
Both database lockouts and concurrency controls are designed to ensure that the transactions are completely processed and that all transactions are accurately reflected in the firm's databases. Failure to implement these controls can result in transactions being lost, being partially processed, or with inconsistent databases.
PTS: 1
You might also like to view...
__________ encryption is a form of cryptosystem in which encryption and decryption are performed using the same key.
Fill in the blank(s) with the appropriate word(s).
The selector .center is an example of a(n) ____ selector.
A. elemental B. concatenated C. class D. active
A technician notices a rack mounted server is beeping without booting up. The NEXT step to diagnose this issue would be to:
A. continue to power cycle the server until it boots normally. B. count the beeps and reference the service manual. C. disable the alarm within the server. D. install the server into a different rack.
The Polygonal Lasso Tool is used to draw straight lines and create segments of a selection border.
Answer the following statement true (T) or false (F)