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

Abstract 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.
AbstractList 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.
Author HU WEI
PASSE ANDREW PETER
THIEMANN ULRICH
KETHIREDDY SHANTAN
CARLSON DAVID GLENN
KATHMANN KEVIN JAMES
Author_xml – fullname: THIEMANN ULRICH
– fullname: HU WEI
– fullname: KETHIREDDY SHANTAN
– fullname: KATHMANN KEVIN JAMES
– fullname: CARLSON DAVID GLENN
– fullname: PASSE ANDREW PETER
BookMark eNrjYmDJy89L5WSwcUksSUxKLE5VKCxNLapUKCjKT04tLs7MS1cozyzJUEipzEvMzUxOzMmpVEhMLsksSyxJTVFIKk1LSy0q5mFgTUvMKU7lhdLcDApuriHOHrqpBfnxqcUFicmpeakl8aHBFgYWRkZmpk5GxkQoAQDaCTHu
ContentType Patent
DBID EVB
DatabaseName esp@cenet
DatabaseTitleList
Database_xml – sequence: 1
  dbid: EVB
  name: esp@cenet
  url: http://worldwide.espacenet.com/singleLineSearch?locale=en_EP
  sourceTypes: Open Access Repository
DeliveryMethod fulltext_linktorsrc
Discipline Medicine
Chemistry
Sciences
Physics
ExternalDocumentID US8082265B2
GroupedDBID EVB
ID FETCH-epo_espacenet_US8082265B23
IEDL.DBID EVB
IngestDate Fri Jul 19 13:59:21 EDT 2024
IsOpenAccess true
IsPeerReviewed false
IsScholarly false
Language English
LinkModel DirectLink
MergedId FETCHMERGED-epo_espacenet_US8082265B23
Notes Application Number: US20080056344
OpenAccessLink https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20111220&DB=EPODOC&CC=US&NR=8082265B2
ParticipantIDs epo_espacenet_US8082265B2
PublicationCentury 2000
PublicationDate 20111220
PublicationDateYYYYMMDD 2011-12-20
PublicationDate_xml – month: 12
  year: 2011
  text: 20111220
  day: 20
PublicationDecade 2010
PublicationYear 2011
RelatedCompanies INTERNATIONAL BUSINESS MACHINES CORPORATION
HU WEI
PASSE ANDREW PETER
THIEMANN ULRICH
KETHIREDDY SHANTAN
CARLSON DAVID GLENN
KATHMANN KEVIN JAMES
RelatedCompanies_xml – name: INTERNATIONAL BUSINESS MACHINES CORPORATION
– name: KETHIREDDY SHANTAN
– name: CARLSON DAVID GLENN
– name: PASSE ANDREW PETER
– name: KATHMANN KEVIN JAMES
– name: THIEMANN ULRICH
– name: HU WEI
Score 2.8364925
Snippet A method, apparatus and program product dynamically activate and/or deactivate buffers during execution of a database query. The dynamic deactivation and...
SourceID epo
SourceType Open Access Repository
SubjectTerms CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Title Database query processing with dynamically activated buffers
URI https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20111220&DB=EPODOC&locale=&CC=US&NR=8082265B2
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1La8MwDBale962bqPdCx9GbmFJmqQpLAzyKGXQB2szeit27EKhpKFJN_rvJ7uP7bJdbZBlwyfZsqQP4Cm1hLBnoqWbtCnwgWKbOmNNS2eSKMejzDIUHVCv73YT-23iTCow39fCqD6hX6o5IiIqRbyXyl7nP0GsSOVWFs9sjkPL187YjzS-D_eZlmVoUeDHw0E0CLUw9JOR1n_3PdnZ3HUCtNZH8hYt2-zHH4EsSsl_e5TOBRwPUVhWXkJFZDU4C_fEazU47e3-u2twohI00wIHdyAsruAloiWV3oegTV9tSL7N9UcfRGRUlfAtyTxdLDZEli184kKcsLVkQimugXTicdjVUaHpYfPTZHRQvXkD1WyZiToQR7B2ynjLo9yxU4e2OfVcA41oa8aFY5sNaPwp5vafuTs4V0FT00L43EO1XK3FA3rdkj2q8_oGU5aI7g
link.rule.ids 230,309,786,891,25594,76903
linkProvider European Patent Office
linkToHtml http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1La8JAEB7EPuyttS3a5x5KbqEmJiZCQ8FEsa0valK8yW52BUGimNjiv-_s-mgv7XUWdmcXvhlmdmY-gIfYFMKaCEc3aFVggGIZOmNVU2eSKMelzKwoOqBur9aOrNeRPcrBdNcLo-aEfqnhiIioGPGeKXu9-EliBaq2Mn1kUxTNn1uhF2h8l-4zTLOiBQ2vOegHfV_zfS8aar13z5WTzWt2A631gYMRoYqUPhqyKWXx26O0TuFwgJsl2RnkRFKEgr8jXivCcXf7312EI1WgGaco3IIwPYengGZUeh-CNn25JotNrT_6ICKzqoRvSObpbLYmsm3hEw_ihK0kE0p6AaTVDP22jgqN95cfR8O96tVLyCfzRJSA2ILVY8Ydl3Lbim1a59StVdCIOhMubMsoQ_nPba7-WbuHQjvsdsadl97bNZyoBKphIpRuIJ8tV-IWPXDG7tTbfQPgSIvY
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Apatent&rft.title=Database+query+processing+with+dynamically+activated+buffers&rft.inventor=THIEMANN+ULRICH&rft.inventor=HU+WEI&rft.inventor=KETHIREDDY+SHANTAN&rft.inventor=KATHMANN+KEVIN+JAMES&rft.inventor=CARLSON+DAVID+GLENN&rft.inventor=PASSE+ANDREW+PETER&rft.date=2011-12-20&rft.externalDBID=B2&rft.externalDocID=US8082265B2