Social Media Vs. Artificial Intelligence
MAT 259, 2022
Qing Huang

Concept
This project intends to examine whether the development history of social media and artificial intelligence are aligned with check-out book records in the Seattle library. Both social media and artificial intelligence are emerging technologies that have become known to the public and led to some heated discussions.

Query
SELECT
ItemNumber,Time(cout),Date(cout),title
FROM
spl_2016.outraw
WHERE
    ((LOWER(title) LIKE '%artificial intelligence%')
        OR '%ai%')
  AND YEAR(cout) <= '2022';

SELECT
ItemNumber,Time(cout),Date(cout),title
FROM
spl_2016.outraw
WHERE
((LOWER(title) LIKE '%social media%')
        OR '%social networking site%'
        OR '%social networking sites%')
          AND YEAR(cout) <= '2022';
            

Preliminary sketches
The dataset has 14670 rows with three dimensions: ItemNumber (transformed), Time (10 AM-8 PM), and Date (2006-2022). The dataset also includes a count of the number of records and two categories: 1) social media and 2) AI.


Process
The code maps time and item number values to a specific range for visualization purposes. However, outliers in the time dimension may not be appropriately adjusted. Additionally, the item number is calculated based on a specific formula and may not accurately represent the number of unique items. To improve the visualization, better use of color, shape, and new functions can be implemented, and the title of the book can be shown when the mouse hovers over it.




Final result
By visualizing these two concept-related books' check-out records together within a 3D model, we can gain insights into how the public gets to learn about new technologies through borrowing book from the library (time, date, itemNumber).

Usage: 1. A mouse left-drag will rotate the camera around the subject.
2. A right drag will zoom in and out.
3. A double-click restores the camera to its original position.
4. rotation










Code
All work is developed within Processing
Source Code + Data