September 9, 2004 at 12:56 am
We are currently debating how to store BO's within our SQL Server DB.
We have a object to relational mapping layer that allows us to map BO's to DB tables. It has been suggested that we take the serialised BO graph and just place it in to a blob within the DB.
I'm looking for any pro's and con's of storing the serialised BO's into a Blob. If any one has had experience with this, please respond.
September 13, 2004 at 8:00 am
This was removed by the editor as SPAM
September 13, 2004 at 9:33 am
Why would you want to store blobs instead of normalized data?
Will you ever need to query the data, report on the data, or use the data for anything other than that one application that's writing the blobs? If the answer to all of these is "no", then perhaps you can start thinking about the pros of the blob decision (I don't know what they are; please share your ideas). If any of the answers is "yes", you have no choice but to normalize the data.
--
Adam Machanic
whoisactive
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply