Solid State Drive Query Execution During Data Retention Scans
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
There is a need for a system and method to efficiently execute non-time-sensitive queries in storage devices without transitioning from power save mode, as frequent transitions consume power and can lead to data corruption.
Innovation Solution
A solid-state drive system that determines whether a query is time-sensitive and executes read operations during a scheduled data retention scan, allowing for delayed execution and sharing of read operations with other queries or scans, thereby avoiding unnecessary power mode transitions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Speed
If the storage device transitions from power save mode to normal mode to execute queries, then query execution speed is improved, but power consumption increases
Solution Approach 1:
The system performs preliminary classification of queries to identify non-time-sensitive queries before they are executed. By determining the time-sensitivity characteristic in advance, the system can defer execution of non-critical queries until a data retention scan is scheduled, avoiding unnecessary power mode transitions and reducing overall power consumption while maintaining acceptable performance for time-sensitive operations.
Solution Approach 2:
The system merges the execution of non-time-sensitive queries with the periodic data retention scan operation. By combining these two separate operations into a single execution phase, the system eliminates redundant power mode transitions and utilizes the already-activated normal mode during data retention scans to process accumulated non-time-sensitive queries, thereby reducing power consumption without sacrificing data integrity.
2Loss of time
If the storage device frequently transitions between power save mode and normal mode, then query responsiveness is improved, but data corruption risk increases
Solution Approach 1:
The system performs preliminary classification of queries to identify non-time-sensitive queries before execution. This advance identification allows the system to defer these queries until a data retention scan is scheduled, reducing the frequency of power mode transitions and thereby lowering the risk of data corruption while maintaining acceptable responsiveness for time-sensitive operations.
Solution Approach 2:
The system implements a feedback mechanism where query execution decisions are based on the current operational state and scheduled data retention scan timing. By continuously monitoring whether a data retention scan is scheduled and adjusting query execution timing accordingly, the system minimizes unnecessary power mode transitions and associated data corruption risks while maintaining appropriate response times for time-sensitive queries.
3Use of energy by moving object
If non-time-sensitive queries are executed during data retention scans, then power consumption is reduced, but query execution time increases
Solution Approach 1:
The system performs preliminary classification of queries to identify non-time-sensitive queries before they are executed. By determining the time-sensitivity characteristic in advance, the system can strategically defer execution of non-critical queries until a data retention scan is scheduled, optimizing power consumption without causing unacceptable delays for time-sensitive operations.
Solution Approach 2:
The system changes the execution timing parameter for non-time-sensitive queries from immediate execution to deferred execution during data retention scans. This parameter change optimizes power consumption by eliminating unnecessary power mode transitions, while the non-time-sensitive nature of these queries ensures that the delayed execution does not result in unacceptable performance degradation.
Data Source
AI summary
A system and method for combining the execution of a query with other operations, such as a data retention scan, in a storage device, when the execution of the query is not time-sensitive. The storage device may be connected to a host, and may operate during intervals of time in a power save mode. When a query is received by the host that is not time-sensitive, the query may be stored in the host or in the storage device until such time as the device would otherwise return to a normal operating mode, and then the query may be executed. Such delayed execution may enable the sharing of read operations for the query with read operations used, for example, for the execution of other queries or for a data retention scan.


