Hacker News new | ask | show | jobs
by ironchef 748 days ago
You appear to be describing a classic type 2 or type 4 slowly changing dimension. (https://en.wikipedia.org/wiki/Slowly_changing_dimension )