Proj2 - Visualize an SQL Query in Processing

glegrady
Posts: 203
Joined: Wed Sep 22, 2010 12:26 pm

Proj2 - Visualize an SQL Query in Processing

Post by glegrady » Sun Jan 13, 2013 5:46 pm

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,
George Legrady
legrady@mat.ucsb.edu

anastasiya
Posts: 6
Joined: Fri Jan 11, 2013 10:32 am

Re: Proj2 - Visualize an SQL Query in Processing

Post by anastasiya » Fri Jan 25, 2013 3:15 pm

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
Attachments

[The extension tiff has been deactivated and can no longer be displayed.]

Lazareva_Anastasiya_MAT_HW2.zip
Processing File
(1.52 KiB) Downloaded 259 times
Last edited by anastasiya on Thu Mar 07, 2013 12:09 pm, edited 3 times in total.

danasolomon
Posts: 2
Joined: Fri Jan 11, 2013 10:35 am

Re: Proj2 - Visualize an SQL Query in Processing

Post by danasolomon » Mon Jan 28, 2013 2:16 pm

Hi all,

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

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

ytang
Posts: 5
Joined: Fri Jan 11, 2013 10:37 am

Re: Proj2 - Visualize an SQL Query in Processing

Post by ytang » Mon Jan 28, 2013 10:50 pm

Hi,

Here is my doodle link

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


Yeu-Shuan Tang
Attachments
MAT259proj2.docx
Description
(360.82 KiB) Downloaded 259 times
Screen Shot 2013-03-20 at 10.36.58 PM.png
Screen Shot 2013-03-20 at 10.36.51 PM.png
proj2_yeushuan.zip
(455.12 KiB) Downloaded 258 times
Last edited by ytang on Wed Mar 20, 2013 11:27 pm, edited 4 times in total.

bkang
Posts: 5
Joined: Fri Jan 11, 2013 10:32 am

Re: Proj2 - Visualize an SQL Query in Processing

Post by bkang » Mon Jan 28, 2013 11:21 pm

Hi all,

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

https://docs.google.com/document/d/15fp ... sqVbe8/pub
Attachments
pjt2-jay.zip
code
(4.62 MiB) Downloaded 267 times
Last edited by bkang on Thu Jan 31, 2013 5:33 pm, edited 5 times in total.

ramon.rovirosa
Posts: 5
Joined: Tue Jan 15, 2013 1:22 pm

Re: Proj2 - Visualize an SQL Query in Processing

Post by ramon.rovirosa » Mon Jan 28, 2013 11:46 pm

Attachments
linear_visualization_sports.zip
Updated Linear Visualizaton!
(2.27 KiB) Downloaded 260 times
sports.jpg
Last edited by ramon.rovirosa on Mon Feb 04, 2013 12:58 pm, edited 6 times in total.

giovanni
Posts: 24
Joined: Fri Oct 12, 2012 9:27 am

Re: Proj2 - Visualize an SQL Query in Processing

Post by giovanni » Mon Jan 28, 2013 11:53 pm

Attachments
hw2b.png
hw2b.zip
(2.14 KiB) Downloaded 267 times
Last edited by giovanni on Thu Jan 31, 2013 3:09 am, edited 4 times in total.

gstocking
Posts: 3
Joined: Fri Jan 11, 2013 10:36 am

Re: Proj2 - Visualize an SQL Query in Processing

Post by gstocking » Tue Jan 29, 2013 9:59 am

Here's my HW2:
https://docs.google.com/document/d/1rDG ... plrqc/edit
Assignment_2.zip
(2.36 KiB) Downloaded 267 times
Last edited by gstocking on Thu Jan 31, 2013 12:16 pm, edited 1 time in total.

andrewwaranis
Posts: 5
Joined: Fri Jan 11, 2013 10:38 am

Re: Proj2 - Visualize an SQL Query in Processing

Post by andrewwaranis » Tue Jan 29, 2013 11:33 am

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
Project 2.png
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 .
Attachments
bar_line.zip
Allocore file + data correlation script
(3.57 KiB) Downloaded 209 times
Last edited by andrewwaranis on Fri Mar 29, 2013 12:55 pm, edited 5 times in total.


Post Reply