Try OpenEdge Now
skip to main content
Trend Database Guide and Reference
Managing OpenEdge Management Trend Database Data : How data compacting works
 

How data compacting works

When you run OpenEdge Management Trend Database compaction (as a job), the compaction takes a number of the records and compacts them in a different table in the OpenEdge Management Trend Database. For example, the compaction might take the first four records in the table and combine them into one record in the archive table.
As part of the compaction process, the records physically move to the archive table and are deleted from the real-data table. The archive automatically creates an hourly, daily, and weekly version of each sample, as follows:
*Hourly — Takes all the data for an hour and compacts it into one record for that hour. This compaction method takes records for one hour and reduces them to one row.
*Daily — Takes all the data for a day and compacts it into one record for that day. This compaction method takes records for one day and reduces them to one row.
*Weekly — Takes all the data for seven days and compacts it into one record. The week technically begins at midnight on Saturday night. This compaction method takes records for seven days and reduces them to one row.
Caution: There is no option to undo the deletion of data samples from a real-data table following the compaction.