Entity creation wizard with data versioning options
31
Views
0
Comments
New
Database

When creating entities, can we build a wizard style experience for the developers to choose from?

The options and underlying logic for this wizard would be similar to Slow Changing Dimension Types i.e. 

#1 SCD Type 0 — Dimension is never updated

#2 SCD Type 1 — Dimension is overwritten

#3 SCD Type 2 — Maintain all the old records for the dimension by versioning the row

#4 SCD Type 3 — Maintain an old attribute but in the same row (by adding a previous value column)

#5 SCD Type 4 — Maintain current record and older record in two different tables


This would greatly help database modeling, data versioning strategy and have a standardized approach for the application being developed.