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...
Gespeichert in:
Hauptverfasser: | , , , |
---|---|
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&date=20190423&DB=EPODOC&CC=US&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&date=20190423&DB=EPODOC&CC=US&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 |