Method for unordered relational database retrieval returning distinct values
The retrieval of distinct tuples in a relational database management system. In response to a request from a consumer process for distinct tuples in a relational database table matching a defined criteria, a distinct operator component sequentially requests tuples from a source component. The source...
Gespeichert in:
Hauptverfasser: | , , , |
---|---|
Format: | Patent |
Sprache: | eng |
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 | Finlay, Ian R Lai, Tony Wen Hsun Zilio, Daniel C Zuzarte, Calisto Paul |
description | The retrieval of distinct tuples in a relational database management system. In response to a request from a consumer process for distinct tuples in a relational database table matching a defined criteria, a distinct operator component sequentially requests tuples from a source component. The source component access the database table and returns a tuple in the sequence to the distinct operator component. The distinct operator component passes each tuple in the sequence to an auxiliary logger. The auxiliary component receives a tuples from the distinct component and determines if it is distinct from other previously received tuples in the sequence to verify its uniqueness to the distinct operator. Tuples that are verified as unique by the auxiliary logger are returned to the consumer process by the distinct operator upon verification. |
format | Patent |
fullrecord | <record><control><sourceid>uspatents_EFH</sourceid><recordid>TN_cdi_uspatents_grants_07752160</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>07752160</sourcerecordid><originalsourceid>FETCH-uspatents_grants_077521603</originalsourceid><addsrcrecordid>eNqNyjEKAkEMheFpLES9Qy4grIruAUSx0M5eosmugSEjScbzO4IHsPofH2-azheOZyEYikHVYsTGBMYZQ4piBsLAOzo3CxN-N2qrmoqOQOIh-ghoXNnnaTJgdl78OktwPFz3p2X1FwZr-G00_Kbr--16tes2f1w-ug83hw</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method for unordered relational database retrieval returning distinct values</title><source>USPTO Issued Patents</source><creator>Finlay, Ian R ; Lai, Tony Wen Hsun ; Zilio, Daniel C ; Zuzarte, Calisto Paul</creator><creatorcontrib>Finlay, Ian R ; Lai, Tony Wen Hsun ; Zilio, Daniel C ; Zuzarte, Calisto Paul ; International Business Machines Corporation</creatorcontrib><description>The retrieval of distinct tuples in a relational database management system. In response to a request from a consumer process for distinct tuples in a relational database table matching a defined criteria, a distinct operator component sequentially requests tuples from a source component. The source component access the database table and returns a tuple in the sequence to the distinct operator component. The distinct operator component passes each tuple in the sequence to an auxiliary logger. The auxiliary component receives a tuples from the distinct component and determines if it is distinct from other previously received tuples in the sequence to verify its uniqueness to the distinct operator. Tuples that are verified as unique by the auxiliary logger are returned to the consumer process by the distinct operator upon verification.</description><language>eng</language><creationdate>2010</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7752160$$EPDF$$P50$$Guspatents$$Hfree_for_read</linktopdf><link.rule.ids>230,308,776,798,881,64012</link.rule.ids><linktorsrc>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7752160$$EView_record_in_USPTO$$FView_record_in_$$GUSPTO$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Finlay, Ian R</creatorcontrib><creatorcontrib>Lai, Tony Wen Hsun</creatorcontrib><creatorcontrib>Zilio, Daniel C</creatorcontrib><creatorcontrib>Zuzarte, Calisto Paul</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><title>Method for unordered relational database retrieval returning distinct values</title><description>The retrieval of distinct tuples in a relational database management system. In response to a request from a consumer process for distinct tuples in a relational database table matching a defined criteria, a distinct operator component sequentially requests tuples from a source component. The source component access the database table and returns a tuple in the sequence to the distinct operator component. The distinct operator component passes each tuple in the sequence to an auxiliary logger. The auxiliary component receives a tuples from the distinct component and determines if it is distinct from other previously received tuples in the sequence to verify its uniqueness to the distinct operator. Tuples that are verified as unique by the auxiliary logger are returned to the consumer process by the distinct operator upon verification.</description><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2010</creationdate><recordtype>patent</recordtype><sourceid>EFH</sourceid><recordid>eNqNyjEKAkEMheFpLES9Qy4grIruAUSx0M5eosmugSEjScbzO4IHsPofH2-azheOZyEYikHVYsTGBMYZQ4piBsLAOzo3CxN-N2qrmoqOQOIh-ghoXNnnaTJgdl78OktwPFz3p2X1FwZr-G00_Kbr--16tes2f1w-ug83hw</recordid><startdate>20100706</startdate><enddate>20100706</enddate><creator>Finlay, Ian R</creator><creator>Lai, Tony Wen Hsun</creator><creator>Zilio, Daniel C</creator><creator>Zuzarte, Calisto Paul</creator><scope>EFH</scope></search><sort><creationdate>20100706</creationdate><title>Method for unordered relational database retrieval returning distinct values</title><author>Finlay, Ian R ; Lai, Tony Wen Hsun ; Zilio, Daniel C ; Zuzarte, Calisto Paul</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-uspatents_grants_077521603</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2010</creationdate><toplevel>online_resources</toplevel><creatorcontrib>Finlay, Ian R</creatorcontrib><creatorcontrib>Lai, Tony Wen Hsun</creatorcontrib><creatorcontrib>Zilio, Daniel C</creatorcontrib><creatorcontrib>Zuzarte, Calisto Paul</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><collection>USPTO Issued Patents</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Finlay, Ian R</au><au>Lai, Tony Wen Hsun</au><au>Zilio, Daniel C</au><au>Zuzarte, Calisto Paul</au><aucorp>International Business Machines Corporation</aucorp><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method for unordered relational database retrieval returning distinct values</title><date>2010-07-06</date><risdate>2010</risdate><abstract>The retrieval of distinct tuples in a relational database management system. In response to a request from a consumer process for distinct tuples in a relational database table matching a defined criteria, a distinct operator component sequentially requests tuples from a source component. The source component access the database table and returns a tuple in the sequence to the distinct operator component. The distinct operator component passes each tuple in the sequence to an auxiliary logger. The auxiliary component receives a tuples from the distinct component and determines if it is distinct from other previously received tuples in the sequence to verify its uniqueness to the distinct operator. Tuples that are verified as unique by the auxiliary logger are returned to the consumer process by the distinct operator upon verification.</abstract><oa>free_for_read</oa></addata></record> |
fulltext | fulltext_linktorsrc |
identifier | |
ispartof | |
issn | |
language | eng |
recordid | cdi_uspatents_grants_07752160 |
source | USPTO Issued Patents |
title | Method for unordered relational database retrieval returning distinct values |
url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-13T02%3A31%3A30IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-uspatents_EFH&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=Finlay,%20Ian%20R&rft.aucorp=International%20Business%20Machines%20Corporation&rft.date=2010-07-06&rft_id=info:doi/&rft_dat=%3Cuspatents_EFH%3E07752160%3C/uspatents_EFH%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 |