Top all-time · #10700
Kimball Group
Company blog · kimballgroup.comdatabusiness
Kimball Group is the company blog at kimballgroup.com, writing about data and business. Since 2011, 7 different Hacker News readers have linked it 10 times. The last post was in 2015, but the archive is still widely read.
Too few sampled comments (6) to say how often HN recommends it.?
Why HN links it
HN readers link Kimball Group's posts on data warehousing and dimensional modelling, including slowly changing dimensions, ETL and Parquet, Iceberg and data lakehouses. Commenters cite them as references.
Summarised by Claude from a sample of 6 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
The Kimball Group is the source for data warehousing expertise. A team of dedicated data warehousing professionals, bringing 100+ years of experience.
What Hacker News says?
It's really easy to get lost in the technical jargon that the vendors who are selling products throw around, but this article has missed the important part, and spent all the time talking about the relatively unimportant part (data formats). You need to step back and look from a broader perspective to understand this domain. Talking about arrow/parquet/iceberg is like talking about InnoDB vs MyISAM when you're talki…
Comment linking /data-warehouse-business-intelligence-resources/books/data-warehouse-dw-toolkit/
on “Understanding Parquet, Iceberg and Data Lakehouses”Submitted A Dimensional Modeling Manifesto (1997) as a story · 13 points
HN discussionIts pretty much the kimball books - https://www.kimballgroup.com/data-warehouse-business-intelli...
Comment linking /data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/
on “Effectively Using Materialized Views in Ruby on Rails”Submitted A Dimensional Modeling Manifesto as a story · 2 points
HN discussionIf you are interested in Data Warehousing, you should read Ralph Kimball's "The Data Warehouse Toolkit": http://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimens... When I started learning about BI (Business Intelligence), a few members of the Pentaho community advised me to read this book. I'm glad I did. Kimball is one of the "fathers" of data warehousing, and his book had a lot of great insights for dimension…
Comment linking /html/07dt.html
on “Data Warehousing 101”Updates and deletes in ROLAP dimensional data models are usually performed via explicit ETL jobs, not triggers nor particularly update/delete cascading triggers. When a customer record is deleted in a source system, you typically do not want to delete (much less cascading delete) it from a downstream ROLAP data model because you are trying to maintain a history of past activity for reporting and/or audit purposes. I…
Comment linking /2013/02/design-tip-152-slowly-changing-dimension-types-0-4-5-6-7/
on “Things that don’t work well with MySQL’s FOREIGN KEY implementation”What this will provide having SCD? ( http://www.kimballgroup.com/2008/08/21/slowly-changing-dimen... )?
Comment linking /2008/08/21/slowly-changing-dimensions/
on “Immutable SQL”How does Lume know what to fill in on the target table if a record effective end date isn’t in the source system but is a property of when the data was fetched? How does Lume know to update the record effective termination date of a target row when a new row comes along? (This type of data modeling is described here: https://www.kimballgroup.com/data-warehouse-business-intelli... )
Comment linking /data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/type-2/
on “Launch HN: Lume (YC W23) – Generate custom data integrations with AI”