Let me provide you with an example. Let's say I have an
html_tag with two columns,
For example, let's say I have a record with the value "link" under the
tag_type field and "https://dba.stackexchange.com" under the
Now, how would I approach this for auditing purposes? I want to only
INSERT into this table when one of the
tag_value fields corresponding to a
tag_type has changed, because it would not make sense to add redundant records to this table.
Is this a database design problem I'm having, or is there advanced SQL I'm unaware of that would accomplish this? Or, rather, would the Java I am getting these values from initially be the place to handle such a thing? Example of how I would do this in Java (psuedo code):
var newTag = extract the tag's value from my webpage; var tag_value = SELECT tag_value from html_tag WHERE tag_type = 'link' if (new_tag != tag_value) then (INSERT INTO html_tag)...
Should I handle this at the database level, or java level, like directly above?