Microsoft Access 2010 Bible

Part VI: Access as an Enterprise Platform

1192

FIGURE 36.5

Web and application server computers manage back-end server access.

Peripherals

Lots of client

computers

Application

server computer

Web server

computer

Database

Reports

Thousands of Internet users

An application server is less often used for connection pooling than Web servers are because the

number of connections is much reduced. An application server is better suited for maintaining fre-

quently used data in a dedicated computer, in addition to managing load balancing.

Making Sense of Multi-Tier Architecture

Database systems can be thought of as consisting of three major components: the data, the busi-

ness logic that determines how data is handled by the application, and a user interface that inter-

acts with the user. Each of these three components is a tier of a multitier system.