Four different views regarding the design of a data warehousemust

最新推荐文章于 2023-02-18 12:29:57 发布

原创最新推荐文章于 2023-02-18 12:29:57 发布 · 187 阅读

0 ·

CC 4.0 BY-SA版权

数据挖掘专栏收录该内容

9 篇文章

订阅专栏

本文探讨了数据仓库设计的四个重要视角：顶层视图、数据源视图、数据仓库视图和业务查询视图。从数据源的捕获、存储和管理，到数据仓库内的事实表和维度表，再到满足最终用户需求的业务查询视图，文章详细介绍了每个视角的核心内容和作用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Four different views regarding the design of a data warehousemust be considered: the top-down view, the data source view, the data warehouse view, and the business query view.

The top-down view allows the selection of the relevant information necessary for the data warehouse. This information matches the current and future business needs.

The data source view exposes the information being captured, stored, and managed by operational systems. This information may be documented at various levels of detail and accuracy, from individual data source tables to integrated data source tables. Data sources are often modeled by traditional data modeling techniques, such as the entity-relationship model or CASE (computer-aided software engineering) tools.

The data warehouse view includes fact tables and dimension tables. It represents the information that is stored inside the data warehouse, including precalculated totals and counts, as well as information regarding the source, date, and time of origin, added to provide historical context.

Finally, the business query view is the perspective of data in the data warehouse from the viewpoint of the end user.