Database Query Plan Selection for Storage Power Optimization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In database management systems, query execution plans are generated without considering power saving functions, resulting in insufficient reduction of power consumption.
Innovation Solution
A computer system that includes a database server and a storage apparatus with a power saving function, where the database management system analyzes queries to create execution plans, identifies volumes for data access, calculates power consumption, and selects plans that meet a predetermined threshold, instructing the control unit to optimize data access based on these plans.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Speed
If query execution plans are generated to maximize processing performance, then processing speed is improved, but power consumption increases
Solution Approach 1:
The system dynamically adjusts query execution plans based on real-time storage device states (active/sleep modes). The optimization considers not only processing performance but also power consumption characteristics of storage devices at different operational states, enabling flexible adaptation to changing system conditions and energy availability.
Solution Approach 2:
The system changes optimization parameters from purely performance-based to include power consumption metrics. By incorporating storage device power states into the execution plan generation process, the system evaluates multiple plans with different power consumption profiles and selects the most appropriate one based on both performance requirements and energy constraints.
2Use of energy by moving object
If storage devices frequently switch between active and sleep modes to save power, then power consumption is reduced, but access time increases
Solution Approach 1:
The system performs preliminary assessment of storage device states before generating execution plans. By anticipating which storage devices will be in sleep mode and which will be active, the optimizer can proactively choose execution plans that avoid sleep mode devices or account for wake-up delays, thereby reducing actual access time while maintaining power savings.
Solution Approach 2:
The system introduces an intermediary optimization layer between query reception and execution plan generation. This intermediary process collects information about storage device power states and uses it to mediate the selection of execution plans, balancing the trade-off between power consumption and access time by choosing plans that appropriately utilize devices in different power states.
Data Source
AI summary
A computer system includes: a database server configured to execute a database management system; and a storage apparatus configured to store data. The storage apparatus is configured to have a power saving function for switching between a sleep mode for reducing power consumption of the storage apparatus and an active mode for enabling read and write of the data. The database management system is configured to be executed by the arithmetic device, to thereby: receive a query for reading or writing data; analyze the received query to create an execution plan; identify a volume for reading and writing data; and select an execution plan for which power consumption satisfies a predetermined threshold value based on power consumption information on the identified volume.