Oracle has announced the general availability of Oracle Information Lifecycle Management Assistant (Oracle ILM Assistant), providing customers with a comprehensive range of Information Lifecycle Management (ILM) capabilities for Oracle Database 10g.

Building on Oracle's commitment to meeting the needs of its customers, Oracle ILM Assistant significantly eases the challenge of designing and implementing a strategy to manage the lifecycle of information.
With an increasing amount of information in the enterprise, organisations are required to store vast amounts of data for extended periods of time to meet new regulatory data retention and protection requirements.
A recent study of members of the Independent Oracle User Group (IOUG) found that 92% of respondents expect their database storage needs to increase in 2007. To meet this growth, 64% of respondents said they will increase their spending on storage in 2007. The report, "Managing the Storage Equation: The Converging Roles of Data and Storage Professionals," was produced by Unisphere Research.
By implementing an ILM strategy, customers can benefit from reduced storage costs by keeping a minimum quantity of data on high cost storage devices. In conjunction with the partitioning capabilities of Oracle Database 10g, Oracle ILM Assistant enables users to define lifecycles – when it is time to move or purge data – enabling the maximum quantity of data to be retained at the lowest cost. In addition, Oracle ILM Assistant features simulated table partitioning, storage cost modelling, and reports on security and compliance features in use.
The reliability and scalability of Oracle Database 10g coupled with Oracle Partitioning provides the ideal environment for managing business ILM because the data lies all in one place instead of being stored in multiple formats. As the number of rows in large tables continues to grow, database reliability and query performance in particular can degrade significantly. This is not the case with Oracle. Oracle's sophisticated query optimisation technology avoids referencing partitions containing archival data not required to process application queries.
Oracle Database 10g also features table compression technology to help lower storage costs further. The flexibility inherent in Oracle Database 10g allows it to rapidly adapt to any change in requirements, an important benefit considering the continuing evolution of regulatory mandates.
"Effective ILM is one of the key challenges organizations face today," says Andy Mendelsohn, senior vice president of Database Server Technologies at Oracle. "Oracle ILM Assistant is the first tool of its kind that gives customers practical ILM capabilities using their Oracle Database. Customers can easily and efficiently manage their information lifecycles and may reduce their related storage costs with Oracle ILM Assistant and Oracle Partitioning."