Oracle Region Cache Update via Benefit Parameter Evaluation

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing methods for updating the oracle region cache in databases, such as LFU and LRU algorithms, do not fully optimize cache utilization, leading to inefficiencies in query performance.

Innovation Solution

A method that calculates a benefit parameter for each region to be processed, considering both the benefit and cost of storing data in the oracle region cache, and updates the cache based on regions with the highest benefit parameter values.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If traditional cache update algorithms (LFU/LRU) are used, then cache update simplicity is maintained, but cache utilization rate is insufficient

Engineering Contradiction:
Improvecache utilization rateVSAvoidupdate algorithm complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent introduces a benefit parameter that dynamically evaluates regions based on multiple factors including data access frequency, data size, and cache capacity. This parameter-driven approach allows the system to adaptively select which regions to update in the cache, transforming the static LFU/LRU algorithms into a dynamic decision-making process that optimizes cache utilization without requiring complex structural changes to the cache mechanism itself.

Inventive Principle:
Principle #35Parameter changes

2Productivity

If all regions are updated in the oracle region cache, then query efficiency is improved, but cache capacity is wasted due to storing low-value data

Engineering Contradiction:
Improvequery efficiencyVSAvoidcache storage capacity
Core Design Contradiction:
ProductivityVSQuantity of substance

Solution Approach 1:

The patent applies local quality by evaluating each region individually using the benefit parameter, which considers local characteristics such as data access patterns, data size, and specific cache capacity availability. This allows different regions to be treated differently - high-benefit regions are prioritized for caching while low-benefit regions are excluded, thereby optimizing both query efficiency and storage capacity utilization without applying a uniform caching strategy.

Inventive Principle:
Principle #3Local quality

3Reliability

If the oracle region cache is frequently updated, then data freshness is improved, but system performance overhead increases

Engineering Contradiction:
Improvedata freshnessVSAvoidsystem performance overhead
Core Design Contradiction:
ReliabilityVSUse of energy by moving object

Solution Approach 1:

The patent implements partial action by updating only those regions that meet the benefit threshold, rather than performing full cache updates. The benefit parameter calculation identifies a subset of regions that provide the most value for caching, allowing the system to achieve data freshness for critical regions while avoiding the performance overhead of updating all regions. This selective update approach maintains reliability for important data while reducing overall system overhead.

Inventive Principle:
Principle #16Partial or excessive action

Data Source

PatentUS20250124029A1Method for processing oracle region cache electronic device, and storage medium
Publication Date: 2025.04.17 BEIJING BAIDU NETCOM SCI & TECH CO LTD
  • US20250124029A1 patent drawing
  • US20250124029A1 patent drawing
  • US20250124029A1 patent drawing

AI summary

Provided is a method for processing an oracle region cache, an electronic device and a storage medium, relating to the field of data processing technology, and in particular to the fields of big data, cloud computing, distributed database, intelligent search and other technologies. The method includes: obtaining a benefit parameter of a region to be processed, wherein the benefit parameter is used to represent a difference between benefit and cost of setting the region to be processed in the oracle region cache; and selecting the region to be processed to update the oracle region cache when the benefit parameter of the region to be processed meets a target condition.