International Business Machines Corporation

Francisco J Bermudez

Vijayshankar Raman

Gopi K Attaluri

Alan Tsu-I Yaung

Ganesh Vaideeswaran

Embodiments relate to an immediate join spilling scheme for a database. An aspect includes receiving a command to perform a join of an inner table and an outer table in a database. Another aspect includes spilling a plurality of hash tables to a disk memory, each hash table corresponding to a respective inner table partition. Another aspect includes registering, by a first agent of a plurality of agents, a set of inner table partitions that require processing by the first agent to complete the join for a first stride of rows of the outer table. Another aspect includes, based on determining that a hash table corresponding to a registered inner table partition of the first agent has been loaded into the local memory by the second agent of the plurality of agents, performing the join of the loaded hash table and the first stride of rows of the outer table by the first agent.

Immediate join spilling scheme for a database

A method and system employing an object-oriented approach to remotely controlling storage management services in a content management system. An Application Programming Interface (API) is used to communicate between a system administrator client and a resource manager, so that a system administrator can, e.g., start and stop services, check the status of services, etc. The API and resource manager exchange information, for example by exchanging XML documents by HTTP posting.

Growing community of inventors

Milpitas, CA, United States of America

Francisco J Bermudez