Quentin's Films and His Oscar Years
MAT 259, 2016
Yan Kong
Concept
Quentin Tarantino is famous for his unique violence aesthetics. And his filmmaking style has won him tons of Academy awards nomination and several Oscars. In 2010, 2013 and 2016, his Inglorious Basterds, Unchained Django and the Hateful Eight are all nominated. It will be interesting to see the correlation between his nomination years and his films' checkouts in SPL in those years.
Query
SELECT
bibNumber,
itemType,
title,
COUNT(bibNumber) AS Counts,
SUM(CASE
WHEN (YEAR(cout) = 2006) THEN 1
ELSE 0
END) AS '2006',
SUM(CASE
WHEN (YEAR(cout) = 2007) THEN 1
ELSE 0
END) AS '2007',
SUM(CASE
WHEN (YEAR(cout) = 2008) THEN 1
ELSE 0
END) AS '2008',
SUM(CASE
WHEN (YEAR(cout) = 2009) THEN 1
ELSE 0
END) AS '2009',
SUM(CASE
WHEN (YEAR(cout) = 2010) THEN 1
ELSE 0
END) AS '2010',
SUM(CASE
WHEN (YEAR(cout) = 2011) THEN 1
ELSE 0
END) AS '2011',
SUM(CASE
WHEN (YEAR(cout) = 2012) THEN 1
ELSE 0
END) AS '2012',
SUM(CASE
WHEN (YEAR(cout) = 2013) THEN 1
ELSE 0
END) AS '2013',
SUM(CASE
WHEN (YEAR(cout) = 2014) THEN 1
ELSE 0
END) AS '2014',
SUM(CASE
WHEN (YEAR(cout) = 2015) THEN 1
ELSE 0
END) AS '2015',
SUM(CASE
WHEN (YEAR(cout) = 2016) THEN 1
ELSE 0
END) AS '2016',
SUM(CASE
WHEN (YEAR(cout) = 2017) THEN 1
ELSE 0
END) AS '2017'
FROM
spl_2016.outraw
WHERE
title = 'Reservoir dogs'
or title = 'Pulp fiction'
OR title = 'Pulp fiction the complete story of Quentin Tarantinos masterpiece'
OR title = 'Quentin Tarantinos Death proof original soundtrack'
OR title = 'Kill Bill volume 1'
OR title = 'Kill Bill Vol 2 original soundtrack'
OR title = 'Kill Bill Vol 2'
OR title = 'Kill Bill Vol 1 original soundtrack'
OR title = 'Kill Bill diary the making of a Tarantino classic as seen through the eyes of a screen legend'
OR title = 'Jackie Brown a screenplay'
OR title = 'Jackie Brown a Quentin Tarantino film music from the Miramar motion picture'
OR title = 'Jackie Brown'
OR title = 'Inglourious Basterds'
OR title = 'hateful eight'
OR title = 'Django unchained original motion picture soundtrack'
OR title LIKE '%Django Unchained%'
OR title = 'Death proof'
OR title = 'Death proof original soundtrack'
GROUP BY bibNumber , itemtype, title
ORDER BY Counts DESC
Preliminary sketches
My visualization strategy is inspired by the radar system. On a radar panel, a circular area is divided equally into squential sectors. The target will show up on the panel when it is being scanned and then fade out. Also, when the target is closer to the center, it is closer to the radar.
Similarly, in my visualization, years are represented as sequential sectors in a circle. As a pointer scans through these areas, the corresponding yearly checkouts, which is represented by points, will show up and gradually fade out when the pointer leaves. The quantity of checkouts is shown by the size of each point.
Process
Quentin has 9 movies, so I assign every one of them a unique color and put it in a fixed orbit just like the solar system. Every film circles around the center, like 8 stars circles around the sun.
Final result
This radar scanning system demonstrates the popularity of Quentin Tatantino's movies and correlations between checkouts each year and Quentin's Oscar winning moments.
It's easy to distinguish that in 2010, 2013 and 2016, there are big dots and cluster lying in its area, which show drastic increases for its yearly checkouts. And checkouts for his old movies also increases a little bit in his Oscar years.
According to our instructor's idea, I add UI to allow users to see the static overview of this visualization.
Press key '1': show the overview without data points fading out and scanning effect.
Press key '2': show the scanning system.
Code