INEQUALITY SIGN CONDITION CONNECTION SYSTEM FOR RELATED DATA BASE SYSTEM

摘要

PURPOSE:To shorten the overall processing time by obtaining a pair of record Nos having different column values based on an assembly of record Nos and the pairs of record Nos. CONSTITUTION:A retrieving request input means 1 is provided together with a retrieving result output means 2, an inequality sign condition connection means 3, an equal sign condition connection means 4, a record No acquiring means 5, an input/output control means 6, a secondary storage 7, and a data base 8. Then a record No assembly 1 consisting of the Nos of all records included in a table 1 is obtained together with a record No assembly 2 consisting of the Nos of all record included in a table 2. The pairs of record Nos of tables 1 and 2 including the pairs of same values of columns 1 and 2. Based on these pairs of record Nos, a pair of record Nos including the unequal values of both columns 1 and 2 is obtained. As a result, the comparing frequency can be reduced between the values of columns 1 and 2. Then it is possible to shorten the processing time required for production of a pair of desired record Nos.