Hi,
As part of resilience and audit in a financial system, we are planning to store the "XML"/Object request sent to the external system and
the "XML"/Object response obtained from the external system in the same table. Is this an advised data modeling practice? Please share your opinion.
Thanks for your comments.
If you are not laughing at yourself, then you just didn't get the joke.
Jimmy Clark
Ranch Hand
Joined: Apr 16, 2008
Posts: 2159
posted
0
You're asking about storing system request data and system response data in the same relational table. How will you determine or distinguish between the two different types of records, e.g. request record, response record?
Mea culpa. I meant, I will have "XMLDetails" column for request and a "XMLDetails" column for response.
The request is sent/stored and once we receive the response, the same row will be updated with the response XML.
Jimmy Clark
Ranch Hand
Joined: Apr 16, 2008
Posts: 2159
posted
0
Are you stating that you are planning to store a request record in a table row and then when you recieve the response, you are going to delete the request data and replace it with the response data?
0
