Detailed Structure of a TP Monitor input queue authorization lock manager application recovery manager servers log manager database and resource managers network output queue Database System Concepts-6th Edition 26.7 @Silberschatz,Korth and Sudarshan
Database System Concepts - 6 26.7 ©Silberschatz, Korth and Sudarshan th Edition Detailed Structure of a TP Monitor
Detailed Structure of a TP Monitor Queue manager handles incoming messages Some queue managers provide persistent or durable message queueing contents of queue are safe even if systems fails. Durable queueing of outgoing messages is important application server writes message to durable queue as part of a transaction once the transaction commits,the TP monitor guarantees message is eventually delivered,regardless of crashes. ACID properties are thus provided even for messages sent outside the database Many TP monitors provide locking,logging and recovery services, to enable application servers to implement ACID properties by themselves. Database System Concepts-6th Edition 26.8 @Silberschatz,Korth and Sudarshan
Database System Concepts - 6 26.8 ©Silberschatz, Korth and Sudarshan th Edition Detailed Structure of a TP Monitor Queue manager handles incoming messages Some queue managers provide persistent or durable message queueing contents of queue are safe even if systems fails. Durable queueing of outgoing messages is important application server writes message to durable queue as part of a transaction once the transaction commits, the TP monitor guarantees message is eventually delivered, regardless of crashes. ACID properties are thus provided even for messages sent outside the database Many TP monitors provide locking, logging and recovery services, to enable application servers to implement ACID properties by themselves
Application Coordination Using TP Monitors A TP monitor treats each subsystem as a resource manager that provides transactional access to some set of resources. The interface between the TP monitor and the resource manager is defined by a set of transaction primitives The resource manager interface is defined by the X/Open Distributed Transaction Processing standard. TP monitor systems provide a transactional remote procedure call (transactional RPC)interface to their service Transactional RPC provides calls to enclose a series of RPC calls within a transaction. Updates performed by an RPC are carried out within the scope of the transaction,and can be rolled back if there is any failure. Database System Concepts-6th Edition 26.9 @Silberschatz,Korth and Sudarshan
Database System Concepts - 6 26.9 ©Silberschatz, Korth and Sudarshan th Edition Application Coordination Using TP Monitors A TP monitor treats each subsystem as a resource manager that provides transactional access to some set of resources. The interface between the TP monitor and the resource manager is defined by a set of transaction primitives The resource manager interface is defined by the X/Open Distributed Transaction Processing standard. TP monitor systems provide a transactional remote procedure call (transactional RPC) interface to their service Transactional RPC provides calls to enclose a series of RPC calls within a transaction. Updates performed by an RPC are carried out within the scope of the transaction, and can be rolled back if there is any failure
☒无法显示该图片。 Workflow Systems Database System Concepts,6th Ed. Silberschatz,Korth and Sudarshan See www.db-book.com for conditions on re-use
Database System Concepts, 6th Ed. ©Silberschatz, Korth and Sudarshan See www.db-book.com for conditions on re-use Workflow Systems
Transactional Workflows Workflows are activities that involve the coordinated execution of multiple tasks performed by different processing entities. With the growth of networks,and the existence of multiple autonomous database systems,workflows provide a convenient way of carrying out tasks that involve multiple systems. Example of a workflow delivery of an email message,which goes through several mails systems to reach destination. Each mailer performs a tasks:forwarding of the mail to the next mailer. If a mailer cannot deliver mail,failure must be handled semantically (delivery failure message). Workflows usually involve humans:e.g.loan processing,or purchase order processing. Database System Concepts-6th Edition 26.11 ©Silberschat乜，Korth and Sudarshan
Database System Concepts - 6 26.11 ©Silberschatz, Korth and Sudarshan th Edition Transactional Workflows Workflows are activities that involve the coordinated execution of multiple tasks performed by different processing entities. With the growth of networks, and the existence of multiple autonomous database systems, workflows provide a convenient way of carrying out tasks that involve multiple systems. Example of a workflow delivery of an email message, which goes through several mails systems to reach destination. Each mailer performs a tasks: forwarding of the mail to the next mailer. If a mailer cannot deliver mail, failure must be handled semantically (delivery failure message). Workflows usually involve humans: e.g. loan processing, or purchase order processing