Summary tables are required in a data warehouse for fast query processing and to allow users to drill up and down into the facts.
在数据仓库中需要汇总表,来实现快速查询,并允许用户在事实表中钻入钻出。
Summary tables are an important part of creating a high-performance data warehouse.
汇总表是创建高性能数据仓库的重要部分。
A well-designed data warehouse has a pyramid of summary tables, each one containing more detail until you arrive at the fact table, at the bottom of the pyramid.
一个设计良好的数据仓库拥有由大量汇总表,形成一个“金字塔”,每个汇总表都包含更多细节,直到金字塔底部的事实表。
应用推荐