
The data warehouse toolkit
Ralph Kimball, Margy Ross · 1996
Programming and computer science › Databases and distributed data
#1,574 most recommended
Hacker News
32
mentions by 27 people · top 11% of 15,732 books
Open Library
—
No ratings yet
29 want to read
Wikipedia
—
No article yet
About the book
A practical guide to designing data warehouses and business intelligence databases, centred on dimensional modeling. It covers fact and dimension tables, star schemas, and techniques for handling data that changes over time, and it works through example models for a range of business areas. The central claim is that a warehouse should be organized around business processes and modeled dimensionally, so that its structure is understandable to business users and efficient for querying. Kimball argues that each fact table should be defined at one clearly stated grain, and that dimensions should be conformed across the warehouse so that separate data marts can be combined. The book also contends that surrogate keys and slowly changing dimension techniques are needed to keep historical analysis accurate as source data changes.
Written by Claude from what it knows of this book.
What Hacker News says 85% recommend · 0% critical
In the commenters’ own words
I haven't heard the term ScalepUp CTO. There's a company named ScaleUp, but I'm assuming you're not their new CTO ;p but a CTO promoted during the "scale up"…
I've personally read the "Box: How the shipping container..." book. Its a pretty good read, it talks about the history of caravel ships's cargo load…
What Open Library readers say
No Open Library reader has rated it yet.
- 29 want to read
- 0 reading
- 1 have read
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
The threads it came up in
- Ask HN: Books that improved your career?
- Ask HN: What books would you recommend to newly appointed ScaleUp CTO?
- Ask HN: What are some good books for SQL/DBA?
- Ask HN: What is a good book or resource discussing how to create a data warehouse
- Ask HN: Good books/resources that provide overviews of large industries?
Details
- First published
- 1996
- ISBN
- 9780471200246
- Editions known
- 30 at Open Library
- Open Library
- OL2983865W
Architecture informatiqueBUSINESS & ECONOMICSBases de donneesBases de donnéesBusiness enterprisesBusiness intelligenceConceptionConception assistee par ordinateurData processingData warehousingData-Warehouse-KonzeptDatabankenDatabase Management SystemsDatabase design
Read next: its neighbours on the mosaic
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · 5 people recommended both
Applied Mathematics for Database ProfessionalsLex deHaan · 2007 · recommended by 2 people · similar by subject and what people say about it
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · 2 people recommended both
Applied mathematics for database professionalsLex de Haan · 2007 · recommended by 5 people · similar by subject and what people say about it
The Art of PostgreSQLDimitri Fontaine · 2019 · recommended by 20 people · 2 people recommended both
Seven Databases in Seven WeeksEric Redmond · 2012 · recommended by 8 people · similar by subject and what people say about it
Data Analysis with Open Source ToolsPhilipp K. Janert · 2010 · recommended by 7 people · 2 people recommended both
Big DataNathan Marz · 2015 · recommended by 7 people · similar by subject and what people say about it
Data and RealityWilliam Kent · 1978 · recommended by 15 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
Readings in database systemsMichael Stonebraker · 1998 · recommended by 11 people · similar by subject and what people say about it
The data warehouse ETL toolkitRalph Kimball · 2004 · recommended by 1 person · similar by subject and what people say about it
Database InternalsAlex Petrov · 2019 · recommended by 31 people · similar by subject and what people say about it
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
The Datacenter as a ComputerLuiz André Barroso · 1900 · recommended by 9 people · similar by subject and what people say about it
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
Data SmartJohn W. Foreman · 2013 · recommended by 20 people · similar by subject and what people say about it
Information Dashboard DesignStephen Few · 2006 · recommended by 25 people · similar by subject and what people say about it
The data model resource bookLen Silverston · 1997 · recommended by 8 people · similar by subject and what people say about it
Architecture of a database systemJoseph M. Hellerstein · 2007 · recommended by 7 people · similar by subject and what people say about it
Python For Data AnalysisWes McKinney · 2012 · recommended by 29 people · 2 people recommended both
Data miningI. H. Witten · 1999 · recommended by 9 people · similar by subject and what people say about it