Midterm

Question 1

A -> B
B -> C
so Link A-> C

Answer 1

Transitive Closure

Question 2

After an ER process links a cluster of references, only one reference is retained

Answer 2

Survivor Record MDM

Question 3

Survivor EIS where you select one ‘best’ record from the cluster to represent the identity

Answer 3

Best Reference Style

Question 4

Survivor EIS where you create a new record from the best parts of records in the cluster

Answer 4

Exemplar Reference Style

Question 5

• Master identifier
• Identity attributes
• Application information

Answer 5

Components of MDM architecture

Question 6

What MDM architecture is good for cybersecurity?

Answer 6

External reference

Question 7

What MDM architecture stores no identify information in the IKB?

Answer 7

External reference

Question 8

What MDM architecture components are stored in IKB in external reference?

Answer 8

Master identifier

Question 9

What MDM architecture components are stored in IKP in registry?

Answer 9

Master identifier and Identity attributes

Question 10

What MDM architecture is the registry schematic with the cross walk added?

Answer 10

Reconciliation Engine

Question 11

What MDM architecture stores all components in the IKB?

Answer 11

Transaction Hub

Question 12

What MDM architecture components are stored in the IKB in Transaction Hub?

Answer 12

Master identifier, identity attributes, and application information

Question 13

What are the methods of updating IKB in MDM?

Answer 13

Automatic and manual

Question 14

What is the output of Entity Resolution?

Answer 14

A link index

Question 15

1 cause of data quality issues?

Answer 15

Multiple sources of the same information

Question 16

Three parts of entity-based data integration

Answer 16

1. Standardization
2. Entity Resolution
3. Rationalization

Question 17

References to the same entity are called…

Answer 17

Equivalent References

Question 18

Every entity reference in an information system is created with the intention to reference one, and only one, real-world entity.

Answer 18

Unique Reference Assumption

Question 19

The higher the degree of similarity between two entity references, the higher the probability the references are
equivalent, and the less similar, the less likely they are equivalent

Answer 19

Reference Similarity Assumption

Question 20

Precision Formula

Answer 20

P=TP/(TP+FP)

Question 21

Recall Formula

Answer 21

R=TP/(TP+FN)

Question 22

F-Measure Formula

Answer 22

F= (2 x P x R)/(P + R)

Question 23

Accuracy Formula

Answer 23

(TP+TN)/(TP+FP+TN+FN) = (TP+TN)/D

Question 24

How do you calculate unordered pairs?

Answer 24

N*(N-1)/2

Question 25

CSRUD Model

Answer 25

• Capture of Entity Identity Information • Store and Share Entity Identity Information • Resolve and Retrieve Entity Identifiers • Update Entity Identity Information • Dispose (Retire) Entity Identity Information

Question 26

Capture Phase Activities

Answer 26

1. Assess the data quality of each identity source, plan the cleansing and standardization processes 2. Profile and select candidates for primary and supporting identity attributes 3. Setup entity identity integrity assessment methods, 4. Craft the matching rules or build ML model 5. Evaluate and refine the rules/model to acceptable levels of false positive and false negative error 6. Develop blocking strategy

Question 27

biggest enemies of ER

Answer 27

inconsistent representation of values and missing values

Question 28

Measures of discrimination power

Answer 28

• Attribute Uniqueness • Attribute Entropy • Attribute Weight

Question 29

Attribute Uniqueness Formula

Answer 29

𝐶𝑜𝑢𝑛𝑡 𝑜𝑓 𝑈𝑛𝑖𝑞𝑢𝑒 𝑁𝑜𝑛𝑁𝑢𝑙𝑙 𝑉𝑎𝑙𝑢𝑒s /𝐶𝑜𝑢𝑛𝑡 𝑜𝑓 𝑁𝑜𝑛𝑁𝑢𝑙𝑙 𝑉𝑎𝑙𝑢𝑒

Question 30

What are the three levels of ER matching?

Answer 30

1. Attribute level 2. Record level 3. Cluster level

Question 31

What do you call and algo to compare attribute values?

Answer 31

Comparator

Question 32

What are the three types of similarity functions for string values?

Answer 32

1. Approximate Syntatic Match (ASM) 2. Approximate Semantic Match 3. Phonetic Match

Question 33

The minimum number of single character changes that will transform one string into the other

Answer 33

Levenshtein Edit Distance

Question 34

Same as Levensthein, but allows one additional string manipulation, transpose adjacent characters

Answer 34

Damereau-Levenshtein Edit Distance

Question 35

Based on the number of characters in common and number of transpositions between two strings S1 and S2

Answer 35

Jaro String Comparator

Question 36

Modification of Jaro Comparator which gives added weight to the first four prefix characters

Answer 36

Jaro-Winkler

Question 37

Replace 'A', E', 'I', 'O', 'U', 'H', 'W', 'Y‘ with “0” (zero) after the first letter, change letters to digits

Answer 37

Soundex Algorithm

Question 38

Tries to measure similarity according to linguistic meaning rather than by character structure.

Answer 38

Approximate Semantic Match

Question 39

Two types of supervised MDM

Answer 39

1. Bring-Your-Own-Identifier MDM 2. Once-and-Done MDM

Question 40

Two types of unsupervised MDM

Answer 40

1. Survivor Record MDM 2. Full-Context MDM

Question 41

Two types of record updates in MDM

Answer 41

1. Automated (Unsupervised) 2. Manual (Supervised)

Question 42

Two types of assertions

Answer 42

1. Correction affirmation 2. Confirmation affirmation

Question 43

Type of assertion to correct the error that two structures are false negatives of each other

Answer 43

Structure-to-Structure

Question 44

Type of assertion to correct the error that a structure has references to more than one identity

Answer 44

Structure-split Assertion

Question 45

Type of assertion which corrects both a false positive and false negative in one operation

Answer 45

Reference-transfer Assertion

Question 46

Asserts that a structure has been reviewed and found to be a true positive

Answer 46

True Positive Assertion

Question 47

Asserts two or more structures have been reviewed and found to be true negatives

Answer 47

True Negative Assertion

Question 48

Which type of assertion creates a cluster from specific set of input references

Answer 48

Reference to Reference Assertion

Question 49

Which type of assertion adds a specific set of input references to a specific structure

Answer 49

Reference-to-Structure Assertion