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
Threaded  |  Newest First  |  Oldest First
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.
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 | 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 | 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



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.
News
Think Like a Chief Innovation Officer and Get Work Done
Joao-Pierre S. Ruth, Senior Writer,  10/13/2020
Slideshows
10 Trends Accelerating Edge Computing
Cynthia Harvey, Freelance Journalist, InformationWeek,  10/8/2020
News
Northwestern Mutual CIO: Riding Out the Pandemic
Jessica Davis, Senior Editor, Enterprise Apps,  10/7/2020
Register for InformationWeek Newsletters
Video
Current Issue
[Special Report] Edge Computing: An IT Platform for the New Enterprise
Edge computing is poised to make a major splash within the next generation of corporate IT architectures. Here's what you need to know!
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