Summary - Distributed and big data

Speed up an analytical query with columnar storage.

Summary - Distributed and big data

Distributed SQL: FDW for remote tables, MPP for parallel, columnar for OLAP, SQL on Hadoop for big data, NoSQL for flexible structure. Scale-out design ties them together.

-- FDW -> MPP -> columnar -> Hadoop
-- NoSQL: CAP seçer

Distributed data arrives five ways.

Exercise Summary - Distributed and big data

Summary task: create the analytics table as columnar: WITH (format = 'columnar').

Show example solution

CREATE TABLE analytics (id INT, revenue NUMERIC) WITH (format = 'columnar');

Test yourself

Distributed foreign table

CREATE FOREIGN TABLE remote_events (id INT) SERVER ____

Show answer

CREATE FOREIGN TABLE remote_events (id INT) SERVER remote_server

Which workload suits columnar storage?
- OLAP
- OLTP
- Both
- Files
Show answer

OLAP — Columnar storage suits OLAP workloads.
Summary - Distributed and big data: match the terms

FDW

foreign table
MPP

parallel
columnar

columnar
Hadoop

big data

Next lesson: SQL injection

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies