Database Redistribution via Cost-Benefit Analysis

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

In dynamic database systems, efficiently managing the redistribution of database information across additional resources is challenging due to the need for cost-benefit analysis and consideration of access frequency, original resource amounts, and temporary resource additions, which affects database usage efficiency.

Innovation Solution

Implementing a resource management system that detects additional resources and performs a cost-benefit analysis to determine if database information should be redistributed, taking into account access frequency, original and additional resource amounts, and other factors to optimize database usage.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If database information is redistributed to additional resources, then database capacity and processing efficiency are improved, but redistribution costs and system complexity increase

Engineering Contradiction:

Improvedatabase processing efficiencyVSAvoidredistribution system complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The system automatically detects additional resources, evaluates redistribution opportunities, and executes data redistribution without manual intervention. The resource management system performs self-service by monitoring database performance metrics, identifying redistribution candidates, and managing the entire redistribution process autonomously based on predefined policies and cost-benefit analysis

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system performs preliminary evaluation and cost-benefit analysis before executing data redistribution. By assessing access frequency patterns, estimating redistribution costs, and predicting performance improvements in advance, the system determines whether redistribution should proceed, thereby avoiding unnecessary complexity from premature or unwarranted redistribution actions

Inventive Principle:

Principle #10Preliminary action

2Adaptability or versatility

If database information is redistributed frequently to accommodate temporary resources, then resource utilization is improved, but redistribution costs and performance disruption increase

Engineering Contradiction:

Improveresource utilization flexibilityVSAvoidredistribution cost

Core Design Contradiction:

Adaptability or versatilityVSLoss of energy

Solution Approach 1:

The system continuously monitors database access patterns, resource availability, and performance metrics to provide feedback for redistribution decisions. By tracking access frequency changes and resource lifecycle events (addition/removal), the system dynamically adjusts redistribution strategies, redistributing data only when access patterns indicate sustained benefit and resources are permanently available

Inventive Principle:

Principle #23Feedback

Solution Approach 2:

The system changes the parameter of redistribution timing by introducing thresholds and evaluation criteria. Instead of redistributing on every resource change event, the system evaluates multiple parameters including access frequency thresholds, resource permanence indicators, and cost-benefit ratios, redistributing only when parameter combinations indicate optimal conditions

Inventive Principle:

Principle #35Parameter changes

3Productivity

If comprehensive cost-benefit analysis is performed for each redistribution decision, then redistribution efficiency is improved, but analysis time and computational overhead increase

Engineering Contradiction:

Improveredistribution decision efficiencyVSAvoidanalysis time

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The system performs partial cost-benefit analysis by focusing evaluation on only those database objects that meet preliminary criteria (e.g., high access frequency, large size, cross-node distribution). Instead of analyzing all database objects comprehensively, the system applies full analysis only to candidate objects identified through preliminary filtering, reducing overall analysis time while maintaining decision quality for critical objects

Inventive Principle:

Principle #16Partial or excessive action

Data Source

PatentUS9141646B1Database redistribution in dynamically-configured database systems

Publication Date: 2015.09.22 TERADATA CORP

AI summary

A database system may implement resource management for redistribution of stored database information in additional database resources. Resource management may include detection of the presence of additional database resources, such as storage and processing resources. Based on conditions associated with the additional resources and database information selected for potential redistribution, resource management may include a determination as to whether or not redistribution of the database information is to be performed. Resource management may include a cost-benefit analysis to determine if redistribution of database information is to be performed. The cost-benefit analysis may be based on factors related to both the additional resources and the database information being considered for redistribution.