File Library

How to Use Times-Ten as the Cornerstone for Successful BI Implementations on Exalytics
Topic: Business Intelligence
Owner: Holger Friedrich
Date: 2013-06-26
Subtopic: Best Practices

Exalystics, being Oracle's engineered system for BI, draws lots of attention these days. But what is the big advantage of using Exalytics over a regular Lintel box that you'd set up with lots of processing cores and a Terabyte of RAM? What gives the whole package the extra performance boost? It is not the BI server installation, which is basically the same as the one you'd install on other platforms. No, the ingredient that really makes the difference is the Oracle TimesTen In-Memory Database for Exalytics. Times Ten on Exalytics is a new release that includes advanced features like columnar data compression, SQL-analytics functions and more. Those together with the fact that all data is stored in DRAM, are responsible for the superior performance of an Exalystics based BI system.

However, although technical features and example applications have been presented all around since the first release of the Exalytics server, little attention has been given as to when and how the TimesTen database should be used in conjunction with the BI server as data recipient and source systems as data providers. Of course, the summary advisor of the BI server ist mentioned everywhere, but is using the advisor all that you need to know, in order to develop and run a BI solution successfully and maintainable in the long term?

This presentation discusses all the relevant aspects regarding the application of TimeTen as cornerstone for successful BI implementations on Exalytics. Various different areas are covered. These include
- when to use TimesTen at at all and when to read directly from source systems instead
- deciding what to cache in TimesTen and what not, here the summary advisor comes into play
- when to compute aggregates in TimesTen, in contrast to pre-computing them in source systems and only caching them in TimesTen afterwards
- discussion, comparison and assessment of different ETL and interfacing strategies, including hand-written code, summary advisor scripts, the use of ODI, Golden Gate, and TimesTen cache groups

Attendees of this presentation will get an in-depth analysis of how-to employ TimesTen on Exalytics in different BI application scenarios in the most beneficial way. The information presented will empower attendees to develop high-performance solutions themselves, that are also efficiently maintainable and utilize the different system components, i.e. BI server, Times Ten, and source systems, in the most efficient way possible.

Download File   hfriedrich.howtouse.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database