Directory

Encyclopedia

NodeWorks
                              ENCYCLOPEDIA

Link Checker

Home
Encyclopedia : W : WR : WRI :

Write ahead logging

 

Write ahead logging

In computer science, Write Ahead Logging (WAL) is a family of techniques for providing atomicity and
durability (two of the ACID properties) in database systems.

In a system using WAL, all modifications are written to a log before they are applied to the database. Usually both redo and undo information is stored in the log.

The motivation for WAL is to allow updates of the database to be done in-place. The other obvious way to implement atomic update is with shadow paging, which is not in-place. The main advantage of doing updates in-place is it reduces the need to modify indexes and block lists.

ARIES is a popular algorithm in the WAL family.


NodeWorks boosts web surfing!
Page Returned in 0.971 seconds - HTML Compressed 68.7%

This article is from Wikipedia. All text is available
under the terms of the GNU Free Documentation License.
 GNU Free Documentation License
© 2008 Chamas Enterprises Inc.