Learning Data

Topics › Master and reference data › The same one, everywhere

Which value wins: a rule for each field, declared in one place, not hidden in the code

In 1831, HMS Beagle sailed with twenty-two clocks, and which ones to trust was decided before they could disagree. At the university, Linh's five records are now linked to one person, and their values still disagree: four ways of writing her name, two birth dates, two mobile numbers, four emails. The model already picks one, with a single order for every field, hidden in the code, and letting the newest value win would hand her record to HR's resent file, typo and all. Jun writes a rule for each field in one place, where the steps that build her record read them: on a master data tool's screens or, in the simplest form, in a file. Mei pins the right birth date with a reason, and every value keeps its source, its rule and its age.

6 minPause and thinkEnglish captions

Builds on Who is it?

Watch the film

Press Play, or pick a chapter. Turn on Pause and think to stop for one question at the end of chapters.

0:00

Think it through

The four Pause and think questions, for a class or a team. Open one to see the answer.

Take it apart, then make the call

This film's labs, and its situations, among the series' 29 labs and 72 situations. Your progress stays in this browser.

Take it apart: Which name, where →Take it apart: Which value winsTake it apart: Write the ruleMake the call: 8 situationsEvery lab

In the series: The same one, everywhere

Film 3 of 9.

← Previous · Film 2 of 9

Who is it?

Two records, one person? A check proposes pairs, weights make a score, and a steward decides the hard ones once, with a reason.

5½ min · Pause and think · The same one, everywhere

Next · Film 4 of 9 →

Roles come and go

A status is true for a day. Give every role a start, an end and an owner, and ask any question as at a date.

5½ min · Pause and think · The same one, everywhere

  1. 1One person, many roles
  2. 2Who is it?
  3. 3Which value wins
  4. 4Roles come and go
  5. 5Lists everyone uses
  6. 6For this purpose only
  7. 7One person, many systems
  8. 8A hub at work
  9. 9Kept, not cleaned