Towards Data Warehouse Schema Design from Social Networks - Dynamic Discovery of Multidimensional Concepts

Rania Yangui, Ahlem Nabli, Faiez Gargouri

2015

Abstract

This research work is conducting as part of the project BWEC (Business for Women in Women of Emerging Country) that aims to improve the socio-economic situation of handicraft women by providing true technological means. In fact, since few years, the Web has been transformed into an exchange platform where users have become the main suppliers of information through social media. User-generated data are usually rich and thus need to be analyzed to enhance decision. The storage and the centralization of these data in a data warehouse (DW) are highly required. Nevertheless, the growing complexity and volumes of the data to be analyzed impose new requirements on DW. In order to address these issues, in this paper, we propose four stages methodology to define a DW schema from social networks. Firstly we design the initial DW schema based on the existing approaches. Secondly, we apply a set of transformation rules to prepare the creation of the NOSQL(Not Only SQL) data warehouse. Then, based on user’s requirement, clustering of social networks profiling data will be performed which allows the dynamic discovery of multidimensional concepts. Finally, the enrichment of the NoSQL DW schema by the discovered MC will be realized to ensure the DW schema evolution.

References

  1. A. Thusoo, Z. Shao, S. A. D. B. N. J. J. S. S. R. M. and Liu, H. (2010). Data warehousing and analytics infrastructure at facebook. In International conference on Management of data SIGMOD'10, pages 1013-1020.
  2. E. Gallinucci, M. Golfarelli, A. W. and Rizzi, S. (2013). Meta-stars: Multidimensional modeling for social business intelligence. In International Workshop On Data Warehousing and OLAP DOLAP13, pages 11- 18.
  3. L. Sautot, B. Faivre, L. J. and Molin, P. (2014). The hierarchical agglomerative clustering with gower index: A methodology for automatic design of olap cube in ecological data processing context. In Ecological Informatics, pages 1-14.
  4. M. Ceci, A. and Malerba, D. (2011). Olap over continuous domains via densitybased hierarchical clustering. In International Conference on Knowledge-Based and Intelligent Information and Engineering Systems KES'11, pages 559-570.
  5. Mansmann, S. (2008). Extending the olap technology to handle nonconventional and complex data. In Ph.D. dissertation, University Konstanz, Department of Computer and Information Science Germany.
  6. Moalla, I. and Nabli, A. (2014). Towards data mart building from social network for opinion analysis. In International Conference on Intelligent Data Engineering and Automated Learning IDEAL14, pages 295-302.
  7. N. U. Rehman, S. Mansmann, A. W. and Scholl, M. H. (2012). Building a data warehouse for twitter stream exploration. In International Conference on Advances in Social Networks Analysis and Mining ASONAM'12, pages 1341-1348.
  8. Nabli, A. (2013). Approche d'aide la conception automatise d'entrept de donnes: Guide de modlisation. Presses Acadmiques Francophones.
  9. P. Kazienko, K. Musial, E. K. T. K. and Brdka, P. (2011). Multidimensional social network: Model and analysis. In International Conference on Computational Collective Intelligence Technologies and Applications ICCCI'11, pages 378-387.
  10. R. Yangui, A. N. and Gargouri, F. (2014a). Shicaro: Semisupervised hierarchical clustering based on ranking features using ontology. In International Conference on Management and Technology in Knowledge, Service, Tourism & Hospitality SERVE'14, pages 233- 238.
  11. R. Yangui, A. N. and Gargouri, F. (2014b). Soim: Similarity measures on ontology instances based on mixed features. In 4th International Conference on Model & Data Engineering MEDI2014, pages 169-176.
  12. Usman, M. and Pears, R. (2011). Multi level mining of warehouse schema. In NDT, volume 136 of Communications in Computer and Information Science, pages 395-408.
Download


Paper Citation


in Harvard Style

Yangui R., Nabli A. and Gargouri F. (2015). Towards Data Warehouse Schema Design from Social Networks - Dynamic Discovery of Multidimensional Concepts . In Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-096-3, pages 338-345. DOI: 10.5220/0005383903380345


in Bibtex Style

@conference{iceis15,
author={Rania Yangui and Ahlem Nabli and Faiez Gargouri},
title={Towards Data Warehouse Schema Design from Social Networks - Dynamic Discovery of Multidimensional Concepts},
booktitle={Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2015},
pages={338-345},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005383903380345},
isbn={978-989-758-096-3},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Towards Data Warehouse Schema Design from Social Networks - Dynamic Discovery of Multidimensional Concepts
SN - 978-989-758-096-3
AU - Yangui R.
AU - Nabli A.
AU - Gargouri F.
PY - 2015
SP - 338
EP - 345
DO - 10.5220/0005383903380345