Sign in to view content

Sign in to view this lesson and continue learning.

Dimensional Data Modeling - Complex Data Types Arrays and Structs with Postgres (Day 1 Lecture)

Week 1: Dimensional Data Modeling in Postgres (v2)
54 mins
SQLData ModelingPostgres

Description

In this presentation, we discuss the fundamental concepts of cumulative table design, the strategic use of complex data types like STRUCTS and ARRAYS, tradeoff between compactness and usability, and the challenges posed by temporal cardinality explosions in data representation.