Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Database design - multi-level structure?

Author  Topic 

gbaia
Yak Posting Veteran

52 Posts

Posted - 2004-03-23 : 16:41:35
Hello! I have to do a DB with thousands of images. These images have keywords with multiple levels that can be edited.

For example, if someone inputs 'strawberry' as a keyword for the image, automatically the image would have 'strawberry','fruit','food' (or whatever would be the parent keywords), then, the user could edit and change... for example, he could choose to have only 'strawberry' and 'fruit'...

how can I design something that would work like this in the DB and keep up the good performance when the system is up and running?

Many many thanks for any help!! Grazi

Grazi

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2004-03-23 : 18:09:53
Nested sets will show you the way to hierarchical happiness.
http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=230706

"Hit me with a shovel 'cause I can't believe I dug you."
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-03-23 : 18:12:22
look here too:

http://www.sqlteam.com/item.asp?ItemID=8866



-ec
Go to Top of Page

gbaia
Yak Posting Veteran

52 Posts

Posted - 2004-03-25 : 17:13:33
Thank you so much for you both. The articles seem great and it's a great starting track!



Grazi
Go to Top of Page
   

- Advertisement -