TechValidate Research on Micro Focus Archive

Case Study: Medium Enterprise Media & Entertainment Company


This case study of a medium enterprise media & entertainment 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 were able to leverage data at a raw level and at massive scale. That coupled with the ease of use and interactions via ANSI SQL changed our company into an analytical company top to bottom. Metrics and analysis are used daily to help guide the business.”


  • 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 need to stop queries while loading new data
    • Performance limits with current system
    • The lack of business insight from data
    • Existing data warehouse/data management infrastructure that could not handle Big Data
    • Supports ANSI SQL plus analytical functions

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Financial tracking
    • Behavior analytics
    • Clickstream analyses
    • Customer analytics
    • Predictive analytics
    • Campaign management
  • Currently managing 1PB + of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Pentaho Kettle
    • Tableau
    • Homegrown
    • Reporting 2d and charting, also some custom ETL


  • 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
    • Concurrency for hundreds or thousands of users
    • Aggressive compression
    • In-database analytics capabilities – R, C++
    • Ease of interaction with existing BI tools through connectors and ODBC/JDBC
    • High availability without hardware redundancy
    • Optimizer and execution engine
    • Workload management
    • Flexibility
    • 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
    • Enhanced profitability
    • Increased amount and complexity of data analyzed
    • Increased concurrency for accessing analytics/BI (multiple users)
    • Reduced implementation time for a new analytics warehouse
    • Advanced analytics with in-database C++ or R
    • High availability for analytics systems
  • Is able to analyze > 1,000% more data at one time with HPE Vertica.
  • Saved > $10,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