File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Data Modeling Question

 
Arun Kumarr
Ranch Hand
Posts: 661
Eclipse IDE Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jimmy Clark
Ranch Hand
Posts: 2187
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 661
Eclipse IDE Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2187
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 661
Eclipse IDE Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry about the delay. The request and response column are different.
 
Jimmy Clark
Ranch Hand
Posts: 2187
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Storing request data and response data in different columns may be a good design.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic