将数据存储为 XML BLOB
目前，与我合作的团队正在研究将用户从一系列输入向导屏幕输入的数据作为 XML blob 存储在数据库中的可能性。这样做的主要原因是我想将输入向导编写为一个组件，可以将其引入到许多系统中，而不必带来大型表结构。
为了尝试澄清向导是否有 100 个输入字段（例如），那么如果我使用正常的关系数据库结构，那么它们将是 1 对 1 的关系，因此数据库中将有 100 列。因此，要使其在另一个系统中工作，必须将表、存储过程等引入新系统。
我对此有很多保留，但我想听听人们的意见？
谢谢
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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果这些输入字段不需要更新或用于以后的计算或计算，那么使用 xml 或 JSON 的某些值是明智的选择。
所以对于你的场景来说它似乎是一个完美的解决方案
If those inputted fields don't need to be updated or to be used for later calculation or computation some values using xml or JSON is a smart choice.
so for your scenario seems like its a perfect solution