IBM Optim Data Growth Solution – Control Data Growth

Estuate implements IBM Optim's Data Growth Solution for our clients to control their unmanaged data growth at the source, by proactively managing their enterprise application data. Unmanaged data growth can negatively impact application performance and strain financial and technical resources, jeopardizing the completion of business-critical processes on schedule.

IBM Optim Data Growth Solution mitigates the adverse impact of rapid data growth by archiving historical data safely to a secure archive. The archive can be maintained as a database or compressed file, and can be stored on any hardware device. We apply our clients' functional requirements, data retention policies, application logic, and validation rules to IBM Optim's Data Growth Solution to control our clients unmanaged data growth at the source, while ensuring that application integrity is maintained.

IBM Optim provides predefined built-in templates that define the most common business objects within leading ERP and CRM application products, including Oracle JDE EnterpriseOne, Oracle E-Business Suite, Oracle PeopleSoft, SAP, and Siebel. These templates can be customized or used to develop new templates for specific business requirements. Criteria are commonly based on functional requirements or data retention regulations. IBM Optim identifies all transactions that meet the criteria and moves them into the archive. Archiving can be automated to execute at specific times by using any third-party job scheduler or through IBM Optim itself.

single image

Once the data is archived, only the most current data is maintained in the production environment, which helps to maintain high application performance. The archived data can be maintained in mid-tier storage at lower cost while still meeting service targets. The archived data (historical or reference data) can also be stored in secure WORM, tape or other storage devices. This Optim-based archived data can be directly accessed by using any SQL-based reporting tool, such as Crystal Reports, JasperReports or Oracle Discoverer.

Estuate recently implemented Optim Data Growth Solution for a client using Oracle E-Business Suite (EBS). The client was having serious problems with high storage costs and system performance for users. Our approach to control data growth and improve system performance was to archive infrequently-used, inactive, transactional data. We implemented Optim Data Growth Solution on IBM's AIX platform and archived three years of Oracle EBS transactional data. We configured Optim for native application access, enabling our client to access archived data virtually through standard Oracle EBS screens. As a result, our client gained 40% improvement in throughput and met their performance objectives.

single image
single image

Recorded Webinars

  • Unlock the potential of APEX and get answers to questions such as: "What can APEX do for me or my organization? What features are available "out-of-the-box,"? How can I Read more

  • Estuate, an Oracle Gold Partner, has teamed with Lavante, a leader in supplier management software, to bring you an educational webinar on vendor file management and cleansing Read more

  • Most Oracle Applications (Oracle EBS, Siebel, PeopleSoft, JDE and custom applications) customers have accumulated many years of data in their production databases, Read more

  View More
single image

Customer Success Stories

  View More