Close
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Menu
Search
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    IDC Spells Out Value of In-Memory as Database of Future

    By
    Chris Preimesberger
    -
    August 25, 2015
    Share
    Facebook
    Twitter
    Linkedin

      IT research firm IDC released a new report Aug. 25 that advises enterprises with a need to better handle their data for making strategic business decisions to look seriously at in-memory databases.

      Fundamentally, the researcher said that enterprises need to be doing business intelligence on hot and fresh data to make accurate business decisions and projections and not waste time on information sitting in a data warehouse that is weeks or months old.

      “The whitepaper is a fairly straightforward exposition of the benefits of in-memory [database] capability in general and for Oracle users in particular,” IDC analyst Carl Olofson, author of the report, told eWEEK.

      “In general, what it means is you can set up your database to do complex queries without facing the classic problems of allocating the data in storage, so that you can make the queries run faster using partitioning, that kind of thing, using com secondary indexes.

      “You can also perform complex queries on production data [using an in-memory database] because they have that capability.”

      The in-memory database world is growing as IT decision-makers realize the value of speed in this department. MemSQL, Oracle DB In-Memory, SAP HANA, Pivotal, Starcounter, DataStax, Terracotta, EMC eXtremDB, Gemfire, Microsoft SQL, Informix, Oracle TimesTen, VoltDB, SafePeak and Kognitio are just a few of the in-memory databases now available.

      These are still much more expensive than standard databases—often five to 10 times more costly at acquisition. But, like so many other business-tool decisions managers have to make, this type of new-gen component can make a huge difference in cost and efficiency to an enterprise over a span of time.

      IDC research shows that most business managers admit to basing their intra-day decisions on personal knowledge and educated guesswork rather than on data. Data is commonly used for monthly, quarterly, annual and multiyear planning—but not for on-the-spot business decisions. This is what needs to change, Olofson said.

      The reason for this old-school approach is simple: The data is not available, Olofson said. Most business intelligence systems extract data on a periodic basis from operational databases and load it into analytic databases for query and reporting. These may be operational data stores, data marts or data warehouses.

      Operational data stores and data marts typically have schemas similar to those of operational databases, but with indexes for query enhancement, cubes, materialized views and so forth to enhance query performance. They may receive data through frequent extract, transform and load (ETL) processes or from dynamic data movement tools, such as change data capture (CDC) software.

      They are used to making short-term planning decisions, looking at the next day, the next week and the next month. Data warehouses, which receive data from many databases and collect it in a schema carefully crafted to encompass all the source data in a way that optimizes the value of queries, receive their data through scheduled ETL (extract, transform and load) jobs and are used for quarterly, semiannual, annual and multiyear planning exercises.

      Using an in-memory database, Olfson said, decisions can be made in near-real time, saving not only time and effort but hard storage costs.

      You can obtain a portable document format (PDF) copy of the report here.

      Avatar
      Chris Preimesberger
      https://www.eweek.com/author/cpreimesberger/
      Chris J. Preimesberger is Editor-in-Chief of eWEEK and responsible for all the publication's coverage. In his 16 years and more than 5,000 articles at eWEEK, he has distinguished himself in reporting and analysis of the business use of new-gen IT in a variety of sectors, including cloud computing, data center systems, storage, edge systems, security and others. In February 2017 and September 2018, Chris was named among the 250 most influential business journalists in the world (https://richtopia.com/inspirational-people/top-250-business-journalists/) by Richtopia, a UK research firm that used analytics to compile the ranking. He has won several national and regional awards for his work, including a 2011 Folio Award for a profile (https://www.eweek.com/cloud/marc-benioff-trend-seer-and-business-socialist/) of Salesforce founder/CEO Marc Benioff--the only time he has entered the competition. Previously, Chris was a founding editor of both IT Manager's Journal and DevX.com and was managing editor of Software Development magazine. He has been a stringer for the Associated Press since 1983 and resides in Silicon Valley.

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      eWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      Zeus Kerravala - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      Wayne Rash - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more
      eWeek


      Contact Us | About | Sitemap

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Property of TechnologyAdvice.
      Terms of Service | Privacy Notice | Advertise | California - Do Not Sell My Information

      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×