Databases Reference
In-Depth Information
Figure 2-13.
Transparent branching + RWS patterns
This pattern offers the following advantages:
•
Transparent data transfer.
In this case, the transparent branching pattern copies an existing
application's data into cloud databases without changing a single line of code in the existing
application.
•
High performance.
To ensure high performance and throughput, the round-robin shard
pattern is used along with asynchronous calls into the cloud.
•
Scalable.
When using a shard, it's very simple to expand it by adding a new SQL Database
instance into the cloud. If implemented correctly, the shard automatically detects the new
database and storage capacity, and throughput automatically increases.
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 Database instance to another must be accomplished
using a high-level process, such as a worker process in Windows Azure.
