Method and apparatus for query optimization and management of sleepy drives
View Patent ↗The invention, in an embodiment, relates to optimizing database performance by taking advantage of sleepy drives. The invention analyzes queries to indexes based on usage frequency, and determines whether to access an index stored on a sleepy drive, or perform an alternate access plan based on green optimization. Furthermore, the invention transfers data, such as, for example, indexes, files, data areas, journals, and statistics, between active and sleepy drives based on usage frequency. In another embodiment, the invention provides an improved sleepy drive which optimizes energy savings by a graduated degree based on a speed setting. In yet another embodiment, the invention controls when read-write heads are unloaded from disks to reduce drag and power consumption by a disk drive.
1. A method of reducing the power consumption of a computer device, comprising:
receiving a plurality of queries from a processor, each query directed to an index stored on one of an active drive or a sleeping drive;
generating a log storing a history of the plurality of queries to the index;
determining, using the log, if the index is infrequently used, frequently used, or intermittently used;
transferring the index from the sleeping drive to the active drive when the index is frequently used;
transferring the index from the active drive to the sleeping drive when the index is infrequently used;
determining a future query request based on the log; and
temporarily transferring, in anticipating of the future query request, the index from the sleeping drive to an active drive;
wherein the index provides rapid access to data identified by the plurality of queries, the data stored in one of the active or sleeping drives and wherein the index points to a storage location for the data.