What you've described is essentially a slowly changing dimension. Take a look at Kimball's advice and patterns how to slowly changing dimensions.

http://www.kimballgroup.com/2008/09/slowly-changing-dimensions-part-2/

.. When developers ask about adopting MongoDB for certain applications, or for help setting up a CI process, is your stock answer to say "no", and to quote corporate...

You had me alarmed there for a moment; I thought that Mother's...

This is kind of like an office with 100 employees and 1 bathroom stall to share between them; it's a very time wasting and contentious bottleneck. But of course you...

LOL! Look at all the bad (1) star reviews. Go peddle your junk somewhere else.
https://www.facebook.com/UK-Cheap-Kitchens-329159410509196/

When Microsoft says that they're collecting data just for quality of service purposes and don't care who I am personally, I take them at their word. I'd trust Microsoft with...

It would be hard to prove that the data loss was the result of a botched upgrade, unless there were a statistically sufficient number of other users who experienced similar...