The people table, and its satellite tables -- _contacts,
_address, _classification, etc -- need to be "fully"
temporalized as the events_registration and couples
tables have been. This typically means adding a "since"
attribute for each attribute in the base tables and
a "during" table for each key, key/attribute pair that
contains the from/to dates for that historic value.
The base tables, extended with "since"s, are the
_current_ tables. While the "during" tables are the
historic values. See Date, Darwen, and Lorentzos's
_Temproal Data and the Relational Model_ for more
details.
Numerous triggers, functions, check constraints will be
needed to be written. The absence of the pack/unpack
operators will make this more difficult, along with the
absense of their shorthand suggestions.
Log in to post a comment.
