TechValidate Research on Vertica


Case Study: Medium Enterprise Health Care Company

Introduction

This case study of a medium enterprise health care company is based on a February 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“HPE Vertica is used as our hosting platform where a lot of analytics have been performed.”

“Yes, we would recommend HPE Vertica because of the following:
1. It runs really really fast
2. They have the best support professionals
3. There are multiple ways to monitor the performance of the database/queries
4. Parallel load and query feature
5. High availability with improved query performance
6. An easy way to remove/replace/add nodes to the cluster
7. Interface with HADOOP
8. Database design features to enable the best design
9. Addition of new features for Backup, recovery, catalog footprint
10. Feature to save and use the optimized query path
11. Ability to guide an optimized query path.”

“I received valuable support from Vertica support professionals. The way they respond is awesome and support answers all of my queries with patience and dedication. Furthermore, I personally like the product and find the concept to be cool. If there is a problem, HPE always has a solution to fix it through a new patch."

“With HPE Vertica, we are able to reduce the response time significantly. We continue to see an increase in usage by our clients.”

Challenges

  • Is using HPE Vertica for the following:
    • Claims analytics
    • Patient records analytics
    • Clinical data analytics
    • Fraud monitoring/prevention
    • Predictive analytics
  • Replaced the following vendors with HPE Vertica:
    • IBM
    • Oracle
    • Oracle Exadata

Use Case

  • Currently manages 21 – 40 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tool in their environment with HPE Vertica:
    • BI: Microstrategy
  • Uses the following Advanced Analytics and/or Replication tool in their environment with HPE Vertica:
    • Advanced Analytics: SAS

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Database designer and administration tools
    • High availability without hardware redundancy
    • Optimizer and execution engine
    • Workload management
  • Reduced TCO by > 100% with HPE Vertica.
  • Improved query performance by 501 – 1,000% with HPE 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