ELTE Digital Institutional Repository (EDIT) (Eötvös Loránd University) · 2013 · 23 citations · 16 references
ComputingComputer ScienceGeoinformaticsDatabasesGeographic Information ScienceSpatial Data AnalysisGeospatial Natural Language ProcessingSocial MediaSocial Network AnalysisData LoadingGeospatial Text MiningGeotagged Data AnalysisLinguistic Feature AnalysisRelational Database SystemsScalable Database DesignSocial Media GeographiesSocial Network Structure
Despite their relatively low sampling factor, the freely available, randomly sampled status streams of Twitter are very useful sources of geographically embedded social network data. To statistically analyze the information Twitter provides via these streams, we have collected a year's worth of data and built a multi-terabyte relational database from it. The database is designed for fast data loading and to support a wide range of studies focusing on the statistics and geographic features of social networks, as well as on the linguistic analysis of tweets. In this paper we present the method of data collection, the database design, the data loading procedure and special treatment of geo-tagged and multi-lingual data. We also provide some SQL recipes for computing network statistics.
16
What is Twitter, a social network or a news media?
Haewoon Kwak, Changhyun Lee, Hosung Park et al. · 2010 · 6.7K citations · Full text
Eunjoon Cho, Seth A. Myers, Jure Leskovec · 2011 · 2.9K citations
Groups of galaxies. I - Nearby groups
J. Huchra, Margaret J. Geller · The Astrophysical Journal · 1982 · 850 citations
Natural Sciences, Astronomy, Physics +15
Lars Bäckström, Eric Sun, Cameron Marlow · 2010 · 712 citations
The Twitter of Babel: Mapping World Languages through Microblogging Platforms
Delia Mocanu, Andrea Baronchelli, Nicola Perra et al. · PLoS ONE · 2013 · 297 citations · Full text