Patent
1993-09-02
1998-10-06
Black, Thomas G.
395876, 39520003, 39520012, G06F 15163, G06F 1730, G06F 1314
Patent
active
058190830
ABSTRACT:
A method, system and program for distributing data to a first node in a parallel database system from a plurality of existing nodes. First, a minimal sufficient number of communication buffers necessary to guarantee that a table scan operation in each of the existing nodes will execute without stopping is determined. Once calculated, the minimal sufficient number of communication buffer is allocated in the memory associated with each of the existing nodes. Thus, data from each of the plurality of existing nodes to the first node can be redistributed without interruption. Unless the redistribution process has a default set of data to be redistributed, which data from which data tables in each of the plurality of existing nodes is to be distributed to the first node must be determined. The first node may either be a new node which must be registered within the parallel database system, or an existing node within an imbalanced parallel database system which has excess capacity. The minimal sufficient number of communication buffers is determined according to the ratio of a mean queuing in a communication buffer and an average time to fill a communication buffer.
REFERENCES:
patent: 4926324 (1990-05-01), Yamamoto et al.
patent: 5179662 (1993-01-01), Corrigan et al.
patent: 5339413 (1994-08-01), Koval et al.
Chen Wen-Tzer Thomas
Li Shih-Gong
Black Thomas G.
Choules Jack M.
Dillon Andrew J.
International Business Machines - Corporation
McBurney Mark E.
LandOfFree
Minimal sufficient buffer space for data redistribution in a par does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Minimal sufficient buffer space for data redistribution in a par, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Minimal sufficient buffer space for data redistribution in a par will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-91184