Although you can process your application data on the client side in the case of Oracle database, there are many advantages of processing data inside the database. From a performance standpoint, moving processing to the data allows you to:

• Reduce the communication overhead between the web server and the database
• Conserve the web server resources
• Take advantage of optimizations and indexing techniques provided by the Oracle database

By using triggers and stored procedures, you can develop an application whose business logic resides entirely inside the database. Moving data processing to the database tier is particularly useful if your application is database intensive. This is because your application doesn’t need to transfer a large amount of data between tiers while processing data inside the database; instead, it sends only the final product across the wire.