Title: Virtual data warehouse: implementation and experimental comparison

Authors: Khurram Shahzad, Ghulam Mustafa

Addresses: Department of Computer and Systems Sciences, Royal Institute of Technology (KTH)/Stockholm University, Forum 100, SE 164 40 Kista, Stockholm, Sweden. ' Punjab Information Technology Board (PITB), 84-E Model Town, Lahore, Pakistan

Abstract: The purpose of this paper is to evaluate the virtual data warehousing (VDW) concept, by evaluating its capabilities to solve the problems that are identified in recent studies. In this study, we have developed a tool (called VDW-tool), with the capability of implementing virtual data warehouse, and proposed a framework (called 4-DEF), for evaluation of data warehouse. In order to evaluate the virtual data warehouse, we have compared its capabilities with conventional data warehouse, by means of 4-DEF framework. To demonstrate that, results from four experimental case studies are included in this paper. It is found that virtual data warehouse not only enhances schema and content flexibility, but it also provides on-the-fly data for decision support purposes. Furthermore, our experiments demonstrate that the performance of conventional data warehouse (DW) is slightly better than virtual data warehouse, as long as the size of DW is not too large.

Keywords: decision support systems; computer-based decision aids; virtual data warehouses; comparison frameworks; capability evaluation; VDW-tool; 4-DEF; schema enhancement; content flexibility; on-the-fly data; performance measurement; data warehousing; data management; strategic decision making; decision models.

DOI: 10.1504/IJMDM.2010.033644

International Journal of Management and Decision Making, 2010 Vol.11 No.1, pp.69 - 88

Published online: 09 Jun 2010 *

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