3 comments

  1. Thanks for these articles, there’s indeed not so much information about EAV on the internet. On the other hand you’re in the high in the Google list ;-).

    I was wondering, isn’t ValidTo redundant? If they don’t align with the next ValidFrom you get gaps.

    Frank de Groot - Schouten Beantwoorden

  2. Hello Frank, I hope these articles are useful to you.
    First of all, if you use the technique I’ve described above you won’t get gaps because the ValidTo will align with the next ValidFrom 100% of the time.

    Knowing this, you could do without ValidTo in most timelines except the last.
    Because the last timeline won’t have a ‘next ValidFrom’, you can’t tell when the last timeline will ‘end’.
    For this reason I have included a ValidTo column in every record.

    marks Beantwoorden

  3. […] approach for entity attribute value tables with the above pattern (check out : Handling EAV-data: Timelines for more information and a nother approach to this […]

    Filling out and slicing timelines in one or more tables | Versificator Beantwoorden