Our SPARC and OLAP development teams have published some fantastic performance figures on their blog: https://blogs.oracle.com/BestPerf/entry/20130326_sparc_t5_8_olap
Using Oracle's SPARC T5-8 server the teams delivered world record query performance with near real-time analytic capability using the Oracle OLAP Perf Version 3 workload running Oracle Database 11g Release 2 on Oracle Solaris 11. The workload uses a set of realistic BI queries that run against an OLAP cube based on a 4 billion row fact table of sales data. The 4 billion rows are partitioned by month spanning 10 years. The combination of the Oracle Database with the Oracle OLAP option running on a SPARC T5-8 server supports live data updates occurring concurrently with minimally impacted user query executions.
This is a great evolution of the development work we have been doing with our in-database OLAP features. The details about "real-time" analytics reminded me of the work with did with BNP Paribas to develop a daily time-series data and analysis solution based around the in-database OLAP features. This customer story was covered in the press and in the January 2007 and April 2008 editions of the OLAP Newsletter:
The BNP Paribas solution stores over 3 billion data values within multiple OLAP cubes across several geographical locations. The solution was based on Oracle 10g utilising Oracle OLAP Option and data access tools for Traders and Quant Analysts. Most of the OLAP calculations, written in DML, have a query time ranging from sub-second to just a few seconds - even for the most complex analytics. The business users access their OLAP cubes through a custom web services front end as well as customised spreadsheet applications. The system supports the retrieval of market data, as well as stored formula, customised functions and complex user generated formula. At the time of the article, BNP Paribas was processing over 10 million rows of data are loaded and continuously aggregating cubes throughout the day. Overall the system was processing over 20 million data requests per day from over 4000 users.
Cyrus Kapadia, manager of the implementation team at BNP Paribas states, ‘The advantages of Oracle 10g’s scalability, reliability, ease of maintenance, performance and an industry standard analytical query language made it the natural choice to replace our existing system’.
This latest benchmark result from our development team show how we are continuing to develop our OLAP features to deliver groundbreaking performance to support complex data warehouse workloads. In my recent article about in-database analytics I pointed out the importance of having high performance in-database analytics. Therefore, this benchmark is important for OLAP queries but it is also very important in a wider analytical context because it will increase the performance of analytical mashups where OLAP data is mixed and mashed with other key analytical features such as spatial analytics, data mining, time series analytics and/or statistical analytics. I am hoping to publish a whitepaper on this topic in the next few weeks.
Visit the OLAP Option home page on OTN for more information about Oracle OLAP Option, including how-to videos, presentations, webcasts etc: http://www.oracle.com/technetwork/database/options/olap/index.html