How to optimize application data with a new approach to structured data management

image003.jpegBy Phil Nguyen, HP Software Community Director


Volume of structured data continues to mushroom. The result is a compounding series of challenges for large IT organizations, from reduced application performance to an expanding (and costly) storage footprint.


It also makes it difficult to manage data according to corporate policies and regulatory requirements, which leads to compliance risks, while backup and recovery windows grow and add pressure on IT staff.


The explosion of application data is a big problem that’s not going away, and it’s not sustainable to just keep throwing resources it. Organizations need to find ways to manage data that systematically minimizes the database footprint.


In an interesting new podcast by HP Storage Blogger Calvin Zito (@HPStorageGuy), Joe Leung walks listeners through how new software from HP Autonomy addresses these challenges.


Introducing Application Information Optimizer


The software is HP Application Information Optimizer an update to what was previously known as HP Database Archiving software. HP Application Information Optimizer integrates several systems and offers a new approach that makes it easier to manage the overall structured data lifecycle


The big advantage is that HP Application Information Optimizer provides the ability to easily pull data out of the databases and move the data via built-in integrations into different target destinations, such as Autonomy Consolidated Archive or HP TRIM for comprehensive structured and unstructured information management, or even HP Vertica’s high-performance analytics platform to extract more value out of the data you’ve got.


HP Application Information Optimizer lets you archive data from costly Tier 1 production system to a TIer 2 storage system or to HP Cloud Services for lower cost and off-site storage while still maintaining access to data.


Migrating legacy application data


In addition to production databases, this solution works equally well for migrating data out of legacy application databases that are being maintained not for the application—which may not be in use anymore—but to retain access to the data. Decommissioning these legacy environments eliminates a lot of unnecessary maintenance costs.


There’s also direct integration with meaning-based Intelligent Data Operating Layer (IDOL) to allow you to do “plain English” universal searches without SQL across all the production and legacy databases,  and archive repositories, offering you the ability to do a single search across 10 databases, for example, as opposed to the traditional 10 separate searches.


The podcast is worth a listen, especially if you’re facing some of these challenges and are already using TRIM, Autonomy Consolidated Archive or Vertica software. He provides some remarkable details about how a large-scale customer has used HP Application Information Optimizer to reap some pretty incredible benefits, including reducing database query time by as much as 89%.


Check out Calvin’s blog and listen to the podcast here.


To find out more about Application Information Optimizer, visit

Leave a Comment

We encourage you to share your comments on this post. Comments are moderated and will be reviewed
and posted as promptly as possible during regular business hours

To ensure your comment is published, be sure to follow the Community Guidelines.

Be sure to enter a unique name. You can't reuse a name that's already in use.
Be sure to enter a unique email address. You can't reuse an email address that's already in use.
Type the characters you see in the picture above.Type the words you hear.
Showing results for 
Search instead for 
Do you mean 
About the Author
This account is for guest bloggers. The blog post will identify the blogger.

Follow Us
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.