Exercise 11

1. ACID Properties and TP monitoring

ACID stands for Automicity, Consistency, Isolation, Durability.

• Automicity - The ability for a transaction to be fully processed and completed or cancelled or rolled back to ensure data integrity.
• Consistency - The data of a transaction must be left in a continuous stable state until the transaction is completed.
• Isolation - A transaction must be isolated while being processed, ensuring it is not interrupted or modified by any process or other transactions.
• Durability - Transactions must not be able to be changed due to hardware failure and system crashes or the like. Other transactions must still be able to alter the processed data.

TP stands for Transaction Process monitoring. A transaction process monitor is used to ensure data integrity in a multi-threaded environment. A distributed client/server system is an example of a TP where all transactions are enforced with the properties of ACID. A TP monitor schedules threads and processes to evenly spread the processing load to ensure that an operating system is not overwhelmed.