SHARE
Follow this article on Twitter Facebook LinkedIn Bookmark and Share
Home >> Information Architecture >> Data Warehousing

Oracle offers lifecycle data management tool

Oracle offers lifecycle data management tool

By:  China Martens  On: 26 Feb 2007 For: IDG News Service (Boston Bureau) Creator

Oracle Corp. Monday unveiled a new management tool to help its database users determine when to move, archive and delete data

COMMENT ON THIS ARTICLE

Oracle Corp. Monday unveiled a new management tool to help its database users determine when to move, archive and delete data.

Oracle has been developing Information Lifecycle Management Assistant, a graphical user interface-based tool, based on ILM best practices described by its customers, for more than a year, according to Lilian Hobbs, senior principal product manager for ILM Assistant at Oracle.

While users are spoiled for choice when it comes to archiving tools, she said customers have been looking for software to help them manage their data over the course of its lifetime. As users' databases treble in size every two years or so, finding ways to lower the cost of storing all that data is becoming more critical, added Willie Hardie, vice president of database product marketing at Oracle.

Using ILM Assistant, an Oracle customer can create lifecycle definitions that are then assigned to tables in their database. The tool uses the customer's lifecycle policy to advise on how best to handle data as well as provide input on data storage requirements and how to realize cost savings in storage. For instance, Hardie said that as data ages and is less frequently accessed and updated, the information no longer needs to be stored on the fastest, most expensive storage devices and can be moved over to low-cost alternatives.

Looking ahead, Oracle plans to provide tighter integration between ILM Assistant and specific types of storage devices, Hobbs said. Already, based on customer feedback, the vendor has provided a white paper on how best to use the Oracle tool with Network Appliance Inc.'s SnapLock disk-based data retention software.

Oracle is also looking to add more automation into 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 very much date driven in terms of its classification of data, but Oracle plans to offer nondate type classification in future, she added, for instance, classifying data by its status as active or non-active.

Currently, in order to use ILM Assistant, users must install the vendor's free Application Express Web application development tool as well. Oracle looks to remove that restriction in future, Hobbs said.

ILM Assistant works with Oracle Database 9i or more recent Database 10g releases. The tool is free to Oracle Database Enterprise Edition users and can be downloaded here.

COMMENT ON THIS ARTICLE


Sign up for our Newsletters












Print |  Views: 675   |   Rating:offoffoffoffoff  (0 votes)
Rate this article on a scale of
1 to 5 stars,5 being the best.




China Martens China Martens is a contributor to the International Data Group (IDG) News Service, which publishes global technology stories from bureaus around the world to more than 300 publications in more than 60 countries.

Related Content

Blogosphere: Oracle as an OEM
Blogosphere: Oracle as an OEMOne pundit says leaders in the date warehouse appliance space, such as Teradata and Netazza, will not disappear. Get the tech industry chatter on HP Oracle Database Machine
Oracle pitches high-speed data warehouse server
Oracle pitches high-speed data warehouse serverSpeaking at OpenWorld 2008 in San Francisco, chief executive Larry Ellison discusses what he calls the database giant's first hardware products, server racks from HP preconfigured with its software
Oracle puts its 11g database in Amazon's cloud
Oracle puts its 11g database in Amazon's cloudIn what Forrester describes as a “game changing move,” the database behemoth is offering software that lets customers backup to Amazon Simple Storage Service. Will IBM and Teradata follow suit?
Oracle expects you to Super-size your 11g
this is why major technology companies don't reveal the full details about pricing when they launc
There's logic in Sybase's RAC attack
the whole idea of innovation is to build a better mousetrap, but sybase’s latest product shows you can also focus on simply building a better piece of the mousetrap.sybase is a database management company so boring it’s almost never included in the same breath as oracle, ibm’s db2 or sql server. what it lacks in hype, however, it makes up for in sheer survival. the company maintains a s
blog comments powered by Disqus