tailieunhanh - Lecture Database system concepts - Chapter 20: Database system architectures

The chapter is suitable for an introductory course. We recommend covering it, at least as self-study material, since students are quite likely to use the non-centralized (particularly client-server) database architectures when they enter the real world. The material in this chapter could potentially be supplemented by the two-phase commit protocol, to give students an overview of the most important details of non-centralized database architectures. | Chapter 20: Database System Architectures Version: Oct 5, 2006 Database System Concepts, 5th Ed. ©Silberschatz, Korth and Sudarshan See ­ for conditions on re­use Chapter 20: Database System Architectures s Centralized and Client­Server Systems s Server System Architectures s Parallel Systems s Distributed Systems s Network Types Database System Concepts ­ 5th Edition 20. ©Silberschatz, Korth and Sudarshan Centralized Systems s Run on a single computer system and do not interact with other computer systems. s 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. s Single­user system (., 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. s 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. Database System Concepts ­ 5th Edition 20. ©Silberschatz, Korth and Sudarshan A Centralized Computer System Database System Concepts ­ 5th Edition 20. ©Silberschatz, Korth and Sudarshan Client­Server Systems s .

• Cơ sở dữ liệu
• Database system concepts
• Lecture Database system concepts
• Database systems
• Database languages
• Database design
• Database system architectures
• Relational database design
• Recovery system
• Query optimization
• Transaction state
• Concurrency control
• Data analysis
• Information retrieval
• Parallel databases
• Distributed databases
• Advanced application development
• Advanced data types
• Advanced transaction processing
• Relational databases
• Relational model
• Basic query structure
• Dynamic SQL
• Tuple relational calculus
• Entity relationship model
• Application design
• Object­ based databases
• XML applications
• Physical storage media
• Static hashing
• Query processing