Engine Room ep6: Databases, data modeling, and some pipeline support tooling

An overview of relational databases; the difference between OLTP and OLAP systems; a tool I'm writing to automate the process of setting up an OLAP database

TIMELINE:
0:31 The Story So Far
1:44 Relational databases: an overview
6:50 OLTP database design
15:14 OLAP database design
22:55 Real-live OLAP data model
28:42 new Python CLI utility: dgenr8
44:41 Fixed my Big Stupid Bug

The Mercury demo repo lives here:

This video corresponds to module 1 of the ngst unit, so the local subdirectory is ngst_1 (relative to the repo root).

(also available from PyPi as mercury-toolkit)

Docopt (our favorite CLI argument-parsing tool):