10.5 MySQL Project & Analysis, due Wed Oct 5

Transforming Data: Cultural Strategies in DataMining
Instructor: George Legrady
bowea324
Posts: 13
Joined: Tue Sep 13, 2011 10:58 am

Updated:

Post by bowea324 » Sun Oct 09, 2011 7:29 pm

Andrew Jay Bowe
10.05.2011
Visualizing Data


The Tortoise and the Hare: Brainstorm an Ontological/Virtual Mapping Project

Question: I hope to look at how the concept of speed and movement can be visualized by library data. Knowledge is constantly moving, yet without geographic space, how can one understand movement?

Intention: The intention of this data-experiment has been to inquire on the subject of patterns within the time span of check out and check in dates. This experiment not only seeks to look for a quantitative pattern or potential differences between genre types and check out length and the speed of movement, but also hopes to suggest more of an ontological difference the movement of literature that cannot be suggested by library databases. Though the role of most data might be first and foremost to discover a pattern of interest, this project operates with deconstructing the use of data, assessing the limits of data, and then providing a way to map the movement of literature.

Rather than looking specifically at key sets of books, I will look at the differences between two books within a single genre, Juvenile Children's Literature, and attempt to unravel the utility of my search as an ontological history of the single book(s). The goal, as noted is not to foreshadow the patterns of results, which at times are predictable, but rather look at the simplified data and attempt to discover ways to ontologically situate a book throughout time.

This research not only hopes to recognize patterns in the flow of the literature, but also hopes to look at some of the scientific and data bias' that may result in a data that has been simplified in library databases, a database that is disconnected with historical conditions and demographic issues.

Within the course of this research I took two works of Children's Science Literature, to study the speed of the 'Tortoise and the Hare'.

For this study I used the code:

Queries:

Select * from transactions2006
where title like ‘Rabbits’

Select * from transactions2006
where title like ‘Turtles’

In order to find a work of literature in the children's database. And I used the code:

Select * from transactions2006
where title like ‘Turtles’
and barcode like ‘0010038881313’

And then

Select * from transactions2006
where title like ‘Rabbits’
and barcode like ‘001003581861’


[Books found:

TURTLES

J597.92 BASKIN 1996

Turtles, Juvenile Literature


RABBITS

callNumber

J636.9322 HINDS 1999

Rabbits, Juvenile Literature]


in order to trace the history of that book for the calendar year of 2006.

Analysis:

I discovered that by comparing the results. In this case, that the randomly traced item 'Turtles' and 'Rabbits', the book on 'Turtles' moved out of the library more through the calendar year. Assuming that the library patrons were different, I also drew the conclusion that this book was more popular, and thus had more virtual-geographic movement throughout the calendar year. This data shows, not only that the book Turtle moved at a more rapid speed throughout the calendar year, but also that the book covered a longer terrain.

The following MySQL sequences have produced these results:

Hare and Tortoise:

TURTLES:


1) 2006-02-06 16:18:00 2006-02-17 16:14:00 ncnf jcbk 0010038881313 Turtles J597.92 BASKIN- 1996 597.92 Turtles Endangered species Turtles Juvenile literature Endangered species Juvenile literature
2) 2006-04-15 14:35:00 2006-04-27 19:37:00 ncnf jcbk 0010038881313 Turtles J597.92 BASKIN- 1996 597.92 Turtles Endangered species Turtles Juvenile literature Endangered species Juvenile literature
3) 2006-05-16 17:48:00 2006-05-26 16:54:00 ncnf jcbk 0010038881313 Turtles J597.92 BASKIN- 1996 597.92 Turtles Endangered species Turtles Juvenile literature Endangered species Juvenile literature
4) 2006-06-23 11:16:00 2006-07-12 17:16:00 ncnf jcbk 0010038881313 Turtles J597.92 BASKIN- 1996 597.92 Turtles Endangered species Turtles Juvenile literature Endangered species Juvenile literature
5) 2006-07-17 15:49:00 2006-08-03 12:28:00 ncnf jcbk 0010038881313 Turtles J597.92 BASKIN- 1996 597.92 Turtles Endangered species Turtles Juvenile literature Endangered species Juvenile literature

Here we can see that the title 'Turtles'

Map this data to show the movement of the single book and compare these results to


Rabbits:

select * from transactions2006
where title like 'Rabbits'
and barcode like '0010035381861'

1) 2005-11-23 12:57:00 2006-01-27 00:00:00 ncnf jcbk 0010035381861 Rabbits J636.9322 HINDS 1999 636.9322 Rabbits Rabbits Juvenile literature
2) 2005-11-23 12:57:00 2006-02-08 17:57:00 ncnf jcbk 0010035381861 Rabbits J636.9322 HINDS 1999 636.9322 Rabbits Rabbits Juvenile literature
3) 2006-04-07 14:55:00 2006-04-14 14:06:00 ncnf jcbk 0010035381861 Rabbits J636.9322 HINDS 1999 636.9322 Rabbits Rabbits Juvenile literature


Conclusions:

While the limited data sets may provide a resource in developing an understand of the flow of information, this data operates within a terrain that moves information into a hyper-rationality form of existence. One might map this data and show that key works of literature are moving at differing rates, yet the data does not analyze the bias of real space, i.e. the spacial location of the library, the role of researchers in the area, and etcetera. The conditions of pulling significant information of the flow of information, from the catalog is limited to an extreme degree, one might have to develop a comparative data base sample in order to elaborate and utilize this data to further draw conclusions about the significance.

Kosara:

Kosara and Research:

The absence of theoretical terrain, or subversive theoretical terrain, is apparent within Kosara’s own writing. Kosara writes, “While I consider theory to be important, I do not believe in its value only for its own sake. Like most of my peers, I have developed useful tools and techniques that are applied to real-world data and problems.” This signals to me an often over dramatized distinction, which those in the field of practical sciences apply between theory and practice. While much of the theoretical history, art theory and literary theory, has been quite esoteric and has operated in sharp separation from practical construction or development, the process of developing theory is strongly influential in building a profound understanding of method and existence. When one is to re-think the assumptions of historical notions of visuality, one can begin to construct forward thinking approaches to visualization.

While I do agree with Kosara that empirical studies are important in developing an understanding of the nature of visualization, I would also argue that visualization is key in developing an understanding of what data is. One might argue that data is made closer, in some respects, to a truth as it is represented and mediated.

luc393
Posts: 6
Joined: Tue Sep 13, 2011 11:01 am

Re: 10.5 MySQL Project & Analysis, due Wed Oct 5

Post by luc393 » Mon Oct 10, 2011 10:13 am

Question: How do the resources of the Seattle Public Library reflect the increase and popularity of DIY sustainable practices from 2006-2010?

Query:

select title , count(*) from transactionsall
where title like '%permaculture%' AND deweyClass >= 600 AND deweyClass < 700
group by title
order by count(*) desc


Review & Analysis:

With the help of our wonderful TA Sepand, I was able to narrow the results with my new query above, searching for transactions from 2006, 2010, and all of the years combined.

In this query, I selected all the books related to food & agriculture listed from 600-699 (Technology) in the Dewey decimal system including the title "garden". At first, I searched for any book with the title “sustainable”, but since my interest is in DIY cultures, I replaced it with “garden”, which yielded titles with several DIY key words such as “permaculture”, “organic”, as well as the “sustainable” titles that are relevant. The results show that the books reflecting sustainable DIY practices have greatly increased throughout the years in popularity and specificity.

As I continue to research, I would like to narrow my search to DIY practices that are unique to Seattle with the help of websites such as Seattle DIY. http://www.seattlediy.com/ I would also like to examine the motivations behind the DIY movement. For example, is the interest in sustainable practices fueled by an increase of time due to unemployment, health concerns such as diet and nutrition, or a political response to the current state of the food industry?

In the following results, I compare the titles that are checked out over 100x in 2006 and 2010. In 2010, not only has the popularity of sustainability grown dramatically, but the variety of titles has increased to include DIY practices such as pickling, urban beekeeping, and raising chickens in the city. One book in particular, “Growing vegetables west of the Cascades the complete guide to organic gardening” is the most checked out book throughout the years and its popularity quadrupled from 2006 – 2010.

from transactions2006 (12)

Cass Turnbulls guide to pruning what when where how to prune for a more beautiful garden 228
Ann Lovejoy handbook of Northwest gardening natural sustainable organic 175
Big ideas for northwest small gardens 166
Second nature a gardeners education 155
Gaias garden a guide to home scale permaculture 150
Growing vegetables west of the Cascades the complete guide to natural gardening 144
Month by month gardening in Washington Oregon what to do each month to have a beautiful garden all year 127
Gardening with native plants of the Pacific Northwest 114
Ann Lovejoys organic garden design school a guide to creating your own beautiful easy care garden 104
Container gardening 104
well tended perennial garden planting pruning techniques 102
Gardening when it counts growing food in hard times 99


from transactions2010 (46)

new low maintenance garden how to have a beautiful productive garden and the time to enjoy it 593
Growing vegetables west of the Cascades the complete guide to organic gardening 474
Fresh food from small spaces the square inch gardeners guide to year round growing fermenting and sprouting 410
Small plot high yield gardening grow like a pro save money and eat well from your front or back or side yard 100% organic produce garden 389
All new square foot gardening grow more in less space 378
Maritime northwest garden guide planning calendar for year round organic gardening 372
Gaias garden a guide to home scale permaculture 340
Second nature a gardeners education 318
Sunset Western garden book of edibles the complete A to Z guide to growing your own vegetables herbs and fruits 310
Garden anywhere how to grow gorgeous container gardens herb gardens kitchen gardens and more without spending a fortune 249
Starter vegetable gardens 24 no fail plans for small organic gardens 231
City chicks keeping micro flocks of laying hens as garden helpers compost creators bio recyclers and local food suppliers 218
Ann Lovejoy handbook of Northwest gardening natural sustainable organic 212
garden 211
Four season harvest organic vegetables from your home garden all year long 199
Big gardens in small spaces out of the box advice for boxed in gardeners 189
Timber Press guide to gardening in the Pacific Northwest 179
vegetable gardeners book of building projects raised beds cold frames compost bins planters plant supports trellises harvesting and storage aids 177
Cass Turnbulls guide to pruning what when where how to prune for a more beautiful garden 172
Encyclopedia of northwest native plants for gardens and landscapes 170
backyard beekeeper an absolute beginners guide to keeping bees in your yard and garden 162
Getting started in permaculture over 50 DIY projects for house garden using recycled materials 156
Food not lawns how to turn your yard into a garden and your neighborhood into a community 154
Gardening with Ed Hume Northwest gardening made easy 152
Big ideas for northwest small gardens 151
McGee Stuckeys the bountiful container a container garden of vegatables herbs fruits and edible flowers 149
Edible heirlooms heritage vegetables for the maritime garden 149
Winter gardening in the maritime Northwest cool season crops for the year round gardener 145
Raised bed vegetable gardening made simple the three module home vegetable garden 144
Edible gardening for Washington and Oregon vegetables herbs fruits seeds 144
Grocery gardening planting preparing and preserving fresh food 143
Gardening when it counts growing food in hard times 143
joy of pickling 250 flavor packed recipes for vegetables and more from garden or market 141
Homegrown vegetables fruits and herbs a bountiful healthful garden for lean times 134
American meadow garden creating a natural alternative to the traditional lawn 126
Gardening for a lifetime how to garden wiser as you grow older 125
Succulent container gardens design eye catching displays with 350 easy care plants 123
family kitchen garden how to plant grow and cook together 121
Get me out a history of childbirth from the Garden of Eden to the sperm bank 116
Carrots love tomatoes secrets of companion planting for successful gardening 116
Container gardening for Washington and Oregon 116
vegetable gardeners bible discover Eds high yield W O R D system for all North American gardening regions 114
New encyclopedia of gardening techniques 113
informed gardener blooms again 111
Fearless color gardens the creative gardeners guide to jumping off the color wheel 106
In love with a hillside garden 104

from transactionsall

Growing vegetables west of the Cascades the complete guide to organic gardening 1440
Gaias garden a guide to home scale permaculture 1225
Ann Lovejoy handbook of Northwest gardening natural sustainable organic 1224
Second nature a gardeners education 1201
Fresh food from small spaces the square inch gardeners guide to year round growing fermenting and sprouting 1064
Cass Turnbulls guide to pruning what when where how to prune for a more beautiful garden 1058
Maritime Northwest garden guide planning calendar for year round organic gardening 1038
All new square foot gardening grow more in less space 1035

lazad518
Posts: 8
Joined: Tue Sep 13, 2011 11:01 am

update - Re: 10.5 MySQL Project & Analysis, due Wed Oct 5

Post by lazad518 » Mon Oct 31, 2011 7:38 am

We were jamming in class the other day and came across the idea of comparing entries revolving around 'coffee'. The colder months are the shorter months, and are usually the months where waking up and getting out of bed is more challenging. Therefore it would appear that we are more prone to consuming larger amounts of coffee during that period, in order to compensate the difficulty of waking up. I was curious to see if people were going to the library and researching and reading more about coffee in the winter, than in the summer. Whether its about which grains are stronger, addiction, taste, etc… I think its an interesting relationship that was worth investigating.
We wrote the following processing data to access the library:

import de.bezier.data.sql.*;
// Based on example 1:
// created 2005-05-10 by fjenett
// updated fjenett 20081129
MySQL msql;

int [] months = new int [12];
int [] counts = new int [12];
void setup() {
size( 500, 500 );
String user = "mat259";
String pass = "V1sual1zat1on";
// name of the database to use
String database = "spl_years";
// if needed add additional parameters like this:
// bildwelt?useUnicode=true&characterEncoding=UTF8
// connect to database of server tango
//
msql = new MySQL( this, "tango.mat.ucsb.edu", database, user, pass );
if ( msql.connect() )
{
msql.query( "select month(ckoutDateTime), count(*) from transactions2005 where title like '%coffee%' group by month(ckoutDateTime) order by month(ckoutDateTime)");
int i = 0;
while(msql.next()) {
/* java.sql.Date ts = msql.getDate(1);
String title = msql.getString(2);
String subject = msql.getString(3);
double dewey = msql.getDouble(4);*/
int month1= msql.getInt(1);
int count = msql.getInt(2);

months = month1;
counts = count;

println("----");
println( month1);
println(count);
i= i+1;
}
// println( "number of transactions: " + msql.getInt(1) );
// You should get --> 10347528
}
else
{
println( "Conection Failed!! ");
}
}
void draw() {
background(255, 204, 0);
smooth();
noStroke();
/*ellipse(width/2, height/2, 100, 100);
*/
rect(0, height/2, width/12, 10);
rect(width/12, height/2, width/12, counts[0]);
rect(2*width/12, height/2, width/12, counts[1]);
rect(3*width/12, height/2, width/12, counts[2]);
rect(4*width/12, height/2, width/12, counts[3]);
rect(5*width/12, height/2, width/12, counts[4]);
rect(6*width/12, height/2, width/12, counts[5]);
rect(7*width/12, height/2, width/12, counts[6]);
}

Locked