Integration of a multidimensional schema from different social media to analyze customers'opinions

The increasing role of social media has pushed the scientific community to invest in them and take advantage of their information. Furthermore, the diffusion of social media has a very significant impact on several areas, such as marketing (customer's opinion analysis), terrorism, politics, etc. They affect a very wide audience, such as students, teenagers and companies. In fact, Facebook, Twitter and YouTube platforms play an increasingly important role for companie's to analysis customers generated content and also the information about their competitors. The transformation of data from social media into new knowledge for decision makers is a challenging task nowadays. In this context, several businesses have worked on these media to get extra information about their customers. Thus, the need for a data warehouse has become an emergency for the storage and management of data from social media. However, most of research studies have worked on only one social medium. Specifically, in this paper, we are interested in the design of multidimensional schema of data warehouse for opinion analysis. Firstly, we focuse on the design of the data mart from each social medium. Secondly, we present the data mapping between the multidimensional concepts of data mart determined from different social media. Thirdly, we are interested in the schema integration of several data mart schemes. Our goal is to achieve a generic data warehouse schema, including the most popular social media in order to analyze customers'opinions.