Skip to main content
Article thumbnail
Location of Repository

A data warehouse environment for storing and analyzing simulation output data

By Christos Vasilakis, Elia El-Darzi and Panagiotis Chountas

Abstract

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

Topics: UOW3
Publisher: IEEE Computer Society
OAI identifier: oai:westminsterresearch.wmin.ac.uk:812
Provided by: WestminsterResearch

Suggested articles

Citations

  1. (2001). A conceptual model and algebra for on-line analytical processing in decision support databases.
  2. (2000). A Simulation model to evaluate the interaction between acute, rehabilitation, long-stay care and the community.
  3. (2001). A simulation study of the winter bed crisis.
  4. (2002). A Statistical Process Control Appoach for Estimating the Warm-Up Period.
  5. (1999). A survey of logical models for OLAP databases.
  6. (1999). Adapting on-line analytical processing for decision modelling: the interaction of information and decision technologies. Decision Support Systems
  7. (2004). An OLAP-enabled environment for modelling patient flow.
  8. (1998). Computer simulation in management science.
  9. (2002). Database Systems, A practical approach to Design, Implementation , and Management.
  10. (2001). Database Technology for Decision Support Systems.
  11. (2001). Discreteevent system simulation.
  12. (2001). MDX Solutions with Microsoft SQL Server Analysis Services.
  13. (1998). Output Data Analysis. In Handbook of simulation: principles, methodology, advances, applications and practice,
  14. (2003). Simulating the flow of patients: an OLAP-enabled decision support framework.
  15. (2000). Simulation Modelling and Analysis.
  16. (1998). The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses.
  17. (1997). The Future of Simulation Software: A Panel Discussion.
  18. (1983). The statistical analysis of simulation results. In Computer Performance Modeling
  19. (2003). To Batch or Not to Batch.

To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.