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

Lin, Sheng Hui; Lee, Yuan-Chii Gladys; Hsu, Chien‐Yeh

doi:10.1007/978-3-642-10616-3_13

Cited by 5 publications

(3 citation statements)

References 3 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Some models are designed for specific subject areas, such as oncology 10,22 and orthopedics. 23 Others are intended for bioinformatics purposes or decision support tools, such as the clinical research chart in the integrating biology and the bedside system (i2b2). 9,24 Each design has unique benefits and drawbacks.…”

Section: Discussionmentioning

confidence: 99%

Building a Diabetes Screening Population Data Repository Using Electronic Medical Records

Tuan

Sheehy

Smith

2011

J Diabetes Sci Technol

View full text Add to dashboard Cite

There has been a rapid advancement of information technology in the area of clinical and population health data management since 2000. However, with the fast growth of electronic medical records (EMRs) and the increasing complexity of information systems, it has become challenging for researchers to effectively access, locate, extract, and analyze information critical to their research. This article introduces an outpatient encounter data framework designed to construct an EMR-based population data repository for diabetes screening research. The outpatient encounter data framework is developed on a hybrid data structure of entity-attribute-value models, dimensional models, and relational models. This design preserves a small number of subject-specific tables essential to key clinical constructs in the data repository. It enables atomic information to be maintained in a transparent and meaningful way to researchers and health care practitioners who need to access data and still achieve the same performance level as conventional data warehouse models. A six-layer information processing strategy is developed to extract and transform EMRs to the research data repository. The data structure also complies with both Health Insurance Portability and Accountability Act regulations and the institutional review board's requirements. Although developed for diabetes screening research, the design of the outpatient encounter data framework is suitable for other types of health service research. It may also provide organizations a tool to improve health care quality and efficiency, consistent with the "meaningful use" objectives of the Health Information Technology for Economic and Clinical Health Act.

show abstract

Section: Discussionmentioning

confidence: 99%

Building a Diabetes Screening Population Data Repository Using Electronic Medical Records

Tuan

Sheehy

Smith

2011

J Diabetes Sci Technol

View full text Add to dashboard Cite

show abstract

“…Para pengguna sistem ini akan menganggap sistem yang jauh lebih efektif daripada database konvensional yang hanya menyimpan data pasien saja. Penelitian ini dapat berguna sebagai salah satu pilihan untuk meng-upgrade sistem dari database konvensional menjadi database khusus dan sebuah langkah maju untuk tujuan dari peningkatan kualitas kepada pasien secara berkelanjutan dimana data yang diperoleh dapat dengan mudah dianalisis sehingga pengguna dari sistem ini dapat segera mengambil keputusan terhadap masalah pasien ortopedi [3].…”

Section: Pendahuluanunclassified

Proses Extraction, Transformation, and Loading Pada Pemodelan Data Warehouse Po. Sumber Alam Kutoarjo

Wijaya

Sugiarto

2017

JUTEI

View full text Add to dashboard Cite

Abstract-Information technology used by most companies otobus in warehousing systems that manage all the information of spare parts buses. Data from recording activity at the warehouse of spare parts PO. Sumber Alam from year to year will continue to grow. Transaction data must be transferred to a data warehouse using extraction, transformation, and loading data that can process a variety of data into one unified system. The design of the PO. Sumber Alam data warehouse model is using the star schema approach. This approach has one fact table contained in the center of a star with several dimension tables surrounding it. Formed from the fact table data warehouse design in the barn of PO. Sumber Alam which is a transaction request spare parts from the garage to the barn to the needs of the bus fleet improvements.Intisari-Teknologi informasi dimanfaatkan oleh sebagian besar perusahaan otobus dalam sistem pergudangan yang mengatur segala informasi suku cadang bus. Data dari kegiatan pencatatan suku cadang di bagian gudang PO. Sumber Alam dari tahun ke tahun akan terus bertambah. Data-data transaksi tersebut harus dipindahkan ke sebuah data warehouse melalui proses ekstraksi, transformasi, dan load data yang dapat mengolah berbagai data menjadi satu kesatuan sistem. Perancangan model data warehouse pada PO. Sumber Alam ini menggunakan pendekatan star schema. Pendekatan ini memiliki satu tabel fakta yang terdapat di pusat bintang dengan beberapa tabel dimensi yang mengelilinginya. Tabel fakta yang terbentuk dari perancangan data warehouse di bagian gudang PO. Sumber Alam yang merupakan transaksi permintaan suku cadang dari bagian bengkel ke bagian gudang guna kebutuhan perbaikan armada bus.

show abstract

“…Medical institutions are required to store electronic records in a database and provide access for doctors and researchers. Digital records [ 1 , 2 ] provide convenience, but such a system also introduces the new challenge of storing personal information securely. The issue of privacy [ 3 ] has received much public attention recently.…”

Section: Introductionmentioning

confidence: 99%

A Privacy-Preserved Analytical Method for eHealth Database with Minimized Information Loss

Chen

Cheng

Chen

et al. 2012

Journal of Biomedicine and Biotechnology

View full text Add to dashboard Cite

Digitizing medical information is an emerging trend that employs information and communication technology (ICT) to manage health records, diagnostic reports, and other medical data more effectively, in order to improve the overall quality of medical services. However, medical information is highly confidential and involves private information, even legitimate access to data raises privacy concerns. Medical records provide health information on an as-needed basis for diagnosis and treatment, and the information is also important for medical research and other health management applications. Traditional privacy risk management systems have focused on reducing reidentification risk, and they do not consider information loss. In addition, such systems cannot identify and isolate data that carries high risk of privacy violations. This paper proposes the Hiatus Tailor (HT) system, which ensures low re-identification risk for medical records, while providing more authenticated information to database users and identifying high-risk data in the database for better system management. The experimental results demonstrate that the HT system achieves much lower information loss than traditional risk management methods, with the same risk of re-identification.

show abstract

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.

Cited by 5 publications

References 3 publications

Building a Diabetes Screening Population Data Repository Using Electronic Medical Records

Building a Diabetes Screening Population Data Repository Using Electronic Medical Records

Proses Extraction, Transformation, and Loading Pada Pemodelan Data Warehouse Po. Sumber Alam Kutoarjo

A Privacy-Preserved Analytical Method for eHealth Database with Minimized Information Loss

Contact Info

Product

Resources

About