Building federated data warehouse schema using web service approach
Nouha Arfaoui, Faîçal Felhi, Jalel Akaichi · International Journal of Business Information Systems · 2019
The data warehouse is considered as a repository that stores data from disparate sources. It is used mainly in the process of decision making. Because of the diversity of the applications, their heterogeneity and their physical spacing, building a data warehouse, to make decisions in a federated architecture, is a very complicated task. To overcome this problem, we propose a new approach for the design of a federated data warehouse schema based on the web services. The latter are applied because of their capacity to solve many technical problems related to the integration of data source in a federated environment. The proposed solution is based on the bottom-up approach where the data warehouse schema is generated from the set schemas of the data mart. It is composed by two steps. In the first one, a web service is used to generate the schemas of the data mart one for each data source. In the second step, a second web service is used to merge the generated schemas to build the final schema of the data warehouse.