数仓-维度建模-Kimball-第一章笔记

最新推荐文章于 2024-08-02 11:00:00 发布

8su

最新推荐文章于 2024-08-02 11:00:00 发布

阅读量502

点赞数

分类专栏：数据中台文章标签：数据仓库

本文链接：https://blog.csdn.net/qq_33291559/article/details/116573701

版权

本文介绍了数据仓库（DW）和商业智能（BI）系统的目的是提供易于理解且一致的信息，并强调了维度建模在实现这些目标中的重要性。维度建模旨在简化数据，提高查询性能，通常采用星型架构。事实表存储业务过程的测量数据，而维度表则提供描述性上下文。文章还探讨了Kimball的DW/BI架构和其他架构选项，以及对维度建模的一些误解。

摘要由CSDN通过智能技术生成

Chapter 1 Data Warehousing, Business Intelligence, and Dimensional Modeling Primer

原文：《The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition》

First and foremost, the DW/BI system must consider the needs of the business.

Data is almost always used for two purposes: operational record keeping and analytical decision making.

Users of an operational system, almost always deal with one transaction record at a time.
Users of a DW/BI system, almost never deal with one transaction record at a time. To further complicate matters, they typically demand that historical context to preserved to accurately evaluate the organization’s performance overtime.

Goals of DW/BI systems

Must make info easily accessible (simple and fast)
- The data’s structures and labels should mimic the business user’s though processes and vocabulary
Must present information consistently
- If two performance measure have the same name, they must mean the same thing.
Must adapt to change
Must present info in a timely way
Must be a secure bastion that protects the information assets.
Must serve as the authoritative and trustworthy foundation for improved decision making.
The business community must accept the DW/BI system to deem it successful.