Exalytics - One Size Fits All?

Exalytics - One Size Fits All?

The Exalytics appliance was launched amidst much fanfare and hyperbole, and with their purchase of their own Exalytics machine, Rittman Mead have been able to put the theory to the test. This presentation will assess whether Exalytics out of the box is a true panacea for all OBIEE deployments in all situations, or if there are use-cases in which alternative configurations or technologies may be more appropriate. Performance testing methods will be discussed, and in-depth examples from our Exalytics box examined.

2bded62396ea66c84bd10e91c718dea9?s=128

Robin Moffatt

December 10, 2012
Tweet

Transcript

  1. 1.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics - One Size Fits All? Robin Moffatt, Principal Consultant, Rittman Mead UKOUG 2012
  2. 2.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics - One Size Fits All? •This Presentation: ‣ What IS Exalytics? - Lifting the fog of FUD and marketing ‣ Just an Appliance? - Different ways that Exalytics can fit into a BI architecture ‣ Which way is best?
 •Not This Presentation ‣ This is not … an Exalytics sales pitch ‣ This is not … a £ for £ evaluation of deployment options ‣ This is not … is Exalytics “better” than 
 SAP HANA / QlikView / ZX81 ‣ This is not … the official Oracle line ‣ This is not … necessarily supported, endorsed, approved 
 or tolerated by Oracle
  3. 3.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Vanilla Exalytics As God^H^H^H Larry intended it
  4. 4.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics basic architecture OBIEE Exalytics Oracle / DB2 / SQL Server / etc Base data Existing DW Base data can be loaded into pre- aggregated tables and/or cubes Seamless to the user, OBIEE queries data from the most optimal source TimesTen Aggregated data Essbase OLAP cube BI Server can cache all resultsets BI Server cache Users have a single view of the data with OBIEE, regardless of from where the data came TimesTen in-memory database
  5. 5.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com The OBIEE “Common Enterprise Information Model” •OBIEE abstracts the interface between physical data and the business view of it •Many different data sources are supported, and OBIEE can join data across them •Any datasource that can be used with OBIEE can therefore be used as a source for Exalytics ‣ i.e. Exalytics is not just for using with an Oracle datawarehouse BI Server Common Enterprise Information Model (“RPD”)
  6. 6.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com BI Server Enterprise Information Model (“RPD”) Using TimesTen with OBIEE •In the context of OBIEE, TimesTen is “just” another data source for user queries •OBIEE also uses the RPD metadata to load TimesTen with aggregates
  7. 7.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com How is Exalytics different? OBIEE Exalytics TimesTen Essbase BI Server cache RCU schema Usage Tracking Summary Statistics Summary Advisor Aggregate Persistence Aggregates are generated based on actual query workload Essbase and OBIEE are optimised for Exalytics hardware Hardware: 1TB of DRAM for holding data in-memory 40 CPU cores to support complex reports with large user volumes TimesTen is a special release for Exalytics with support for Analytic functions and compression, not found in standard TimesTen Infiniband for connecting to Exadata
  8. 8.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com The Summary Advisor tool •This is the “Adaptive” and “Self-tuning” element of Exalytics that the marketing material refers to 
 •Part of OBIEE, but Exalytics-only
 •Analyses query workload to suggest most useful aggregates for TimesTen
 •Manual, wizard-based interface generates a script
  9. 9.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com What the Summary Advisor script does •Uses OBIEE’s Aggregate Persistence functionality •Creates and populates the aggregate data on TimesTen •Adds aggregate information into the RPD Base data Exalytics TimesTen RPD Aggregate tables built RPD updated with new aggregate mappings Common Enterprise Information Model (“RPD”) OBIEE Aggregate Persistence Aggregate tables loaded from base data using mappings in RPD
  10. 10.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Different ways to configure & deploy Exalytics
  11. 11.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Alternative Exalytics configurations •For a fully optimised Exalytics deployment, alternative configurations may be useful ‣ How data is loaded ‣ What data is loaded
  12. 12.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com How data is loaded into Exalytics •Think of Exalytics in context of a datawarehouse ETL batch ‣ Batch load time considerations ‣ Maintainability considerations •Several reasons to consider alternatives to Summary Advisor ‣ No incremental refreshes ‣ It is not bullet-proof...
  13. 13.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Custom refresh - Oracle to TimesTen •Extract the generated aggregation SQL •Use a TimesTen routine to run the SQL directly •Avoids touching the online RPD nqquery.log Aggregate Persistence TimesTen Aggregated data ttLoadFromOracle Run once to generate the SQL (and update the RPD) Subsequent data loads done using extracted NB: Not currently supported on Exalytics v1.0.0.1 Aggregate build SQL statement
  14. 14.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com •Minimal changes required to source system •Bespoke ODI code to apply the changed data to aggregate tables Aggregates TimesTen CDC staging data Oracle Base data (any supported DB) GoldenGate ODI ODI age GoldenGate GoldenGat TimesTen Incremental refresh of aggregates using GoldenGate and ODI
  15. 15.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com What data can be loaded into Exalytics? •Base, unaggregated data •Put “hot” transactional data in-memory ‣ NB no out-of-the-box tool to load it BI Server Exalytics TimesTen Aggregated data Base data Oracle / DB2 / SQL Server / etc Base data DATE = TODAY DATE < TODAY
  16. 16.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com What data can be loaded into Exalytics? •BI Server supports modelling against a vast array of sources •Build aggregates directly from source in TimesTen for performance •Uses native Summary Advisor / Aggregate Persistence BI Server Exalytics TimesTen Aggregated data Base data Source OLTP system A Transactional data Source OLTP system B Transactional data Source OLTP system C Transactional data
  17. 17.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics - One Size Fits All? Summary
  18. 18.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics as an Exa-machine One of the reasons why is Exalytics so frequently misunderstood
  19. 19.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics as an Exa-machine •Exadata - database appliance. •All your storage + db servers in one place, faster + cheaper Database servers Storage Exadata
  20. 20.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics as an Exa-machine •Exalogic - application server appliance. •All your app servers in one place, faster and cheaper Application servers Exalogic
  21. 21.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics as an Exa-machine •Exalytics - “in-memory BI appliance”. Faster + Cheaper. Datawarehouse OBIEE Exalytics
  22. 22.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics as an Exa-machine •Exalytics - “in-memory BI appliance”. Faster + Cheaper. Datawarehouse OBIEE Base Exalytics Aggregate
  23. 23.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics as an Exa-machine •Exalytics - “in-memory BI appliance”. Faster + Cheaper. Datawarehouse OBIEE Base Aggregate Exalytics Aggregate Base
  24. 24.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics as an Exa-machine •Exalytics - “in-memory BI appliance”. Faster + Cheaper. Datawarehouse OBIEE Base Aggregate Exalytics Aggregate Base OLAP
  25. 25.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics as an Exa-machine •Exalytics - “in-memory BI appliance”. Faster + Cheaper. Datawarehouse OBIEE Base Aggregate Exalytics Aggregate Base OLAP Unstructured
  26. 26.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics as an Exa-machine •Exalytics - “in-memory BI appliance”. Faster + Cheaper. Datawarehouse OBIEE Base Aggregate Exalytics Aggregate Base OLAP Unstructured
  27. 27.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com Exalytics - One Size Fits All? •Exalytics as an appliance might be just the first step •How you best use Exalytics depends entirely upon YOUR requirements ‣ “Speed of thought” analytics ‣ Support large user base ‣ Consolidate/host multiple disparate deployments ‣ Greenfield (adopting strategic Oracle direction) ‣ Rapid sandboxing from OLTP •Exalytics should normally be considered in the context of an overall BI architecture & strategy •Maximise the potential of your Exalytics plans by speaking to RittmanMead, the Exalytics experts!
  28. 28.

    T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com

    W: www.rittmanmead.com #EOF @RMoff ... robin.moffatt@rittmanmead.com ... www.rittmanmead.com