Executing complex SQL queries using index screening for conjunct or disjunct index operations

Executing complex SQL queries using index screening for conjunct or disjunct index operations

A method, apparatus, and article of manufacture for an index screening system. A query is executed to access data stored on a data storage device connected to a computer. In particular, while accessing one or more indexes to retrieve row identifiers, index matching predicates in the query are applie...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: BEAVIN, THOMAS ABEL, TIE, HONG SANG, HOA, PETER, LIN, FEN-LING
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 BEAVIN
THOMAS ABEL
TIE
HONG SANG
HOA
PETER
LIN
FEN-LING
description A method, apparatus, and article of manufacture for an index screening system. A query is executed to access data stored on a data storage device connected to a computer. In particular, while accessing one or more indexes to retrieve row identifiers, index matching predicates in the query are applied to select row identifiers and index screening predicates in the query are applied to eliminate one or more selected row identifiers.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US6081799A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US6081799A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US6081799A3</originalsourceid><addsrcrecordid>eNrjZIh1rUhNLi3JzEtXSM7PLchJrVAIDvRRKCxNLcpMLVYoLQbJZOalAMWLk4tSU_NA_LT8IqDqvKzSvOQSBSA7JbMYwoYozC9ILUosyczPK-ZhYE1LzClO5YXS3Azybq4hzh66qQX58anFBYnJqXmpJfGhwWYGFobmlpaOxoRVAAA8OTwY</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Executing complex SQL queries using index screening for conjunct or disjunct index operations</title><source>esp@cenet</source><creator>BEAVIN; THOMAS ABEL ; TIE; HONG SANG ; HOA; PETER ; LIN; FEN-LING</creator><creatorcontrib>BEAVIN; THOMAS ABEL ; TIE; HONG SANG ; HOA; PETER ; LIN; FEN-LING</creatorcontrib><description>A method, apparatus, and article of manufacture for an index screening system. A query is executed to access data stored on a data storage device connected to a computer. In particular, while accessing one or more indexes to retrieve row identifiers, index matching predicates in the query are applied to select row identifiers and index screening predicates in the query are applied to eliminate one or more selected row identifiers.</description><edition>7</edition><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2000</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=20000627&amp;DB=EPODOC&amp;CC=US&amp;NR=6081799A$$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&amp;date=20000627&amp;DB=EPODOC&amp;CC=US&amp;NR=6081799A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>BEAVIN; THOMAS ABEL</creatorcontrib><creatorcontrib>TIE; HONG SANG</creatorcontrib><creatorcontrib>HOA; PETER</creatorcontrib><creatorcontrib>LIN; FEN-LING</creatorcontrib><title>Executing complex SQL queries using index screening for conjunct or disjunct index operations</title><description>A method, apparatus, and article of manufacture for an index screening system. A query is executed to access data stored on a data storage device connected to a computer. In particular, while accessing one or more indexes to retrieve row identifiers, index matching predicates in the query are applied to select row identifiers and index screening predicates in the query are applied to eliminate one or more selected row identifiers.</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>2000</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZIh1rUhNLi3JzEtXSM7PLchJrVAIDvRRKCxNLcpMLVYoLQbJZOalAMWLk4tSU_NA_LT8IqDqvKzSvOQSBSA7JbMYwoYozC9ILUosyczPK-ZhYE1LzClO5YXS3Azybq4hzh66qQX58anFBYnJqXmpJfGhwWYGFobmlpaOxoRVAAA8OTwY</recordid><startdate>20000627</startdate><enddate>20000627</enddate><creator>BEAVIN; THOMAS ABEL</creator><creator>TIE; HONG SANG</creator><creator>HOA; PETER</creator><creator>LIN; FEN-LING</creator><scope>EVB</scope></search><sort><creationdate>20000627</creationdate><title>Executing complex SQL queries using index screening for conjunct or disjunct index operations</title><author>BEAVIN; THOMAS ABEL ; TIE; HONG SANG ; HOA; PETER ; LIN; FEN-LING</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US6081799A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2000</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>BEAVIN; THOMAS ABEL</creatorcontrib><creatorcontrib>TIE; HONG SANG</creatorcontrib><creatorcontrib>HOA; PETER</creatorcontrib><creatorcontrib>LIN; FEN-LING</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>BEAVIN; THOMAS ABEL</au><au>TIE; HONG SANG</au><au>HOA; PETER</au><au>LIN; FEN-LING</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Executing complex SQL queries using index screening for conjunct or disjunct index operations</title><date>2000-06-27</date><risdate>2000</risdate><abstract>A method, apparatus, and article of manufacture for an index screening system. A query is executed to access data stored on a data storage device connected to a computer. In particular, while accessing one or more indexes to retrieve row identifiers, index matching predicates in the query are applied to select row identifiers and index screening predicates in the query are applied to eliminate one or more selected row identifiers.</abstract><edition>7</edition><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_US6081799A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Executing complex SQL queries using index screening for conjunct or disjunct index operations
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-17T17%3A01%3A39IST&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=BEAVIN;%20THOMAS%20ABEL&rft.date=2000-06-27&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS6081799A%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