Case Study: QuerySurge achieves scalable, pinpoint data warehouse testing with MySQL

QuerySurge Automated Data Warehouse Testing

RTTS, a long-standing provider of software quality and testing solutions, created QuerySurge to address a widespread problem: organizations relying on data-warehouse–driven decisions couldn’t trust their data because ETL processes introduce and propagate errors. Manual SQL checks are slow, costly, and typically cover less than 1% of data, leaving companies exposed to costly data-quality issues.

QuerySurge automates end-to-end data warehouse and ETL testing by extracting source and target data into its own MySQL-backed database for fast, ACID-compliant comparisons (down to a single character). Using MySQL’s performance, reliability, pluggable storage engines (InnoDB and Archive for ~90% compression), and strong vendor backing, QuerySurge runs up to 100× faster than manual testing, can cover up to 100% of data without impacting warehouse performance, reduces hardware needs, and has delivered dependable results that RTTS continues to rely on.

QuerySurge

Jeff Bocarsly

Architect