DATABASE QUERY OPTIMIZATION VIA PARAMETER-SENSITIVE PLAN SELECTION

DATABASE QUERY OPTIMIZATION VIA PARAMETER-SENSITIVE PLAN SELECTION

A method includes receiving a database query requesting a database to conditionally return one or more data blocks. The database is stored on memory hardware in communication with the data processing hardware and the database query includes a plurality of parameters characterizing the database query...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: DOSHI, Lyric Pankaj, BREVDO, Eugene, FRASER, Campbell Bryce
Format: Patent
Sprache:eng ; fre ; ger
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 DOSHI, Lyric Pankaj
BREVDO, Eugene
FRASER, Campbell Bryce
description A method includes receiving a database query requesting a database to conditionally return one or more data blocks. The database is stored on memory hardware in communication with the data processing hardware and the database query includes a plurality of parameters characterizing the database query. The method includes generating a set of query plans. Each query plan in the set of query plans is configured to execute the database query using a different order of operations. The method includes training a model using historical database queries and generating, using the trained model, a query plan score for each query plan in the set of query plans. The method includes selecting, using the query plan score of each query plan in the set of query plans, a query plan from the set of query plans. The method also includes executing the database query using the selected query plan.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_EP4433906A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>EP4433906A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_EP4433906A13</originalsourceid><addsrcrecordid>eNrjZHBycQxxdHIMdlUIDHUNilTwDwjx9PWMcgzx9PdTCPN0VAhwDHL0dQ1xDdINdvUL9gzxDHNVCPBx9FMIdvVxdQYp42FgTUvMKU7lhdLcDApuriHOHrqpBfnxqcUFicmpeakl8a4BJibGxpYGZo6GxkQoAQDbMis2</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>DATABASE QUERY OPTIMIZATION VIA PARAMETER-SENSITIVE PLAN SELECTION</title><source>esp@cenet</source><creator>DOSHI, Lyric Pankaj ; BREVDO, Eugene ; FRASER, Campbell Bryce</creator><creatorcontrib>DOSHI, Lyric Pankaj ; BREVDO, Eugene ; FRASER, Campbell Bryce</creatorcontrib><description>A method includes receiving a database query requesting a database to conditionally return one or more data blocks. The database is stored on memory hardware in communication with the data processing hardware and the database query includes a plurality of parameters characterizing the database query. The method includes generating a set of query plans. Each query plan in the set of query plans is configured to execute the database query using a different order of operations. The method includes training a model using historical database queries and generating, using the trained model, a query plan score for each query plan in the set of query plans. The method includes selecting, using the query plan score of each query plan in the set of query plans, a query plan from the set of query plans. The method also includes executing the database query using the selected query plan.</description><language>eng ; fre ; ger</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2024</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=20240925&amp;DB=EPODOC&amp;CC=EP&amp;NR=4433906A1$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76289</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20240925&amp;DB=EPODOC&amp;CC=EP&amp;NR=4433906A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>DOSHI, Lyric Pankaj</creatorcontrib><creatorcontrib>BREVDO, Eugene</creatorcontrib><creatorcontrib>FRASER, Campbell Bryce</creatorcontrib><title>DATABASE QUERY OPTIMIZATION VIA PARAMETER-SENSITIVE PLAN SELECTION</title><description>A method includes receiving a database query requesting a database to conditionally return one or more data blocks. The database is stored on memory hardware in communication with the data processing hardware and the database query includes a plurality of parameters characterizing the database query. The method includes generating a set of query plans. Each query plan in the set of query plans is configured to execute the database query using a different order of operations. The method includes training a model using historical database queries and generating, using the trained model, a query plan score for each query plan in the set of query plans. The method includes selecting, using the query plan score of each query plan in the set of query plans, a query plan from the set of query plans. The method also includes executing the database query using the selected query plan.</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>2024</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZHBycQxxdHIMdlUIDHUNilTwDwjx9PWMcgzx9PdTCPN0VAhwDHL0dQ1xDdINdvUL9gzxDHNVCPBx9FMIdvVxdQYp42FgTUvMKU7lhdLcDApuriHOHrqpBfnxqcUFicmpeakl8a4BJibGxpYGZo6GxkQoAQDbMis2</recordid><startdate>20240925</startdate><enddate>20240925</enddate><creator>DOSHI, Lyric Pankaj</creator><creator>BREVDO, Eugene</creator><creator>FRASER, Campbell Bryce</creator><scope>EVB</scope></search><sort><creationdate>20240925</creationdate><title>DATABASE QUERY OPTIMIZATION VIA PARAMETER-SENSITIVE PLAN SELECTION</title><author>DOSHI, Lyric Pankaj ; BREVDO, Eugene ; FRASER, Campbell Bryce</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_EP4433906A13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng ; fre ; ger</language><creationdate>2024</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>DOSHI, Lyric Pankaj</creatorcontrib><creatorcontrib>BREVDO, Eugene</creatorcontrib><creatorcontrib>FRASER, Campbell Bryce</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>DOSHI, Lyric Pankaj</au><au>BREVDO, Eugene</au><au>FRASER, Campbell Bryce</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>DATABASE QUERY OPTIMIZATION VIA PARAMETER-SENSITIVE PLAN SELECTION</title><date>2024-09-25</date><risdate>2024</risdate><abstract>A method includes receiving a database query requesting a database to conditionally return one or more data blocks. The database is stored on memory hardware in communication with the data processing hardware and the database query includes a plurality of parameters characterizing the database query. The method includes generating a set of query plans. Each query plan in the set of query plans is configured to execute the database query using a different order of operations. The method includes training a model using historical database queries and generating, using the trained model, a query plan score for each query plan in the set of query plans. The method includes selecting, using the query plan score of each query plan in the set of query plans, a query plan from the set of query plans. The method also includes executing the database query using the selected query plan.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng ; fre ; ger
recordid cdi_epo_espacenet_EP4433906A1
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title DATABASE QUERY OPTIMIZATION VIA PARAMETER-SENSITIVE PLAN SELECTION
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-07T04%3A18%3A06IST&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=DOSHI,%20Lyric%20Pankaj&rft.date=2024-09-25&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EEP4433906A1%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