TechValidate Research on Micro Focus Archive

Case Study: Medium Enterprise Health Care Company


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

“We replaced DB2 with Vertica for reporting and achieved 800X improvement and more. Data Analysis improved more than 1000%. We were able to attract new customers leading to increased revenue.”


  • Addressed the following pain points with the HPE Vertica Analytics Platform:
    • Slow or incomplete queries
    • The inability to analyze large volumes of data
    • Summarized or aggregated data, losing detail and insights
    • The lack of concurrency limits access to data
    • The prohibitive cost of adding capacity due to licensing or hardware
    • Performance limits with current system

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Claims analyses
    • Patient records analyses
    • Clinical data analyses
    • Fraud monitoring/prevention
    • Behavior analytics
  • Currently managing 40 – 80 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Ab Initio
    • Cognos 8 BI
    • IBM Data Stage
    • SAS


  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Massive scalability on industry-standard hardware
    • Simplicity
    • Aggressive compression
    • Database designer and administration tools
    • In-database analytics capabilities – R, C++
    • Low total cost of ownership (TCO)
    • High availability for analytics systems
  • Achieved the following with HPE Vertica software:
    • Faster analysis and reporting
    • The ability to load and analyze data concurrently
    • Greater business insight
    • Greater financial insight
    • Improved insight into customer behaviors
    • Increased amount and complexity of data analyzed
    • A reduction in database infrastructure costs
    • A reduction in storage costs
    • Ease of adding additional database capacity
    • High availability for analytics systems
  • Increased query performance by > 1,000% through improvement in response time with HPE Vertica.
  • Is able to analyze > 1,000% more data at one time with HPE Vertica.
  • Saved $1,000,000 – $5,000,000 in overall cost savings from using HPE Vertica.

About This Data

This data was sourced directly from verified users of Micro Focus Archive 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 Micro Focus Archive