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
Comments
Oracle Says Database Upgrade Doesn't Enable In-Memory Option
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.


2020 State of DevOps Report
2020 State of DevOps Report
Download this report today to learn more about the key tools and technologies being utilized, and how organizations deal with the cultural and process changes that DevOps brings. The report also examines the barriers organizations face, as well as the rewards from DevOps including faster application delivery, higher quality products, and quicker recovery from errors in production.
Slideshows
Data Science: How the Pandemic Has Affected 10 Popular Jobs
Cynthia Harvey, Freelance Journalist, InformationWeek,  9/9/2020
Commentary
How to Eliminate Disruptive Technology's Risk
Andrew Froehlich, President & Lead Network Architect, West Gate Networks,  8/31/2020
News
How Analytics Helped Accenture's Pandemic Plans
Jessica Davis, Senior Editor, Enterprise Apps,  9/1/2020
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.
White Papers
Slideshows
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Sponsored Video
Flash Poll