The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 06, 2011
Filed:
Jun. 19, 2008
Robert Joseph Bestgen, Rochester, MN (US);
Wei HU, Madison, WI (US);
Shantan Kethireddy, Chicago, IL (US);
Andrew Peter Passe, Rochester, MN (US);
Ulrich Thiemann, Rochester, MN (US);
Robert Joseph Bestgen, Rochester, MN (US);
Wei Hu, Madison, WI (US);
Shantan Kethireddy, Chicago, IL (US);
Andrew Peter Passe, Rochester, MN (US);
Ulrich Thiemann, Rochester, MN (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
Embodiments of the invention provide techniques for aggregating database queries for energy efficiency. In one embodiment, queries received by a DBMS are aggregated and staged according to hard-disk drives required for query execution. Each group of queries accessing a given drive may be dispatched for execution together. Further, the queries received by a DBMS may be matched to patterns of previously received queries. The matching patterns may be used to predict other queries which are likely to be received by the DBMS. The received queries may be staged to be dispatched with the predicted queries. By aggregating queries to be executed, access to each hard-disk drive may be optimized, thus reducing the overall energy consumption required for executing the queries.