基于HBase的电动葫芦能测数据管理系统设计

Design of Data Management System for Electric Hoist Energy Efficiency Measurement Based on HBase

摘要: 针对影响电动葫芦能效的因素属于多维关系矩阵，为了便于分析能效数据、建立统计模型以及指定能效分级标准等，本文提出了基于HBase存储多维因素数据的后端数据管理系统设计方案，运用优化配置的MySQL以及Redis分别存储常规数据以及热点数据。本文设计后端系统结合服务化与微服务的优点，采用Spring Boot + MyBatis架构，按功能划分为公共模块子系统(权限、消息、日志、配置、文档等)与业务子系统(架构、任务调度、RPC、部署等)，在保证健全性的同时，使得系统耦合度最低，可扩展性得到保障。最后，后台压力测试、数据库性能测试、HBase性能对比测试的结果展现出了管理系统的优化设计效果，系统可满足不同型号电动葫芦多种测试条件的能效检测的信息管理需求，为能效数据分析提供支持。

Abstract: The factors affecting the energy efficiency of electric hoist belong to the multidimensional relation-ship matrix. For subsequent data analysis, statistical model and energy efficiency grading standard, this paper proposes a web data management system design using HBase to store multi-dimensional factor data. Simultaneously, MySQL and Redis are used to store regular data and hotspot data respectively. Combining the advantages of service and micro-services, the web back-end system in this paper adopts the SSM architecture, and divides the functions into common module subsystems (permissions, messages, logs, configurations, documents, etc.) and business subsystems (architecture, task scheduling, RPC, deployment, etc.). While ensuring soundness, the system coupling degree is the lowest and the scalability is guaranteed. Finally, the results of back-end system stress testing, database performance testing and HBase performance comparison testing show the optimal design effect of the management system. The system can meet the information management requirements of energy efficiency testing of various types of electric hoist in various conditions, and provide support for energy efficiency data analysis.