多维数据集处理如何内部工 [英] How cube processing works internally?

问题描述

大家好，

任何人都可以建议好的材料/教程/博客，了解'立方体过程'如何在内部工作，就像它从数据库中获取数据，将其绑定到多维数据集结构，聚合等？从DB获取数据时，其他东西并行处理..

Can anyone please suggest good material /tutorial/blogs on how 'cube process' work internally like how it fetch data from DB, binding it to cube structure, aggregations etc.? while fetching data from DB , what other stuff process in parallel..

问候，

推荐答案

如数据源视图中所指定，它从源系统的相关表中提取数据，然后根据您在内部设置的关系执行所需的连接操作立方体。然后根据您的度量值组应用所需的聚合，并在
上应用您在其中添加的任何自定义计算。最后它还添加了所需的索引。

As specified in data source view, it pulls data from relevant tables of your source system and then does required join operations based on the relationships you set inside cube. Then it apply required aggregations as per your measure groups and applies on it any custom calculations you've added inside. Finally it adds required indexes too.

所有这些只有在您选择存储模型为MOLAP或HOLAP时才会发生。 ROLAP只是单独构建结构，但数据本身只驻留在关系数据库中。

All these happens only if you chose storage model as MOLAP or HOLAP. ROLAP just builds the structure alone but data itself will reside only in the relational db.

这篇关于多维数据集处理如何内部工的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！