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
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
