Research on the construction of medical and health data center based on HBase and the synchronization of heterogeneous database

Source: Internet
Author: User
Keywords HBase health care front machine
Tags analysis based data data center data model design health data health information

Research on the construction of medical and health data center based on HBase and the synchronization of heterogeneous database

Fang Shiwei of the

In order to determine the data model, this paper puts forward HBase's c-o-r modeling based on the E-R Modeling Foundation of the relational database, and then comprehensively analyzes the health care metadata Standard and the actual situation of some medical and health institutions, and realizes the HBase data center construction of medical and health information. In order to realize the synchronization of data transparently to data center in heterogeneous relational database of medical institutions, the following schemes are proposed. Firstly, the heterogeneous data produced by heterogeneous database is proposed in the data format to standardize XML and JSON General data format encapsulation to realize the data difference of shielding heterogeneous database; Secondly, the transmission protocol is simple and general, and the design idea of SOA architecture is adopted to realize data synchronous transmission by using Web service method. The method of combining time stamp, trigger and log method in incremental data acquisition of heterogeneous database is put forward, finally, the design of universal front machine is realized to read all heterogeneous database, and the difference configuration of heterogeneous database using XML file is realized. After constructing the HBase center and owning the data, because HBase for the data access only row key localization and the whole table scan two kinds, in order to improve the complex lookup efficiency to propose hbase column index construction. This paper proposes two kinds of index design methods: Using row key advantage and building Index table. In this paper, the construction of Index table is a dual indexing architecture which combines MySQL database with HBase database. Finally, through the simulation test analysis, and compare with the related test performance of MySQL, it is proved that the design method of this paper can better complete the synchronization of the Medical and Health Information Center and the heterogeneous database to the data centre, and realize the health data sharing, supervision and business synergy.


Research on the construction of medical and health data center based on HBase and the synchronization of heterogeneous database

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.