Patent ID: 6938038
Filing Date: 2005-08-30
Classification: G06F,Y10S

Abstract:
1. In a computer system, a method of organizing catalog information in a database structure to provide access to said catalog information comprising: obtaining a set of catalog data; obtaining a set of qualifier fields in said set of catalog data using a rule set comprising a first set of sparsity values associated with each one in said set of qualifier fields; obtaining a set of lookup fields in said set of catalog data using said rule set comprising a plurality of second sparsity values associated with each one in said set of lookup fields; obtaining at least one primary table; obtaining at least one sub-table comprising said set of lookup fields having at least one relationship with said at least one primary table, wherein each of said lookup fields comprises legal values, wherein said at least one sub-table comprises at least one sub-table record having sub-table fields containing legal combination for said catalog data; obtaining a qualified link table per said at least one sub-table wherein said qualified link table comprises said set of qualifier fields and a plurality of association record fields, wherein each of said plurality of association record fields provides an association between at least one record in said at least one primary table and at least one record in said at least one sub-table; performing a search for a sub-set of catalog data using a first lookup in at least one of said plurality of sub-tables, a second lookup in said at least one qualified link table and a third lookup in said at least one primary table.