Embedded database gains transaction logging
Jun 15, 2004 — by LinuxDevices Staff — from the LinuxDevices Archive — viewsMcObject is beta testing a new version of its in-memory embedded database. The principal new feature of eXtremeDB 2.3 is transaction logging to persistent media. The software supports Linux and other embedded OSes.
Version 2.3 supports configurable logging, in which transactions are recorded to non-volatile storage as they occur. Configuration options include:
- Configurable transaction durability — Different levels of “transaction durability” allow system designers to balance performance with the risk of unrecoverable transactions;
- Deferred cleanup — Log rotation can be synchronized with checkpoint completion, or delegated to a background task;
- Wide-ranging control parameters — Configurable transaction logging control parameters include depth of the recovery tree and maximum transaction log file size.
McObject says database read performance is unaffected by transaction logging and, while developers have control over the degree of the logging's impact on database writes, write performance far exceeds traditional disk-based databases in all cases. Logging for eXtremeDB is said to require only a single write to persistent media, versus the many writes required by disk-based databases for data pages and index pages modified during the transaction.
Prospective beta testers can find more information online. The stable version of eXtremeDB is available under royalty-free licensing.
This article was originally published on LinuxDevices.com and has been donated to the open source community by QuinStreet Inc. Please visit LinuxToday.com for up-to-date news and articles about Linux and open source.