Live data from Hacker News

Guide to data tools landscape for developers

sinja.io

1–10 of 38 posts

Re: Guide to data tools landscape for developers

#5
> A data warehouse on the other hand is an OLAP database and is optimized to work on columns

A bit of a pedantic nit here: a data warehouse is a usage pattern. It’s not necessarily tied to any specific technology, however it is commonly implemented with OLAP systems like Snowflake, BigQuery, etc. But there’s nothing stopping you from building out your data warehouse in Postgres or MySQL. If you’re stitching together disparate datasets to build a unified model for analytics, you’ve got yourself a data warehouse no matter what system it lives on.

Re: Guide to data tools landscape for developers

#9
post #2

Now I'll be thinking of "L" in ETL as "Land" and not "Load". Although the article doesn't propose that but uses a lot of "Land" terminology. "Load" => "load where? or FROM where?" - ambiguous "Land" => "land where?" - clear

always understood "land" as the raw data layer though, i.e only the bronze layer in the article.
Post reply on HN