BNP Paribas Runs Global Trading Environment 17-Times Faster with Oracle Exadata
 
 

BNP Paribas Runs Global Trading Environment 17-Times Faster with Oracle Exadata

  • Oracle Customer:  BNP Paribas
    Location:  Paris, France
    Industry:  Financial Services
    Employees:  200,000
    Annual Revenue:  Over $5 Billion

Printer View Printer View


BNP Paribas, born in 2000 out of the merger of Banque Nationale de Paris (BNP) and Paribas, is one of the largest financial institutions in the world, the largest bank in the Eurozone in terms of deposits, and the 7th largest bank globally, according to the 2010 Forbes 2000. Operating across Europe, the group has domestic retail banking markets in France, Italy, Belgium, and Luxembourg. It also has one of the largest international networks, with operations in 83 countries.

 
 

 
 

Challenges

A word from BNP Paribas

  • “I can get tables that were already compressed down to 1 terabyte in Oracle Database 10g down to 185 gigabytes using the hybrid columnar compression in Oracle Exadata Database Machine. That brings massive benefits in terms of manageability.” – Jim Duffy, Senior Data Warehouse Architect, BNP Paribas

  • Provide transparency within the global trading environment and improve compliance reporting and application performance
  • Cope with exponentially growing data in the data warehouse,  between 150 gigabytes a day, to more than 450 gigabytes daily
  • Manage more than 4 billion financial transactions per day in real time with efficiency
  • Standardize all information flows within the global trading environment onto one platform to create a level of agility not previously achieved in a reporting and statistics platform

Solutions

Oracle Product and Services

  • Deployed Oracle Exadata Database Machine to reduce the size of the global trading data warehouse from 40 terabytes to less than 8 terabytes with hybrid columnar compression
  • Accelerated data loading six-fold and achieved much faster query execution time—completing queries in less than one second, down from an average of 30 seconds to one minute per query
  • Achieved report throughput that is 17 times faster than on the legacy system
  • Reduced tuning and maintenance burden and costs with Oracle Exadata’s automated tuning capabilities
  • Allowed the database administration team to reallocate development resources to work on writing code, as opposed to simply managing the database

Resources