International Business Machines Corporation

Kirk Allan Fritsche

Michael Albert Perks

Mark D Nielsen

Patrick Edward Nogay

A method, a system, an apparatus, and a computer program product are presented for reducing synchronization waits when unique sequential identifiers are being allocated for transactions committed to a database that are occurring in a multi-threaded server environment. A transactional object containing an identifier data item is created for a transaction in an object-oriented environment. A pre-process object is then generated that contains the transactional object; when subsequently processed, the pre-process object allocates a sequential identifier value for the identifier data item. The pre-process object is added to a list of pre-process objects that are to be processed prior to completing the transaction, such as committing the transaction to a database. After some initial business logic processing, a commit operation for the transaction is commenced during which the pre-process object is processed, thereby allocating a sequential identifier value for the identifier data item just prior to committing the transaction.

Method and system for reducing synchronization waits when allocating sequenced identifiers in a multi-threaded server

A method and system are described in a data processing system including a database for efficiently retrieving copies of data rows from the database. Query criteria is received by a server from a client which specifies search criteria describing data rows and which requests a particular number of the data rows to return. Each of the data rows is associated with a unique primary key which uniquely identifies a particular data object. The primary key for each of the data rows meeting the specified criteria is first retrieved from the database by the server. Thereafter, copies of only the particular number of the data rows are retrieved from the database using the primary keys. Copies of only the particular number of data rows are then returned to the requesting client.

Growing community of inventors

Cedar Park, TX, United States of America

Kirk Allan Fritsche