BigQuery和BigTable有什么区别？ [英] What's the difference between BigQuery and BigTable?

问题描述

有人出于某种原因会使用BigTable而不是BigQuery吗？两者似乎都支持读取和写入操作，而后者提供了高级的查询操作。

Is there any reason why someone would use BigTable instead of BigQuery? Both seem to support Read and Write operations with the latter offering also advanced 'Query' operations.

我需要开发一个联盟网络（因此，我需要跟踪点击次数和销售），因此我对差异感到困惑，因为bigQuery似乎只是具有更好API的bigTable。

I need to develop an affiliate network (thus I need to track clicks and 'sales') so I'm quite confused by the difference because bigQuery seems to be just bigTable with a better API.

推荐答案

区别基本上是：

BigQuery是一个查询引擎，用于那些变化不大或通过追加而变化的数据集。当您的查询需要表扫描或需要查看整个数据库时，这是一个很好的选择。考虑总和，平均值，计数，分组。 BigQuery是您收集大量数据后需要提出的问题。

BigQuery is a query Engine for datasets that don't change much, or change by appending. It's a great choice when your queries require a "table scan" or the need to look across the entire database. Think sums, averages, counts, groupings. BigQuery is what you use when you have collected a large amount of data, and need to ask questions about it.

BigTable是一个数据库。它被设计为大型可扩展应用程序的基础。在制作需要读取和写入数据的任何类型的应用时，请使用BigTable，而规模是一个潜在的问题。

BigTable is a database. It is designed to be the foundation for a large, scaleable application. Use BigTable when you are making any kind of app that needs to read and write data, and scale is a potential issue.

这篇关于BigQuery和BigTable有什么区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！