A data warehouse environment for storing and analyzing simulation output data

Part of book or chapter of book English OPEN
Vasilakis, Christos ; El-Darzi, Elia ; Chountas, Panagiotis

Discrete event simulation modelling has been extensively\ud used in modelling complex systems. Although it offers\ud great conceptual-modelling flexibility, it is both computationally expensive and data intensive. There are several examples of simulation models that generate millions of observations to achieve satisfactory point and confidence interval estimations for the model variables. In these cases, it is exceptionally cumbersome to conduct the required output and sensitivity analysis in a spreadsheet or statistical package. In this paper, we highlight the advantages of employing data warehousing techniques for storing and analyzing simulation output data. The proposed data warehouse environment is capable of providing the means for automating the necessary algorithms and procedures for estimating different parameters of the simulation. These include initial transient in steady-state simulations and point and confidence interval estimations. Previously developed models for evaluating patient flow through hospital epartments are used to demonstrate the problem and the proposed solutions.
  • References (20)
    20 references, page 1 of 2

    Alexopoulos, C. and D. Goldsman. 2003. To Batch or Not to Batch. In Proceedings of the 2003 Winter Simulation Conference, eds. S. Chick, P. J. Sánchez, D. Ferrin and D. J. Morrice, 481-489. Piscataway, New Jersey: Institute of Electrical and Electronics Engineers.

    Alexopoulos, C. and A. F. Seila. 1998. Output Data Analysis. In Handbook of simulation: principles, methodology, advances, applications and practice, ed J. Banks, 225-272. New York: Wiley.

    Banks, J. 1997. The Future of Simulation Software: A Panel Discussion. In Proceedings of the 1997 Winter Simulation Conference, eds. S. Andradottir, K. J. Healy, D. H. Withers and B. L. Nelson, 1155-1162. Piscataway, New Jersey: Institute of Electrical and Electronics Engineers.

    Banks, J., J. S. I. Carson and B. L. Nelson. 2001. Discreteevent system simulation. New Jersey: Prentice-Hall.

    Chaudhuri, S., U. Dayal and V. Ganti. 2001. Database Technology for Decision Support Systems. Computer 34(12): 48-55.

    Codd, E. F., S. B. Codd and C. T. Salley. 1993. Providing OLAP to User-Analysts: An IT Mandate. Sunnyvale, California: E.F. Codd & Associates.

    Connoly, T. and C. Begg. 2002. Database Systems, A practical approach to Design, Implementation , and Management. Essex: Addison-Wesley.

    El-Darzi, E., C. Vasilakis, T. Chaussalet and P. H. Millard. 2000. A Simulation model to evaluate the interaction between acute, rehabilitation, long-stay care and the community. In Decision Making: Recent Developments and Worldwide Applications, eds. S. H. Zanakis, G. Doukidis and C. Zopounidis, 475-485. Dordrecht: Kluwer Academic Publishers.

    Kimball, R. 1998. The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses. New York: Wiley.

    Koutsoukis, N.-S., G. Mitra and C. Lucas. 1999. Adapting on-line analytical processing for decision modelling: the interaction of information and decision technologies. Decision Support Systems 26(1): 1-30.

  • Metrics
    No metrics available
Share - Bookmark