At present, the data correlation query method in the field of electric power marketing has problems such as low efficiency and low accuracy. This paper improves the Jaro-Winkler character similarity algorithm by combining the editing distance algorithm to improve the matching rate of field names in the data table. Experimental results based on 2,356 data tables show that the improved algorithm is applied to the data table association relationship query, and its accuracy reaches 98%. Based on the improved Jaro-Winkler algorithm and Echarts framework, a visual display system of association relationship of power marketing data table is developed, which provides auxiliary support for business personnel to use data independently and efficiently.
Zong et al. (Thu,) studied this question.