Building a data warehouse for twitter stream exploration

Proceedings of the 2012 IEEE/ACM International Conference on Advances in Social Networks Analysis and Mining, ASONAM 2012

Volumn , Issue , 2012, Pages 1341-1348

  Rehman, Nafees Ur ^a   Mansmann, Svetlana ^a   Weiler, Andreas ^a   Scholl, Marc H ^a  

^a UNIVERSITY OF KONSTANZ   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

DATA-MINING TOOLS; MULTIDIMENSIONAL CUBE; MULTIDIMENSIONAL DATA MODELS; RESEARCH INITIATIVES; SOCIAL NETWORKS; SPECIFIC TASKS;

DATA WAREHOUSES; LOADING;

SOCIAL NETWORKING (ONLINE);

EID: 84874267344     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ASONAM.2012.118     Document Type: Conference Paper

References (24)

1. Twitter Team, "Twitter turns six, " 2012. [Online]. Available: http://blog.twitter.com/2012/03/twitter-turns-six.html.
2. E. F. Codd, S. B. Codd, and C. T. Salley, "Providing OLAP (On-Line Analytical Processing) to User-Analysts: An IT Mandate, " E.F.Codd & Associates, Tech. Rep., 1993.
3. K. Orr, "Data warehousing technology, " The Ken Orr Institute, 1996, White Paper.
4. S. Mansmann and M. H. Scholl, "Decision Support System for Managing Educational Capacity Utilization, " IEEE Transactions on Education, vol. 50, no. 2, pp. 143-150, 2007.
5. T. Neumuth, S. Mansmann, M. H. Scholl, and O. Burgert, "Data Warehousing Technology for Surgical Workflow Analysis, " in CBMS 2008: Proceedings of the 21st IEEE International Symposium on Computer- Based Medical Systems. Jyvskyl, Finland: IEEE Computer Society, 2008, pp. 230-235.
6. A. Thusoo, Z. Shao, S. Anthony, D. Borthakur, N. Jain, J. Sen Sarma, R. Murthy, and H. Liu, "Data warehousing and analytics infrastructure at facebook, " in Proceedings of the 2010 international conference on Management of data, ser. SIGMOD '10. New York, NY, USA: ACM, 2010, pp. 1013-1020.
7. H. Kwak, C. Lee, H. Park, and S. Moon, "What is twitter, a social network or a news media?" in Proceedings of the 19th international conference on World wide web, ser. WWW '10. New York, NY, USA: ACM, 2010, pp. 591-600.
8. A. Java, X. Song, T. Finin, and B. Tseng, "Why we twitter: understanding microblogging usage and communities, " in Proceedings of the 9th WebKDD and 1st SNA-KDD 2007 workshop on Web mining and social network analysis. ACM, 2007, pp. 56-65.
9. M. Mathioudakis and N. Koudas, "Twittermonitor: trend detection over the twitter stream, " in Proceedings of the 2010 international conference on Management of data. ACM, 2010, pp. 1155-1158.
10. J. Chen, R. Nairn, L. Nelson, M. S. Bernstein, and E. H. Chi, "Short and tweet: experiments on recommending content from information streams." in Proc. CHI. ACM, 2010, pp. 1185-1194.
11. O. Phelan, K. McCarthy, and B. Smyth, "Using twitter to recommend real-time topical news, " in Proceedings of the third ACM conference on Recommender systems. ACM, 2009, pp. 385-388.
12. M. Michelson and S. A. Macskassy, "Discovering users' topics of interest on twitter: a first look, " in Proceedings of the Fourth Workshop on Analytics for Noisy Unstructured Text Data, AND 2010, Toronto Ontario, Canada, October 26th, 2010 (in conjunction with CIKM 2010). ACM, 2010.
13. B. Hecht, L. Hong, B. Suh, and E. H. Chi, "Tweets from justin bieber's heart: the dynamics of the location field in user profiles." in Proc. CHI. ACM, 2011, pp. 237-246.
14. A. Holupirek, C. Gr̈un, and M. H. Scholl, "BaseX & DeepFS joint storage for filesystem and database, " in Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, ser. EDBT '09. ACM, 2009, pp. 1108-1111.
15. C. Grün, A. Holupirek, M. Kramis, M. H. Scholl, and M. Waldvogel, "Pushing xpath accelerator to its limits, " in ExpDB, P. Bonnet and I. Manolescu, Eds. ACM, 2006.
16. R. Krikorian, "Developing for @twitterapi (techcrunch disrupt hackathon)." [Online]. Available: https://dev.twitter.com/docs/intro- twitterapi.
17. S. Chaudhuri, U. Dayal, and V. Ganti, "Database technology for decision support systems, " Computer, vol. 34, no. 12, pp. 48-55, 2001.
18. R. Kimball, The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. New York, NY, USA: John Wiley & Sons, Inc., 1996.
19. S. Mansmann, "Extending the olap technology to handle nonconventional and complex data, " Ph.D. dissertation, Konstanz, Germany, 2008.
20. M. Golfarelli, D. Maio, and S. Rizzi, "The Dimensional Fact Model: A conceptual model for data warehouses, " International Journal of Cooperative Information Systems, vol. 7, no. 2-3, pp. 215-247, 1998.
21. Inforgraphic and Benenett, Shea, "Just how big is twitter in 2012?" 2012. [Online]. Available: http://www.mediabistro.com/alltwitter/ twitter-statistics-2012b18914.
22. Wikipedia, "Indonesia, " 2012. [Online]. Available: http://en.wikipedia.org/wiki/Indonesia.
23. US Geological Survey, "Earthquake off the west coast of sumatra, " 2012. [Online]. Available: http://earthquake.usgs.gov/earthquakes/ recenteqsww/Quakes/usc000905e.php.
24. BMKG, "Indonesian meteorological climatological and geophysical agency, " 2012. [Online]. Available: http://www.bmkg.go.id.