barbelhisto-core icon indicating copy to clipboard operation
barbelhisto-core copied to clipboard

Published 20 hours ago • verified publisher icon projectbarbel

Bitemporal deletes

Open vdurbha opened this issue 4 years ago • 4 comments

I was going through examples in Snodgrass book on bitemporal deletes and here's how I understood how he was doing them.

Step1: John is a new customer on Jan 1st, 2020 Cust.No Cust Name VT Begin VT End TT Start TT End 1 John 2020-01-01 9999-12-31 2020-01-01 9999-12-31

Step2: John is no more a customer as of Feb 28th, 2020 Cust.No Cust Name VT Begin VT End TT Start TT End 1 John 2020-01-01 9999-12-31 2020-01-01 2020-02-28 1 John 2020-01-01 2020-02-28 2020-02-28 9999-12-31

Is my understanding correct? Can we support deletes in this manner without extra flags/columns in my business entities?

vdurbha avatar Feb 27 '20 19:02 vdurbha