TechValidate Research on Vertica

Case Study: Medium Enterprise Computer Software Company


This case study of a medium enterprise computer software company is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“We needed to model our clickstream data in real time, and with HPE Vertica we’re able to do this. This significantly increased our ability to promote the appropriate content to our users.”


  • 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
    • The need to stop queries while loading new data
    • The lack of business insight from data
    • The lack of connection between current BI/analytics initiatives and needs of business
    • Existing data warehouse/data management infrastructure that could not handle Big Data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Promotional testing
    • Clinical data analysis
    • Fraud monitoring/prevention
    • Financial tracking
    • Behavior analytics
    • Clickstream analysis
    • Network performance analysis
    • Customer analytics
    • Predictive analytics
    • Campaign management
  • Currently managing 10 – 20 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Hadoop
    • Pentaho Kettle
    • Pentaho Mondrian
  • Purchased HPE Vertica over the following vendors:
    • Hadoop
    • Home grown solution


  • Values the following features in HPE Vertica software the most:
    • Massive scalability on industry-standard hardware
    • Simplicity
    • Standard SQL interface
    • Simultaneous loading and querying
    • Aggressive compression
    • Flexibility
    • High availability for analytics systems
  • Increased query performance by 10 – 50% through improvement in response time with HPE Vertica.
  • Can compress their data by > 50% with HPE Vertica.
  • Saved $100,000 – $500,000 in overall cost savings from using 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