No-force

A no-force policy is used in transaction control in database theory. The term no-force refers to the disk pages related to the actual database object being modified.

With a no-force policy, when a transaction commits, the changes made to the actual objects are not required to be written to disk in-place (forced).[1]

A record of the changes must still be preserved at commit time to ensure that the transaction is durable. This record is typically written to a sequential transaction log, with the actual changes to the database objects being changes which can be written at a later time.

For frequently changed objects, a no-force policy allows updates to be merged and so reduce the number of write operations to the actual database object. A no-force policy also reduces the seek time required for a commit by having mostly sequential write operations to the transaction log, rather than requiring the disk to seek to many distinct database objects during a commit.

References

  1. Gray, Jim; Reuter, Andreas (1993). "Chapter 13". Transaction Processing: Concepts and Techniques. Morgan Kaufmann. ISBN 1-55860-190-2.
This article is issued from Wikipedia - version of the 4/18/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.