Login| Sign Up| Help| Contact|

Patent Searching and Data


Title:
METHOD FOR RETRIEVING OVERLAPPING DATA BY HORIZONTAL DIVISION AND EXTRACTION IN DISTRIBUTED RELATION DATA BASE
Document Type and Number:
Japanese Patent JPH04303261
Kind Code:
A
Abstract:

PURPOSE: To reduce the transfer data volume for remote retrieval in a distributed relation data base where duplicate data exist by horizontal division extraction.

CONSTITUTION: When a horizontally divided partial copy exists in the distributed relation data base as shown in the figure and a system 2 requests data satisfying a condition C2 of T1 to a system 1, all data is not retrieved from T1, but data D1 satisfying the condition of the product between conditions C1 and C2 is retrieved from T2 of the system 2 by the system 2 and data D2 satisfying the condition of the product between NOT of the condition C1 and the condition C2 is requested to the system 1, and thereby, the transfer data volume of data D1 is reduced in comparison with retrieval of all data in the system 1. Consequently, the transfer data volume for remote retrieval is reduced to reduce the transfer cost and the response time.


Inventors:
TAKANO SATOSHI
Application Number:
JP9334391A
Publication Date:
October 27, 1992
Filing Date:
March 29, 1991
Export Citation:
Click for automatic bibliography generation   Help
Assignee:
NEC CORP
International Classes:
G06F15/16; G06F12/00; G06F15/177; G06F17/30; (IPC1-7): G06F15/16; G06F15/40
Attorney, Agent or Firm:
Nobuo Takahashi (5 others)