Definition

Google BigQuery

Google BigQuery is a cloud-based big data analytics web service for processing very large read-only data sets.

BigQuery was designed for analyzing data on the order of billions of rows, using a SQL-like syntax. It runs on the Google Cloud Storage infrastructure and can be accessed with a REST-oriented application program interface (API).

BigQuery, which was released as V2 in 2011, is what Google calls an "externalized version" of its home-brewed Dremel query service software. Dremel and BigQuery employ columnar storage for fast data scanning and a tree architecture for dispatching queries and aggregating results across huge computer clusters.

BigQuery in its Dremel form has been used inside Google to track device installation data, create crash reports and analyze spam. Since its inception, BigQuery features have continually been improved. In early 2013, data joins and time stamps were added to the service. Later in the year, stream data insert capabilities were added.

Mike Mason explains how Google BigQuery works in ten minutes.

See also: columnar database

Contributor(s): Jack Vaughan
This was last updated in October 2013
Posted by: Margaret Rouse

Email Alerts

Register now to receive SearchDataManagement.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

More News and Tutorials

Do you have something to add to this definition? Let us know.

Send your comments to techterms@whatis.com

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: