ch20 - Chapter 20: Database System Architectures Database...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Database System Concepts, 5th Ed . ©Silberschatz, Korth and Sudarshan See www.db-book.com for conditions on re-use Chapter 20: Database System Architectures Chapter 20: Database System Architectures
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 20.2 Database System Concepts - 5 th Edition, Aug 22, 2005. Chapter 20: Database System Architectures Chapter 20: Database System Architectures Centralized and Client-Server Systems Server System Architectures Parallel Systems Distributed Systems Network Types
Background image of page 2
©Silberschatz, Korth and Sudarshan 20.3 Database System Concepts - 5 th Edition, Aug 22, 2005. Centralized Systems Centralized Systems Run on a single computer system and do not interact with other computer systems. General-purpose computer system: one to a few CPUs and a number of device controllers that are connected through a common bus that provides access to shared memory. Single-user system (e.g., personal computer or workstation): desk-top unit, single user, usually has only one CPU and one or two hard disks; the OS may support only one user. Multi-user system: more disks, more memory, multiple CPUs, and a multi-user OS. Serve a large number of users who are connected to the system vie terminals. Often called server systems.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 20.4 Database System Concepts - 5 th Edition, Aug 22, 2005. A Centralized Computer System A Centralized Computer System
Background image of page 4
©Silberschatz, Korth and Sudarshan 20.5 Database System Concepts - 5 th Edition, Aug 22, 2005. Client-Server Systems Client-Server Systems Server systems satisfy requests generated at m client systems, whose general structure is shown below:
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 20.6 Database System Concepts - 5 th Edition, Aug 22, 2005. Client-Server Systems (Cont.) Client-Server Systems (Cont.) Database functionality can be divided into: Back-end : manages access structures, query evaluation and optimization, concurrency control and recovery. Front-end : consists of tools such as forms , report-writers , and graphical user interface facilities. The interface between the front-end and the back-end is through SQL or through an application program interface.
Background image of page 6
©Silberschatz, Korth and Sudarshan 20.7 Database System Concepts - 5 th Edition, Aug 22, 2005. Client-Server Systems (Cont.) Client-Server Systems (Cont.) Advantages of replacing mainframes with networks of workstations or personal computers connected to back-end server machines: better functionality for the cost flexibility in locating resources and expanding facilities better user interfaces easier maintenance
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 20.8 Database System Concepts - 5 th Edition, Aug 22, 2005. Server System Architecture
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/17/2010 for the course ACS ACS-3911 taught by Professor Chen during the Spring '10 term at Windsor.

Page1 / 37

ch20 - Chapter 20: Database System Architectures Database...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online