Oracle Updates TimeTen in-Memory Database, Aims At SAP HANA

Performance, scalability and analytic capabilities are the key new features in TimesTen 11g Release 2.

By Chris Kanaracus
Thu, January 12, 2012

IDG News Service — Oracle on Thursday rolled out an updated version of its TimesTen In-Memory Database, which is a key component of its upcoming Exalytics appliance as well as a competitor to SAP's HANA platform.

TimesTen 11g Release 2 is a relational database "designed to run in the application-tier to provide both rapid transaction response time and high throughput required by mission-critical applications," Oracle said in a statement.

The new release's features include increased performance and scalability that will allow it to support additional concurrent users and sessions as well as larger amounts of requests, Oracle said.

Oracle has also added capabilities to support analytic workloads as well as the OLTP (online transaction processing) jobs TimesTen has long been associated with. To the latter end, Oracle also announced that the release will ship alongside its Communications Billing and Revenue Management application, providing significant leaps in speed and scalability, according to the company.

The vendor has also added columnar compression capabilities that allow up to a 5:1 compression ratio for data stored in memory. That feature is aimed at giving customers of Exalytics machines, which will each contain 1TB of RAM, the ability to process more information at once.

TimesTen's role in Exalytics will also allow Oracle's Business Intelligence Foundation Suite, which is also used in the systems, to run up to 20 times faster, Oracle claimed.

"The key feature is the in-memory columnar compression," said Forrester Research analyst James Kobielus. "I expect them to see them improve that to the level of efficiency on the Exadata platform, where they can achieve 10:1 to 40:1 compression."

Even with those ratios, the amount of data Exalytics would store in memory is small compared to the petabytes users can store in Exadata machines, which are also capable of handling both analytic and transactional workloads.

But the use case for TimesTen and Exalytics is different, Kobielus said. Those products are geared "for real-time, interactive BI, submitting one query after another to [the in-memory database] and iterating through a given problem space. You need to be able to consider a lot of scenarios very quickly."

Exalytics has not yet been released, but given its emergence this week on Oracle's public price list, a launch seems imminent. Overall, the market will see competition heighten between SAP and Oracle, Kobielus said.

"It's a horse race to see who can integrate their in-memory appliances the most quickly and thoroughly, and with the most stability, throughout their entire portfolio," he said.

SAP released the first version of HANA in June, and so far has aimed it primarily at analytic workloads, including through a series of specialized analytic applications that will run on top of the database. But the company also plans to port HANA to its various ERP (enterprise resource planning) software applications as well, including the flagship Business Suite, which many customers now run using Oracle databases.

Chris Kanaracus covers enterprise software and general technology breaking news for The IDG News Service. Chris's e-mail address is Chris_Kanaracus@idg.com

What is Tech Briefcase?

TechBriefcase is a new, free service where IT Professionals can Search, Store and Share IT white papers and content like this. Learn more

Bookmark content

Speed up your research efforts with content across the web.

Search and Store

Find the white papers you need. Create folders for any topic.

View Anywhere

Open your briefcase on your iPhone, tablet or desktop. Share with colleagues.

Don't have an account yet?

You are here: Applications » Data Warehouse » News

Most Recent Data Warehouse Stories

White Papers »

How Much Containment Is Enough?

Achieving an optimum degree of airflow containment cannot be reached through a one-size-fits-all solution. The true measurement of any containment solution is dependent upon using a Hot Aisle, Cold Aisle or Cabinet Containment strategy that has been optimized for airflow, static pressure, leakage, bypass air and temperature variance.

Fast Track your Access to Business Intelligence

Identifying the right configuration and deploying complete, scalable data warehouses can be a time consuming, costly and error-prone process. Success ultimately depends on the ability to deploy a system that can support an expected level of performance - then allow that performance to scale linearly as needed.

Best Practices for Implementing a Data Warehouse on Oracle Exadata

Increasingly companies are recognizing the value of an enterprise data warehouse (EDW). A true EDW provides a single 360-degree view of the business and a powerful platform for a wide spectrum of business intelligence tasks ranging from predictive analysis to near real-time strategic and tactical decision support throughout the organization. Ensuring the EDW will get the desired performance and will scale out as your data grows you need to get three fundamental things correct, the hardware configuration, the physical data model and the data loading process. By correctly designing these three corner stones you will be able to create an EDW that can seamlessly scale without constant tuning or tweaking of the system.

By using the Oracle Exadata Database Machine as your data warehouse platform you have a balanced, high performance hardware configuration. This paper focuses on the other two corner stones, data modeling and data loading, providing a set of best practices and examples for deploying a data warehouse on the Oracle Exadata Database Machine.

Oracle: Big Data for the Enterprise

Analyzing new and diverse digital data streams can reveal new sources of economic value, provide fresh insights into customer behavior and identify market trends early on. But managing this influx of new data can be a challenge. To derive real business value from big data, you need the right tools to ca! pture and organize a wide variety of data types from different sources, and be able to easily analyze it with your enterprise data. By using the Oracle Big Data Appliance with Oracle Exadata, enterprises can acquire, organize and analyze all their enterprise data to make the most informed decisions.

Oracle Database 11g Product Family

By deploying Oracle Database 11g within their IT architecture, organizations can leverage the power of the world's leading database to reduce their server and storage costs and improve quality of service. Read this white paper to get an overview of the Oracle Database family of products and learn how you can transform your business, budgets, and service levels with Oracle Database 11g Release 2.

Oracle Real Application Testing 11g Release 2

Real Application Clusters with Oracle Database 11g, enables a single database to run across a cluster of servers, providing unbeatable fault tolerance, performance, and scalability with no application changes necessary. This white paper provides a technical overview of Oracle Real Application Clusters 11g Release 2 with an emphasis on the features and functionality that can be implemented to provide the highest availability and scalability for your enterprise applications.

Webcasts »

Enterprise Data Warehouse Appliance (EDW)

Join IDC Analyst Dan Vesset and HP Senior Architect, Jeff Spiller, as they discuss the rise of analytics, the impact of big data and need for scalable enterprise solutions. Learn about the HP Enterprise Data Warehouse appliance, which offers massive scale at low cost for single rack appliances up to large scale Data Warehouses. All while providing a single view of information across your enterprise that scales with your data, improves query performance and reduces IT cost over traditional data warehousing offerings. Featuring Intel® Westmere processors. View the entire webcast or only the chapters you desire.

Appliance video

The first appliance in the industry which consolidates and manages thousands of databases, integrates hardware, software and support and is scalable to meet your changing business needs.

Database Consolidation-SQL Server Appliance and Building Your Private Cloud

Please join guest speaker IDC Analyst Carl Olofson as he discusses Enterprise Data Center challenges and why database consolidation is important and necessary. And hear from HP expert Joe Sullivan, who will discuss the HP Database Consolidation Appliance and how it addresses enterprise industry challenges. Joe will provide an overview of product architecture and details on how the appliance enables companies to build their own private cloud. This webcast will provide the latest information for simplifying your data management needs while reducing costs.

Gaining A Competitive Advantage With Your Data

Fact: The demand to respond faster and with greater insight to business demands, based on data, is increasing. Fact: More organizations are turning to business intelligence (BI) and data warehousing for insightful decision-making.

Leverage automation today to reduce IT complexity

Date: Tuesday, June 5, 2012, 2:00 PM EDT

Whether your B2B complexity is caused by multiple technologies due to M&A, business or application specific needs or traditional under investment, the net effect is usually the same: high cost and lower productivity. Enabling business-to-business (B2B) integration using point-to-point EDI translators is usually time intensive and cost prohibitive.

Join IDC's Maureen Fleming and SAP for an insightful Webcast on the different approaches companies are taking to B2B integration and how you can ask the right questions to reassess you B2B approach.

Delivery Management -- Extending Lifecycle Management

Date: Wednesday, June 20, 2012, 1:00 PM EDT

Siloed organizations continue doing the wrong things and doing things wrong, leading to increased costs, project delays, lower quality, and time-to-market delays. Providing a collaborative platform where the whole organization can prioritize, share and manage deliveries with more transparency can help the organizations make more informed decisions at all levels, and greatly improve communications and traceability between teams. Hear from application lifecycle management experts how to increase delivery efficiency and effectiveness with a new approach to Delivery Management.

Newsletter Sign-Up »

Receive the latest news test, reviews and trends on your favorite technology topics

Choose a newsletter