Abstract

A method is disclosed for resolving an inbound telephone caller to exactly one contact record. Two probes — an optional e-mail address and an optional telephone number that must already be in strict international form — become lookup keys; one query returns every row matching either key up to a cap chosen greater than one, never a single "best" row; and a pure function maps that candidate set onto one of five named outcomes in a fixed precedence order. Three outcomes are refusals: the system reports that it does not know who called rather than picking a plausible row. Writes obey a write-once law — a match key is written when a row is created and never again by this path, with one narrow exception stamping the key that just matched onto the row it matched, only where absent. A telephone match leg that accepts either the stamped key column or, for rows not yet stamped, the raw stored value lets legacy rows converge onto the key through use, without a bulk rewrite. Concurrent resolutions are serialised by one transaction-scoped advisory lock per present key, taken in a fixed order before the candidate query.

Creative Commons License

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.

Share

COinS