Information Lifecycle Management (ILM) is a supporting solution for physical federation, data consolidation, and business intelligence. What all these data integration solutions have in common is that the database where the information is being stored continues to grow as daily activity is added to the centralized database. This is not only an issue of data storage costs, but also performance of the applications that access these databases and the cost of managing growing volumes of data. ILM provides a mechanism to automatically move data from primary high speed storage to lower cost storage.
Oracle ILM is a combination of features that are part of the Oracle database and a lightweight GUI that can be used to build an ILM solution. These Oracle database features include Oracle table partitioning, Oracle advanced table compression, and Virtual Private Database (VPD). Oracle VPD is used in an ILM solution by eliminating...