一个设计良好的数据仓库拥有由大量汇总表，形成一个“金字塔”，每个汇总表都包含更多细节，直到金字塔底部的事实表。
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.
用户应该能够从一个汇总表向下深入到另一个汇总表，最终达到事实表(如果事实表是他们需要的细节级别)。
Users should be able to drill down from one summary table into another summary table, ultimately arriving at the fact table (if that's the level of detail they need).
顶级汇总表可能拥有约100,000条记录，下一级汇总表有可能拥有数百万条记录。
Your top-level summary table may have about 100,000 records; the next-level summary table will probably have millions of records.
采用棋盘式总张账和科目汇总表代替总账的单位，年终结账，应当汇编一张全年合计的科目汇总表和棋盘式总账。
The chessboard type total bill and course summary table instead of general ledger units, closing entries, should a whole assembly course summary table and board ledger.
采用棋盘式总张账和科目汇总表代替总账的单位，年终结账，应当汇编一张全年合计的科目汇总表和棋盘式总账。
The chessboard type total bill and course summary table instead of general ledger units, closing entries, should a whole assembly course summary table and board ledger.
应用推荐