Software:BigQuery
BigQuery is a RESTful web service that enables interactive analysis of massive datasets working in conjunction with Google Storage. It is a serverless Software as a Service (SaaS) 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
- ↑ Iain Thomson (November 14, 2011). "Google opens BigQuery for cloud analytics: Dangles free trial to lure doubters". https://www.theregister.co.uk/2011/11/14/google_bigquery_cloud_analytics/. Retrieved August 26, 2016.
- ↑ Simon Sharwood (April 7, 2016). "Google Euro-cloud glitch". https://www.theregister.co.uk/2016/04/07/google_cloud_in_12hour_euro_pitstop/. Retrieved August 26, 2016.
- ↑ Jordan Novet (May 6, 2016). "Google BigQuery now lets you analyze data from Google Sheets". https://venturebeat.com/2016/05/06/google-bigquery-now-lets-you-analyze-data-from-google-sheets/. Retrieved August 26, 2016.
- ↑ "Dremel: Interactive Analysis of Web-Scale Datasets". Proc. of the 36th International Conference on Very Large Data Bases (VLDB). 2010. http://research.google.com/pubs/pub36632.html.
- ↑ Kazunori Sato (2012). "An Inside Look at Google BigQuery". Google. https://cloud.google.com/files/BigQueryTechnicalWP.pdf. Retrieved August 26, 2016.
- ↑ "SQL Reference". https://cloud.google.com/bigquery/docs/reference/standard-sql/. Retrieved 26 June 2017.
- ↑ "Quota Policy". https://cloud.google.com/bigquery/quota-policy#queries. Retrieved 26 June 2017.
- ↑ "BigQuery Service | Apps Script | Google Developers". March 15, 2018. https://developers.google.com/apps-script/advanced/bigquery. Retrieved April 23, 2018.
- ↑ "BigQuery Client Libraries". https://cloud.google.com/bigquery/docs/reference/libraries. Retrieved 26 June 2017.
External links
 |  |
