数据仓库 ETL 工具包
The data warehouse ETL toolkit
Ralph Kimball、Joe Caserta、Margy Ross、Bob Becker · 初版 2004 年
1人推荐
2位读者提及
2次提及
由全球顶尖数据仓库权威Ralph Kimball合著，其以往著作销量已超过15万册。本书为数据仓库中最耗时耗力的数据暂存环节，即抽取、转换和加载（ETL）过程提供了切实可行的解决方案；详细阐述了从分散数据源抽取数据、清除冗余和错误数据、将剩余数据转换为正确格式的数据结构、再将最终成果载入数据仓库的最佳实践；提供经过验证的高效ETL技巧，以及全方位的指导……
Hacker News 上怎么说
正在加载完整评论……
Spark 之类的确实很强，但讲真，如果你刚刚起步，我建议彻底忘掉那些针对 300 人规模公司的现成工具，先把 Kimball 写的《The Data Warehouse ETL Toolkit》读一遍：https://www.amazon.com/gp/product/1118530802/。我是看着第二版学会的，不过听说第三版口碑更棒。边读边上手做个带真实…
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 person companies and I would read The Data Warehouse ETL Toolkit by Kimball: https://www.amazon.com/gp/product/1118530802/ I learned from the second edition, but I've heard even better things about the third. As you're working through it, create a project with real…
…建模为事实表（fact table）的一行。只要事实表的一行存在，它就是一次度量（measurement）。“什么是度量？一个常见的定义是：通过仪器或刻度进行观察所确定的数值。”——《The Data Warehouse ETL Toolkit》（2004），Wiley 出版社。也许事实需要建立属于自己的、公开可访问的确认信息“有向图（directed graph）”。这就更复杂了，因为我们不能直接往一个单元格里写一个值，而是要记录一系列…
…modeled as a fact table row. If a fact table row exists, it is a measurement. "What is a measurement? A common definition is an amount determined by observation with an instrument or scale." -- The Data Warehouse ETL Toolkit (2004) Wiley Publishing. Maybe facts need their own "directed graph" of publicly accessible acknowledgements. That makes it more complex, since we can't write one value to a cell, but record a series…