In-Memory Database Provisional Page Allocation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In-memory database systems face issues with long consistent changes that can block savepoints, leading to system hanging situations and inefficiencies in page allocation processes.
Innovation Solution
The solution involves allocating a provisional page in the database system, filling it with data, and then registering it without requiring consistent changes prior to registration, allowing for multiple provisional pages to be managed within a single consistent change, thereby avoiding long consistent changes and preventing savepoint blocking.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If pages are allocated and registered in the in-memory database system with traditional consistent change requirements, then data consistency is maintained, but savepoints are blocked leading to system hanging situations
Solution Approach 1:
The patent segments the page allocation and registration process into distinct phases: provisional page allocation without consistent change requirements, followed by later registration. This segmentation allows savepoints to proceed without being blocked by lengthy consistent change operations, while data consistency is maintained through the subsequent registration phase that includes proper consistent change handling.
2Stability of the object's composition
If consistent changes are required prior to page registration, then data integrity is ensured, but the critical savepoint phase is blocked causing system hanging
Solution Approach 1:
The patent applies preliminary action by allocating provisional pages before requiring consistent changes. Pages are allocated and made available for use in advance, without immediately requiring the time-consuming consistent change operation. The consistent change and registration occur later, allowing the critical savepoint phase to complete without blocking while data integrity is subsequently ensured.
Data Source
AI summary
A provisional page to be filled with data is allocated in an in-memory database system in which pages are loaded into memory and having associated physical disk storage a provisional page to be filled with data. Thereafter, the provisional page is filled with data. The provisional page is register after the provisional page has been filled with data such that consistent changes in the database are not required for the provisional page prior to the registering.