Skip to content

Blank-Page Reconstructions & Key

Attempt all 12 from memory before using the key.

Prompts

  1. Draw Reference / Master / Transaction / Metadata as a four-way comparison.
  2. Write SOR → System of Reference → Trusted Source → Golden Record and explain each.
  3. Draw List → Cross-reference → Taxonomy → Ontology.
  4. Write all five MDM processing steps in order.
  5. Draw entity-resolution decision with false-positive/false-negative branches.
  6. Write deterministic vs probabilistic matching with one strength/limitation each.
  7. Draw Duplicate Identification → Match-Link → Match-Merge as increasing action/reversal cost.
  8. Draw Source IDs → X-Ref history → Global ID.
  9. Draw Registry vs Transaction Hub vs Consolidated architecture.
  10. Write the six MDM activities and six RDM activities side by side.
  11. Write the Reference Data controlled-change workflow.
  12. Draw Governance → Stewardship → Sharing/SLAs → Metrics → Improvement.

Reconstruction Key

1. Four-way comparison

Reference = controlled classifications/domain values.
Master = persistent core entities.
Transaction = business events.
Metadata = definitions/source/steward/lineage/lifecycle about data.
Show Transactions involving Master entities, Reference values contextualizing them, and Metadata spanning all.

2. Authority sequence

SOR = create/maintain authority → System of Reference = consume/access authority → Trusted Source = governed best source/view → Golden Record = reconciled entity instance. The arrows are a memory device, not a requirement for four separate systems.

3. Reference ladder

List = code/description → Cross-reference = equivalent-set mapping → Taxonomy = hierarchical classification → Ontology = richer formal concepts/relationships.

4. MDM processing

Model → Acquire → Validate/Standardize/Enrich → Resolve Identity + Manage IDs → Share + Steward.

5. Match decision

Candidate records → similarity evidence → SAME ENTITY?
Different entities incorrectly joined = false positive.
Same entity incorrectly separated = false negative.
Add match history/reversal feedback.

6. Match methods

Deterministic = explicit, explainable, repeatable rules but can miss unanticipated variation.
Probabilistic = handles fuzzy evidence statistically but requires training/tuning/threshold governance.

7. Workflow ladder

Duplicate identification = flag/review → Match-link = connect identity/preserve content → Match-merge = reconcile into unified record. Intervention/reversal complexity increases rightward.

8. Identifier map

Source A / B / C IDs → X-Ref mapping + history → one Global ID. Do not erase local IDs.

9. Architectures

Registry = index points to source SORs.
Transaction Hub = hub is SOR and owns updates.
Consolidated = source SORs feed replicated/reconciled central System of Reference.

10. Activity comparison

MDM: requirements → source assessment → architecture → model/master/identity controls → stewardship/governance → share/maintain/monitor.
RDM: authoritative sets/requirements → source/acquisition assessment → architecture → mappings/hierarchies/Metadata → stewardship/change/versioning → publish/share/govern.

11. Reference change

Request → stakeholders → impact → decide/approve → update → communicate/inform.

12. Operating loop

Governance sets authority/rules → Stewardship manages content/exceptions → Sharing/SLAs operationalize provider-consumer commitments → Metrics show quality/service/coverage/adoption/cost → Improvement changes rules/process → Governance.

← Recall Key · Classification Drill →