~/talk

Data Linkage Options: MDM vs Splink (PySpark)

Talkat SQLBits 2024 · 2024-03-19..03-23· [data-engineering]
name:Ash Ward
links:none on file
slides:none on file

Direct comparison of Master Data Management vs Splink: MDM provides a non‑technical UI, integrated QA/distribution and predictable outcomes but typically costs £75–150k/yr (with Customer Insights at ~£7k/yr) and uses rule/fuzzy matchers; Splink is a free Python library built by the Ministry of Justice, scales to 100+ million records, uses probabilistic matching with blocking, runs on DuckDB or Spark/Databricks/Synapse, returns match weights (needs technical build and human review) and pairs well as a heavy-duty matcher feeding MDM.

AI-written summary · about

  1. 0:00Introduction to the challenge
  2. 1:32Understanding record linkage
  3. 2:31Master data management (MDM)
  4. 6:40Introduction to Splink
  5. 10:28Splink's matching methodology
  6. 14:25Splink performance and pros/cons
  7. 16:30Conclusion and Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.