HP Reference Information Manager for Databases manages accelerating data growth for enterprises with large database applications, is designed to improve application performance and meet compliance while lowering total cost of ownership. Through Open Archive, aged transactions that are no longer required by applications can be stored for compliance reasons in an open-standards based XML format. Through Live Archive, application transparency is retained by providing online, real-time user access to a combined view of production and archived data through the native application and reporting interface. By reducing the size of the production database, RIM for DB can significantly boost application performance by improving application stability and reducing application environment costs by millions of dollars annually. Archiving with RIM for DB is an indispensable key to managing the application data lifecycle while ensuring regulatory compliance.

RIM for Databases 5.1 comes with the following capabilities:

• Scalability and Very Large Database (VLDB) Support
• Increased module coverage for Oracle e-Business and PeopleSoft

Within the 5.1 release, products within the RIM for Databases portfolio now have new names:

• RIM for DB Live Archive (formerly known as RIM for DB Relocater)
• RIM for DB Open Archive (formerly known as RIM for DB Encapsulated Archive)
• RIM for DB Ready Subset (formerly known as RIM for DB Subcopy)
• RIM for DB Archive Monitor (formerly known as RIM for DB Analyzer)

This solution addresses four primary business problems :

• Poor performance and response time:
  As database size increases, the performance of mission-critical applications deteriorates. The larger the database, the more time it takes to load, unload, search, reorganize, index and optimize. Response time slows. Service levels decline.
• Increasing TCO for maintaining service level agreements
  IT organizations often spend millions of dollars annually on hardware and software license fees just to maintain service levels. Still, this short-term tactical approach does not address the root cause of the problem - excessive data volume.
• Slow Disaster Recovery
  With oversized databases, both active and inactive data must be restored, just to get business data back online. Restoring large volumes of rarely accessed data, in addition to the operational data, can slow the recovery process by hours or even days.

• Complying with Data Retention Regulations
  Data laws require companies to retain data longer and make them available upon request. The cost of retaining large volumes of historical data online in production databases can be prohibitive; yet, the penalties for noncompliance are severe.

RIM for DB provides following values:

• Improves application performance & availability
  
  • Shortens backup and recovery windows
  • Improves application response time
  • Shortens application's migration
• Lower TCO
  
  • Reduces storage requirements and growth
  • Introduces tiered-storage for application management
  • Lowers application and DB management expenses
• Assists with compliance
  
  • Automates data retention policies
  • Provides read-only access to archived data to prevent alteration
  • Facilitates audit/legal requests while maintaining operational efficiency

RIM for DB is a significant enabler of the HP Adaptive Enterprise, delivering greater simplicity, agility, and value across your organization. By archiving less critical information, RIM for Databases provides following benefits:

• Simplicity: Improves database performance through overall infrastructure management
  
  • Significantly improves application performance
  • Reduces backup time and recovery windows
  • Reduces the impact of downtime due to application migration & upgrade
• Agility: Lowers TCO of managing database applications
  
  • Uses ILM & tier-storage approach for efficiently managing database applications
  • Significantly reduces excessive infrastructure upgrades to maintain sustainable service levels
  • Efficient utilization of existing infrastructures to reduce incremental hardware and storage expenditure
  • Rapid implementations for select packaged applications via pluggable Application Packs
  • Scalability to run on very large databases
• Value: Reduces risks of regulatory compliance failure
  
• Automates data retention policies
• Sustained long-term compliance without excessive infrastructure expenditures
• Dramatically reduces risks & exposure of non-compliance with a better controlled information and access

• RIM for DB Live Archive
• RIM for DB Open Archive
• RIM for DB Ready Subset
• RIM for DB Archive Monitor
• RIM for DB Application Packs for Oracle E-Business Suite
• RIM for DB Application Packs for PeopleSoft Enterprise

The Challenge:
With annual data growth of up to 125 percent, and inactive data reaching 80 percent, application data has become a significant IT cost center. This trend shows no signs of slowing. As application data grows out of control, the cost of IT infrastructure soars, while system performance slows to a crawl.
The conventional response has been to repeatedly increase server and storage capacity and constant tuning. But this approach is only a temporary fix and only defers what's really needed: a permanent solution that addresses the root cause - unmanaged data growth.

RIM for DB, an application and database archiving solution to manage performance, cost, and compliance.
To seize control of the situation, today's smart IT organizations take an Information Lifecycle Management (ILM) approach, dedicating high-end resources to production data while relocating historical transactions to online archives stored on more cost-effective servers and storage classes. Online archiving is an indispensable key to managing the application data lifecycle while ensuring regulatory compliance.
RIM for DB manages accelerating data growth by relocating closed transactions and other infrequently accessed data to an online, easily accessible archive database, significantly reducing the size of the production system and improving application performance. With RIM for DB Live Archive, you can:

• Identify inactive data based on business rules, activity history and retention policies
• Relocate inactive business transactions to an online archive database on less expensive storage
• Retain application transparency providing online, real-time user access to a combined view of production and archived data through native application and reporting interface.

RIM for DB Live Archive boosts application performance, improves application availability and stability, and cuts IT infrastructure costs. Furthermore, it retains transparent, online, real-time access to both the production and archive data.

Major Features
RIM for DB Live Archive offers a complete set of application-aware archiving features:

• Oracle E-Business Suite Archiving: Supports Oracle E-Business Suite (Financials, Human Resources, Manufacturing, and Customer Relationship Management)via Application Packs for the Oracle E-Business Suite
• PeopleSoft Archiving: Supports PeopleSoft Enterprise (Financials, Human Resources, Manufacturing, and Customer Relationship Management) via Application Packs for PeopleSoft Enterprise.
• Using the Designer and Run Time platform, Application Packages can be built to support other applications and environments
• Combined View of Data: Provides real-time, transparent visibility into a combined view of production and archive data.
• 24x7 Availability with Zero Impact on Production System: Executes archive operations without shutting down the application.
• Restores High Performance: Improves application performance by reducing the size of production database including database reorganization and space reclamation.
• Policy-Based: Uses policy- and constraint-based definitions to create and enforce data retention and archiving policies.
• Data Parity: Maintains data parity so archive data has same structure as production data.
• Automatic Patch Detection: Monitors third-party patches and ensures patch synchronization of production and archive databases.
• Database Reorganization: Supports database table reorganization to reclaim allocated space.
• Restatement: Supports General Ledger restatement entries as required by regulations such as GAAP.
• Reload: Moves or restores data back from LiveArchive to the production database, providing an operational safety net and flexibility.
• Multiple Configuration Options: Flexible configuration for transparent data access and archive data storage: Single Instance, Single Instance History Only, Distributed, Physical, History Only.
• Operating Systems: HP-UX 11; AIX; Solaris 8, Windows 2000; Linux Red Hat
• Application Aware: Supports latest vendor patches and vendor upgrades to ensure compatibility between production and archive data.

The Challenge
Applications are temporary, data is permanent. This fact of life has huge bottom-line consequences for the enterprise. Regulatory compliance requires companies to retain transactional data for up to thirty years or more. Until now, retiring legacy applications has meant maintaining millions of records on expensive production servers or difficult-to-access offline archives. As a result, any IT departments actually forestall legacy application retirement and continue to maintain multiple copies of transactional data in the production environment long after active usage.

Regulatory Compliance through Sustainable, Long-Term Access to Historical Records

Open Archive addresses the final stage of the information lifecycle. With RIM for DB Open Archive, HP addresses a major issue for corporate governance, as mounting pressure to comply with regulatory requirements forces companies to re-evaluate their data retention policies. Today, more than 10,000 federal and state regulations mandate how companies must protect, store, and access current and historical transaction records. To comply with regulations like FASB, HIPAA and Sarbanes-Oxley, companies must actively manage application data as never before.

RIM for DB Open Archive is the only open standards-based XML archive to store aged data as complete business transactions that remain independently addressable across generations of applications, platforms and storage mediums. The data is "encapsulated" with all necessary reference metadata, so that business transactions within the archive can be accessed by any XML query, even after the source application has been retired.

Users can move historical records from historical databases to RIM for DB Open Archive, where data is stored in XML format along with XML Schema Definitions (XDS) that provide complete information on every transaction. Alternatively, users can move data directly from production environments to Open Archive. As a result, the archived transaction record is completely independent of application, platform, database, or operating system.

With RIM for Open Archive, you can:

• Identify inactive legacy data based on activity history and data retention policies
• Archive inactive business transactions to disk- or file-based storage in a self-contained, self-describing, and survivable XML-based format
• Retain online access to the data via standard XML query tools.

Major Features

By completing the information lifecycle for application and database content, RIM for DB HP Open Archive delivers:

• Survivability: Archives historical data in survivable format that remains usable even beyond the lifetime of the production system.
• Sustainability: Remains independent of source application, file system, operating system, and platform.
• Real-time, Standards Based Access: Provides archive access via xQuery, the open, XML standard query language supported by thousands of third-party vendors. Relational technologies can also access this data container.
• Storage Independent: Enables the use of low-cost storage classes, including CAS, ATA.
• Compliance Reporting: Supports audits for compliance, reference, and litigation.
• Integration: Uses policy-based archive process and data retention policies as defined in RIM for DB Archive Monitor
• Audit Trail: Copies transaction and reference data from OLTP and logs transaction state
• Oracle custom application support

Challenges:
Application deployments, customizations, upgrades and enhancements all require copies of the production database for testing, development, QA, staging and training. When you create multiple copies of your entire production database, the toll on your IT infrastructure and time-to-delivery can be significant. Yet application managers need true relational data to effectively develop and test the new functionality required to meet new business challenges

HP Ready Subset to gain control of test and development data:
RIM for DB Ready Subset automatically generates database Ready Subsets to provide complete control of the size and composition of the development database instances. With HP Ready Subset, you can:

• Clone production databases
• Select and set policy by time, organization, accounting unit or storage capacity
• Identify data to Ready Subset
• Remove unwanted data
• Reorganize data and reclaim space

Major Features
To help curb application data growth while expediting application software projects, RIM for DB Ready Subset offers a broad array of Ready Subsetting features:

• Relationally Intact Ready Subsets: Generates Ready Subsets that retain data integrity and relationships for consistent business processes.
• Automated Definition: Automated instance definition and generation to speed IT development efforts.
• Re-use: Supports re-use of stored definitions, polices, and rules.
• Storage Savings: Reorganizes test and development databases and reclaims storage space for more effective use of development resources.
• Enterprise Application Support: (Oracle E-Business Suite)

The Challenge
With annual data growth of up to 125 percent, and inactive data reaching 80 percent, most organizations today lack the ability to accurately track and analyze data growth. The result: poor system performance, high storage costs and increasing compliance issues to meet data retention requirements.

Intelligent Insight to Application Data Growth
A key component of the RIM for DB suite, Archive Monitor is an enterprise dashboard that intelligently monitors systems, forecasts and models data growth to provide real-time application performance monitoring and helps create and enforce effective data retention policies. It lets you:

• Monitor current data allocation and growth activity
• Forecast data growth across applications, databases, business processes and storage classes
• Model and preview the impact of data retention policy without affecting production data
• Diagnose and resolve data management issues before they impact operations.

Improved retention policies enable the enterprise to maintain optimum system performance, better utilize storage resources, and proactively manage storage costs while fulfilling service level agreements.

• Enterprise Data Distribution Report: Shows how data is distributed by business applications, users, departments and storage devices, across an organization or its departments.
• Application Data Growth Report: Drills down into a business application on a specific instance to show data growth over time. The report also shows the growth of active and inactive data over time.
• Storage Utilization by Module Report: Shows the distribution of storage/server space by application module. This report helps to identify which modules are consuming the most space.
• Data Growth Forecast: Supports forecasting with full modeling capability for events like application upgrades, data imports, archiving etc.
• Top 100 Tables Report: Shows the top 100 largest tables in the business application.

Major Features
RIM for DB Archive Monitor provides total visibility and control of application data growth across the enterprise:

• Dashboard: Provides a view of all database instances in your enterprise environment. Monitors and analyzes application performance in both graphical and tabular form. Supports aggregation, drill-downs and alerts.
• Time-based Policy Preview: Provides ability to preview the impact of retention policies. Allows "what if" analysis by graphically displaying projected data volumes for any given time-based archiving policy.
• Retention Policy Control: Sets and enforces data retention policies for more cost-effective management of application data.
• Packaged Application Mapping: Provides out-of-the-box support for Oracle and PeopleSoft application modules.
• Custom Application Mapping: Provides an open interface to allow mapping of packaged application customizations as well as custom applications.
• Customizable Alert Thresholds: Set alert thresholds to flag applications that are growing rapidly. There are also alerts for applications that have a large amount of inactive data.

RIM for DB Application Packs for Oracle E-Business Suite provides ready to use Live Archive & Ready Subset modules for all major transaction areas within Oracle E-Business Suite.
Additional features include:

• Seamless access to your data using standard Oracle E-Business Forms and Reports
• Patch and upgrade support as Oracle introduces new versions of Oracle E-Business Suite
• Leverages standard Oracle purges to provide most secure data integrity possible without sacrificing performance
• Eligibility Analytics for complex modules such Accounts Receivable and Payables/Purchasing, providing deep insight into the purge constraints and each customers specific data conditions
• Flexible Purge modules allows for customer-controlled relaxing of specific purge constraints
• GUI Designer & Open API for enhancing existing modules and creating new custom modules

RIM for DB Application Packs for PeopleSoft Enterprise provide ready to use Live Archive modules for all major transaction areas within Oracle E-Business Suite. Additional features include:

• Seamless access to your data using standard PeopleSoft Enterprise Screens and Processes
• Patch and upgrade support as Oracle introduces new versions of PeopleSoft Enterprise
• Integrated with PeopleSoft process schedule to allow scheduling of archive processes from standard PeopleSoft interface

HP Ref Info Mgr DB Live Archive Nolimit LTU

• HP-UX
  
• LINUX
  
• SOLARIS
  
• AIX

NOTE: Databases on unsupported platforms can be supported by installing the software on a supported platform, and then pointing to the database remotely

• Oracle Database

• Applications running against supported Oracle databases
• For HP provided Applications Packs
  • Oracle
  • PSFT

• See above for the OS, databases and ERP versions

For information about HP RIM for Databases:
http://www.hp.com/go/rim4db

For information about HP Information Lifecycle Management (ILM)
http://www.hp.com/go/ilm
http://www.hp.com/products1/storage/index.html

For questions and personalized help about HP RIM for Databases:
http://h71028.www7.hp.com/enterprise/cache/418248-0-0-0-121.html

HP Care Pack Services offer upgraded service levels to extend and expand your standard product warranty with easy to buy, easy to use support packages that help you make the most of your hardware and software investments. They let you choose the support levels that meet your business requirements, from basic to mission-critical. They help you contain total cost of ownership.

HP Care Pack warranty extensions can be purchased along with HP products to cost-effectively upgrade or extend your warranty. For many products, post-warranty HP Care Pack Services are available when your original warranty has expired.

Why purchase an HP Care Pack service?
Your standard warranty protects against product defects. HP Care Pack Services help you guard against unplanned downtime, which can reduce your productivity and profitability. These convenient service packages:

• Protect your investment in HP products
• Provide consistent, predictable levels of support across your entire department or business
• Ease budget planning with fixed-cost support that includes parts and labor
• Give you direct access to proven technical and problem-solving expertise
• Offer a choice of response-time and repair-time commitments
• Deliver prompt, measurable results
• Are available whenever and wherever you do business

HP Care Pack availability may vary by country and product.

Supporting your Adaptive Enterprise journey
HP Services helps you make the Adaptive Enterprise real for your organization. The breadth, depth, and quality of HP hardware and software support services can help you improve the performance of your IT support processes and resolve the complex software and hardware problems that tax user productivity. HP Care Pack services help you increase IT environment stability, efficiency, and agility from the desktop to the data center, and improve the productivity of your employees.

• Enjoy top performance right from the start
• Shorten your time-to-ROI

• Improve the productivity of system managers and operators
• Improve system performance and reduce downtime due to software defects
• Expedite problem resolution through expert-level technical resources
• Enjoy consistent service coverage across geographically dispersed sites
• Update HP and selected third-party software at a predictable cost
• Take advantage of subscription savings on software updates
• Keep your license compliancy up-to-date

The HP Installation and Startup Service ensures a smooth implementation of HP Software Information Management: Reference Information Manager (RIM) for Databases software into your IT infrastructure. The service provides a documented implementation designed to help meet the needs of your business providing:

• Greater ability for your IT resources to stay focused on their core tasks and priorities
• Reduced implementation time and impact to your storage environment

Support Portal
The HP support portal provides one-stop access to the information, tools and services you need to manage the daily operations of your IT environment.

Features include:

• Access to self-solve tools (including search technical knowledge base)
• Efficient logging and tracking of support cases
• Collaboration with other business and IT professionals
• Download of patches and drivers
• Access to diagnostic tools
• Proactive notification of relevant information

Access to certain features of the support portal requires an HP service agreement. To access the support portal, visit http://www.outerbay.com/support/index.html

For more information about Deployment, Per Event, Consulting and Education services for HP Storage, visit:
http://h20219.www2.hp.com/services/cache/125954-0-0-225-21.html?jumpid=reg_R1002_USEN

If you have specific questions, contact your local HP representative. Contact information for a representative in your area can be found at "Contact HP"
http://www.hp.com.

© Copyright 2007 Hewlett-Packard Development Company, L.P.
The information contained herein is subject to change without notice.

Microsoft and Windows NT are US registered trademarks of Microsoft Corporation.

The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors or omissions contained herein.