Oracle has unveiled a new management tool to help its database users determine when to move, archive and delete data.
The company has been developing Information Lifecycle Management Assistant, which is based on best practices described by its customers, for more than a year, said Lilian Hobbs, senior principal product manager for ILM Assistant at Oracle.
ILM Assistant has a graphical user interface. It allows users to create lifecycle definitions that are can then be assigned to tables in their database. The tool draw’s on the user’s lifecycle policy to advise on how best to handle data, as well as to provide suggestions on data storage requirements and potential storage cost savings.
Oracle is planning to provide tighter integration between ILM Assistant and specific types of storage devices, Hobbs added. The company is also looking at adding more automation to ILM Assistant.
"The first release is a passive tool," Hobbs said. "It gives you the scripts and you have to go and implement them." The tool is currently date driven in terms of its classification of data, but Oracle plans to offer non-date type classification in future, Hobbs added.
ILM Assistant works with Oracle Database 9i or more recent Database 10g releases.