Help with a optimization problem

From: lala4life <rafael.avaria_at_gmail.com>
Date: 27 Apr 2007 10:41:57 -0700
Message-ID: <1177695716.984960.111060@o40g2000prh.googlegroups.com>

Hi gurus

 I have the following schema, for a given item i have a set of attributes and for this set of attributes , i can have thousand set of attributes values (ie. item (pant) -> set of attributes (color,manufacturer,season) ) -> set of attributes values ('black','levis','winter'),('blue','levis','winter') etc..

this schema have the following tables

• set of attributes CREATE TABLE t_set_attribute_master ( id_set_attribute_master_id --> Pimary Key name_set_attribute
  )
  

 CREATE TABLE t_set_attribute_detail (

  id_set_attribute_master                      -->Foreign Key

  attribute,
  display_sequence
)

set of attribute values

CREATE TABLE t_set_attribute_values_master (

  uniqueidentifier_set_attributes_values                       -->
Unique Key
  id_set_attribute_master_id INT                                 -->

Foreign Key
)

 CREATE TABLE t_set_attribute_values_detail (    niqueidentifier_set_attributes_values INT --> Foreign Key    attribute
   attribute_value
)

Currently a user entered a set of values and i must check if this values match with a stored attributes values. by the way change the schema is not an option, i am not the designer.

Do you have an efficient way to do this?

Currently i have a following approach, Load all the stored set of attributes values in a temporary table
that is
  uniqueidentifier_set_attributes_values, attribute_value, attribute_value attribute_value , etc..
 and then check for a match

But is not a good choice. Received on Fri Apr 27 2007 - 12:41:57 CDT