Case Study: Capgemini achieves 50% data compression and 30% better database performance with Oracle Exadata Database Machine

Capgemini UK Migrates Data Warehouses to Engineered Systems, Achieves 50% Data Compression, Improves Database Performance by 30% for Large Client

Capgemini, the UK systems integrator for a major transportation-sector client, faced the challenge of preserving, compressing, and migrating five large legacy data warehouses with serious issues such as inconsistent patching, limited capacity, aging architecture, and no disaster recovery plan. To meet the client’s need for a high-performance engineered systems platform, Capgemini selected Oracle Exadata and Oracle Advanced Customer Support with Database Migration Services.

Oracle Exadata and Oracle Advanced Customer Support helped Capgemini successfully migrate the data warehouses to the Oracle Exadata Database Machine, using proof of concept testing, planning, rollout, and validation to reduce risk. The result was dynamic compression of nearly 50%, cutting one dataset from 5 TB to 2.6 TB, and average database performance improvements of 30%, with one job dropping from 48 hours to 8 hours; Capgemini also moved more than 6 TB in a single weekend with 100% success.

Capgemini

Darren Scott

Managing Consultant, Application Services UK