High Performance Levels Executed by Application & Database Servers

 
 

The processing is typically centralised and located near the database server or on the physical database server.  The database optionally contains processing and referential integrity rules.  However, the database always contains the data for the application. 

The SQL queries that manipulate the data are executed on the database server.  This architecture ensures minimal network traffic and that the application logic is executed on servers that ensure high performance levels are achieved.