请输入您要查询的百科知识:

 

词条 BigQuery
释义

  1. History

  2. Design

  3. Features

  4. References

  5. External links

{{Infobox website
| name = BigQuery
| type = Platform as a service
| language = English
| current status = Active
| url = {{URL|https://cloud.google.com/products/bigquery/}}
| registration = Required
| owner = Google
| launch date = {{start date and age|2010|5|19}}
}}

BigQuery is a RESTful web service that enables interactive analysis of massively large datasets working in conjunction with Google Storage. It is a serverless Platform as a Service (PaaS) that may be used complementarily with MapReduce.

History

After a limited testing period in 2010, BigQuery was generally available in November 2011 at the Google Atmosphere conference.[1]

In April 2016, European users of the service suffered a 12-hour outage.[2]

In May 2016, support was announced for Google Sheets.[3]

Design

BigQuery provides external access to the Dremel technology,[4][5] a scalable, interactive ad hoc query system for analysis of read-only nested data. BigQuery requires all requests to be authenticated, supporting a number of Google-proprietary mechanisms as well as OAuth.

Features

  • Managing data - create and delete tables based on a JSON-encoded schema, import data encoded as CSV or JSON from Google Storage.
  • Query - the queries are expressed in a standard SQL dialect[6] and the results are returned in JSON with a maximum reply length of approximately 128 MB, or an unlimited size when large query results are enabled.[7]
  • Integration - BigQuery can be used from Google Apps Script[8] (e.g. as a bound script in Google Docs), or any language that can work with its REST API or client libraries[9].
  • Access control - is possible to share datasets with arbitrary individuals, groups, or the world.

References

1. ^{{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 }}
2. ^{{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 }}
3. ^{{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 }}
4. ^{{cite web|url=http://research.google.com/pubs/pub36632.html|author1=Sergey Melnik |author2=Andrey Gubarev |author3=Jing Jing Long |author4=Geoffrey Romer |author5=Shiva Shivakumar |author6=Matt Tolton |author7=Theo Vassilakis |work=Proc. of the 36th International Conference on Very Large Data Bases (VLDB)|year = 2010|title=Dremel: Interactive Analysis of Web-Scale Datasets}}
5. ^{{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 }}
6. ^{{cite web|title=SQL Reference|url=https://cloud.google.com/bigquery/docs/reference/standard-sql/|accessdate=26 June 2017}}
7. ^{{cite web|title=Quota Policy|url=https://cloud.google.com/bigquery/quota-policy#queries|accessdate=26 June 2017}}
8. ^{{Cite web |title= BigQuery Service | Apps Script | Google Developers |date= March 15, 2018 |url= https://developers.google.com/apps-script/advanced/bigquery |accessdate = April 23, 2018 }}
9. ^{{cite web|title=BigQuery Client Libraries|url=https://cloud.google.com/bigquery/docs/reference/libraries|accessdate=26 June 2017}}

External links

  • [https://cloud.google.com/bigquery/what-is-bigquery Official website]
{{Cloud computing}}{{Google Inc.}}

4 : Web services|Google|2010 software|Computer-related introductions in 2010

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/11/12 2:57:41