• 한국병원경영학회지
• /
• 제28권3호
• /
• pp.1-14
• /
• 2023

Purposes: It is very important to establish a clinical data warehouse based on a common data model to offset the different data characteristics of each medical institution and for drug surveillance. This study attempted to establish a clinical data warehouse for Dankook university hospital for drug surveillance, and to derive the main items necessary for development. Methodology/Approach: This study extracted the electronic medical record data of Dankook university hospital tracked for 9 years from 2013 (2013.01.01. to 2021.12.31) to build a clinical data warehouse. The extracted data was converted into the Observational Medical Outcomes Partnership Common Data Model (Version 5.4). Data term mapping was performed using the electronic medical record data of Dankook university hospital and the standard term mapping guide. To verify the clinical data warehouse, the use of angiotensin receptor blockers and the incidence of liver toxicity were analyzed, and the results were compared with the analysis of hospital raw data. Findings: This study used a total of 670,933 data from electronic medical records for the Dankook university clinical data warehouse. Excluding the number of overlapping cases among the total number of cases, the target data was mapped into standard terms. Diagnosis (100% of total cases), drug (92.1%), and measurement (94.5%) were standardized. For treatment and surgery, the insurance EDI (electronic data interchange) code was used as it is. Extraction, conversion and loading were completed. R language-based conversion and loading software for the process was developed, and clinical data warehouse construction was completed through data verification. Practical Implications: In this study, a clinical data warehouse for Dankook university hospitals based on a common data model supporting drug surveillance research was established and verified. The results of this study provide guidelines for institutions that want to build a clinical data warehouse in the future by deriving key points necessary for building a clinical data warehouse.

• 한국데이타베이스학회:학술대회논문집
• /
• 한국데이타베이스학회 1999년도 국제컨퍼런스 디지털컨텐츠 활용을 통한 지식경영의 확산
• /
• pp.113-118
• /
• 1999

본 연구는 통합병원정보시스템 (Integrated Hospital Information System) 에서 의료용 데이터 웨어하우스 (Medical Data Warehouse) 부분의 보안 프로토타입 시스템을 메타데이터 기반으로 설계하고 구현하는 데 주안점을 두었다. 특히, 의료용 데이터 웨어하우스 중에서도 임상 데이터 웨어하우스 (Clinical Data Warehouse) 에 초점을 두었으며 이에 대한 프로토타입은 ㅈ 병원에 적용되어서 개발되었다.

• 산업공학
• /
• 제17권4호
• /
• pp.426-439
• /
• 2004

This research discusses knowledge contents needed to build an OLAP system for medical sector, OLAP functionalities from past studies, and a medical intelligence system which is a kind of OLAP. The knowledge requirements which consist of nine contents and OLAP fundamental functionalities are applied to the system. Most past studies have focused on developing a medical data warehouse rather than OLAP. The medical intelligence system supplies health care providers (i.e., doctors, clinicians, researchers and nurses) and non-providers (i.e., managers and business analysts) with multidimensional OLAP functionalities. The system can be used to gain a deeper understanding of specific medical issues. In this research, we focus not on medical data warehouse, but on the technical challenges of designing and implementing an effective medical intelligence system for health care information. An architecture is applied to developing the medical intelligence system for a medical center in order to illustrate its practical usage. Six packages in the developed system are discussed in this research: Explorer, Analyzer, Reporter, Statistician, Visualizer, and Meta Administrator packages. Evaluation of the system and ongoing research directions conclude the research.

• Asia pacific journal of information systems
• /
• 제10권3호
• /
• pp.79-103
• /
• 2000

Data warehouse is an intelligent store of data. A metadata is critical for implementing data warehouse. Integrating data warehouse with its metadata helps create a more adaptive information system. This paper proposes a metadata-oriented data warehouse architecture that consists of seven components: legacy, extracting, operational data store, data warehouse, data mart, application, and metadata. A taxonomy for dataflow and metaflow is proposed for better understanding of the architecture. In addition, a metadata schema is built within the framework of the seven components. Lastly, the architecture with its metadata component is applied to a real-life data warehouse project for a large medical center in order to illustrate its practical usefulness.

• 한국데이타베이스학회:학술대회논문집
• /
• 한국데이타베이스학회 1999년도 춘계공동학술대회: 지식경영과 지식공학
• /
• pp.393-402
• /
• 1999

과거와 다르게 최근의 병원들은 정보화로 인해서 상당한 양의 의료 데이터가 저장되어 있어서 이의 효과적인 이용에 관심을 가지고 있다. 그러나 기존 통합병원정보시스템 (Integrated Hospital Information System)은 아직까지 일반관리와 원무관리 중심에서 벗어나지 못하고 있다. 품질 좋은 의료 서비스를 제공하기 위해서 환자 중심의 진료 및 진료지원, 임상연구 등을 종합적으로 지원하기 위한 데이터 웨어하우스 (Data Warehouse)의 필요성이 대두되기 시작했다. 이에 본 연구는 병원 전체 차원에서 데이터 웨어하우스의 아키텍쳐를 설계하고 개발하는 데 주안점을 두었다. 특히, 임상 데이터 웨어하우스 (Clinical Data Warehouse)에 초점을 두었으며 이에 대한 프로토타입은 J 병원에 적용되어서 개발되었다.

• 한국지능정보시스템학회:학술대회논문집
• /
• 한국지능정보시스템학회 1999년도 춘계공동학술대회-지식경영과 지식공학
• /
• pp.393-402
• /
• 1999

과거와 다르게 최근의 병원들은 정보화로 인해서 상당한 양의 의료 데이터가 저장되어 있어서 이의 효과적인 이용에 관심을 가지고 있다. 그러나 기존 통합병원정보시스템(Integrated Hospital Information System)은 아직까지 일반관리와 원무관리 중에서 벗어나지 못하고 있다. 품질 좋은 의료 서비스를 제공하기 위해서 환자 중심의 진료 및 진료지원, 임상연구 등을 종합적으로 지원하기 위한 데이터 웨어하우스(Data Warehouse)의 필요성이 대두되기 시작했다. 이에 본 연구는 병원 전체 차원에서 데이터 웨어하우스의 아키텍쳐를 설계하고 개발하는 데 주안점을 두었다. 특히, 임상 데이터 웨어하우스(Clinical Data Warehouse)에 초점을 두었으며 이에 대한 프로토타입은 J 병원에 적용되어서 개발되었다.

• 디지털융복합연구
• /
• 제11권8호
• /
• pp.293-302
• /
• 2013

지금까지의 병원의 DW(Data Warehouse)는 주로 원무중심의 데이터를 분석하는 용도로 사용되어 왔다. 하지만, 전자의무기록(Electronic Medical Record) 시스템이 구축되면서 원무중심의 기존의 DW와 달리 진료 기록과 영상 촬영 기록의 판독내용 등의 비정형 데이터도 환자의 진료 및 치료의 중요한 정보를 얻는데 매우 유익하게 활용될 수 있다. 따라서 본 논문에서는 지금까지 병원에서 활용되는 원무 중심의 DW(Medical DW)가 아닌 진료 중심의 DW(Clinical DW)의 구축의 필요성을 제기하였다. 또한 CDW가 실제로 어떤 부분에 어떻게 활용되는 지를 기술하였다. 마지막으로 병원의 실제 진료 데이터를 시소러스(Thesaurus)검색 방법을 사용하여 과거 이력에 따른 연관 상병 간의 상관관계를 도출하여 환자 조기치료의 기반을 마련하고자 한다.

• 한국지능정보시스템학회:학술대회논문집
• /
• 한국지능정보시스템학회 2001년도 The Pacific Aisan Confrence On Intelligent Systems 2001
• /
• pp.448-455
• /
• 2001

Recently, many enterprises have attempted to capitalize knowledge assets on data warehouse (DW). It has been recognized as strategic core process to create corporate competitive advantage and implement enterprise e-biz strategies. However, most approaches to represent knowledge and decision process have limits in considering various knowledge types, their relationships and continuity in knowledge formulation. In addition, they are so inclined to one side such as concept-oriented frameworks or technology-oriented ones. They lack universal and wide-ranging features. This paper presents a comprehensive methodology to accumulate knowledge capital on DW via a properly grained hypermedia model. The methodology consists of three phases: knowledge requirement elicitation, hypermedia modeling, and system implementation. A real-life case for medical DW development is presented to demonstrate the usefulness of the proposed methodology. This methodology is effective when an organization accumulates knowledge assets to put the corporate e-biz or cre-biz strategy into practice.

• 한국직업건강간호학회지
• /
• 제26권3호
• /
• pp.133-141
• /
• 2017

Purpose: The purpose of this study was to identify the relationship between work-related characteristics and job stressors and the factors influencing musculoskeletal symptoms of the warehouse employees. Methods: The research was a cross-sectional, descriptive study. Data were collected from 319 warehouse employees who agreed to participate in the study by using self-report questionnaires. Data were analyzed using descriptive statistics, $x^2-test$, and logistic regression analysis (SPSS 18.0). Results: The overall prevalence of musculoskeletal symptoms was 37.6%. The logistic regression analysis revealed a posture that renders fatigue or pain, repetitive work, and a higher total score of job stressors as the risk factors for musculoskeletal symptoms in many body parts. Conclusion: Employers should plan to educate employees who work in warehouses about the correct working posture to prevent musculoskeletal diseases, stop repetitive work, and manage job stressors.

• International Journal of Fuzzy Logic and Intelligent Systems
• /
• 제14권4호
• /
• pp.268-275
• /
• 2014

In future, hospitals are expected to automatically issue remote transcriptions. Many general hospitals are planning to encrypt their medical database to secure personal information as mandated by law. The electronic medical record system, picture archiving communication system, and the clinical data warehouse, amongst others, are the preferred targets for which stronger security is planned. In the near future, medical systems can be assumed to be automated and connected to remote locations, such as rural areas, and islands. Connecting patients who are in remote locations to medical complexes that are usually based in larger cities requires not only automatic processing, but also a certain amount of security in terms of medical data that is of a sensitive and critical nature. Unauthorized access to patients' transcription data could result in the data being modified, with possible lethal results. Hence, personal and sensitive data on telemedicine and medical information systems should be encrypted to protect patients from these risks. Login passwords, personal identification information, and biological information should similarly be protected in a systematic way. This paper proposes the use of electronic acupuncture with a built-in multi-pad, which has the advantage of being able to establish a patient's physical condition, while simultaneously treating the patient with acupuncture. This system implements a sensing pad, amplifier, a small signal drive circuit, and a digital signal processing system, while the use of a built-in fuzzy technique and a control algorithm have been proposed for performing analyses.