November 2017
Beginner to intermediate
366 pages
7h 59m
English
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 ...
Read now
Unlock full access