Research On Storage And Retrieval Strategy Of Wind Turbine Operation Data Based On Hbase

In recent years,with the rapid development and popularization of wind power technology,the installed capacity of wind power units has been growing rapidly.During the daily operation of wind power units,a large number of production,operation and maintenance data have been deposited.The effective utilization of these data plays a crucial role in improving the generation efficiency and operation and maintenance level of wind power units.Therefore,how to efficiently manage data has become a problem faced by wind turbine operation and maintenance.(1)Aiming at the problems of traditional relational database,such as the time-out of massive data query task,low system performance and poor scalability,this paper designs a database of wind power unit operation data based on distributed database Hbase to realize the rapid storage of massive wind power data.(2)A heat ranking strategy based on heat and time exponential decay and a secondary index mechanism based on heat ranking were designed to solve the problem of low efficiency of wind turbine operation data query caused by Hbase not supporting non-primary key query.On this basis,an Hbase distributed cluster optimization scheme with non-primary key index is proposed,in which the hot data index is established according to the heat ranking strategy with exponential decay,and the second-level index of the heat ranking top-K is stored according to the strategy to improve the query efficiency.The experimental results show that the heat ranking of data is more effective and can improve the hit rate of data access.(3)Finally,based on the strategy proposed in this paper,a wind turbine operation data storage and retrieval system is developed.By comparing the query response time of the two-level index mechanism,it shows that the scheme can improve the query efficiency of Hbase database.