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屋！