Declare the Grain Before Writing the Query
Define what one row represents, distinguish entities from revisions and attach that meaning to keys and measures.
5 min readRead article
SQL, models & data integrity
Articles
Original guides and technical studies, written to make the assumptions and trade-offs visible.
Matching articles
1 articleFrom the wider community
Engineering Feed
Publications from DEV Community. Titles and summaries are attributed to their original authors; the links open the original articles.
Data Modelling, Relationships And Joins In Power BI
Introduction This article takes through the ideas that decide whether a model works as...
The FETCH FIRST story: from ROW_NUMBER() in 12c back to ROWNUM in 23ai, and a LIMIT equivalent for PostgreSQL
The FETCH FIRST ... ROWS ONLY clause arrived in the SQL standard with SQL:2008, and Oracle Database...
Your Database Is Small. That Doesn’t Mean Your Queries Are Fast
“My database is only 50 MB. Why is my API slow?” It's an easy assumption to make. Small database =...
How I Built a Two-Tier Data Platform in 9 Phases (Spark, Kafka, dbt, Kubernetes)
A complete data platform — batch + streaming, single-node + distributed, local + Kubernetes. What I built, what broke, and what I learned.
Your Oracle Traffic Is Readable on the Wire. Here's the Proof, and the Fix.
By default an Oracle client and server negotiate no encryption, so every query and every row crosses the network in readable bytes. A packet-capture lab shows the SQL and a confidential value in plaintext, then four lines of sqlnet.ora (REQ
OpenSearch Under the Hood: How It Actually Works
I have been using OpenSearch for querying and aggregating data at work. Initially, I was just...