Contruction Method Of The Clinical Medical Data Warehouse Based On OpenEHR

Complexity and continuous evolution of healthcare information is the biggest challenge for healthcare information systems, two-level information model from openEHR can facilitate healthcare information systems to adapt to the change of healthcare information requirements. But the medical information system based on openEHR two-level modeling displays low performance when faced with the particular operational demand which includes a large number of data query and complex and mutative query conditions, this is mainly related to the fundamental data storage model. The multidimensional data model of data warehouse has the advantage of high-performance query, the data mart that is established for fulfilling users’ particular demand can increase the particular query speed. Due to the particularity of the medical information system that based on openEHR two-level modeling, traditional data warehouse construction method makes users’ participation rate lower and is a waste of time and effort. this research proposed the mapping method between template and multidimensional data model of data warehouse based on openEHR two-level modeling to solve this problem, this research achieved the configuration of multidimensional data model by users, and used the mapping path accelerate the implementation of ETL. This research provided one kind of dirigible and scalable data warehouse construction method which truly reflects the user requirements for medical industry. And we validated this method in performance, the results showed that, the data mart which was founded based on this method is much faster than the database which was generated based on openEHR two-level modeling and was almost the same as the data mart that was founded by traditional method.