Title: Building federated data warehouse schema using web service approach

Authors: Nouha Arfaoui; Faîçal Felhi; Jalel Akaichi

Addresses: BESTMOD, High Institute of Management, Tunis, Tunisia ' BESTMOD, High Institute of Management, Tunis, Tunisia ' College of Computer Science, King Khaled University, Abha, Saudi Arabia

Abstract: 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.

Keywords: federated architecture; federated data warehouse schema; data mart schema; web service; schema integration; schema merging.

DOI: 10.1504/IJBIS.2019.099307

International Journal of Business Information Systems, 2019 Vol.30 No.4, pp.463 - 488

Received: 24 Jan 2017
Accepted: 26 Aug 2017

Published online: 26 Apr 2019 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article