Information Lifecycle Management (ILM)

Information Lifecycle Management (ILM) is a methodology designed to address data management issues. Old data starts becoming an overhead to the overall application not only in terms of storage, but also in terms of performance. This older data, which has completed its lifecycle, can be possibly removed from the system to make an overall savings in terms of cost and performance. The archival implementation need to ensure that referential integrity of the overall system is maintained. Archiving keeps the volume of data in the production database at a manageable level without compromising the system's ability to perform normal operations.

The Information Lifecycle Management (ILM) includes the following three processes:

1. Setup - The setup process is all about how you implement the ILM feature. The following figure indicates the different steps that you need to perform to implement the ILM feature:

   
   

   

   
   

2. Execution - The execution process is a process where you execute the ILM batches to identify and mark the records which are eligible for archival. You can either execute the required ILM Crawler batch (i.e. C1-ADCRL, C1-BLCRL, C1-BCCRL, C1-TCCRL, or C1-FMCRL) or just execute the ILM Crawler Initiator (F1-ILMIN) batch. The following figure indicates how the ILM Crawler batch identifies and marks the records which are eligible for archival:

   
   

   

   
   

   The following figure indicates how the ILM Crawler Initiator batch identifies and marks the records which are eligible for archival:

   
   

   

   
   

3. Maintenance - The maintenance process is a process where you archive and then drop the table partitions where all records are eligible for archival. The following figure indicates the steps involved in the maintenance process:

   
   

   

   
   

Parent Topic: Oracle Revenue Management and Billing Generic Business Processes