Tuning Performance of Remotely Accessed Databases

Abstract

The large expansion in the use of networks, Internet and the huge development in the business of the international companies, has generated new types of applications which use remote databases (distributed databases or centralized databases) .These new applications add further load to the performance problem of the traditional databases, because of the use of networks and Internet This study attempts to tune the performance of the remotely accessed database. The research adopts the Web browsers in the client side (this is for its portability and reusability). The study suggests solutions to minimize the response time to reasonable limits. This solution is to design the application with three layers and distribute the work on them, this model lift out load of database and make it for read and write only. The model also make client not taking care about the mass of work which was making it very busy. The 3-tiers model consists of the following three layers: Client layer that is the Internet browser with its ability to cache client side pages. This enables it to recover from disconnections that may occur occasionally. The business layer has the facilities that make load balance at the times of high traffic. The end layer (database layer) is only responsible for read/write operations. This is achieved by removing authorization, authentication and verification from the database and putting them in the middle layer (business layers).