标题：The Selection and Placement Method of Materialized Views on Big Data Platform of Equipment Condition Assessment
作者：Ma, Yan; Yao, Jinxia; Gu, Chao; Chen, Yufeng; Yang, Yi; Zou, Lida
作者机构：[Ma, Yan; Yao, Jinxia; Gu, Chao; Chen, Yufeng; Yang, Yi] State Grid Shandong Elect Power Res Inst, 2000 WangYue Rd, Jinan 250002, Shandong, Peoples R 更多
会议名称：2nd Asia Conference on Power and Electrical Engineering (ACPEE)
会议日期：MAR 24-26, 2017
来源：2017 2ND ASIA CONFERENCE ON POWER AND ELECTRICAL ENGINEERING (ACPEE 2017)
摘要：With the formation of electric big data environment, more and more big data analyses emerge. In the complicated data analysis on equipment condition assessment, there exist many join operations, which are time-consuming. In order to save time, the approach of materialized view is usually used. It places part of common and critical join results on external storage and avoids the frequent join operation. In the paper we propose the methods of selecting and placing materialized views to reduce the query time of electric transmission and transformation equipment, and make the profits of service providers maximal. In selection method we design a computation way for the value of non-leaf node based on MVPP structure chart. In placement method we use relevance weights to place the selected materialized views, which help reduce the network transmission time. Our experiments show that the proposed selection and placement methods have a high throughput and good optimization ability of query time for electric transmission and transformation equipment.