TechValidate Research on Micro Focus Archive

Case Study: Small Business Computer Software Company


This case study of a small business computer software 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.

“Vertica’s performance, scalability, ease of use and OEM-friendly pricing allow us to offer an interactive data exploration experience with adhoc filtering, aggregation and drill-down capabilities. This is a highly disruptive feature set in an industry accustomed to periodic high-level reporting.”


  • 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 lack of business insight from data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Network performance analyses
    • Customer analytics
    • Machine/sensor data analysis
  • Currently managing 500 GB – 1 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Homegrown
    • Custom ETL loader multiple QPID queues. Flash-based UI. Java lib for generating PDF reports


  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Massive scalability on industry-standard hardware
    • Simplicity
    • Standard SQL interface
    • Simultaneous loading and querying
    • Aggressive compression
    • Database designer and administration tools
    • In-database analytics capabilities – R, C++
    • High availability without hardware redundancy
    • Low total cost of ownership (TCO)
  • Achieved the following with HPE Vertica software:
    • Faster analysis and reporting
    • The ability to load and analyze data concurrently
    • Greater business insight
    • A more interactive, conversational view of our data
    • A reduction in database infrastructure costs
    • A reduction in storage costs
    • Reduced implementation time for a new analytics warehouse
  • Increased query performance by 500 – 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 $100,000 – $500,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