TechValidate Research on Vertica


Case Study: Medium Enterprise Computer Software Company

Introduction

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

“With HPE Vertica, data from the data warehouse is loaded into Vertica for analysis. It is preferred by our analysts for the large data sets over Oracle.”

“Analyzing video game success from all angles is the key to our business. Vertica allows us to achieve that with record speed!”

“It performs very well. I think that its ability to self-tune with new projections gives it a lead on other analytic databases.”

Challenges

  • Uses HPE Vertica for the following:
    • Financial tracking
    • Behavior analytics
    • Customer analytics
    • Enterprise Data Warehouse optimization
    • Sales Analytics
  • Replaced the following vendor with HPE Vertica:
    • Green Plum

Use Case

  • Currently manages 6 – 20 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with HPE Vertica:
    • ETL : Informatica – Power Center
    • BI: Cognos 8/10/11
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tools in their environment with HPE Vertica:
    • Replication: Home Grown

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Standard SQL interface
    • Simultaneous loading and querying
    • Database designer and administration tools
    • Ease of interaction with existing BI tools & ETL tools
    • Optimizer and execution engine
  • Improved query performance by 51 – 100% 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