Microsoft® SQL Server 2012 Unleashed

OLTP Shopping Cart Example

This next example features an Internet-based e-commerce implementation for a global health and vitamin retailer. At the center of this high-availability application is the shopping cart and a global ordering and fulfillment capability. Concurrent users are approximately 5,000 to 10,000 at any one time, and this application supports up to 50 million hits per day. A key to this application is that it is “stateless” and all database calls are extremely simple and shallow. This web-facing application is built on a JRUN application server (from Adobe), uses Microsoft’s Internet Information Services (IIS), and features SQL Server at the database layer (as shown in Figure 3.3).

FIGURE 3.3 E-commerce Internet application with ...