SQL Execution Plan Baselines

Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a database server may only execute a command according to a baseline plan, even if the database server predicts that a different plan has a lower c...

Full description

Saved in:
Bibliographic Details
Main Authors YAGOUB KHALED, ZAIT MOHAMED, BELKNAP PETER, ZHU YALI, SU HONG, ZIAUDDIN MOHAMED, OZBUTUN CETIN, DAS DINESH
Format Patent
LanguageEnglish
Published 23.04.2009
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

Abstract Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a database server may only execute a command according to a baseline plan, even if the database server predicts that a different plan has a lower cost. The set of baseline plans are plans that, for one reason or another, have been determined to provide acceptable actual performance in at least one execution context. When the database server receives a request to execute a particular command, the database server, if possible, always executes the command according to the lowest predicted cost baseline plan. The database server may evolve the plan baseline to include additional plans by generating and testing new plans in response to new requests to execute the database command, or as part of a query optimization or tuning process.
AbstractList Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a database server may only execute a command according to a baseline plan, even if the database server predicts that a different plan has a lower cost. The set of baseline plans are plans that, for one reason or another, have been determined to provide acceptable actual performance in at least one execution context. When the database server receives a request to execute a particular command, the database server, if possible, always executes the command according to the lowest predicted cost baseline plan. The database server may evolve the plan baseline to include additional plans by generating and testing new plans in response to new requests to execute the database command, or as part of a query optimization or tuning process.
Author OZBUTUN CETIN
YAGOUB KHALED
DAS DINESH
ZAIT MOHAMED
ZIAUDDIN MOHAMED
BELKNAP PETER
SU HONG
ZHU YALI
Author_xml – fullname: YAGOUB KHALED
– fullname: ZAIT MOHAMED
– fullname: BELKNAP PETER
– fullname: ZHU YALI
– fullname: SU HONG
– fullname: ZIAUDDIN MOHAMED
– fullname: OZBUTUN CETIN
– fullname: DAS DINESH
BookMark eNrjYmDJy89L5WSQCQ70UXCtSE0uLcnMz1MIyEnMU3BKLE7NycxLLeZhYE1LzClO5YXS3AzKbq4hzh66qQX58anFBYnJqXmpJfGhwUYGBpaGBmbGBmaOhsbEqQIAxs0l0A
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 US2009106306A1
GroupedDBID EVB
ID FETCH-epo_espacenet_US2009106306A13
IEDL.DBID EVB
IngestDate Fri Jul 19 16:19:28 EDT 2024
IsOpenAccess true
IsPeerReviewed false
IsScholarly false
Language English
LinkModel DirectLink
MergedId FETCHMERGED-epo_espacenet_US2009106306A13
Notes Application Number: US20080188678
OpenAccessLink https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20090423&DB=EPODOC&CC=US&NR=2009106306A1
ParticipantIDs epo_espacenet_US2009106306A1
PublicationCentury 2000
PublicationDate 20090423
PublicationDateYYYYMMDD 2009-04-23
PublicationDate_xml – month: 04
  year: 2009
  text: 20090423
  day: 23
PublicationDecade 2000
PublicationYear 2009
Score 2.7365465
Snippet Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a...
SourceID epo
SourceType Open Access Repository
SubjectTerms CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Title SQL Execution Plan Baselines
URI https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20090423&DB=EPODOC&locale=&CC=US&NR=2009106306A1
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1LS8QwEB6W9XnTqvioUlB6K7pNGttDEftiEfeh3creljSmIMi62Ir-fCdhq3vaawJ5kcnkm5lvBuCKoRLl9JU5XHIEKC7Fd5BWntOrqECNdBP4RBGcB0PWL-jD1Jt24L3lwug8od86OSJKlEB5b_R7vfg3YiU6trK-Lt-w6eMum4SJ3aLjQIV52EkUpuNRMortOA6L3B4-676eyi_F7hErbeBH-lbJQ_oSKV7KYlWpZHuwOcbx5s0-dOTcgJ24rb1mwPZg6fI2YEvHaIoaG5dyWB-AmT89WumPFPraWKrykBVxzS2X9SFcZukk7js44exvf7MiX10dOYIuIn95DJZX-YITKqSy-OHXoWSKO1oSEQhG_co9AXPdSKfru89gt3WNuMSEbvP5Jc9RwzblhT6YX2uke9E
link.rule.ids 230,309,783,888,25576,76876
linkProvider European Patent Office
linkToHtml http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1LT4NAEJ409VFvipqqqCQabkQLW4QDMfIKKtAqremNwLokJqY2gtGf7-ymaE-97ib7ys7OfjPzzQBcmqhEC_JqagUrEKDoBN9BUg21QUUoaqRr2zI4wTlJzWhKHmbDWQfeWy6MyBP6LZIjokRRlPdGvNeLfyOWL2Ir66vyDZs-bsOJ46stOrZ5mIfqu04wHvkjT_U8Z5qp6bPoG_D8UuYdYqUN_GTfcHkIXlzOS1msKpVwFzbHON682YMOm0vQ89raaxJsJ0uXtwRbIkaT1ti4lMN6H-TsKVaCH0bFtVF45SHFLQS3nNUHcBEGEy_ScML8b3_5NFtdnXEIXUT-rA_KsLJoYRDKuMUPvw6lybmjpUFtahKr0o9AXjfS8fruc-hFkyTO4_v08QR2WjeJbsjQbT6_2Clq26Y8E4f0C2UJfsQ
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=SQL+Execution+Plan+Baselines&rft.inventor=YAGOUB+KHALED&rft.inventor=ZAIT+MOHAMED&rft.inventor=BELKNAP+PETER&rft.inventor=ZHU+YALI&rft.inventor=SU+HONG&rft.inventor=ZIAUDDIN+MOHAMED&rft.inventor=OZBUTUN+CETIN&rft.inventor=DAS+DINESH&rft.date=2009-04-23&rft.externalDBID=A1&rft.externalDocID=US2009106306A1