Index Project Extra Credit II

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.

  1. (Up to 50%) Build indexes for ACTORS table in Oracle for the following query:
    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.
  2. (Up to 50%) Build indexes and/or more tables for finding The Oracle of Bacon for any two actor/actress names. You will need to write a program that will accepts 2 actor/actress names and show the results. For example, if the given names are Kevin Bacon and Emma Watson (II), then an example result would be
    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.
  3. (10%) Build a website like the Oracle of Bacon above that works for any two actor/actress names.