Actian Beats Snowflake and BigQuery in GigaOm TPC-H Benchmark Test
July 19, 2023
Driven by the desire for organizations to get better business insights, data systems are becoming more specialized, and data stacks are increasing in complexity. As companies continue their quest toward data-driven operations, they must balance speed and cost. This is why we recently engaged with GigaOm Research to conduct a TPC-H Benchmark Test against Snowflake and BigQuery – the results were clear, the Actian cloud data platform offers superior performance at a fraction of the cost of these competitors.
Actian’s operational data warehouse is designed to support real-time data analytics so customers can maintain a competitive advantage. The TPC-H benchmark consists of a series of ad-hoc analytical queries that involve complex joins, aggregations, and sorting operations. These queries represent common decision support tasks to generate sales reports, analyze trends, and perform advanced data analytics. In today’s rapidly changing business climate, there is no room for delays when it comes to accessing data to support business decisions.
Our data analytics engine ensures that the warehouse capability in the Actian platform delivers on the promise of performance without runaway costs. The GigaOm field test, informed by TPC-H spec validation queries, highlights the price and performance ratio and cost-effectiveness of the Actian platform, providing independent validation of the Actian data platform in terms of both performance and cost.
In the GigaOm benchmark, the Actian Data Platform outperformed both Snowflake and BigQuery in 20 of the 22 queries, clearly illustrating Actian’s powerful decision support capabilities. Leveraging decades of data management experience, the Actian platform provides data warehouse technology that uses in-memory computing along with optimized data storage, vector processing, and query execution that exploits powerful CPU features. These capabilities significantly improve the speed and efficiency of real-time analytics.
The benchmark results reveal query execution and price efficiencies that outperform competitor solutions, lowering the total cost of ownership without sacrificing speed. Overall, the Actian platform delivered query results that were 3x faster than Snowflake and 9x faster than BigQuery. Performance improved with additional users, highlighting the platform’s ability to scale with concurrency to meet the demands of all business users.
In terms of cost, the GigaOm field tests further prove the value of the Actian data platform over the competition. Snowflake’s costs were nearly 4x higher than Actian’s, and BigQuery ranged from 11x to 16x more expensive based on concurrency.
Subscribe to the Actian Blog
Subscribe to Actian’s blog to get data insights delivered right to you.
- Stay in the know – Get the latest in data analytics pushed directly to your inbox
- Never miss a post – You’ll receive automatic email updates to let you know when new posts are live
- It’s all up to you – Change your delivery preferences to suit your needs