Oracle Says Database Upgrade Doesn't Enable In-Memory Option - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
News
7/30/2014
10:30 AM
Connect Directly
Google+
LinkedIn
Twitter
RSS
E-Mail

Oracle Says Database Upgrade Doesn't Enable In-Memory Option

Oracle insists latest database release doesn't enable a costly in-memory option, countering claims by an ex-Oracle-employee and database blogger.

Maria Colgan's Google+ page describes her blog post on the Oracle Database In-Memory option as a response to Kevin Closson's reports.
Maria Colgan's Google+ page describes her blog post on the Oracle Database In-Memory option as a response to Kevin Closson's reports.

Comment  | 
Print  | 
Comments
Newest First  |  Oldest First  |  Threaded View
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
7/30/2014 | 4:12:39 PM
Reader comments that options shouldn't be treated like features
Reader Dave Schmidt submitted the following comment via email:

Based on the passage below (underlined words my emphasis), Oracle is putting it to customers. What they are describing is a feature disabled for marketing purposes, not an option.

Oracle's Monday blog post, titled "Getting started with Oracle Database In-Memory," explains that the feature is installed automatically with the latest release because it's an intrinsic part of the database, "not a bolt-on technology," writes Maria Colgan, master product manager of the feature. But enabling the option requires a deliberate, two-step process, she explains. All opinions expressed here are personal. -- Dave Schmidt

gxs11
50%
50%
gxs11,
User Rank: Apprentice
7/30/2014 | 2:43:15 PM
It is all about defaults.
The pointof the article is that Oracle says the default on the latest upgrade leaves the In-Memory option off. Having been both a Technical Consultant and a Design Architect, I am aware of how poorly developers tend to set defaults in terms of performance. With application software such stupid, inefficient defaults often fall through the cracks and an application succeeds with customers in spite of it. With databases, the DBA and Data Architect are expected to be knowledgeable enough and sufficiently detail oriented to address such matters.

When one considers how cheap memory has become, it is amazing that it has takes so long for this to be implemented. Hana is one of the reasons SAP has been so successful.
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
7/30/2014 | 12:34:45 PM
Re: Oracle is Very Late to the Game on this Concept
What you say about IBM's CICS technology may be true, but IBM only recently added in-memory technology to its flagship DB2 database by way of the BLU Acceleration for DB2 feature, introduced in 2013. I'm fairly certain it's an extra-cost option. BLU acceleration applies only to analytic querying, not transactional performance.

Oracle Database In-Memory applies acceleration to selected analytical queries, and if you can eliminate query indexes, you can also accelerate transactional performance by two to four times, according to Oracle. SAP's Hana In-Memory Database runs entirely in memory, not just against selected tables or partitions, and improves transactional and analytical performance. Microsoft's In-Memory OLAP feature for SQL Server 2014 applies only to transactional perfomance.
gxs11
50%
50%
gxs11,
User Rank: Apprentice
7/30/2014 | 12:24:26 PM
Oracle is Very Late to the Game on this Concept
Data-In-Memory use started with Local Shared Resources in the late 1970's under CICS (IBM's interactive online program originally developed for NASA). I did work making it available for batch processing in 1985-6. My point is that this is an old concept and Oracle is very late in introducing it. Charging a hefty license fee for it is outrageous.
Slideshows
Data Science: How the Pandemic Has Affected 10 Popular Jobs
Cynthia Harvey, Freelance Journalist, InformationWeek,  9/9/2020
Commentary
The Growing Security Priority for DevOps and Cloud Migration
Joao-Pierre S. Ruth, Senior Writer,  9/3/2020
Commentary
Dark Side of AI: How to Make Artificial Intelligence Trustworthy
Guest Commentary, Guest Commentary,  9/15/2020
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
IT Automation Transforms Network Management
In this special report we will examine the layers of automation and orchestration in IT operations, and how they can provide high availability and greater scale for modern applications and business demands.
Slideshows
Flash Poll