Speedy in-memory databases put lid on costs


Source: cornelius30

With big data raining down on enterprises, it's DBAs who are stuck trying to weather the storm. Their work is particularly arduous because vast increases in data volumes mean significantly more disk capacity to manage. Disk optimization becomes practically a full-time job.

With 20th century databases, disk optimization was a necessary art for a DBA. The best DBAs gave it a lot of thought. A lot. It even became an essential part of a DBA’s education. That’s because without the DBA’s optimization skills, application SLAs would seldom be met.

Devoting so much time to disk optimization is costly. Carl Olofson, research vice president at IDC, considers lowering operational costs, particularly the time DBAs must devote to disk management issues, as a side benefit for deploying ultra-high-performance in-memory databases. He writes, “No more unload/reload operations, index rebuilds, disk redistributions, and backups means that expensive DBA time can be freed up for more high value work.”

By migrating performance-hungry and SLA-critical analytics applications to an in-memory database, the relentless demand for improved response time from business groups can be met without DBAs having to regularly burn the midnight oil simply to squeeze out another millisecond or two in performance. These man-years of labor savings are not a one-time event, but long-term operational savings for IT.

Olofson cites response-time improvements ranging from 10 to 200 times when applications are moved to in-memory databases, pushing SLA metrics to their highest levels. It’s ironic, then, that in-memory databases help keep operational costs to their lowest levels as well.

Related reading:

Invent new possibilities with HANA, SAP's game-changing in-memory software

SAP Sybase IQ Database 15.4 provides advanced analytic techniques to unlock critical business insights from Big Data

SAP Sybase Adaptive Server Enterprise is a high-performance RDBMS for mission-critical, data-intensive environments. It ensures highest operational efficiency and throughput on a broad range of platforms.

SAP SQL Anywhere is a comprehensive suite of solutions that provides data management, synchronization and data exchange technologies that enable the rapid development and deployment of database-powered applications in remote and mobile environments

Overview of SAP database technologies

Join us:






Spotlight on ...
Online Training

    Upgrade your skills and earn higher pay

    Readers to share their best tips for maximizing training dollars and getting the most out self-directed learning. Here’s what they said.


    Learn more

Big DataWhite Papers & Webcasts

See more White Papers | Webcasts

Answers - Powered by ITworld

ITworld Answers helps you solve problems and share expertise. Ask a question or take a crack at answering the new questions below.

Ask a Question