I am classifying some items. The items will be stored in a large MySQL
database (probably InnoDB engine). At storage time, we would like to append
a series of descriptive categories to the item, in order to facilitate
"friendly", very flexible searches later.
For instance item A is in main category food, subcategory organic,
Item B is category organic, sub-category food, sub-sub category baby.
As you see the same category can be main category for one type of item,
subcategory for another item, sub-subcategory for another.
I have been working on this thing for a couple of days now, but I have not
been able to come out with any clever solution.
- good efficiency on multicategory searches
- to store data in a relational table (if possible)
- to update easily the list of categories (the table)
- to address the problem of assigning a different status (main, sub, sub-sub
and so on) depending on the type of item to each category I put in the list.
symbulos - ethical services for your organisation