Logging request , response to Database

Question

0.00/5 (No votes)

See more:

Dears,

I need to log transaction requests and responses to database
But shall I log them in a single table with a relationship within the same table
or it's better to have 2 tables (one for request and one for response) ?

Regards,

Posted 19-Sep-13 1:53am

Sandra Ha

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2013-09-19T01:56:00

Solution 1

Database design has no exact answer. It always depends on what you want to do. How will you use the data? How much data do you anticipate of each kind? On the one hand if they are in the same table to get a report you don't have to union but if you won't need to union often then keep them separate. If they will share all the same fields then keep them in the same table.

Essentially, the answer is it depends. You'll have to decide.

Posted 19-Sep-13 1:56am

ZurdoDev

Comments

Sandra Ha 19-Sep-13 8:02am

yes they have the same structure (same fields) and the data will be used for reporting. Some data will be taken from request records and some from responses.

ZurdoDev 19-Sep-13 8:04am

Probably put them in the same table then with a field to indicate if it is a request or response.

gvprabu 19-Sep-13 8:49am

nice explanation.... my 5+ :-)

Maciej Los · Answer 2 · 2013-09-20T03:13:00

Solution 2

It depends on how response are related with single request.
1) Relationship: 1 request to 1 response
One table

2) Relationship: 1 request to many responses
Two tables

Please, read these:
Relational database[^]
Relational model of database[^]

Posted 20-Sep-13 3:13am

Maciej Los