US2010228787A1PendingUtilityA1

Online data volume deletion

Assignee: HEMPELMANN HENRIKPriority: Jan 30, 2006Filed: Mar 15, 2010Published: Sep 9, 2010
Est. expiryJan 30, 2026(expired)· nominal 20-yr term from priority
G06F 16/2379
40
PatentIndex Score
0
Cited by
0
References
0
Claims

Abstract

A system to delete a data volume may include storage of a plurality of data pages of the data volume of a data area into a cache, prevention of writing of data pages to the data volume, and designation of each of the plurality of data pages in the cache as modified. The system may also include writing of all data pages in the cache that are designated as modified to a respective location in one or more other data volumes of the data area, and updating, for each of the written data pages, a converter page of the cache to associate the written data page with its respective location in the one or more other data volumes.

Claims

exact text as granted — not AI-modified
1 . A method for managing a data volume of a data area, the method comprising:
 storing a plurality of data pages into a cache, wherein each of the stored plurality of data pages is a copy of a respective one of a plurality of data pages of the data volume;   preventing writing of data pages to the data volume;   designating each of the plurality of data pages stored in the cache as modified with respect to a respective data page stored in the data volume, wherein each one of a plurality of the data pages stored in the cache is identical to the respective data page stored in the data volume when the designating of that one as modified with respect to the respective data page stored in the data volume is initiated;   writing all data pages in the cache that are designated as modified to a respective location in one or more other data volumes of the data area; and   for each of the written data pages, updating a converter page of the cache to associate the written data page with its respective location in the one or more other data volumes.   
   
   
       2 . A method according to  claim 1 , wherein storing the plurality of data pages comprises:
 identifying the plurality of data pages of the data volume based on a plurality of converter pages of the cache that associate each of the plurality of data pages with a respective location in the data volume; and   for each of the plurality of data pages, determining if the data page is stored in the cache, and, if the data page is not stored in cache, reading the data page from the data volume and storing the data page into the cache.   
   
   
       3 . A method according to  claim 1 , further comprising:
 identifying a plurality of converter pages of the cache that are associated with respective converter pages of the data volume;   designating the plurality of converter pages as modified;   writing all converter pages in the cache that are designated as modified to a respective location in the one or more other data volumes of the data area; and   updating each of the written converter pages in the cache to indicate its respective location in the one or more other data volumes of the data area.   
   
   
       4 . A method according to  claim 3 , further comprising:
 for each of the written converter pages, updating a converter index page of the data area to associate the written converter page with its respective location in the one or more other data volumes.   
   
   
       5 . A method according to  claim 1 , further comprising:
 for each of the updated converter pages, further updating the converter page to indicate a respective location in the one or more other data volumes of the cache;   writing each of the updated converter pages to its indicated respective location in the one or more other data volumes; and   designating locations of the plurality of data pages in the data volume as free.   
   
   
       6 . A method according to  claim 5 , further comprising:
 for each of the written updated converter pages, updating a converter index page of the data area to associate the written updated converter page with its indicated respective location in the one or more other data volumes.   
   
   
       7 . A method according to  claim 1 , further comprising:
 determining that the data volume includes a restart page;   moving the restart page to a location in the one or more other data volumes; and   modifying a page of one of the one or more other data volumes to indicate the location to which the restart page was moved.   
   
   
       8 . A tangible computer-readable medium storing program code to manage a data volume of a data area, the program code comprising:
 code to store a plurality of data pages into a cache wherein each of the stored plurality of data pages is a copy of a respective one of a plurality of data pages of the data volume;   code to prevent writing of data pages to the data volume;   code to designate each of the plurality of data pages stored in the cache as modified with respect to a respective data page stored in the data volume, wherein each one of a plurality of the data pages stored in the cache is identical to the respective data page stored in the data volume when the designation of that one as modified with respect to the respective data page stored in the data volume is initiated;   code to write all data pages in the cache that are designated as modified to a respective location in one or more other data volumes of the data area; and   code to update, for each of the written data pages, a converter page of the cache to associate the written data page with its respective location in the one or more other data volumes.   
   
   
       9 . A tangible medium according to  claim 8 , wherein the code to store the plurality of data pages comprises:
 code to identify the plurality of data pages of the data volume based on a plurality of converter pages of the cache that associate each of the plurality of data pages with a respective location in the data volume; and   code to determine, for each of the plurality of data pages, if the data page is stored in the cache, and, if the data page is not stored in cache, code to read the data page from the data volume and to store the data page into the cache.   
   
   
       10 . A tangible medium according to  claim 8 , the program code further comprising:
 code to identify a plurality of converter pages of the cache that are associated with respective converter pages of the data volume;   code to designate the plurality of converter pages as modified;   code to write all converter pages in the cache that are designated as modified to a respective location in the one or more other data volumes of the data area; and   code to update each of the written converter pages in the cache to indicate its respective location in the one or more other data volumes of the data area.   
   
   
       11 . A tangible medium according to  claim 10 , the program code further comprising:
 code to update, for each of the written converter pages, a converter index page of the data area to associate the written converter page with its respective location in the one or more other data volumes.   
   
   
       12 . A tangible medium according to  claim 8 , the program code further comprising:
 code to further update, for each of the updated converter pages, the converter page to indicate a respective location in the one or more other data volumes of the cache;   code to write each of the updated converter pages to its indicated respective location in the one or more other data volumes; and   code to designate locations of the plurality of data pages in the data volume as free.   
   
   
       13 . A tangible medium according to  claim 12 , the program code further comprising:
 code to update, for each of the written updated converter pages, a converter index page of the data area to associate the written updated converter page with its indicated respective location in the one or more other data volumes.   
   
   
       14 . A tangible medium according to  claim 8 , the program code further comprising:
 code to determine that the data volume includes a restart page;   code to move the restart page to a location in the one or more other data volumes; and   code to modify a page of one of the one or more other data volumes to indicate the location to which the restart page was moved.   
   
   
       15 . A system comprising:
 a database comprising:
 a data area; 
 a data volume of the data area, the data volume comprising a plurality of data pages; and 
 one or more other data volumes of the data area; 
   a cache to store data pages and converter pages; and   a database management system in communication with the database and the cache, the database management system to:
 store the plurality of data pages into the cache, wherein each of the stored plurality of data pages is a copy of a respective one of a plurality of data pages of the data volume; 
 prevent writing of data pages to the data volume; 
 designate each of the plurality of data pages stored in the cache as modified with respect to a respective data page stored in the data volume, wherein each one of a plurality of the data pages is identical to the respective data page stored in the data volume when the designation of that one as modified with respect to the respective data page stored in the data volume is initiated; 
 write all data pages in the cache that are designated as modified to a respective location in the one or more other data volumes; and 
 update, for each of the written data pages, a converter page of the cache to associate the written data page with its respective location in the one or more other data volumes. 
   
   
   
       16 . A system according to  claim 15 , wherein storage of the plurality of data pages comprises:
 identification of the plurality of data pages of the data volume based on a plurality of converter pages of the cache that associate each of the plurality of data pages with a respective location in the data volume; and   determination, for each of the plurality of data pages, of whether the data page is stored in the cache, and, if the data page is not stored in cache, reading of the data page from the data volume and storage of the data page into the cache.   
   
   
       17 . A system according to  claim 15 , the database management system further to:
 identify a plurality of converter pages of the cache that are associated with respective converter pages of the data volume;   designate the plurality of converter pages as modified;   write all converter pages in the cache that are designated as modified to a respective location in the one or more other data volumes of the data area; and   update each of the written converter pages in the cache to indicate its respective location in the one or more other data volumes of the data area.   
   
   
       18 . A system according to  claim 17 , the database management system further to:
 update, for each of the written converter pages, a converter index page of the data area to associate the written converter page with its respective location in the one or more other data volumes.   
   
   
       19 . A system according to  claim 15 , the database management system further to:
 update, for each of the updated converter pages, the converter page to indicate a respective location in the one or more other data volumes of the cache;   write each of the updated converter pages to its indicated respective location in the one or more other data volumes; and   designate locations of the plurality of data pages in the data volume as free.   
   
   
       20 . A system according to  claim 19 , the database management system further to:
 update, for each of the written updated converter pages, a converter index page of the data area to associate the written updated converter page with its indicated respective location in the one or more other data volumes.   
   
   
       21 . A system according to  claim 15 , the database management system further to:
 determine that the data volume includes a restart page;   move the restart page to a location in the one or more other data volumes; and   modify a page of one of the one or more other data volumes to indicate the location to which the restart page was moved.   
   
   
       22 . A method for managing a data volume of a data area, the method comprising:
 storing a plurality of data pages of the data volume into a cache;   preventing writing of data pages to the data volume;   designating each data page of the stored data pages as modified with respect to a respective data page of the data pages of the data volume regardless of whether the data page of the stored data pages is an identical version or a modified version of the respective data page of the data pages of the data volume;   writing each of the stored data pages that is designated as modified to a respective location in one or more other data volumes of the data area; and   for each data page of the written data pages, updating a converter page of the cache to associate the written data page with its respective location in the one or more other data volumes.   
   
   
       23 . A method according to  claim 1 , wherein the designating each of the plurality of data pages stored in the cache as modified with respect to a respective data page stored in the data volume comprises:
 designating, during the preventing writing of data pages to the data volume, each of the plurality of data pages stored in the cache as modified with respect to the respective data page stored in the data volume.   
   
   
       24 . A method according to  claim 1 , wherein the preventing writing of data pages to the data volume comprises:
 designating the data volume as read only.   
   
   
       25 . A method according to  claim 1 , further comprising:
 not writing the data pages designated as modified to the respective data page stored in the data volume.   
   
   
       26 . A method according to  claim 23 , wherein the preventing writing of data pages to the data volume comprises designating the data volume as read only and wherein the method further comprises not writing the data pages designated as modified to the respective data page stored in the data volume. 
   
   
       27 . An apparatus according to  claim 8 , wherein the code to designate each of the plurality of data pages stored in the cache as modified with respect to a respective data page stored in the data volume comprises:
 code to designate, during the prevention of writing of data pages to the data volume, each of the plurality of data pages stored in the cache as modified with respect to the respective data page stored in the data volume.   
   
   
       28 . A system according to  claim 15 , wherein the designation each of the plurality of data pages stored in the cache as modified with respect to a respective data page stored in the data volume comprises:
 designation, during the prevention of writing of data pages to the data volume, of each of the plurality of data pages stored in the cache as modified with respect to a respective data page stored in the data volume.   
   
   
       29 . A method according to  claim 22 , wherein the designating each data page of the stored data pages as modified with respect to a respective data page of the data pages of the data volume comprises:
 designating, during the preventing writing of data pages to the data volume, each data page of the stored data pages as modified with respect to a respective data page of the data pages of the data volume.

Join the waitlist — get patent alerts

Track US2010228787A1 — get alerts on status changes and closely related new filings.

We store only your email — no account needed. See our privacy policy.