Skip to main content

Community Detection-Based Methodology to Data Warehouse Modeling from Social Network: Application to Handicraft Women Social Network

  • Chapter
  • First Online:
Social Interactions and Networking in Cyber Society
  • 522 Accesses

Abstract

Data generated from social network are usually rich and need to be analyzed to support the decision making process. The storage and centralization of these data in a data warehouse are highly required. However, classical warehousing approaches have shown some limitations when dealing with this kind of data. In fact, data warehouses schema are essentially static in that the change of social networks is neglected. Challenged by these limitations, we propose, in this book chapter a methodology to design a DW schema via dynamic discovery of community from huge social networks (Facebook) using semi-supervised hierarchical clustering coupled with profiling ontology.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    Towards a new Manner to use Affordable Technologies and Social Networks to Improve Business for Women in Emerging Countries http://projetat.cerist.dz/artisanat/

References

  • Cai, B., Wang, H., Zheng, H., & Wang, H. (2010). Evaluation repeated random walks in community detection of social networks. In Proceedings of the ninth international conference on machine learning and cybernetics, Qingdao.

    Google Scholar 

  • Gallinucci, E., Golfarelli, M., & Rizzi, S. (2013). Meta-stars: Multidimensional modeling for social business intelligence. In International workshop on data warehousing and OLAP DOLAP13.

    Google Scholar 

  • Gruber, T. R. (1993). Towards principles for the design of ontologies used for knowledge sharing. In N. Guarino & R. Poli (Eds.), Formal ontology in conceptual analysis and knowledge representation. Deventer: Kluwer Academic Publishers.

    Google Scholar 

  • Kazienko, P., Musial, K., & Brdka, P. (2011). Multidimensional social network: Model and analysis. In International Conference on Computational Collective Intelligence Technologies and Applications ICCCI’11.

    Google Scholar 

  • Moalla, I., & Nabli, A. (2014). Towards data mart building from social network for opinion analysis. In International conference on Intelligent Data Engineering and Automated Learning IDEAL14.

    Google Scholar 

  • Nabli, A. (2013). Approche d’aide la conception automatise d’entrept de donnes: Guide de modlisation. Presses Acadmiques Francophones.

    Google Scholar 

  • Nabli, A., Bouaziz, S., Yangui, R., & Gargouri F. (2015) Two-ETL phases for data warehouse creation: Design and implementation. In The 19st European Conference on Advances in Databases and Information Systems, Futuroscope, Poitiers, France. 138–150.

    Google Scholar 

  • Papadopoulos, S., Kompatsiaris, Y., & Vakali, A. (2009). Leveraging collective intelligence through community detection in tag networks. In Proceedings of CKCaR’09 workshop on collective knowledge capturing and representation, Redondo Beach, California.

    Google Scholar 

  • Rehman, N., Mansmann, S., & Scholl, M. (2012). Building a data warehouse for twitter stream exploration. In International conference on Advances in Social Networks Analysis and Mining ASONAM’12.

    Google Scholar 

  • Thusoo, A., Shao, Z., & Liu, H. (2010). Data warehousing and analytics infrastructure at facebook. In International conference on Management of data SIGMOD’10.

    Google Scholar 

  • Wang, Z., Chen, Z., Zhao, Z., & Chen, S. (2014). A community detection algorithm based on topology potential and spectral clustering. The Scientific World Journal, 2014, 1–9.

    Google Scholar 

  • Yangui, R., Maalej, M., Mtibaa, A., Nabli, A., Mhiri M., & Gargouri, F. (2014a). Ontology-based clustering of handicraft women. In ASD Advances on Decisional Systems Conference, (pp. 29–31).

    Google Scholar 

  • Yangui, R., Nabli, A., & Gargouri, F. (2014b). Shicaro: Semisupervised hierarchical clustering based on ranking features using ontology. In International conference on management and technology in knowledge, service, tourism hospitality SERVE’14.

    Google Scholar 

  • Zhang, Q., Gong, Y., Sun, X., & Huang, X. (2014). Time-aware personalized Hashtag recommendation on social media. In The 25th International conference on computational linguistics, (pp. 203–212), Dublin, Ireland.

    Google Scholar 

Download references

Acknowledgments

We are very thankful to the Algerian Tunisian Project dealing with the improvement of handicraft women business in emerging countries through affordable technologies and social networks. This project is financed by the Tunisian Ministry of Higher Education, Scientific Research and Information and Communication Technologies Higher Education and Scientific Research sector.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to R. Yangui .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer Nature Singapore Pte Ltd.

About this chapter

Cite this chapter

Yangui, R., Nabli, A., Gargouri, F. (2017). Community Detection-Based Methodology to Data Warehouse Modeling from Social Network: Application to Handicraft Women Social Network. In: Gaol, F., Hutagalung, F. (eds) Social Interactions and Networking in Cyber Society. Springer, Singapore. https://doi.org/10.1007/978-981-10-4190-7_10

Download citation

  • DOI: https://doi.org/10.1007/978-981-10-4190-7_10

  • Published:

  • Publisher Name: Springer, Singapore

  • Print ISBN: 978-981-10-4189-1

  • Online ISBN: 978-981-10-4190-7

  • eBook Packages: Social SciencesSocial Sciences (R0)

Publish with us

Policies and ethics