DeepRead
Cover of The data warehouse ETL toolkit

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

02420182020202220232018 peak · 1
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.

  • 4 want to read
  • 1 reading
  • 0 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

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

Explore in the mosaic

Read next: its neighbours on the mosaic