Techniques for improving the performance of complex queries

Techniques for improving complex database queries are provided. A determination is made whether to adopt a static or dynamic query execution plan based on metrics. When the dynamic query execution plan is used, a request fragment of the request is planned and the corresponding plan fragment is execu...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Sinclair, Paul, Korlapati, Rama Krishna, Sarathy, Vijay, Au, Grace Kwan-On
Format: Patent
Sprache:eng
Schlagworte:
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 Sinclair, Paul
Korlapati, Rama Krishna
Sarathy, Vijay
Au, Grace Kwan-On
description Techniques for improving complex database queries are provided. A determination is made whether to adopt a static or dynamic query execution plan based on metrics. When the dynamic query execution plan is used, a request fragment of the request is planned and the corresponding plan fragment is executed. The processed fragment provides feedback related to its processing to the remaining request and the process is repeated on the remaining request until the request is completed.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US10268724B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US10268724B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US10268724B23</originalsourceid><addsrcrecordid>eNrjZLAOSU3OyMssLE0tVkjLL1LIzC0oyi_LzEtXKMlIVShILQIK5ibmJacq5KcpJOfnFuSkVigAVRdlphbzMLCmJeYUp_JCaW4GRTfXEGcP3dSC_PjU4oLE5NS81JL40GBDAyMzC3MjEycjY2LUAADpWjAL</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Techniques for improving the performance of complex queries</title><source>esp@cenet</source><creator>Sinclair, Paul ; Korlapati, Rama Krishna ; Sarathy, Vijay ; Au, Grace Kwan-On</creator><creatorcontrib>Sinclair, Paul ; Korlapati, Rama Krishna ; Sarathy, Vijay ; Au, Grace Kwan-On</creatorcontrib><description>Techniques for improving complex database queries are provided. A determination is made whether to adopt a static or dynamic query execution plan based on metrics. When the dynamic query execution plan is used, a request fragment of the request is planned and the corresponding plan fragment is executed. The processed fragment provides feedback related to its processing to the remaining request and the process is repeated on the remaining request until the request is completed.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2019</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=20190423&amp;DB=EPODOC&amp;CC=US&amp;NR=10268724B2$$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=20190423&amp;DB=EPODOC&amp;CC=US&amp;NR=10268724B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Sinclair, Paul</creatorcontrib><creatorcontrib>Korlapati, Rama Krishna</creatorcontrib><creatorcontrib>Sarathy, Vijay</creatorcontrib><creatorcontrib>Au, Grace Kwan-On</creatorcontrib><title>Techniques for improving the performance of complex queries</title><description>Techniques for improving complex database queries are provided. A determination is made whether to adopt a static or dynamic query execution plan based on metrics. When the dynamic query execution plan is used, a request fragment of the request is planned and the corresponding plan fragment is executed. The processed fragment provides feedback related to its processing to the remaining request and the process is repeated on the remaining request until the request is completed.</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>2019</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZLAOSU3OyMssLE0tVkjLL1LIzC0oyi_LzEtXKMlIVShILQIK5ibmJacq5KcpJOfnFuSkVigAVRdlphbzMLCmJeYUp_JCaW4GRTfXEGcP3dSC_PjU4oLE5NS81JL40GBDAyMzC3MjEycjY2LUAADpWjAL</recordid><startdate>20190423</startdate><enddate>20190423</enddate><creator>Sinclair, Paul</creator><creator>Korlapati, Rama Krishna</creator><creator>Sarathy, Vijay</creator><creator>Au, Grace Kwan-On</creator><scope>EVB</scope></search><sort><creationdate>20190423</creationdate><title>Techniques for improving the performance of complex queries</title><author>Sinclair, Paul ; Korlapati, Rama Krishna ; Sarathy, Vijay ; Au, Grace Kwan-On</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US10268724B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2019</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>Sinclair, Paul</creatorcontrib><creatorcontrib>Korlapati, Rama Krishna</creatorcontrib><creatorcontrib>Sarathy, Vijay</creatorcontrib><creatorcontrib>Au, Grace Kwan-On</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Sinclair, Paul</au><au>Korlapati, Rama Krishna</au><au>Sarathy, Vijay</au><au>Au, Grace Kwan-On</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Techniques for improving the performance of complex queries</title><date>2019-04-23</date><risdate>2019</risdate><abstract>Techniques for improving complex database queries are provided. A determination is made whether to adopt a static or dynamic query execution plan based on metrics. When the dynamic query execution plan is used, a request fragment of the request is planned and the corresponding plan fragment is executed. The processed fragment provides feedback related to its processing to the remaining request and the process is repeated on the remaining request until the request is completed.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_US10268724B2
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Techniques for improving the performance of complex queries
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-06T15%3A22%3A01IST&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=Sinclair,%20Paul&rft.date=2019-04-23&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS10268724B2%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