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.
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.
Joined: Apr 16, 2008
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?