TechValidate Research on Vertica


Case Study: Small Business Real Estate Company

Introduction

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

“We use HPE Vertica as our data warehouse for reporting and visualization.”

“We would recommend Vertica because it runs effortlessly for workloads that would not practically run on MySQL. Easy to use SQL interface.”

“Vertica cuts development time for visualization apps by eliminating the complexity of high availability MySQL or NoSQL solutions. We get all the speed and power we need with the familiarity of a full-featured SQL implementation and industry-standard APIs.”

Challenges

  • Is using HPE Vertica for the following:
    • Enterprise Data Warehouse optimization
  • Replaced the following vendors with HPE Vertica:
    • Amazon Redshift
    • MySQL

Use Case

  • Currently manages 6TB or less of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tool in their environment with HPE Vertica:
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tool in their environment with HPE Vertica:
    • Tungsten Replicator

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Superior compression
    • In-database analytics capabilities
    • Ease of interaction with existing BI tools & ETL tools
  • Improved query performance by 101 – 500% 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