Power-Based Query Cost Rules for Database Resource Control

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing database systems lack effective mechanisms for end users to configure cost rules based on query costs, leading to inefficiencies and potential misuse of resources.

Innovation Solution

Implementing a system that allows end users to configure cost thresholds and rules within a database system, utilizing query cost data to manage query execution and ensure compliance with provider-defined rules, including pre-execution and runtime compliance modules for query pricing.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If end users can configure cost thresholds and rules, then resource management efficiency and compliance control are improved, but system complexity increases due to additional configuration mechanisms

Engineering Contradiction:

Improvecompliance controlVSAvoidsystem complexity

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The compliance control system is segmented into multiple independent modules: cost threshold configuration module, query cost calculation module, compliance evaluation module, and enforcement module. Each module handles a specific aspect of compliance control, allowing the system to manage complexity through modular architecture while providing comprehensive compliance control capabilities.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

End users can pre-configure cost thresholds and compliance rules before query execution. The system stores these pre-defined rules and automatically applies them during query processing, eliminating the need for complex real-time compliance calculations and reducing system complexity during operation.

Inventive Principle:

Principle #10Preliminary action

2Productivity

If query cost data is collected and processed, then resource management efficiency is improved, but processing time and computational overhead increase

Engineering Contradiction:

Improveresource management efficiencyVSAvoidprocessing time

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

Query cost data is collected and processed in advance during query planning and optimization phases. The system pre-calculates cost estimates and stores them for later retrieval during query execution, reducing the time required for compliance evaluation and resource management during actual query processing.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The system implements feedback mechanisms where query cost data collected during execution is fed back to the optimization module. This feedback loop allows the system to learn from actual query performance and adjust future cost estimates, improving resource management efficiency while minimizing processing time through adaptive optimization.

Inventive Principle:

Principle #23Feedback

Data Source

PatentUS12443600B2End user configuration of cost rules in a database system with query costs based on power and methods for use therewith

Publication Date: 2025.10.14 OCIENT HOLDINGS LLC

AI summary

A database system operates by: receiving a query request from a requesting entity; determining the maximum query cost ruleset for the requesting entity by identifying one of the plurality of maximum query cost rulesets that corresponds to one of the corresponding plurality of end users associated with the requesting entity, wherein the maximum query cost ruleset for the requesting entity indicates a set of query function-based query cost rules corresponding to each of a set of query function types; generating query cost data by utilizing the query pricing scheme based on the query request and a power consumption; and generating maximum query cost compliance data based on determining whether the query cost data complies with the maximum query cost ruleset.