XML document with varying number of nodes sql table design
I am receiving an XML document from a web service, and I need to insert
the data into a database table.
The xml spec sheet states that, " 0 or more nodes describing the standard
features that are present on the vehicle ". There are couple of other
sections that are this way. This wouldn't be an issue if I was just
parsing through the data and displaying it, but I need to insert into a db
table. Since the number of nodes that I receive may vary, I need to create
the table or tables will enough flexibility to allow for that variation,
but I'm not sure the best way to accomplish this.
Here is the paste bin of the full xml file: tcuv xml
I am receiving the xml document via a coldfusion component, and the
database is SQL Server 2008
Any help would appreciated.
EDIT:
ADDITIONAL INFORMATION: How we normally deal with this is just create one
long string of options and place the whole string in one column
No comments:
Post a Comment