TechValidate Research on Vertica


Case Study: Global 500 Telecommunications Services Company

Introduction

This case study of a Global 500 telecommunications services company is based on a March 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.

“In the world of Analytics, user requirement evolve at a rapid pace. Our users want to gain insights from a VERY large volume quickly and they want to be able to do that immediately. They are excited and want more. Vertica allows me to bring server data to the dashboard with a response time that exceeds SLA. Also “time to market” for new and varied data into dashboard ready form is very low."

“HPE Vertica is an excellent enterprise-level analytic database. It does what it is supposed to do and does it very well. Period.”

“In our Big Data analytic stack, Vertica sits at the end of data flow pipeline. Both ETL and ELT processes are used to load data into Vertica. Analytics dashboards and users retrieve/query data from Vertica.”

Challenges

  • Using HPE Vertica for the following:
    • Clickstream analytics
    • Customer analytics
    • Campaign management
    • Enterprise Data Warehouse optimization
  • Replaced the following vendors with HPE Vertica:
    • Oracle
    • Oracle Exadata

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: Hadoop
    • ETL: Kafka
    • BI: Microstrategy
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tools in their environment with HPE Vertica:
    • Advanced Analytics: Home grown (describe in other)

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Superior compression
    • Database designer and administration tools
    • In-database analytics capabilities
    • Ease of interaction with existing BI tools & ETL tools
    • High availability without hardware redundancy
    • Optimizer and execution engine
    • Advanced analytics: predictive, geospatial, sentiment, etc
    • Semi structured and structured data analytics in one environment
  • 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