BigQuery Architecture

Introduzione a BigQuery

Matt Forrest

CTO and author

Columnar data

Image showing the differences between row and columnar data storage

1 http://www.primarydigit.com/blog/-a-brief-introduction-to-column-oriented-databases
Introduzione a BigQuery

Capacitor

Capacitor in the BigQuery Architecture

Introduzione a BigQuery

Colossus

Colossus in the BigQuery architecture

Introduzione a BigQuery

Jupiter

The Jupiter network in the BigQuery Architecutre

Introduzione a BigQuery

Dremel

Dremel within the BigQuery architecture

Introduzione a BigQuery

Borg

The Borg cluster management system in BigQuery

Introduzione a BigQuery

Mixers, leaves, execution trees, and slots

Mixers, leaves, and execution trees in BigQuery

1 https://panoply.io/data-warehouse-guide/bigquery-architecture/
Introduzione a BigQuery

Categorized architecture

Storage

  • Capacitor
  • Colossus

Compute

  • Jupiter
  • Borg

Query Execution (Dremel)

  • Mixers
  • Leaf nodes
  • Execution tree
  • Slots
Introduzione a BigQuery

Let's practice!

Introduzione a BigQuery

Preparing Video For Download...