Data structure for a relational database system for collecting component and specification level data related to products
First Claim
1. A computer implemented electronic catalog database method for collecting component and specification level data related to products in a manner that permits cataloging and managing large quantities of product data in an efficient manner, said method being implemented on a digital computer including a display device and running system software interfacing with a database manager to generate screens on said display device and comprising the steps of:
- classifying data in a three tiered hierarchical data structure consisting of domains, classes and subclasses, domains being a highest level of the hierarchical data structure and each domain having its own group of classes, each class having its own group of subclasses, and each subclass having a specific set of components, all products in a subclass having these components, components in a subclass having attributes;
defining component groups for subclasses and defining a component order within each subclass in a series of tables, each table having at least one primary key field and a junction table having a plurality of fields;
linking attributes with components, the attributes having specification values and units of measure associated with them, and linking components to products using the junction tables of the series of tables;
storing the linked tables on a storage device of a digital computer having a database manager programmed and arranged to manage said data in the linked tables to allow users to input and search for specific products based on component criteria, wherein the linked tables stored on the storage device form a data structure including a product domain table, data input in said product domain table identifying product domains, each said product domain being linked to a product table, data input in said product table identifying manufactured or published products by part number and description or a service by an offering number and description, said descriptions being formatted according to concatenation rules, said product table being linked to a component table containing component information, a pricing table containing pricing and leasing information, and a warranty table containing warranty information; and
generating a screen on which a user selects a domain, a class and a subclass to input and to search data in the linked tables, said database manager allowing a user to search products meeting a particular criteria including a criteria defined by logical operators, wherein data entered in the component table includes pre-defined, standard component types with filled-in specification values such that when product components and product component specifications are added, said method allowing a user to choose from a list of common components to copy thereby promoting efficiency and data integrity, said component table further being linked to a component specification table which includes information on the predefined, standard component types with filled-in specification values and to a component group specification type usage table which contains information associating subclass component types to subclass component type specification types.
1 Assignment
0 Petitions
Accused Products
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. The relational database system allows mathematical additions of component values, such as cumulative system memory accumulated over a period of time, via the use of a unit of measure table and measurement group table.
196 Citations
12 Claims
-
1. A computer implemented electronic catalog database method for collecting component and specification level data related to products in a manner that permits cataloging and managing large quantities of product data in an efficient manner, said method being implemented on a digital computer including a display device and running system software interfacing with a database manager to generate screens on said display device and comprising the steps of:
-
classifying data in a three tiered hierarchical data structure consisting of domains, classes and subclasses, domains being a highest level of the hierarchical data structure and each domain having its own group of classes, each class having its own group of subclasses, and each subclass having a specific set of components, all products in a subclass having these components, components in a subclass having attributes; defining component groups for subclasses and defining a component order within each subclass in a series of tables, each table having at least one primary key field and a junction table having a plurality of fields; linking attributes with components, the attributes having specification values and units of measure associated with them, and linking components to products using the junction tables of the series of tables; storing the linked tables on a storage device of a digital computer having a database manager programmed and arranged to manage said data in the linked tables to allow users to input and search for specific products based on component criteria, wherein the linked tables stored on the storage device form a data structure including a product domain table, data input in said product domain table identifying product domains, each said product domain being linked to a product table, data input in said product table identifying manufactured or published products by part number and description or a service by an offering number and description, said descriptions being formatted according to concatenation rules, said product table being linked to a component table containing component information, a pricing table containing pricing and leasing information, and a warranty table containing warranty information; and generating a screen on which a user selects a domain, a class and a subclass to input and to search data in the linked tables, said database manager allowing a user to search products meeting a particular criteria including a criteria defined by logical operators, wherein data entered in the component table includes pre-defined, standard component types with filled-in specification values such that when product components and product component specifications are added, said method allowing a user to choose from a list of common components to copy thereby promoting efficiency and data integrity, said component table further being linked to a component specification table which includes information on the predefined, standard component types with filled-in specification values and to a component group specification type usage table which contains information associating subclass component types to subclass component type specification types. - View Dependent Claims (2, 3, 4)
-
-
5. A computer implemented electronic catalog database method for collecting component and specification level data related to products in a manner that permits cataloging and managing large quantities of product data in an efficient manner, said method being implemented on a digital computer including a display device and running system software interfacing with a database manager to generate screens on said display device and comprising the steps of:
-
classifying data in a three tiered hierarchical data structure consisting of domains, classes and subclasses;
domains being a highest level of the hierarchical data structure and each domain having its own group of classes, each class having its own group of subclasses, and each subclass having a specific set of components, all products in a subclass having these components, components in a subclass having attributes;defining component groups for subclasses and defining a component order within each subclass in a series of tables, each table having at least one primary key field and a junction table having a plurality of fields; linking attributes with components, the attributes having specification values and units of measure associated with them, and linking components to products using the junction tables of the series of tables; storing the linked tables on a storage device of a digital computer having a database manager programmed and arranged to manage said data in the linked tables to allow users to input and search for specific products based on component criteria, wherein the linked tables stored on the storage device form a data structure including a product domain table, data input in said product domain table identifying product domains, each said product domain being linked to a product table, data input in said product table identifying manufactured or published products by part number and description or a service by an offering number and description, said descriptions being formatted according to concatenation rules, said product table being linked to a component table containing component information, a pricing table containing pricing and leasing information, and a warranty table containing warranty information; and generating a screen on which a user selects a domain, a class and a subclass to input and to search data in the linked tables, said database manager allowing a user to search products meeting a particular criteria including a criteria defined by logical operators, wherein data entered in the component table includes pre-defined, standard component types with filled-in specification values such that when product components and product component specifications are added, said method allowing a user to choose from a list of common components to copy thereby promoting efficiency and data integrity, said component table further being linked to a component specification table which includes information on the pre-defined, standard component types with filled-in specification values and to a component group specification type usage table which contains information associating subclass component types to subclass component type specification types, wherein said linked tables further included a bundle product table linked to said product table, data entered in said bundle product table storing information of component packages included in a product in said product table.
-
-
6. A computer implemented electronic catalog database method for collecting component and specification level data related to products in a manner that permits cataloging and managing large quantities of product data in an efficient manner, said method being implemented on a digital computer including a display device and running system software interfacing with a database manager to generate screens on said display device and comprising the steps of:
-
classifying data in a three tiered hierarchical data structure consisting of domains, classes and subclasses, domains being a highest level of the hierarchical data structure and each domain having its own group of classes, each classes having its own group of subclasses, and each subclass having a specific set of components, all products in a subclass having these components, components in a subclass having attributes; defining component groups for subclasses and defining a component order within each subclass in a series of tables, each table having at least one primary key field and a junction table having a plurality of fields; linking attributes with components, the attributes having specification values and units of measure associated with them, and linking components to products using the junction tables of the series of tables; storing the linked tables on a storage device of a digital computer having a database manager programmed and arranged to manage said data in the linked tables to allow users to input and search for specific products based on component criteria, wherein the linked tables stored on the storage device form a data structure including a product domain table, data input in said product domain table identifying product domains, each said product domain being linked to a product table, data input in said product table identifying manufactured or published products by part number and description or a service by an offering number and description, said descriptions being formatted according to concatenation rules, said product table being linked to a component table containing component information, a pricing table containing pricing and leasing information, and a warranty table containing warranty information; and generating a screen on which a user selects a domain, a class and a subclass to input and to search data in the linked tables, said database manager allowing a user to search products meeting a particular criteria including a criteria defined by logical operators, wherein data entered in the component table includes pre-defined, standard component types with filled-in specification values such that when product components and product component specifications are added, said method allowing a user to choose from a list of common components to copy thereby promoting efficiency and data integrity, said component table further being linked to a component specification table which includes information on the pre-defined, standard component types with filled-in specification values and to a component group specification type usage table which contains information associating subclass component type to subclass component, type specification types,wherein data entered in said warranty table linked to said product table includes information on a warranty program, if any, of a product in said product table, said information on the warranty program including a price of the warranty program, time period when the warranty program is in effect, and conditions under the warranty program.
-
-
7. An electronic catalog in which component and specification level data related to products are collected, said electronic catalog including a digital computer having a storage device, a display device, and system software for managing, controlling and displaying catalog data comprising:
-
a data structure comprising a hierarchical data structure programmed and arranged for classifying data in a three tiered hierarchical structure consisting of domains, a highest level, classes, a next level which groups similar products, each domain have its own group of classes, and subclasses having a specific set of components, all products in a subclass having these components, components in a subclass having attributes and attributes having specification values associated with them, said data structure being stored on said storage device as a series of linked tables, each said table having at least one primary key field and a junction table having a plurality of fields, said junction table providing links to other tables in the data structure, wherein said linked tables include a product domain table identifying product domains, each said product domain being linked to a product table which identifies manufactured or published products by part number and description or a service by an offering number and description, said descriptions being formatted according to concatenation rules, said product table being linked to a component table containing component information, a pricing table containing pricing and leasing information, and a warranty table containing warranty information, wherein said component table includes pre-defined, standard component types with filled-in specification values such that when product components and product component specifications are added, a user may choose from a list of common components to copy thereby promoting efficiency and data integrity, said component table further being linked to a component specification table which includes information on the pre-defined, standard component types with filled-in specification values and to a component group specification type usage table which contains information associating subclass component types to subclass component type specification types; and a database manager programmed and arranged for managing said data structure to allow users to input and search for specific products based on component criteria, said database manager interfacing with said system software to generate a screen on said display device on which a user selects a domain, a class and a subclass to input and to search data in said linked tables, said database manager allowing a user to search products meeting a particular criteria including a criteria defined by logical operators. - View Dependent Claims (8, 9, 12)
-
-
10. An electronic catalog in which component and specification level data related to products are collected, said electronic catalog including a digital computer having a storage device, a display device, and system software for managing, controlling and displaying catalog data comprising:
-
a data structure comprising a hierarchical data structure programmed and arranged for classifying data in a three tiered hierarchical structure consisting of domains, a highest level, classes, a next level which groups similar products, each domain have its own group of classes, and subclasses having a specific set of components, all products in a subclass having these components, components in a subclass having attributes and attributes having specification values associated with them, said data structure being stored on said storage device as a series of linked tables, each said table having at least one primary key field and a junction table having a plurality of fields, said junction table providing links to other tables in the data structure, wherein said linked tables include a product domain table identifying product domains, each said product domain being linked to a product table which identifies manufactured or published products by part number and description or a service by an offering number and description, said descriptions being formatted according to concatenation rules, said product table being linked to a component table containing component information, a pricing table containing pricing and leasing information, and a warranty table containing warranty information, wherein said component table includes pre-defined, standard component types with filled-in specification values such that when product components and product component specifications are added, a user may choose from a list of common components to copy thereby promoting efficiency and data integrity, said component table further being linked to a component specification table which includes information on the pre-defined, standard component types with filled-in specification values and to a component group specification type usage table which contains information associating subclass component types to subclass component type specification types, and wherein said linked tables further include a bundle product table linked to said product table, said bundle product table storing information of component packages included in a product in said product table; and a database manager programmed and arranged for managing said data structure to allow users to input and search for specific products based on component criteria, said database manager interfacing with said system software to generate a screen on said display device on which a user selects a domain, a class and a subclass to input and to search data in said linked tables, said database manager allowing a user to search products meeting a particular criteria including a criteria defined by logical operators.
-
-
11. An electronic catalog in which component and specification level data related to products are collected, said electronic catalog including a digital computer having a storage device, a display device, and system software for managing, controlling and displaying catalog data comprising:
-
a data structure comprising a hierarchical data structure programmed and arranged for classifying data in a three tiered hierarchical structure consisting of domains, a highest level, classes, a next level which groups similar products, each domain have its own group of classes, and subclasses having a specific set of components, all products in a subclass having these components, components in a subclass having attributes and attributes having specification values associated with them, said data structure being stored on said storage device as a series of linked tables, each said table having at least one primary key field and a junction table having a plurality of fields, said junction table providing links to other tables in the data structure, wherein said linked tables include a product domain table identifying product domains, each said product domain being linked to a product table which identifies manufactured or published products by part number and description or a service by an offering number and description, said descriptions being formatted according to concatenation rules, said product table being linked to a component table containing component information, a pricing table containing pricing and leasing information, and a warranty table containing warranty information, wherein said component table includes pre-defined, standard component types with filled-in specification values such that when product components and product component specifications are added, a user may choose from a list of common components to copy thereby promoting efficiency and data integrity, said component table further being linked to a component specification table which includes information on the pre-defined, standard component types with filled-in specification values and to a component group specification type usage table which contains information associating subclass component types to subclass component type specification types, and wherein said warranty table linked to said product table includes information on a warranty program, if any, of a product in said product table, said information on the warranty program including a price of the warranty program, time period when the warranty program is in effect, and conditions under the warranty program; and a database manager programmed, a and arranged for managing said data structure to allow users to input and search for specific products based on component criteria, said database manager interfacing with said system software to generate a screen on said display device on which a user selects a domain, a class and a subclass to input and to search data in said linked tables, said database manager allowing a user to search products meeting a particular criteria including a criteria defined by logical operators.
-
Specification