Building federated data warehouse schema using web service approach Online publication date: Fri, 26-Apr-2019
by Nouha Arfaoui; Faîçal Felhi; Jalel Akaichi
International Journal of Business Information Systems (IJBIS), Vol. 30, No. 4, 2019
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.
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Business Information Systems (IJBIS):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email subs@inderscience.com
Our Blog 
Follow us on Twitter 
Visit us on Facebook