Data Model: SQL Limitations and XML Use
Posted on 2012-03-16
I have a data schema/model issue that is stretching my knowledge of implementation in SQL and I think I will need to implement in XML. would like some thoughts as well as best practices if XML is th e way to go.
I will generisize the problem:
Object A is the main object, it can contain the following types (max quantities in brackets)
Thing 1 (unlimited), Thing 2 (unlimited), Thing 3 (1), Thing 4 (1)
Further Thing 1 can contain the following types (max quantities in brackets)
Thing 1 (unlimited), Thing 2 (unlimited), Thing 3 (1), Thing 4 (1) [Yes, same as the above]
This can go on and on depending on how the use chooses to design the object.
Given I do not know in advance how deep (I am more concerned with depth then width) this problem space can go I do not see any easy way to structure, store and retrieve in SQL 2008. XML and its nodes seems to be workable. The tangential thought is the ability to srialize the XML data into a class I can use in the application.
Any and all comments welcome.