This week's book giveaways are in the iOS and Features new in Java 8 forums. We're giving away four copies each of Barcodes with iOS: Bringing together the digital and physical worlds and Core Java for the Impatient and have the authors on-line! See this thread and this one for details.
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?