Learning Data

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

Who is it? Master or reference data, the golden record, and a match decided once

In 1556, a village took the wrong man for Martin Guerre, because so much matched. At the university, a duplicate check proposes three pairs, and Mei's office decides each one: Linh's two student numbers, linked with a reason; HR's record of her, scored weight by weight, its birth date one digit apart; and two students called Aisha who share a number but are two people. A golden record keeps every source as it arrived, so any link can be undone.

5½ minPause and thinkEnglish captions

Builds on One person, many roles

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: Master or reference? →Take it apart: What a master record isTake it apart: Same person?Take it apart: Where to draw the linesMake the call: 8 situationsEvery lab

In the series: The same one, everywhere

Film 2 of 9.

← Previous · Film 1 of 9

One person, many roles

One person, four systems, five records. Keep the person apart from the roles, and ask four questions to know what needs mastering.

6 min · Pause and think · The same one, everywhere

Next · Film 3 of 9 →

Which value wins

Five linked records, and the values still disagree. Declare a rule for each field, not one order hidden in the code.

6 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