摘要 |
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.
|