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