In a large database of records, synonymous records pose a great problem. Two records referring to the same entity are considered to be synonymous. In the absence of a common identifier, such as a primary key or foreign key, joining such records based on the entities is a tough task. Let's illustrate this with a quick example. Consider the following two records:
| Sno | First name | Middle name | Last name | Address | City | State | Zip |
| 1 | John | NULL | NULL | 312 Delray Ave | Deer Field | FL | 33433 |
| 2 | John | NULL | Sanders | 312 Delray Beach Ave | Deer Field | FL | 33433 |
Both the records refer to the same entity, one Mr. John. Record linkage refers to an umbrella of algorithms that are designed to solve the ...
