Menu

TechValidate Research on Micro Focus Vertica

These pages present data that TechValidate has sourced via direct research with verified customers and users of Micro Focus Vertica. TechValidate stands behind the authenticity of all published data. Learn more »



860 Customers Surveyed

6,975 Data Points Collected

483 Published TechFacts

31 Published Charts

86 Published Case Studies



Featured Research Collections for Micro Focus Vertica

Curated collections and slideshows of TechValidate research data on Micro Focus Vertica.



Selected Research Highlights


Case Study: Small Business Financial Services Company

Introduction

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

“By replacing our current SQL database with Vertica, we have achieved 50X – 1000X improvement in query speed with one-tenth the storage space.”

Challenges

  • 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
    • Performance limits with current system
    • Existing data warehouse/data management infrastructure that could not handle Big Data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Fraud monitoring/prevention
    • Customer analytics
    • Predictive analytics
  • Currently managing 1 – 5 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • GoldenGate TDM

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Simplicity
    • Aggressive compression
    • Database designer and administration tools
  • Achieved the following with HPE Vertica software:
    • Faster analysis and reporting
    • Increased amount and complexity of data analyzed
    • Ease of adding additional database capacity
  • Increased query performance by > 1,000% through improvement in response time with HPE Vertica.
  • Is able to analyze 100 – 500% more data at one time with HPE Vertica.

Vertica Customer Testimonial

Outstanding Performance at a Fraction of the Cost

By utilizing Vertica, we are able to reduce our cost of ownership by ~80% in one case. The responsiveness of queries is outstanding and allows us to consider moving most of our core data to the platform.

Data Architect, Fortune 500 Telecommunications Services Company

Vertica means extreme returns on investment

By what % are you able to reduce the Total Cost of Ownership (TCO) by using Vertica? (TCO reductions from: ability to run on commodity hardware, superior compression, ease of use, limitless scalability, high performance)

Greater than 100%
3%
51-100%
31%
26-50%
40%
1-25%
26%

Case Study: Medium Enterprise Telecommunications Services Company

Introduction

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

“The ability to continuously load data and query at the same time with Vertica has allowed our applications to provide improved availability and access to big data.”

Challenges

  • Addressed the following pain points with the HPE Vertica Analytics Platform:
    • Slow or incomplete queries
    • The inability to analyze large volumes of data
    • The lack of concurrency limits access to data
    • The prohibitive cost of adding capacity due to licensing or hardware
    • The need to stop queries while loading new data
    • Performance limits with current system
    • Existing data warehouse/data management infrastructure that could not handle Big Data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Behavior analytics
    • Customer analytics
    • Predictive analytics
  • Currently managing 80 – 200 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Oracle
    • Oracle OBIEE

Results

  • 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
    • 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
    • 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
    • Improved insight into customer behaviors
    • Increased amount and complexity of data analyzed
    • A reduction in database infrastructure costs
    • A reduction in storage costs
    • Increased concurrency for accessing analytics/BI (multiple users)
    • Ease of adding additional database capacity
    • High availability for analytics systems
  • Increased query performance by 100 – 500% through improvement in response time with HPE Vertica.
  • Is able to analyze 100 – 500% more data at one time with HPE Vertica.
  • Saved $500,000 – $1,000,000 in overall cost savings from using HPE Vertica.

Most Valued feature in Vertica – Extreme Speed and Performance

Which of the following features in Vertica do you value the most?

Extreme speed and performance
80%
Massive scalability on industry-standard hardware
45%
Simplicity
38%
Standard SQL interface
69%
Simultaneous loading and querying
40%
Concurrency for hundreds or thousands of users
9%
Aggressive compression
48%
Database Designer and Administration Tools
17%
In-database analytics capabilities – R, C++
17%
Native support MapReduce and Hadoop
11%
Ease of interaction with existing BI tools through connectors and ODBC/JDBC
35%
High availability without hardware redundancy
31%
Optimizer and Execution Engine
22%
Workload management
10%
Flexibility
11%
Low Total Cost of Ownership (TCO)
27%
High availability for analytics systems
32%

Vertica’s scalability and its OEM-friendly pricing helped maintain reputation

By replacing our current MySQL database with Vertica, we have achieved 20x – 500x improvement in query speed with one-fourth the storage space. Vertica’s scalability and its OEM-friendly pricing helped us maintain our reputation for delivering an excellent SAN monitoring application.

Engineer, Medium Enterprise Computer Software Company



More to Explore



About Micro Focus Vertica

With the MicroFocus Vertica Analytics platform, MicroFocus innovates in software, services and big data infrastructure to make data tangible for businesses, right now.

Micro Focus Vertica Website