Analysis of Real-time Database Test Points

In the power industry, real-time databases are widely used in power generation (especially thermal power generation), transmission, and distribution, providing basic support for data acquisition, storage, monitoring, and analysis. This article mainly discusses the selection and test of real-time database of power grids for transmission and distribution links. It involves the collection, storage, query, and analysis of power grid data.

According to the characteristics of grid power data labels, large data throughput, and high stability and reliability requirements of the system, the test points for real-time databases include the following aspects:

1) The maximum number of tag points supported by the system: The maximum number of tag points supported by the real-time database determines the application scope and capabilities of the database.

2) Data writing speed: Because the data acquisition has periodicity, the data must be written in an acquisition cycle to ensure that the data will not be lost, and the data write speed also determines the database throughput.

3) Data query time: including real-time data query response time and history section query response time. The real-time data query response time mainly examines the response time for querying the real-time value of single/multiple tabs; the historical section query response time mainly examines the response time for querying the historical value of single/multiple tabs at a certain time.

4) Abnormal situation processing capability: In the data collection process, you may encounter abnormal situations such as network interruption and database service stop, but you must ensure that the collected data is not damaged or lost. Once the network and database are restored, it can be stored in the database normally. Without affecting the collection of real-time data.

5) Stability and reliability of the database: Under normal circumstances, data collection is periodically written at a certain frequency. In order for the data to be correctly stored in the database, it must be ensured that the database does not stop running continuously. Therefore, the database is required to be stable and reliable.

Based on the above analysis, in addition to functionality, the real-time database testing also needs to focus on its performance, reliability, and stability.