TheClientServerDatabaseEnvironment.pptVIP

The Client/Server Database Environment CS263 Lecture 12 Client/Server systems Operate in a networked environment Processing of an application distributed between front-end clients and back-end servers Generally the client process requires some resource, which the server provides to the client Clients and servers can reside in the same computer, or they can be on different computers that are networked together, usually: Client – Workstation (usually a PC) that requests and uses a service Server – Computer (PC/mini/mainframe) that provides a service. For DBMS, server is a database server Three components of application logic Client/Server architectures File Server Architecture Database Server Architecture Three-tier Architecture File server architecture The first client/server architectures developed All processing is done at the PC that requested the data, I.e. the client handles the presentation logic, the processing logic and much of the storage logic A file server is a device that manages file operations and is shared by each of the client PCs attached to the LAN Each file server acts as an additional hard disk for each of the client PCs Each PC may be called a FAT CLIENT (most processing occurs on the client) Entire files are transferred from the server to the client for processing. Three problems with file server architecture Three problems with file server architecture Database server architectures After the file-server approach came two-tiered approaches Client is responsible for managing user interface, I/O processing logic, data processing logic and some business rules logic (front-end programs) Database server performs all data storage and access processing (back-end functions) – DBMS is only on server Advantages include:Clients do not have to be as powerful, only the database server requires processing power adequate to handle the database – therefore the server can be tuned to optimise data processing performance Greatly reduces data traffic on the ne