Movatterモバイル変換


[0]ホーム

URL:


Jump to content
WikipediaThe Free Encyclopedia
Search

BigQuery

From Wikipedia, the free encyclopedia
Cloud-based data warehouse service
This articlemay rely excessively on sourcestoo closely associated with the subject, potentially preventing the article from beingverifiable andneutral. Please helpimprove it by replacing them with more appropriatecitations toreliable, independent sources.(May 2023) (Learn how and when to remove this message)
BigQuery
Type of site
Platform as a servicedata warehouse
Available inEnglish
OwnerGoogle
URLcloud.google.com/bigquery
RegistrationRequired
LaunchedMay 19, 2010; 14 years ago (2010-05-19)
Current statusActive

BigQuery is a managed,serverlessdata warehouse product byGoogle, offeringscalable analysis over large quantities of data. It is aPlatform as a Service (PaaS) that supports querying using a dialect ofSQL. It also has built-inmachine learning capabilities. BigQuery was announced in May 2010 and made generally available in November 2011.[1]

History

[edit]

Bigquery originated from Google's internalDremel technology,[2][3] which enabled quick queries across trillions of rows of data.[4] The product was originally announced in May 2010 atGoogle I/O.[5] Initially, it was only usable by a limited number of external early adopters due to limitations on the API.[4] However, after the product proved its potential, it was released for limited availability in 2011 and general availability in 2012.[4] After general availability, BigQuery found success among a broad range of customers, including airlines, insurance, and retail organizations.[4]

Design

[edit]

BigQuery requires all requests to be authenticated, supporting a number of Google-proprietary mechanisms as well asOAuth.

Features

[edit]
  • Managing data - Create and delete objects such as tables, views, and user defined functions. Import data fromGoogle Storage in formats such as CSV, Parquet, Avro or JSON.
  • Query - Queries are expressed in a SQL dialect[6] and the results are returned inJSON 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 fromGoogle Apps Script[8] (e.g. as a bound script inGoogle Docs), or any language that can work with its REST API or client libraries.[9]
  • Access control - Share datasets with arbitrary individuals, groups, or the world.
  • Machine learning - Create and execute machine learning models using SQL queries.

References

[edit]
  1. ^Iain Thomson (November 14, 2011)."Google opens BigQuery for cloud analytics: Dangles free trial to lure doubters".The Register. RetrievedAugust 26, 2016.
  2. ^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).
  3. ^Kazunori Sato (2012)."An Inside Look at Google BigQuery"(PDF). RetrievedAugust 26, 2016.
  4. ^abcdKwek, Ju-Kay."BigQuery: the unlikely birth of a cloud juggernaut". RetrievedOctober 20, 2024.
  5. ^"Google I/O 2010 - BigQuery and Prediction APIs".
  6. ^"SQL Reference". Retrieved26 June 2017.
  7. ^"Quota Policy". Retrieved26 June 2017.
  8. ^"BigQuery Service | Apps Script | Google Developers". March 15, 2018. RetrievedApril 23, 2018.
  9. ^"BigQuery Client Libraries". Retrieved26 June 2017.

External links

[edit]
a subsidiary ofAlphabet
Company
Divisions
Subsidiaries
Active
Defunct
Programs
Events
Infrastructure
People
Current
Former
Criticism
General
Incidents
Other
Software
A–C
D–N
O–Z
Operating systems
Language models
Neural networks
Computer programs
Formats and codecs
Programming languages
Search algorithms
Domain names
Typefaces
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Y
Hardware
Pixel
Smartphones
Smartwatches
Tablets
Laptops
Other
Nexus
Smartphones
Tablets
Other
Other
Advertising
Antitrust
Intellectual property
Privacy
Other
Related
Concepts
Products
Android
Street View coverage
YouTube
Other
Documentaries
Books
Popular culture
Other
Cloud
Subsidiaries
Google Workspace
Business models
Technologies
Applications
Platforms
Infrastructure
Retrieved from "https://en.wikipedia.org/w/index.php?title=BigQuery&oldid=1252680588"
Categories:
Hidden categories:

[8]ページ先頭

©2009-2025 Movatter.jp