Why Should You Combine Transactional & Analytic Databases?

One solution to database challenges is to consolidate database operations, combining transactional and analytic capabilities in a single DBMS with blended features. Here’s a breakdown of what we learned from a recent survey.

Read more: Best Dashboard Software for 2022

Why Should You Combine Transactional & Analytic Databases?

Untimely Data Hurts the Enterprise

Seventy-six percent of the IT professionals surveyed said data that’s not available in a timely way has at least somewhat inhibited their organization’s ability to take advantage of business opportunities.

What’s more, 54% said untimely data limits their company’s ability to improve operational efficiency. Further, 27% said untimely data hurts productivity and agility the most, while 25% said it most negatively impacts their ability to conduct analyses.

Read more on Datamation: Database Trends 2022

Too Many Databases?

More than 60% of the professionals surveyed said they use more than five analytical databases. Along the same lines, 37% are evaluating new database technologies, while 25% are seeking to retire older versions of databases.

All told, survey respondents outlined the following top business objectives for the year:

  • Innovate faster: 34%
  • Streamline operations: 32%
  • Reduce costs: 18%
  • Simplify architecture: 16%

Read more: Cloud Migration: What Are Key Strategies & Processes?

A Blended DBMS Can Solve ETL Lag

Eighty-seven percent of the professionals surveyed said that at least 25% of their transactional data is moved via extract transform load (ETL) technology. What’s more, 64% of transactional data moved via ETL technology takes at least five days to reach the analytical database.

Ninety-one percent of the professionals surveyed said that a blended DBMS that combined transactional and analytics capabilities would be at least moderately valuable. Interestingly, 45% said that all new DBMS technologies must be proprietary (not open source), compared to 17% who are seeking DBMS tech that is strictly open source.

Read more on ServerWatch: Best Database Software & Management Systems

Dennis McCafferty
Dennis McCafferty
Dennis McCafferty is a contributor to CIO Insight. He covers topics such as IT leadership, IT strategy, collaboration, and IT for businesses.

Get the Free Newsletter!

Subscribe to Daily Tech Insider for top news, trends, and analysis.

Latest Articles