Learn: DWH, DataLake, and Data Lakehouse

konabuta / my-scratch-book

MIT License

0 stars 0 forks source link

Open konabuta opened 3 days ago

konabuta commented 3 days ago

my memo in learning DWH.

Operating system vs Information system

konabuta commented 3 days ago

Operating system vs Information system

konabuta commented 2 days ago

Shared Disk vs Shared Nothing
- Hybrid: Snowflake
Star schema vs Flat schema
- Star schema is more common, but flat schema has an advantage in modeling difficulty.
- Flat schema can't analyze data which doesn't exist in the data.