Menu

Case Study: Real Time Medical Data

Introduction

This case study of Real Time Medical Data is based on a February 2013 survey of HP Vertica customers by TechValidate, a 3rd-party research service.

“By replacing our current SQL Server database with Vertica, we have achieved 50X – 1000X improvement in query speed with one-tenth the storage space. The company is now better positioned for growth because we can handle more data, more types of queries and more concurrent users, and can scale inexpensively when needed.”

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 analyses
    • Clinical data analyses
  • 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
    • Standard SQL interface
    • Aggressive compression
    • Low total cost of ownership (TCO)
    • High availability for analytics systems
  • Achieved the following with HPE Vertica software:
    • Faster analysis and reporting
    • Greater business insight
    • Greater financial insight
    • Enhanced profitability
    • Increased amount and complexity of data analyzed
    • A reduction in database infrastructure costs
    • A reduction in storage costs
    • 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 500 – 1,000% more data at one time with HPE Vertica.
  • Saved $100,000 – $500,000 in overall cost savings from using HPE Vertica.




About This Data

This data was sourced directly from verified users of Micro Focus 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 Micro Focus Vertica