Essential Guide

How to step up performance with Oracle in-memory database options

The Oracle in-memory database boosts analytics processing speeds and facilitates business intelligence reporting. But the tangible benefits vary. Learn about all the factors that come into play.

Introduction

With its in-memory database add-on to Oracle Database, Oracle projects querying speed increases of more than 1,000%. Users can implement the add-on with their existing Oracle database, avoiding a large data migration or full replacement of the database infrastructure. Oracle continues to offer the Oracle TimesTen in-memory database as well, which has gained popularity in vertical industries such as telecommunications and financial services. Both tools facilitate business analytics and business intelligence reporting by enabling increased flexibility and response times. An added business benefit of in-memory analytics is the reduced reliance on IT staff.

However, businesses must examine the actual benefits of in-memory analytics tools for their particular database architecture, weighing the advantages with the potential costs and specific business objectives. The performance boost may not be as dramatic as expected in some situations.

The articles in this guide offer a close examination of the potential benefits of the Oracle in-memory database options, as well as expert insights into practical uses and possible drawbacks.

1Oracle in-memory database-

What the Oracle in-memory database has to offer

Oracle in-memory databases can increase the performance of analytical queries and allow for a faster approach to deployment. On the other hand, there are costs associated with licensing, hardware and development. The articles in this section examine several factors to consider before choosing any Oracle in-memory database options.

Tip

Considerations for the Oracle in-memory database option

This tip offers preliminary considerations to take into account before implementing the Oracle Database 12c in-memory option. Continue Reading

Tip

Licensing and hardware costs associated with Oracle in-memory database

In this tip, the author discloses the potential licensing and hardware costs that come with the Oracle Database 12c in-memory option. Continue Reading

Tip

Comparing Oracle TimesTen and Sybase ASE in-memory databases, part 1

Expert Mich Talebzadeh examines the Oracle TimesTen in-memory database in detail, looking at how it works and what benefits it offers. Continue Reading

Tip

Sybase ASE in-memory database vs. Oracle TimesTen, part 2

How does Sybase's Adaptive Server Enterprise (ASE) in-memory database compare with Oracle TimesTen? Mich Talebzadeh investigates. Continue Reading

2In-memory speed-

Speed promised by in-memory technology

Perhaps the most touted benefit of in-memory analytics is the great potential for increased processing speeds for business intelligence operations. In the articles in this section, learn more about the reality of these expedited processing times, as well as related considerations such as cost, business goals and varying architectures.

Feature

In-memory processing speed only valuable when matched with business needs

In-memory analytics tools must align with business processes to be valuable to users, according to this co-author of a book on big data analytics. Continue Reading

Feature

Accelerate BI speeds, boost performance with in-memory technology

Explore how in-memory appliances boost business intelligence performance and speed, but may invoke additional costs. Continue Reading

News

In-memory becoming a commodity thanks to Oracle Exalytics

An expert explains how Oracle Exalytics, Oracle's in-memory BI server appliance, will become a commodity due to its fast processing capabilities. Continue Reading

News

In-memory analytics and the potential for faster business intelligence performance

Analysts explain how the potential for faster business intelligence speeds is a common thread with in-memory analytics tools, despite the different architectures available. Continue Reading

3In-memory uses-

Uses for in-memory technologies

In-memory processing can enhance performance in more ways than one. Organizations confronting large data sets -- big data -- and data-intensive projects have been using in-memory applications and data grids to perform analytics tasks. The articles in this section offer user experiences and advice.

Feature

Take on big data analytics with in-memory applications

Get user and consultant insights into analyzing big data with the aid of in-memory applications -- a potent mix. Continue Reading

Feature

Going mainstream: Big data in-memory data grids

In-memory data grid technology is gaining popularity as an answer to big data analytics issues. Continue Reading

Feature

Address performance bottlenecks with in-memory data grids

In-memory data grids can be applied to data-intensive jobs to improve performance. Continue Reading

Podcast

News from OpenWorld 2013: Oracle in-memory database challenges SAP

Learn what SearchOracle editors David Essex and Mark Brunelli discovered about the Oracle in-memory database and other news at OpenWorld 2013. Continue Reading

4Glossary-

Definitions of in-memory database terms

Check out these terms to enhance your understanding of in-memory technologies.