Collection of Vertica User Case Studies- Part 2

Check out the mini-cases studies of how Vertica users are using the big data analytics solution

Case Study: Medium Enterprise Computer Software Company

Introduction

This case study of a medium enterprise computer software company is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

Case Study: Small Business Computer Services Company

Introduction

This case study of a small business computer services company is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

Case Study: Small Business Automotive & Transport Company

Introduction

This case study of a small business automotive & transport company is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“Vertica allows us to load millions of events daily in seconds, merging it with billions of existing records in a perfectly optimized fashion. We are also able to reduce runtime on our aggregation and other business intelligence solutions down to seconds from hours.

I cannot imagine how we would function if we were forced to move back to an older transactional database technology."

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

The need to stop queries while loading new data

Use Case

Is implementing the following applications with HPE Vertica:

Clickstream analysis

Network performance analysis

Predictive analytics

Currently managing 5 – 10 TB of data with HPE Vertica software.

Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:

Hadoop

MicroStrategy

Purchased HPE Vertica over the following vendors:

Microsoft

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

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)

Increased query performance by > 1,000% through improvement in response time with HPE Vertica.

Case Study: Global 500 Computer Hardware Company

Introduction

This case study of a Global 500 computer hardware company is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

Case Study: Small Business Financial Services Company

Introduction

This case study of a small business financial services company is based on a January 2014 survey of HP Software 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 collect valuable insights through relevant user behavior data that helped us fine tune the user experience in our gaming product. This significantly increased the time our users spent on our product.”

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

The lack of connection between current BI/analytics initiatives and needs of business

Case Study: Global 500 Telecommunications Services Company

Introduction

This case study of a Global 500 telecommunications services company is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“We have been a Vertica customer since 2008. At that time, it cost us less money to purchase Vertica and develop a new system vs a quoted cost from our software vendor. Good thing, as business requirements changed, we no longer have need for the system we developed, but still have Vertica. Further, due to the great query performance, business analysts saw new opportunities in our data. We developed an add on ot, an existing system and reaped new benefits. Vertica allowed us to be agile.”

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

Case Study: Real Time Medicare Data

Introduction

“We were able to reduce report run time and query time significantly, reduce infrastructure cost, and simplify data management using Vertica. These reductions have allowed us to remain lean and efficient in our IT department and to provide greater value to our customers.”

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

Use Case

Is implementing the following applications with HPE Vertica:

Claims analysis

Patient records analysis

Clinical data analysis

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 SQL Server Reporting Services

Tableau

Purchased HPE Vertica over the following vendors:

Microsoft

Oracle

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

Aggressive compression

Flexibility

Low total cost of ownership (TCO)

Increased query performance by 500 – 1,000% through improvement in response 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 January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

Case Study: Snag A Job, Inc.

Introduction

“We were looking for a database backend to allow end users (a couple of thousand external users) to crunch through their detailed data in real time. The dataset is several hundred million rows and our avg. response time goal was less than 5 secs. Last but not least we are building this environment for the future, i.e. another requirement was to be able to scale horizontally). Redshift came close in response time but completed failed in concurrency, i.e. multiple users running an analysis at the same time. Infobright came close in response time and concurrency but didn’t provide sufficient scalability. Vertica checked all boxes at a very competitive price-point.”

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

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

Case Study: Medium Enterprise Computer Services Company

Introduction

This case study of a medium enterprise computer services company is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“Moving from MySQL to Vertica for our Analytics Database, which is a subset of data we store in our Hadoop-based Data Warehouse for real-time analytics, allowed us to make better use of hardware, drastically improved our query performance, and achieve better availability and scalability. We had reached the limits of MySQL, even with heavy partitioning the indexes were occupying more space than data and we were limited by the performance of a single host machine. Vertica’s “indexless” layout, horizontal scaling, and perfect use of parallel compute resources took us to the next level on our Real-Time Analytics Platform."

Challenges

Addressed the following pain points with the HPE Vertica Analytics Platform:

Slow or incomplete queries

Performance limits with current system

Use Case

Is implementing the following applications with HPE Vertica:

Behavior analytics

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

Pentaho Kettle

Tableau

Homegrown

Purchased HPE Vertica over the following vendors:

MySQL

Results

Values the following features in HPE Vertica software the most:

Extreme speed and performance

Massive scalability on industry-standard hardware

Simplicity

Aggressive compression

High availability without hardware redundancy

Flexibility

High availability for analytics systems

Increased query performance by > 1,000% through improvement in response time with HPE Vertica.

Can compress their data by 25-40% with HPE Vertica.

Company Profile

The company featured in this case study asked to have its name publicly blinded because publicly endorsing vendors is against their policies.

TechValidate stands behind the authenticity of this data.

Company Size:Medium Enterprise

Industry:Computer Services

About HPE Software Vertica

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

Case Study: Medium Enterprise Telecommunications Services Company

Introduction

This case study of a medium enterprise telecommunications services company is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

Case Study: Small Business Computer Software Company

Introduction

This case study of a small business computer software company is based on a February 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“We need to quickly access logs from disparate security devices, usually across multiple customers. These are accessed via a real-time portal, so response time is critical. Vertica has been able to achieve these goals, where previously a real-time portal was not viable in production.”

Challenges

Addressed the following pain points with the HPE Vertica Analytics Platform:

Slow or incomplete queries

Performance limits with current system

Use Case

Is implementing the following applications with HPE Vertica:

Cyber security monitoring/prevention

Currently managing 1 – 5 TB of data with HPE Vertica software.

Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:

Homegrown

Proprietary Report tools built in Crystal and HighCharts

Purchased HPE Vertica over the following vendors:

EMC Greenplum

Hadoop

Oracle

Oracle Exadata

Results

Values the following features in HPE Vertica software the most:

Extreme speed and performance

Standard SQL interface

Ease of interaction with existing BI tools through connectors and ODBC/JDBC

Increased query performance by 100 – 500% through improvement in response time with HPE Vertica.

Can compress their data by > 50% with HPE Vertica.

Company Profile

The company featured in this case study asked to have its name publicly blinded because publicly endorsing vendors is against their policies.

TechValidate stands behind the authenticity of this data.

Company Size:Small Business

Industry:Computer Software

About HPE Software Vertica

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

Case Study: Medium Enterprise Health Care Company

Introduction

This case study of a medium enterprise health care company is based on a February 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“With Vertica especially with read-only data we gained over 1000% performance improvement with significantly less capital cost/investment. We are only able to run 100s of reports where before we were able to run only 2 reports. This made us gain a lot of customers with very little maintenance from the admins.”

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

The lack of business insight from data

Use Case

Is implementing the following applications with HPE Vertica:

Claims analysis

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:

Ab Initio

Cognos 8 BI

Purchased HPE Vertica over the following vendors:

IBM DB2

Results

Values the following features in HPE Vertica software the most:

Extreme speed and performance

Increased query performance by > 1,000% through improvement in response time with HPE Vertica.

Case Study: Medium Enterprise Computer Services Company

Introduction

“Our Merchants’ reports are now powered by Vertica which increases their satisfaction because they are able to access their information much more quickly and have many different ways of visualizing that data. We also constantly mine our data internally to provide business insights and patterns to both existing and prospective Merchants.”

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

The lack of business insight from data

The lack of connection between current BI/analytics initiatives and needs of business

Case Study: Large Enterprise Insurance Company

Introduction

This case study of a large enterprise insurance company is based on a February 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.