Connecting Tech Pros Worldwide Forums | Help | Site Map

Organizing Categories

Newbie
 
Join Date: Apr 2009
Location: India
Posts: 7
#1: Apr 28 '09
We have a scenario for maintaing items based on categorization. But at the same time we have multiple manufacturers can load items. We want manufacturers create their own categories and assign when loading item.

So whats the best way to organize categories?

Thanks in advance.
Sunil Kalahasti

debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,508
#2: Apr 28 '09

re: Organizing Categories


you need to maintain some nomenclature formula.

1. Prefix the manufacturer code with the actual code

OR

2. Assign a range of numbers to each manufacturer and concatenate with the actual code so that the codes will not clash across manufacturers.
Newbie
 
Join Date: Apr 2009
Location: India
Posts: 7
#3: May 1 '09

re: Organizing Categories


Thanks for your response debasisdas.

Actually we want to allow Manufacturers to create their own categories. And we will be having the same database accessed by multiple manufacturers.

Can we build these in XML and store in database? And when display thier categories we need to parse these category wise.

Thanks in advance.
Sunil
Reply

Tags
categories


Similar Oracle Database bytes