Systems and Methods for a Database Archive

A method for archiving data records in an archive repository, the method comprising:

• modifying, by a server, a first data record;
• generating, by the server, a first change data record based on the modification of the first data record;
• storing, by the server, the first change data record in a first repository,
• wherein the first repository is configured to store data records;
• determining, by the server, the first repository includes at least a first threshold number of change data records;
• determining, by the server, a second repository includes at least a second threshold number of change data records,
• wherein the second repository is configured to store data records, and wherein the first threshold number and the second threshold number are equal;
• retrieving, by the server and in response to:
• the first repository including at least the first threshold number of change data records and the second repository including least the second threshold number of change data records, a plurality of change data records of the second repository;
• generating, by the server, a plurality of data files,
• wherein each change file includes at least one change data record of the second plurality of change data records, and wherein the archive repository is configured to store data files;
• storing, by the server, the plurality of data files in the archive repository;
• modifying, by the server, a second data record;
• generating, by the server, a second change data record based on the modification of the second data record;
• and
• storing, by the server, the second change data record in the second repository.

A non-transitory computer readable medium having computer executable instructions embodied therein that, when executed by at least one processor of a computing system, cause the computing system to perform operations to archive data records in an archive repository, the operations comprising:

• generating a first data record;
• storing the first data record in a first repository,
• wherein the first repository is configured to store data records;
• determining the first repository includes at least a first threshold number of data records;
• determining a second repository includes at least a second threshold number of data records,
• wherein the second repository is configured to store data records, and wherein the first threshold number and the second threshold number are equal;
• retrieving, in response to:
• the first repository including at least the first threshold number of data records and the first repository including at least the second threshold number of data records, a plurality of data records from the second repository;
• generating a plurality of data files,
• wherein each data file includes at least one data record of the plurality of data records, and wherein the archive repository is configured to store data files;
• storing the plurality of data files in the archive repository;
• generating a second data record;
• and
• storing the second data record in the second repository.

A method for archiving data records in an archive repository, the method comprising:

• generating, by a server, a first data record;
• storing, by the server, the first data record in a first repository,
• wherein the first repository is configured to store data records;
• determining, by the server, the first repository includes at least a first threshold number of data records;
• determining, by the server, a second repository includes at least a second threshold number of data records,
• wherein the second repository is configured to store data records, wherein the first threshold number is inclusively between 20 million and 30 million, and wherein the second threshold number is inclusively between 20 million and 30 million;
• retrieving, by the server and in response to:
• the first repository including at least the first threshold number of data records and the first repository including at least the second threshold number of data records, a plurality of data records from the second repository;
• generating, by the server, a plurality of data files,
• wherein each data file includes at least one data record of the plurality of data records, and wherein the archive repository is configured to store data files;
• storing, by the server, the plurality of data files in the archive repository;
• generating, by the server, a second data record;
• and
• storing, by the server, the second data record in the second repository.