Grouping predicted database queries

A computer readable storage medium containing a program which, when executed, performs an operation, comprising:

• receiving at least one query for a database;
• determining data elements required to execute the at least one query;
• matching the received at least one query to a pattern of previously executed queries;
• predicting, based on the matching pattern, attributes of one or more queries to be subsequently received;
• determining, based on the predicted attributes, data elements required to execute the one or more subsequent queries;
• determining a grouping of the one or more subsequent queries with the at least one received query, such that each query in the grouping will require one or more data elements stored in a common storage device in order to be executed, the grouping being performed on the basis of an objective to reduce energy consumption;
• receiving the one or more subsequent queries;
• and
• adding to a queue, according to the determined grouping, the one or more subsequent queries with the at least one received query.

A system, comprising:

• a database;
• a processor;
• and
• a memory containing a program, which when executed by the processor is configured to perform an operation, comprising:
• receiving at least one query for a database;
• determining data elements required to execute the at least one query;
• matching the received at least one query to a pattern of previously executed queries;
• predicting, based on the matching pattern, attributes of one or more queries to be subsequently received;
• determining, based on the predicted attributes, data elements required to execute the one or more subsequent queries;
• determining a grouping of the one or more subsequent queries with the at least one received query, such that each query in the grouping will require one or more data elements stored in a common storage device in order to be executed, the grouping being performed on the basis of an objective to reduce energy consumption;
• receiving the one or more subsequent queries;
• and
• adding to a queue, according to the determined grouping, the one or more subsequent queries with the at least one received query.