公开(公告)号：JPH1125096A

公开(公告)日：1999-01-29

申请号：JP16844596

申请日：1996-06-07

Applicant: TANDEM COMPUTERS INC

Inventor： LESLIE HARRY A ,  BIRDSALL DAVID W ,  JAIN ROHIT N ,  YAGHMAI HEDIEH

IPC: G06F12/00 ,  G06F17/30

Abstract: PROBLEM TO BE SOLVED: To efficiently and easily search a data base by designating the range and IN list of many key columns, and constructing each search key by a user. SOLUTION: A computer system 100 is a distributed computer system which is provided with plural computers 102, 104, and 106 mutually connected through a local area network medium and a wide area network medium 108. The value of a predicate designated by a search question is evaluated. The value of the equivalent range is assigned to a key column corresponding to each value of each predicate designated as the value of one range. Also, the value of the equivalent range is assigned to a key column corresponding to each value of each predicate designated as the value of an IN list. Moreover, the value of a certain range is assigned to a key column corresponding to each value of each non-designated predicate. Thus, each search key can be constructed by using those values to be assigned.