Storing Data as XML BLOB
Posted
by
NBrowne
on Stack Overflow
See other posts from Stack Overflow
or by NBrowne
Published on 2010-09-28T08:56:45Z
Indexed on
2010/12/24
9:54 UTC
Read the original article
Hit count: 198
Hi,
At the moment the team i am working with is looking into the possibility of storing data which is entered by users from a series of input wizard screens as an XML blob in the database. the main reason for this being that i would like to write the input wizard as a component which can be brought into a number of systems without having to bring with it a large table structure.
To try to clarify if the wizard has 100 input fields (for example) then if i go with the normal relational db structure then their will be a 1 to 1 relationship so will have 100 columns in database. So to get this working in another system will have to bring the tables,strore procedures etc into the new system.
I have a number of reservations about this but i would like peoples opinions??
thanks
© Stack Overflow or respective owner