DeepRead
Cover of The data warehouse toolkit

The data warehouse toolkit

Ralph Kimball, Margy Ross · 1996

Programming and computer science › Databases and distributed data

#1,574 most recommended

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

02420092015202020262017 peak · 4
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say

No Open Library reader has rated it yet.

  • 29 want to read
  • 0 reading
  • 1 have read

Open Library’s page for the book

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

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

Explore in the mosaic

Read next: its neighbours on the mosaic