Search found 5 matches

by christopherchen0
Mon Mar 20, 2017 3:40 pm
Forum: Winter 2017
Topic: 4 Student Defined Final Project
Replies: 10
Views: 9415

Re: 4 Student Defined Final Project

My goal for this project was looking at interesting ways to create connections within a set of data. I knew from the start, I wanted to do something with music as I have a somewhat familiar relationship with it. I turned towards Spotify – a music streaming/social media platform because it had an int...
by christopherchen0
Thu Feb 23, 2017 3:36 am
Forum: Winter 2017
Topic: 3D Visualization
Replies: 10
Views: 8400

Re: 3D Visualization

I was interested in patterns of how checkout times and dates reflected on checkout durations. For this representative data set, I focused my ideas on three main search terms: cyber, virtual, and digital as I believed this would help to create the overall design of my visualization. digital.png My qu...
by christopherchen0
Tue Jan 31, 2017 11:31 am
Forum: Winter 2017
Topic: 2D Frequency Pattern Visualization
Replies: 11
Views: 8848

Re: 2 2D Frequency Pattern Visualization

My question was how different media types experience variation in popularity over the course of a ten year period. Seeing as how different media formats go out of fashion with the advent of newer platforms, I wanted to track when certain media types experience life, growth, or death. My query: SELEC...
by christopherchen0
Thu Jan 19, 2017 4:50 pm
Forum: Winter 2017
Topic: 1 Advanced MySQL: Frequency Pattern
Replies: 10
Views: 7574

Re: 1b Advanced MySQL: Frequency Pattern

As the number and formats of media change - especially in the last 20 or 30 years, some are eventually phased out while others remain popular. When it comes to this dataset, I wanted to investigate those sorts of changes within a decade in the context of library checkouts, from 2006-2016. Ultimately...
by christopherchen0
Thu Jan 12, 2017 12:57 am
Forum: Winter 2017
Topic: 1a Basic MySQL
Replies: 11
Views: 9298

Re: 1a Basic MySQL

Question 1: How many items about gluten were checked out prior to 2007? SELECT DISTINCT spl_2016.title.title, spl_2016.collectionCode.itemNumber, spl_2016.transactions.checkOut FROM spl_2016.transactions INNER JOIN spl_2016.title ON spl_2016.transactions.bibNumber = spl_2016.title.bibNumber INNER J...