Chapter 9 The ClientServer Database Environment.ppt

Chapter 9: The Client/Server Database Environment Modern Database Management 7th Edition Jeffrey A. Hoffer, Mary B. Prescott, Fred R. McFadden Objectives Definition of terms List advantages of client/server architecture Explain three application components: presentation, processing, and storage Suggest partitioning possibilities Distinguish between file server, database server, 3-tier, and n-tier approaches Describe and discuss middleware Explain query-by-example (QBE) Explain database linking via ODBC and JDBC Explain VBA and Microsoft Access Client/Server Systems Networked computing model Processes distributed between clients and servers 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 Application Logic in C/S Systems Client/Server Architectures File Server Architecture Database Server Architecture Three-tier Architecture File Server Architecture All processing is done at the PC that requested the data Entire files are transferred from the server to the client for processing Problems: Huge amount of data transfer on the network Each client must contain full DBMS Heavy resource demand on clients Client DBMSs must recognize shared locks, integrity checks, etc. Two-Tier Database Server Architectures Client is responsible for I/O processing logic Some business rules logic Server performs all data storage and access processing ? DBMS is only on server Advantages of Two-Tier Approach Clients do not have to be as powerful Greatly reduces data traffic on the network Improved data integrity since it is all processed centrally Stored procedures ? some business rules done on server Advantages of Stored Procedures Compiled SQL statements Reduced network traffic Improved security Improved data integrity Thinner clients Three-Tier Architectures Advantages of Three-Tier Architectures Scalability Technological flexibility Long-term cost reduction Bet