Title: Federated data warehousing application framework and platform-as-a-services to model virtual data marts in the clouds

Authors: Thanh Binh Nguyen; Fabian Wagner; Wolfgang Schoepp

Addresses: International Institute for Applied Systems Analysis (IIASA), Schlossplatz 1, A-2361 Laxenburg, Austria ' International Institute for Applied Systems Analysis (IIASA), Schlossplatz 1, A-2361 Laxenburg, Austria ' International Institute for Applied Systems Analysis (IIASA), Schlossplatz 1, A-2361 Laxenburg, Austria

Abstract: Each federated data warehousing system contains a data warehouse and a class of data marts. Building and maintaining such systems are painful processes. In this paper, we propose our approach to improve these processes. First, a cloud-based federated data warehousing system architecture, description of which is specified in a formal manner, is introduced. Afterwards, Unified Modelling Language (UML) is used to design the conceptual model. In this context, a cloud-based federated data warehousing application framework and its components, i.e., global data warehouse and linked virtual data marts, as well as its services, i.e., platform-as-a-services, software-as-a-services are modelled. Hereafter, the GAINS model is presented as an implementation example to proof of our concepts.

Keywords: federated data warehouses; DWH; greenhouse gases; GHG; air pollution; GAINS; optimisation; Unified Modelling Language; UML; online analytical processing; OLAP; platform-as-a-service; PaaS; conceptual modelling; virtual data marts; cloud computing; software-as-a-service; SaaS.

DOI: 10.1504/IJIIDS.2014.066635

International Journal of Intelligent Information and Database Systems, 2014 Vol.8 No.3, pp.280 - 294

Received: 29 Apr 2013
Accepted: 25 Oct 2013
Published online: 11 Jan 2015 *

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