ch20 - Chapter20:DatabaseSystemArchitectures...

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  Version: Oct 5, 2006
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.<number> Database System Concepts - 5 th  Edition 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.<number> Database System Concepts - 5 th  Edition 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.<number> Database System Concepts - 5 th  Edition A Centralized Computer System A Centralized Computer System
Background image of page 4
©Silberschatz, Korth and Sudarshan 20.<number> Database System Concepts - 5 th  Edition 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.<number> Database System Concepts - 5 th  Edition 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.<number> Database System Concepts - 5 th  Edition 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.<number>
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.

Page1 / 37

ch20 - Chapter20:DatabaseSystemArchitectures...

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