Authors:
Rania Yangui
;
Ahlem Nabli
and
Faiez Gargouri
Affiliation:
Sfax University, Tunisia
Keyword(s):
: Data Warehouse, Social Network, Ontology, Flexibility, Scalability, Dynamicity, Clustering.
Related
Ontology
Subjects/Areas/Topics:
Data Warehouses and OLAP
;
Databases and Information Systems Integration
;
Enterprise Information Systems
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, base
d 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.
(More)