BAM - RTA和预定聚合之间的差异 [英] BAM - Difference between RTA and Scheduled Aggregation

问题描述

大家好，

我试图了解两者的区别（RTA和预定）。

I am trying to understand the difference the two (RTA and Scheduled).

1）什么SSIS包针对RTA而不是SSIS包对预定聚合做了什么？ （是否有任何命名对话？），对于Scheduled，它以BAM_AN_开始计划，BAM_DN_为RTA？

1) What does the SSIS package do for RTA over the SSIS package do for Scheduled Aggregation? (Is there any naming convetion?) like for Scheduled it starts with BAM_AN_ for scheduled and BAM_DN_ for RTA?

2）BAMStarSchema DB用作仅用于计划聚合的交错数据库而不使用对于RTA？

2) BAMStarSchema DB is used as the stagging DB for only Scheduled Aggregation and not used for RTA?

谢谢你

SKGuru

推荐答案

1）SSIS包为什么做SSIS包上的RTA是否用于预定聚合？ （是否有任何命名对话？），对于预定，它以BAM_AN_开始计划，BAM_DN_为RTA？ - >

1) What does the SSIS package do for RTA over the SSIS package do for Scheduled Aggregation? (Is there any naming convetion?) like for Scheduled it starts with BAM_AN_ for scheduled and BAM_DN_ for RTA?-->

维度和度量可用于定义实时或计划的聚合。计划的聚合表示活动视图的时间快照。为了执行度量和维度所需的所有计算，这种类型的聚合
计划根据特定的时间间隔运行。

Dimensions and measures can be used to define real-time or scheduled aggregations. A scheduled aggregation represents a time snapshot of an activity view. In order to execute all the calculations required for the measures and dimensions, this type of aggregation is scheduled to run based on specific time intervals.

2）BAMStarSchema数据库用作仅用于预定聚合的交错数据库而不用于RTA？

2) BAMStarSchema DB is used as the stagging DB for only Scheduled Aggregation and not used for RTA?

计划的聚合数据模型基于存储在BAMAnalysis数据库中的一组多维结构，这些结构也基于存储在BAMStarSchema数据库中的星型模式关系拓扑

The scheduled aggregation data model is based on a set of multidimensional structures stored in the BAMAnalysis database, which are also based on a star schema relational topology stored in the BAMStarSchema database

我建议你参考
开发人员深度的业务活动监控  msdn page。它详细包含了您上述所有查询的答案。

I would suggest you to refer Business Activity Monitoring in Depth for Developers msdn page. It contains answers of all your above queries in detail.

我希望它有所帮助

这篇关于BAM - RTA和预定聚合之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！