Denormalization to allow use UNQIUE index?
Post has many Comment. Post contain issue_id field and Comment contains comment_id field. The request to create a comment with (issue_id, comment_id) which already exists in the DB should be ignored. Is it worth to add a copy of post_id into Comment (in order to use UNIQUE index to prevent duplicates)? Or should I use transactions?
That is, is denormalization worth the possibility to easily create composite UNIQUE?
--
http://freesoft.portonvictor.org
Subject
Views
Written By
Posted
Denormalization to allow use UNQIUE index?
2228
November 11, 2016 09:34AM
976
November 11, 2016 11:49AM
1190
November 11, 2016 01:02PM
1031
November 12, 2016 01:25PM
1220
November 12, 2016 02:14PM
1012
November 12, 2016 05:38PM
902
November 12, 2016 06:30PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.