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.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
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)
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)
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)
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)
Hu, Y., Li, W.: Document sentiment classification by exploring description model of topical terms. Comput. Speech Lang. J. 25(2), 386–403 (2011)
Jiao, J., Zhou, Y.: Sentiment polarity analysis based multi dictionary. In: International Conference on Physics Science and Technology (ICPST) (2011)
Kim, S., Hovy, E.: Determining the sentiment of opinions. In: Proceedings of the 20th International Conference on Computational Linguistics (COLING’04) (2004)
Liu, B.: Web Data Mining: Exploring Hyperlinks, Contents, and Usage Data, 2nd edn. Springer, New York (2011)
Medhat, W., Hassan, A., Korashy, H.: Sentiment analysis algorithms and applications: a survey. Ain Shams Eng. J. 5(4), 1093–1113 (2014)
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)
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)
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)
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)
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)
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)
Vassiliadis, P.: A survey of extract–transform–load technology. Int. J. Data Wareh. Min. (IJDWM), 5(3), 1–27 (2009)
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)
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)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)