1 Advanced MySQL: Frequency Pattern
Posted: Wed Jan 04, 2017 6:25 pm
The assignment in MySQL is to select a topic of interest and to retrieve data that can show some frequency pattern variations. Part of the assignment can be to discover some interesting cultural content, trends and/or patterns within the data. Your MySQL data will be visualized in a 2D matrix.
Methodologies:
1) Track the checkout history of the item or topic over the 10 year history to make sure there is adequate activity to study.
2) Compare the item/topic’s history to other similar ones. Select one or more items to see if performance patterns are comparable. Identify repeating patterns, and irregularities. Look for interesting, unexpected occurrences.
What to look for:
. Search for (unexpected) patterns in the data
. How often something happens (frequency)
. Anomalies in the system (errors, outliers, etc.) http://en.wikipedia.org/wiki/Anomaly_detection
. Association: Search for relationships between variables
. Do statistical analysis using MySQL aggregate functions: http://dev.mysql.com/doc/refman/5.6/en/ ... tions.html
Your Query Search Details
. Download a minimum 3, preferably 4 columns of metadata – this will be used for horizontal, vertical, and depth values for your visualization
. Best to sequence columns to sequence of how they may be used: (col1: vertical, col2: horizontal, col3: pixel value, etc.)
. Your search results should be sufficient to feature subtleties in the data to be expressed visually within a screen size between 1920x 1280 to 2560 x 1850 pixels
. Output to csv file
Process:
. Imagine a question
. Explore all fields of the database
. Test the query for logical and other errors
. Start with Booleans (AND, OR NOT), wildcards
. Make the query efficient (finetune)
. Interpret the results (data analysis)
. Export to .csv file to be used in visualization
Your Assignment Report:
. Concept/Question (describe what question you are exploring)
. Provide the Query
. Explain the Query
. Provide the results
. Give Processing Time
. Give an Analysis (report back on your results, explain how you did it, and what your outcomes are)
Post your Project as a PostReply to this description
Grading
. Standard Completion of Project: B
. Revised, advanced functions: B+, A-
. Innovative query with significant retrieved data: A
Methodologies:
1) Track the checkout history of the item or topic over the 10 year history to make sure there is adequate activity to study.
2) Compare the item/topic’s history to other similar ones. Select one or more items to see if performance patterns are comparable. Identify repeating patterns, and irregularities. Look for interesting, unexpected occurrences.
What to look for:
. Search for (unexpected) patterns in the data
. How often something happens (frequency)
. Anomalies in the system (errors, outliers, etc.) http://en.wikipedia.org/wiki/Anomaly_detection
. Association: Search for relationships between variables
. Do statistical analysis using MySQL aggregate functions: http://dev.mysql.com/doc/refman/5.6/en/ ... tions.html
Your Query Search Details
. Download a minimum 3, preferably 4 columns of metadata – this will be used for horizontal, vertical, and depth values for your visualization
. Best to sequence columns to sequence of how they may be used: (col1: vertical, col2: horizontal, col3: pixel value, etc.)
. Your search results should be sufficient to feature subtleties in the data to be expressed visually within a screen size between 1920x 1280 to 2560 x 1850 pixels
. Output to csv file
Process:
. Imagine a question
. Explore all fields of the database
. Test the query for logical and other errors
. Start with Booleans (AND, OR NOT), wildcards
. Make the query efficient (finetune)
. Interpret the results (data analysis)
. Export to .csv file to be used in visualization
Your Assignment Report:
. Concept/Question (describe what question you are exploring)
. Provide the Query
. Explain the Query
. Provide the results
. Give Processing Time
. Give an Analysis (report back on your results, explain how you did it, and what your outcomes are)
Post your Project as a PostReply to this description
Grading
. Standard Completion of Project: B
. Revised, advanced functions: B+, A-
. Innovative query with significant retrieved data: A