Skip to main content
SpringerLink
Log in
Book cover

Computer and Information Science 2015 pp 235–249Cite as

ETL Design Toward Social Network Opinion Analysis

  • Conference paper
  • First Online:

Part of the book series: Studies in Computational Intelligence ((SCI,volume 614))

Abstract

Now-a-days, social networking sites have been created lot of buzz in technology world. They are considered as a rich source of information because people share and discuss their opinions about a certain topic freely. Sentiment analysis or opinion mining is used for knowing voice or response of crowd for products, services, organizations, individuals, events, etc. Due to the importance of user’s opinions in decisional systems, several Data Warehouse approaches integrate them through a cleaning and transformation processes. However, there is a clear lack of a standard model that can be used to represent the ETL processes. We propose an ETL design approach integrating user’s opinion analysis, expressed on the popular social network Facebook. It consists in the extraction of opinion data on Facebook pages (e.g. comments), its pre-processing, sentiment analysis and classification, reformatting and loading into the Data WeBhouse (DWB).

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

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   129.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD   169.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

Learn about institutional subscriptions

References

  1. Abbasi, A., Chen, H., Salem, A.: Sentiment analysis in multiple languages: feature selection for opinion classification in web forums. ACM Trans. Inf. Syst. 26(3), 1–34 (2008)

    Article  Google Scholar 

  2. Akkaoui, Z.E., Mazón, J., Vaisman, A.A., Zimányi, E.: BPMN-Based conceptual modeling of ETL processes. In: 14th International Conference on Data Warehousing and Knowledge Discovery (DaWaK), pp. 1–14 (2012)

    Google Scholar 

  3. El-Sappagh, S., Hendawi, H., Bastawissy, A.H.: A proposed model for data warehouse ETL processes. J. King Saud Univ. Comput. Inf. Sci. 23(2), 91–104 (2011)

    Google Scholar 

  4. Hogenboom, A., Bal, D., Frasincar, F.: Exploiting emoticons in sentiment analysis. In: Proceedings of the 28th Annual ACM Symposium on Applied Computing (SAC), pp. 703–710 (2013)

    Google Scholar 

  5. Hu, Y., Li, W.: Document sentiment classification by exploring description model of topical terms. Comput. Speech Lang. J. 25(2), 386–403 (2011)

    Article  Google Scholar 

  6. Jiao, J., Zhou, Y.: Sentiment polarity analysis based multi dictionary. In: International Conference on Physics Science and Technology (ICPST) (2011)

    Google Scholar 

  7. Kim, S., Hovy, E.: Determining the sentiment of opinions. In: Proceedings of the 20th International Conference on Computational Linguistics (COLING’04) (2004)

    Google Scholar 

  8. Liu, B.: Web Data Mining: Exploring Hyperlinks, Contents, and Usage Data, 2nd edn. Springer, New York (2011)

    Google Scholar 

  9. Medhat, W., Hassan, A., Korashy, H.: Sentiment analysis algorithms and applications: a survey. Ain Shams Eng. J. 5(4), 1093–1113 (2014)

    Article  Google Scholar 

  10. Miller, G., Beckwith, R., Fellbaum, C., Gross, D., Miller, K.: WordNet: an on line lexical database. In: International Journal of Lexicography, vol. 3. Oxford University Press (1990)

    Google Scholar 

  11. Minging, H., Bing, L.: Mining and summarizing customer reviews. In: Proceeding of ACM SIGKDD International Conference on Knowledge Discovery and Data Mining (KDD’04), pp. 168–177 (2004)

    Google Scholar 

  12. Muñoz, L., Mazón, J.N., Trujillo, J.: A family of experiments to validate measures for UML activity diagrams of ETL processes in data warehouse. Inf. Softw. Technol. 52(11), 1188–1203 (2010)

    Article  Google Scholar 

  13. Qiu, G., He, X., Zhang, F., Shi, Y., Bu, J., Chen, C.: DASA: dissatisfaction-oriented advertising based on sentiment analysis. Expert Syst. Appl. J. 37(9), 6182–6191 (2010)

    Article  Google Scholar 

  14. Trujillo, J., Luján-Mora, S.: A UML based approach for modeling ETL processes in data warehouses. In: 22nd International Conference on Conceptual Modeling—ER. Lecture Notes in Computer Science, vol. 2813, pp. 307–320 (2003)

    Google Scholar 

  15. Vashisht, S., Thakur, S.: Facebook as a corpus for emoticons-based sentiment analysis. Int. J. Emerg. Technol. Adv. Eng. J. (IJETAE) 4(5), 904–908 (2014)

    Google Scholar 

  16. Vassiliadis, P.: A survey of extract–transform–load technology. Int. J. Data Wareh. Min. (IJDWM), 5(3), 1–27 (2009)

    Google Scholar 

  17. Wilkinson, K., Simitsis, A., Dayal, U., Castellanos, M.: Leveraging business process models for ETL design. In: ER 2010: 29th International Conference on Conceptual Modeling, November 2010. Lecture Notes in Computer Science, vol. 6412, pp. 15–30 (2010)

    Google Scholar 

  18. Wilson, T., Wiebe, J., Hoffmann, P.: Recognizing contextual polarity in phrase-level sentiment analysis. In: Proceeding of the conference on Human Language Technology and Empirical Methods in Natural Language Processing. Association for Computational Linguistics, pp. 347–354 (2005)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Multimedia, Information systems and Advanced Computing Laboratory, MIR@CL, University of Sfax, Sfax, Tunisia

    Afef Walha

  2. Institute of Computer Science and Multimedia, University of Sfax, Sfax, Tunisia

    Faiza Ghozzi & Faïez Gargouri

Authors
  1. Afef Walha
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Faiza Ghozzi
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Faïez Gargouri
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Afef Walha .

Editor information

Editors and Affiliations

  1. Software Engineering and Information Institute, Central Michigan University, Mount Pleasant, Michigan, USA

    Roger Lee

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Walha, A., Ghozzi, F., Gargouri, F. (2016). ETL Design Toward Social Network Opinion Analysis. In: Lee, R. (eds) Computer and Information Science 2015. Studies in Computational Intelligence, vol 614. Springer, Cham. https://doi.org/10.1007/978-3-319-23467-0_16

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-23467-0_16

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-23466-3

  • Online ISBN: 978-3-319-23467-0

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation