Seamless purge operations to reduce cost and increase performance

  • Data Purge for application database having large volume of history data to regain space and performance
  • Increase performance up to 70% and make head-room for new business / work load
  • Regain space up to 50% and eliminate on storage investments for future growth.
  • Data Archive to retire-decommission legacy applications to cut cost on infrastructure, licenses, maintenance and data center costs.
  • Keep data in low cost disk storage with high compression for reference
  • Store data in open source database for reporting and regulatory compliance purpose

Technology and Applications

  • COTS
    Oracle ERP
  • Native DB Scripts for home-grown applications
  • HP App IO (formerly HP DB Archive)
  • Oracle GoldenGate

Case Studies

Mphasis DE team architected the solution and executed a seamless purge of business data from 5 TB Siebel database which is highly business critical for one of a Telecom leader in APAC. The migration was done with zero impact to production database. At the end of purge the database was brought down to 1.5 TB with 10TB storage reclamation.
Mphasis DE team designed and executed data archival project for a large Telecom company in APAC. It involved archiving 1TB data from Mainframe DB2 database to Oracle Database. The task was accomplished by using native database load / unload utilities.

The Mphasis Advantage

  • Seamless purge operations on production database with very no/minimal impact to business.
  • Expertise in native purge API for COTS application like Siebel, PeopleSoft, Oracle ERP etc and proven purge methods for Siebel, PeopleSoft and Oracle ERP using HP DBA COTS plug-ins.
  • HP DBA tool or custom scripts for on-going purge and archival