Design and Develop Processing Algorithms

If any of the tables are involved in an aggregate summary, you may need to write a processing algorithm that inserts summary records to represent the deleted detail records. The logic for these programs depends heavily on the type of aggregate summary. Often you can avoid these situations by limiting the set of archived or purged data.

For example, if you were to choose to archive credit rating history records, use a criteria algorithm that returns false if the credit rating history is not expired. Since expired credit rating history records do not contribute to the aggregate summary, it is not necessary to develop a processing algorithm.