International Business Machines Corporation

Herbert Walter Pereyra

David C Kalmuk

Jack Hon Wai Ng

Calisto Paul Zuzarte

Matthew Albert Huras

Mark Francis Wilding

Xun Xue

Jeffrey James Goss

Kaarel Truuvert

John Paul Kennedy

Victor Muntes-Mulero

Josep L Lariba-Pey

Josep Aguilar-Saborit

Cheuk Lun Lam

Disclosed is a data processing system, and an article of manufacturing for use with the data processing system. The data processing system joins rows associated with a column of a source table with rows associated with a column of a target table. The data processing system includes a source node containing the source table and including a target node containing the target table. The data processing system further includes a generating module for generating a reduced representation of selected rows associated with the column of the source table, and generating a representation of the column of the target table, a filtering module for filtering the generated reduced representation of selected rows associated with the column of the source table through the generated representation of the column of the target table, the filtered generated reduced representation of selected rows identifying source table rows that do not have to be joined with the target table, and a joining module for joining, to the rows associated with the column of the target table, the rows associated with the column of the source table minus the filtered generated reduced representation of selected rows.

System and program for joining source table rows with target table rows

A method, system and computer program product for an asynchronous interconnection between nodes of a clustered database management system (DBMS). Node timestamps are provided when each of the nodes in the cluster are started. Two or more communication conduits are established between the nodes. Each communication conduit between a local node and a remote node has an associated session identifier. The session identifiers and the timestamp from the remote node are associated to each communication conduit and the associated local node in the cluster. A timestamp is received from the remote node at the local node when establishing communication to determine if the remote node corresponds to the remote node incarnation identified by the timestamp and if DBMS communication between nodes can be initiated.

Asynchronous interconnect protocol for a clustered DBMS

A database management system in which a plurality of nodes form a database instance, each node including a communication manager for dynamically configuring inter-nodal communication resources. The communication manager receives communication resource allocation requests from clients or a self-tuning algorithm. A resource self-tuning mechanism allocates or de-allocates memory blocks used for communication resource elements dynamically in real time without cycling the instance. Memory blocks are de-allocated asynchronously by placing associated communication resource elements in quarantine until all communication resource elements associated with the memory block are quarantined.

Dynamic configuration and self-tuning on inter-nodal communication resources in a database management system

A reservation system for making reservations in a shared memory buffer to store information from applications is logically partitioned in a number of fixed size indexed contiguous slots. The reservation system uses an atomic counter that is stored in the shared memory buffer. The value of the atomic counter can be associated with the index of a slot available for reservation. An application making a reservation increases the atomic counter value on a number of reserved slots to provide a value that is associated with the index of the next slot available for reservation. After the reservation is accomplished, the information is written into the reserved slots. The reservation system writes parsing information for further parsing to validate information in the shared memory buffer. The reservation system provides functionality for continuous and instantaneous dumping of the shared memory buffer into a file for cleaning and for wrapping the buffer.

Reduced synchronization reservation system and method for a shared memory buffer

Growing community of inventors

Toronto, Canada

Herbert Walter Pereyra