Study On Xml Electronic Medical Record System Based On Relational Database

In recent years, XML technology has been widely used in the electronic medical record system, accomplished data sharing between heterogeneous systems, and it has become the standard way to develop EMR systems. Although XML technology has success in solving the problem of description and display in EMR, the problem how to store large and complex medical records has never been solved. Some institutions used file system to store records, others used relational database. In order to meet the complex business needs, the file-stored way must pay a high price to build a professional file management system. However, the relational database itself has powerful transaction processing functions, and has become the first choice to store xml medical record.Using relational database to storing XML data, first of all, have to convert XML hierarchical model into relational model. At present, there are so many studies on this conversion; some are based on the DTD model, some on Schema model, and others even on the XML source data. But they are more or less inadequate. This study proposed a new mapping model, which can achieve conversion of both DTD and Schema: Model for the DTD, in accordance with the conversion table of DTD and Schema, convert DTD into Schema, and then map Schema to the relational database. For Schema model, at first Schema is preprocessed, and then got a Schema model which can no longer be extracted, finally mapped to the relational database. The study aimed at the realization of these two processes to carry out research and its being used into EMR system.Through the studies of storage and conversion from XML data to relation database, we realized the integration of DTD and Schema model, which broken the line between DTD and Schema. To some extent it has solved some incompatible problems that existed in EMR system, provided a reference for relational database based storage EMR System. For the development of Health Care business, it also has a theoretical and practical significance.