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: 232
        
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