Book 1970 - Reorder Matrix
MAT 259, 2015
Rodger (Jieliang) Luo
I'm still very interested of the books being "checked out" at 1970-01-01. Since it was a kind of system error, then I'm curious about the reasons of the error. After exploring the database, I found some books in the "1970" category had been checked out several times, which means the system error occurred to these books every time they were checked out, but didn't occur to the book being checked out before or after. Apparently, it doesn't look like coincidence. Therefore, this data visualization is trying to dig out more information of those books.
COUNT(inraw.itemNumber) AS NumberOfTimes,
FLOOR(inraw.deweyClass / 100) * 100 AS Dewey,
cout = '1970-01-01'
GROUP BY itemNumber
HAVING (COUNT(itemNumber) > 1)
ORDER BY NumberOfTimes DESC
Arc diagram is a very interesting data visualization form to present inner connections among data. If each book is drawn as a circle, then the color and radius of the circle can represent two attributes of the data, which functions like x-y axises in the traditional 2d matrix.
As a matter of fact, the initial attention of this project was to design a self-organizing map based on the the first project, Forgotten Books. However, it didn't look visually interesting.
Be inspired by the above image of all the circles horizontally aligned and were connected with arcs, it's not a bad idea to reorder the matrix as an arc form.
All work is developed within Processing
Move the mouse on each circle to see details of that book.
Left click the mouse to see the overview.
Source Code + Data