
The data warehouse ETL toolkit
Ralph Kimball, Joe Caserta, Margy Ross, Bob Becker, Joy Mundy, Warren Thornthwaite · 2004
Programming and computer science › Databases and distributed data
#15,512 most recommended
Hacker News
2
mentions by 2 people · top 79% of 15,732 books
Open Library
—
No ratings yet
4 want to read
Wikipedia
—
No article yet
About the book
The book covers the extract, transform, and load (ETL) work that moves data from scattered operational source systems into a data warehouse. It addresses the back-room staging area, including extraction, cleansing, conforming, and loading data into dimensional tables such as dimensions and fact tables. It is written as a practical guide for the stage of warehouse projects that usually takes the most time and effort. The authors contend that ETL is the most labor-intensive part of data warehousing and should be designed as a deliberate architecture rather than assembled ad hoc from scripts. They present a catalogue of recurring ETL subsystems and techniques, including change data capture, surrogate keys, slowly changing dimensions, and load auditing. They also argue that data quality should be enforced inside the pipeline, with errors detected, logged, and handled systematically before data reaches the presentation layer.
Written by Claude from what it knows of this book.
What Hacker News says 50% recommend · 0% critical
In the commenters’ own words
Spark, etc, are great, but honestly if you're just getting started I would forget all about existing tooling that is geared towards people working at 300…
"Fact tables hold the measurements of an enterprise. The relationship between fact tables and measurements are extremely simple. If a measurement exists, it…
What Open Library readers say
No Open Library reader has rated it yet.
- 4 want to read
- 1 reading
- 0 have read
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
Details
- First published
- 2004
- ISBN
- 9780764567575
- Editions known
- 12 at Open Library
- Open Library
- OL2983864W
Computer Books: DatabaseComputer Software PackagesComputer TechnologyComputersComputers - Data Base ManagementComputers / Database Management / GeneralData warehousingDatabase Management - GeneralDatabase designDatabase managementNonfictionQa76.9.d37 k53 2004
Read next: its neighbours on the mosaic
The data warehouse toolkitRalph Kimball · 1996 · recommended by 23 people · similar by subject and what people say about it
Agile Data Warehouse DesignLawrence Corr · 2011 · recommended by 2 people · similar by subject and what people say about it
The Enterprise Big Data LakeAlex Gorelik · 2019 · recommended by 0 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
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
Database systemsPeter Rob · 2006 · recommended by 4 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
Data miningJiawei Han · 2000 · recommended by 4 people · similar by subject and what people say about it
Database system implementationHector Garcia-Molina · 1999 · recommended by 3 people · loosely similar by subject
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · loosely similar by subject
Effective Oracle by designThomas Kyte · 2003 · recommended by 1 person · loosely similar by subject
Data and RealityWilliam Kent · 1978 · recommended by 15 people · loosely similar by subject
HadoopTom White · 2009 · recommended by 2 people · loosely similar by subject
Database System ConceptsKorth · 2005 · recommended by 4 people · loosely similar by subject
Fundamentals of Data EngineeringJoe Reis · 2022 · recommended by 3 people · loosely similar by subject
Click here to kill everybodyBruce Schneier · 2018 · recommended by 6 people · loosely similar by subject
Fundamentals of database systemsRamez Elmasri · 1989 · recommended by 2 people · loosely similar by subject
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · loosely similar by subject
Building Evolutionary ArchitecturesNeal Ford · 2017 · recommended by 5 people · loosely similar by subject
SQL CookbookAnthony Molinaro · 2005 · recommended by 7 people · loosely similar by subject
Big DataNathan Marz · 2015 · recommended by 7 people · loosely similar by subject
Applied Mathematics for Database ProfessionalsLex deHaan · 2007 · recommended by 2 people · loosely similar by subject
SQL Design PatternsVadim Tropashko · 2007 · recommended by 2 people · loosely similar by subject
Readings in database systemsMichael Stonebraker · 1998 · recommended by 11 people · loosely similar by subject