Parameter-sensitive plans for structural scenarios

Systems and methods that generate specialized plans for compiling SQL queries. A plan generator component scans the query representation for parameter sensitive predicates and evaluates each predicate individually based on the parameter values. Accordingly, queries can be identified not only based o...

Ausführliche Beschreibung

Gespeichert in:

Bibliographische Detailangaben
Hauptverfasser:	JOSHI MILIND MADHUKAR, GALINDO-LEGARIA CESAR A, PRAKASH NAVEEN, FRIEDMAN MARC T, ISMERT ERIK
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	JOSHI MILIND MADHUKAR GALINDO-LEGARIA CESAR A PRAKASH NAVEEN FRIEDMAN MARC T ISMERT ERIK
description	Systems and methods that generate specialized plans for compiling SQL queries. A plan generator component scans the query representation for parameter sensitive predicates and evaluates each predicate individually based on the parameter values. Accordingly, queries can be identified not only based on their structures, but also based on their parameter conditions. The specialized plans are more efficient for particular values, wherein queries that employ such values are optimally executed.
format	Patent
fullrecord	<record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US7933894B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US7933894B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US7933894B23</originalsourceid><addsrcrecordid>eNrjZDAKSCxKzE0tSS3SLU7NK84sySxLVSjIScwrVkjLL1IoLikqTS4pLUrMUShOTs1LLMrML-ZhYE1LzClO5YXS3AwKbq4hzh66qQX58anFBYlAhakl8aHB5pbGxhaWJk5GxkQoAQDMJCyu</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Parameter-sensitive plans for structural scenarios</title><source>esp@cenet</source><creator>JOSHI MILIND MADHUKAR ; GALINDO-LEGARIA CESAR A ; PRAKASH NAVEEN ; FRIEDMAN MARC T ; ISMERT ERIK</creator><creatorcontrib>JOSHI MILIND MADHUKAR ; GALINDO-LEGARIA CESAR A ; PRAKASH NAVEEN ; FRIEDMAN MARC T ; ISMERT ERIK</creatorcontrib><description>Systems and methods that generate specialized plans for compiling SQL queries. A plan generator component scans the query representation for parameter sensitive predicates and evaluates each predicate individually based on the parameter values. Accordingly, queries can be identified not only based on their structures, but also based on their parameter conditions. The specialized plans are more efficient for particular values, wherein queries that employ such values are optimally executed.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2011</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=20110426&DB=EPODOC&CC=US&NR=7933894B2$$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=20110426&DB=EPODOC&CC=US&NR=7933894B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>JOSHI MILIND MADHUKAR</creatorcontrib><creatorcontrib>GALINDO-LEGARIA CESAR A</creatorcontrib><creatorcontrib>PRAKASH NAVEEN</creatorcontrib><creatorcontrib>FRIEDMAN MARC T</creatorcontrib><creatorcontrib>ISMERT ERIK</creatorcontrib><title>Parameter-sensitive plans for structural scenarios</title><description>Systems and methods that generate specialized plans for compiling SQL queries. A plan generator component scans the query representation for parameter sensitive predicates and evaluates each predicate individually based on the parameter values. Accordingly, queries can be identified not only based on their structures, but also based on their parameter conditions. The specialized plans are more efficient for particular values, wherein queries that employ such values are optimally executed.</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>2011</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZDAKSCxKzE0tSS3SLU7NK84sySxLVSjIScwrVkjLL1IoLikqTS4pLUrMUShOTs1LLMrML-ZhYE1LzClO5YXS3AwKbq4hzh66qQX58anFBYlAhakl8aHB5pbGxhaWJk5GxkQoAQDMJCyu</recordid><startdate>20110426</startdate><enddate>20110426</enddate><creator>JOSHI MILIND MADHUKAR</creator><creator>GALINDO-LEGARIA CESAR A</creator><creator>PRAKASH NAVEEN</creator><creator>FRIEDMAN MARC T</creator><creator>ISMERT ERIK</creator><scope>EVB</scope></search><sort><creationdate>20110426</creationdate><title>Parameter-sensitive plans for structural scenarios</title><author>JOSHI MILIND MADHUKAR ; GALINDO-LEGARIA CESAR A ; PRAKASH NAVEEN ; FRIEDMAN MARC T ; ISMERT ERIK</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US7933894B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2011</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>JOSHI MILIND MADHUKAR</creatorcontrib><creatorcontrib>GALINDO-LEGARIA CESAR A</creatorcontrib><creatorcontrib>PRAKASH NAVEEN</creatorcontrib><creatorcontrib>FRIEDMAN MARC T</creatorcontrib><creatorcontrib>ISMERT ERIK</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>JOSHI MILIND MADHUKAR</au><au>GALINDO-LEGARIA CESAR A</au><au>PRAKASH NAVEEN</au><au>FRIEDMAN MARC T</au><au>ISMERT ERIK</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Parameter-sensitive plans for structural scenarios</title><date>2011-04-26</date><risdate>2011</risdate><abstract>Systems and methods that generate specialized plans for compiling SQL queries. A plan generator component scans the query representation for parameter sensitive predicates and evaluates each predicate individually based on the parameter values. Accordingly, queries can be identified not only based on their structures, but also based on their parameter conditions. The specialized plans are more efficient for particular values, wherein queries that employ such values are optimally executed.</abstract><oa>free_for_read</oa></addata></record>
fulltext	fulltext_linktorsrc
identifier
ispartof
issn
language	eng
recordid	cdi_epo_espacenet_US7933894B2
source	esp@cenet
subjects	CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS
title	Parameter-sensitive plans for structural scenarios
url	https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-30T21%3A08%3A07IST&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=JOSHI%20MILIND%20MADHUKAR&rft.date=2011-04-26&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS7933894B2%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