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.

“We needed to model our clickstream data in real time, and with HPE Vertica we’re able to do this. This significantly increased our ability to promote the appropriate content to our users.”

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
    • The need to stop queries while loading new data
    • 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:
    • Promotional testing
    • Clinical data analysis
    • Fraud monitoring/prevention
    • Financial tracking
    • Behavior analytics
    • Clickstream analysis
    • Network performance analysis
    • Customer analytics
    • Predictive analytics
    • Campaign management
  • Currently managing 10 – 20 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
  • Purchased HPE Vertica over the following vendors:
    • Hadoop
    • Home grown solution

Results

  • Values the following features in HPE Vertica software the most:
    • Massive scalability on industry-standard hardware
    • Simplicity
    • Standard SQL interface
    • Simultaneous loading and querying
    • Aggressive compression
    • Flexibility
    • High availability for analytics systems
  • Increased query performance by 10 – 50% through improvement in response time with HPE Vertica.
  • Can compress their data by > 50% with HPE Vertica.
  • Saved $100,000 – $500,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 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 able to use the same data in many ways in Vertica without the traditional ramp-up time of building a Data Warehouse system and the related schema loading and maintenance work.”

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
    • 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
    • Behavior analytics
    • Cyber security monitoring/prevention
    • Predictive analytics
    • Machine/sensor 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:
    • Pentaho Kettle
  • Purchased HPE Vertica over the following vendors:
    • EMC Greenplum
    • Hadoop
    • Infobright
    • Oracle
    • Home grown solution

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++
    • Ease of interaction with existing BI tools through connectors and ODBC/JDBC
    • High availability without hardware redundancy
  • Increased query performance by > 1,000% through improvement in response time with HPE Vertica.
  • Can compress their data by > 50% with HPE Vertica.
  • Saved $100,000 – $500,000 in overall cost savings from using HPE Vertica.

Case Study: Retail Solutions

Introduction

This case study of Retail Solutions is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service.

“With Vertica, cost of software license of SQLserver 2012 is & will be considerably reduced 20 times. We are also able to scale from 100GB of data size analytics to 1TB data size analytics.”

Challenges

  • Addressed the following pain points with the HPE Vertica Analytics Platform:
    • 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:
    • Promotional testing
    • Loyalty 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:
    • Microsoft SqlServer Analysis Service
  • Purchased HPE Vertica over the following vendors:
    • Microsoft

Results

  • Values the following features in HPE Vertica software the most:
    • Massive scalability on industry-standard hardware
    • Simultaneous loading and querying
    • Aggressive compression
    • Low total cost of ownership (TCO)
  • Increased query performance by 10 – 50% through improvement in response time with HPE Vertica.
  • Can compress their data by > 50% with HPE Vertica.

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.
  • Can compress their data by > 50% with HPE Vertica.
  • Saved $100,000 – $500,000 in overall cost savings from using 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.

“With Vertica we have setup a query performance requirement that any query fired on the database should have response timings of less than 1 Second. And we achieved it.”

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 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:
    • Customer 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:
    • Home grown ETL and Reporting tools
  • Purchased HPE Vertica over the following vendors:
    • Oracle
    • Teradata

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Simplicity
    • Aggressive compression
    • Database designer and administration tools
    • High availability without hardware redundancy
    • Optimizer and execution engine
    • High availability for analytics systems
  • Increased query performance by 100 – 500% through improvement in response time with HPE Vertica.
  • Can compress their data by > 50% with HPE Vertica.

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

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Promotional testing
    • Clinical data analysis
    • Financial tracking
    • Behavior analytics
    • Customer analytics
    • Loyalty analysis
    • Predictive analytics
    • Campaign management
  • 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
    • Oracle
    • Oracle Data Integrator
    • Oracle GoldenGate
    • Oracle Warehouse Builder
    • Pentaho Kettle
    • Pentaho Mondrian
  • Purchased HPE Vertica over the following vendors:
    • EMC Greenplum
    • Exasol
    • Hadoop
    • Infobright
    • MongoDB
    • Oracle Exadata

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Massive scalability on industry-standard hardware
    • Flexibility
    • Low total cost of ownership (TCO)
  • Can compress their data by 25-40% with HPE Vertica.
  • Saved $1,000,000 – $5,000,000 in overall cost savings from using HPE Vertica.

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

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Financial tracking
    • Behavior analytics
    • Customer analytics
  • 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
  • Purchased HPE Vertica over the following vendors:
    • Oracle
    • Home grown solution
    • Vertica basically has been our solution since 2008

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Simplicity
    • Standard SQL interface
    • 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
  • Increased query performance by > 1,000% through improvement in response time with HPE Vertica.
  • Can compress their data by > 50% with HPE Vertica.
  • Saved $1,000,000 – $5,000,000 in overall cost savings from using HPE Vertica.

Case Study: Real Time Medicare Data

Introduction

This case study of RealTime Medicare Data is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service.

“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.
  • Can compress their data by > 50% with HPE Vertica.
  • Saved $100,000 – $500,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 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 handle millions of records per day – both for loading and processing and also for fast analyzing.”

Challenges

  • Addressed the following pain points with the HPE Vertica Analytics Platform:
    • 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
    • The lack of connection between current BI/analytics initiatives and needs of business

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Claims analysis
    • Behavior analytics
    • Network performance analysis
    • Customer analytics
    • Machine/sensor data analysis
  • Currently managing 20 – 40 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Oracle
  • Purchased HPE Vertica over the following vendors:
    • Oracle
    • SybaseIQ

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Standard SQL interface
    • High availability for analytics systems
  • Increased query performance by 100 – 500% through improvement in response time with HPE Vertica.
  • Can compress their data by > 50% with HPE Vertica.
  • Saved $0 – $100,000 in overall cost savings from using HPE Vertica.

Case Study: Snag A Job, Inc.

Introduction

This case study of SnagAJob.com, Inc. is based on a January 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service.

“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
    • Existing data warehouse/data management infrastructure that could not handle Big Data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Clickstream analysis
    • Predictive analytics
  • 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
    • Tableau
    • Birst
  • Purchased HPE Vertica over the following vendors:
    • Amazon Redshift
    • Infobright
    • 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
    • Database designer and administration tools
    • High availability without hardware redundancy
    • Optimizer and execution engine
    • Flexibility
    • High availability for analytics systems
  • Increased query performance by 500 – 1,000% through improvement in response time with HPE Vertica.
  • Can compress their data by > 50% with HPE Vertica.

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.

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.

“Vertica is a powerful, easy and stable solution.”

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
    • Performance limits with current system

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Promotional testing
    • Financial tracking
    • Network performance analysis
    • Customer analytics
    • Machine/sensor data analysis
  • Currently managing 20 – 40 TB of data with HPE Vertica software.
  • Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
    • Business Objects Crystal Reports
    • Informatica – Data Replicator
    • MicroStrategy
    • Oracle GoldenGate
    • Tableau
    • Talend Open Studio
  • Purchased HPE Vertica over the following vendors:
    • EMC Greenplum
    • IBM Neteeza
    • SybaseIQ

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Massive scalability on industry-standard hardware
    • Simplicity
    • High availability without hardware redundancy
    • Flexibility
    • Low total cost of ownership (TCO)
    • High availability for analytics systems
  • Increased query performance by 50 – 100% through improvement in response time with HPE Vertica.
  • Can compress their data by 10-25% with HPE Vertica.
  • Saved $1,000,000 – $5,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 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.

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.
  • Can compress their data by > 50% with HPE Vertica.
  • Saved $5,000,000 – $10,000,000 in overall cost savings from using HPE Vertica.

Case Study: Medium Enterprise Computer Services Company

Introduction

This case study of CCBill.com is based on a February 2014 survey of HP Software Vertica customers by TechValidate, a 3rd-party research service.

“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
    • Existing data warehouse/data management infrastructure that could not handle Big Data

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Promotional testing
    • Financial tracking
    • Behavior analytics
    • Clickstream analysis
    • Customer analytics
    • Loyalty analysis
    • 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:
    • Pentaho Kettle
    • Homegrown
    • Based on Grails, HighCharts, and jQuery
  • Purchased HPE Vertica over the following vendors:
    • IBM Neteeza
    • Infobright
    • MySQL
    • Oracle Exadata
    • Home grown solution

Results

  • Values the following features in HPE Vertica software the most:
    • Extreme speed and performance
    • Massive scalability on industry-standard hardware
    • Concurrency for hundreds or thousands of users
    • Ease of interaction with existing BI tools through connectors and ODBC/JDBC
    • High availability for analytics systems
  • Increased query performance by > 1,000% through improvement in response time with HPE Vertica.
  • Can compress their data by > 50% with HPE Vertica.

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.

“Using Vertica created a force-multiplier for our BI and DBA teams. We can focus on delivery of features instead of tuning and scaling the database.”

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

Use Case

  • Is implementing the following applications with HPE Vertica:
    • Claims analysis
    • Clickstream analysis
    • Customer analytics
    • Predictive 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:
    • Hadoop
    • MicroStrategy
    • Oracle Data Integrator
    • Oracle GoldenGate
    • SAS
  • Purchased HPE Vertica over the following vendors:
    • Amazon Redshift
    • EMC Greenplum
    • Oracle Exadata
    • ParAccel

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
    • Database designer and administration tools
    • Ease of interaction with existing BI tools through connectors and ODBC/JDBC
    • Low total cost of ownership (TCO)
  • Increased query performance by 500 – 1,000% through improvement in response time with HPE Vertica.
  • Can compress their data by 10-25% with HPE Vertica.
  • Saved $1,000,000 – $5,000,000 in overall cost savings from using HPE Vertica.