Competitors price comparison - 1 Billion Taxi Rides


For this comparison we will be using the well-known 1.1 Billion Taxi Rides dataset, that includes rides made in New York City between 2009 and 2015 and that is available on this Github repository.

Below is a graph showing the costs for each service. (less is better)

...
...

SlicingDice

Pricing Model: Pay-per-gigabyte
$ 125.00 per month — Total monthly cost to store the dataset, equivalent to 500 GB of data.

Pricing Model: Pay-per-column
$ 144.00 per month — Total monthly cost to store the dataset, using 48 event columns.

Details: including built-in high availability and backup. Making unlimited number of queries and expecting them to complete always under 10 seconds.


AWS Redshift

$ 612,00 per month — Total monthly cost to store the 1.1 Billion Taxi Rides dataset on Redshift, making unlimited number of queries and expecting them to complete between few seconds up to 2 minutes, without any backup or high availability.

Details: 1 ds2.xlarge on-demand instance running for 720 hours (30 days). This cost above does not include any network transfer or storage (S3) cost.

...

...

Google BigQuery

$ 12,60 + $ 0.07 x # of queries = $ 12,60 + Unpredictable per month — Total monthly cost to store the 1.1 Billion Taxi Rides dataset on BigQuery, making unknown volume of queries per day and expecting them to complete within seconds, with built-in high availability.

Details: Data is stored uncompressed on BigQuery and takes up about 500 GB of space, so the storage cost will be around $0.42 per day. BigQuery also charges for each query, what could translate to $0.07 for each query run. So that is $12,6 for storage and $0.07 for each query. Considering 500 queries per day would end up being $1,050.00 per month.


Snowflake

$ 1,460,00 per month — Total monthly cost to store the 1.1 Billion Taxi Rides dataset on Snowflake, making unlimited number of queries and expecting them to complete between few seconds up to few minutes, without any backup or high availability.

Details: 500 GB storage x $ 40.00 per Terabyte + 720 hours x $ 2.00, that is equivalent to the standard on-demand instance running for 720 hours (30 days). This cost above does not include any network transfer.

...

...

ElasticSearch Cloud

$1,999.00 per month — Total monthly cost to store the 1.1 Billion Taxi Rides dataset on ElasticSearch, making unlimited number of queries and expecting them to complete between 10 seconds up to few minutes, with high availability on 3 different DCs (same as SlicingDice).

Details: As this dataset takes around 700 GB of disk space on ElasticSearh, we dimensioned a 32 GB memory and 768 GB reserved storage cluster on ElasticSearch Cloud US East (N. Virginia) with 3 data centers HA.

Do you want to receive a custom quote?

Check also the Features Comparison

Check how SlicingDice's features compares to other solutions like Amazon Redshift, Google BigQuery, ElasticSearch Cloud and Keen IO.


...

Ready to get started?

Get in touch, or create an account.