Assigning Plan Volatility Scores to Control Reoptimization Frequency and Number of Stored Reoptimization Plans

Methods, systems, and computer program products are provided for improving the processing of database queries. Some embodiments include generating volatility scores for various plans for executing similar database queries. Different embodiments may utilize: database statistics, the variable values b...

Ausführliche Beschreibung

Gespeichert in:

Bibliographische Detailangaben
Hauptverfasser:	KETHIREDDY SHANTAN, BESTGEN ROBERT J
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	KETHIREDDY SHANTAN BESTGEN ROBERT J
description	Methods, systems, and computer program products are provided for improving the processing of database queries. Some embodiments include generating volatility scores for various plans for executing similar database queries. Different embodiments may utilize: database statistics, the variable values being selected for, and/or historical run time data, to generate the plan volatility scores. In some embodiments, the volatility scores are used to determine whether to generate a new plan for a query, whether to prune an existing plan, and/or how many different plans to store for a query.
format	Patent
fullrecord	<record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US2009271360A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US2009271360A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US2009271360A13</originalsourceid><addsrcrecordid>eNqNzDELwjAQhuEuDqL-hwNnIW1BcSzF4iRi1bXE9loC6V1MrkP99VZwcnL6lud75xFlIZiODHVwtprgzlaLsUZGKGv2GEAYcibxbOGC7MT05jURJig8PgekegRNDZyG_oEeuIVSpmPzqz_5sIxmrbYBV99dROvicM2PG3RcYXC6RkKpbmWi1D7ZxelWZXH6n3oD6itDxQ</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Assigning Plan Volatility Scores to Control Reoptimization Frequency and Number of Stored Reoptimization Plans</title><source>esp@cenet</source><creator>KETHIREDDY SHANTAN ; BESTGEN ROBERT J</creator><creatorcontrib>KETHIREDDY SHANTAN ; BESTGEN ROBERT J</creatorcontrib><description>Methods, systems, and computer program products are provided for improving the processing of database queries. Some embodiments include generating volatility scores for various plans for executing similar database queries. Different embodiments may utilize: database statistics, the variable values being selected for, and/or historical run time data, to generate the plan volatility scores. In some embodiments, the volatility scores are used to determine whether to generate a new plan for a query, whether to prune an existing plan, and/or how many different plans to store for a query.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2009</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&date=20091029&DB=EPODOC&CC=US&NR=2009271360A1$$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&date=20091029&DB=EPODOC&CC=US&NR=2009271360A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>KETHIREDDY SHANTAN</creatorcontrib><creatorcontrib>BESTGEN ROBERT J</creatorcontrib><title>Assigning Plan Volatility Scores to Control Reoptimization Frequency and Number of Stored Reoptimization Plans</title><description>Methods, systems, and computer program products are provided for improving the processing of database queries. Some embodiments include generating volatility scores for various plans for executing similar database queries. Different embodiments may utilize: database statistics, the variable values being selected for, and/or historical run time data, to generate the plan volatility scores. In some embodiments, the volatility scores are used to determine whether to generate a new plan for a query, whether to prune an existing plan, and/or how many different plans to store for a query.</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>2009</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNzDELwjAQhuEuDqL-hwNnIW1BcSzF4iRi1bXE9loC6V1MrkP99VZwcnL6lud75xFlIZiODHVwtprgzlaLsUZGKGv2GEAYcibxbOGC7MT05jURJig8PgekegRNDZyG_oEeuIVSpmPzqz_5sIxmrbYBV99dROvicM2PG3RcYXC6RkKpbmWi1D7ZxelWZXH6n3oD6itDxQ</recordid><startdate>20091029</startdate><enddate>20091029</enddate><creator>KETHIREDDY SHANTAN</creator><creator>BESTGEN ROBERT J</creator><scope>EVB</scope></search><sort><creationdate>20091029</creationdate><title>Assigning Plan Volatility Scores to Control Reoptimization Frequency and Number of Stored Reoptimization Plans</title><author>KETHIREDDY SHANTAN ; BESTGEN ROBERT J</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US2009271360A13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2009</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>KETHIREDDY SHANTAN</creatorcontrib><creatorcontrib>BESTGEN ROBERT J</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>KETHIREDDY SHANTAN</au><au>BESTGEN ROBERT J</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Assigning Plan Volatility Scores to Control Reoptimization Frequency and Number of Stored Reoptimization Plans</title><date>2009-10-29</date><risdate>2009</risdate><abstract>Methods, systems, and computer program products are provided for improving the processing of database queries. Some embodiments include generating volatility scores for various plans for executing similar database queries. Different embodiments may utilize: database statistics, the variable values being selected for, and/or historical run time data, to generate the plan volatility scores. In some embodiments, the volatility scores are used to determine whether to generate a new plan for a query, whether to prune an existing plan, and/or how many different plans to store for a query.</abstract><oa>free_for_read</oa></addata></record>
fulltext	fulltext_linktorsrc
identifier
ispartof
issn
language	eng
recordid	cdi_epo_espacenet_US2009271360A1
source	esp@cenet
subjects	CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS
title	Assigning Plan Volatility Scores to Control Reoptimization Frequency and Number of Stored Reoptimization Plans
url	https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-29T13%3A55%3A59IST&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=KETHIREDDY%20SHANTAN&rft.date=2009-10-29&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS2009271360A1%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