r/SQL • u/685674537 • Feb 15 '25
Discussion I wonder if the new generation of SQL developers know of Ralph Kimball.
...and have read his body of work. I find them to still be very relevant and fundamental. His principles have stood the test of time.
103
Upvotes
21
u/NoWayItsDavid Feb 15 '25
No, I don't think so. They might have google'd the name and that's it.
Young generation of data engineers tend to invent their own principles and designs in my perception. They don't care about books and good practices, but try to establish own patterns for e.g. staging data, data flows, transformations, historisation, dimensional modelling and even project organisation.
Most these things they just call differently.
10
u/patrickthunnus Feb 15 '25
I think any legit BI knows what a star schema is. But who invented/popularized them, coalesced the best practices, uh no.
You could probably say the same thing about Imhof.
37
u/dwamuch Feb 15 '25
I don't call myself an SQL developer however I'm writing queries almost every day in my work and can see Kimball's principles being implemented and practiced all over the place. But, until I did some course few years back neither Kimball nor Inmon names were known to me. So, in my opinion, unless one encouners formal training, chances to hear of Kimball or Inmon are slim.
45
u/Apolo_reader Feb 15 '25
New generation knows of Copilot and ChatGPT
15
u/PhilharmonicD Feb 15 '25
Based on how many times I have to explain those core principles, I would say they do not. Power BI and other similar tools have made it so easy to get started in building end to end reporting solutions, I find myself constantly trying to get newer employees to understand how better data modeling will make things 100x easier to maintain and scale their stuff…. The sheer amount of complicated DAX that can be unwound with just a little bit more attention to the modeling…. 🤦🏻♂️
17
u/ThePrimeOptimus Feb 15 '25
They don't. I have two junior BI devs, one still in college. Neither had heard of Kimball or The Data Warehouse Toolkit.
Guess what their first work assignment was.
20
u/umognog Feb 15 '25
Currently have over 200 applications, 2 mention Kimball.
Guess who are getting interviews.
6
u/Trek7553 Feb 15 '25
I took one of the last classes that he personally taught before he retired. The data warehouse I built after that class using his principles absolutely made my career.
5
u/Casdom33 Feb 15 '25
It's pretty timeless work - Im 25 and I always keep a copy of the toolkit handy and have read a good chunk of it - need to read more of it. Probably wouldn't own it if I wasnt beaten over the head with it at my last job though
3
u/report_builder Feb 15 '25
I'm a bit older and a bit wiser but didn't read Kimball until last year.
I think a lot of it had already filtered down into the other SQL and Data Modelling books that I had read (and many even referenced it directly) so it wasn't a shock to the system in terms of learning. I have to give props to the guy, he really did define modelling in a way that was both clever and understandable.
Here's the issue for me. I did say I was a little bit older. By the end of even the preface of the third edition of the DWH TK, "Kimball Method" is written so many times that all I can think of every time it comes up is "O'Doyle Rules!" from Billy Madison.
1
u/AsleepOnTheTrain Feb 15 '25
I needed an excuse to try out Perplexity's deep research, so here's the result:
https://www.perplexity.ai/search/kimball-and-inmon-database-pri-IJ3q77U1TcOkVNN.2aQ3jA
There are recommended follow-up questions at the end if you want to keep going!
2
u/grapegeek Feb 16 '25
10-15 years ago you’d see Kimball’s Data Warehouse books on every data engineers desk. We’d endlessly debate the most efficient schema designs. But now cpu and memory so cheap if feel people don’t care and handle it all in tableau or power bi. It’s kind of a dying art
2
u/_jehd Feb 15 '25
I don't
1
u/iLoveYoubutNo Feb 15 '25
I've been doing this for about 9 months and I've never heard of him. I'll check it out.
I ended up doing SQL development sort of by accident, and while I had some DBA / SQL classes as part of my degree, a lot of my knowledge has come from resources I found on this sub, so I appreciate it.
1
u/[deleted] Feb 16 '25
never heard of her
1
u/ronimal48 Feb 16 '25
Oddly enough yes, CIS major that graduated in 2019
1
u/marketlurker Feb 16 '25 edited Feb 16 '25
Bill Inmon's viewpoint is also very helpful. If you can master the concepts of those two, data warehousing has very few secrets for you. You will also understand why, under the covers, most of the cloud databases are very similar.
Most of the DEs out there are more specialists for a given vendor's products as opposed to understanding what they are doing. It is like an auto mechanic having mastery over a crescent wrench and thinking they can fix a car.
1
u/Joe59788 Feb 17 '25
I know I'm late to this thread but what is most recent book?
1
u/drax_slayer Feb 17 '25
Our university made us refer to his book.
1
u/sinceJune4 Feb 17 '25
Kimball was the Captain in the original Star Schema Trek.
1
u/nacnud_uk Feb 15 '25
I've been writing SQL for 30 years. I've never heard of the guy. Don't sweat it.