Database system facilitating parametric searching

专利名称：Database system facilitating parametric

searching

发明人：Steven C. Bailey,Stephen W. Blessin,Allen E.

Detmer

申请号：US10052668申请日：20020118

公开号：US20020087558A1公开日：20020704

专利附图：

摘要：In one aspect of the invention, a computer-implemented database system ()includes a first table () including rows each corresponding to a keyword and each

including an identifier uniquely identifying the keyword. Each keyword corresponds toone or more items for which a parametric search may be performed. A second table ()includes rows each corresponding to an attribute of one or more items and eachincluding an identifier uniquely identifying the attribute and a name of the attribute. Athird table () includes rows each corresponding to a keyword-attribute combination andeach including the identifier for the keyword, the identifier for the attribute, and a set ofall valid attribute values for this combination. A fourth table () includes rows eachcorresponding to an item and each including an identifier uniquely identifying the item, aname for the item, and the identifier for the keyword for the item. A fifth table () includesrows each corresponding to an attribute value of an attribute of an item and eachincluding the attribute value, the identifier for the attribute, the identifier for the item,and the identifier for the keyword for the item.

申请人：CATERPILLAR INC.

更多信息请下载全文后查看