No replies to this topic

[Voltzz]

Hello,

I'm designing a project similar to wikipedia that would import categories from an XML schema. The thing is, that the XML schema is not a regular hierarchy of categories but rather it also contains links to other categories. For example:

Cat1 --> Cat 2 --> Cat 3
V >--> Cat 4 ---> Cat 5
Cat6 ------^

So my question is, what kind of structure should I use? I will be using a mySQL database, and my initial thought is just to find a primary path through the XML schema, generate a hierarchy and store it in a table and have a separate table storing the interlinkage. This would create a problem when I'm designing algorithms, so I was wondering if there was a better way? My project is similar to Knoll (Google) as it also would incorporate rating system, so my guess is that there is probably a more efficient way. Thanks in advance!