Entity Identification in Database Integration

• Main Authors: LIM, Ee Peng, SRIVASTAVA, Jaideep, PRABHAKAR, Satya, RICHARDSON, James
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 1993
• Subjects: ILFD; completeness; database integration; distinctness rules; entity identification; extended key; extended key attribute values; instance level; instance level functional dependencies; integrated world; object instances; real-world entities; schema level heterogeneity; semantic constraint information; tuple; Databases and Information Systems; Numerical Analysis and Scientific Computing
• Online Access: https://ink.library.smu.edu.sg/sis_research/925; https://ink.library.smu.edu.sg/context/sis_research/article/1924/viewcontent/1_s2.0_0020025595001859_main.pdf
• Institution: Singapore Management University

The objective of entity identification is to determine the correspondence between object instances from more than one database. Entity identification at the instance level, assuming that schema level heterogeneity has been resolved a priori, is examined. Soundness and completeness are defined as the desired properties of any entity identification technique. To achieve soundness, a set of identity and distinctness rules are established for entities in the integrated world. The use of extended key, which is the union of keys, and possibly other attributes, from the relations to be matched, and its corresponding identify rule are proposed to determine the equivalence between tuples from relations which may not share any common key. Instance level functional dependencies (ILFD), a form of semantic constraint information about the real-world entities, are used to derive the missing extended key attribute values of a tuple.