Media Arts and Technology

Review the query projects by Christo de Clerck https://docs.google.com/document/d/1fK4 ... t?hl=en_US and Matthew Willse https://docs.google.com/document/d/1Hpe ... t?hl=en_US

Following their model, post the following:

Data Mining Question
The Sql Query
Explanation of the query
Processing Time
Comment & Analysis

Here is my query.
https://docs.google.com/document/d/13Jv ... Qh0PY/edit
RJ

https://docs.google.com/document/d/1VfQ ... yq5Tw/edit

-Anis Haron

https://docs.google.com/document/d/1v6w ... xho-Y/edit

- Yoon Chung Han

Please find my writeup, query and some mock visualization (using gnuplot) here -
https://docs.google.com/document/d/1Ufh ... 67t1s/edit


--
Ankit

Here is my writeup and query:

https://docs.google.com/document/d/1bHw ... L-PFk/edit

http://www.muhammadhafiz.com/class/mat2 ... 120124.pdf

-hafiz

Hey Yoon,

I think this query is actually closer to what you want. Saying year(ckoutDateTime) = 2011 isn't necessary because we're saying that the ckoutDateTime has to be after 2011-09-04. Also you need parenthesis around the title and subject criteria because otherwise the OR will make MySQL ignore the ckoutDateTime >= '2011-09-04' part:

SELECT
count(*)
FROM transactions2011
WHERE
ckoutDateTime >= '2011-09-04'
AND (TITLE LIKE "%Steve Jobs%"
OR subject1 like "%Steve Jobs%"
OR subject2 like "%Steve Jobs%"
OR subject3 like "%Steve Jobs%"
OR subject4 like "%Steve Jobs%"
OR subject5 like "%Steve Jobs%")
ORDER BY ckoutDateTime;

MAT 259 Assignment #1
Dallas Mercer

https://docs.google.com/document/d/1uEG ... t?hl=en_US