Transaction Server Process Structure A typical transaction server consists of multiple processes accessing data in shared memory Shared memory contains shared data ·Buffer pool ·Lock table ·Log buffer Cached query plans (reused if same query submitted again) All database processes can access shared memory ■Server processes These receive user queries (transactions),execute them and send results back Processes may be multithreaded,allowing a single process to execute several user queries concurrently Typically multiple multithreaded server processes Database System Concepts-7th Edition 20.7 ©Silberscha乜，Korth and SudarshanDatabase System Concepts - 7 20.7 ©Silberschatz, Korth and Sudarshan th Edition Transaction Server Process Structure ▪ A typical transaction server consists of multiple processes accessing data in shared memory ▪ Shared memory contains shared data • Buffer pool • Lock table • Log buffer • Cached query plans (reused if same query submitted again) ▪ All database processes can access shared memory ▪ Server processes • These receive user queries (transactions), execute them and send results back • Processes may be multithreaded, allowing a single process to execute several user queries concurrently • Typically multiple multithreaded server processes