Provide an interface for archiving data from any table
Multiple tables have a need to be archived as data grows in size, particularly the captured Metrics for trends, (afmmetrictrend_values) , notifications log, and data event logs. When there is no auto archive process integrated, an archiving console could be provided that will allow the user to determine
a. the table to be archived
b. whole or partial archive
c. date or pkey (or other criteria) for archiving a partial data set
d. merge to existing historical table or create a new historical table
The process would then use these options to remove records from the data table in question, and move them into the archive. It should be extensible so that new tables, or custom tables will also be compatible.
Mike Garabedian
shared this idea
-
Victor Espinel
commented
At least this should be an option for data event log that grows (maybe auto-archive old stuff) a lot with time and causes problems in the system