Database Reference
In-Depth Information
Figure 2-13.
Transparent branching + RWS patterns
Cascading Aggregation
In cascading aggregation (see Figure 2-14), the aggregation pattern is applied serially to generate a
summary database. The mechanism to copy (or move) data from one SQL Azure database to another
must be accomplished using a high-level process, such as a worker process in Windows Azure.
For example, this pattern can be used to collect information from multiple SQL Azure databases
into a single one used by a third party to monitor overall performance. A Windows Azure worker process
can run a performance view provided by SQL Azure and store the data into another database. Although
the SQL Azure databases being monitored for performance may have a totally different schema, the
output of SQL Azure's performance data management view (DMV) is consistent. For example, the
monitoring service can call
sys.dm_exec_connections
to monitor connection activity in various SQL
Azure databases every 5 minutes and store the result in a separate SQL Azure database.
Figure 2-14.
Aggregation + MMS patterns
