#temporal-data
1 works and posts tagged with this.
-
An organisation chart that changes by regulation is still master data for relational records. I keep it in SQL as a table that points at itself, with versions per agency and effective dates, read it with one query and recursive CTEs, and leave drawing it to the interface.