directed study: week 6 presentation

8/14/2019 Directed Study: Week 6 Presentation

1/36

Group 1Presentation Week 6


2/36

Daniel BeereDaniel Beere

Twitch: ProgressTwitch: Progress


3/36

DatabaseDatabase


4/36

CodeCode

Insert Data into a Database TableInsert Data into a Database Tablemysql_select_db(mysql_select_db( twitchtwitch ", $con);", $con);mysql_query("INSERT INTOmysql_query("INSERT INTO twitchtwitch ((bandband ,, venuevenue ,, locationlocation ,, datedate ,, timetime ,, locationlocation ))VALUES (VALUES ( Mick ORourke, The Stables,Mick ORourke, The Stables,Limerick, 24 Feb, 10pm, My First Gig!Limerick, 24 Feb, 10pm, My First Gig! )");)");

mysql_close($con);mysql_close($con);?>?>


5/36

CodeCode

Select Data from a DatabaseSelect Data from a Databasemysql_select_db(mysql_select_db( twitchtwitch ", $con);", $con);$result = mysql_query("SELECT * FROM$result = mysql_query("SELECT * FROM twitchtwitch ");");while($row = mysql_fetch_array($result))while($row = mysql_fetch_array($result)){{echo $row['echo $row[' bandband '] . " " . $row[''] . " " . $row[' venuevenue '] . " " . $row[''] . " " . $row[' locationlocation '] . " " .'] . " " .$row['$row['datedate '] . " " . $row[''] . " " . $row[' timetime '] . " " . $row[''] . " " . $row[' commentcomment '];'];echo "
";echo "
";

}}mysql_close($con);mysql_close($con);?>?>


6/36

CodeCodeExtract Data from a Specified Field (WHERE Clause)Extract Data from a Specified Field (WHERE Clause)mysql_select_db(mysql_select_db( twitchtwitch ", $con);", $con);

$result = mysql_query("SELECT * FROM$result = mysql_query("SELECT * FROM twitchtwitch

WHEREWHERE location=limerick'");location=limerick'");

while($row = mysql_fetch_array($result))while($row = mysql_fetch_array($result)){{echo $row[echo $row[ bandband '] . " " . $row['] . " " . $row[venuevenue '] . " " . $row['] . " " . $row[ locationlocation '] . " " . $row['] . " " . $row[datedate '] .'] .

" " . $row[" " . $row[timetime ']. " " . $row[']. " " . $row[commentcomment '];'];echo "
";echo "
";}}

?>?>


7/36

Twitter Twitter Popular Microbloggig Platform.Popular Microbloggig Platform.Users share information about their activities,Users share information about their activities,opinions and status (140 character limit).opinions and status (140 character limit).Users can interact with Twitter by either using aUsers can interact with Twitter by either using aWeb interface, IM agent or sending SMS updatesWeb interface, IM agent or sending SMS updates

(11:00 and 14:00).(11:00 and 14:00).Web Celebrities.Web Celebrities.Most users inMost users in

1) North America1) North America2) Europe2) Europe3) Asia (Japan)3) Asia (Japan)


8/36

Twitter Twitter Different user roles are:Different user roles are:

Information source/sharingInformation source/sharingInformation seeker Information seeker

Friend/RelationshipFriend/Relationship(Formal & Informal)(Formal & Informal)

Main types of user intentions are:Main types of user intentions are:Daily chatter Daily chatter

ConversationsConversationsSharing information (About 13% of postsSharing information (About 13% of postscontained a URL)contained a URL)Reporting newsReporting news


9/36

Twitter Twitter

01 April 2007 to 30 May 2007.01 April 2007 to 30 May 2007.Almost 1.5 million updates from over Almost 1.5 million updates from over 75,000 users.75,000 users.Growth of Twitter users from 3.5 million toGrowth of Twitter users from 3.5 million toover 6 million.over 6 million.

Growth of Twitter posts from 2 million toGrowth of Twitter posts from 2 million toover 6.5 million.over 6.5 million.


10/36

Twitter Input & Output MethodsTwitter Input & Output Methods

UserApps

Facebook

TwitterAPI

SMSIMWeb

Interface

Twitter


11/36

Twitch: ProgressTwitch: Progress

Billy KennedyBilly Kennedy


12/36

This Week I Learned:This Week I Learned:

You can't learn PHP in a week, even off aYou can't learn PHP in a week, even off aLynda DVD.Lynda DVD.Still learned a fair amount of PHP, moving onStill learned a fair amount of PHP, moving onto MySQL integration.to MySQL integration.A number of reasons why users actually useA number of reasons why users actually useservices like Twitter to move and exchangeservices like Twitter to move and exchange

information.information.How we can adapt these reasons of useHow we can adapt these reasons of usetowards our site.towards our site.


13/36

So during the week I...So during the week I...

Kept learning PHP.Kept learning PHP.Read two papers on the use of Twitter.Read two papers on the use of Twitter.

Went over the sites progress and designWent over the sites progress and designwith Daniel and Brian.with Daniel and Brian.Found a number of useful articles on UXFound a number of useful articles on UXDesign for this type of site.Design for this type of site.Read the Design Document for a similar Read the Design Document for a similar application.application.


14/36

Why People Tweet:Why People Tweet:Emotionally, people seem to want to achieveEmotionally, people seem to want to achievea level of cyberspace presence, to feel a level of cyberspace presence, to feel another layer of connection with friends and another layer of connection with friends and

the world.the world.

... the most common text ... the most common text

messages people send each other today aremessages people send each other today arewhere are you?, followed by where are you?, followed by what are youwhat are youdoing? doing?


15/36

How Twitter Will ChangeHow Twitter Will Changethe Way We Livethe Way We LiveSteven Johnson, TIME MagazineSteven Johnson, TIME Magazine

June 2009June 2009

How Twitter Will Change the Way We Live


16/36

Why Do We Even Use Twitter?Why Do We Even Use Twitter?"If only there were a technology that would allow me to"If only there were a technology that would allow me to

send a message to my 50 friends, alerting them in realsend a message to my 50 friends, alerting them in realtime about my choice of breakfast cereal.time about my choice of breakfast cereal.

Skepticism of Twitter and it's value as a social mediumSkepticism of Twitter and it's value as a social mediumhas been rife since it's introduction.has been rife since it's introduction.

In this article, Johnson espouses the view that not only isIn this article, Johnson espouses the view that not only isTwitter a valuable medium, it is part of a paradigm shift inTwitter a valuable medium, it is part of a paradigm shift inthe way we communicate.the way we communicate.



17/36

What was next? SoftwareWhat was next? Softwarethat let you send a singlethat let you send a single

punctuation mark to punctuation mark todescribe your mood? describe your mood?



18/36

Reasons for UseReasons for Use

Ambient Awareness Ambient Awareness Clive Thompson (New York Times Reporter)Clive Thompson (New York Times Reporter) By following these quick, abbreviated statusBy following these quick, abbreviated statusreports from members of your extended social reports from members of your extended social network, you get a strangely satisfying glimpsenetwork, you get a strangely satisfying glimpseof their daily routines. of their daily routines.

In essence, choice of punctuation mark, andIn essence, choice of punctuation mark, andeven choice of Breakfast Cereal add to aneven choice of Breakfast Cereal add to anoverall picture of who you are as a person.overall picture of who you are as a person.



19/36

Ambient Awareness as itAmbient Awareness as itConcerns TwitchConcerns Twitch

By Twitching events, users create an imageBy Twitching events, users create an image

of their preferences in Music, Arts etc. Usersof their preferences in Music, Arts etc. Userswith similar tastes might choose to Followwith similar tastes might choose to Followthese users to find more interesting events.these users to find more interesting events.

(Oh ya, I just used Twitiching as a verb!)(Oh ya, I just used Twitiching as a verb!)



20/36

The Open ConversationThe Open Conversation

Just a few years ago, conversations aboutJust a few years ago, conversations aboutevents were confined solely to those whoevents were confined solely to those whohad actually attended.had actually attended.Now with the advent of liveblogging, evenNow with the advent of liveblogging, eventhose who weren't there can interact and talkthose who weren't there can interact and talkabout the event.about the event.

E.g. Attendees at a conference liveblog aE.g. Attendees at a conference liveblog apresentation. People all over the world canpresentation. People all over the world canview this and react instantly.view this and react instantly.



21/36

The Open Conversation andThe Open Conversation and

TwitchTwitchPeople who can't actually attend an eventPeople who can't actually attend an eventor gig still comment on it, wishing well toor gig still comment on it, wishing well tothe attendees and wishing they were going.the attendees and wishing they were going.Creates an immediate buzz and sense of Creates an immediate buzz and sense of exclusivity for the attendees. They areexclusivity for the attendees. They areattending an event which others can not.attending an event which others can not.



22/36

User Appropriation of Twitter User Appropriation of Twitter ... significant point about the Twitter platform: the fact that many of ... significant point about the Twitter platform: the fact that many of its core features and applications have been developed by peopleits core features and applications have been developed by peoplewho are not on the Twitter payroll who are not on the Twitter payroll

The convention of grouping a topic or event by the "hashtag" The convention of grouping a topic or event by the "hashtag" #hackedu or #inauguration was spontaneously invented by the#hackedu or #inauguration was spontaneously invented by theTwitter user base (as was the convention of replying to another user Twitter user base (as was the convention of replying to another user with the @ symbol). The ability to search a live stream of tweetswith the @ symbol). The ability to search a live stream of tweetswas developed by another start-up altogether, Summize, whichwas developed by another start-up altogether, Summize, whichTwitter purchased last year.Twitter purchased last year.

... the tools you're offered if you visit Twitter.com have changed... the tools you're offered if you visit Twitter.com have changedvery little in the past two years. But there's an entire Home Depot of very little in the past two years. But there's an entire Home Depot of Twitter tools available everywhere else.Twitter tools available everywhere else.


ll h h


23/36

End User Innovation and TwitchEnd User Innovation and Twitch

The Twitch system is based on parsingThe Twitch system is based on parsingposts within a particular Twitter feed (our posts within a particular Twitter feed (our hashtag).hashtag).But what if users add a field we didn'tBut what if users add a field we didn'texpect? Or don't use one of the fields weexpect? Or don't use one of the fields weexpected?expected?

Simple, we have to adapt!Simple, we have to adapt!UsersUsers likelike tools that they can appropriate.tools that they can appropriate.


T itt d St t U d ti


24/36

Twitter and StatusTwitter and Status

UpdatingUpdatingLenhart, A., Fox, S.,Lenhart, A., Fox, S.,

PewInternet.org, February 2009PewInternet.org, February 2009

Twitter and Status Updating



25/36

As of December 2008, 11% of online Americanadults said they used a service like Twitter or

another service that allowed them to shareupdates about themselves or to see the updates

of others.




26/36

Twitter users are mobile, less tethered by technology




27/36

Methods to Post to Twitter:Methods to Post to Twitter:

SMSSMSNumerous iPhone AppsNumerous iPhone AppsAndroid AppsAndroid Apps

Blackberry AppsBlackberry AppsJava Applications.Java Applications. (Platform Independent)(Platform Independent)Adobe Air Applications (Platform Independent)Adobe Air Applications (Platform Independent)

Any Web Browser.Any Web Browser.Any Web Enabled Device.Any Web Enabled Device.




28/36

Some Interesting FindingsSome Interesting FindingsUsers have themselves expanded the information carried inUsers have themselves expanded the information carried ina twitter message through the development of in-tweeta twitter message through the development of in-tweetshorthand and symbols.shorthand and symbols.... online Americans who live in lower-income households... online Americans who live in lower-income households

are more likely to use Twitter than more affluent Americans.are more likely to use Twitter than more affluent Americans.Wireless internet users are more than twice as likely to useWireless internet users are more than twice as likely to useTwitter as wired users (14% as compared to 6%)Twitter as wired users (14% as compared to 6%)People who already use social networks are more likely toPeople who already use social networks are more likely to

use Twitter (23% of people who already use a socialuse Twitter (23% of people who already use a socialnetworking service have used Twitter)networking service have used Twitter)




29/36

Nearly a third of all Bloggers Twitter (27%).Nearly a third of all Bloggers Twitter (27%).Roughly 13% of internet users Blog.Roughly 13% of internet users Blog.Twitter is a slightly more racially diverseTwitter is a slightly more racially diversethan the US population. The authors putthan the US population. The authors putthis down to young people being morethis down to young people being moreethnically diverse, I put it down to Twitter ethnically diverse, I put it down to Twitter

being a Global rather than Americanbeing a Global rather than Americanphenomenon.phenomenon.

Some Interesting Findingsp g



30/36

Portrait of a Twitter User Portrait of a Twitter User

YoungYoungEthnically DiverseEthnically DiverseUrbanUrbanTechnologically SavvyTechnologically SavvyLikely to use ICTs as a primary source of Likely to use ICTs as a primary source of

News and Information.News and Information.

g


31/36


32/36

Twitviz - Exploring Twitter Twitviz - Exploring Twitter network for your interestsnetwork for your interests

Ferreira, D., Freitas, M., Rodrigues, J.,Ferreira, D., Freitas, M., Rodrigues, J.,Ferreira, V.Ferreira, V.

University of Madeira, 2009University of Madeira, 2009


33/36

A Similar Concept: TwitvizA Similar Concept: Twitviz

A tool for exploring networks on Twitter A tool for exploring networks on Twitter based on similar interests.based on similar interests.Graphs networks of Followers andGraphs networks of Followers andReciprocal Followers.Reciprocal Followers.A Tool developed by users of Twitter to addA Tool developed by users of Twitter to addpreviously non-existant functionality.previously non-existant functionality.


34/36

Twitter in particular, provides poor support for Twitter in particular, provides poor support for discovery of communities of interest beyond discovery of communities of interest beyond

following a public user that represents afollowing a public user that represents acompany, event or group of interest. company, event or group of interest.


35/36

A Similar Concept: TwitvizA Similar Concept: Twitviz

Twitter does not provide a similar feature toTwitter does not provide a similar feature toFacebook Groups and similar Facebook Groups and similar technologies.technologies.

One of the aims of Twitviz is to fill thatOne of the aims of Twitviz is to fill thatdivide.divide.The general aim is to allow users to viewThe general aim is to allow users to viewTwitter Networks in a graphical format.Twitter Networks in a graphical format.

Limitations (Which Might AffectLimitations (Which Might Affect


36/36

Limitations (Which Might AffectLimitations (Which Might AffectTwitch)Twitch)

Twitter limits the number of calls an IPTwitter limits the number of calls an IPaddress or account can make for address or account can make for performance reasons. (100 per hour.)performance reasons. (100 per hour.)

However it is possible to be whitelistedHowever it is possible to be whitelistedas a developer and overcome this.as a developer and overcome this.(20000 per hour)(20000 per hour)

The Twitter API doesn't allow you to filter byThe Twitter API doesn't allow you to filter bylanguage. We might get false positives fromlanguage. We might get false positives fromusers using languages other than english.users using languages other than english.

directed study: week 6 presentation

Documents