OOW2011 : Oracle Exalytics Intelligence Machine

October 3rd, 2011 by

So the big announcement for Oracle BI customers at Larry Ellison’s keynote on Sunday evening at Oracle Openworld was the Oracle Exalytics Intelligence Machine, a new hardware and software combination from Oracle that aims to provide “speed-of-thought” analysis based around OBIEE 11g and the TimesTen parallel in-memory database.

Based on what was announced today, Exalytics is part of the same family as Exadata and Exalogic, in that it is a combination of hardware, software and engineering that you can’t get by just installing off-the-shelf products. The key components in Exalytics are:

  • A four socket, 48 40-core server with 1TB of DRAM and locally-attached disks
  • OBIEE 11g (based on a future release)
  • The TimesTen parallel in-memory database, with a 200GB/sec scan rate
  • An in-memory parallel version of the Essbase OLAP Server
  • An updated user interface for “speed of thought” analytics
  • Fast infiniband connection to Exadata

Here’s a picture of one just outside the keynote hall:

Exalytics is designed to solve the problem of aggregating and analyzing large volumes of data, and would be used alongside source databases such as Oracle Database, Teradata, Microsoft SQL Server or stand-alone Essbase databases. Typically, customers would use it in conjunction with Exadata, so that Exadata does the heavy-lifting around filtering and searching large amounts of data, and Exalytics, through the in-built TimesTen database and Essbase server, does the aggregation. The diagram below shows the products working together.

There’s a lot more I could say, but at this point let’s wait and see what information Oracle put into the public domain. Suffice to say, it’s a very interesting development that will apply to both Oracle and non-Oracle customers, and will work alongside technologies such as Exadata, Essbase and Oracle OLAP. Watch this space over the coming months, and also look out for the Oracle Press book I’m working on which will include a whole section on Exalytics and TimesTen.

Comments

  1. Gary Says:

    Great write up. Nice of you to keep it simple. I wonder why you do not mention MySQL in your list of db’s this could sit next to?

    Thanks

    Gary Jay Brooks

  2. Salih Oztop Says:

    Hi Mark,
    There is a typo in number of cores. It is 4 CPU X 10-Core, Total of 40 Cores machine.

    Oracle Exalytics BI Machine http://bit.ly/pBRjsT

  3. René Kuipers Says:

    Wow ! You’re fast ! Is your personal internal processor also running on Exalytics ?

  4. Marco Says:

    Hi Mark, definitely a lot of processing power.

    Any idea’s what business processes this is designed to support?

  5. Paul Says:

    Now I know what I want for Christmas!

  6. Mark Rittman Says:

    Probably because I rarely see it as a data source for OBIEE. Given the price (and usual applications) for mySQL, I most usually see it used in conjunction with JQuery and Pentaho, rather than $$$$ systems such as OBIEE.

  7. Amir Riaz Says:

    Dear Mark Rittman.

    Sir you said.
    “Exalytics is designed to solve the problem of aggregating and analyzing large volumes of data, and would be used alongside source databases such as Oracle Database, Teradata, Microsoft SQL Server or stand-alone Essbase databases”.

    Exalytics can be used that way, but its a wrong usage of that technology. Technologies like SAP HANA and Exalytic is for real time analytic.

    With real time analytic i mean, it work on operational ERP data. replicates that data in memory from ERP system in real time. These in-memory systems dont have ETL processes, they have simple ETL processes embedded in reporting systems. so when you run reports, the ETL transformation process transform data in real time, aggregate it and show it user.

    Although, it can host Oracle Dimension and facts and aggregate it but that would be a totally stupid thing to do, why would we aggregate in real time since the data is being loaded through batch and will not change over time.

  8. CheaperNow Says:

    Vertica can snatch the Analytics title if Oracle DW Engineers weren’t whining “Just Wait!”. Doesn’t take many of them to kill off a Vertica proposal out of sheer ignorance.

Website Design & Build: tymedia.co.uk