Selection of rows and values from indexes with updates

Methods and apparatus, including computer program products, for selection of rows and values from indexes with updates. In general, rows of an index may be associated with validity flags that indicate whether a row has been updated with an update inserted in a delta index; one scheme for value ident...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: ROSS ANDREW, SCHWEDES HOLGER, STEPHAN WOLFGANG, RENKES FRANK, PEH THOMAS
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 ROSS ANDREW
SCHWEDES HOLGER
STEPHAN WOLFGANG
RENKES FRANK
PEH THOMAS
description Methods and apparatus, including computer program products, for selection of rows and values from indexes with updates. In general, rows of an index may be associated with validity flags that indicate whether a row has been updated with an update inserted in a delta index; one scheme for value identifiers may be used for an index and another scheme for one or more delta indexes where all of the indexes are, to at least some extent, compressed according to dictionary-based compression; and multiple delta indexes may be used in alternation such that one delta index may accept updates while another is being updated. The delta indexes may also have validity flags and all updates, such as modifications of values, deletion of records, and inserting of new records may be handled as updates accepted by one or more delta indexes.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US8161024B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US8161024B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US8161024B23</originalsourceid><addsrcrecordid>eNrjZDALTs1JTS7JzM9TyE9TKMovL1ZIzEtRKEvMKU0tVkgrys9VyMxLSa0AcsozSzIUSgtSEktSi3kYWNMSc4pTeaE0N4OCm2uIs4duakF-fGpxQWJyal5qSXxosIWhmaGBkYmTkTERSgA_ky06</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Selection of rows and values from indexes with updates</title><source>esp@cenet</source><creator>ROSS ANDREW ; SCHWEDES HOLGER ; STEPHAN WOLFGANG ; RENKES FRANK ; PEH THOMAS</creator><creatorcontrib>ROSS ANDREW ; SCHWEDES HOLGER ; STEPHAN WOLFGANG ; RENKES FRANK ; PEH THOMAS</creatorcontrib><description>Methods and apparatus, including computer program products, for selection of rows and values from indexes with updates. In general, rows of an index may be associated with validity flags that indicate whether a row has been updated with an update inserted in a delta index; one scheme for value identifiers may be used for an index and another scheme for one or more delta indexes where all of the indexes are, to at least some extent, compressed according to dictionary-based compression; and multiple delta indexes may be used in alternation such that one delta index may accept updates while another is being updated. The delta indexes may also have validity flags and all updates, such as modifications of values, deletion of records, and inserting of new records may be handled as updates accepted by one or more delta indexes.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2012</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=20120417&amp;DB=EPODOC&amp;CC=US&amp;NR=8161024B2$$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&amp;date=20120417&amp;DB=EPODOC&amp;CC=US&amp;NR=8161024B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>ROSS ANDREW</creatorcontrib><creatorcontrib>SCHWEDES HOLGER</creatorcontrib><creatorcontrib>STEPHAN WOLFGANG</creatorcontrib><creatorcontrib>RENKES FRANK</creatorcontrib><creatorcontrib>PEH THOMAS</creatorcontrib><title>Selection of rows and values from indexes with updates</title><description>Methods and apparatus, including computer program products, for selection of rows and values from indexes with updates. In general, rows of an index may be associated with validity flags that indicate whether a row has been updated with an update inserted in a delta index; one scheme for value identifiers may be used for an index and another scheme for one or more delta indexes where all of the indexes are, to at least some extent, compressed according to dictionary-based compression; and multiple delta indexes may be used in alternation such that one delta index may accept updates while another is being updated. The delta indexes may also have validity flags and all updates, such as modifications of values, deletion of records, and inserting of new records may be handled as updates accepted by one or more delta indexes.</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>2012</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZDALTs1JTS7JzM9TyE9TKMovL1ZIzEtRKEvMKU0tVkgrys9VyMxLSa0AcsozSzIUSgtSEktSi3kYWNMSc4pTeaE0N4OCm2uIs4duakF-fGpxQWJyal5qSXxosIWhmaGBkYmTkTERSgA_ky06</recordid><startdate>20120417</startdate><enddate>20120417</enddate><creator>ROSS ANDREW</creator><creator>SCHWEDES HOLGER</creator><creator>STEPHAN WOLFGANG</creator><creator>RENKES FRANK</creator><creator>PEH THOMAS</creator><scope>EVB</scope></search><sort><creationdate>20120417</creationdate><title>Selection of rows and values from indexes with updates</title><author>ROSS ANDREW ; SCHWEDES HOLGER ; STEPHAN WOLFGANG ; RENKES FRANK ; PEH THOMAS</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US8161024B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2012</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>ROSS ANDREW</creatorcontrib><creatorcontrib>SCHWEDES HOLGER</creatorcontrib><creatorcontrib>STEPHAN WOLFGANG</creatorcontrib><creatorcontrib>RENKES FRANK</creatorcontrib><creatorcontrib>PEH THOMAS</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>ROSS ANDREW</au><au>SCHWEDES HOLGER</au><au>STEPHAN WOLFGANG</au><au>RENKES FRANK</au><au>PEH THOMAS</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Selection of rows and values from indexes with updates</title><date>2012-04-17</date><risdate>2012</risdate><abstract>Methods and apparatus, including computer program products, for selection of rows and values from indexes with updates. In general, rows of an index may be associated with validity flags that indicate whether a row has been updated with an update inserted in a delta index; one scheme for value identifiers may be used for an index and another scheme for one or more delta indexes where all of the indexes are, to at least some extent, compressed according to dictionary-based compression; and multiple delta indexes may be used in alternation such that one delta index may accept updates while another is being updated. The delta indexes may also have validity flags and all updates, such as modifications of values, deletion of records, and inserting of new records may be handled as updates accepted by one or more delta indexes.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_US8161024B2
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Selection of rows and values from indexes with updates
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-28T14%3A42%3A13IST&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=ROSS%20ANDREW&rft.date=2012-04-17&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS8161024B2%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