Collection of Vertica User Case Studies- Part 1 of 2

Check out some mini case studies that show a snapshot of how customer are using HP Vertica and what benefits they have achieved.



Case Study: Medium Enterprise Professional Services Company

Introduction

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

“With Vertica, we were able to significantly improve the data load and query run times. This means near real time analysis and availability of 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 prohibitive cost of adding capacity due to licensing or hardware
    • 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:
    • Network performance analyses
    • Customer 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:
    • Microsoft Integrated Services
    • Microsoft SQL Server Reporting Services

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Massive scalability on industry-standard hardware
    • Simplicity
    • Simultaneous loading and querying
    • Aggressive compression
    • Low total cost of ownership (TCO)
  • Achieved the following with HPE Vertica software:
    • Faster analysis and reporting
    • The ability to load and analyze data concurrently
    • A reduction in database infrastructure costs
  • Increased query performance by 100 – 500% through improvement in response time with HPE Vertica.
  • Is able to analyze 500 – 1,000% more data at one time with HPE Vertica.
  • Saved $500,000 – $1,000,000 in overall cost savings from using HPE Vertica.

Case Study: Large Enterprise Media & Entertainment Company

Introduction

This case study of a large 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 are able to track and analyze data in much greater detail than with our previous platform. Our load times have decreased from 18 hours to 3 per 120gb of data. We are able to execute multiple analytical cubes and support a large number of users concurrently.”

Challenges

  • Addressed the following pain points with the HPE Vertica Analytics Platform:
    • The inability to analyze large volumes of 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:
    • Clickstream analyses
  • Currently managing 80 – 200 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Hadoop
    • MicroStrategy
    • Talend Open Studio

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Simplicity
    • In-database analytics capabilities – R, C++
    • Native support MapReduce and Hadoop
    • Optimizer and execution engine
  • 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 concurrency for accessing analytics/BI (multiple users)
    • High availability for analytics systems
  • Is able to analyze > 1,000% more data at one time with HPE Vertica.

Case Study: Global 500 Telecommunications Services Company

Introduction

This case study of a Global 500 telecommunications 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.

“Vertica has changed our entire business dynamic. We are able to report on data with much less latency than when we processed only in Oracle. Further, we have been able to improve our accuracy due to the ability to run queries, converse, change code and reprocess results in real time. This wasn’t possible in Oracle.”

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
    • The prohibitive cost of adding capacity due to licensing or hardware
    • Performance limits with current system
    • The lack of business insight from data
    • The lack of connection between current BI/analytics initiatives and needs of business
    • Existing data warehouse/data management infrastructure that could not handle Big Data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Customer analytics
    • Machine/sensor data analysis
  • Currently managing 10 – 20 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Business Objects Crystal Reports
    • Oracle
    • Talend Open Studio
    • Homegrown
    • SQL

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Standard SQL interface
    • Simultaneous loading and querying
    • Aggressive compression
    • Database designer and administration tools
    • Ease of interaction with existing BI tools through connectors and ODBC/JDBC
    • High availability without hardware redundancy
    • Optimizer and execution engine
    • Flexibility
    • Low total cost of ownership (TCO)
  • 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
    • A more interactive, conversational view of our data
    • 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)
    • Reduced implementation time for a new analytics warehouse
    • Ease of adding additional database capacity
    • High availability for analytics systems
  • Increased query performance by > 1,000% through improvement in response time with HPE Vertica.
  • Is able to analyze > 1,000% more data at one time with HPE Vertica.

Case Study: Non Profit

Introduction

This case study of a non-profit is based on a February 2013 survey of HP Vertica customers by TechValidate, a 3rd-party research service. The profiled organization asked to have their name blinded to protect their confidentiality.

“HPE Vertica Software has enabled us to provide service offerings we would otherwise not have been able to provide. The most important feature to us is the speed with which we are able to do an ad-hoc analysis of larger data sets.”

Challenges

  • Addressed the following pain points with the HPE Vertica Analytics Platform:
    • Slow or incomplete queries
    • The inability to analyze large volumes of data
    • Performance limits with current system

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Claims analyses
    • Patient records analyses
    • Fraud monitoring/prevention
    • Predictive analytics
    • Machine/sensor data analysis
  • Currently managing 500 GB – 1 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Hadoop
    • Pentaho Kettle
    • Pentaho Mondrian
    • SAS
    • SPSS
    • Tableau
    • Talend Open Studio

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
    • In-database analytics capabilities – R, C++
    • Native support MapReduce and Hadoop
    • Ease of interaction with existing BI tools through connectors and ODBC/JDBC
    • Optimizer and execution engine
  • Achieved the following with HPE Vertica software:
    • Faster analysis and reporting
    • A more interactive, conversational view of our data
    • Increased amount and complexity of data analyzed
    • Advanced analytics with in-database C++ or R
  • Increased query performance by 500 – 1,000% through improvement in response time with HPE Vertica.
  • Is able to analyze > 1,000% more data at one time with HPE Vertica.

Case Study: Medium Enterprise Media & Entertainment Company

Introduction

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.”

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
    • 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

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
    • 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.

Case Study: Large Enterprise Telecommunications Services Company

Introduction

This case study of a large enterprise telecommunications 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.

“Only with Vertica we’re able to implement a new data collection system that can handle 50X more data than the legacy system.”

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
    • 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
    • The lack of business insight from data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Behavior analytics
    • Network performance analyses
    • Predictive analytics
    • Machine/sensor data analysis
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Eclipse BIRT
    • Hadoop
    • Pentaho Kettle
    • Pentaho Mondrian

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
    • Concurrency for hundreds or thousands of users
    • Aggressive compression
    • Native support MapReduce and Hadoop
    • 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
    • A more interactive, conversational view of our data
    • 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)
    • Reduced implementation time for a new analytics warehouse
    • 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.

Case Study: Global 500 Professional Services Company

Introduction

This case study of a Global 500 professional 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.

“With Vertica we are able to understand customer behaviors in near-real time and adapt accordingly.”

Challenges

  • Addressed the following pain points with the HPE Vertica Analytics Platform:
    • The inability to analyze large volumes of data
    • Summarized or aggregated data, losing detail and insights
    • The prohibitive cost of adding capacity due to licensing or hardware
    • The lack of business insight from data
    • The lack of connection between current BI/analytics initiatives and needs of business

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Promotional testing
    • Fraud monitoring/prevention
    • Behavior analytics
    • Clickstream analyses
    • Customer analytics
    • Loyalty analysis
    • Predictive analytics
    • Campaign management
  • Currently managing 1 – 5 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Hadoop
    • Spotfire (TIBCO)

Results

  • Values the following features in HPE Vertica software the most:
    • Massive scalability on industry-standard hardware
    • Simplicity
    • Simultaneous loading and querying
    • Native support MapReduce and Hadoop
    • High availability without hardware redundancy
    • 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
    • A more interactive, conversational view of our data
    • Improved insight into customer behaviors
    • Increased amount and complexity of data analyzed
  • 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.

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.

Case Study: Small Business Computer Software Company

Introduction

This case study of a small business computer software 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 use Vertica as our data warehouse for just about everything. It has allowed us to do better financial reporting, analyze user data to improve user experience and our products, increase revenue and profitability, and build complicated models for predictive analytics.”

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 business insight from data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Promotional testing
    • Financial tracking
    • Behavior analytics
    • Clickstream analyses
    • 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:
    • Hadoop
    • SPSS
    • Tableau

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Standard SQL interface
    • Aggressive compression
    • Database designer and administration tools
    • Ease of interaction with existing BI tools through connectors and ODBC/JDBC
    • Workload management
    • High availability for analytics systems
  • Achieved the following with HPE Vertica software:
    • Faster analysis and reporting
    • Greater business insight
    • A more interactive, conversational view of our data
    • Improved insight into customer behaviors
    • Enhanced profitability
    • Increased amount and complexity of data analyzed
    • Reduced implementation time for a new analytics warehouse
    • 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 $1,000,000 – $5,000,000 in overall cost savings from using HPE Vertica.

Case Study: Small Business Computer Services Company

Introduction

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

“With Vertica we have been able to offer a data warehouse in the cloud. That would not have been possible without the ability to run on commodity hardware and the ease of management.”

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
    • The prohibitive cost of adding capacity due to licensing or hardware
    • The lack of business insight from data
    • The lack of connection between current BI/analytics initiatives and needs of business
    • Existing data warehouse/data management infrastructure that could not handle Big Data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Clinical data analyses
    • Financial tracking
    • Clickstream analyses
    • Customer analytics
  • Currently managing 20 – 40 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • JasperSoft
    • Jaspersoft ETL
    • Pentaho Mondrian
    • Tableau
    • Homegrown

Results

  • Values the following features in HPE Vertica software the most:
    • Massive scalability on industry-standard hardware
    • Simplicity
    • Standard SQL interface
    • Optimizer and execution engine
    • Low total cost of ownership (TCO)
  • Achieved the following with HPE Vertica software:
    • Faster analysis and reporting
    • Greater business insight
    • A more interactive, conversational view of our data
    • Increased amount and complexity of data analyzed
    • A reduction in database infrastructure costs
    • A reduction in storage costs
  • Increased query performance by 500 – 1,000% through improvement in response time with HPE Vertica.
  • Is able to analyze 500 – 1,000% more data at one time with HPE Vertica.
  • Saved $500,000 – $1,000,000 in overall cost savings from using HPE Vertica.

Case Study: Small Business Computer Software Company

Introduction

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

“Vertica’s performance, scalability, ease of use and OEM-friendly pricing allow us to offer an interactive data exploration experience with adhoc filtering, aggregation and drill-down capabilities. This is a highly disruptive feature set in an industry accustomed to periodic high-level reporting.”

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
    • The lack of concurrency limits access to data
    • The lack of business insight from data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Network performance analyses
    • Customer analytics
    • Machine/sensor data analysis
  • Currently managing 500 GB – 1 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Homegrown
    • Custom ETL loader multiple QPID queues. Flash-based UI. Java lib for generating PDF reports

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
    • Database designer and administration tools
    • In-database analytics capabilities – R, C++
    • High availability without hardware redundancy
    • Low total cost of ownership (TCO)
  • Achieved the following with HPE Vertica software:
    • Faster analysis and reporting
    • The ability to load and analyze data concurrently
    • Greater business insight
    • A more interactive, conversational view of our data
    • A reduction in database infrastructure costs
    • A reduction in storage costs
    • Reduced implementation time for a new analytics warehouse
  • Increased query performance by 500 – 1,000% through improvement in response time with HPE Vertica.
  • Is able to analyze > 1,000% more data at one time with HPE Vertica.
  • Saved $100,000 – $500,000 in overall cost savings from using HPE Vertica.

Case Study: Medium Enterprise Health Care Company

Introduction

This case study of a medium enterprise health care 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 replaced DB2 with Vertica for reporting and achieved 800X improvement and more. Data Analysis improved more than 1000%. We were able to attract new customers leading to increased revenue.”

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
    • The lack of concurrency limits access to data
    • The prohibitive cost of adding capacity due to licensing or hardware
    • Performance limits with current system

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Claims analyses
    • Patient records analyses
    • Clinical data analyses
    • Fraud monitoring/prevention
    • Behavior analytics
  • Currently managing 40 – 80 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Ab Initio
    • Cognos 8 BI
    • IBM Data Stage
    • SAS

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Massive scalability on industry-standard hardware
    • Simplicity
    • Aggressive compression
    • Database designer and administration tools
    • In-database analytics capabilities – R, C++
    • 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
    • Increased amount and complexity of data analyzed
    • A reduction in database infrastructure costs
    • A reduction in storage costs
    • Ease of adding additional database capacity
    • High availability for analytics systems
  • Increased query performance by > 1,000% through improvement in response time with HPE Vertica.
  • Is able to analyze > 1,000% more data at one time with HPE Vertica.
  • Saved $1,000,000 – $5,000,000 in overall cost savings from using HPE Vertica.

Case Study: Small Business Telecommunications Services Company

Introduction

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

“Vertica has given us the ability to query larger amounts of data in a shorter time frame. We are able to query months and years worth of data in sub-minute time rather than the hours it used to take to query a days worth of 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
    • Summarized or aggregated data, losing detail and insights
    • The lack of business insight from data
    • 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
    • Compliance testing
  • Currently managing 1 – 5 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • JasperSoft
    • Oracle

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Massive scalability on industry-standard hardware
    • Simplicity
    • Simultaneous loading and querying
    • Aggressive compression
    • Ease of interaction with existing BI tools through connectors and ODBC/JDBC
    • High availability without hardware redundancy
    • Optimizer and execution engine
    • 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
    • A more interactive, conversational view of our data
    • Increased amount and complexity of data analyzed
    • High availability for analytics systems
  • Increased query performance by 500 – 1,000% through improvement in response time with HPE Vertica.
  • Is able to analyze greater than 1,000% more data at one time with HPE Vertica.
  • Saved up to $100,000 in overall cost savings from using HPE Vertica.

Case Study: Medium Enterprise Computer Software Company

Introduction

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

“Vertica is the best data-warehouse product.”

Challenges

  • Addressed the following pain points with the HPE Vertica Analytics Platform:
    • Too many required resources (memory especially)

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Clickstream analyses
    • Customer analytics
    • Machine/sensor data analysis
    • Web access info. by Smart Device in Tel. Corp.
  • Currently managing 20 – 40 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Hadoop

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Standard SQL interface
    • Simultaneous loading and querying
    • Aggressive compression
    • Workload management
    • Low total cost of ownership (TCO)
  • Achieved the following with HPE Vertica software:
    • Faster analysis and reporting
  • 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.

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.