Candidate architecture
We are looking at a single candidate for this solution. While the Windows Server AppFabric Cache is the best choice for this scenario, we will also discuss the alternatives for accessing reference data.
Candidate architecture #1 Windows Server AppFabric Cache
Usage of distributed caching technology is common when implementing this pattern. Before talking about it, let us look at a couple of other options available database servers and ASP.NET (session and application caching). Let us use the data from the use case and key requirements to see how the options stack up.
In large enterprises, SQL Server or any database server is a huge investment used by many critical applications. In this pattern, the reference data could be accessed repeatedly from the database tables which may become inefficient and obtrusive to other transaction processing systems sharing the database instance or the network. As we have seen in the previous section, when the workload is essentially...