TECHNIQUE FOR FACTORING UNCERTAINTY INTO COST-BASED QUERY OPTIMIZATION

TECHNIQUE FOR FACTORING UNCERTAINTY INTO COST-BASED QUERY OPTIMIZATION

A technique for factoring uncertainty into cost-based query optimization includes: determining the degree of uncertainty involved in the cost estimates for the query, determining the degree of sensitivity the query has to that uncertainty, and determining if there is an access path that performs wel...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: PURCELL TERENCE P, BEAVIN THOMAS A, ALPERS JASON L, GUO SHUANGLIN, BOSSMAN PATRICK D
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator PURCELL TERENCE P
BEAVIN THOMAS A
ALPERS JASON L
GUO SHUANGLIN
BOSSMAN PATRICK D
description A technique for factoring uncertainty into cost-based query optimization includes: determining the degree of uncertainty involved in the cost estimates for the query, determining the degree of sensitivity the query has to that uncertainty, and determining if there is an access path that performs well across the range of possible conditions that could occur at execution time, reducing the risk of performance spikes and performance volatility. If such an access path exists, select that access path; if not, perform parametric query optimization or query re-optimization.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US2014108378A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US2014108378A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US2014108378A13</originalsourceid><addsrcrecordid>eNrjZHALcXX28PMMDHVVcPMPUnBzdA7xD_L0c1cI9XN2DQpx9PQLiVQAEv4Kzv7BIbpOjsGuLgpA1UGRCv4BIZ6-nlGOIZ7-fjwMrGmJOcWpvFCam0HZzTXE2UM3tSA_PrW4IDE5NS-1JD402MjA0MTQwMLY3MLR0Jg4VQCZsC3B</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>TECHNIQUE FOR FACTORING UNCERTAINTY INTO COST-BASED QUERY OPTIMIZATION</title><source>esp@cenet</source><creator>PURCELL TERENCE P ; BEAVIN THOMAS A ; ALPERS JASON L ; GUO SHUANGLIN ; BOSSMAN PATRICK D</creator><creatorcontrib>PURCELL TERENCE P ; BEAVIN THOMAS A ; ALPERS JASON L ; GUO SHUANGLIN ; BOSSMAN PATRICK D</creatorcontrib><description>A technique for factoring uncertainty into cost-based query optimization includes: determining the degree of uncertainty involved in the cost estimates for the query, determining the degree of sensitivity the query has to that uncertainty, and determining if there is an access path that performs well across the range of possible conditions that could occur at execution time, reducing the risk of performance spikes and performance volatility. If such an access path exists, select that access path; if not, perform parametric query optimization or query re-optimization.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2014</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20140417&amp;DB=EPODOC&amp;CC=US&amp;NR=2014108378A1$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25564,76547</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20140417&amp;DB=EPODOC&amp;CC=US&amp;NR=2014108378A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>PURCELL TERENCE P</creatorcontrib><creatorcontrib>BEAVIN THOMAS A</creatorcontrib><creatorcontrib>ALPERS JASON L</creatorcontrib><creatorcontrib>GUO SHUANGLIN</creatorcontrib><creatorcontrib>BOSSMAN PATRICK D</creatorcontrib><title>TECHNIQUE FOR FACTORING UNCERTAINTY INTO COST-BASED QUERY OPTIMIZATION</title><description>A technique for factoring uncertainty into cost-based query optimization includes: determining the degree of uncertainty involved in the cost estimates for the query, determining the degree of sensitivity the query has to that uncertainty, and determining if there is an access path that performs well across the range of possible conditions that could occur at execution time, reducing the risk of performance spikes and performance volatility. If such an access path exists, select that access path; if not, perform parametric query optimization or query re-optimization.</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2014</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZHALcXX28PMMDHVVcPMPUnBzdA7xD_L0c1cI9XN2DQpx9PQLiVQAEv4Kzv7BIbpOjsGuLgpA1UGRCv4BIZ6-nlGOIZ7-fjwMrGmJOcWpvFCam0HZzTXE2UM3tSA_PrW4IDE5NS-1JD402MjA0MTQwMLY3MLR0Jg4VQCZsC3B</recordid><startdate>20140417</startdate><enddate>20140417</enddate><creator>PURCELL TERENCE P</creator><creator>BEAVIN THOMAS A</creator><creator>ALPERS JASON L</creator><creator>GUO SHUANGLIN</creator><creator>BOSSMAN PATRICK D</creator><scope>EVB</scope></search><sort><creationdate>20140417</creationdate><title>TECHNIQUE FOR FACTORING UNCERTAINTY INTO COST-BASED QUERY OPTIMIZATION</title><author>PURCELL TERENCE P ; BEAVIN THOMAS A ; ALPERS JASON L ; GUO SHUANGLIN ; BOSSMAN PATRICK D</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US2014108378A13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2014</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>PURCELL TERENCE P</creatorcontrib><creatorcontrib>BEAVIN THOMAS A</creatorcontrib><creatorcontrib>ALPERS JASON L</creatorcontrib><creatorcontrib>GUO SHUANGLIN</creatorcontrib><creatorcontrib>BOSSMAN PATRICK D</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>PURCELL TERENCE P</au><au>BEAVIN THOMAS A</au><au>ALPERS JASON L</au><au>GUO SHUANGLIN</au><au>BOSSMAN PATRICK D</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>TECHNIQUE FOR FACTORING UNCERTAINTY INTO COST-BASED QUERY OPTIMIZATION</title><date>2014-04-17</date><risdate>2014</risdate><abstract>A technique for factoring uncertainty into cost-based query optimization includes: determining the degree of uncertainty involved in the cost estimates for the query, determining the degree of sensitivity the query has to that uncertainty, and determining if there is an access path that performs well across the range of possible conditions that could occur at execution time, reducing the risk of performance spikes and performance volatility. If such an access path exists, select that access path; if not, perform parametric query optimization or query re-optimization.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_US2014108378A1
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title TECHNIQUE FOR FACTORING UNCERTAINTY INTO COST-BASED QUERY OPTIMIZATION
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-02T15%3A59%3A46IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=PURCELL%20TERENCE%20P&rft.date=2014-04-17&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS2014108378A1%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true