How a Blended Approach to Databases Can Help IT

 
 
By Dennis McCafferty  |  Posted 08-21-2017 Email
 
 
 
 
 
 
 
 
 
  • Previous
    How a Blended Approach to Databases Can Help IT
    Next

    How a Blended Approach to Databases Can Help IT

    A solution to database challenges is to consolidate database operations combining transactional and analytic capabilities in a single DBMS with blended features.
  • Previous
    Data Delay
    Next

    Data Delay

    76% of the professionals surveyed said that data that's not available in the timely way has at least somewhat inhibited their organization's ability to take advantage of business opportunities.
  • Previous
    Big Bottleneck
    Next

    Big Bottleneck

    54% said untimely data limits their company's ability to improve operational efficiency.
  • Previous
    Ill Effects
    Next

    Ill Effects

    27% said untimely data hurts productivity and agility the most, while 25% said it most negatively impacts their ability to conduct analyses.
  • Previous
    Multi-Sourced
    Next

    Multi-Sourced

    More than 60% of the professionals surveyed said they use more than five analytical databases.
  • Previous
    IT Overhaul
    Next

    IT Overhaul

    37% are evaluating new database technologies, while 25% are seeking to retire older versions of databases.
  • Previous
    Top Business Objectives for 2017
    Next

    Top Business Objectives for 2017

    Innovate faster: 34%. Streamline operations: 32%. Reduce costs: 18%. Simplify architecture: 16%.
  • Previous
    Dominant Share
    Next

    Dominant Share

    87% of the professionals surveyed said that at least 25% of their transactional data is moved via extract transform load (ETL) technology.
  • Previous
    Slow Churn
    Next

    Slow Churn

    64% of transactional data moved via ETL technology takes at least five days to reach the analytical database
  • Previous
    Good Mix
    Next

    Good Mix

    91% of the professionals surveyed said that a blended DBMS that combined transactional and analytics capabilities would be at least moderately valuable.
  • Previous
    Closed Issue
    Next

    Closed Issue

    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.
 

With many current systems failing to make data available in a timely manner, a significant share of companies are actively evaluating new forms of database management system (DBMS) technology, according to a recent survey from InterSystems. The resulting report, "Choosing a DBMS to Address the Challenges of the Third Platform," indicates that much of the problem is based on the management of data that is transactional (records-oriented processing that drives business operations) versus analytical (data from many transactional databases and optimized for query speed). Supporting both types is difficult, as databases optimized for transactions are not usually able to perform complex analytical queries in a timely manner, if at all. At the same time, databases intended for analytics are frequently too slow at transaction processing to meet organizational needs. In addition, large amounts of transactional data move forward using extract transform load (ETL) technology, which migrates data to analytical databases too slowly, findings claim. "The era of digital transformation … brings with it the need to analyze an array of data types and to analyze transactional data at near-real-time speed," according to the report. "Many organizations today are still using ETL data transfer approaches, which cannot meet requirements for real-time data analysis. Untimely data significantly inhibits [the] ability to compete and remain agile. A solution to these challenges is to consolidate database operations combining transactional and analytic capabilities in a single DBMS solution with blended features." Professionals in 502 global organizations, whose work involves databases, took part in the research, which was conducted by IDC.

 
 
 
 
 
Dennis McCafferty is a freelance writer for Baseline Magazine.

 
 
 
 
 
 

Submit a Comment

Loading Comments...
 
Manage your Newsletters: Login Register