Categories schema

Hi,

I want to extract the DMOZ categories and I'm wonder how are the tables needed to put the data.
I understand it is hierarchical, however, I've never seen before the multi-parents capability shown by DMOZ.

Could someone shed some light on this ?

There are no tables in the downloadable RDF file, it's just a text file. It's up to you to design a table structure that meets your needs and then load the data into it.

Thanks, well, that's exactly my point ...
I wonder if someone could give advise about the most proper schema needed to dump the data.

If you want to store hierarchical data, then I suggest youi use an sql-tree with left and right values. Google for "sql trees" and you will find tutorials.