Method and apparatus for partitioned based purging of data

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S793000, C707S793000

Reexamination Certificate

active

07124141

ABSTRACT:
Fast purging of change data from a named change data database table by: (1) partitioning the table into partitions to separate data to be retained from data to be dropped and dropping the partition holding the data to be purged; or (2) creating a temporary change data database table and inserting the change data to be retained into a temporary table, dropping the named change data table, renaming the temporary table as the named table and inserting the change data within the temporary table into the renamed change table; or (3) creating a temporary change data table and copying data above a given value from the named table into the temporary database table, truncating the named table and inserting the data from the temporary into the named table and dropping the temporary table.

REFERENCES:
patent: 5963934 (1999-10-01), Cochrane et al.
patent: 6012126 (2000-01-01), Aggarwal et al.
patent: 6442543 (2002-08-01), Snodgrass et al.
patent: 6789071 (2004-09-01), Kapoor et al.
patent: 2003/0212789 (2003-11-01), Hamel et al.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Method and apparatus for partitioned based purging of data does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for partitioned based purging of data, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for partitioned based purging of data will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3716426

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.