What users are saying about
1 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 9 out of 101
69 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.6 out of 101

Add comparison

Likelihood to Recommend

Amazon SimpleDB

Well suited for: Games, Chat rooms, real time software like corporate events, marathons and so. Anytime and anywhere you could use a NoSQL DB you should think of SimpleDB.
As an arduous AWS user, Amazon SimpleDB easily integrates with EC2 and other AWS module; and if you are not an AWS user, you also have a fantastic tool that will solve the problem for which you are focused.
Miguel Angel Merino Vega profile photo

Google BigQuery

- If you are using Google Analytics and there is huge data that is getting streamed every day then you must have Big Query and use it for analysis. It is not only helpful for analysis but also for debugging your Google Analytics implementations.- For analyzing a small dataset you don't need Big Query you can use normal MySQL on your own premises. Analyzing on Un-structured data is not possible with Big Query.
No photo available

Feature Rating Comparison

Database-as-a-Service

Amazon SimpleDB
Google BigQuery
7.7
Automatic software patching
Amazon SimpleDB
Google BigQuery
10.0
Database scalability
Amazon SimpleDB
Google BigQuery
7.5
Automated backups
Amazon SimpleDB
Google BigQuery
7.6
Database security provisions
Amazon SimpleDB
Google BigQuery
9.1
Monitoring and metrics
Amazon SimpleDB
Google BigQuery
5.3
Automatic host deployment
Amazon SimpleDB
Google BigQuery
6.5

Pros

  • Flexibility
  • Easy to learn and use
  • AWS integration
Miguel Angel Merino Vega profile photo
  • BigQuery is a highly optimized, columnar oriented database, and as such it exceeds when doing complex aggregations over massive datasets, i.e. computing n-tiles, statistics, sorting, etc.
  • BigQuery is seamlessly integrated with the rest of the Google Cloud Platform stack, and as such it is extremely easy to move data in and out of BigQuery for analysis and storage. However, it also exposes very well defined APIs for inserting and streaming data in, and as such can be used easily with other on-premeses or cloud solutions.
  • Because BigQuery is fully managed, there is no need to think about provisioning machines, optimizing memory/cores, 'vacuuming', etc. This increases the 'democratization' effect BigQuery can have, as a basic knowledge of SQL is all that is needed to get started.
Alex Andrews profile photo

Cons

  • Non AWS environments
  • Strict storage limit (but well we have DynamoDB for storage issues)
Miguel Angel Merino Vega profile photo
  • SQL syntax is not exactly same as ANSI SQL so there is a learning curve. Traditional SQL queries cannot execute in BigQuery which limits portabiltiy of the code.
  • Limitation on visualization: We can improve visualization in data studio by bringing in the ability to support complex functions/formulas such as Tableau can do.
Gaurav Gautam profile photo

Alternatives Considered

It integrates beautifully with AWS. In some projects we use SimpleDB while we use DynamoDB for others, according to the characteristics of the project. If the infrastructure is AWS, we always think of one of them.
Miguel Angel Merino Vega profile photo
We liked BQ because the cost of it is only dependent on the amount of data you store (and there are tiers of data access) and how much you search. For us, it is significantly less expensive to run BQ than an equivalent hosted RDBMS. Because most of our data pipelines are automated, and, we only need to do ad-hoc queries irregularly, BQ fit our criteria very well.
Anatoly Geyfman profile photo

Return on Investment

  • Reduced database administration time
  • Reduced data model analysis time
  • Lower cost of resources in projects in general
Miguel Angel Merino Vega profile photo
  • We were able to reduce our investment in self-hosted Postgres and move our bigger data assets to BigQuery. Overall, we saved hundreds per month, thousands per year.
  • We are able to search through very large datasets with BQ that were difficult to search with standard Postgres, even on very large servers. This gave us the ability to do ad-hoc data introspection easily.
  • Because we already used Google Storage, it was easy to integrate BQ into our environment.
Anatoly Geyfman profile photo

Pricing Details

Amazon SimpleDB

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Google BigQuery

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details