摘要
文章分析了智慧校园数据平台建设过程中应用MPP架构数据库出现的主要问题,然后提出将基于机器学习的数据库自动调优技术OtterTune应用到其中,并针对MPP架构数据库负载刻画不够准确的问题,提出一种新的算法与解决思路,最后对新的算法进行了性能分析,结果显示调优效果提升。
This paper analyzes the main problems in the MPP database applied in the construction of smart campus data platform, then proposes to apply OtterTune which is automatic database tuning technology based on machine learning to the tuning process, and puts forward a new algorithm and solution to the problem that the load characterization of MPP architecture database is not accurate enough. Finally, the performance of the new algorithm is analyzed. The result shows that the tuning effect is promoted.
作者
田浩
TIAN Hao(Liaoning Finance Vocational College,Shenyang,Liaoning,China 110122)
出处
《湖南邮电职业技术学院学报》
2021年第4期26-29,共4页
Journal of Hunan Post and Telecommunication College
基金
辽宁金融职业学院2021年度校级课题“基于大数据技术的决策型智慧校园的设计研究”(课题编号:LJXJ202101)。