aspose file tools*
The moose likes OO, Patterns, UML and Refactoring and the fly likes Data Modeling Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » OO, Patterns, UML and Refactoring
Bookmark "Data Modeling Question" Watch "Data Modeling Question" New topic
Author

Data Modeling Question

Arun Kumarr
Ranch Hand

Joined: May 16, 2005
Posts: 513

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: 2187
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?
Arun Kumarr
Ranch Hand

Joined: May 16, 2005
Posts: 513

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: 2187
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?
Arun Kumarr
Ranch Hand

Joined: May 16, 2005
Posts: 513

Sorry about the delay. The request and response column are different.
Jimmy Clark
Ranch Hand

Joined: Apr 16, 2008
Posts: 2187
Storing request data and response data in different columns may be a good design.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Data Modeling Question