Data Management patterns¶

We’ve identified a set of patterns when working with problems related to Master Data Management in Sesam. We find it very useful to name these patterns as it makes it easier to refer to them when discussing challenges.

Note

This document is subject to improvements as we are continuously identifying new patters to enforce better master data management in Sesam.

Enrich Patterns¶

Looking for some enrich patterns? These topics will get you started on the right foot.

Extract foreign references as extracted datatypes pattern

Adding type information pattern

Splitting out lists of sub-objects pattern

Normalising data pattern

Extract reference properties as reference/classification entities

Connect Patterns¶

Looking for some connect patterns? These topics will get you started on the right foot.

Cleaning data pattern

External merge pattern

Golden property based on priority pattern

Golden property based on last updated pattern

Golden property based on quality

Feedback loop pattern

Hungarian notation references pattern

Transform Patterns¶

Looking for some transform patterns? These topics will get you started on the right foot.

Late schema binding

Defining hierarchies for recursion

Re-mapping references to target identifiers

Generic Patterns¶

Looking for some generic patterns? These topics will get you started on the right foot.

Rewriting identity pattern

Open to extension closed for modification

Data Management

Enrich Patterns