Asynchronous task for energy cost aware database query optimization

This is an example of a new method for optimization of database queries which uses an asynchronous task which keeps the most current status of the database objects by directly interfacing the existing storage management system. This asynchronous task in combination with query plan and cache data is...

Full description

Saved in:
Bibliographic Details
Main Authors Thiemann, Ulrich, Hu, Wei, Kethireddy, Shantan, Passe, Andrew Peter, Bestgen, Robert Joseph
Format Patent
LanguageEnglish
Published 21.04.2009
Online AccessGet full text

Cover

More Information
Summary:This is an example of a new method for optimization of database queries which uses an asynchronous task which keeps the most current status of the database objects by directly interfacing the existing storage management system. This asynchronous task in combination with query plan and cache data is able to aid in detecting and choosing "warm" query costing alternatives. The cold/warm status information of the asynchronous task helps query optimizer to determine: if it is suitable to use "warm" costing for a new query optimization; validate previous decisions to use a "warm"-optimized query plan, when it comes to potentially reuse and run with such a plan again; decide whether it's worthwhile to still cache such a plan in the plan cache.