Symphony Advanced Media offers solutions and services in advertising strategy, advertising performance, and consumer and shopper insights.

Challenge: To identify and invest in a modern analytics database for several use cases

Results: The following were Vertica benefits:

  • Massive scalability on industry-standard hardware
  • Simultaneous loading and querying
  • Concurrency for hundreds or thousands of users
  • Superior compression
  • In-database analytics capabilities
  • Ease of interaction with existing BI tools & ETL tools
  • High availability without hardware redundancy
  • Advanced analytics: predictive, geospatial, sentiment, etc.
  • Reduced TCO by 1-25% with Vertica
  • Improved query performance by 51 – 100% with Vertica

I would personally recommend Vertica for the application which has a fixed set of report generation which rarely changes because the projections we design is query specific and having multiple projections for the same table can prove expensive in terms of storage and data loading.

  • - Harman Support, DBA Engineer, Symphony Advanced Media