System and method for archiving to a single database table information located across multiple tables

摘要

A method for archiving to a single database table information located across multiple database tables. The method begins by monitoring at least one data value residing in the multiple database tables. After monitoring, the method continues by identifying at least one archival data value where each archival data value corresponds to a unique data value not exceeding a threshold. An end user provides the threshold used to identify the archival data values prior to execution of the method. After identifying the archival data values, the method continues by storing archive files in the single database table, each archive file comprising at least one archive data value. Finally, after storing the archive files in the single database table, the method concludes by removing from the multiple database tables each archival data value.

主权项

1. A method for archiving to a single database table information located across multiple database tables, said single database table being an archive table, each table of said multiple database tables being an active table, said method comprising:
monitoring at least one data value, each data value of said at least one data value residing in a table of said multiple database tables; identifying, by a processor, at least one archival data value, each archival data value of said at least one archival data value corresponding to a unique data value of said at least one data value, each archival data value of said at least one archival data value not exceeding a threshold; storing at least one archive file in said single database table, each archive file of said at least one archive file comprising said at least one archive data value; and removing from said multiple database tables each archival data value of said at least one archival data value.