Challenge: Their existing data warehouse/data management infrastructure could not handle performance at scale. Choice Hotels was experiencing slow/incomplete queries, inability to analyze large volumes of data, lack of concurrency limits to access data and lack of connection between current BI/analytics initiatives and needs of business.

Result: Values the following features in  Vertica software the most:

  • Extreme speed and performance
  • Massive scalability on industry-standard hardware
  • Simplicity
  • Simultaneous loading and querying
  • Concurrency for hundreds or thousands of users
  • 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
  • Low total cost of ownership (TCO)
  • High availability for analytics systems

Achieved the following with 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 50 – 100% through improvement in response time with Vertica.
  • Is able to analyze 100 – 500% more data at one time with Vertica.

Read the Case Study

Vertica is fast, consumes a small footprint, and can load anything.

  • - Venkatesh Kamat, Senior Data Analyst, Choice Hotels