Building a Data Warehouse for Social Media Analysis: The case of Twitter and Facebook

Author:

kraiem Maha Ben1,Feki Jamel1

Affiliation:

1. University of Jeddah, IST dept Jeddah

Abstract

Abstract The proliferation of data generated and stored through social media has experienced a significant surge over the past decade. Consequently, the analysis and interpretation of such data have emerged as valuable sources of insights across diverse contexts, serving as aids for researchers and businesses in making informed decisions. However, the data is widespread, stemming from diverse sources with distinct formats, and is generated at a rapid pace. These characteristics collectively contribute to the intricacy of extracting knowledge from this data, transforming the process into one that is both complex and resource-intensive. The central scientific contribution of this paper lies in the formulation of a social media data integration model, built upon the foundation of a data warehouse. This model is designed to alleviate the computational costs associated with data analysis while concurrently facilitating the application of techniques aimed at discovering meaningful insights. Notably, this study differentiates itself from existing literature by concentrating on both the Facebook and Twitter social media platforms. Additionally, we introduce a model that covers data acquisition, transformation, and loading processes, enabling the extraction of valuable insights even when the data's complexity surpasses human understanding. The results of our study showcase that the proposed data warehouse enhances the effectiveness of data mining algorithms in contrast to related works. Notably, this improvement in quality is achieved while simultaneously reducing execution time.”

Publisher

Research Square Platform LLC

Reference24 articles.

1. Ben Kraiem M., Feki J, Khrouf K, Ravat F, Teste O (2014). OLAP of the Tweets: From Modeling toward exploitation. 8th International Conference on Research Challenges in Information Science (IEEE RCIS’2014), May 28–30, 2014, Marrakesh, Morocco, pp. 45–55, ISBN #978-1-4799-2393-9.

2. Opinion mining and information fusion: A survey;Balazs JA;Inform. Fus.,2016

3. Social media analytics: A survey of techniques, tools and platforms;Batrinca B;Ai Society,2015

4. DOI: 10.1007/s00146-014-0549-4

5. Bringay S, Béchet N, Bouillot F, Poncelet P, Roche M, Teisseire M (2011) Towards an On-Line Analysis of Tweets Processing, 22nd International Conference on Database and Expert Systems Applications, DEXA, Toulouse, France.

同舟云学术

1.学者识别学者识别

2.学术分析学术分析

3.人才评估人才评估

"同舟云学术"是以全球学者为主线,采集、加工和组织学术论文而形成的新型学术文献查询和分析系统,可以对全球学者进行文献检索和人才价值评估。用户可以通过关注某些学科领域的顶尖人物而持续追踪该领域的学科进展和研究前沿。经过近期的数据扩容,当前同舟云学术共收录了国内外主流学术期刊6万余种,收集的期刊论文及会议论文总量共计约1.5亿篇,并以每天添加12000余篇中外论文的速度递增。我们也可以为用户提供个性化、定制化的学者数据。欢迎来电咨询!咨询电话:010-8811{复制后删除}0370

www.globalauthorid.com

TOP

Copyright © 2019-2024 北京同舟云网络信息技术有限公司
京公网安备11010802033243号  京ICP备18003416号-3