Business Commons^™

Simulation Model And Analysis Of A Data Warehouse, Vikas Agrawal, Udayan Nandkeolyar, P.S. Sundararaghavan, Mesbah U. Ahmed

Journal of International Technology and Information Management

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 …