With a database server, these commands do not have to be transmitted over the network, since they are handled locally. A database server provides better data integrity. This is not possible with the file server model. Because a database server is intelligent, it can shorten the application development cycle and allow applications to execute faster. One method is stored procedures.
Stored procedures are short programs that reside on the server, waiting to be executed.
Any front-end can call the stored procedures. This saves programmers from including redundant code segments in every application. It also saves memory in the workstation. Each database server has its own access methods that the front-ends must use because of different types of SQL used as well as differences in transport protocols. The result is that applications written to work on one database server will not work on another.