I have never done any serious SQL design before. Anyways I have to store a hierarchical data structure, similar to a tree in a SQL database.Right now I simply add a "parent_id" column in each of ...

How are you going to manage and store all that XML data? Simple database? Maybe a not-so-simple database. See why a hierarchical structure designed for XML could be a better choice than a ...