Elimination of query fragment duplication in complex database queries
A database engine receives a database query from a client. The database engine parses the database query to build a query operator tree that includes a plurality of query operators. The database engine performs one or more optimization passes on the query operator tree, including a deduplication opt...
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 | Muehlbauer, Tobias Vogelsgesang, Adrian Finis, Jan Then, Manuel Cole, Rick Neumann, Thomas Haubenschild, Michael |
description | A database engine receives a database query from a client. The database engine parses the database query to build a query operator tree that includes a plurality of query operators. The database engine performs one or more optimization passes on the query operator tree, including a deduplication optimization pass, to form an optimized execution plan. The deduplication optimization pass includes: creating a list of query operators via a first traversal of the query operator tree, determining a first query operator that is equivalent to a second query operator, based on a hash map, via a second traversal of the query operator tree, and substituting, via a third traversal of the query operator tree, the second query operator with a tree node that links to the first query operator. The database engine executes the optimized execution plan to retrieve a result set from the database, and returns the result set. |
format | Patent |
fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_AU2022279452BB1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>AU2022279452BB1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_AU2022279452BB13</originalsourceid><addsrcrecordid>eNrjZHB1zcnMzcxLLMnMz1PIT1MoLE0tqlRIK0pMz03NK1FIKS3IyUyGyGbmKSTn5xbkpFYopCSWJCYlFqeClWemFvMwsKYl5hSn8kJpbgYVN9cQZw_d1IL8-NTigsTk1LzUknjHUCMDIyMjc0sTUyMnJ0NjIpUBAF4UNQA</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Elimination of query fragment duplication in complex database queries</title><source>esp@cenet</source><creator>Muehlbauer, Tobias ; Vogelsgesang, Adrian ; Finis, Jan ; Then, Manuel ; Cole, Rick ; Neumann, Thomas ; Haubenschild, Michael</creator><creatorcontrib>Muehlbauer, Tobias ; Vogelsgesang, Adrian ; Finis, Jan ; Then, Manuel ; Cole, Rick ; Neumann, Thomas ; Haubenschild, Michael</creatorcontrib><description>A database engine receives a database query from a client. The database engine parses the database query to build a query operator tree that includes a plurality of query operators. The database engine performs one or more optimization passes on the query operator tree, including a deduplication optimization pass, to form an optimized execution plan. The deduplication optimization pass includes: creating a list of query operators via a first traversal of the query operator tree, determining a first query operator that is equivalent to a second query operator, based on a hash map, via a second traversal of the query operator tree, and substituting, via a third traversal of the query operator tree, the second query operator with a tree node that links to the first query operator. The database engine executes the optimized execution plan to retrieve a result set from the database, and returns the result set.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2023</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=20230202&DB=EPODOC&CC=AU&NR=2022279452B1$$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=20230202&DB=EPODOC&CC=AU&NR=2022279452B1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Muehlbauer, Tobias</creatorcontrib><creatorcontrib>Vogelsgesang, Adrian</creatorcontrib><creatorcontrib>Finis, Jan</creatorcontrib><creatorcontrib>Then, Manuel</creatorcontrib><creatorcontrib>Cole, Rick</creatorcontrib><creatorcontrib>Neumann, Thomas</creatorcontrib><creatorcontrib>Haubenschild, Michael</creatorcontrib><title>Elimination of query fragment duplication in complex database queries</title><description>A database engine receives a database query from a client. The database engine parses the database query to build a query operator tree that includes a plurality of query operators. The database engine performs one or more optimization passes on the query operator tree, including a deduplication optimization pass, to form an optimized execution plan. The deduplication optimization pass includes: creating a list of query operators via a first traversal of the query operator tree, determining a first query operator that is equivalent to a second query operator, based on a hash map, via a second traversal of the query operator tree, and substituting, via a third traversal of the query operator tree, the second query operator with a tree node that links to the first query operator. The database engine executes the optimized execution plan to retrieve a result set from the database, and returns the result set.</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>2023</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZHB1zcnMzcxLLMnMz1PIT1MoLE0tqlRIK0pMz03NK1FIKS3IyUyGyGbmKSTn5xbkpFYopCSWJCYlFqeClWemFvMwsKYl5hSn8kJpbgYVN9cQZw_d1IL8-NTigsTk1LzUknjHUCMDIyMjc0sTUyMnJ0NjIpUBAF4UNQA</recordid><startdate>20230202</startdate><enddate>20230202</enddate><creator>Muehlbauer, Tobias</creator><creator>Vogelsgesang, Adrian</creator><creator>Finis, Jan</creator><creator>Then, Manuel</creator><creator>Cole, Rick</creator><creator>Neumann, Thomas</creator><creator>Haubenschild, Michael</creator><scope>EVB</scope></search><sort><creationdate>20230202</creationdate><title>Elimination of query fragment duplication in complex database queries</title><author>Muehlbauer, Tobias ; Vogelsgesang, Adrian ; Finis, Jan ; Then, Manuel ; Cole, Rick ; Neumann, Thomas ; Haubenschild, Michael</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_AU2022279452BB13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2023</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>Muehlbauer, Tobias</creatorcontrib><creatorcontrib>Vogelsgesang, Adrian</creatorcontrib><creatorcontrib>Finis, Jan</creatorcontrib><creatorcontrib>Then, Manuel</creatorcontrib><creatorcontrib>Cole, Rick</creatorcontrib><creatorcontrib>Neumann, Thomas</creatorcontrib><creatorcontrib>Haubenschild, Michael</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Muehlbauer, Tobias</au><au>Vogelsgesang, Adrian</au><au>Finis, Jan</au><au>Then, Manuel</au><au>Cole, Rick</au><au>Neumann, Thomas</au><au>Haubenschild, Michael</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Elimination of query fragment duplication in complex database queries</title><date>2023-02-02</date><risdate>2023</risdate><abstract>A database engine receives a database query from a client. The database engine parses the database query to build a query operator tree that includes a plurality of query operators. The database engine performs one or more optimization passes on the query operator tree, including a deduplication optimization pass, to form an optimized execution plan. The deduplication optimization pass includes: creating a list of query operators via a first traversal of the query operator tree, determining a first query operator that is equivalent to a second query operator, based on a hash map, via a second traversal of the query operator tree, and substituting, via a third traversal of the query operator tree, the second query operator with a tree node that links to the first query operator. The database engine executes the optimized execution plan to retrieve a result set from the database, and returns the result set.</abstract><oa>free_for_read</oa></addata></record> |
fulltext | fulltext_linktorsrc |
identifier | |
ispartof | |
issn | |
language | eng |
recordid | cdi_epo_espacenet_AU2022279452BB1 |
source | esp@cenet |
subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
title | Elimination of query fragment duplication in complex database queries |
url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-25T11%3A16%3A55IST&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=Muehlbauer,%20Tobias&rft.date=2023-02-02&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EAU2022279452BB1%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 |