Densely grouping dimensional data

Densely grouping dimensional data and/or aggregating data uses a data structure, such as one that is constructed based on dimensional data. When smaller tables are joined with a larger table, a server may analyze the smaller tables first to determine actual value combinations that occur in the smaller tables, and these actual value combinations are used to more efficiently process the larger table. A dense data structure may be generated by processing dimensional data before processing data from fact table. The dense data structure may be generated by compressing ranges of values that are possible in dimensions into a range of values that actually occurs in the dimensions. The compressed range of values may be represented by dense set identifiers rather than the actual compressed range of values. 密集分组维度数据和/或聚合数据使用数据结构，诸如基于维度数据构造的数据结构。当较小的表与较大的表连接时，服务器可以首先分析较小的表，以确定在较小的表中出现的实际值组合，并且这些实际值组合被用来更高效地处理较大的表。密集数据结构可以通过在处理来自事实表的数据之前处理维度数据来生成。密集数据结构可以通过将在维度中可能的值范围压缩到在维度中真正出现的值范围来生成。压缩的值范围可以由密集集合标识符而不是真正压缩的值范围来表示。