Where year 2001 will generate duplicates candidate

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: le MID TITLE YEAR REVIEW MID TITLE YEAR REVIEW m1 Big Fish 2003 8.1/10 m1 Big Fish 2003 8.1/10 m2 Public Enemies 2009 7.4/10 m2 Public Enemies 2009 7.4/10 m3 Public Enemies 09 null m3 Public Enemies 09 null m4 Big Fish 2003 7.5/10 m4 Big Fish 2003 7.5/10 1. Decide which object representa/ons are subject to duplica/on •  A rela/onal table named Movie. •  The schema of the Movie rela/on –  Do we search only for duplicates within movies? –  Or do we have any condi/on to decide? –  e.g. SELECT *! FROM Movie! WHERE Year >=2001! Will generate Duplicates Candidate with the type T, T={c ,c ,…,c } , CMovie={m1, m2, m3, m4} C 12 n –  < MID, Title, Year, Review > •  Four records –  e.g. < m1, Big Fish, 2003, 8.1/10 > Sangmi Lee Pallickara, CS480, Spring 2012 Sangmi Lee Pallickara, CS480, Spring 2012 19 CS480 Principles of Data Management Spring 2013 20 CS480 Principles of Data...
View Full Document

This note was uploaded on 02/11/2014 for the course CS 480 taught by Professor Staff during the Spring '08 term at Colorado State.

Ask a homework question - tutors are online