Home / Services / Entity resolution

Entity resolution that holds up in production.

One customer, one record, with the evidence for every merge. We build resolution pipelines that survive audit, not demos that score well on clean data.

Every company past a certain size has the same quiet problem. One customer exists four times. The CRM knows them as Robert J. Okafor, billing has Bob Okafor, the support desk typed Rbert Okafor, and a 2019 acquisition brought in a sixth record nobody has touched since. Revenue reporting counts them separately. Fraud models treat them as strangers. The AI assistant you just deployed answers questions about all six as though they were unrelated.

Exact matching finds the easy cases and misses the expensive ones. What works is a sequence: deterministic rules where identifiers are reliable, probabilistic scoring where they are not, and graph traversal where neither is enough on its own but the connections between records settle it.

What an entity resolution engagement includes.

The pipeline, the evidence trail, and the human process around the close calls.

Deterministic matching

Rules first, because they are cheap, explainable and correct where identifiers are reliable. Normalise, then match on the fields that genuinely identify a person or company, and know exactly where the rules stop working.

Normalisation and standardisationComposite key rulesCoverage measurement

Probabilistic scoring

String similarity, field weighting and a calibrated threshold, so a near match becomes a score rather than a guess. Jaro-Winkler for typos, token methods for reordering, phonetic methods where they earn their place.

Field weighting and calibrationUpper and lower thresholdsSplink, dedupe and recordlinkage where they fit

Graph traversal

The cases pairwise comparison cannot reach. Two records that share nothing directly but connect through a third: same address, same device, same employer. Connected components over the match graph resolve clusters, not just pairs.

Match graph constructionConnected components and clusteringWeighted evidence across attribute types

Blocking that scales

The naive version compares every record against every other and dies at a million rows. Blocking narrows the candidate set without losing the matches that matter, and getting the blocking keys right is most of the engineering.

Blocking key designRecall measurement on held-out pairsIncremental resolution for new records

Golden records and lineage

Merging is not deleting. Every golden record keeps which source rows contributed, which rule or score caused the merge, and when. That lineage is the difference between a system compliance signs off and one they refuse.

Survivorship rulesFull merge lineage and audit trailUnmerge path for corrections

Review queues

The band between the thresholds is where humans belong. We build the queue, the interface and the feedback loop so the reviewers' decisions improve the model instead of disappearing into a spreadsheet.

Clerical review workflowFeedback into threshold tuningThroughput and agreement measurement

Where this has run.

H-E-BIdentity resolution improved by 50% across systems with no shared key.
Bank of AmericaResolved parties underpinning more than $2B in surfaced fraud patterns.
PRACRecipients matched across pandemic-relief programs for federal oversight.
Private equityPortfolio entities reconciled into one ownership view.

How an engagement runs.

  1. 01
    AssessWe measure what you have: duplicate rate, field reliability, and which identifiers can carry a deterministic rule. Usually the first real answer anyone has had on the size of the problem.
  2. 02
    PilotA resolution pass over one domain, scored against a labelled sample so precision and recall are numbers rather than impressions.
  3. 03
    BuildThe production pipeline: blocking, matching, clustering, survivorship and lineage, running incrementally as new records arrive.
  4. 04
    OperateReview queue, monitoring and threshold tuning, with the documentation your auditors will ask for.

Three ways to start.

Every engagement opens with your data and your question, never a slide deck.

Kickstart

A working session and a plan

$500

  • 90 minutes on your data and your question
  • An action plan with tools and next steps
  • Email support for a week afterwards
Get started

Deployment

A Neo4j solution you own in 60 days

Customscoped to your data

  • A precise graph model, built for production load
  • Hidden risks surfaced with our 6-Degree Pattern Detection Blueprint
  • Results in 60 days, or we keep working free
Book a call

Embedded

A consultant inside your team

Customfull time

  • Dedicated Neo4j and analytics capacity
  • Strategy built around your objectives
  • Training and optimization as you grow
Get a quote

The 60-day guarantee. If a deployed solution is not delivering in 60 days, we keep working at no charge until it does.

Common questions

How accurate is it?

That depends on your data, and any number quoted before seeing it is marketing. What we commit to is measuring it honestly: precision and recall against a labelled sample, reported separately, with the false positives shown to you rather than averaged away.

Can you do this without moving our data?

Yes. The pipeline runs in your environment, on your infrastructure. For teams who want a resolution pass without standing up a graph database at all, Bridgr builds the graph on the fly from your files and discards it afterwards.

What about false merges?

They are the expensive error, so the design is asymmetric on purpose. The upper threshold merges automatically, the lower one rejects, and everything between goes to a human. Every merge is reversible because the lineage is kept.

Do we need Neo4j for this?

Not necessarily. The deterministic and probabilistic stages run in Python or Spark. The graph stage needs a graph, but that can be an in-memory one for a batch run. Neo4j earns its place when resolution is continuous and the graph is queried for other things too.

How does this connect to our AI work?

Directly. Retrieval over unresolved records returns four partial answers about the same customer and no way to tell. Resolution is the prerequisite for a knowledge graph that an LLM can be trusted to read.

Bring a data problem. Leave with a plan.

  • A straight answer on whether your problem is graph shaped, and what it would take.
  • A first sketch of the model: the entities, the relationships, the question it answers.
  • Next steps in writing within a day, whether or not we work together.
Tim EastridgeFounder. Thirty minutes, no slide deck.
30 minvideo callFreeno obligationSame weekusually
Book a call

Or email info@eastridge-analytics.com