Cache Update Control via Constraint Checking to Reduce Database Load
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional cache update methods in data analysis systems fail to control cache updates automatically based on time, leading to unintended database access loads during the development phase, which can result in incorrect analysis results and increased database load.
Innovation Solution
A data processing system with a cache management module that sets update constraints for cache updates, allowing updates only when permitted by the administrator, ensuring planned and controlled cache updates to reduce database access loads.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If cache update is performed automatically based on time lapse, then cache data freshness is improved, but database load increases during development phase
Solution Approach 1:
The patent introduces a cache management module as an intermediary between the database and the analysis system. This module controls cache updates by checking update constraints before allowing database access, thereby mediating between the need for fresh cache data and the need to reduce database load during development phase
Solution Approach 2:
The system dynamically adjusts cache update behavior based on the current phase (development vs. operation). During development phase, cache updates are restricted even if data is stale, while during operation phase, automatic updates based on time lapse are permitted, making the update policy flexible and context-dependent
2Object-generated harmful factors
If cache update is restricted during development phase, then database load is reduced, but cache data becomes stale
Solution Approach 1:
The system implements periodic cache updates based on update constraints that are checked before each update operation. The update determination module periodically evaluates whether cache update is permitted according to the constraints, allowing updates to occur at appropriate intervals when conditions are met
Solution Approach 2:
The system changes the update policy parameters based on the operational phase. The cache management module modifies update behavior by adjusting the applicability of update constraints, transitioning from restrictive updating during development phase to more permissive updating during operation phase
3Ease of operation
If manual cache update control is implemented, then update timing is controlled, but automation is reduced
Solution Approach 1:
The update determination module implements feedback by checking update constraints before each cache update operation. The system automatically evaluates the current state against the constraints and makes update decisions based on this feedback, combining automation with controlled timing
Solution Approach 2:
The cache management module serves itself by automatically managing update timing and constraints without requiring manual intervention. The system self-regulates cache updates based on the configured constraints, eliminating the need for manual update scheduling while maintaining control
Data Source
AI summary
A data processing system includes an analysis part cache that caches data of a database, a data processing development module that is used by a developer and develops analysis processing for data analysis, a data processing module that is used by the developer and performs data analysis by executing analysis processing, a cache management module that sets an update constraint input from a DB administrator regarding cache update from the database in the analysis part cache, and an update determination module that determines whether or not cache update is possible based on the update constraint, and when cache update is requested, the update determination module executes the requested cache update if cache update is possible in the determination.