BigQuery
BigQuery
Jump to navigation
Jump to search
Type of site | Infrastructure as a service |
|---|---|
| Available in | English |
| Owner | |
| Website | cloud.google.com/products/bigquery/ |
| Registration | Required |
| Launched | May 19, 2010 (2010-05-19) |
| Current status | Active |
BigQuery is a RESTful web service that enables interactive analysis of massively large datasets working in conjunction with Google Storage. It is an Infrastructure as a Service (IaaS) that may be used complementarily with MapReduce.
Contents
1 History
2 Design
3 Features
4 References
5 External links
History[edit]
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[edit]
BigQuery provides external access to the Dremel technology,[4][5] a scalable, interactive ad hoc query system for analysis of read-only nested data. To use the data in BigQuery, it first must be uploaded to Google Storage and in a second step imported using the BigQuery HTTP API. BigQuery requires all requests to be authenticated, supporting a number of Google-proprietary mechanisms as well as OAuth.
Features[edit]
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[edit]
^ Iain Thomson (November 14, 2011). "Google opens BigQuery for cloud analytics: Dangles free trial to lure doubters". Retrieved August 26, 2016..mw-parser-output cite.citation{font-style:inherit}.mw-parser-output q{quotes:"""""""'""'"}.mw-parser-output code.cs1-code{color:inherit;background:inherit;border:inherit;padding:inherit}.mw-parser-output .cs1-lock-free a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/6/65/Lock-green.svg/9px-Lock-green.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output .cs1-lock-limited a,.mw-parser-output .cs1-lock-registration a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/d/d6/Lock-gray-alt-2.svg/9px-Lock-gray-alt-2.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output .cs1-lock-subscription a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/a/aa/Lock-red-alt-2.svg/9px-Lock-red-alt-2.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output .cs1-subscription,.mw-parser-output .cs1-registration{color:#555}.mw-parser-output .cs1-subscription span,.mw-parser-output .cs1-registration span{border-bottom:1px dotted;cursor:help}.mw-parser-output .cs1-hidden-error{display:none;font-size:100%}.mw-parser-output .cs1-visible-error{font-size:100%}.mw-parser-output .cs1-subscription,.mw-parser-output .cs1-registration,.mw-parser-output .cs1-format{font-size:95%}.mw-parser-output .cs1-kern-left,.mw-parser-output .cs1-kern-wl-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right,.mw-parser-output .cs1-kern-wl-right{padding-right:0.2em}
^ Simon Sharwood (April 7, 2016). "Google Euro-cloud glitch". Retrieved August 26, 2016.
^ Jordan Novet (May 6, 2016). "Google BigQuery now lets you analyze data from Google Sheets". Retrieved August 26, 2016.
^ Sergey Melnik; Andrey Gubarev; Jing Jing Long; Geoffrey Romer; Shiva Shivakumar; Matt Tolton; Theo Vassilakis (2010). "Dremel: Interactive Analysis of Web-Scale Datasets". Proc. of the 36th International Conference on Very Large Data Bases (VLDB).
^ Kazunori Sato (2012). "An Inside Look at Google BigQuery" (PDF). Google. Retrieved August 26, 2016.
^ "SQL Reference". Retrieved 26 June 2017.
^ "Quota Policy". Retrieved 26 June 2017.
^ "BigQuery Service | Apps Script | Google Developers". March 15, 2018. Retrieved April 23, 2018.
^ "BigQuery Client Libraries". Retrieved 26 June 2017.
External links[edit]
- Official website
Cloud computing | |
|---|---|
| As a service |
|
| Technologies |
|
| Applications |
|
| Platforms |
|
| Infrastructure |
|
| |
Category
CommonsGoogle | |||||||
|---|---|---|---|---|---|---|---|
| Overview |
| ||||||
| Advertising |
| ||||||
| Communication |
| ||||||
| Software |
| ||||||
| Operating systems |
| ||||||
| Programming languages |
| ||||||
| Platforms |
| ||||||
| Hardware |
| ||||||
| Development tools |
| ||||||
| Publishing |
| ||||||
Search (timeline) |
| ||||||
| Discontinued |
| ||||||
| Other |
| ||||||
| People |
| ||||||
| Related |
| ||||||
| |||||||
PortalCategories:
- Web services
- 2010 software
- Computer-related introductions in 2010
(window.RLQ=window.RLQ||).push(function(){mw.config.set({"wgPageParseReport":{"limitreport":{"cputime":"0.332","walltime":"0.446","ppvisitednodes":{"value":1565,"limit":1000000},"ppgeneratednodes":{"value":0,"limit":1500000},"postexpandincludesize":{"value":91157,"limit":2097152},"templateargumentsize":{"value":664,"limit":2097152},"expansiondepth":{"value":17,"limit":40},"expensivefunctioncount":{"value":0,"limit":500},"unstrip-depth":{"value":1,"limit":20},"unstrip-size":{"value":23177,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 310.784 1 -total"," 45.58% 141.658 1 Template:Infobox_website"," 38.65% 120.127 1 Template:Reflist"," 38.11% 118.455 1 Template:Infobox"," 33.79% 105.004 9 Template:Cite_web"," 12.69% 39.449 5 Template:Navbox"," 10.44% 32.453 1 Template:Start_date_and_age"," 7.23% 22.481 1 Template:Google_Inc."," 6.92% 21.492 1 Template:Cloud_computing"," 5.99% 18.605 3 Template:If_empty"]},"scribunto":{"limitreport-timeusage":{"value":"0.125","limit":"10.000"},"limitreport-memusage":{"value":5062479,"limit":52428800}},"cachereport":{"origin":"mw1323","timestamp":"20190109182850","ttl":1900800,"transientcontent":false}}});});{"@context":"https://schema.org","@type":"Article","name":"BigQuery","url":"https://en.wikipedia.org/wiki/BigQuery","sameAs":"http://www.wikidata.org/entity/Q4904867","mainEntity":"http://www.wikidata.org/entity/Q4904867","author":{"@type":"Organization","name":"Contributors to Wikimedia projects"},"publisher":{"@type":"Organization","name":"Wikimedia Foundation, Inc.","logo":{"@type":"ImageObject","url":"https://www.wikimedia.org/static/images/wmf-hor-googpub.png"}},"datePublished":"2011-01-07T11:41:20Z","dateModified":"2018-11-13T02:09:48Z","headline":"Fully managed, scalable data warehouse with built-in ML"}(window.RLQ=window.RLQ||).push(function(){mw.config.set({"wgBackendResponseTime":85,"wgHostname":"mw1273"});});
