SYSTEM AND METHOD FOR PAGE DEFRAGMENTATION AND DATA COMPACTION DURING DATA BACKUP

摘要

In one implementation, the present invention when used during backup operation, it processes the contents in the database, file by file, by getting rid of or by removing the dead tuples in the pages, and ensuring a page is contiguous. The data in multiple places in the page is aligned after the page head which allows a maximum usable content in the page available as a single chunk in the page. Further, a hint on the length of data, while writing the backup content of the changed pages is provided in the page header. The present invention when used in offline data, dead tuples in the pages, may be removed in the same way as explained above, and when used during restore operation, checks if the pages have already been de-fragmented. If the pages are de-fragmented, the present invention writes only portions of the page that contain the valid data. (TO BE PUBLISHED WITH FIGURE 4 & 5(b))