Search found 5 matches

by freeberg
Sat Mar 18, 2017 9:42 am
Forum: Winter 2017
Topic: 4 Student Defined Final Project
Replies: 10
Views: 9333

Re: 4 Student Defined Final Project

WikiViz : Visualizing ~16,000 Wikipedia articles by their text-based Principle Components. The visualization opens with each Wikipedia article represented as a sphere in 3D space. Each sphere is positioned by their 1st, 2nd, and 3rd Principle Components. The remaining Principle Components determine...
by freeberg
Fri Feb 24, 2017 7:37 pm
Forum: Winter 2017
Topic: 3D Visualization
Replies: 10
Views: 8348

Re: 3D Visualization

Project Name : The Vinyl Frontier Question : My original question was to investigate the volume and genres of the CD's checked out from the Seattle Public Library. However, I came to find out that there is a massive number of CDs checked out every year, so I could not look look at all CD's over a w...
by freeberg
Tue Jan 24, 2017 11:05 am
Forum: Winter 2017
Topic: 2D Frequency Pattern Visualization
Replies: 11
Views: 8792

Re: 2 2D Frequency Pattern Visualization

Analysis of Jason Bourne Movies Primary Question : Does the release of a new Jason Bourne movie prompt the library's patrons to check out the previous titles? Secondary Questions : How often are the patrons checking out these items? For how long do they keep them checked out? Layout : Each move titl...
by freeberg
Wed Jan 18, 2017 10:36 pm
Forum: Winter 2017
Topic: 1 Advanced MySQL: Frequency Pattern
Replies: 10
Views: 7529

Re: 1b Advanced MySQL: Frequency Pattern

Question : How often do residents of the greater Seattle area check out materials relating to common hobbies or skills? Some examples of hobbies and skills include gardening, cooking, programming, and housekeeping. (I am an avid hobbyist. I like to learn new disciplines deep enough to make them enj...
by freeberg
Wed Jan 11, 2017 10:58 pm
Forum: Winter 2017
Topic: 1a Basic MySQL
Replies: 11
Views: 9236

Re: 1a Basic MySQL

Question 1: How often are books about Donald Trump being checked out? The Query: I wanted a count for each ISBN, counting the number of times that material was checked out. To get this I used a sub-query and joined on it. Results are ordered by the most recent checkouts. The query ran in 22.2 secon...