Sunday, March 20, 2022

Anti-pattern: Adding Relationship Temporality to a Non-historised LINK

Non-historised Links represent data can not change or be deleted, for e.g. Stock Trades, Medical Test results etc. This data, once recorded, should not change. As such, there is no need to capture the End date of these. If you find yourself having the need to add the End Date to a LINK table, then it must be a Historized Link.

No comments:

Post a Comment