Greedy Search for Storage Configuration Optimization

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Computer systems with limited storage resources face challenges in optimizing data storage configurations, as administrators often rely on guesswork to determine which data to store in limited spaces, leading to inefficient use of resources and potential performance issues.

Innovation Solution

A method using a 'greedy search' algorithm to generate storage recommendations by calculating performance benefits and storage costs for different configurations, recommending optimal data storage options across various storage sizes, including compression techniques and distribution methods, to efficiently utilize storage resources.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If methodical comparison of different data storage combinations is performed to identify optimal configuration, then storage optimization accuracy is improved, but time consumption increases significantly

Engineering Contradiction:
Improvestorage optimization accuracyVSAvoidtime consumption
Core Design Contradiction:
Measurement precisionVSLoss of time

Solution Approach 1:

The system pre-calculates and stores performance metrics for individual data elements and storage configurations before optimization is needed. When optimization is required, the pre-computed data enables rapid comparison and selection of optimal configurations without performing exhaustive testing at that moment.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

Instead of testing actual data storage configurations which would be time-consuming, the system uses surrogate models or simplified representations to evaluate storage options. The greedy search algorithm evaluates copies or proxies of storage configurations to identify optimal solutions without committing actual resources during the evaluation phase.

Inventive Principle:
Principle #26Copying

2Productivity

If exhaustive testing of storage configurations is performed to ensure optimal performance, then system performance optimization is improved, but computational resources and time required increase

Engineering Contradiction:
Improvesystem performanceVSAvoidcomputational time
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The greedy search algorithm performs partial evaluation of storage configurations by considering only the most promising options at each step rather than exhaustively testing all possibilities. It makes locally optimal choices that lead to near-global optima, achieving sufficient performance improvement without the computational cost of complete enumeration.

Inventive Principle:
Principle #16Partial or excessive action

Solution Approach 2:

The system changes evaluation parameters dynamically during the optimization process, adjusting criteria for what constitutes an acceptable configuration. The greedy approach modifies search parameters to focus computational effort on high-promise regions of the configuration space, avoiding wasted computation on clearly suboptimal options.

Inventive Principle:
Principle #35Parameter changes

3Device complexity

If administrators manually guess storage configurations to fit limited storage space, then system complexity is reduced, but storage resource utilization efficiency deteriorates

Engineering Contradiction:
Improveconfiguration complexityVSAvoidstorage resource utilization
Core Design Contradiction:
Device complexityVSProductivity

Solution Approach 1:

The system performs self-optimization by automatically analyzing storage requirements and selecting optimal configurations without requiring administrator intervention. The greedy search algorithm autonomously evaluates data elements, determines which should be stored in limited-space storage, and configures compression and distribution parameters automatically.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The manual administrative process of guessing configurations is replaced with an automated computational system. The mechanical act of administrator analysis and decision-making is substituted with algorithmic evaluation that objectively assesses storage options based on predefined performance criteria and resource constraints.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS10466936B2Scalable, multi-dimensional search for optimal configuration
Publication Date: 2019.11.05 ORACLE INT CORP
  • US10466936B2 patent drawing
  • US10466936B2 patent drawing
  • US10466936B2 patent drawing

AI summary

According to an embodiment, storage configurations are identified for storing items, such as database tables, partitions, or any other types of objects or data structures, within a desired storage area, such as an in-memory data store or any other limited storage resource. Each of the storage configurations is assigned to a particular item of the items. Each of the storage configurations associates the assigned particular item with one or more storage configuration options. Storage recommendations are generated for at least a set of the storage configurations. A different storage recommendation exists for each storage configuration in the set of the storage configurations. The storage recommendation associates the storage configuration with a range of possible storage sizes for a particular storage area of a system. Based on the storage recommendations, recommended system configurations a generated for different possible storage sizes of the particular storage area.