Disk Rotation Control for Database Storage Power Optimization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current technologies for reducing power consumption in storage systems that store databases face challenges in minimizing power usage while maintaining response rates, as existing methods either delay read responses or cannot control individual disk devices within the storage system.
Innovation Solution
A computer system with a disk rotation control part that manages the rotation speed of disk devices, allowing for slower speeds when not in use and faster speeds during access, based on query plans and processing progress to optimize power consumption and response times.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Use of energy by stationary object
If the power supply to a disk device is turned OFF to reduce power consumption, then power consumption is reduced, but the read response to the host machine becomes delayed when the disk device needs to be accessed
Solution Approach 1:
The system performs preliminary actions by predicting future disk access requests based on query plans and preprocessing data to be accessed. This allows the disk to be prepared in advance (rotated to correct position, data loaded to cache) before the actual access occurs, eliminating the need to keep the disk continuously rotating while maintaining quick response when access is needed.
Solution Approach 2:
The system dynamically adjusts disk rotation speed based on predicted access patterns. Instead of maintaining constant high-speed rotation, the disk rotates at variable speeds - faster when access is predicted soon, slower or stopped when no access is anticipated - thereby reducing overall power consumption while maintaining acceptable response times.
2Quantity of substance
If more disk devices are mounted to increase storage capacity, then storage capacity is increased, but power consumption increases due to the large amounts of power consumed by the rotating disk drives
Solution Approach 1:
The system predicts which disk devices will be accessed based on query plans and prepares only those specific disks in advance. This allows the system to keep fewer disks in active rotation at any given time, reducing the total power consumption of the storage system while maintaining the ability to serve multiple storage devices for high capacity.
Solution Approach 2:
Instead of uniformly managing all disk devices in the storage system, the system applies different rotation speeds and activation states to individual disks based on their predicted usage. High-utilization disks maintain faster rotation, while low-utilization disks slow down or stop, optimizing the overall power consumption of the storage system.
3Use of energy by stationary object
If disk rotation speed is reduced to lower power consumption, then power consumption is reduced, but the response rate of the storage system degrades
Solution Approach 1:
The system performs preliminary data preparation and disk positioning based on query plan analysis. By pre-loading data to cache and positioning disk heads before actual access requests arrive, the system can use slower rotation speeds without degrading the effective response rate, as the critical data is already prepared for immediate access.
Solution Approach 2:
The system maintains continuous useful action by keeping predicted-access data in cache memory and pre-positioning disk elements. This allows the main disk to rotate slower while the cache continues to provide fast access to frequently needed data, maintaining high productivity for the most critical operations while reducing overall power consumption.
Data Source
AI summary
A disk rotation control part for controlling the rotations of a plurality of disk devices is provided. The configuration is such that a disk of a disk device for which an access will not be generated is rotated at a second rate of speed, which is faster than 0, and slower than a first rate of speed, which is the rotation speed at access time. DB management information comprises information denoting which DB schema inside a DB is stored in which location. The disk rotation control part, based on a query plan of a query received by the DBMS, and DB management information, specifies the storage location of a DB schema to be accessed when this query is processed, and rotates a disk of the disk device comprising the specified storage location at a first rate of speed.