Patent ID: 9588973
Date: 2017-03-07
CPC Classifications: G06F

Claim:
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: receiving, by a processor from an end user, a threshold number of times specified by the end user and a period of time specified by the end user; identifying, by the processor, at least one archival data value in the archive table, said archive table being a set of data values organized using columns and rows, said set of data being only readable and not modifiable, said of data values including the 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 at least one data value residing in a table of said multiple database tables; determining, by the processor, that the specified threshold number of times has not been exceeded, within the specified period of time, by a number of times each archival data value has been moved within the multiple database tables; 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.