SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Database design - multi-level structure?
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

gbaia
Yak Posting Veteran

United Kingdom
52 Posts

Posted - 03/23/2004 :  16:41:35  Show Profile
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

USA
1157 Posts

Posted - 03/23/2004 :  18:09:53  Show Profile
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

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

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



-ec
Go to Top of Page

gbaia
Yak Posting Veteran

United Kingdom
52 Posts

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



Grazi
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000