Login| Sign Up| Help| Contact|

Patent Searching and Data


Title:
METHOD FOR CONNECTING DATA BASE RELATIONS
Document Type and Number:
Japanese Patent JP03126169
Kind Code:
A
Abstract:

PURPOSE: To make total execution time for naturally connecting two relations minimum by dividing a connection operation into different jobs and scheduling the jobs in optimum among plural processors.

CONSTITUTION: The first relation is divided into plural partitions and the second relation is divided into plural partitions corresponding to them. The execution time of the respective jobs is shortened to be less than 1/P of whole execution time so that the present set of the jobs constituted by tasks connecting the respective partitions with the corresponding partitions fits to one processor. When estimated skew quantity fits to standard skew quantity, the present set of the jobs which are scheduled last is executed by using P processors and the two data base relations are connected with the minimum completion time skew on a common field. Thus, whole execution time for naturally connecting the two relations can be set to a minimum.


Inventors:
Dias, Daniel M.
Wolf, Joel L.
YU, Philip S.
Application Number:
JP1990000217257
Publication Date:
May 29, 1991
Filing Date:
August 20, 1990
Export Citation:
Click for automatic bibliography generation   Help
Assignee:
INTERNATL BUSINESS MACH CORP
International Classes:
G06F15/16; G06F9/50; G06F12/00; G06F15/177; G06F17/30; (IPC1-7): G06F12/00; G06F15/16; G06F15/40