TAILIEUCHUNG - Lecture Database system concepts (6/e): Chapter 26 - Silberschatz, Korth, Sudarshan

Chapter 26 - Advanced transaction processing. Topics covered in the chapter include transaction-processing monitors, transactional workflows, electronic commerce, high-performance transaction systems, real-time transaction systems, and long-duration transactions. | Chapter 26: Advanced Transaction Processing Database System Concepts, 6th Ed. ©Silberschatz, Korth and Sudarshan See for conditions on re-use Chapter 26: Advanced Transaction Processing Transaction-Processing Monitors Transactional Workflows High-Performance Transaction Systems Main memory databases Real-Time Transaction Systems Long-Duration Transactions Transaction management in multidatabase systems Database System Concepts - 6th Edition ©Silberschatz, Korth and Sudarshan Transaction Processing Monitors TP monitors initially developed as multithreaded servers to support large numbers of terminals from a single process. Provide infrastructure for building and administering complex transaction processing systems with a large number of clients and multiple servers. Provide services such as: Presentation facilities to simplify creating user interfaces Persistent queuing of client requests and server responses Routing of client messages to servers Coordination of two-phase commit when transactions access multiple servers. Some commercial TP monitors: CICS from IBM, Pathway from Tandem, Top End from NCR, and Encina from Transarc Database System Concepts - 6th Edition ©Silberschatz, Korth and Sudarshan TP Monitor Architectures Database System Concepts - 6th Edition ©Silberschatz, Korth and Sudarshan TP Monitor Architectures (Cont.) Process per client model - instead of individual login session per terminal, server process communicates with the terminal, handles authentication, and executes actions. Memory requirements are high Multitasking- high CPU overhead for context switching between processes Single process model - all remote terminals connect to a single server process. Used in client-server environments Server process is multi-threaded; low cost for thread switching No protection between applications Not suited for parallel or distributed .

• Cơ sở dữ liệu
• Database system
• Lecture Database system
• Relational databases
• Advanced transaction processing
• Transaction processing monitors
• Transactional workflows
• Database system concepts
• Lecture Database system concepts
• Database systems
• Database languages
• Database design
• Database system architectures
• Relational database design
• Database system architecture
• File based approach
• Data management systems framework
• Recovery system
• Lecture Database systems
• Database architecture
• Database approach
• Database design process
• Query optimization
• Transaction state
• Concurrency control
• Data analysis
• Information retrieval
• Parallel databases
• Distributed databases
• Advanced application development
• Advanced data types
• Relational model
• Basic query structure
• Dynamic SQL
• Tuple relational calculus
• Entity relationship model
• Application design
• Object­ based databases