As I said earlier, I don't know what each items are about and their XML schema. So it is highly impossible for me to create flat table structure.

Thanks for your reply. This looks promising and I will give it a try.

Will there be any performance hit if there are millions of rows. Since I am writing this...