Amazon SimpleDB vs Google BigQuery

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.

Read full review

Miguel Angel Merino Vega

Analista de Sistemas

Consultor independiente de softwareComputer Software, 1-10 employees

View all 1 answers on this topic

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.

Read full review

Verified User

Analyst in Information Technology

Internet Company, 11-50 employees

View all 10 answers on this topic

Feature Rating Comparison

Amazon SimpleDB

—

Google BigQuery

7.6

Automatic software patching

—

10.0

Database scalability

—

7.4

Automated backups

—

7.8

Database security provisions

—

8.2

Monitoring and metrics

—

5.5

Automatic host deployment

—

6.9

Pros

Flexibility
Easy to learn and use
AWS integration

Read full review

Miguel Angel Merino Vega

Analista de Sistemas

Consultor independiente de softwareComputer Software, 1-10 employees

View all 1 answers on this topic

Big Query is fast and based on the cloud you can run your query on a huge dataset. Huge means data in TB's. This also reduces the company cost to build that kind of infrastructure to store data.
Not specific to Google Analytics but you can import data from different sources for analysis purpose and use the power of the cloud to run the query.
Not much time to learn - You don't need any special skills, just SQL and you can use Big Query for your use. Learning SQL is not a big task you can learn it in a week.
Big Query refrence schema and different sample query are available to practice on queries.
Google also provide sample dataset to use then purchase Big Query.

Read full review

Verified User

Analyst in Information Technology

Internet Company, 11-50 employees

View all 10 answers on this topic

Cons

Non AWS environments
Strict storage limit (but well we have DynamoDB for storage issues)

Read full review

Miguel Angel Merino Vega

Analista de Sistemas

Consultor independiente de softwareComputer Software, 1-10 employees

View all 1 answers on this topic

Though it is SQL some syntax are different but they are getting used to after you use for some time.
The legacy SQL is in beta state but can be used and you can run the query with simple SQL.
More documentation is needed for using User-defined functions in Big Query.

Read full review

Verified User

Analyst in Information Technology

Internet Company, 11-50 employees

View all 10 answers on this topic

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.

Read full review

Miguel Angel Merino Vega

Analista de Sistemas

Consultor independiente de softwareComputer Software, 1-10 employees

View all 1 answers on this topic

Comparing to competitors, Google BigQuery has the lowest cost and most flexible pricing model. Definitely higher ROI.

Read full review

Charles Chao

Sr. Data Engineer

BlueCavaComputer Software, 11-50 employees

View all 10 answers on this topic