| In the field of coal chemical industry,a large number of coal data will be produced along with the mining,processing and use of coal resources by the coal chemical enterprises around the country.Some processing work like data cleaning can effectively improve the quality of data.Besides,the data visualization can show the regularity of the coal quality data in the map and timing characteristics more directly.Based on these,a data system is designed and developed.This paper focuses on the research of two aspects:data cleaning and data visualization.In the data cleaning part,for one thing,the system will clean the "dirty data" which may occur through the bulk upload by means of human-computer interaction.For another,preprocessing like duplicate data cleaning will be done before data visualization.Through the duplicate data cleaning,duplicate data will be recorded and cleaned combined with the field matching algorithm and the database-level improved "Basic Sorted-Neighborhood Method"(SNM)algorithm.In the data visualization part,there are two things to achieve.One thing is cartographic visualization,which shows the result of coal sample data retrieval through both of list and map by the API interface of Baidu map.Another thing is the visualization of time series data,which needs to show the changes of different kinds of coal prices and content of coal sample in different time series through the multi-map linkage display of double line charts.On the basis of the above research,one "coal data processing and visualization system" is designed in this paper.which achieve some basic function modules like data management,user group management,enterprise management and so on.It can effectively integrate and utilize the coal quality data,and extract more useful information from the visualization of coal quality data. |