Viral marketing is often the best endorsement a vendor can hope for. It is certainly what Oracle has found in the response of BNP Paribas to their adoption of Oracle Exadata V2, as reported in InformationWeek by Doug Henschen.
The enthusiasm at BNP Paribas stems from having been able to replace a four-node RAC cluster running Oracle 10g with a half-rack deployment of Exadata V2. The new system, like the retired legacy system, provides the underpinning of some 35 trading-floor applications, including near-real-time performance stat monitoring, risk- and market-abuse compliance reporting, network and internal application optimization, and long-term (five-year) archival compliance querying and reporting, Henschen writes, adding that a second Exadata V2 half rack is dedicated to disaster recovery.
The five TB worth of Smart Flash Cache in BNP Paribas' Exadata V2 implementation supports the high end of the company's high/medium/low-speed data-access scheme, enabling the storage of the preceding week's trading data in flash cache. Further, Henschen continues, there is also room in the cache for anything directly accessed by an internal-facing Website used for monitoring and querying (particularly derived data).
BNP Paribas data warehouse architect Jim Duffy told the writer that cache is used as well for staging tables that are accessed directly to deliver internal application performance statistics. According to Duffy the monitoring/querying Web site is serving up answers five times faster than it did with the RAC/10g deployment.
The hybrid columnar compression feature of Exadata V2 enables BNP Paribas to store only 10 TB rather than 23, as was the case in the previous setup, Henschen writes. "I can get tables that were already compressed down to 1 terabyte in Oracle 10g down to 185 gigabytes using the hybrid columnar compression in Exadata. That brings massive benefits in terms of manageability," Duffy said.
Duffy is equally satisfied with the reduction in admin and management tasks that Exadata V2 delivers. What used to take hours can now be accomplished in minutes, he told Henschen. Duffy added the observation that existing queries run, on average, about 16 to 17 times faster on Exadata V2 than in the old RAC deployment. He expects to achieve even further performance improvements through code changes to exploit Exadata V2's ability to push SQL querying down into the storage tier, Henschen writes.
What's New in Oracle Exadata V2?
Oracle Exadata: A Data Management Tipping Point
Flash Storage in Exadata V2 Cuts Query Processing Time Significantly
Unconventional Resources on Oracle Exadata Version 2
Read More ...