ABSTRACT
BACKGROUND: The increasing use of electronic medical record (EMR) systems for documenting clinical medical data has led to EMR data being increasingly accessed for clinical trials. In this study, a database of patients who were prescribed statins for the first time was developed using EMR data. A clinical data mart (CDM) was developed for cohort study researchers. METHODS: Seoul St. Mary's Hospital implemented a clinical data warehouse (CDW) of data for ~2.8 million patients, 47 million prescription events, and laboratory results for 150 million cases. We developed a research database from a subset of the data on the basis of a study protocol. Data for patients who were prescribed a statin for the first time (between the period from January 1, 2009 to December 31, 2015), including personal data, laboratory data, diagnoses, and medications, were extracted. RESULTS: We extracted initial clinical data of statin from a CDW that was established to support clinical studies; the data was refined through a data quality management process. Data for 21,368 patients who were prescribed statins for the first time were extracted. We extracted data every 3 months for a period of 1 year. A total of 17 different statins were extracted. It was found that statins were first prescribed by the endocrinology department in most cases (69%, 14,865/21,368). CONCLUSION: Study researchers can use our CDM for statins. Our EMR data for statins is useful for investigating the effectiveness of treatments and exploring new information on statins. Using EMR is advantageous for compiling an adequate study cohort in a short period.
Subject(s)
Humans , Cohort Studies , Data Accuracy , Diagnosis , Electronic Health Records , Endocrinology , Hydroxymethylglutaryl-CoA Reductase Inhibitors , Oxidoreductases , Prescriptions , SeoulABSTRACT
O objetivo deste trabalho é apresentar os passos necessários para a construção de data marts / data warehouses como uma solução para um ambiente de suporte à decisão. Seu foco não é, entretanto, o aprofundamento de cada uma das etapas deste método (uma vez que existe uma ampla literatura sobre o assunto), mas realçar a importância do envolvimento do usuário aqui denominado consumidor da informação durante o processo de criação e manutenção destes data marts / data warehouses. O consumidor da informação é chamado a participar de um plano integrado com os membros das áreas detentoras do conhecimento necessário para a construção destas soluções de suporte à decisão, incluindo a área de tecnologia da informação. A disseminação das informações contidas nestes bancos de dados para os diversos tipos de consumidores da informação (com diferentes recursos de hardware, software e humanos disponíveis), e sua aplicação no controle social, também são discutidas aqui.
The purpose of this work is to present the required steps for the construction of data marts / data warehouses as a solution for a decision support environment. However, its focus is not to go deeper in each of the steps of this method (since there is a broadliterature about the subject), but to highlight the importance of the user here called information consumer engagement during the process of creating and maintaining these data marts / data warehouses. The information consumer is called to take part in an integrated plan together with the members of the areas who own the necessary knowledge to build these decision support solutions, including the information technology (IT) area. The spread of the informations contained in these databases to the different types of information consumers (with different hardware, software and humanresources available), and its application in social control, is also discussed here.
Subject(s)
Health Management , Information Dissemination , Information Technology , Software , Information Systems , Software ValidationABSTRACT
Objective To research and design a system of data integrated warehouse oriented to HIS. Methods The system was constructed by developing special data integrated warehouse, data integrated mart, XML(SQL) interface of script, etc. Results The anticipated result was achieved by applying the system architecture. Conclusion It is feasible to construct the system with special intelligent modular kits comprising data integrated warehouse, data integrated mart, and so on. The system is suitable for medical data mining and processing oriented to HIS.
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.
ABSTRACT
OBJECTIVE: A purpose of this study was developing the Decision-Support Patient affairs management and building of Data-mart for individually specified department. Because it had a OLTP system where we were researching the hospital. It can not be analyzied variously because the data for the management, accounts, patient affairs and medical record were changing monthly/annually in conditions. also it can not have the specificity of the hospital management information. METHODS: The Data Set that used for analysis process was examined with the patient's Database for a year. They were in hospital where locates in Sun Cheon. For developing patient affairs management program, The Microsoft Visual Basic 6.0 was used. and A analysis method of ROLAP which is based on Oracle relation Database was used for general analysis of required works. RESULTS: The patient affairs Data-mart and Decision-Support System was built with the main results of the study. Those took advantage of the analysis for the each department's revenue and doctor's actual results, it also can compare the patient's hospital using frequency. With the analyzied results, each department can have their own special marketing. They can offer to the resistants a lecture, consultant and free service for the health. CONCLUSION: The management, the accounts, patient affairs and the medical record can have been analyzied various changing through the study. The host System had enormous volume, so it takes lots of times what they want to inquire. The host system usually took at night because of low transaction occurrence. The new system which was built with Data-mart had been improved the problem a lot.