ILM Consulting

Information Lifecycle Management

ILM is a set of rules that rule the datas lifecycle. From a business standpoint, data has different faces: creation, reception, distribution, use, maintenance and provision. Provision is the information management practice less frequently used. Although a small proportion of organizational information never loses its value, most information loses its value over time. The value of almost all information is high shortly after being created, and in most cases this time varies between 1 to 3 years, after which its value declines rapidly. The registers then perform the transit through their life cycle to semi-active and finally inactive states.

ILM projects accompany the informations transit throught it´s lifecycle, by either moving the storaged data to lower range storage, historical databases, backups or deletion.

The techniques used in ILM projects are:

• Data processing through batch processes developed in java or PL / SQL with batch operations (bulk) to ensure performance and reduce the impact
• Cleaning and transfer of data based in the option of partitioning and transportable tablespace.

In most cases, the obsolescence criteria coincide with the time elapsed since the data was created. However, there are more complex cases where this simple rule is not enough, such as:

• Time since last change.
• One condition of the records makes the rule invalid.
• The rule is based on other tables dates.
• Dependencies in the provision, meaning, first the layout of the child tables must be made and then the master tables.