Aggregating Database Queries
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...
Saved in:
Main Authors | , , , , |
---|---|
Format | Patent |
Language | English |
Published |
24.12.2009
|
Subjects | |
Online Access | Get full text |
Cover
Loading…
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. |
---|---|
AbstractList | 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. |
Author | HU WEI PASSE ANDREW PETER THIEMANN ULRICH KETHIREDDY SHANTAN BESTGEN ROBERT JOSEPH |
Author_xml | – fullname: THIEMANN ULRICH – fullname: HU WEI – fullname: BESTGEN ROBERT JOSEPH – fullname: KETHIREDDY SHANTAN – fullname: PASSE ANDREW PETER |
BookMark | eNrjYmDJy89L5WSQcUxPL0pNTyzJzEtXcEksSUxKLE5VCCxNLcpMLeZhYE1LzClO5YXS3AzKbq4hzh66qQX58anFBYnJqXmpJfGhwUYGBpbGhpYm5iaOhsbEqQIA-4ImVg |
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 | US2009319474A1 |
GroupedDBID | EVB |
ID | FETCH-epo_espacenet_US2009319474A13 |
IEDL.DBID | EVB |
IngestDate | Fri Jul 19 16:29:39 EDT 2024 |
IsOpenAccess | true |
IsPeerReviewed | false |
IsScholarly | false |
Language | English |
LinkModel | DirectLink |
MergedId | FETCHMERGED-epo_espacenet_US2009319474A13 |
Notes | Application Number: US20080142182 |
OpenAccessLink | https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20091224&DB=EPODOC&CC=US&NR=2009319474A1 |
ParticipantIDs | epo_espacenet_US2009319474A1 |
PublicationCentury | 2000 |
PublicationDate | 20091224 |
PublicationDateYYYYMMDD | 2009-12-24 |
PublicationDate_xml | – month: 12 year: 2009 text: 20091224 day: 24 |
PublicationDecade | 2000 |
PublicationYear | 2009 |
Score | 2.76153 |
Snippet | Embodiments of the invention provide techniques for aggregating database queries for energy efficiency. In one embodiment, queries received by a DBMS are... |
SourceID | epo |
SourceType | Open Access Repository |
SubjectTerms | CALCULATING CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION ANDCOMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION ANDCOMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THIR OWNENERGY USE COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS PHYSICS TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINSTCLIMATE CHANGE |
Title | Aggregating Database Queries |
URI | https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20091224&DB=EPODOC&locale=&CC=US&NR=2009319474A1 |
hasFullText | 1 |
inHoldings | 1 |
isFullTextHit | |
isPrint | |
link | http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1LS8NAEB5Kfd40Kj6iBJTcgnWzMeYQpM2DIvShbaS3srvdFEFiMSn-fWeXRHvqdRf2xc7Mzn4z3wDc8QWXHSJQ-wkFMxLPdRh_II56WrOOgiADlZw8GD72M_oy82Yt-GxyYTRP6I8mR0SJEijvldbXq_9PrFjHVpb3_AObvp7TaRjbjXccKKDIjnthMh7Fo8iOojCb2MM33Ye3jfq0i77SjnpIK6b95L2n8lJWm0YlPYLdMY5XVMfQkoUBB1FTe82A_UENeRuwp2M0RYmNtRyWJ2B2l-gnK3KMYmnFrGLKGFmva8VaXJ7CbZpMo76DE87_9jfPJpurc8-gjZ6_PAfLdzl9YoLleS5p7lPmiYUvAkGIL-Qi9y7A3DbS5fbuKzgkdTEEQk1oV99reY0WtuI3-mB-AcnFfhs |
link.rule.ids | 230,309,786,891,25594,76903 |
linkProvider | European Patent Office |
linkToHtml | http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1LT4NAEJ409VFvWjU-UEk03BrrsogciGmhBLXQasH0RpYFGhODjdD4953dtNpTrzvJ7CM7M_vtvABu0izNu4Sj9uPCzUgMvcPSO9IRT2vWFS5ISyQnB-G9H9PnqTFtwOcqF0bWCf2RxRFRojjKey319fz_E8uVsZXVbfqBQ1-PXmS72godW8JRpLl9ezAeuSNHcxw7nmjhm6ThbaMm7SFW2jIRFEqw9N4XeSnzdaPi7cP2GPmV9QE08rINLWfVe60Nu8HS5d2GHRmjySscXMphdQhKb4Y4WRTHKGeqy2omjJH6uhBVi6sjuPYGkeN3cMLkb39JPFlfnX4MTUT--Qmopp7SB8ZZURQ5LUzKDJ6Z3OKEmDzPCuMUlE2czjaTr6DlR8EwGT6FL-ewR5aNEQhVoFl_L_ILtLZ1eikP6RfUD4EF |
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=Aggregating+Database+Queries&rft.inventor=THIEMANN+ULRICH&rft.inventor=HU+WEI&rft.inventor=BESTGEN+ROBERT+JOSEPH&rft.inventor=KETHIREDDY+SHANTAN&rft.inventor=PASSE+ANDREW+PETER&rft.date=2009-12-24&rft.externalDBID=A1&rft.externalDocID=US2009319474A1 |