Building a Data Warehouse for Social Media: Review and Comparison

Authors

  • Maha Ben Kraiem Miracl, University of Sfax, Tunisia IRIT, University of france
  • Jamel Feki

DOI:

https://doi.org/10.13053/cys-28-1-4677

Keywords:

Data warehouse, social media, multidimensional model, OLAP, BI

Abstract

The considerable development experienced by the technologies in recent decades has led to the emergence of relatively simple panoply of Internet applications based on open source software, and services designed to improve online collaboration to the large public as: social networking sites. These social networks have revolutionized the ways of interacting and exchanging information on the Internet. Millions of users interact frequently and share variety of digital content with each other. They express their feelings and opinions on every topic of interest. These opinions carry import value for personal, academic and commercial applications, but the volume and the speed at which these are produced make it a challenging task for decision makers and the underlying technologies to provide useful insights to such data. In order to benefit from the data issued from these social networks, many researchers focused on helping companies understand how to perform a competitive analysis and transform these data into knowledge for decision makers.In this paper, we provide a literature review on data warehouse approaches from social networks. More precisely, we start by introducing the main concepts of data warehouse and social networks. We also propose three classes of data warehouse approaches and expose for each one the most representative existing works. Afterward, we propose a comparative study of the existing works.

Downloads

Published

2024-03-20

Issue

Vol. 28 No. 1 (2024): 28(1) 2024

Section

Articles

License 

Hereby I transfer exclusively to the Journal "Computación y 
Sistemas", published by the Computing Research Center (CIC-IPN),
the Copyright of the aforementioned paper. I also accept that these 
rights will not be transferred to any other publication, in any other 
format, language or other existing means of developing.
I certify that the paper has not been previously disclosed or simultaneo
usly submitted to any other publication, and that it does not contain 
material whose publication would violate the Copyright or other 
proprietary rights of any person, company or institution. I certify that 
I have the permission from the institution or company where I work or 
study to publish this work.
The representative author accepts the responsibility for the publication
of this paper on behalf of each and every one of the authors. 
This transfer is subject to the following conditions:
  • The authors retain all ownership rights (such as patent rights) of this work, except for the publishing rights transferred to the CIC, through this document.
  • Authors retain the right to publish the work in whole or in part in any book they are the authors or publishers. They can also make use of this work in conferences, courses, personal web pages, and so on.
  • Authors may include working as part of his thesis, for non-profit distribution only.