Accure’s Momentum Data Warehousing and OLAP Solution Outperforms Google BigQuery by 3x

Momentum outperformed BigQuery by 3x on an average in all queries executed on both the platforms against the same dataset. For the same query performance, Momentum runs on a cluster that costs 10% of BigQuery.

Reston, Virginia Aug 20, 2021 (Issuewire.com)  - Accure announces the release of benchmarking results of its data warehousing and OLAP solution. A comprehensive benchmarking of the Momentum data warehouse was performed and compared against the price-performance of Google BigQuery (GBQ). Momentum outperformed GBQ by 3x on an average in all queries executed on both the platforms against the Star Schema Benchmark (SSB) dataset. For the same query performance, Momentum runs on a cluster that costs 10% of GBQ.


Benchmark Summary:

Data size: 100GB

Method: Star Schema Benchmark (SSB), which is a dataset and query set designed to evaluate the performance of data warehouses since 2007

Average query performance: 6.5 seconds on Momentum and 20 seconds on BigQuery

Price-performance: Momentum infrastructure costs 10% of BigQuery

Accure followed the Star Schema Benchmarks (SSB) method, which is a set of large normalized tables and queries designed to evaluate the performance of data warehousing systems since 2007. The datasets -- consisting of 6 million line orders, 30,000 customers, 2000 suppliers, 200,000 parts, and 2,556 dates -- were created using an open-source tool. The data were ingested using Momentum’s ETL toolset, converted into parquet format, and loaded into the data warehouse. The data was manually copied over to the Google Cloud Storage bucket and loaded into tables in BigQuery. 

Five sets of 13 queries, as suggested in the SSB paper, were executed both on Momentum and BigQuery, and their response times were collected and aggregated to compare the results.

In all cases, Momentum returned the results faster than BigQuery. On average, Momentum performed 3 times faster than BigQuery.

In addition to query result time, Accure also conducted a price-performance comparison. The momentum cluster was installed on AWS virtual machines (EC2). For comparing the cost, Accure is considered the most cost-effective pricing option that BigQuery offers, which is $1,700 per month for a committed usage of 100 slots of BigQuery. To estimate  Momentum’s cluster cost on AWS, the 3 years EC2 committed price was considered. The same set of 13 queries were executed to determine the slot times and number of slots of BigQuery. It was observed that for a concurrency level of 64, the cost of BigQuery is $85,000 per month compared to just $9,400 per month of Momentum cluster cost, which is just about 10% of BigQuery cost. On average Momentum is found to be at least 90% cost-effective compared to BigQuery.

 

“We strive to bring disruptive technologies not only to make our customers efficient but also to save them tonnes of money”, says Sam Ansari, CEO of Accure. “A blazing fast, cutting edge and low-cost technology help everyone in the ecosystem, including our implementation partners, system integrators, resellers, and particularly our end customers''. 

 

Moghisuddin Raza, COO of Accure states, “Start small and scale big. Run-on a single machine, or on a cluster involving 100s and 1000s of nodes. Run locally in your own data center or deploy on any cloud-based environment. We provide multiple options and for everyone of all sizes.”

 

Visit Accure’s website at https://accure.ai to grab a copy of the detailed report of this benchmarking exercise. Accure also offers a sandbox environment to test out and play with its Momentum data warehousing solution. You could sign up for a free account by visiting https://one.accure.ai:8444. To address any question, send them an email at info@accure.ai.

free

Media Contact

Accure, Inc. momentum@accure.ai 540-923-2747 https://accure.ai
Categories : Computers , Software
Tags : data warehousing , OLAP

Accure, Inc.

Accure provides software platforms for data engineers, scientists, analysts, and automation engineers to efficiently solve machine learning problems and automate business processes.
momentum@accure.ai
Virginia, Reston
20190
540-923-2747
https://accure.ai
Report Spam