摘要:
A system and method for balancing database transaction request distribution between various hosts in a multiprocessor transaction processing system is provided. The transaction processing system includes a database and multiple host processors each coupled to at least one database transaction request unit. Database transaction requests sent from the host processors are collectively entered into a commonly-accessible load balancing queue. Each database transaction request is accompanied by a source identifier that identifies the database transaction request unit which initiated the corresponding database transaction request. The queued database transaction requests from the load balancing queue are processed by currently-available host processors, regardless of which host processor initiated the database transaction request. A transaction request acknowledgment for each of the processed transaction requests is created and transferred to the database transaction request unit identified by their respective source identifiers.
摘要:
A system and method for providing transaction indivisibility in a transaction processing system through the use of commonly-accessible modules for monitoring and maintaining proper source message sequencing is provided. A source message is transmitted from the host processing unit upon recovery of a failure of the host processing unit, where the source message includes information destined for the database, and an identifying sequence number. The identifying sequence number is compared to a stored sequence number, where the stored sequence number is associated with an immediately preceding source message received prior to the failure of the host processing unit. A source message indivisibility failure is indicated where the identifying sequence number is not consecutive with respect to the stored sequence number, while the source message is added to a message execution queue if the identifying sequence number is consecutive with respect to the stored sequence number.
摘要:
A system and method for organizing and managing recovery information on a per-transaction basis using distinct memory structures is provided. A transaction processing system includes one or more transaction request units for initiating data transactions with a database. A memory architecture includes storage modules to store transaction recovery information that is used in recovering from a transaction processing failure, and further includes transaction descriptor memory structures each of which correspond to a distinct transaction. The transaction descriptors allow access to the transaction recovery information to be isolated from other transaction recovery information. A control information field in each transaction descriptor stores a transaction identifier that identifies the distinct transaction to which it corresponds. The transaction descriptor also includes multiple information address fields, each of which includes a pointer to one of the storage modules that stores part of the transaction recovery information associated with the transaction identifier.
摘要:
A system and method for assembling database restoration data according to transaction in a transaction processing system. Database restoration data is collated by chronologically storing updated database records in distinct storage banks partitioned according to its corresponding transaction. Resulting database record blocks from storage banks associated with completed database transactions are queued in the order that their corresponding transactions were completed. The queued database record blocks are transferred to storage media, whereby the queued database record blocks are arranged on the storage media according to transaction, and in the order that the active transactions were completed.