News for hackers. Stuff that matters.

A comment on Ask HN: What are some examples of good database schema designs?. Parent comment

Re:Ask HN: What are some examples of good database schema de... by jacques_chester on Friday February 14, 2020 @07:54AM (#22326098)
There's a whole subfield of information science dedicated to basically this exact problem: entity resolution.

Hilariously, it has dozens of names, because it just comes up in so many places for so many people. It appears that "record linkage" is the term that has won the top spot at Wikipedia: https://en.wikipedia.org/wiki/Record_linkage

[ Parent | on HN ]
Re:Ask HN: What are some examples of good database schema de... by eska on Saturday February 15, 2020 @07:52AM (#22335002)
Record linkage seems to be unrelated. While OP isn't sure how to segregate and join data, he has perfect joining capability through unique indices.

Record linkage seems to be concerned with joins that aren't guaranteed to be correct because there are no unique keys.

[ Parent | on HN ]