Media Arts and Technology

This is the first project in Processing. You will import a MySQL query into Processing and visualize it. There are a few steps to do this.

Step1: Doodle: Due on Tuesday, January 29
Post your doodle/sketch of what the visualization may look like. Include, an introduction, a working query to run in Processing. Describe the concept of the visualization, the query, an explanation. Visit examples at http://vislab.mat.ucsb.edu/2012.html

Step2: Visualization: Due on Thursday, January 31
Create the visualization based on the class demos given on Jan 24. Add this to your doodle posting. Also attach the code,

Hi,

Here's my mockup for HW2. It has some notes that I think might help me with the Processing code.

https://docs.google.com/file/d/0B0pO4Q- ... I0OU0/edit

Libraries:

de.bezier.data.sql

Screenshot and Processing code attached.

From the visualization we see that the checkouts of books containing the word 'earth' and 'moon' follow similar trends over time. Generally, the 'moon' was present more often in book titles in 2011.


Thanks,

Anastasiya

Hi all,

Here is the link to my first vis. mock-up.

https://docs.google.com/document/d/1w90 ... XT-Bs/edit

Hi,

Here is my doodle link

https://docs.google.com/file/d/0BxTPhw- ... RZNGc/edit


Yeu-Shuan Tang

Hi all,

Here's the link to my doodle + viz is attached.

https://docs.google.com/document/d/15fp ... sqVbe8/pub

Link to my visualization:

https://docs.google.com/document/d/10f6 ... A2DlE/edit

hw2 link

https://docs.google.com/document/d/1HNW ... w47PE/edit#

Here's my HW2:
https://docs.google.com/document/d/1rDG ... plrqc/edit

Pearl Jam's Popularity at SPL from 2006 to 2012

Explanation
My initial question was "Does an artist's popularity increase after their death?" This had a couple issues: the first was that (at the time) the database did not include the artist of the work. I remedied this by using Ruby to retrieve an artist's album list from Spotify and then insert it into a query. Now, thanks to Jay's extras table, this can be accomplished (give or take some omissions) with an inner join. The other issue was mapping an artist to multiple bands they had been members of. I never got around this and instead chose my favourite band.

The spike in October coincides with Pearl Jam's 8th appearance at Neil Young’s Bridge School Benefit and their 20th anniversary as a band.

Query
This, using the accompanying Ruby script, calculates the number of times any of an artist's albums are checked out per month. This version requires outside computation using Spotify to map an artist to a list of albums, but Jay Kang's extras table removes the need for that step.

SELECT count(*), DATE_FORMAT(o,"%Y-%m") as checkout_month
FROM title, activity, kind
WHERE
title.bib = activity.bib AND
activity.item = kind.item AND
title like [album_list] AND
substr(kind,3) = "cd" AND
year(o) > 2005 AND
year(o) < 2013
GROUP BY checkout_month;


Results The left-most section was meant to contain additional query information, but I wasn't able to get text rendering working before switching to using Processing.

Code
The Allocore file and the data corellation script are attached as a zip file.
This requires https://github.com/AlloSphere-Research-Group/AlloSystem .

My proposed doodle:
https://docs.google.com/document/d/14oU ... B2La0/edit
And the Code base for it:
https://docs.google.com/file/d/0B7PkP8N ... Q4cVU/edit
https://docs.google.com/file/d/0B7PkP8N ... sp=sharing

A picture:
https://docs.google.com/file/d/0B7PkP8N ... sp=sharing