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

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

Capgemini UK plc is part of the Capgemini Group, one of the world’s foremost providers of consulting, technology, and outsourcing services. Capgemini served as the primary systems integrator for a large IT initiative required by a major transportation-sector client. The client needed to preserve, compress, and migrate several large data sets from five legacy datawarehouses that were experiencing serious business-critical issues, including inconsistent patch updates, a lack of capacity, an aging reduced-instruction-set-computing -based architecture , limited computing capacity, and a lack of disaster recovery planning. The stored data varied in type and volume and included billions of lines of code, millions of data points, numerous lines of business, complex character-based files, and a variety of root access paths. The client wanted to migrate all of this data to an engineered systems solution capable of delivering extreme performance for mixed workloads, combined with unparalleled scalability.

Due to the legacy nature of the datawarehouses, there was no simple “lift-and-shift” migration option available to the end client. The project required a specialized approach, demanding specific technical expertise. Capgemini conducted a detailed review of market options and evaluated five possible database technologies with export and import capabilities.

The group selected Oracle Advanced Customer Support Services and its Oracle-to-Oracle (O2O) database migration toolset, gaining broad expertise, risk mitigation, and a proven track history. Oracle Advanced Customer Support Services operates across the entire Oracle stack—applications, middleware, database, servers, and storage systems. Capgemini also had access to Oracle’s specialized database migration consultants working in Germany and Romania.

By collaborating with Oracle Advanced Customer Support Services, Capgemini helped its client preserve the structure of five large data warehouses through migration to the Oracle Exadata Database Machine. It achieved dynamic compression ratios approaching 50%, reducing one dataset from 5 TB to 2.6 TB. It also improved overall database performance by an average 30%. For example, one dataset that took 48 hours to execute in the legacy environment takes just eight hours today.

A word from Capgemini UK plc

  • "For Capgemini, the collaborative project with Oracle Advanced Customer Support Services was a win-win situation. By working with Oracle Advanced Customer Support Services, we had access to the best possible database migration toolset available as well as engineering expertise to overcome any potential technical issues across numerous Oracle Database revisions.” – Darren Scott, Managing Consultant, Application Services UK, Capgemini

 
 

 
 

Why Oracle

Capgemini needed the best team and toolkit available to mitigate risk for its client. After evaluating several data warehouse migration methods, Capgemini selected Oracle Advanced Customer Support Services. It decided that Oracle Advanced Customer Support Services was the best option based on a broad range of criteria, including portability, reusability, robustness, migration speed, reliability, risk-mitigation, configurability, and use of audit reports.

Oracle Advanced Customer Support Services delivered tailored support services to maintain and maximize performance following the migration of the end client’s data. Oracle's engineering teams collaborated with Capgemini to provide a highly integrated approach to meet its client’s requirements. Oracle also provides critical ongoing support for Oracle Exadata. With a dedicated support team, proactive guidance, and preventative services, Oracle Advanced Customer Support Services maximizes availability, reduces risk, and optimizes performance for all Oracle engineered systems, including Oracle Exadata.

Implementation Process

Capgemini worked with Oracle Advanced Customer Support Services to conduct a proof of concept that successfully tested the migration process and verified migrated data to confirm its integrity. Oracle experts then delivered 15 successful O2O migrations, complete with assessments, planning, rollout, testing, and hand-over. Oracle Advanced Customer Support Services helped the firm move more than 6 TB of data in a single weekend with 100% success and reliability.

Capgemini completed the project in approximately 18 months, from initial assessment by Capgemini in conjunction with Oracle Advanced Customer Support Services, to the fifth and final data warehouse going live on its new Oracle Exadata platform.