2010 Volume 11 Issue 1 Pages 36-40
Since around the year 2000, large hospitals started introducing electronic medical record (EMR) systems. Because of time passed and an increase of data volume, time has come to renew and upgrade the operation systems (OP). Issues related to the renewal are how to transfer the data from the old to the new system and how to change to a new customized system.
For this study, we conducted a system replacement between different venders and successfully transferred all EMR data accumulated over the past seven years (about 100 million records). With this method, the XML output (including attributes) was obtained from the old RDBMS EMR, re-converted, transferred to, and stored in the new system (XML document, DWH type data base system). This new data base system is independent from its ordering system. It stores all the generated fixed data for a long time. Traverse type access is used, so the increase of data does not deteriorate responses.
First the data transfer caused many issues. There was missing and damaged data, conversion processing, the transfer period and system downtime, verification of transfer data, the bearing of expenses, the project management, standardization for the future, and others. But finally, the system replacement and its data transfer created a new flawless information system, which facilitates standardization throughout the hospital.
