There is at least some mismatch between the "relational databases" and the soft deletes. While for some fact tables (time series) it is easy to implement the s

There is at least some mismatch between the "relational databases" and the soft deletes. While for some fact tables (time series) it is easy to implement the soft deletes, for other dynamic workloads (e.g. when both fact tables and dimension tables are updated) it can become a messy nightmare to keep the referential integrity up-to-date with the dangling soft-deleted records. Sometimes it will be difficult to decide if the long-ago soft-deleted record should be maintained, if the dimension is maintained.