Method, system, computer product for recovering dropped database table specifying one or more table spaces, recovering the table space being restored using the dropped table history data structure

Method, system, computer product for recovering dropped database table specifying one or more table spaces, recovering the table space being restored using the dropped table history data structure

A technique for recovering a dropped table is provided. One or more table spaces are specified prior to one or more tables being dropped from the specified one or more table spaces. When a table is to be dropped from the one or more specified table spaces, a table identifier, a time stamp, and table...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Huras, Matthew Albert, McInnis, Dale M, Ofer, Effi, Winer, Michael J, Zheng, Roger Luo Q
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 Huras, Matthew Albert
McInnis, Dale M
Ofer, Effi
Winer, Michael J
Zheng, Roger Luo Q
description A technique for recovering a dropped table is provided. One or more table spaces are specified prior to one or more tables being dropped from the specified one or more table spaces. When a table is to be dropped from the one or more specified table spaces, a table identifier, a time stamp, and table definition attributes are stored for the dropped table in a data structure and the table is dropped. Upon receiving a request to restore a table space from the one or more specified table spaces, each of the one or more tables in the table space being restored is recovered using the data structure.
format Patent
fullrecord <record><control><sourceid>uspatents_EFH</sourceid><recordid>TN_cdi_uspatents_grants_07188124</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>07188124</sourcerecordid><originalsourceid>FETCH-uspatents_grants_071881243</originalsourceid><addsrcrecordid>eNqNjr0KwkAQhNNYiPoO-wARjAqmF8XGzl4ud5sfSHLH7p6Q9_PBvFOD2lkN7Hwzs9PkfkaprUmBBxbsUtC2c16QwJE1XguUloBQ2xtS01dgyDqHBowSVShGCNIisEPdlEMkbI8QMp2lj6k0cvpdI_WPCQXGKyFLiBnwPELj3guumwgMz3VgofCgJ5wnk1K1jIu3zhI4Hi7709KHcsFe-FqRirLaZXmerbebP5AHBBBkFQ</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method, system, computer product for recovering dropped database table specifying one or more table spaces, recovering the table space being restored using the dropped table history data structure</title><source>USPTO Issued Patents</source><creator>Huras, Matthew Albert ; McInnis, Dale M ; Ofer, Effi ; Winer, Michael J ; Zheng, Roger Luo Q</creator><creatorcontrib>Huras, Matthew Albert ; McInnis, Dale M ; Ofer, Effi ; Winer, Michael J ; Zheng, Roger Luo Q ; International Business Machines Corporation</creatorcontrib><description>A technique for recovering a dropped table is provided. One or more table spaces are specified prior to one or more tables being dropped from the specified one or more table spaces. When a table is to be dropped from the one or more specified table spaces, a table identifier, a time stamp, and table definition attributes are stored for the dropped table in a data structure and the table is dropped. Upon receiving a request to restore a table space from the one or more specified table spaces, each of the one or more tables in the table space being restored is recovered using the data structure.</description><language>eng</language><creationdate>2007</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/7188124$$EPDF$$P50$$Guspatents$$Hfree_for_read</linktopdf><link.rule.ids>230,308,780,802,885,64038</link.rule.ids><linktorsrc>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7188124$$EView_record_in_USPTO$$FView_record_in_$$GUSPTO$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Huras, Matthew Albert</creatorcontrib><creatorcontrib>McInnis, Dale M</creatorcontrib><creatorcontrib>Ofer, Effi</creatorcontrib><creatorcontrib>Winer, Michael J</creatorcontrib><creatorcontrib>Zheng, Roger Luo Q</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><title>Method, system, computer product for recovering dropped database table specifying one or more table spaces, recovering the table space being restored using the dropped table history data structure</title><description>A technique for recovering a dropped table is provided. One or more table spaces are specified prior to one or more tables being dropped from the specified one or more table spaces. When a table is to be dropped from the one or more specified table spaces, a table identifier, a time stamp, and table definition attributes are stored for the dropped table in a data structure and the table is dropped. Upon receiving a request to restore a table space from the one or more specified table spaces, each of the one or more tables in the table space being restored is recovered using the data structure.</description><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2007</creationdate><recordtype>patent</recordtype><sourceid>EFH</sourceid><recordid>eNqNjr0KwkAQhNNYiPoO-wARjAqmF8XGzl4ud5sfSHLH7p6Q9_PBvFOD2lkN7Hwzs9PkfkaprUmBBxbsUtC2c16QwJE1XguUloBQ2xtS01dgyDqHBowSVShGCNIisEPdlEMkbI8QMp2lj6k0cvpdI_WPCQXGKyFLiBnwPELj3guumwgMz3VgofCgJ5wnk1K1jIu3zhI4Hi7709KHcsFe-FqRirLaZXmerbebP5AHBBBkFQ</recordid><startdate>20070306</startdate><enddate>20070306</enddate><creator>Huras, Matthew Albert</creator><creator>McInnis, Dale M</creator><creator>Ofer, Effi</creator><creator>Winer, Michael J</creator><creator>Zheng, Roger Luo Q</creator><scope>EFH</scope></search><sort><creationdate>20070306</creationdate><title>Method, system, computer product for recovering dropped database table specifying one or more table spaces, recovering the table space being restored using the dropped table history data structure</title><author>Huras, Matthew Albert ; McInnis, Dale M ; Ofer, Effi ; Winer, Michael J ; Zheng, Roger Luo Q</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-uspatents_grants_071881243</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2007</creationdate><toplevel>online_resources</toplevel><creatorcontrib>Huras, Matthew Albert</creatorcontrib><creatorcontrib>McInnis, Dale M</creatorcontrib><creatorcontrib>Ofer, Effi</creatorcontrib><creatorcontrib>Winer, Michael J</creatorcontrib><creatorcontrib>Zheng, Roger Luo Q</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>Huras, Matthew Albert</au><au>McInnis, Dale M</au><au>Ofer, Effi</au><au>Winer, Michael J</au><au>Zheng, Roger Luo Q</au><aucorp>International Business Machines Corporation</aucorp><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method, system, computer product for recovering dropped database table specifying one or more table spaces, recovering the table space being restored using the dropped table history data structure</title><date>2007-03-06</date><risdate>2007</risdate><abstract>A technique for recovering a dropped table is provided. One or more table spaces are specified prior to one or more tables being dropped from the specified one or more table spaces. When a table is to be dropped from the one or more specified table spaces, a table identifier, a time stamp, and table definition attributes are stored for the dropped table in a data structure and the table is dropped. Upon receiving a request to restore a table space from the one or more specified table spaces, each of the one or more tables in the table space being restored is recovered using the data structure.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_uspatents_grants_07188124
source USPTO Issued Patents
title Method, system, computer product for recovering dropped database table specifying one or more table spaces, recovering the table space being restored using the dropped table history data structure
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-08T13%3A51%3A37IST&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=Huras,%20Matthew%20Albert&rft.aucorp=International%20Business%20Machines%20Corporation&rft.date=2007-03-06&rft_id=info:doi/&rft_dat=%3Cuspatents_EFH%3E07188124%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