1/2/14 19
16
3
4
5 18
6
7
17 8
9
15
10
11
12
13

Crossword: Database Transactions

Across

1. The property that allows multiple transactions to execute concurrently without interfering with each other.

2. Techniques and mechanisms used to manage the simultaneous execution of transactions without interference or inconsistency.

3. A property of transactions that allows them to behave as if they were executed sequentially, even though they may be executed concurrently.

4. A concurrency control technique in database systems where transactions are ordered based on their timestamp values.

5. The process of performing multiple database operations as a single unit of work, ensuring consistency and integrity of data.

6. A process that reverses the effects of a transaction by applying the opposite changes recorded in the transaction log.

7. A point within a transaction where you can roll back a part of the transaction instead of the entire transaction.

8. A sequential record of all the changes made to a database, stored in the transaction log.

9. A set of properties that guarantee that database transactions are processed reliably.

10. The final step of a database transaction where all changes made within the transaction are permanently saved.

11. A file that contains a systematic record of events, actions, or observations.

12. A concurrency control protocol where a transaction acquires all its required locks before starting execution and releases them all at the end. It enforces serializability.

13. A mechanism used in the recovery process of a database to revert the effects of incomplete or aborted transactions.

Down

14. The property that ensures the database remains in a valid state after a transaction.

15. The process of recording events, activities, and information to a log file or transaction log.

16. The process of determining the order in which transactions should be executed in a database system.

17. The property that ensures that committed transactions survive permanent system failures.

18. The property of a transaction to be an indivisible operation, either all or none of its changes are applied.

19. A file that records all the transactions and activities in a database system.


🖶

Shortcuts

Left: ⇤ Right: ⇥ Up: ↑ Down: ↓