Method and system for deferred maintenance of database indexes

Method and system for deferred maintenance of database indexes

Rectifying discrepancies between a table, from which a segment of data has been removed, and an index for the table may be deferred. Each entry in the index is sequentially analyzed to remove entries therefrom referring to any removed segment referenced in the starting location list. During this pro...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Kennedy, John Paul, Hong, Quanhua, O'Connell, William T, Buback, Leslie Anne
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 Kennedy, John Paul
Hong, Quanhua
O'Connell, William T
Buback, Leslie Anne
description Rectifying discrepancies between a table, from which a segment of data has been removed, and an index for the table may be deferred. Each entry in the index is sequentially analyzed to remove entries therefrom referring to any removed segment referenced in the starting location list. During this process, if a segment newly removed from the table is detected, then analysis of the index entries continues and an indicator is set that another segment has been removed. Analysis of the entries continues in a looping fashion until each entry has been assessed to determine if it makes a reference to any of the removed segments. If a query is received before rectification is complete then the query is amended by establishing search boundaries based so that the query does not produce any entries in the index referring to removed segments.
format Patent
fullrecord <record><control><sourceid>uspatents_EFH</sourceid><recordid>TN_cdi_uspatents_grants_07945543</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>07945543</sourcerecordid><originalsourceid>FETCH-uspatents_grants_079455433</originalsourceid><addsrcrecordid>eNrjZLDzTS3JyE9RSMxLUSiuLC5JzVVIyy9SSElNSy0qSk1RyE3MzCtJzUvMS05VyE9TSEksSUxKLE5VyMxLSa1ILeZhYE1LzClO5YXS3AwKbq4hzh66pcUFiUB9JcXx6UWJIMrA3NLE1NTE2JgIJQAQiTFb</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method and system for deferred maintenance of database indexes</title><source>USPTO Issued Patents</source><creator>Kennedy, John Paul ; Hong, Quanhua ; O'Connell, William T ; Buback, Leslie Anne</creator><creatorcontrib>Kennedy, John Paul ; Hong, Quanhua ; O'Connell, William T ; Buback, Leslie Anne ; International Business Machines Corporation</creatorcontrib><description>Rectifying discrepancies between a table, from which a segment of data has been removed, and an index for the table may be deferred. Each entry in the index is sequentially analyzed to remove entries therefrom referring to any removed segment referenced in the starting location list. During this process, if a segment newly removed from the table is detected, then analysis of the index entries continues and an indicator is set that another segment has been removed. Analysis of the entries continues in a looping fashion until each entry has been assessed to determine if it makes a reference to any of the removed segments. If a query is received before rectification is complete then the query is amended by establishing search boundaries based so that the query does not produce any entries in the index referring to removed segments.</description><language>eng</language><creationdate>2011</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/7945543$$EPDF$$P50$$Guspatents$$Hfree_for_read</linktopdf><link.rule.ids>230,308,780,802,885,64039</link.rule.ids><linktorsrc>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7945543$$EView_record_in_USPTO$$FView_record_in_$$GUSPTO$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Kennedy, John Paul</creatorcontrib><creatorcontrib>Hong, Quanhua</creatorcontrib><creatorcontrib>O'Connell, William T</creatorcontrib><creatorcontrib>Buback, Leslie Anne</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><title>Method and system for deferred maintenance of database indexes</title><description>Rectifying discrepancies between a table, from which a segment of data has been removed, and an index for the table may be deferred. Each entry in the index is sequentially analyzed to remove entries therefrom referring to any removed segment referenced in the starting location list. During this process, if a segment newly removed from the table is detected, then analysis of the index entries continues and an indicator is set that another segment has been removed. Analysis of the entries continues in a looping fashion until each entry has been assessed to determine if it makes a reference to any of the removed segments. If a query is received before rectification is complete then the query is amended by establishing search boundaries based so that the query does not produce any entries in the index referring to removed segments.</description><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2011</creationdate><recordtype>patent</recordtype><sourceid>EFH</sourceid><recordid>eNrjZLDzTS3JyE9RSMxLUSiuLC5JzVVIyy9SSElNSy0qSk1RyE3MzCtJzUvMS05VyE9TSEksSUxKLE5VyMxLSa1ILeZhYE1LzClO5YXS3AwKbq4hzh66pcUFiUB9JcXx6UWJIMrA3NLE1NTE2JgIJQAQiTFb</recordid><startdate>20110517</startdate><enddate>20110517</enddate><creator>Kennedy, John Paul</creator><creator>Hong, Quanhua</creator><creator>O'Connell, William T</creator><creator>Buback, Leslie Anne</creator><scope>EFH</scope></search><sort><creationdate>20110517</creationdate><title>Method and system for deferred maintenance of database indexes</title><author>Kennedy, John Paul ; Hong, Quanhua ; O'Connell, William T ; Buback, Leslie Anne</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-uspatents_grants_079455433</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2011</creationdate><toplevel>online_resources</toplevel><creatorcontrib>Kennedy, John Paul</creatorcontrib><creatorcontrib>Hong, Quanhua</creatorcontrib><creatorcontrib>O'Connell, William T</creatorcontrib><creatorcontrib>Buback, Leslie Anne</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>Kennedy, John Paul</au><au>Hong, Quanhua</au><au>O'Connell, William T</au><au>Buback, Leslie Anne</au><aucorp>International Business Machines Corporation</aucorp><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method and system for deferred maintenance of database indexes</title><date>2011-05-17</date><risdate>2011</risdate><abstract>Rectifying discrepancies between a table, from which a segment of data has been removed, and an index for the table may be deferred. Each entry in the index is sequentially analyzed to remove entries therefrom referring to any removed segment referenced in the starting location list. During this process, if a segment newly removed from the table is detected, then analysis of the index entries continues and an indicator is set that another segment has been removed. Analysis of the entries continues in a looping fashion until each entry has been assessed to determine if it makes a reference to any of the removed segments. If a query is received before rectification is complete then the query is amended by establishing search boundaries based so that the query does not produce any entries in the index referring to removed segments.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_uspatents_grants_07945543
source USPTO Issued Patents
title Method and system for deferred maintenance of database indexes
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-02T08%3A40%3A02IST&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=Kennedy,%20John%20Paul&rft.aucorp=International%20Business%20Machines%20Corporation&rft.date=2011-05-17&rft_id=info:doi/&rft_dat=%3Cuspatents_EFH%3E07945543%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