The difference between theft and force in the database

Question

They say that no theft means that the updated transaction buffer is not written to disk before the transaction is completed, and no force has a similar definition, but what is the difference between them?

Answer 1

Suppose transaction T1 wants to read data object X, but the working memory is full of all the work of other transactions. Therefore, T1 needs to clear some memory, which it does by deleting another working memory in stable storage. This can be dangerous because we cannot be sure that T1 is moving towards stable storage. This is known as theft.

, , , . , .

steal/no-force, , , , , .