JOIN ELIMINATION

Techniques for join elimination are described herein. Join elimination can identify and eliminate unnecessary joins in a query plan node. For example, join elimination can involve a semantic query optimization technique, which removes reference to a table whose columns are only referenced in join pr...

Ausführliche Beschreibung

Gespeichert in:

Bibliographische Detailangaben
Hauptverfasser:	Hwang, Sangyong, Yoon, Yongsik, Yan, Jiaqi, Jindal, Nitish, Cruanes, Thierry
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	Hwang, Sangyong Yoon, Yongsik Yan, Jiaqi Jindal, Nitish Cruanes, Thierry
description	Techniques for join elimination are described herein. Join elimination can identify and eliminate unnecessary joins in a query plan node. For example, join elimination can involve a semantic query optimization technique, which removes reference to a table whose columns are only referenced in join predicates if the joins do not filter/expand rows in the result. Such joins can cause significant performance issues on larger datasets if not optimized.
format	Patent
fullrecord	<record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US2023135440A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US2023135440A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US2023135440A13</originalsourceid><addsrcrecordid>eNrjZBDw8vf0U3D18fT19HMM8fT342FgTUvMKU7lhdLcDMpuriHOHrqpBfnxqcUFicmpeakl8aHBRgZGxobGpiYmBo6GxsSpAgB4pB5k</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>JOIN ELIMINATION</title><source>esp@cenet</source><creator>Hwang, Sangyong ; Yoon, Yongsik ; Yan, Jiaqi ; Jindal, Nitish ; Cruanes, Thierry</creator><creatorcontrib>Hwang, Sangyong ; Yoon, Yongsik ; Yan, Jiaqi ; Jindal, Nitish ; Cruanes, Thierry</creatorcontrib><description>Techniques for join elimination are described herein. Join elimination can identify and eliminate unnecessary joins in a query plan node. For example, join elimination can involve a semantic query optimization technique, which removes reference to a table whose columns are only referenced in join predicates if the joins do not filter/expand rows in the result. Such joins can cause significant performance issues on larger datasets if not optimized.</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=20230504&DB=EPODOC&CC=US&NR=2023135440A1$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,777,882,25545,76296</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20230504&DB=EPODOC&CC=US&NR=2023135440A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Hwang, Sangyong</creatorcontrib><creatorcontrib>Yoon, Yongsik</creatorcontrib><creatorcontrib>Yan, Jiaqi</creatorcontrib><creatorcontrib>Jindal, Nitish</creatorcontrib><creatorcontrib>Cruanes, Thierry</creatorcontrib><title>JOIN ELIMINATION</title><description>Techniques for join elimination are described herein. Join elimination can identify and eliminate unnecessary joins in a query plan node. For example, join elimination can involve a semantic query optimization technique, which removes reference to a table whose columns are only referenced in join predicates if the joins do not filter/expand rows in the result. Such joins can cause significant performance issues on larger datasets if not optimized.</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>eNrjZBDw8vf0U3D18fT19HMM8fT342FgTUvMKU7lhdLcDMpuriHOHrqpBfnxqcUFicmpeakl8aHBRgZGxobGpiYmBo6GxsSpAgB4pB5k</recordid><startdate>20230504</startdate><enddate>20230504</enddate><creator>Hwang, Sangyong</creator><creator>Yoon, Yongsik</creator><creator>Yan, Jiaqi</creator><creator>Jindal, Nitish</creator><creator>Cruanes, Thierry</creator><scope>EVB</scope></search><sort><creationdate>20230504</creationdate><title>JOIN ELIMINATION</title><author>Hwang, Sangyong ; Yoon, Yongsik ; Yan, Jiaqi ; Jindal, Nitish ; Cruanes, Thierry</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US2023135440A13</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>Hwang, Sangyong</creatorcontrib><creatorcontrib>Yoon, Yongsik</creatorcontrib><creatorcontrib>Yan, Jiaqi</creatorcontrib><creatorcontrib>Jindal, Nitish</creatorcontrib><creatorcontrib>Cruanes, Thierry</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Hwang, Sangyong</au><au>Yoon, Yongsik</au><au>Yan, Jiaqi</au><au>Jindal, Nitish</au><au>Cruanes, Thierry</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>JOIN ELIMINATION</title><date>2023-05-04</date><risdate>2023</risdate><abstract>Techniques for join elimination are described herein. Join elimination can identify and eliminate unnecessary joins in a query plan node. For example, join elimination can involve a semantic query optimization technique, which removes reference to a table whose columns are only referenced in join predicates if the joins do not filter/expand rows in the result. Such joins can cause significant performance issues on larger datasets if not optimized.</abstract><oa>free_for_read</oa></addata></record>
fulltext	fulltext_linktorsrc
identifier
ispartof
issn
language	eng
recordid	cdi_epo_espacenet_US2023135440A1
source	esp@cenet
subjects	CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS
title	JOIN ELIMINATION
url	https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-20T19%3A06%3A36IST&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=Hwang,%20Sangyong&rft.date=2023-05-04&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS2023135440A1%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