Skip to main content
Article thumbnail
Location of Repository

An OLAP-enabled software environment for modelling patient flow

By Christos Vasilakis, Elia El-Darzi and Panagiotis Chountas


On-Line Analytical Processing (OLAP) tools use multidimensional views to provide quick access to information. They have become the de facto standard in the business world for analytical databases. In health care, care givers and managers could benefit from being able to perform interactive data exploration, ad-hoc analysis and possibly discover hidden trends and patterns in health data. However, health data have unique characteristics that distinguish them from common business examples, an aspect that makes the direct adaptation of the already established business oriented solutions difficult. In this paper we report the development of an OLAP system for analyzing hospital discharge data and for modeling hospital length of stay

Topics: UOW3
Publisher: IEEE
OAI identifier:
Provided by: WestminsterResearch

Suggested articles


  1. (2001). A conceptual model and algebra for on-line analytical processing in decision support databases,"
  2. (1998). A Simulation Modelling Approach to Evaluating Length of Stay, Occupancy, Emptiness and Bed Blocking in a Hospital Geriatric Department,"
  3. (2001). A simulation study ofthe winter bed crisis,"
  4. (1999). A survey of logical models for OLAP databases,"
  5. (1991). Balancing acute and long term care: the mathematics of throughput in departments of geriatric medicine,"
  6. (1996). Building the Data Warehouse.
  7. (2001). Case study: how to apply data mining techniques in a healthcare data warehouse,"
  8. (1998). CATCH/IT: A Data Warehouse to Support Comprehensive Assessment for Tracking Community Health," presented at Annual Fall Symposium,
  9. (2003). Conditional phase-type distributions for modelling patient length of stay in hospital,"
  10. (2002). Current measures and their defects," in Modelling hospital resource use. a diferent approach to the planning and control of
  11. (2002). Data mining to support simulation modeling of patient flow in hospitals,"
  12. (1997). Data Warehousing and OLAP for Decision Support," presented at
  13. (1998). Data warehousing as a healthcare business solution,"
  14. (1998). Data Warehousing in an Integrated Health System; Building the Business Case," presented at DOLAP '98,
  15. (1997). Enhancing health services management," Health service
  16. (1999). Getting data out of the electronic patient record: critical steps in building a data warehouse for decision support," presented at Annual Symposium,
  17. (2000). Health Management Information Systems. A handbookfor decision makers.
  18. (2001). Healthcare Data Warehousing and Quality Assurance,"
  19. (2000). Hospital Discharge Transactions: A Data Warehouse Component," presented at
  20. (1996). Intelligent Decision Support Methods. The science ofknowledge work.
  21. (2005). Length of Stay-Based Patient Flow Models: Recent Developments and Future Directions,"
  22. (2001). MDXSolutions with Microsoft SQL Server Analysis Services.
  23. (2005). Modelling nationwide hospital length of stay: opening the black box,"
  24. (1999). Multidimensional data modeling for complex data," presented at
  25. (2001). Multidimensional Database Technology,"
  26. (2002). OLAP and OLAP Server Definitions,"
  27. (1999). Outpatient health care statistics data warehouse--implementation,"
  28. (1993). Patterns of length of stay after admission in geriatric medicine: an event history approach,"
  29. Performance management and Operational Research: a marriage made in heaven?,"
  30. (1993). Providing OLAP to User-Analysts. An IT Mandate.
  31. (1998). Research issues in clinical data warehousing," presented at
  32. (2000). Shaping the Future NHS: Long Term Planning for Hospitals and Related Services", Department of Health,
  33. (2002). The Data Warehouse Toolkit.
  34. (1995). The occupancy management and planning system (BOMPS),"
  35. (2001). Toward best practice: leveraging the electronic patient record as a clinical data warehouse,"
  36. (2000). Using data warehousing and OLAP in public health care," presented at Annual Symposium,
  37. (2004). Using online analytical processing to manage emergency department operations,"

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