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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!