Data Governance

Metadata Management and Data Governance • 63

Third Normal Form Data Versioning

Normalization is the process of organizing data to minimize redundancy.

Most Online Transaction Systems are in third normal data format or close

to it. With third normal data format, there are many more tables than a

Star Dimensional model.

Data versioning in a ird Normal Form (3NF) model is more com-

plex than in a Star Dimensional model. ere are many dierent ways to

support data versioning in a ird Normal Form model. One approach

is a composite surrogate key. is approach is far less complex: less eort

to implement, performs well, and maintains referential integr ...