** ======================================================== ** MAT259 Visualizaing Data | Winter 2011 | George Legrady ** ======================================================= ** Project 2 : Top 100 Most Checked Out Items from 2005 to 2010 ** ============================================================= ** Nichole Stockman ** ================ ** ** ** ** ============================================================================ ** THE DATASET ** ============================================================================ ** XML dataset stored in a mySQL database containing information on checked-out ** items (books, cds, movies, etc.) from the Seattle Public Library. The data ** has been continuously recorded since August, 2005 and includes information ** from earlier dates. ** ** ** ** ============================================================================ ** PROJECT DESCRIPTION AND THE DATA IT USES ** ============================================================================ ** This project displays a treemap. In the initial view, squares represent only ** the 10 main Dewey categories to which the top 100 most checked out items ** belong. However, left-clicking a square will divide it into squares ** representing the individual items. ** ** The size of each square is determined by the number of times the item was ** checked out between 2005 and 2010. The square's brightness is determined by ** whether the items was a book, cd or dvd. ** ** ** ** ============================================================================ ** FUNCTIONALITIES OF THE APPLICATION ** ============================================================================ ** ** Left-Click ** ---------- ** In the main view, this will divide a category square into smaller squares ** representing items in that category. ** ** If a square is already divided, this will zoom into the category. ** ** ** Right-Click ** ----------- ** This will either hide the contents of a category or it will zoom out of the ** category depending on which state the treemap is in ** ** ** Keys ** ----------- ** Pressing 'i' will toggle displaying the information box when hovering ** over items. ** ** ** ** ============================================================================ ** PARSING THE DATA ** ============================================================================ ** MySQL Query Browser was used to make queries to the database and obtain a ** list of the top 100 items which were checked out the most number of times. ** The result was stored as a text file. ** ** ** ** ============================================================================ ** TO DO ** ============================================================================ ** - Change info box style.. include link to the item on wikipedia or amazon ** - ** ** ** ** ============================================================================