Database query processing with dynamically activated buffers

A method, apparatus and program product dynamically activate and/or deactivate buffers during execution of a database query. The dynamic deactivation and activation is based on the monitoring of information associated with the consumption of data by a plurality of threads during execution of an acce...

Full description

Saved in:
Bibliographic Details
Main Authors THIEMANN ULRICH, HU WEI, KETHIREDDY SHANTAN, KATHMANN KEVIN JAMES, CARLSON DAVID GLENN, PASSE ANDREW PETER
Format Patent
LanguageEnglish
Published 20.12.2011
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:A method, apparatus and program product dynamically activate and/or deactivate buffers during execution of a database query. The dynamic deactivation and activation is based on the monitoring of information associated with the consumption of data by a plurality of threads during execution of an access plan for the database query. By doing so, the selection of a less optimal buffer position during optimization may be replaced with a more optimal buffer position during runtime, often resulting in improved query performance and parallelism.
Bibliography:Application Number: US20080056344