imported>Vango1251：/* 外部链接 */

2023-06-26T06:57:38Z

外部链接

新页面

{{Infobox website|name=BigQuery|type=[[平台即服务]]|language=[[英语]]|current_status=运营中|url={{URL|https://cloud.google.com/products/bigquery/}}|registration=需要|owner=[[谷歌]]|date_of_launch={{start date and age|2010|5|19}}}} '''BigQuery'''是一个[[表现层状态转换|RESTful]]的[[Web服务]] ，可以对与[[Google Storage]]结合使用的大型数据集进行交互式分析。它是一种无服务器的平台即服务（ [[平台即服务|PaaS]] ），且可与[[MapReduce]]相互补充使用。

== 历史 ==
谷歌在2010年进行了有限度测试之后，于2011年11月在Google Atmosphere会议上宣布BigQuery全面可用。<ref>{{Cite web|title=Google opens BigQuery for cloud analytics: Dangles free trial to lure doubters|author=Iain Thomson|date=November 14, 2011|url=https://www.theregister.co.uk/2011/11/14/google_bigquery_cloud_analytics/|accessdate=August 26, 2016|archive-date=2016-09-15|archive-url=https://web.archive.org/web/20160915085642/http://www.theregister.co.uk/2011/11/14/google_bigquery_cloud_analytics/|dead-url=no}}</ref>

2016年4月，此服务的欧洲用户经历了12小时的中断。<ref>{{Cite web|title=Google Euro-cloud glitch|author=Simon Sharwood|date=April 7, 2016|url=https://www.theregister.co.uk/2016/04/07/google_cloud_in_12hour_euro_pitstop/|accessdate=August 26, 2016|archive-date=2016-09-15|archive-url=https://web.archive.org/web/20160915085414/http://www.theregister.co.uk/2016/04/07/google_cloud_in_12hour_euro_pitstop/|dead-url=no}}</ref>2016年5月，谷歌宣布了对[[Google表单]]的支持。<ref>{{Cite web|title=Google BigQuery now lets you analyze data from Google Sheets|author=Jordan Novet|date=May 6, 2016|url=https://venturebeat.com/2016/05/06/google-bigquery-now-lets-you-analyze-data-from-google-sheets/|accessdate=August 26, 2016|archive-date=2016-09-08|archive-url=https://web.archive.org/web/20160908185744/http://venturebeat.com/2016/05/06/google-bigquery-now-lets-you-analyze-data-from-google-sheets/|dead-url=no}}</ref>

== 设计 ==
BigQuery提供对[[Dremel]]技术的外部访问<ref name="goog-dremel">{{Cite web|url=http://research.google.com/pubs/pub36632.html|author=Sergey Melnik|work=Proc. of the 36th International Conference on Very Large Data Bases (VLDB)|year=2010|title=Dremel: Interactive Analysis of Web-Scale Datasets|accessdate=2019-04-03|archive-date=2010-10-28|archive-url=https://web.archive.org/web/20101028163845/http://research.google.com/pubs/pub36632.html|dead-url=no}}</ref><ref>{{Cite web|publisher=Google|title=An Inside Look at Google BigQuery|author=Kazunori Sato|year=2012|url=https://cloud.google.com/files/BigQueryTechnicalWP.pdf|accessdate=August 26, 2016|archive-date=2016-09-03|archive-url=https://web.archive.org/web/20160903094302/https://cloud.google.com/files/BigQueryTechnicalWP.pdf|dead-url=no}}</ref>，是一个可扩展的交互式[[即席查询]]系统，用于分析只读嵌套数据。BigQuery要求对所有请求进行身份验证，其支持许多Google专有的验证机制以及[[开放授权|OAuth]]。

== 特征 ==

* '''管理数据''' - 基于[[JSON]]编码模式创建和删除表，从Google Storage导入编码为[[CSV]]或JSON的数据。
* '''查询''' - 以标准SQL方言查询<ref name="Google BigQuery SQL reference">{{Cite web|title=SQL Reference|url=https://cloud.google.com/bigquery/docs/reference/standard-sql/|accessdate=26 June 2017|archive-date=2017-04-07|archive-url=https://web.archive.org/web/20170407174809/https://cloud.google.com/bigquery/docs/reference/standard-sql/|dead-url=no}}</ref>，以JSON格式返回结果，最大答复长度约为128 MB，启用大型查询结果时无大小限制。<ref name="Google BigQuery API">{{Cite web|title=Quota Policy|url=https://cloud.google.com/bigquery/quota-policy#queries|accessdate=26 June 2017|archive-date=2017-07-15|archive-url=https://web.archive.org/web/20170715192632/https://cloud.google.com/bigquery/quota-policy#queries|dead-url=no}}</ref>
* '''集成''' - 可以从Google Apps Script<ref>{{Cite web|title=<nowiki>BigQuery Service | Apps Script | Google Developers</nowiki>|date=March 15, 2018|url=https://developers.google.com/apps-script/advanced/bigquery|accessdate=April 23, 2018|archive-date=2019-04-03|archive-url=https://web.archive.org/web/20190403052318/https://developers.google.com/apps-script/advanced/bigquery|dead-url=no}}</ref>使用BigQuery（例如，作为[[Google文档]]中的绑定脚本），也可以从使用其REST API或客户端库的任何语言使用BigQuery<ref name="Google BigQuery Client Libraries">{{Cite web|title=BigQuery Client Libraries|url=https://cloud.google.com/bigquery/docs/reference/libraries|accessdate=26 June 2017|archive-date=2017-02-11|archive-url=https://web.archive.org/web/20170211174740/https://cloud.google.com/bigquery/docs/reference/libraries|dead-url=no}}</ref> 。
* '''访问控制''' - 可以与任意个人，团体或世界共享数据集。

== 参考 ==
<references group="" responsive=""></references>

== 外部链接 ==
* [https://cloud.google.com/bigquery/what-is-bigquery 官方网站]{{Wayback|url=https://cloud.google.com/bigquery/what-is-bigquery |date=20141229192309 }}
*{{ URL | https://tw.cocloud.com/zh-tw/blog/google-compute-engine | Google Compute Engine 教學 }}
*{{ URL | https://tw.cocloud.com/zh-tw/blog/google-kubernetes-Engine | Google Kubernetes Engine 教學 }}
*{{ URL | https://tw.cocloud.com/zh-tw/blog/gcp-teaching-encyclopedia | Google Cloud Platform 教學 }}

{{Google Cloud}}

[[Category:2010年软件]]
[[Category:Google服務]]
[[Category:Web服务]]
[[Category:有未审阅翻译的页面]]

BigQuery - 版本历史

imported>Vango1251：​/* 外部链接 */

imported>Vango1251：/* 外部链接 */