posted 18 years ago
Hi,
What is the Best way to store complex(nested) xml elements in database ?
for Simple elements:
<Person>Lucky ali</Person>
am storing it in a table with columns ObjectId, Name, Value.
For Complex Element as follows, what should be the table structure ? Will a single Table suffice to store the Hierarchy ? What if the nested levels increase upto n...
First level of nesting:
<Name>
<FirstName>Lucky</FirstName>
<LastName>Ali</LastName>
</Name>
Second level of nesting:
<Address>
<line1> </line1>
<City> </City>
<Phone>
<OfficeNo></OfficeNo>
<ResNo></ResNo>
</Phone>
</Address>
thanks and regards,
Lucky