Aggregating database queries

Details Aggregating database queries Aggregating database queries

2011-06-07

2011-06-07

Mofiz, Apu M (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S718000, C707S719000, C707S720000, C707S721000

Reexamination Certificate

active

07958158

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.

REFERENCES:
patent: 5493670 (1996-02-01), Douglis et al.
patent: 2007/0100793 (2007-05-01), Brown et al.
“Reducing Energy Consumption of Queries in Memory Resident Database Systems” Pisharath et al., Copyright 2004 ACM.
U.S. Patent Application filed Jun. 19, 2008, “Grouping Predicted Database Queries” by Robert Joseph Bestgen et al, IBM.

Affiliated with

Also associated with

Rating

Aggregating database queries does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Aggregating database queries, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Aggregating database queries will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2691050