Applications of data management and analysis : Case studies in social networks and beyond.