Currently the power quality monitoring data have exhibited a massiveness tendency. If the data are stored in the relational database
problems such as large storage space
low query access speed and poor scalability will be caused. By analyzing the data access characteristics and hardware environment of the power quality monitoring system
this paper proposes a data management scheme for massive power quality monitoring data based on the distributed file system. The monitoring data of different power quality indices are stored in the compressed files; the heterogeneous distributed servers of the existing monitoring sub stations and related systems are used as file servers to store the original monitoring data files
the server of the monitoring master station is used as master server for storing data characteristic value and file indexes
it is also used for unified management of file resources. The scheme takes full advantage of each server’s storage space and network bandwidth
and saves the storage space and improves the access speed. It also has high reliability and scalability. For example
when the 180 days’ data from 100 monitoring sites are stored
the storage space of this scheme is only 2.28% of the traditional scheme; and when the 180 days’ three phase voltage root mean square (RMS) value data of a certain order harmonic are queried
this scheme’s acceleration ratio is about 16.49. The reliability and practicality of this scheme are proved through application in the Sichuan power quality integrated data platform.