Data warehouses are large complex systems with many interacting nonlinear components. It is an amalgamation of many different systems and integration of such diverse elements is its primary concern. It is often difficult for a data warehouse manager to predict the performance of the system especially when demand pattern for the required data keeps changing. We have developed a simulation model using ARENA simulation package that will simulate the behavior and performance of a data warehouse system environment based on its overall design. Given such a model, a data warehouse manager can walk through various what-if scenarios and can pinpoint the areas of weaknesses in the system. This visibility could result in improved operational performance in a data warehouse.
Agrawal, Vikas; Nandkeolyar, Udayan; Sundararaghavan, P.S.; and Ahmed, Mesbah U.
"Simulation Model and Analysis of a Data Warehouse,"
Journal of International Technology and Information Management: Vol. 15
, Article 3.
Available at: http://scholarworks.lib.csusb.edu/jitim/vol15/iss3/3