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:
Caution: There is no option to undo the deletion of data samples from a real-data table following the compaction.
- 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.
Copyright © 2008 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |