Balanced input/output task management for use in multiprocessor transaction processing system
First Claim
1. A method for balancing database transaction request distribution in a transaction processing system having a database, and a plurality of host processors each coupled to one or more database transaction request units, the method comprising:
- collectively entering database transaction requests sent from each of the host processors into a commonly-accessible load balancing queue, wherein each database transaction request is accompanied by a source identifier identifying the database transaction request unit that initiated the corresponding database transaction request;
processing queued database transaction requests from the commonly-accessible load balancing queue by available ones of the host processors;
creating a transaction request acknowledgment for each of the queued database transaction requests which are processed; and
transferring the transaction request acknowledgments to the database transaction request unit identified by their respective source identifiers.
12 Assignments
0 Petitions
Accused Products
Abstract
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.
127 Citations
24 Claims
-
1. A method for balancing database transaction request distribution in a transaction processing system having a database, and a plurality of host processors each coupled to one or more database transaction request units, the method comprising:
-
collectively entering database transaction requests sent from each of the host processors into a commonly-accessible load balancing queue, wherein each database transaction request is accompanied by a source identifier identifying the database transaction request unit that initiated the corresponding database transaction request; processing queued database transaction requests from the commonly-accessible load balancing queue by available ones of the host processors; creating a transaction request acknowledgment for each of the queued database transaction requests which are processed; and transferring the transaction request acknowledgments to the database transaction request unit identified by their respective source identifiers. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
-
-
18. A multiprocessor system for managing database transaction requests from a plurality of input/output (I/O) devices, comprising:
-
a plurality of host processing units each coupled to at least one of the plurality of I/O devices to receive the database transaction requests; a task management system coupled to each of the plurality of host processing units to process the database transaction requests from the plurality of host processing units, the task management system comprising; a load balancing queue coupled to each of the host processing units to collectively queue the database transaction requests from each of the plurality of host processing units; a plurality of input message queues, each coupled to a respective one of the host processing units and to the load balancing queue; and wherein an available one of the host processing units transfers a next available one of the database transaction requests from the load balancing queue to its corresponding input message queue for processing by the available host processing unit. - View Dependent Claims (19, 20, 21, 22, 23, 24)
-
Specification