Data Engineering Exercises
- DB Schema, few joins --> snapshots/database-schema
- pyspark computing --> snapshots/pyspark
OLAP: Online analytical processing OLTP: Online transaction processing
for OLAP --> use column-oriented databases
Massively parallel processing (MPP) databases are usually column-oriented, like Redshift