08 May 20 · npack · #Bigquery ·   Bookmark   ×

What is the difference between BigQuery vs BigTable ?

What is BigTable ?

BigTable is a petabyte-scale, fully managed NoSQL database service for large analytical and operational workloads. Bigtable can be as the storage engine for large-scale, low-latency applications as well as throughput-intensive data processing and analytics. Provision and scale to hundreds of petabytes and smoothly handle millions of operations per second. Changes to the deployment configuration are immediate, so there’s no downtime during reconfiguration. Replication adds high availability for live serving apps, and workload isolation for serving vs. analytics

What is BigQuery ?

BigQuery on the other hand is SQL data warehouse (not like traditional database). It means that it is designed to do various (analytical) queries under large amount (order of tera / peta bytes) of data very quickly

Difference between BigTable vs BigQuery?

BigTableBigQuery
OLTP System (Online transaction processing)OLAP System (Online Analytical processing)
Low LatencyMedium Latency
Built to handle large volume of CRUD (Create, Read, Update, Delete)Specializes in scanning petabytes of data and produce analytical reports out of it

npack

posted on 08 May 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds