| Author |
Message
|
| nathanw |
 Posted: Tue Feb 01, 2005 4:25 am Post subject: Storage of data in XML for Reference later |
 |
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
In a situation between apps whereby the source app will deliver a message and WMQI picks it up and deleivers to the target app
In this scenario where a database is required to store the input message for reference / look up later on I hav always just created a table matching the message with columns = fields
Now this does mean that when the message changes we have to adjust the table to include new items
Someone has suggeste that storing the message as a blob in a db an dthen refering to that for info later is the solution however I am not that certain that this is possible?
You thoughts
I have always used the BLOB as a warehousing function whereby the data is not access but when data needs to be accessed i have separated out the data indiviually as this means I can extract alot easier indiviual fields etc
Is this true |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Feb 01, 2005 5:06 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's certainly possible to store an ASBITSTREAM version of your message and then reCREATE and PARSE it later.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| nathanw |
| Posted: Tue Feb 01, 2005 5:24 am Post subject: |
|
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
jeff
yes i understand that but it is more likely taht we will ahve to do a look up and only extract a certain field or maybe a couple of them
in my view having to reCreate and Parse it again is not a worthwhile exercise
if it was the entire message then I would agree |
|
| Back to top |
|
|
| EddieA |
| Posted: Tue Feb 01, 2005 8:05 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| Quote: |
| if it was the entire message then I would agree |
I think Jeff was suggesting that you store the entire message.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Feb 01, 2005 8:43 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| EddieA wrote: |
| I think Jeff was suggesting that you store the entire message. |
Actually, I wasn't suggesting anything. 
It is possible to store the entire message as a BLOB. Storing the entire message as a blob does make it somewhat harder to access specific fields later on.
It is possible to store only specific fields in individual columns. Doing so does make it somewhat harder to change which fields you store later on, but does make it easy to access different fields later on.
If I were to make a suggestion here, it would be that nathanw understand his own requirements, and use them to drive the decision he's asking for suggestions about... 
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
