Proj2 - Visualize an SQL Query in Processing
Proj2 - Visualize an SQL Query in Processing
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,
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
legrady@mat.ucsb.edu
-
- Posts: 6
- Joined: Fri Jan 11, 2013 10:32 am
Re: Proj2 - Visualize an SQL Query in Processing
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
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 276 times
Last edited by anastasiya on Thu Mar 07, 2013 12:09 pm, edited 3 times in total.
-
- Posts: 2
- Joined: Fri Jan 11, 2013 10:35 am
Re: Proj2 - Visualize an SQL Query in Processing
Hi all,
Here is the link to my first vis. mock-up.
https://docs.google.com/document/d/1w90 ... XT-Bs/edit
Here is the link to my first vis. mock-up.
https://docs.google.com/document/d/1w90 ... XT-Bs/edit
Re: Proj2 - Visualize an SQL Query in Processing
- Attachments
-
- MAT259proj2.docx
- Description
- (360.82 KiB) Downloaded 280 times
-
- proj2_yeushuan.zip
- (455.12 KiB) Downloaded 276 times
Last edited by ytang on Wed Mar 20, 2013 11:27 pm, edited 4 times in total.
Re: Proj2 - Visualize an SQL Query in Processing
Hi all,
Here's the link to my doodle + viz is attached.
https://docs.google.com/document/d/15fp ... sqVbe8/pub
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 293 times
Last edited by bkang on Thu Jan 31, 2013 5:33 pm, edited 5 times in total.
-
- Posts: 5
- Joined: Tue Jan 15, 2013 1:22 pm
Re: Proj2 - Visualize an SQL Query in Processing
- Attachments
-
- linear_visualization_sports.zip
- Updated Linear Visualizaton!
- (2.27 KiB) Downloaded 276 times
Last edited by ramon.rovirosa on Mon Feb 04, 2013 12:58 pm, edited 6 times in total.
Re: Proj2 - Visualize an SQL Query in Processing
- Attachments
-
- hw2b.zip
- (2.14 KiB) Downloaded 284 times
Last edited by giovanni on Thu Jan 31, 2013 3:09 am, edited 4 times in total.
Re: Proj2 - Visualize an SQL Query in Processing
Last edited by gstocking on Thu Jan 31, 2013 12:16 pm, edited 1 time in total.
-
- Posts: 5
- Joined: Fri Jan 11, 2013 10:38 am
Re: Proj2 - Visualize an SQL Query in Processing
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 .
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 .
- Attachments
-
- bar_line.zip
- Allocore file + data correlation script
- (3.57 KiB) Downloaded 224 times
Last edited by andrewwaranis on Fri Mar 29, 2013 12:55 pm, edited 5 times in total.
-
- Posts: 5
- Joined: Tue Jan 22, 2013 4:49 pm
Re: Proj2 - Visualize an SQL Query in Processing
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
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
Last edited by scottbcesar on Mon Mar 25, 2013 9:42 pm, edited 1 time in total.