Hi,
Working on Oracle 11g R2.
We have a web application written in Java and one of the current task is to save what a user inputs in the web interface as is, as the same information is being used in other parts of the site as is - no modification.
Example:
On the web page, user enters the following:
Name -
Address -
Email -
Phone -
Other Entities -
And other fields.
We need to save the user entered information (Shown above) in a table which can then be used in other sections of the Web, it will be more like a log of what an user entered at a particular time.
Not all fields are shown above but I can go ahead and normalize the above entered data which could mean creation of multiple tables or I can store everything as is without normalization in 1 or 2 tables.
Only DML operations on the above tables will be:
INSERT
SELECT
no UPDATES or DELETES.
Please advise on:
Normalize or Denormalize?, which is a better way? and should we always try to create normalized table structures even though some applications will only need to support INSERTs and SELECTs?
Thanks,