Data Preprocessing for Building Hospital Data Warehouse

DU Jian-qiang,WU Jun,ZHU Ming-feng,WU You-ping

DOI: https://doi.org/10.3969/j.issn.1005-9431.2008.02.024

2008-01-01

Abstract:This paper reveals some common issues of data preparation for building data warehouse during the practice of medical data warehouse,proposes corresponding solutions and carry on practice.

What problem does this paper attempt to address?

Design and Implementation of Clinical Data Integration and Management System Based on Hadoop Platform

Dao-Ming Lyu,Yu Tian,Yu Wang,Dan-Yang Tong,Wei-Wei Yin,Jing-Song Li

DOI: https://doi.org/10.1109/ITME.2015.86

2015-01-01

Abstract:With the increasing size of the medical data, the traditional processing methods and tools could not meet the requirements. So, resolving the challenges that the big medical data faces, is critical to realizing the promise of the big data [1]. Aiming at the problems in the big data integration process, this paper proposes the clinical data integration and management system based on Hadoop platform. As a result, the system can connect with multiple heterogeneous data source, such as EMR, PACS, LIS and so on. And then, on the basis of the data sharing, it can retrieve the patient's medical records and manage the different information.
Medical Big Data Analysis In Hospital Information System

Jing-Song Li,Yi-Fan Zhang,Yu Tian

DOI: https://doi.org/10.5772/63754

2016-01-01

Abstract:The rapidly increasing medical data generated from hospital information system (HIS) signifies the era of Big Data in the healthcare domain. These data hold great value to the workflow management, patient care and treatment, scientific research, and education in the healthcare industry. However, the complex, distributed, and highly interdisciplinary nature of medical data has underscored the limitations of traditional data analysis capabilities of data accessing, storage, processing, analyzing, distributing, and sharing. New and efficient technologies are becoming necessary to obtain the wealth of information and knowledge underlying medical Big Data. This chapter discusses medical Big Data analysis in HIS, including an introduction to the fundamental concepts, related platforms and technologies of medical Big Data processing, and advanced Big Data processing technologies.
Design and Implementation of Clinical Data Center Based on Hadoop

Hong-lei Zhang,Peng-fei Li,Xin-hang Li,Sheng-qiang Chi,Jing-song Li

DOI: https://doi.org/10.1109/itme.2015.83

2015-01-01

Abstract:This paper considers the actual needs of the hospital for data storage and the characteristics of the Hadoop framework, builds a clinical data center using Hadoop, Hive and so on which are widely used in modern society. This new clinical data center overcomes the shortcomings of traditional Unix servers, meets the hospital demand for data storage and provides Cloud Computing platform. First, this paper describes the current trends of hospital clinical data center. Then the paper describes the design of clinical data center with EMR and PACS and realizes the storage of structured data and unstructured data.
Data mining analysis of inpatient fees in Hospital Information System

Yu Hai-yan,Li Jing-song,Han Xiong,Hu Zhen

DOI: https://doi.org/10.1109/ITIME.2009.5236458

2009-01-01

Abstract:Although data mining and knowledge discovery techniques have been used to clinical medicine frequently, little research has been conducted on hospital decision-making. Decision-making is a crucial part of hospital management, and it goes the whole process of medical behavior. Medical data in hospital information system is always complicated and especial, and this consequently aggravates burden on data analysis. In this paper, we explore how data mining and knowledge discovery can be applied to hospital management, and propose a modified data mining method that is appropriate for mass data in Hospital Information System. We first build a model based on inpatient fees theme, and then analyze it in three aspects: medical insurance fee, department annual fee and fee compositions. The knowledge discovery and analysis is based on Intersystem BI tool DeepSee.
A Study on Building Data Warehouse of Hospital Information System.

Li Ping,Wu Tao,Chen Mu,Zhou Bin,Xu Wei-guo

DOI: https://doi.org/10.3760/cma.j.issn.0366-6999.2011.15.022

2011-01-01

Abstract:Background Existing hospital information systems with simple statistical functions cannot meet current management needs. It is well known that hospital resources are distributed with private property rights among hospitals, such as in the case of the regional coordination of medical services. In this study, to integrate and make full use of medical data effectively, we propose a data warehouse modeling method for the hospital information system. The method can also be employed for a distributed-hospital medical service system.Methods To ensure that hospital information supports the diverse needs of health care, the framework of the hospital information system has three layers: datacenter layer, system-function layer, and user-interface layer. This paper discusses the role of a data warehouse management system in handling hospital information from the establishment of the data theme to the design of a data model to the establishment of a data warehouse. Online analytical processing tools assist user-friendly multidimensional analysis from a number of different angles to extract the required data and information.Results Use of the data warehouse improves online analytical processing and mitigates deficiencies in the decision support system. The hospital information system based on a data warehouse effectively employs statistical analysis and data mining technology to handle massive quantities of historical data, and summarizes from clinical and hospital information for decision making.Conclusions This paper proposes the use of a data warehouse for a hospital information system, specifically a data warehouse for the theme of hospital information to determine latitude, modeling and so on. The processing of patient information is given as an example that demonstrates the usefulness of this method in the case of hospital information management. Data warehouse technology is an evolving technology, and more and more decision support information extracted by data mining and with decision-making technology is required for further research. Chin Med J 2011;124(15): 2372-2377
Practice of Medical Information Systems Integration

Li Haomin,Wang Ning

2005-01-01

Abstract:The idea behind hospital information systems is to make all of a patient's medical reports, lab results, and images electronically available to clinicians, instantaneously, wherever they are, But the higgledy-piggledy evolution of most hospital computer systems makes it hard to integrate all these clinical records. Although several integration standards had been proposed to meet this challenge, none of them is fit for hospitals in China. This paper introduces our work of implementing a three-tiered architecture enterprise viewer in Huzhou Central Hospital to integrate all existing medical information systems using limited resource.
Hospital Operational Data Center: Building and Application

Yu Gang,Chen Lingdong,Zhang Hongbo,Chen Zhujing

DOI: https://doi.org/10.3760/cma.j.issn.1000-6672.2017.03.014

2017-01-01

Abstract:This paper discussed the method and procedure of building a hospital operational data center,and introduced the application of its service with examples.Three aspects discussed in the paper cover the setup of information standard,integration of heterogeneous data resources,and flexible data presentation.Other issues discussed include key challenges and solutions for development of hospital data center systems.Such a platform enables the hospital in a successful standardization and structural management of its clinical data.
A Kind Of Data Warehouse In Community Healthcare Service System

Yan Zhu,Jianli Guo

DOI: https://doi.org/10.1109/ICSSSM.2005.1500230

2005-01-01

Abstract:Chinese health care industry is increasingly becoming a community-based style, it is hoped that the community healthcare service model can efficiently connect hospitals, clinics, pharmacies, and customers for sharing information, reducing administrative costs and improving the quality of care. Thus, the successful community healthcare depends critically on the collection, analysis and seamless exchange of residents, clinical, pharmacies and other utilization health information or knowledge within and across the above organizational boundaries. In this paper, a data warehouse-enabled community health care management system that would help to integrate residents, hospitals, pharmacies and governments in health care was put forward through a common technical architecture. According to the characteristics of different roles, a subject-oriented information share model is also discussed. Hence, the objective of this research is to present and describe. the community healthcare service system in China, the technical infrastructure of data warehouse, and the decision support architecture for such a health care management system. The research findings would immensely help the development of health care community in China, and improve the healthcare service quality from the point of view of residents.
DESIGN AND IMPLEMENTATION OF A MEDICAL INSURANCE FUND RISK PREVENTION AND CONTROL DATA WAREHOUSE

Qin Delin,Wang Airong,Chen Cheng,Lin Zhijie,Xiong Yun,Zhu Yangyong

DOI: https://doi.org/10.3969/j.issn.1000-386X.2011.07.022

2011-01-01

Abstract:The Shanghai medical insurance infrastructure is almost completed which is now covering all business sectors and has accumulated rich historical data.However due to the insufficient planning of database design in the past,the data resources are not fully utilised.Therefore it is incapable of providing efficient decision making support.Since the core of decision making support is the data warehouse,we have built a medical insurance fund risk prevention and control data warehouse which is integrated with meta-data management and ETL technology to realise the effective integration of heterogeneous medical insurance data sources to provide a fine database platform for medical insurance fund risk management.The system is performing well after being applied to Shanghai medical insurance fund risk management.
Analysis of Data Quality Problems in the Digital Hospital and Relevant Solutions

Ting XU

DOI: https://doi.org/10.3969/j.issn.1674-1633.2015.04.043

2015-01-01

Abstract:This paper analyzed the causes for the inconsistency, incompletion and non-standardization of data in the hospital information system. Based on this, a series of measures were taken including establishment of an information quality monitoring system and a data supervision and veriifcation system so as to improve the data quality from the beginning of data input all the way up to each section of the system operation. Moreover, great importance was attached to the utilization of data mining and resources utilization, which provided convenience for better exertion of the advantages of the digital hospital.
Data Cleaning In Data Warehouse: A Survey of Data Pre-processing Techniques and Tools

Muhammad Gufran Khan,Nosheen Nazir,Anosh Fatima

DOI: https://doi.org/10.5815/IJITCS.2017.03.06

2017-03-08

Abstract:A Data Warehouse is a computer system designed for storing and analyzing an organization's historical data from day-to-day operations in Online Transaction Processing System (OLTP). Usually, an organization summarizes and copies information from its operational systems to the data warehouse on a regular schedule and management performs complex queries and analysis on the information without slowing down the operational systems. Data need to be pre-processed to improve quality of data, before storing into data warehouse. This survey paper presents data cleaning problems and the approaches in use currently for preprocessing. To determine which technique of preprocessing is best in what scenario to improve the performance of Data Warehouse is main goal of this paper. Many techniques have been analyzed for data cleansing, using certain evaluation attributes and tested on different kind of data sets. Data quality tools such as YALE, ALTERYX, and WEKA have been used for conclusive results to ready the data in data warehouse and ensure that only cleaned data populates the warehouse, thus enhancing usability of the warehouse. Results of paper can be useful in many future activities like cleansing, standardizing, correction, matching and transformation. This research can help in data auditing and pattern detection in the data.

Computer Science
Selection of data mart in the application of medical data warehouse to hospital

Zhi-min LIU,Jun DONG,Xiu-tang CAO

DOI: https://doi.org/10.3969/j.issn.1003-8868.2005.08.017

2005-01-01

Abstract:With the application of HIS in hospital,a great deal of data accumulate in database.It's very important to take advantage of these data for IT and managerial staffs.It is suggested that data mart be selected to process the data at the initial stage.
Development of a Clinical Data Warehouse for Hospital Infection Control

Mary F. Wisniewski,Piotr Kieszkowski,Brandon M. Zagorski,William E. Trick,Michael Sommers,Robert A. Weinstein

DOI: https://doi.org/10.1197/jamia.m1299

2003-09-01

Journal of the American Medical Informatics Association

Abstract:Existing data stored in a hospital's transactional servers have enormous potential to improve performance measurement and health care quality. Accessing, organizing, and using these data to support research and quality improvement projects are evolving challenges for hospital systems. The authors report development of a clinical data warehouse that they created by importing data from the information systems of three affiliated public hospitals. They describe their methodology; difficulties encountered; responses from administrators, computer specialists, and clinicians; and the steps taken to capture and store patient-level data. The authors provide examples of their use of the clinical data warehouse to monitor antimicrobial resistance, to measure antimicrobial use, to detect hospital-acquired bloodstream infections, to measure the cost of infections, and to detect antimicrobial prescribing errors. In addition, they estimate the amount of time and money saved and the increased precision achieved through the practical application of the data warehouse.

information science & library science,computer science, information systems, interdisciplinary applications,health care sciences & services,medical informatics
Constructing Ideas Of Chronic Disease Prevention Control Data Warehouse System And Data Mining

Min Hu,Zhu-Guo Yu,Michael Lawo,Dong-Yi Chen,Fu-Ji Ren

2015-01-01

Abstract:Based on the research of HealthWear@AAL and related projects, this paper presents the idea of constructing a data warehouse system of chronic diseases prevention and control. Based on the idea of "preparing-monitoring-treating-forecasting" process and closed-loop service, this system's purposes include: (1) Building a data warehouse by using the Intermediate Database Components (IDC) to provide a powerful support platform for all kinds of data storage, conversion, and analyze application for HealthWear@AAL project and other institutions. (2) Applying OLAP and multidimensional data analyses technology to real-time supervise patient disease status and realize disease prevention and control. (3) Providing technical means for decision maker and researcher to make strategy of the disease prevention and health promotion by using data mining and depth analysis technology
Medical Big Data Warehouse: Architecture and System Design, a Case Study: Improving Healthcare Resources Distribution

Abderrazak Sebaa,Fatima Chikh,Amina Nouicer,AbdelKamel Tari

DOI: https://doi.org/10.1007/s10916-018-0894-9

IF: 4.92

2018-02-19

Journal of Medical Systems

Abstract:The huge increases in medical devices and clinical applications which generate enormous data have raised a big issue in managing, processing, and mining this massive amount of data. Indeed, traditional data warehousing frameworks can not be effective when managing the volume, variety, and velocity of current medical applications. As a result, several data warehouses face many issues over medical data and many challenges need to be addressed. New solutions have emerged and Hadoop is one of the best examples, it can be used to process these streams of medical data. However, without an efficient system design and architecture, these performances will not be significant and valuable for medical managers. In this paper, we provide a short review of the literature about research issues of traditional data warehouses and we present some important Hadoop-based data warehouses. In addition, a Hadoop-based architecture and a conceptual data model for designing medical Big Data warehouse are given. In our case study, we provide implementation detail of big data warehouse based on the proposed architecture and data model in the Apache Hadoop platform to ensure an optimal allocation of health resources.

health care sciences & services,medical informatics
Research of data warehouse established methods based on civil aviation medicine certification management information system

Yuan Cao,Qianfeng Liu,Zheng Zheng,Hong Su

DOI: https://doi.org/10.1109/ICBBT.2010.5479011

2010-01-01

Abstract:Since 5 years ago, civil aviation medicine certification management information system (CAMC system) has been applied in China. As relative dataset increases rapidly, data mining techniques become more and more important. A significant initial step toward the most effective mining is the development of civil aviation medicine data warehouse which integrates data from CAMC system and other sources into separated, fully integrated databases. This paper introduces the process of building the Civil Aviation Medicine Data Warehouse (CAM DW) which allows the investigation of potential flight safety-related issues, by integrating multiple databases and documents. According to the analysis of actual requirement, by analyzing the structure of the data sources, we provide the model of data warehouse and determine disease subject snowflake schema. We also describe the implementation strategy and methods of data extraction, transformation and loading. Finally, the future work and challenges are pointed out.
Study on the Data Warehouse of Pharmaceutical Information and Information Application

董军,刘志敏,李莉,曹秀堂,高筠,代伟,郝璐,王伟

DOI: https://doi.org/10.3969/j.issn.1672-8157.2004.01.014

2004-01-01

Abstract:Objective: To find out an advanced method on medicine management and pharmaceutical information management in hospital, so as to strengthen the pharmaceutical management and information application.Methods: Use computer network techniques, statistical methods and the Data Warehouse techniques. Results: Set up a multidimensional model of pharmaceutical information the Data Warehouse. Illustrate pharmaceutical information with BrioQuery software, make medicine check up, inquiry, statistics, analysis and data development online. Construct pharmaceutical information application framework, including: pharmaceutical management information, medicine application and components analysis and DDDs, and the information of pharmaceutical expenditure, rational medicine usage, pharmaceutical economy and pharmaceutical prediction analysis etc.Conclusion: Pharmaceutical information warehouse is an effective method in pharmaceutical management and pharmaceutical information application in hospital.
Implementing intelligent predictive models for patient disease risk in cloud data warehousing

Yadong Shi,Jiaqiang Yuan,Peiyuan Yang,Yufu Wang,Zhou Chen

DOI: https://doi.org/10.54254/2755-2721/67/2024ma0059

2024-05-31

Abstract:A data warehouse, which stores data after it has been extracted, processed, and organized into files and folders, is a cloud data warehousing solution for storing structured data from one or more sources. When data is stored in an organized format within files and folders, it becomes easily accessible and facilitates strategic, data-driven decision-making. This paper introduces the importance of cloud data warehousing in medical information management and discusses its application in a disease prediction model. By analyzing medical data and constructing predictive models, it can assist medical decision-makers in taking timely actions to enhance the quality and efficiency of medical services, providing patients with more personalized treatment plans.
Constructing a Traditional Chinese Medicine Data Warehouse Application

Wing-Kit Sunny Lam,Tony Sahama,Randike Gajanayake

DOI: https://doi.org/10.48550/arXiv.1606.02507

2016-06-08

Computers and Society

Abstract:The explosive growth in the development of Traditional Chinese Medicine (TCM) has resulted in the continued increase in clinical and research data. The lack of standardised terminology, flaws in data quality planning and management of TCM informatics are preventing clinical decision-making, drug discovery and education. This paper argues that the introduction of data warehousing technologies to enhance the effectiveness and durability in TCM is paramount. To showcase the role of data warehousing in the improvement of TCM, this paper presents a practical model for data warehousing with detailed explanation, which is based on the structured electronic records, for TCM clinical researches and medical knowledge discovery.
Managing data quality in an existing medical data warehouse using business intelligence technologies

Scott Eaton,Michael Ostrander,Jennifer Santangelo,Jyoti Kamal

2008-11-06

Abstract:The Ohio State University Medical Center (OSUMC) Information Warehouse (IW) is a comprehensive data warehousing facility that provides providing data integration, management, mining, training, and development services to a diversity of customers across the clinical, education, and research sectors of the OSUMC. Providing accurate and complete data is a must for these purposes. In order to monitor the data quality of targeted data sets, an online scorecard has been developed to allow visualization of the critical measures of data quality in the Information Warehouse.

Data Preprocessing for Building Hospital Data Warehouse

Design and Implementation of Clinical Data Integration and Management System Based on Hadoop Platform

Medical Big Data Analysis In Hospital Information System

Design and Implementation of Clinical Data Center Based on Hadoop

Data mining analysis of inpatient fees in Hospital Information System

A Study on Building Data Warehouse of Hospital Information System.

Practice of Medical Information Systems Integration

Hospital Operational Data Center: Building and Application

A Kind Of Data Warehouse In Community Healthcare Service System

DESIGN AND IMPLEMENTATION OF A MEDICAL INSURANCE FUND RISK PREVENTION AND CONTROL DATA WAREHOUSE

Analysis of Data Quality Problems in the Digital Hospital and Relevant Solutions

Data Cleaning In Data Warehouse: A Survey of Data Pre-processing Techniques and Tools

Selection of data mart in the application of medical data warehouse to hospital

Development of a Clinical Data Warehouse for Hospital Infection Control

Constructing Ideas Of Chronic Disease Prevention Control Data Warehouse System And Data Mining

Medical Big Data Warehouse: Architecture and System Design, a Case Study: Improving Healthcare Resources Distribution

Research of data warehouse established methods based on civil aviation medicine certification management information system

Study on the Data Warehouse of Pharmaceutical Information and Information Application

Implementing intelligent predictive models for patient disease risk in cloud data warehousing

Constructing a Traditional Chinese Medicine Data Warehouse Application

Managing data quality in an existing medical data warehouse using business intelligence technologies