Categories schema

[fischermx]

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 ?

[bobrat]

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.

[fischermx]

 

Thanks, well, that's exactly my point ...

I wonder if someone could give advise about the most proper schema needed to dump the data.

[lazydog]

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.