Search PubMed⌕ Search
Home/Archive/PubMed

PubMed · 11452576

A data mart for operations analysis.

M W Isken·S J Littig·M West
View original source ↗Export metadata ↓

Abstract

In this article we describe the evolution and architecture of a data mart developed to address the modeling and analysis needs of healthcare operations analysts. More specifically, the data mart is used in projects relating to demand analysis, forecasting, capacity planning, and service system design for a healthcare system consisting of a large tertiary care hospital and a smaller community hospital. The primary focus of the mart is on the detailed movement of inpatients through each hospital, although most component data tables include outpatient information such as emergency center visits, surgical cases, cardiac catheterization cases, and short-stay visits. We show that the data mart goes well beyond consolidating data from different sources by including a number of complex, precalculated fields, data structures, and function libraries that are specific to the needs of operations analysts. We discuss several outstanding and challenging design issues that should be of interest to the data warehouse vendor community.

Explore related subjects

Bed OccupancyDatabase Management SystemsDecision Support Systems, ManagementHealth Services Needs and DemandHospital PlanningHumansInformation CentersMichiganMulti-Institutional SystemsOperations ResearchOrganizational Case StudiesSoftwareJournal Article

Keep this discovery

Explore connections, maps & timelines

BibTeXRIS

M W Isken, S J Littig, M West. 2001. A data mart for operations analysis.. https://pubmed.ncbi.nlm.nih.gov/11452576/

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related citations

PubMed2002

[Patient referral and patient volume in a regional hospital].

BACKGROUND: A general trend in health care is the increasing discrepancy between resources available and the volume of patients treated. Few studies have looked at a reduction in patient referral as a possible explanation for this situation. MATERIAL AND METHODS: The volume of hospital admissions and outpatient care 1996 through 2000 at a large regional hospital was related to the number of referrals over the same period. RESULTS: There was an overall increase in patient admissions as well as in outpatient care during the study period. However, while the number of new referrals seen as outpatients dropped by 1.2%, the number of patients in for controls increased by 27.1%. While some departments had an increase in both admissions and new outpatients, other departments had a dramatic decrease in new patient contacts but total patient volume was maintained by a comparable increase in control consultations. At the same time, there was a 15.1% overall drop in new patient referrals (new referrals for admissions down 44.4%, new referrals for outpatient care down 11.4%), in some departments even more. INTERPRETATION: The study shows that patient demand for hospital care is not unlimited and should also be considered when more resources allocated to hospitals do not result in increased patient volume.

Bed Occupancy↗
PubMed2002

Randomized clinical trial of no wound drains and early discharge in the treatment of women with breast cancer.

BACKGROUND: Women undergoing surgery for primary breast cancer routinely have suction drains inserted deep to the wounds, which are removed approximately 6-8 days after operation, requiring a period of stay of that duration in hospital. The aim of this study was to perform a prospective randomized clinical trial to evaluate a new surgical technique of suturing flaps without wound drainage, combined with early discharge, in women undergoing surgery for breast cancer. METHODS: A total of 375 patients undergoing surgery for breast cancer were randomized to conventional surgery or suturing of flaps with no drain. The main outcome measures were length of hospital stay, surgical morbidity, psychological morbidity and health economics. RESULTS: Suturing of flaps and avoiding wound drainage in women undergoing surgery for breast cancer resulted in a significantly shorter hospital stay. Adopting this surgical technique with early discharge did not lead to any difference in surgical or psychological morbidity. Health economic benefits to the National Health Service resulted from saved bed days with no impact on community costs. CONCLUSION: Wound drainage following surgery for breast cancer can be avoided, thereby facilitating early discharge with no associated increase in surgical or psychological morbidity.

Bed Occupancy↗