Ontology driven Dimensional Modeling
To understand how to answer world questions from data models, we don't need semantic layers, we need ontologies
7 of 392 posts
To understand how to answer world questions from data models, we don't need semantic layers, we need ontologies
For the data engineering crowd, here’s an explainer of how unstructured AI memory works, though the lens of what we know from working with structured data.
By upgrading only the generative model, we achieved a 3x accuracy boost but hit a hard ceiling, proving that not only LLMs are needed for good retrieval.
I didn't vibe-build a product. I wrote a messy scaffold that runs a pipeline, grabs the schema, and forces an agent to build a star schema. It works shockingly well.
Who's the UFC GOAT? Reshef Sharvit built an analytics pipeline using dlt, dbt & Metabase to find out. Automated ingestion meets deep SQL analysis. See the results here.
Moved 5M rows from DuckDB to MySQL 3.7x faster, reducing time from 344s to 92s by switching from SQLAlchemy’s row-by-row path to Arrow + ADBC’s columnar pipeline.