Stephen W Schaefle

US Patent:

56757840, Oct 7, 1997

Filed:

May 31, 1995

Appl. No.:

8/454708

Inventors:

John E. Maxwell - Claredon Hills IL
Donald J. McDowell - Wheaton IL
Stephen W. Schaefle - Wheaton IL

Assignee:

International Business Machnes Corporation - Armonk NY

International Classification:

G06F 1760
G06F 1730

US Classification:

395611

Abstract:

A relational database system allows users to search for specific products based on component criteria. The relational database system allows for unlimited number and type of components to be associated with products and employs a data architecture that enforces consistent product data including consistent description format among like products and consistent component descriptions whenever components are used in products. Product and component specification data is arranged in such a way as to allow users to search for specific products based on component criteria. The structure allows for an unlimited number and type of components to be associated with products and can accommodate future technologies that are not yet identified. The database system employs a series of tables having relationships that promote consistency, accuracy and ease of use by employing selection lists wherever data redundancy is possible. The database system automatically concatenates product descriptions using a component table.