Data Warehouse Approach to Build a Decision-Support Platform for Orthopedics Based on Clinical and Academic Requirements

Abstract

The continuous quality improvement has become a trend in the contemporary medical society, and that can be achieved by the specialty database implement. Decision-support system in the academic and clinical aspects are included in the process such continuous quality improvement. The database has its limitation in the decision-support due to deficiency of on-line analytic function. The data warehouse offers the sophisticated function for decision-support processes. However, the implement of data warehouse may face a lot of obstacles, included expensive cost and large personnel. We had previously established a database of orthopedics, which collected the patients’ data since 2002. The new system was constructed based on this specialty database, the knowledge architectures was build up via specialists committee and accreditation indicators. The major function was to generate sufficient information for decision-support process in the academic and clinical aspects. The execution efficiency of this system is more effective than database. The unique knowledge architecture can form a distinguishing feature of the department. The cost that saved from personnel and time reduced from reports generation for accreditation is remarkable. The stratification of web-based interface application can be assessed through questionnaires; the outcome is satisfactory as what we previously expected. The sophisticate function of the data warehouse is hard to express in a solitary department of the hospital, especially when they had already owned traditional database. The experience of this system construction can be useful as one option for upgrade of specialty database and a step forward to the goal of the continuous quality improvement.