Question: Problem 4.8. Consider the following two relations PRODUCT and ARTICLE that are specified in a simplified SQL notation. The perfect schema matching correspon- dences are

Problem 4.8. Consider the following two relations PRODUCT and ARTICLE that are specified in a simplified SQL notation. The perfect schema matching correspon- dences are denoted by arrows. 4.7 Bibliographic Notes 165 PRODUCT ARTICLE id: int PRIMARY KEY -Key: varchar(255) PRIMARY KEY Name: varchar(255)> Title: varchar(255) DeliveryPrice: float Description: varchar(8000) Information: varchar(5000) Price: real For each of the five correspondences, indicate which of the following match approaches will probably identify the correspondence: (a) 1. Syntactic comparison of element names, e-g.using edit distance string 2. 3. 4. similarity Comparison of element names using a synonym lookup table Comparison of data types Analysis of instance data values (b) Is it possible for the listed matching approaches to determine false correspon dences for these match tasks? If so, give an example. Problem 4.8. Consider the following two relations PRODUCT and ARTICLE that are specified in a simplified SQL notation. The perfect schema matching correspon- dences are denoted by arrows. 4.7 Bibliographic Notes 165 PRODUCT ARTICLE id: int PRIMARY KEY -Key: varchar(255) PRIMARY KEY Name: varchar(255)> Title: varchar(255) DeliveryPrice: float Description: varchar(8000) Information: varchar(5000) Price: real For each of the five correspondences, indicate which of the following match approaches will probably identify the correspondence: (a) 1. Syntactic comparison of element names, e-g.using edit distance string 2. 3. 4. similarity Comparison of element names using a synonym lookup table Comparison of data types Analysis of instance data values (b) Is it possible for the listed matching approaches to determine false correspon dences for these match tasks? If so, give an example
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
