The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 16, 2004
Filed:
Jan. 18, 2002
Steven C. Bailey, Washington, IL (US);
Stephen W. Blessin, Peoria, IL (US);
Allen E. Detmer, Patriot, IN (US);
i2 Technologies US, Inc., Dallas, TX (US);
Abstract
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 to one 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 each including an identifier uniquely identifying the attribute and a name of the attribute. A third table ( ) includes rows each corresponding to a keyword-attribute combination and each including the identifier for the keyword, the identifier for the attribute, and a set of all valid attribute values for this combination. A fourth table ( ) includes rows each corresponding to an item and each including an identifier uniquely identifying the item, a name for the item, and the identifier for the keyword for the item. A fifth table ( ) includes rows each corresponding to an attribute value of an attribute of an item and each including the attribute value, the identifier for the attribute, the identifier for the item, and the identifier for the keyword for the item.