Blocking Algorithms for Real-World Applications from Fraud Detection to LLMs

When working on the common data engineering problem of identifying which records across two different databases correspond to the same real-world entity — a process known as record linkage — one inevitably runs into issues associated with the worst-case quadratic complexity of doing pairwise comparisons. To understand where things can get computationally heavy, let’s look … More Blocking Algorithms for Real-World Applications from Fraud Detection to LLMs

A Note on Large Scale Data Matching and Entity Resolution

Data matching and entity resolution is a common first step in data preparation and there is a thousand academic papers written on the subject in the literature. In practice, for large datasets – anything more than a million records will do as a definition of large here because most data-matching algorithms can’t handle that because … More A Note on Large Scale Data Matching and Entity Resolution