Oracle Releases TimesTen To Compete Against SAP Hana

Oracle recently introduced TimesTen In-Memory database 11d release 2. Also, it is anticipated that Exalytics In-Memory machine will likely be published soon. The cost for the product is shown on Oracle's website. As outlined by Oracle, the TimesTen upgrade gives you overall performance benefits, and scalability that will permit it to support a greater quantity of users at a given time, process a greater quantity of requests and take care of far more sessions. As it is one of the two principal components necessary to run Oracle Exalytics (the 2nd being Oracle Essbase) TimesTen won't just be confined to transaction processing but will also be able to support analytic apps by way of its brand new adaptive caching abilities.

Highlights of TimesTen

The brand new caching function, in conjunction with Exalytics and the Business Intelligence Foundation Suite, enables TimesTen to aid with analytic apps. When it is working together with OBIEE, the TimesTen adaptive cache can look at the workloads that'll be generated by different queries and dashboards. Precise knowledge about these tools is valuable, and that's why professionals should think about taking obiee courses and keeping on top of the most recent changes. Whenever the cache can uncover a response time blockage in an OBIEE application or in apps which are designed to run OBIEE as middleware, the information will be moved to the memory of the Exalytics system. The Exalytics system has 1TB of RAM and is powered by 4 E7-4800 Intel Xeon processors that have 10 cores.

To many of you, 1 TB may not be adequate RAM however TimesTen also gives you compression in columnar form. Because of this 1TB is effectively the same as 5TB of addressable memory. As per Oracle, the data will be scanned in the main memory within 5 seconds. In order to enhance the system's capacity, then you must raise the number of Exalytics boxes. TimesTen's caching abilities are also adaptive in nature because they keep on modifying and refining themselves depending on the changes in dashboarding and query needs. In addition, they depend more on the in-memory speed, materialized views, and other approaches that are more influenced by administration work than on database.

TimesTen and Hana

TimesTen has predominantly been a part of the transaction-processing field, since it has been utilized in that segment since the latter part of the 1990s. It was used by telecommunications companies, online retail, as well as in fiscal buying and selling for low latency applications as an embedded database. SAP's Hana experienced a totally different beginning. Hana was first put to use in analytics as an accelerator to drive the SAP BW (Business Warehouse). Fairly recently, Hana was adopted as a tool to operate analytic apps and also to take the place of the BW database.

Having said that, at present both of these in-memory technologies of SAP and Oracle are set to collide. The main reason Hana presents an issue to Oracle is because SAP is promoting it as something that will turn out to be an in-memory replacement of BW running databases. With the good sized customer base that SAP has got, and with 60% of the instances of BW using Oracle database, any sort of modifications to Hana may affect Oracle adversely.