Cost-based semi-join rewrite

A method, apparatus, and computer program product for executing a relational database management system (RDBMS) in a computer system, wherein the RDBMS manages a relational database comprised of one or more tables storing data. The RDBMS executes a query with a semi-join operation comprising an incl...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Al-Kateb, Mohammed Hussien, Tang, Conrad, Nair, Sanjay, Au, Grace Kwan-On, Zhang, Ming
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 Al-Kateb, Mohammed Hussien
Tang, Conrad
Nair, Sanjay
Au, Grace Kwan-On
Zhang, Ming
description A method, apparatus, and computer program product for executing a relational database management system (RDBMS) in a computer system, wherein the RDBMS manages a relational database comprised of one or more tables storing data. The RDBMS executes a query with a semi-join operation comprising an inclusion join and/or an exclusion join performed against at least an outer table and an inner table, wherein the inclusion join returns a row from the outer table when there is a match with a row in the inner table, and the exclusion join returns a row from the outer table when there is no match with a row in the inner table. The RDBMS performs a rewrite of the query to avoid spooling and/or sorting of the inner table, when the inner table is larger than the outer table and a cost after the rewrite is lower than before the rewrite.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US12105708B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US12105708B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US12105708B23</originalsourceid><addsrcrecordid>eNrjZJBxzi8u0U1KLE5NUShOzc3UzcrPzFMoSi0vyixJ5WFgTUvMKU7lhdLcDIpuriHOHrqpBfnxqcUFicmpeakl8aHBhkaGBqbmBhZORsbEqAEAkRUjuQ</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Cost-based semi-join rewrite</title><source>esp@cenet</source><creator>Al-Kateb, Mohammed Hussien ; Tang, Conrad ; Nair, Sanjay ; Au, Grace Kwan-On ; Zhang, Ming</creator><creatorcontrib>Al-Kateb, Mohammed Hussien ; Tang, Conrad ; Nair, Sanjay ; Au, Grace Kwan-On ; Zhang, Ming</creatorcontrib><description>A method, apparatus, and computer program product for executing a relational database management system (RDBMS) in a computer system, wherein the RDBMS manages a relational database comprised of one or more tables storing data. The RDBMS executes a query with a semi-join operation comprising an inclusion join and/or an exclusion join performed against at least an outer table and an inner table, wherein the inclusion join returns a row from the outer table when there is a match with a row in the inner table, and the exclusion join returns a row from the outer table when there is no match with a row in the inner table. The RDBMS performs a rewrite of the query to avoid spooling and/or sorting of the inner table, when the inner table is larger than the outer table and a cost after the rewrite is lower than before the rewrite.</description><language>eng</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=20241001&amp;DB=EPODOC&amp;CC=US&amp;NR=12105708B2$$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=20241001&amp;DB=EPODOC&amp;CC=US&amp;NR=12105708B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Al-Kateb, Mohammed Hussien</creatorcontrib><creatorcontrib>Tang, Conrad</creatorcontrib><creatorcontrib>Nair, Sanjay</creatorcontrib><creatorcontrib>Au, Grace Kwan-On</creatorcontrib><creatorcontrib>Zhang, Ming</creatorcontrib><title>Cost-based semi-join rewrite</title><description>A method, apparatus, and computer program product for executing a relational database management system (RDBMS) in a computer system, wherein the RDBMS manages a relational database comprised of one or more tables storing data. The RDBMS executes a query with a semi-join operation comprising an inclusion join and/or an exclusion join performed against at least an outer table and an inner table, wherein the inclusion join returns a row from the outer table when there is a match with a row in the inner table, and the exclusion join returns a row from the outer table when there is no match with a row in the inner table. The RDBMS performs a rewrite of the query to avoid spooling and/or sorting of the inner table, when the inner table is larger than the outer table and a cost after the rewrite is lower than before the rewrite.</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>eNrjZJBxzi8u0U1KLE5NUShOzc3UzcrPzFMoSi0vyixJ5WFgTUvMKU7lhdLcDIpuriHOHrqpBfnxqcUFicmpeakl8aHBhkaGBqbmBhZORsbEqAEAkRUjuQ</recordid><startdate>20241001</startdate><enddate>20241001</enddate><creator>Al-Kateb, Mohammed Hussien</creator><creator>Tang, Conrad</creator><creator>Nair, Sanjay</creator><creator>Au, Grace Kwan-On</creator><creator>Zhang, Ming</creator><scope>EVB</scope></search><sort><creationdate>20241001</creationdate><title>Cost-based semi-join rewrite</title><author>Al-Kateb, Mohammed Hussien ; Tang, Conrad ; Nair, Sanjay ; Au, Grace Kwan-On ; Zhang, Ming</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US12105708B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</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>Al-Kateb, Mohammed Hussien</creatorcontrib><creatorcontrib>Tang, Conrad</creatorcontrib><creatorcontrib>Nair, Sanjay</creatorcontrib><creatorcontrib>Au, Grace Kwan-On</creatorcontrib><creatorcontrib>Zhang, Ming</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Al-Kateb, Mohammed Hussien</au><au>Tang, Conrad</au><au>Nair, Sanjay</au><au>Au, Grace Kwan-On</au><au>Zhang, Ming</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Cost-based semi-join rewrite</title><date>2024-10-01</date><risdate>2024</risdate><abstract>A method, apparatus, and computer program product for executing a relational database management system (RDBMS) in a computer system, wherein the RDBMS manages a relational database comprised of one or more tables storing data. The RDBMS executes a query with a semi-join operation comprising an inclusion join and/or an exclusion join performed against at least an outer table and an inner table, wherein the inclusion join returns a row from the outer table when there is a match with a row in the inner table, and the exclusion join returns a row from the outer table when there is no match with a row in the inner table. The RDBMS performs a rewrite of the query to avoid spooling and/or sorting of the inner table, when the inner table is larger than the outer table and a cost after the rewrite is lower than before the rewrite.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_US12105708B2
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Cost-based semi-join rewrite
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-06T13%3A25%3A20IST&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=Al-Kateb,%20Mohammed%20Hussien&rft.date=2024-10-01&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS12105708B2%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