9.26 Data Mining/MySQL Ideas + Google Reviews here

Transforming Data: Cultural Strategies in DataMining
Instructor: George Legrady
glegrady
Posts: 160
Joined: Wed Sep 22, 2010 12:26 pm

9.26 Data Mining/MySQL Ideas + Google Reviews here

Post by glegrady » Sun Sep 18, 2011 3:54 pm

Please submit Data Mining ideas here, and also reviews for week 3 and 4: "500 Billion Words", and/or the Google gram, and/or google correlate, and/or Yerkes from http://www.mat.ucsb.edu/~g.legrady/acad ... index.html
Last edited by glegrady on Fri Oct 07, 2011 8:02 pm, edited 2 times in total.
George Legrady
legrady@mat.ucsb.edu

User avatar
deklerk
Posts: 14
Joined: Tue Sep 13, 2011 11:10 am
Location: New York, NY
Contact:

Re: 2. Data Mining Assignment here

Post by deklerk » Mon Sep 26, 2011 12:11 pm

Here are a few SQL scripts I was playing with before today's class [access it here]. Look under the "Correlate" tab for scripts to feed Google Correlate.
-----
Christo

User avatar
keats047
Posts: 10
Joined: Tue Sep 13, 2011 11:00 am

Re: 2. Wk 3. Data Mining/MySQL Ideas + Google Reviews here

Post by keats047 » Wed Sep 28, 2011 3:53 pm

This is just a question, but can anyone explain in a little detail as to how to export the data you're looking at in the SQL program (HeidiSQL in my case) so that Google can use it to make correlations? Right now I have exported the data to multiple file types (XML, CSV, SQL, HTML, LaTex) and while I can get one Column to return (as in, when I load an exported file it returns all my dates, but not the results from that date), it won't return two columns, and thus I can't actually get it to create correlate tables. Any help would be appreciated.

User avatar
deklerk
Posts: 14
Joined: Tue Sep 13, 2011 11:10 am
Location: New York, NY
Contact:

Re: 2. Wk 3. Data Mining/MySQL Ideas + Google Reviews here

Post by deklerk » Wed Sep 28, 2011 6:57 pm

Here's what you do:

Note: I've updated the query to exclude checkouts prior to 2006.

1. Run query
2. a) In HeidiSQL, right click the results and click "Export grid data to file". b) in Sequel Pro click on the sprocket icon below the results pane and select "export results".
3. Save as a csv file.
4. Important: you will need to go into a text editor or Excel and make sure that the first row of your exported data is a date and value. It must NOT be titles for the columns.
4. Go to: http://www.google.com/trends/correlate/ and select "Enter your own data" next to the search field
5. Click "choose file" and select your file, give it a moment to load.
6. Enter a name for the Time Series.
7. Hit Search.

Let me know if you have any trouble. Google Correlate seems a little buggy. You may have better luck copying and pasting your data from excel right into the spreadsheet field provided.

- Christo
-----
Christo

User avatar
deklerk
Posts: 14
Joined: Tue Sep 13, 2011 11:10 am
Location: New York, NY
Contact:

Re: 2. Wk 3. Data Mining/MySQL Ideas + Google Reviews here

Post by deklerk » Thu Sep 29, 2011 1:54 pm

Reflection 2: Google’s Ngram Viewer, Window on Culture?

The power of publicly available data sets is indisputably plain when we consider those agencies that do not make their data readily available. A quick search for “data sets homeland security” and the best you might find are spreadsheets summarizing the quantity of requests for data they have received under the freedom of information act.#

There can be little doubt then that the availability of a data set like Google’s database of word and phrase counts from the millions of books it has scanned offers a great potential for valuable inquiry. For many that potential is quickly realized in Google’s Ngram Viewer, a tool that correlates two or more phrases over a variable amount of time and renders the result in a line graph. The visualization is accompanied by a chart summarizing the data - the content of which can be clicked to link to search results. The user thereby drills down from the level of the visualization into the details. The details are revealed in the familiar form of search results; a list of the books from which Google aggregated its word count.

In assessing this interface for the data set, we may want to consider Ben Shneiderman’s “Visual Information Seeking Mantra”. Google’s Ngram Viewer is an example of a) overview first and c) details-on-demand. The missing step b) is the “zoom and filter”. In some manner we ought to be able to zoom into the visualization to assess the topography of the data in a little more detail. The topography may very well be affected by typography. As we discovered in class, a typeface peculiar to the 1700s significantly distorts the overview or big picture view of the data. Zoom in, assess the type, filter it out, and reassess the big picture. This is a challenge both for designers and engineers. Meaning does not just come from the big picture and the details, but rather from an understanding that establish nuance by exploring the picture at varying levels of granularity.

The second point we should consider that would have an influence on an approach to visualizing this mammoth data set is an evaluation of how it represents the way words are being used. On the one hand the issue is technical: what is the syntax for the words and how does that shade a correlation with another word? On the other hand the issue is about tactics: in what sense is a word being used? As The New York Times article on Google’s book data set points out, the frequency of the word “men” and “women” clearly converge over the 1970s.# While sincerely not intending a definitive conclusion to the correlation, the article points out that 1970s marks the rise of feminism. A “details-on-demand” review of those books does not disprove this, but the search also only prioritizes those books with the word “women” in the title. What are the books not titled “women” but yet all about “women” and how is the word used in these books? Also, is the word “women” refer to all classes and races of women?

The varying ways that words are used leads into my concluding point, a critique of decision making based on mining and visualizing a data set generated from machine read books. The New York Times article describes the functional possibility of this database for assisting in such tasks as establishing which new words to add to the dictionary. Certainly other decisions could be influenced by an analysis of the data. To this end, the data set and the practice its represents (dubbed Culturomics) ought not to be handled as a value neutral tool, as it is expressed to be by its research leads, Erez Liberman Aiden and Jean-Baptiste Michel. For most people their first experience of the data set will be through the Ngram Viewer. A great experience, but few will likely prove more than their preconception about what the graphed correlation means by rummaging through the details. How do more complex mining and visualization tools challenge these assumption for the more serious user of the data? Also, the legality of the production of this data carries with it a value. The information is produced through machine reading rather than human reading. Liberman Aiden and Michel point out with relief that the value of machine reading is efficiency. Yet, as the article explains, Culturomics is also not legally possible without machine reading constituting a fully separate form of reading to satisfy copyright.

Certainly machine reading as a different class of reader than human reading may facilitate circumnavigation of copyright protection for the benefit of social insight, but the process is not value neutral when the books can be read by machines but not by people. If a data set like this is going to be used to make the kind of insights that influence decisions, then the very method of producing the information becomes a challenge for designers and academics to engage critically. A critique that should be performed by uncovering the dirt in the data mining results, by unveiling the contradictions of data visualizations, and by interrogating the sources. As with the data set on freedom of information act access requests provided by the Department of Homeland Security, the full account remains in the books.
-----
Christo

putzb642
Posts: 10
Joined: Tue Sep 13, 2011 11:02 am

Re: 2. Wk 3. Data Mining/MySQL Ideas + Google Reviews here

Post by putzb642 » Fri Sep 30, 2011 11:56 am

For the Data Mining I am currently exploring the correlation between celebrity deaths and whether or not there is an influx of dvd/literature check outs surrounding the days around/after/day of their death including subsequent anniversaries.

**UPDATE**
Through working through the information of celebrity it was difficult to narrow down and peg check outs simply by scanning the subjects for an actor name, it would need to be a specific title. To break it down so the search could be more streamlined I started examining the check out's of musicians in the months of their death and compared them with different months and previous years. I made a point to use multiple genre's of musicians as well.


-Lucciano Pavarotti (death September 6, 2007)
-Richard Wright (of Pink Floyd( death September 15 2008) )
-Marvin Gaye (death April 1, 1984)
-Kurt Cobain (death april 5, 1994)



In 500 Billions Words Response

Cohen goes on to describe the recent database that Google has been setting up with all of the text from published materials from the 1500’s until present day. It is important to understand that by creating this database you can see trends which have occurred within given languages. It was proven that over time english verbs evolved to change with the changing norms for language. It is interesting to see how trends in the written word have changed through time as well. I believe it is important for us as designers to use these tools to produce compelling arguments which otherwise could not have been made in the past. Large data sets such as this offer an enormous opportunity for us to re-imagine how someone can consume this information and make it interesting for them.
Last edited by putzb642 on Mon Oct 03, 2011 7:36 am, edited 1 time in total.

alessandrarosecampos
Posts: 9
Joined: Tue Sep 13, 2011 11:09 am

Re: 2. Wk 3. Data Mining/MySQL Ideas + Google Reviews here

Post by alessandrarosecampos » Fri Sep 30, 2011 7:11 pm

500 Billion Words Review
The “500 Billion Words” project, created through the mutual efforts of two Harvard fellows and Google’s massive book scanning projects, presents an interesting opportunity for scholars in the humanities to use quantitative analysis in their research. However, for me the more interesting point of the article was that a tool such as the Google Ngram is not designed to be exclusively used by or accessible to university scholars. Laymen, young students, or anyone who is interested in exploring cultural trends through history via keywords can utilize Ngram. The article suggests that Ngram can allow students to interact with history in novel ways and to connect him with potentially scholarly research methods at a young age. While this democratization of information is a positive thing, especially in the information age, which prides itself on the ease of accessibility to information across economic and cultural hierarchies, there are problems with Ngram if informational freedom is one of its goals.

As Louis Menand points out, the information gathered on Ngram may not produce meaningful conclusions and the data as presented may not always be entirely accurate. Google’s book project itself creates issues, not only of legality, but of the ownership of information. While Ngram is able to search the database for keywords and draw conclusions, the user is unable to look further into those books that the information is pulled from. This is Google’s defense against copyright infringement claims that have been made by both authors and publishers—while Google maintains a database of the information that is accessible to those working behind the curtain, users are unable to read any of the scanned words, sentences, passages, or books.

If a user wishes to look further into the information retrieved on the database, he still needs to utilize more traditional methods such as a public library (which may, through Google efforts such as these, become a study in obsolescence) or purchasing the book. The disjunctions between Ngram’s access to the information and the human user’s seem to reinstate the hierarchies that already exist in terms of the accessibility of information to “outsiders” (those without the informational privileges of say, a Harvard University post-doctoral fellow). While these issues are not made explicit in the article, and are tangential to its overall point, I though they may be interesting to bring up anyway.

Data Mining Ideas
In terms of our ideas for data mining, in our Monday class I decided to search for words such as “disaster” and “conspiracy” in the months surrounding Hurricane Katrina’s landfall in New Orleans. I found some interesting results regarding prophecy—one book dealt with the foolishness of those who didn’t listen to Noah’s warnings of a flood and comparing Noah’s flood to modern day natural disasters and how they may have been avoided. I’m not sure if I should do a massive search by these keywords (disaster, conspiracy, etc.) and try to pick out patterns in the data or if I should try to search around natural disaster dates and see what pulls up. I’m also not sure if these searches will yield any interesting results, but so far that’s what I’ve looked into.

User avatar
keats047
Posts: 10
Joined: Tue Sep 13, 2011 11:00 am

Re: 2. Wk 3. Data Mining/MySQL Ideas + Google Reviews here

Post by keats047 » Sat Oct 01, 2011 3:04 am

deklerk wrote:Here's what you do:

Note: I've updated the query to exclude checkouts prior to 2006.

1. Run query
2. a) In HeidiSQL, right click the results and click "Export grid data to file". b) in Sequel Pro click on the sprocket icon below the results pane and select "export results".
3. Save as a csv file.
4. Important: you will need to go into a text editor or Excel and make sure that the first row of your exported data is a date and value. It must NOT be titles for the columns.
4. Go to: http://www.google.com/trends/correlate/ and select "Enter your own data" next to the search field
5. Click "choose file" and select your file, give it a moment to load.
6. Enter a name for the Time Series.
7. Hit Search.

Let me know if you have any trouble. Google Correlate seems a little buggy. You may have better luck copying and pasting your data from excel right into the spreadsheet field provided.

- Christo
Got the searches working after a little tweaking, thanks for this. In HeidiSQL the files save as semi-colon delimited fields rather than comma separated fields. So you can use something like Open Office to fix that, but that did bewilder me a bit.

For the article on words, I suppose I am perturbed. Even if we should be able to search through the entirety of mankind's information network, it seems of little use without interpretation, and the authors of the work themselves admit to this. If we find that more words of a certain type appear more often in some era of history, does this suddenly make work which isn't referencing this less relevant? Somehow as many of the other scholars who have viewed the information have noted, much is yet to be seen in relation to whether or not the data gathered will help us or add to the chaos. Thus far, information seems to be winning the battle over man for a dominant cultural role, where culture, the actual practice of culture, loses to the informative ditty about what culture is.

In many ways, I feel that much of what scatterplotting the words of man is about relates to downsizing our intellectual capacity to that of a few points on a graph. We end up talking about 'culturomics' seriously, and there's a problem with the process itself. The article, and much of the work, screams of wanting to be taken seriously, but clearly ends up trying too hard and being perturbing without enlightening. Does the fact that Marilyn Monroe's popularity in printed press rises with her claim to stardom? Is this really something we should be surprised by? There is a level of minutia here that strips the information of being meaningful, and problematically so. Perhaps the end of the tunnel of information is something far darker than previously imagined, a place where information is rendered meaningless by the good intentions of those attempting to sort it. Or perhaps, it is more that the information is merely rendered more meaningless than it already was, a cold comfort that much of the work done is little better than any given part of the surplus population of information.

I do not mean to sound cynical of such information-gathering. It should be encouraging that we are looking at information in new ways, but perhaps it is just that the approach of this information to an academic setting that is not primarily focused in the field of engineering seems less than ideal. It seems difficult for me to imagine a history professor teaching a class based on how often a figure got mentioned in history books written throughout the ages, because statistically he's a significant character. It reduces critical analysis on a deep, fundamental level, whereby a thinking begins to emerge that we can numericize the written word, that certain words have weight, value, importance. It refuses to take works on their cultural or historical merit, grinding them ceaselessly into what can be easily processed. I would be horrified if, in the future, to be a man of letters is to simply read the right words enough times, to know when to say them and where--a statistically mastered conflagration of reality.
Last edited by keats047 on Mon Oct 03, 2011 11:41 am, edited 3 times in total.

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

David Lazarus - Data Mining/MySQL Ideas + Google Reviews her

Post by lazad518 » Sat Oct 01, 2011 2:36 pm

I found that the amount of pornography taken out in the library has fallen since 2005 by about 30%. 

select ckinDateTime, title from transactions2005 where (month(ckinDateTime) = 11) and title like '%pornography%'
58 results
select ckinDateTime, title from transactions2010 where (month(ckinDateTime) = 11) and title like '%pornography%' 
29 results

I was considering that there has been an explosion of online free pornography in the last couple of years. I have a family member who works in advertising, but specifically related to the adult entertainment industry and he has shared with me the hardships and the destruction of the pornography industry in the last couple of years, due to the simplicity of handheld filming devices, and the simplicity with which one can shoot, produce and distribute pornography online. Furthermore, the google Ngram illustrating Online Pornography shows a sky rocketing curve from the late 1990s up to 2010. Therefore I was hoping to see if the number of books related to pornography had fallen in the years we have available in the database. And it turns out that there is a significant drop from 2005 to 2010. I am hoping that I can pursue this research and hopefully create a data visualization where I can compare the proliferation of online pornographic free websites, and the fall in pornography taken out of the library.

May 2005
2005-05-12 17:40:00 Bound and gagged pornography and the politics of fantasy in America
2005-05-13 10:05:00 Bound and gagged pornography and the politics of fantasy in America
2005-05-16 16:53:00 Forbidden knowledge from Prometheus to pornography
2005-05-22 14:41:00 high price of pornography
2005-05-26 02:57:00 Obscenity and pornography decisions of the United States Supreme Court
2005-05-26 11:28:00 Obscenity and pornography decisions of the United States Supreme Court
2005-05-31 16:42:00 Bound and gagged pornography and the politics of fantasy in America

June 2005
2005-06-02 00:54:00 Beyond tolerance child pornography on the Internet
2005-06-03 14:48:00 Beyond tolerance child pornography on the Internet
2005-06-04 16:09:00 Forbidden knowledge from Prometheus to pornography
2005-06-05 13:02:00 Bound and gagged pornography and the politics of fantasy in America
2005-06-07 14:33:00 Bound and gagged pornography and the politics of fantasy in America
2005-06-07 18:53:00 Bound and gagged pornography and the politics of fantasy in America
2005-06-11 04:15:00 Bound and gagged pornography and the politics of fantasy in America
2005-06-17 00:00:00 Not a love story a film about pornography

July 2005
2005-07-05 13:24:00 Pornography on trial a handbook with cases laws and documents
2005-07-11 13:17:00 history of pornography
2005-07-11 13:19:00 Foolish figleaves Pornography in and out of court
2005-07-11 13:19:00 Debating sexual correctness pornography sexual harassment date rape and the politics of sexual equality
2005-07-11 13:20:00 high price of pornography
2005-07-11 13:22:00 aesthetics of pornography
2005-07-11 13:25:00 Pornography the production and consumption of inequality
2005-07-11 13:25:00 Soft core moral crusades against pornography in Britain and America
2005-07-11 13:26:00 Pornography sex and feminism
2005-07-11 13:26:00 Pornography debating the issues
2005-07-11 17:18:00 jaguar and the anteater pornography degree zero
2005-07-13 11:31:00 Defending pornography free speech sex and the fight for womens rights
2005-07-13 11:40:00 Reconcilable differences confronting beauty pornography and the future of feminism
2005-07-19 09:54:00 Pornography debating the issues
2005-07-19 17:35:00 Pornography debating the issues
2005-07-20 18:52:00 Pornography on trial a handbook with cases laws and documents
2005-07-20 18:57:00 Pornography opposing viewpoints
2005-07-21 20:52:00 Pornography on trial a handbook with cases laws and documents
2005-07-25 11:53:00 Pornography on trial a handbook with cases laws and documents
2005-07-25 16:45:00 Watching sex how men really respond to pornography

August 2005
2005-08-15 12:52:00 Pornography
2005-08-15 14:08:00 Pornography
2005-08-17 19:23:00 Reconcilable differences confronting beauty pornography and the future of feminism
2005-08-17 19:26:00 Defending pornography free speech sex and the fight for womens rights
2005-08-25 13:12:00 Pornography
2005-08-25 16:16:00 Pornography
2005-08-26 17:08:00 jaguar and the anteater pornography degree zero
2005-08-26 17:08:00 Pornography the other side
2005-08-26 17:16:00 Watching sex how men really respond to pornography
2005-08-30 03:50:00 Pornography
2005-08-30 16:00:00 Pornography

September 2005
2005-09-06 17:34:00 Pornography
2005-09-07 15:50:00 Pornography
2005-09-07 18:12:00 Pornography
2005-09-08 17:34:00 Obscenity and pornography decisions of the United States Supreme Court
2005-09-09 12:54:00 Pornography
2005-09-09 17:10:00 Pornography
2005-09-09 22:08:00 Pornography the production and consumption of inequality
2005-09-11 14:27:00 aesthetics of pornography
2005-09-11 16:40:00 Pornography
2005-09-12 21:29:00 Pornography
2005-09-13 12:20:00 Pornified how pornography is transforming our lives our relationships and our families
2005-09-13 12:38:00 Pornified how pornography is transforming our lives our relationships and our families
2005-09-13 13:23:00 Pornography
2005-09-13 14:05:00 Pornography
2005-09-13 18:41:00 Reconcilable differences confronting beauty pornography and the future of feminism
2005-09-13 19:51:00 Pornography
2005-09-14 10:52:00 Reconcilable differences confronting beauty pornography and the future of feminism
2005-09-14 10:56:00 Pornography
2005-09-14 13:20:00 Pornified how pornography is transforming our lives our relationships and our families
2005-09-14 14:07:00 aesthetics of pornography
2005-09-14 16:58:00 Pornography
2005-09-14 21:42:00 Pornography
2005-09-15 17:26:00 Pornography sex and feminism
2005-09-15 17:28:00 Pornified how pornography is transforming our lives our relationships and our families
2005-09-15 18:23:00 Pornography
2005-09-15 20:10:00 Pornography the production and consumption of inequality
2005-09-17 14:20:00 Pornography the production and consumption of inequality
2005-09-17 15:10:00 Pornography
2005-09-17 15:11:00 Pornography
2005-09-17 17:15:00 Reconcilable differences confronting beauty pornography and the future of feminism
2005-09-17 17:46:00 Pornified how pornography is transforming our lives our relationships and our families
2005-09-19 17:08:00 Pornography
2005-09-19 18:59:00 Pornified how pornography is transforming our lives our relationships and our families
2005-09-19 19:41:00 Watching sex how men really respond to pornography
2005-09-20 14:42:00 Pornography
2005-09-20 16:46:00 Pornified how pornography is transforming our lives our relationships and our families
2005-09-20 18:24:00 jaguar and the anteater pornography degree zero
2005-09-21 09:15:00 Reconcilable differences confronting beauty pornography and the future of feminism
2005-09-21 09:20:00 Pornography the production and consumption of inequality
2005-09-21 19:42:00 Pornography
2005-09-22 17:53:00 Pornography
2005-09-23 10:28:00 Pornified how pornography is transforming our lives our relationships and our families
2005-09-27 10:18:00 Pornography
2005-09-27 13:50:00 Pornography
2005-09-27 16:28:00 Pornography
2005-09-27 17:35:00 Beyond tolerance child pornography on the Internet
2005-09-28 11:46:00 Pornography
2005-09-28 12:02:00 Pornography
2005-09-28 12:23:00 Pornography
2005-09-28 13:13:00 Pornography
2005-09-28 15:46:00 Beyond tolerance child pornography on the Internet
2005-09-29 10:36:00 Pornified how pornography is transforming our lives our relationships and our families
2005-09-29 21:55:00 Pornography

October 2005
2005-10-01 17:19:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-03 12:43:00 Pornography
2005-10-03 22:38:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-04 13:31:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-05 13:11:00 Watching sex how men really respond to pornography
2005-10-05 17:49:00 Pornography
2005-10-07 15:58:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-10 10:58:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-10 11:57:00 Pornography the other side
2005-10-10 16:04:00 Watching sex how men really respond to pornography
2005-10-10 19:56:00 affair of the mind one womans courageous battle to salvage her family from the devastation of pornography
2005-10-10 19:57:00 high price of pornography
2005-10-11 12:56:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-11 13:34:00 Pornography
2005-10-12 10:05:00 Pornography
2005-10-13 14:36:00 Pornography
2005-10-14 15:01:00 Watching sex how men really respond to pornography
2005-10-15 10:03:00 Obscenity and pornography decisions of the United States Supreme Court
2005-10-15 12:20:00 Pornography
2005-10-15 12:42:00 Pornography
2005-10-15 15:34:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-15 15:43:00 Watching sex how men really respond to pornography
2005-10-17 10:47:00 Pornography
2005-10-18 12:17:00 Pornography
2005-10-20 15:38:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-22 10:18:00 jaguar and the anteater pornography degree zero
2005-10-22 11:23:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-22 14:48:00 high price of pornography
2005-10-22 17:14:00 Pornography
2005-10-24 10:15:00 Forbidden knowledge from Prometheus to pornography
2005-10-24 15:02:00 Pornography
2005-10-25 20:15:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-27 12:01:00 Pornography
2005-10-27 13:40:00 Pornography
2005-10-27 15:37:00 Pornified how pornography is transforming our lives our relationships and our families
2005-10-28 11:24:00 Pornography
2005-10-28 17:41:00 Pornography
2005-10-29 10:18:00 Pornified how pornography is transforming our lives our relationships and our families

November 2005
2005-11-01 13:57:00 Watching sex how men really respond to pornography
2005-11-01 17:40:00 Pornography
2005-11-02 15:43:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-03 13:14:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-03 13:42:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-03 14:50:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-04 15:24:00 Pornography
2005-11-04 17:36:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-05 13:34:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-07 13:19:00 I surrender all rebuilding a marriage broken by pornography
2005-11-07 15:34:00 affair of the mind one womans courageous battle to salvage her family from the devastation of pornography
2005-11-07 16:22:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-07 16:59:00 Pornography
2005-11-07 18:22:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-07 18:24:00 Beyond tolerance child pornography on the Internet
2005-11-09 12:48:00 Pornography
2005-11-09 16:05:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-10 12:11:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-10 16:17:00 I surrender all rebuilding a marriage broken by pornography
2005-11-10 18:31:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-12 12:16:00 Pornography
2005-11-12 13:28:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-12 15:02:00 Pornography
2005-11-15 12:24:00 Pornography
2005-11-16 11:03:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-16 12:27:00 Pornography
2005-11-16 16:01:00 Pornography
2005-11-17 11:49:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-17 15:00:00 Pornography
2005-11-18 16:12:00 Pornography
2005-11-21 16:46:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-22 12:48:00 Pornography
2005-11-22 14:12:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-23 12:45:00 Pornography
2005-11-23 19:03:00 affair of the mind one womans courageous battle to salvage her family from the devastation of pornography
2005-11-25 13:14:00 price we pay the case against racist speech hate propaganda and pornography
2005-11-28 12:23:00 Pornography
2005-11-28 14:47:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-28 16:50:00 Beyond tolerance child pornography on the Internet
2005-11-28 17:40:00 Pornography sex and feminism
2005-11-28 19:09:00 Pornography
2005-11-29 11:30:00 Pornography
2005-11-29 12:21:00 Beyond tolerance child pornography on the Internet
2005-11-29 19:50:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-30 10:22:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-30 11:03:00 Pornified how pornography is transforming our lives our relationships and our families
2005-11-30 11:35:00 Pornography
2005-11-30 14:57:00 Pornography

December 2005

2005-12-01 12:44:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-01 16:10:00 Pornography
2005-12-02 10:18:00 Pornography
2005-12-04 15:59:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-05 12:06:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-06 11:44:00 Pornography
2005-12-06 17:32:00 Pornography
2005-12-07 12:38:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-07 14:24:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-07 16:27:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-08 16:27:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-08 16:57:00 Pornography the production and consumption of inequality
2005-12-09 12:49:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-09 14:58:00 Pornography the production and consumption of inequality
2005-12-10 11:45:00 Pornography
2005-12-12 15:55:00 Forbidden knowledge from Prometheus to pornography
2005-12-13 13:14:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-13 16:46:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-13 18:33:00 Pornography
2005-12-14 12:41:00 Pornography
2005-12-14 16:01:00 Where do you draw the line An exploration into media violence pornography and censorship
2005-12-14 17:56:00 Pornography
2005-12-15 11:20:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-16 10:52:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-17 16:43:00 Pornography
2005-12-19 18:26:00 Watching sex how men really respond to pornography
2005-12-21 11:16:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-21 23:42:00 Pornography
2005-12-22 12:28:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-22 16:02:00 Pornography
2005-12-22 16:15:00 Pornography
2005-12-22 17:19:00 Pornography opposing viewpoints
2005-12-23 13:16:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-23 15:32:00 Watching sex how men really respond to pornography
2005-12-26 10:56:00 Excess access pornography children and the American Library Association
2005-12-26 13:30:00 Pornography
2005-12-26 16:09:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-26 19:19:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-26 21:53:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-27 11:49:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-27 13:41:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-27 16:06:00 Pornography
2005-12-27 19:42:00 Pornography
2005-12-28 10:28:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-29 12:26:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-29 13:34:00 Pornography
2005-12-30 10:14:00 I surrender all rebuilding a marriage broken by pornography
2005-12-30 13:41:00 Pornography
2005-12-30 14:16:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-30 18:26:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-31 16:43:00 Pornified how pornography is transforming our lives our relationships and our families
2005-12-31 17:44:00 Pornography opposing viewpoints

------------------
------------------
------------------

May 2010
2010-05-01 13:33:00 porn trap the essential guide to overcoming problems caused by pornography
2010-05-03 12:26:00 Pornography
2010-05-03 18:28:00 common pornography a memoir
2010-05-04 17:15:00 common pornography a memoir
2010-05-06 10:50:00 Getting off pornography and the end of masculinity
2010-05-06 13:58:00 Pornography
2010-05-06 18:24:00 common pornography a memoir
2010-05-09 18:22:00 Pornography
2010-05-10 12:16:00 Pornography
2010-05-11 18:53:00 Pornography
2010-05-11 19:29:00 Pornography the secret history of civilisation
2010-05-11 21:45:00 Pornography the secret history of civilisation
2010-05-12 14:30:00 Pornography
2010-05-13 13:20:00 Pornography the secret history of civilisation
2010-05-13 15:01:00 porn trap the essential guide to overcoming problems caused by pornography
2010-05-15 15:30:00 common pornography a memoir
2010-05-15 23:08:00 common pornography a memoir
2010-05-17 12:17:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-05-17 19:34:00 aesthetics of pornography
2010-05-19 13:04:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-05-20 10:38:00 Pornography debating the issues
2010-05-20 14:23:00 porn trap the essential guide to overcoming problems caused by pornography
2010-05-20 18:38:00 Pornography
2010-05-20 21:53:00 Pornography
2010-05-22 12:23:00 Pornography
2010-05-22 16:07:00 Pornography the secret history of civilisation
2010-05-24 13:28:00 Pornography the secret history of civilisation
2010-05-25 14:19:00 Pornography the secret history of civilisation
2010-05-26 19:56:00 Getting off pornography and the end of masculinity
2010-05-27 10:06:00 Forbidden knowledge from Prometheus to pornography
2010-05-27 20:24:00 Pornography
2010-05-28 11:15:00 common pornography a memoir
2010-05-29 11:26:00 Online pornography
2010-05-29 17:02:00 Pornography
2010-05-29 18:34:00 Getting off pornography and the end of masculinity
2010-05-30 12:04:00 Getting off pornography and the end of masculinity
2010-05-30 12:37:00 Pornography the secret history of civilisation
2010-05-30 15:39:00 Pornography

June 2010
2010-06-01 16:05:00 Pornography debating the issues
2010-06-02 13:24:00 Pornography the secret history of civilisation
2010-06-02 15:46:00 Pornography
2010-06-02 19:34:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-06-03 12:41:00 Pornified how pornography is transforming our lives our relationships and our families
2010-06-03 14:37:00 Pornography the secret history of civilisation
2010-06-03 15:29:00 common pornography a memoir
2010-06-05 12:48:00 Pornography
2010-06-05 17:33:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-06-06 13:12:00 Getting off pornography and the end of masculinity
2010-06-06 16:32:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-06-07 10:27:00 common pornography a memoir
2010-06-07 12:13:00 Pornography
2010-06-09 10:40:00 common pornography a memoir
2010-06-09 10:42:00 Pornography the secret history of civilisation
2010-06-10 15:57:00 Pornography
2010-06-11 12:34:00 Pornography
2010-06-11 17:34:00 common pornography a memoir
2010-06-12 13:17:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-06-15 12:37:00 royal nonesuch in which the author a failure at literature fails likewise at pornography founds a corporate branding consultancy and a new media empire
2010-06-15 14:17:00 common pornography a memoir
2010-06-15 14:19:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-06-17 13:47:00 Pornography
2010-06-18 15:37:00 Pornography
2010-06-19 11:28:00 Pornography
2010-06-19 13:37:00 Pornography the secret history of civilisation
2010-06-19 17:44:00 Forbidden knowledge from Prometheus to pornography

July 2010
2010-07-01 15:47:00 Pornography the secret history of civilisation
2010-07-01 19:06:00 Pornography
2010-07-03 12:35:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-07-03 13:30:00 Naked the life and pornography of Michael Lucas
2010-07-06 19:08:00 common pornography a memoir
2010-07-07 16:40:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-07-08 13:58:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-07-08 22:15:00 common pornography a memoir
2010-07-09 12:51:00 Pornography
2010-07-10 10:33:00 common pornography a memoir
2010-07-10 17:00:00 Pornified how pornography is transforming our lives our relationships and our families
2010-07-11 14:24:00 common pornography a memoir
2010-07-12 14:14:00 royal nonesuch in which the author a failure at literature fails likewise at pornography founds a corporate branding consultancy and a new media empire
2010-07-12 15:10:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-07-13 13:25:00 Pornography
2010-07-13 19:22:00 common pornography a memoir

August 2010
2010-08-02 18:06:00 Pornography the secret history of civilisation
2010-08-03 12:50:00 common pornography a memoir
2010-08-03 13:18:00 Pornified how pornography is transforming our lives our relationships and our families
2010-08-03 14:34:00 common pornography a memoir
2010-08-05 17:26:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-08-05 17:50:00 common pornography a memoir
2010-08-06 11:12:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-08-06 12:37:00 Pornography
2010-08-07 11:23:00 Pornography
2010-08-08 12:36:00 common pornography a memoir
2010-08-08 13:40:00 Pornography the secret history of civilisation
2010-08-09 14:27:00 Pornography
2010-08-09 17:20:00 common pornography a memoir
2010-08-10 15:15:00 Pornography
2010-08-12 14:04:00 Pornography
2010-08-12 14:40:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-08-16 13:21:00 Naked the life and pornography of Michael Lucas
2010-08-16 13:27:00 common pornography a memoir
2010-08-16 18:53:00 Pornified how pornography is transforming our lives our relationships and our families
2010-08-17 13:18:00 Pornography the secret history of civilisation
2010-08-17 15:33:00 Bound and gagged pornography and the politics of fantasy in America
2010-08-19 11:01:00 Pornography
2010-08-19 15:01:00 Getting off pornography and the end of masculinity
2010-08-19 15:44:00 Pornified how pornography is transforming our lives our relationships and our families
2010-08-19 18:08:00 Pornography sex and feminism
2010-08-20 09:59:00 Bound and gagged pornography and the politics of fantasy in America
2010-08-20 10:32:00 Pornography sex and feminism
2010-08-20 10:39:00 Pornography the production and consumption of inequality
2010-08-20 11:44:00 Pornography the secret history of civilisation

September 2010
2010-09-07 13:27:00 Pornography the secret history of civilisation
2010-09-07 18:04:00 porn trap the essential guide to overcoming problems caused by pornography
2010-09-08 10:44:00 pornography of meat
2010-09-09 11:49:00 Thinking tuna fish talking death essays on the pornography of power
2010-09-09 14:09:00 common pornography a memoir
2010-09-11 10:59:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-09-13 15:01:00 Pornography the production and consumption of inequality
2010-09-13 15:08:00 Obscenity and pornography decisions of the United States Supreme Court
2010-09-13 17:20:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-09-14 15:28:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-09-14 15:54:00 pornography of meat
2010-09-14 17:35:00 Pornography the secret history of civilisation
2010-09-15 10:17:00 Pornography the secret history of civilisation
2010-09-15 10:41:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-09-15 14:43:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-09-15 16:41:00 common pornography a memoir
2010-09-16 15:04:00 common pornography a memoir
2010-09-18 13:19:00 Pornography the secret history of civilisation
2010-09-18 18:27:00 Pornified how pornography is transforming our lives our relationships and our families
2010-09-20 16:16:00 Pornography the secret history of civilisation
2010-09-21 11:29:00 Pornography sex and feminism
2010-09-21 14:10:00 Pornography
2010-09-21 16:27:00 common pornography a memoir
2010-09-25 10:14:00 Pornography

October 2010
2010-10-01 11:19:00 Thinking tuna fish talking death essays on the pornography of power
2010-10-01 13:12:00 Pornography
2010-10-02 15:18:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-10-04 11:38:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-10-04 12:21:00 Obscenity and pornography decisions of the United States Supreme Court
2010-10-04 14:53:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-10-05 16:44:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-10-06 15:51:00 Pornography the secret history of civilisation
2010-10-06 17:44:00 Pornography
2010-10-07 17:47:00 Pornography the secret history of civilisation
2010-10-08 12:44:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-10-08 17:46:00 porn trap the essential guide to overcoming problems caused by pornography
2010-10-09 17:24:00 Pornography
2010-10-11 14:25:00 Pornography the secret history of civilisation
2010-10-11 15:04:00 Pornography
2010-10-11 15:29:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-10-12 13:51:00 Pornography
2010-10-13 17:54:00 Pornography the secret history of civilisation
2010-10-14 16:02:00 common pornography a memoir

November 2010
2010-11-02 10:09:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-11-02 14:29:00 Pornography
2010-11-02 17:20:00 Pornified how pornography is transforming our lives our relationships and our families
2010-11-03 13:52:00 Pornography
2010-11-03 14:35:00 Getting off pornography and the end of masculinity
2010-11-04 11:26:00 Pornography
2010-11-04 14:05:00 Naked the life and pornography of Michael Lucas
2010-11-08 15:13:00 Pornography
2010-11-08 16:46:00 Pornography the secret history of civilisation
2010-11-12 12:26:00 Pornography the secret history of civilisation
2010-11-13 15:33:00 pornography of power how defense hawks hijacked 9 11 and weakened America
2010-11-15 13:31:00 Bound and gagged pornography and the politics of fantasy in America
2010-11-15 13:54:00 Pornography
2010-11-15 15:25:00 Pornography the secret history of civilisation
2010-11-15 23:01:00 Pornography
2010-11-16 12:13:00 Pornography
2010-11-16 13:17:00 common pornography a memoir
2010-11-17 11:14:00 Pornography
2010-11-18 19:38:00 Bound and gagged pornography and the politics of fantasy in America
2010-11-20 11:53:00 Pornography
2010-11-20 13:22:00 Bound and gagged pornography and the politics of fantasy in America
2010-11-20 14:13:00 Pornography

December 2010
2010-12-01 12:18:00 Pornography
2010-12-02 10:33:00 porn trap the essential guide to overcoming problems caused by pornography
2010-12-04 16:10:00 Pornography
2010-12-06 14:14:00 Pornography
2010-12-06 14:35:00 Pornography
2010-12-06 15:09:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-12-07 16:43:00 Pornography the secret history of civilisation
2010-12-07 17:11:00 Pornography
2010-12-08 12:31:00 Pornography
2010-12-08 15:34:00 pornography of meat
2010-12-08 21:18:00 Pornography
2010-12-10 11:40:00 Pornography
2010-12-13 14:11:00 Bound and gagged pornography and the politics of fantasy in America
2010-12-14 15:09:00 Pornography
2010-12-16 10:31:00 Pornography
2010-12-16 11:44:00 Pornography
2010-12-17 11:06:00 Pornography
2010-12-17 12:15:00 Pornography
2010-12-20 14:20:00 Pornography
2010-12-21 12:17:00 common pornography a memoir
2010-12-21 18:06:00 porn trap the essential guide to overcoming problems caused by pornography
2010-12-26 15:04:00 Getting off pornography and the end of masculinity
2010-12-28 12:09:00 My undoing love in the thick of sex drugs pornography and prostitution
2010-12-28 12:21:00 Pornography the secret history of civilisation
2010-12-28 15:34:00 Naked the life and pornography of Michael Lucas
2010-12-29 10:24:00 Pornography the secret history of civilisation
2010-12-29 11:36:00 Pornified how pornography is transforming our lives our relationships and our families
2010-12-29 13:40:00 Pornography
2010-12-30 19:17:00 Naked the life and pornography of Michael Lucas
2010-12-31 18:51:00 pornography of meat

-----------------------------------------

500 billion words.

500 billion words is a staggering new concept launched by Google, who else? Essentially it makes quantitative analysis available to 8 year olds and up, through a simple web interface. Anyone with a computer can dig in and research through every single book (English, French, Spanish, German, Russian) from the 1500s to 2008. This makes research for anyone, but especially scholars in the humanities immensely more approachable. 
Both tools, correlate and draw are extremely interesting, and rather dangerous if you are prone to procrastination. I have spent the last hours trying to get two words that have similar curves. The closest I got, was between 'Football' and 'Baseball'. What is interesting out of that search is the identical drops in frequency during the 2nd world war, and during the great depression. I can already imagine a research paper that studies the impact of economic and military hardships of a country, and the popularity of organized sports. 
I can only fathom how useful this tool could have been when writing papers in college. Furthermore, this amount of statistical data could easily have been presented in an immensely complicated an unapproachable way, but as usual, google transcended the user-interface and made the information as easy to read as a children's book. Within minutes, I found myself perusing across millions of data points, exploring the relations of words, and discovering new things second after second. Google keeps pushing the envelope, and whenever someone doubts that they will be able to do it again, they do. 


The Shaping of Information by Visual Metaphors - Kosara

This article by Kosara studies the compatibility between visual and verbal metaphors and how they function together in order to allow the viewer to better understand the data. It was found that compatibility between both elements allow the visualizations to be far more efficient and increased the ability of users to answer relevant questions. 
However, repeated exposure to incompatible information (visual and verbal), allowed the user to get a better understanding over time. Therefore the results of this study were interesting, but not extremely conclusive. It essentially explored the validity of the metaphorical effect, and attempted to better understand what causes it. I'm not entirely sure I better understand Kosara's data visualization after reading this, but it definitely gave me an insight on how he wants to push the theory and develop into something more of a science. 

bowea324
Posts: 13
Joined: Tue Sep 13, 2011 10:58 am

Data Ontology

Post by bowea324 » Sun Oct 02, 2011 3:20 pm

Project Idea:

The ontology of data bases must also account for moving data. Within this project I hope to look at the speed of return of 10 library resources during different occurrences in time, and visualize these results.

One example would be to look at texts which reference the stock market after the stock market crash of 2008, and compare the speed of return to prior to the stock market crash. Can one situate this as an event in time that effects the changing flow of life or of reading? This is a very interesting ontological question.

To look at the movement of the product, the literature, is to show that data only places a temporary hold on an object which is constantly changing. Library materials come in and out, yet the data of their existence tells a very limited story of the text through time.

By using the command:

select count(*) from transactions2009
where date(ckoutdatetime)> '2008-03-02'
and date(ckoutdatetime)< '2008-06-02'
and subject1 like 'great depression'
or title like 'great depression'
or subject1 like 'finance'
or title like 'finance'

and altering the time and word/phrases searched, I might be able to discover certain books which have been checked out in response to the stock market crash, and hopefully find comparable patterns prior to and after the crash.


500 Billion Words Analysis:

Among the most practical functions of Google's 5.2 million digitized books is the capacity to quickly search search documents for words and phrases of "research" interest without flipping through pages or referencing the index.

One might imagine the history of the Humanities as a sort of slow process of reading and interpreting, whereby the critic slowly and thoughtfully develops a response. Now that Google has brought certain analytical functions to the forefront of humanities research, we might now imagine not only a shift in the speed of research and reading, but certainly also a shift in the qualitative history of reading.

As the article mentions, "databases can transform our understanding of language, culture, and the flow of ideas," one might understand the utility of databases as transforming both the pedagogy of engaging with data, of facing databases as locations of pre-organized knowledge, that must either be re-arranged, deranged or sub-ranged.

The transformation of language by databases helps one to imagine not only the categories thought which language functions, but also the extremely oversimplified blankets that bind language together.

It remains important to deconstruct many of the methods that Google uses in constructing their databases. The history of words and databases is certainly connected with a history of power and domination that must be understood before bringing to light over simplified ideas of cultural trends. These databases, along with the library resources must account for certain marginalized or under published literature throughout history.

Locked