demonstration

Tweets as data: demonstration of TweeQL and Twitinfo

Authors:

Adam Marcus,

Michael S. Bernstein,

Osama Badar,

David R. Karger,

Samuel Madden,

Robert C. MillerAuthors Info & Claims

SIGMOD '11: Proceedings of the 2011 ACM SIGMOD International Conference on Management of data

Pages 1259 - 1262

https://doi.org/10.1145/1989323.1989470

Published: 12 June 2011 Publication History

Get Access

Abstract

Microblogs such as Twitter are a tremendous repository of user-generated content. Increasingly, we see tweets used as data sources for novel applications such as disaster mapping, brand sentiment analysis, and real-time visualizations. In each scenario, the workflow for processing tweets is ad-hoc, and a lot of unnecessary work goes into repeating common data processing patterns. We introduce TweeQL, a stream query processing language that presents a SQL-like query interface for unstructured tweets to generate structured data for downstream applications. We have built several tools on top of TweeQL, most notably TwitInfo, an event timeline generation and exploration interface that summarizes events as they are discussed on Twitter. Our demonstration will allow the audience to interact with both TweeQL and TwitInfo to convey the value of data embedded in tweets.

References

[1]

S. Asur and B. A. Huberman. Predicting the future with social media. CoRR, abs/1003.5699, 2010.

Google Scholar

[2]

R. Avnur and J. M. Hellerstein. Eddies: Continuously adaptive query processing. In SIGMOD, pages 261--272, 2000.

Digital Library

Google Scholar

[3]

N. Diakopoulos, M. Naaman, and F. Kivran-Swaine. Diamonds in the rough: Social media visual analytics for journalistic inquiry. In VAST 2010.

Crossref

Google Scholar

[4]

N. Diakopoulos and D. A. Shamma. Characterizing debate performance via aggregated twitter sentiment. In CHI '10. ACM Press, 2010.

Digital Library

Google Scholar

[5]

R. Goldman and J. Widom. Wsq/dsq: a practical approach for combined querying of databases and the web. SIGMOD Rec., 29(2):285--296, 2000.

Digital Library

Google Scholar

[6]

P. J. Haas and J. M. Hellerstein. Online query processing: a tutorial. In SIGMOD, 2001.

Digital Library

Google Scholar

[7]

A. Marcus, M. S. Bernstein, O. Badar, D. R. Karger, R. C. Miller, and S. Madden. Twitinfo: Aggregating and visualizing microblogs for event exploration. In CHI 2011.

Digital Library

Google Scholar

[8]

V. Raman and J. M. Hellerstein. Partial results for online query processing. In SIGMOD '02, pages 275--286, New York, NY, USA, 2002. ACM.

Digital Library

Google Scholar

[9]

S. Vieweg, A. L. Hughes, K. Starbird, and L. Palen. Microblogging during two natural hazards events: what twitter may contribute to situational awareness. In CHI '10, New York, NY, USA, 2010. ACM.

Digital Library

Google Scholar

Cited By

View all

Kouadri WOuziri MBenbernou SEchihabi KPalpanas TAmor I(2020)Quality of sentiment analysis toolsProceedings of the VLDB Endowment10.14778/3436905.343692414:4(668-681)Online publication date: 1-Dec-2020
https://dl.acm.org/doi/10.14778/3436905.3436924
Magdy A(2020)MicroblogsSIGSPATIAL Special10.1145/3404820.340482712:1(41-52)Online publication date: 8-Jul-2020
https://dl.acm.org/doi/10.1145/3404820.3404827
Sharma SJain A(2020)Role of sentiment analysis in social media security and analyticsWIREs Data Mining and Knowledge Discovery10.1002/widm.136610:5Online publication date: 29-Mar-2020
https://doi.org/10.1002/widm.1366
Show More Cited By

Index Terms

Tweets as data: demonstration of TweeQL and Twitinfo
1. Information systems
  1. Data management systems

Recommendations

Analyzing and predicting viral tweets
WWW '13 Companion: Proceedings of the 22nd International Conference on World Wide Web

Twitter and other microblogging services have become indispensable sources of information in today's web. Understanding the main factors that make certain pieces of information spread quickly in these platforms can be decisive for the analysis of ...
Analysis of Tweets Related to Cyberbullying: Exploring Information Diffusion and Advice Available for Cyberbullying Victims

The use of Twitter, especially by teenagers and young people, has raised the issue of cyberbullying. There is a lack of research into what types of advice and support are available in tweets for cyberbullying victims, and into the features influencing ...
An analysis of influential users for predicting the popularity of news tweets
PRICAI'16: Proceedings of the 14th Pacific Rim International Conference on Trends in Artificial Intelligence

Twitter plays an important role in today social network. Its key mechanism is retweet that disseminates information to broad audiences within a very short time and help increases the popularity of the social content. Therefore, an effective model for ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

SIGMOD '11: Proceedings of the 2011 ACM SIGMOD International Conference on Management of data

June 2011

1364 pages

ISBN:9781450306614

DOI:10.1145/1989323

General Chair:
Timos Sellis
IMIS/RC Athena
,
Program Chair:
Renée J. Miller
University of Toronto
,
Publications Chairs:
Anastasios Kementsietsidis
IBM T.J. Watson Research Center
,
Yannis Velegrakis
University of Trento

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 12 June 2011

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Demonstration

Conference

SIGMOD/PODS '11

Sponsor:

SIGMOD

SIGMOD/PODS '11: International Conference on Management of Data

June 12 - 16, 2011

Athens, Greece

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

29
Total Citations
View Citations
638
Total Downloads

Downloads (Last 12 months)3
Downloads (Last 6 weeks)0

Reflects downloads up to 01 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Kouadri WOuziri MBenbernou SEchihabi KPalpanas TAmor I(2020)Quality of sentiment analysis toolsProceedings of the VLDB Endowment10.14778/3436905.343692414:4(668-681)Online publication date: 1-Dec-2020
https://dl.acm.org/doi/10.14778/3436905.3436924
Magdy A(2020)MicroblogsSIGSPATIAL Special10.1145/3404820.340482712:1(41-52)Online publication date: 8-Jul-2020
https://dl.acm.org/doi/10.1145/3404820.3404827
Sharma SJain A(2020)Role of sentiment analysis in social media security and analyticsWIREs Data Mining and Knowledge Discovery10.1002/widm.136610:5Online publication date: 29-Mar-2020
https://doi.org/10.1002/widm.1366
Magdy AAbdelhafeez LKang YOng EMokbel M(2019)Microblogs data management: a surveyThe VLDB Journal10.1007/s00778-019-00569-6Online publication date: 18-Sep-2019
https://doi.org/10.1007/s00778-019-00569-6
Lim KJayasekara SKarunasekera SHarwood AFalzon LDunn JBurgess G(2019)RAPID: Real-time Analytics Platform for Interactive Data MiningMachine Learning and Knowledge Discovery in Databases10.1007/978-3-030-10997-4_44(649-653)Online publication date: 18-Jan-2019
https://doi.org/10.1007/978-3-030-10997-4_44
Quadri SKarusala NArriaga R(2018)#AutismAwarenessProceedings of the 9th Indian Conference on Human-Computer Interaction10.1145/3297121.3297128(11-19)Online publication date: 16-Dec-2018
https://dl.acm.org/doi/10.1145/3297121.3297128
Suero Montero CHaddad HMozgovoy MAli C(2018)Detecting the Likely Causes Behind the Emotion Spikes of Influential Twitter UsersComputational Linguistics and Intelligent Text Processing10.1007/978-3-319-75487-1_29(374-384)Online publication date: 21-Mar-2018
https://doi.org/10.1007/978-3-319-75487-1_29
Li XZhang GXing CQu Z(2018)Efficient Massive Medical Rules Parallel Processing AlgorithmsSmart Health10.1007/978-3-030-03649-2_17(179-184)Online publication date: 26-Oct-2018
https://doi.org/10.1007/978-3-030-03649-2_17
Carvalho JRosa HBrogueira GBatista F(2017)MISNISExpert Systems with Applications: An International Journal10.1016/j.eswa.2017.08.00189:C(374-388)Online publication date: 15-Dec-2017
https://dl.acm.org/doi/10.1016/j.eswa.2017.08.001
Wrench CStahl FDi Fatta GKarthikeyan VNauck D(2016)Data Stream Mining of Event and Complex Event StreamsEnterprise Big Data Engineering, Analytics, and Management10.4018/978-1-5225-0293-7.ch003(24-47)Online publication date: 2016
https://doi.org/10.4018/978-1-5225-0293-7.ch003
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

Analyzing and predicting viral tweets

Analysis of Tweets Related to Cyberbullying: Exploring Information Diffusion and Advice Available for Cyberbullying Victims

An analysis of influential users for predicting the popularity of news tweets