IMDB indexing in Oracle
Download actorsDML.zip from Blackboard->Course Documents->Index Project Files. In the zip file, you will find actor_DML.sql and actress_DML.sql that populates the ACTORS table (definition in Blackboard). You may want to break these files into several smaller files for easier management.
There are 3 categories for extra credit.
SELECT DISTINCT A.name FROM actors A WHERE A.movie IN (SELECT A1.movie FROM actors A1 WHERE A1.name = 'GIVENACTORNAME')For example, if the given name is "Firth, Colin", then the query looks like
SELECT DISTINCT A.name FROM actors A WHERE A.movie IN (SELECT A1.movie FROM actors A1 WHERE A1.name = 'Firth, Colin')The fastest database will earn extra 50% of the indexing project grade, 2nd fastest 40%, and so on.
Bacon, Kevin -> Novocaine (2001) -> Carter, Helena Bonham -> Harry Potter and the Deathly Hallows: Part 2 (2011) -> Watson, Emma (II)This category will be graded based on how many pairs' connection you find out of 100 pairs we will randomly select and test. The names will be provided in the same format as in the database.