TechValidate Research on Vertica

Case Study: MD Insider


This case study of MD Insider is based on a February 2016 survey of Vertica customers by TechValidate, a 3rd-party research service.

“We push medical claims data going back several years into Vertica, and make it available to our data scientist to mine gems out of it.”

“Yes!! We would recommend Vertica. The need to run low latency ad-hoc query on large datasets is satisfied with ease using Vertica! While Redshift comes very close in terms of performance, the fact that I can take a Vertica license to my data center, unlike Redshift, makes it preferable!”

“My consumers are data scientists within the organization that mine data out of billions of ingested medical data. Using Vertica has increased, significantly, the productivity of data scientists; due to the speed at which data can get into the engine and can get out of it!”


  • Is using Vertica for the following:
    • Claims analytics
    • Patient records analytics
  • Replaced the following vendor with Vertica:
    • MySQL

Use Case

  • Currently manages 6TB or less of data with Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with Vertica:
    • ETL: Talend
    • BI: Tableau


  • The following are the most valuable Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Superior compression
    • In-database analytics capabilities
    • Ease of interaction with existing BI tools & ETL tools
    • High availability without hardware redundancy
    • Ability to do low latency SQL queries on Hadoop
  • Improved query performance by 101 – 500% with Vertica.

About This Data

This data was sourced directly from verified users of Vertica by TechValidate.

TechValidate verifies the identity and organizational affiliation of all participants that contribute to published research data. When research participants so desire, we also guarantee their anonymity so that they may share information honestly and freely.

More Research on Vertica