linking attributes 
Author Message
 linking attributes

well, i've a design-problem - maybe the one or the other collegue had
a similar problem in the past an can answer. every idea is welcome !

db2 udb v6, java.

a customer has "attributes" like

- has an american express credit card (with all informations)
- is interested in "new york times"
- has a compaq computer (with all informations)
- ...

the number of attributes are known (we're not selling refrigerators
to eskimoes eg.) so i like to create one table per attribute to
transport all the informations needed.

what is the best idea to link this attributes to the customer record
?

i've 2 ideas:

- create a linked list like
  customer -> anchor to first attribute
    attribute -> next/previous attribute

- working with a reference table like
  customer -> key in referencetable
    referencetable is "key,key_in_attribute:table_of_attribute"

- other ideas ?

clueless,
  bernd

--
the DB2 faq: http://www.***.com/



Wed, 05 Mar 2003 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Large attributes from linked AD are truncated

2. xsl:element | xsl:attribute - How do i dynamically assign values to the attributes before output

3. attribute's attributes

4. A way to add attributes past last attribute using UP or ED?

5. Good links MCSD and SQL links!!

6. Linking SQL server 7 to AS400 using linked feature

7. How to report on 3 tables with a True / False when linked / not linked

8. Is It Possible: Linked Server to Linked Server?

9. link to server and link to excel.........*****

10. -Linked Server--Richard Waymire Seminar--Cannot use Integrated Security with Linked Server with SQL7 and Win2k--

11. How linked are linked servers ?

12. Problem linking to Sybase as linked server


 
Powered by phpBB® Forum Software