Research On Key Technologies Of Building Database For Healthcare And Smart Home

As a necessary product for pursuing high-quality life,health-oriented smart home is becoming more and more popular.However,with the increasing variety of health-oriented smart home device products and the massive and growing data,the demand for the data storage and processing capability of the health-oriented smart home system is becoming more and more urgent.Therefore,this topic designs a database system for health-oriented smart home,which is deployed on the local server and cloud platform server of the home.It not only has higher security,faster data transmission and storage speed,but also has scalability and low cost benefits.A network topology of health-oriented smart home was designed,and data interaction between health-oriented smart home devices and home-side server was realized based on MQTT protocol.Different data frame structures were designed according to the characteristics of different smart home device data,so as to realize the efficient transmission of data from the intelligent device side to the home-side server.In the home-side server,My SQL database was used to construct ER model,thus realizing the orderly storage of data.On the cloud platform,a family cloud server environment was built based on Hadoop components.Sqoop was used to realize the data interaction between My SQL in the family-side server and Hive in the family cloud server.In Hive,the health-oriented smart home data warehouse was designed in layers and dimensionally modeled,and a high-efficiency,secure,automated data extraction,data storage,data calculation and data push method was designed.In this paper,the network topology structure of healthy intelligent home is designed;EMQX is used to realize the data transmission between the intelligent device and the home-side server,and My SQL database is built in the home-side server to complete the data storage function,and the performance test of the database is completed;python,shell and SQL are used,based on Sqoop,Hadoop,Hive and Azkaban technology,to realize the data extraction,data storage,data calculation and data push between the family-side server My SQL and the family cloud server data warehouse.Figure[58] table[25] reference[49]...