Asynchronous Database Persistence via In-Memory Buffering

The patent segments the persistence operation from the transaction processing flow. Changes are first applied to the in-memory target database portion, allowing immediate processing continuation. The persistent storage write is separated as an asynchronous background operation, eliminating the I/O wait from the critical transaction processing path while still ensuring durability through eventual persistence.

The patent performs preliminary action by pre-writing changes to the in-memory target database portion before persistent storage. This allows the system to have data ready for immediate use while the slower persistent write occurs in the background. The in-memory portion serves as a preliminary buffer that enables fast processing while persistence is being prepared.

The patent extracts the persistence overhead from the main transaction processing system. By using an asynchronous write mechanism for the target database changes, the logging and persistence operations are removed from the critical path. This reduces system overhead while maintaining consistency through the use of the in-memory portion as a buffer and recovery logs for the source database.

The in-memory target database portion acts as an intermediary between the source database changes and persistent storage. It buffers changes temporarily, allowing the system to decouple the timing of processing from the timing of persistence. This intermediary layer reduces overhead by batch processing and asynchronous writes rather than requiring synchronous persistence for each transaction.

The patent performs preliminary action by continuously maintaining an in-memory target database portion with recent changes from the source database. This pre-prepared in-memory buffer enables fast recovery after crashes because the system already has recent data ready in memory, requiring only the application of recovered log entries rather than full reconstruction. The in-memory portion serves as a preliminary recovery artifact that simplifies the recovery process.

The patent changes the state parameter of the target database by introducing an in-memory portion that exists in a different state than traditional persistent storage. This in-memory state allows for faster recovery operations because memory operations are significantly faster than disk I/O. The system leverages the parameter change from persistent to volatile storage to reduce recovery time and complexity while maintaining data availability through the duality of in-memory and persistent portions.