Data warehouse approach to build a decision-support platform for orthopedics based on clinical and academic requirements

Sheng Hui Lin, Yuan Chii G Lee, Chien-Yeh Hsu

Research output: Contribution to journalArticle

6 Citations (Scopus)

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.

Original languageEnglish
Pages (from-to)1-12
Number of pages12
JournalInternational Journal of Bio-Science and Bio-Technology
Volume2
Issue number1
Publication statusPublished - Mar 2010

Fingerprint

Data warehouses
Orthopedics
Databases
Quality Improvement
Accreditation
Personnel
Costs and Cost Analysis
Medical Societies
Hospital Departments
Decision support systems
Costs

ASJC Scopus subject areas

  • Biomedical Engineering
  • Biotechnology
  • Bioengineering
  • Artificial Intelligence

Cite this

@article{c80a15c35e114f0492d4fc93a06c4e9d,
title = "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.",
author = "Lin, {Sheng Hui} and Lee, {Yuan Chii G} and Chien-Yeh Hsu",
year = "2010",
month = "3",
language = "English",
volume = "2",
pages = "1--12",
journal = "International Journal of Bio-Science and Bio-Technology",
issn = "2233-7849",
publisher = "Science and Engineering Research Support Society",
number = "1",

}

TY - JOUR

T1 - Data warehouse approach to build a decision-support platform for orthopedics based on clinical and academic requirements

AU - Lin, Sheng Hui

AU - Lee, Yuan Chii G

AU - Hsu, Chien-Yeh

PY - 2010/3

Y1 - 2010/3

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=79960718919&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=79960718919&partnerID=8YFLogxK

M3 - Article

VL - 2

SP - 1

EP - 12

JO - International Journal of Bio-Science and Bio-Technology

JF - International Journal of Bio-Science and Bio-Technology

SN - 2233-7849

IS - 1

ER -