wk4 - 10.18.22 Discover Patterns with MySQL
Posted: Fri Sep 16, 2022 7:49 am
10.18.22 Discover Patterns with MySQL
The approach to discovering patterns is by searching the database without necessarily knowing what you will get, but eventually to arrive at something of interest that features unexpected patterns and/or unexpected associations. Concentrate on performance and volume over time based on ItemNumber, and the performance of the unique objects representing a title through barcode. (Updated Oct.18.2022 during crit)
Karl Yerkes, lecturer in the MAT program (also software developer, creative coder, and music instrument builder) did a simple project years ago that explored the serendipitous nature of a random search, asking the question "What are the first twelve items in the database that have the word "Happiness" in the title: https://www.mat.ucsb.edu/~g.legrady/aca ... reqmap.pdf Once he had the data for the twelve items he then did a frequency map of how the items performed over a period of time (JANUARY 1, 2005 to JANUARY 19, 2011). Through this process an interesting comparison is revealed as we see how the different items' history performed over time.
There are many things to explore, for instance, how long items remain in the collection, and then need to be replaced, what are gaps in itemnumber and how do they correlate to dates, etc. The goal of this assignment is to be granular and reveal details (Revised Oct 18, 2022).
-------------
The assignment is due on October 18, 2022. Present to the class the sequence of steps it took to arrive at an "interesting result" showing both the queries and the data results in csv.
This means that you will probably author numerous MySQL queries which will advance your skills in interacting with the database, asking innovative questions, with presentable results.
-------------
DOCUMENTATION IN THE STUDENT FORUM
Introduce your project with a brief and clear description in the student forum. Your pdf and csv files should have relevant titles, so we know what to expect before clicking on them.
Your pdf describing your project should be structured as follows:
Title,
your name
Abstract introduction
Detailed description
MySQL queries that can be copied
Analysis of results
References and URL links
-------------
REFERENCES:
"Frequency Pattern Mining", authors Aggarwal, Han, https://www.mat.ucsb.edu/~g.legrady/aca ... Mining.pdf
(link to the book https://link.springer.com/book/10.1007/ ... 19-07821-2)
A project by former MAT graduate student Anastasiya Lazavera about co-occurence:
https://vislab.mat.ucsb.edu/2015/anasta ... index.html
The approach to discovering patterns is by searching the database without necessarily knowing what you will get, but eventually to arrive at something of interest that features unexpected patterns and/or unexpected associations. Concentrate on performance and volume over time based on ItemNumber, and the performance of the unique objects representing a title through barcode. (Updated Oct.18.2022 during crit)
Karl Yerkes, lecturer in the MAT program (also software developer, creative coder, and music instrument builder) did a simple project years ago that explored the serendipitous nature of a random search, asking the question "What are the first twelve items in the database that have the word "Happiness" in the title: https://www.mat.ucsb.edu/~g.legrady/aca ... reqmap.pdf Once he had the data for the twelve items he then did a frequency map of how the items performed over a period of time (JANUARY 1, 2005 to JANUARY 19, 2011). Through this process an interesting comparison is revealed as we see how the different items' history performed over time.
There are many things to explore, for instance, how long items remain in the collection, and then need to be replaced, what are gaps in itemnumber and how do they correlate to dates, etc. The goal of this assignment is to be granular and reveal details (Revised Oct 18, 2022).
-------------
The assignment is due on October 18, 2022. Present to the class the sequence of steps it took to arrive at an "interesting result" showing both the queries and the data results in csv.
This means that you will probably author numerous MySQL queries which will advance your skills in interacting with the database, asking innovative questions, with presentable results.
-------------
DOCUMENTATION IN THE STUDENT FORUM
Introduce your project with a brief and clear description in the student forum. Your pdf and csv files should have relevant titles, so we know what to expect before clicking on them.
Your pdf describing your project should be structured as follows:
Title,
your name
Abstract introduction
Detailed description
MySQL queries that can be copied
Analysis of results
References and URL links
-------------
REFERENCES:
"Frequency Pattern Mining", authors Aggarwal, Han, https://www.mat.ucsb.edu/~g.legrady/aca ... Mining.pdf
(link to the book https://link.springer.com/book/10.1007/ ... 19-07821-2)
A project by former MAT graduate student Anastasiya Lazavera about co-occurence:
https://vislab.mat.ucsb.edu/2015/anasta ... index.html