Electric power pumped storage data storage method, device, equipment and medium

By identifying and classifying the type field encoding and unique encoding of power extraction data, data checksum storage is carried out, and the problems of insufficient data quality monitoring and data storage redundancy in the prior art are solved, and efficient and accurate data storage and query are achieved.

CN119645985APending Publication Date: 2025-03-18CHINA ELECTRIC POWER RESEARCH INSTITUTE CO LTD +1
View PDF 0 Cites 1 Cited by

Patent Information

Application Number
CN202411811152.X
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-12-10
Publication Date
2025-03-18

AI Technical Summary

Technical Problem

The prior art fails to effectively monitor data quality during the power data storage process, resulting in the database being contaminated by dirty data and failing to classify and store different data types, resulting in data redundancy and low query efficiency.

Method used

Data classification and verification are performed by identifying the type field encoding and unique encoding from the packets to be stored for power extraction. Perform rationality checksum data null checksum data, generates a unique code for storage, and time partitioning and object partitioning are performed based on the data timestamp and device ID.

Benefits of technology

Effectively monitor and filter low-quality data, avoid database pollution, improve the accuracy and consistency of data storage, reduce redundant fields, and improve data query efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119645985A_ABST
    Figure CN119645985A_ABST
Patent Text Reader

Abstract

The invention belongs to the technical field of power dispatching automation, and particularly relates to a power pumped storage data storage method, device and equipment and a medium. In order to solve the problem of power pumped storage data storage, the method identifies type field codes from a message of to-be-stored power pumped storage data, and classifies the data based on the type field codes. After data classification, each type of data is subjected to rationality verification and data null value verification. The rationality verification ensures that the data accords with expected logic and business rules, and the data null value verification checks whether excessive null values or missing values exist in the data. Through data null value verification and rationality verification, low-quality data can be found and filtered in time, and the problem that a database is polluted by dirty data is avoided.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention belongs to the technical field of electric power dispatching automation, and in particular relates to a method, device, equipment and medium for storing electric power pumped storage data. Background Art

[0002] With the advancement of the construction of new power systems, the demand for digitalization of production and operation is becoming increasingly urgent. At present, the power station side systems of the pumped storage operation and control system come from different sources, involving many control system manufacturers at home and abroad. In the process of sending data to the provincial company operation and control center and the group operation and control center, each power station has data missing and chaotic data storage. In view of the above situation, it is urgent to unify the data collection and storage system, and monitor the data quality during the data collection process. Data with high pass rate will be stored, and data with low pass rate will not be stored, so as to reduce the probability of database being polluted by dirty data, ensure the reliability and credibility of the data, and lay the foundation for reasonable and reliable data for subsequent data analysis.

[0003] Prior art 1 discloses a power data storage system, and the key points of its technical solution are: including a power data collection module, a power data preprocessing module, a power data storage module, a power data management module, a power data early warning module and a power data encryption module; the power data collection module is used to collect power data and transmit the collected power data to the power data preprocessing module in real time; the power data preprocessing module is used to clean the repeated, missing and abnormal data in the power data and transmit it to the power data storage module; the power data storage module is used to store power data, including a cloud storage unit, a database storage unit and a distributed storage unit. The present invention provides a variety of storage methods for power data, and can clean the data to be stored, implement data standardization to improve the accuracy and consistency of the data. 1. This technology only performs a preprocessing step on the power data and then stores it, without verifying the original data itself. There may be a possibility that the data itself is of poor quality, and the data formed after preprocessing is not credible. 2. This technology does not classify and store according to the business characteristics of power data, which will lead to redundant fields when various data are stored, resulting in data confusion and inability to obtain efficiently when querying.

[0004] Prior art 2 discloses a method, device, equipment and medium for storing electric power data, receiving message data sent by a sub-site; determining the data type corresponding to the message data according to the type identifier in the message data; executing the message processing strategy corresponding to the data type according to the data type, obtaining the target data to be stored, and storing the target data in the target time slice of the target data table corresponding to the data type, by executing the corresponding message processing strategy for different types of message data, the stored data can be effectively screened, the validity of the database storage data can be improved, and then the data is stored according to the time slice, effectively ensuring the long-term query efficiency of the data, and providing effective data guarantee for the later data analysis. 1. This technology only distinguishes the data type by message and stores it in the corresponding data table, without verifying the corresponding data, and there will be the problem of low quality of the original data leading to low data availability. 2. This technology parses the message data based on the message processing strategy of the telemetry data, obtains the telemetry address, the first timestamp and the telemetry data value corresponding to the telemetry data; determines the target data table corresponding to the telemetry address according to the telemetry address, and stores the telemetry data value in the time slice corresponding to the first timestamp in the target data table. If each data message is not marked, the data sent from the same telemetry point may overwrite each other, and the data status of each data when it is sent cannot be monitored. Summary of the invention

[0005] The object of the present invention is to provide a method, device, equipment and medium for storing pumped storage power data, so as to at least solve one of the problems of data quality monitoring when collecting pumped storage power data and the problems of different data collection quality and storage.

[0006] In order to achieve the above object, the present invention adopts the following technical solution: In a first aspect, the present invention provides a method for storing pumped storage power data, comprising the following steps: Identify a type field code and a unique code from a message of power pumped storage data to be stored; Classifying the pumped-storage power data to be stored based on the type field code to obtain a category of the pumped-storage power data to be stored; Perform rationality check and data null value check on the classified pumped storage data to be stored; The verified pumped storage data to be stored is stored according to the corresponding category and unique code.

[0007] Optionally, in the step of identifying a type field code and a unique code from a message of the power pumped storage data to be stored, the type field includes a message type field and a data type field.

[0008] Optionally, in the step of identifying the type field code and the unique code from the message of the power pumped storage data to be stored, the unique code is generated in the following manner: The data source code of the power pumped storage data to be stored, the data upload time code, the type field code, the device code and the code assigned by the server itself are converted into hash values ​​to obtain a unique code.

[0009] Optionally, classifying the pumped power data to be stored based on the type field encoding includes: Determine the preliminary classification of the pumped storage power data to be stored according to the message type field; On the basis of the preliminary classification, the secondary classification of the pumped storage power data to be stored is determined according to the data type field.

[0010] Optionally, in the step of performing rationality check and data null value check on the classified pumped storage power data to be stored, the method of data null value check is as follows: Identifying a data null value time point in the power pumped storage data to be stored; The data null value check result is determined according to the proportion of the data null value time point to the above time.

[0011] Optionally, determining the data null value check result according to the proportion of the data null value time point to the above time includes: Calculate the proportion of the data null value time points to the above time; When the ratio is within a preset range, the data null value check passes; When the ratio exceeds a preset range, the data null value check fails.

[0012] Optionally, the verified pumped storage data to be stored is stored according to the corresponding category and unique code, including: Determine the corresponding time partition and object partition according to the timestamp and object code of the data; Prepare corresponding data tables according to the storage partition division results; Insert the parsed and verified data into the data table under the corresponding time partition and object partition.

[0013] In a second aspect of the present invention, there is provided an electric pumped storage data storage device, comprising: An identification module, used to identify a type field code and a unique code from a message of electric power pumped storage data to be stored; A classification module, used for classifying the pumped-storage power data to be stored based on the type field code to obtain the category of the pumped-storage power data to be stored; A verification module, used to perform rationality verification and data null value verification on the classified power pumped storage data to be stored; The storage module is used to store the verified power pumped storage data to be stored according to the corresponding category and unique code.

[0014] According to a third aspect of the present invention, an electronic device is provided, comprising a processor and a memory, wherein the processor is configured to execute a computer program stored in the memory to implement the above-mentioned method for storing pumped storage power data.

[0015] According to a fourth aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores at least one instruction, and when the at least one instruction is executed by a processor, the above-mentioned method for storing pumped storage data is implemented.

[0016] Compared with the prior art, the beneficial effects of the present invention are as follows: In response to the problem of electric power pumped storage data storage, the method of the present invention identifies the type field code from the message of the electric power pumped storage data to be stored, and classifies the data based on the type field code. After the data is classified, the present invention performs a rationality check and a data null value check on each type of data. The rationality check ensures that the data complies with the expected logic and business rules, and the data null value check checks whether there are too many null values ​​or missing values ​​in the data. Through the data null value check and the rationality check, the present invention can promptly discover and filter out low-quality data, avoiding the problem of the database being polluted by dirty data. The electric power pumped storage data storage device, electronic device and computer-readable storage medium provided by the present invention also solve the problems raised in the background technology section.

[0017] The present invention generates a unique code for each piece of power pumped storage data to be stored through hash value conversion, and stores the data according to the code, thereby avoiding the problem of mutual overwriting when the data of the same telemetry point are sent up.

[0018] The present invention classifies and stores different types of data, reduces redundant fields during data storage, and improves data clarity and query efficiency. At the same time, time partitioning and object partitioning storage are performed according to data timestamps and device ID information, further improving the convenience and accuracy of data query. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] The drawings constituting a part of the present application are used to provide a further understanding of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings: Figure 1 This is a flow chart of a method for storing pumped storage data according to an embodiment of the present invention; Figure 2 A schematic diagram of generating a unique code in an embodiment of the present invention; Figure 3This is a flow chart of a method for storing pumped storage data in accordance with another optional embodiment of the present invention; Figure 4 This is a structural block diagram of an electric power pumped storage data storage device according to an embodiment of the present invention; Figure 5 The present invention is a structural block diagram of an electronic device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0020] The present invention will be described in detail below with reference to the accompanying drawings and in combination with embodiments. It should be noted that the embodiments and features in the embodiments of the present application can be combined with each other without conflict.

[0021] The following detailed description is an exemplary description, which is intended to provide further detailed description of the present invention. Unless otherwise specified, all technical terms used in the present invention have the same meaning as those generally understood by those skilled in the art to which the present application belongs. The terms used in the present invention are only for describing specific embodiments, and are not intended to limit exemplary embodiments according to the present invention.

[0022] Example 1 The embodiment of the present invention provides a method for storing pumped storage data, which is aimed at the storage and data quality monitoring of different types of pumped storage data. The data is collected through messages, and data type fields are set in the messages to distinguish different types of data. A storage architecture for massive multi-source heterogeneous data of pumped storage operation and control systems is established in a targeted manner. In the process of data collection, different monitoring rules are set for the data collection quality in combination with the characteristics of different types of data, so as to realize real-time monitoring of massive multi-source heterogeneous data, quickly locate data quality problems, and be able to trace back to the source of the corresponding uploaded data, providing data reference for production and operation data management.

[0023] like Figure 1 As shown, a method for storing electric pumped storage data comprises the following steps: S1. Identify the type field code and the unique code from the message of the power pumped storage data to be stored.

[0024] Specifically, in step S1, the type field includes a message type field and a data type field.

[0025] Specifically, in step S1, the unique code is generated in the following manner: the data source code of the power pumped storage data to be stored, the data upload time code, the type field code, the device code and the code assigned by the server itself are converted into a hash value to obtain a unique code.

[0026] As an example, Figure 2As shown, the 18-bit data source code, the 13-bit data upload timestamp (data upload time code), the 14-bit type field code, the 18-bit device code and the 8-bit code assigned by the server itself are converted into hash values ​​to obtain a unique code.

[0027] When performing hash value conversion, MD5, SHA-256, etc. can be used as hash functions.

[0028] Optionally, the data reception and storage of the present invention is implemented based on a self-designed message, and the data is converted into a corresponding format based on the message when it is sent from the source end to complete the data sending. The message structure is as follows: option java_outer_classname = "BigDataProto"; / / Unified message for this type of data that uses table domain information as the collection information message / / The time field passes a 13-bit timestamp message big_data_info_list{ / / Unique identifier of the message (32-bit UUID) required string uuid = 1; / / Flag, 0--increment; 1--make up move required int32 flag = 2; / / Data source required string data_sourceid = 3; / / Message type meas (measurement), plan (plan), tmr (power), forecast (forecast) required string message_type= 4; / / Data type (optional field, used to distinguish the specific data type in the message) optional string data_type = 5; / / Data frequency, periodic data is specified according to the upload period, non-periodic data is specified as -1 required int32 interval = 6; / / The message contains the start time of the data time, 13-bit timestamp start_time<data time ≤ end_time required int64 start_time = 7; / / The message contains the end time of the data time, 13-bit timestamp required int64 end_time =8; / / Release time (only for prediction data) optional string fore_time= 9; / / Object encoding required string object_id = 10; / / Data set contained in the message repeated data_row data_rows = 11; / / The device or object ID set contained in the message repeated dev_data dd_list = 12; } / / Data row message data_row { / / The date to which the data belongs. 13-bit timestamp, starting from 1970 required int64 x_time = 1; / / Data value collection repeated data_column data_cols = 2; } / / Data value message data_column { / / (starting from 0) The index of the device id corresponding to this value in dd_list required int32 dev_index= 1; / / Data field name (name in the structured table of the big data platform) required string column_name = 2; / / Data field value (if it is a time type value, a 13-bit timestamp is used uniformly) optional string column_value = 3; } / / id information message dev_data { / / Device ID code required string id= 1; / / Spare fields, such as the plant ID to which the equipment belongs optional string st_id = 2; } Among them, various power pumped storage data are jointly judged by the message built-in identifiers message_type and data_type to distinguish different data types, and then the data quality is monitored according to the pre-set data collection monitoring strategy. When monitoring data, different data monitoring rules are designed according to each type of data to monitor the data collection situation.

[0029] For pumped storage measurement type data, that is, when message_type is meas, it is necessary to verify whether the device ID length meets the platform requirements and verify the data continuity in the data value set.

[0030] For plan and forecast data, that is, when message_type is plan or forecast, it is necessary to verify whether the device ID length meets the platform requirements, verify the data continuity in the data value set, and at the same time verify that the data start time (start_time) and data end time (end_time) need to be later than or equal to the release time (fore_time) For power data, that is, when message_type is tmr, it is necessary to verify whether the device ID length meets the platform requirements, and at the same time verify that the value of each time point in the data value set cannot be less than the data value of the previous time point.

[0031] It should be noted that the data message UUID is a unique code obtained by the server by performing hash value conversion on the data source, data upload time, data type code, device code and the code assigned by the server itself when data is sent, and it serves as the unique data identifier of each message.

[0032] S2. Classify the pumped-storage power data to be stored based on the type field code to obtain the category of the pumped-storage power data to be stored.

[0033] Specifically, step S2 specifically includes: S21. Determine the preliminary classification of the pumped storage power data to be stored according to the message type field; S22. Based on the preliminary classification, determine the secondary classification of the pumped storage power data to be stored according to the data type field.

[0034] It should be noted that the message involves the following fields: / / Message type meas (measurement), plan (plan), tmr (power), forecast (forecast) required string message_type= 4; / / Data type (optional field, used to distinguish the specific data type in the message) optional string data_type = 5; Therefore, the category of the pumped storage data with stored power can be determined by combining the message type and data type.

[0035] S3. Perform rationality check and data null value check on the classified pumped storage data to be stored.

[0036] Specifically, in step S3, the method for checking the data null value is as follows: S31, identifying a data null value time point in the power pumped storage data to be stored; S32. Determine the data null value check result according to the proportion of the data null value time point to the above time.

[0037] Specifically, step S32 includes: calculating the proportion of the data null value time point to the above time; when the proportion is within a preset range, the data null value check passes; when the proportion exceeds the preset range, the data null value check fails.

[0038] For example, the preset range can be set to 5% (the range can be adjusted according to actual needs). If the proportion of data null value time points to the upload time is less than 5%, the data is stored in the data table under the corresponding time and object partition. If it is greater than 5%, the data is not stored.

[0039] S4. The verified pumped storage data to be stored is stored according to the corresponding category and unique code.

[0040] Specifically, step S4 includes: S41. According to the timestamp (such as start_time or x_time) and object code (such as object_id or device ID in dd_list) of the data, determine in which time partition and object partition the data should be stored. The time partition is divided based on date (such as day, week, month, etc.), and the object partition is divided based on device type, plant ID, etc.

[0041] S42. Prepare a corresponding data table according to the storage partition division result. If the data table does not exist yet, create it. The design of the data table meets the needs of data storage and query, including table structure, index, etc.

[0042] S43. Insert the parsed and verified data into the data table under the corresponding time partition and object partition.

[0043] It should be noted that each message has only one UUID corresponding to it, so even if the same data source repeatedly sends data to the database for overwriting, each data message can still be traced back for corresponding data verification. And the means of finding the collection status during the data collection period will not be lost because the database data is overwritten. In addition, the UUID code can define different digits according to the business.

[0044] The electric pumped storage data storage method provided by the present invention can effectively monitor the data collection during data upload. At present, this technology has been piloted in the pumped storage centralized operation and control system of State Grid Xinyuan Shandong Company, and has effectively monitored the collection quality of 43 types of data in the pumped storage production process. Through the implementation of the above process, the situation of dirty data entering the warehouse is reduced, and the proportion of storage space usage is reduced by 13% compared with the original, and the problem of low data quality at the data source can be discovered and located in time and rectified.

[0045] In this solution, the unique code obtained by converting the data source, data upload time, data type code, device code and the code assigned by the server itself is hashed to generate a unique message identifier for each message. The data can only enter the storage module under the corresponding partition after the data is checked for null values ​​and meets the requirements.

[0046] In an optional embodiment, Figure 3 As shown, the data collection module collects the power storage data to be stored, and then classifies the data through the message field; the classified data is subjected to rationality check and data null value check in the data collection monitoring module, and the data that passes the rationality check but has a data null value time point ratio of less than 5% of the sending time enters the corresponding storage module for storage, otherwise, the data is not stored.

[0047] Example 2 like Figure 4 As shown, based on the same inventive concept as the above embodiment, the present invention also provides an electric pumped storage data storage device, comprising: An identification module, used to identify a type field code and a unique code from a message of power pumped storage data to be stored; A classification module, used for classifying the pumped-storage power data to be stored based on the type field code to obtain the category of the pumped-storage power data to be stored; A verification module, used to perform rationality verification and data null value verification on the classified power pumped storage data to be stored; The storage module is used to store the verified power pumped storage data to be stored according to the corresponding category and unique code.

[0048] Example 3 like Figure 5 As shown, the present invention also provides an electronic device 100 for implementing the power pumped storage data storage method; The electronic device 100 includes a memory 101 , at least one processor 102 , a computer program 103 stored in the memory 101 and executable on the at least one processor 102 , and at least one communication bus 104 .

[0049] The memory 101 can be used to store a computer program 103 , and the processor 102 implements the steps of a method for storing pumped storage data in Example 1 by running or executing the computer program stored in the memory 101 and calling the data stored in the memory 101 .

[0050] The memory 101 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application required for at least one function (such as a sound playback function, an image playback function, etc.), etc.; the data storage area may store data (such as audio data) created according to the use of the electronic device 100, etc. In addition, the memory 101 may include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), at least one disk storage device, a flash memory device, or other non-volatile solid-state storage devices.

[0051] At least one processor 102 may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor 102 may be a microprocessor or any conventional processor, etc. The processor 102 is the control center of the electronic device 100, and uses various interfaces and lines to connect various parts of the entire electronic device 100.

[0052] The memory 101 in the electronic device 100 stores a plurality of instructions to implement a method for storing pumped power data, and the processor 102 can execute the plurality of instructions to implement: Identify a type field code and a unique code from a message of power pumped storage data to be stored; Classifying the pumped-storage power data to be stored based on the type field code to obtain a category of the pumped-storage power data to be stored; Perform rationality check and data null value check on the classified pumped storage data to be stored; The verified pumped storage data to be stored is stored according to the corresponding category and unique code.

[0053] Example 4 If the module / unit integrated in the electronic device 100 is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present invention implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium, and the computer program can implement the steps of the above-mentioned method embodiments when executed by the processor. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. Computer-readable media may include: any entity or device capable of carrying computer program code, recording medium, U disk, mobile hard disk, disk, optical disk, computer memory and read-only memory (ROM, Read-Only Memory).

[0054] It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0055] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0056] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0057] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0058] In the description of this specification, the description with reference to the terms "one embodiment", "example", "specific example", etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described can be combined in any one or more embodiments or examples in a suitable manner.

[0059] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the above embodiments, ordinary technicians in the relevant field should understand that the specific implementation methods of the present invention can still be modified or replaced by equivalents. Any modification or equivalent replacement that does not depart from the spirit and scope of the present invention should be covered within the scope of protection of the claims of the present invention.

Claims

1. A method for storing pumped storage data, characterized in that: The steps include: Identify a type field code and a unique code from a message of power pumped storage data to be stored; Classifying the pumped-storage power data to be stored based on the type field code to obtain a category of the pumped-storage power data to be stored; Perform rationality check and data null value check on the classified pumped storage data to be stored; The verified pumped storage data to be stored is stored according to the corresponding category and unique code.

2. The method for storing pumped storage data according to claim 1, characterized in that: In the step of identifying the type field code and the unique code from the message of the power pumped storage data to be stored, the type field includes a message type field and a data type field.

3. The method for storing pumped storage data according to claim 1, characterized in that: In the step of identifying the type field code and the unique code from the message of the power pumped storage data to be stored, the unique code is generated in the following manner: The data source code of the power pumped storage data to be stored, the data upload time code, the type field code, the device code and the code assigned by the server itself are converted into hash values ​​to obtain a unique code.

4. The method for storing pumped storage data according to claim 2, characterized in that: The pumped storage data to be stored is classified based on the type field encoding, including: Determine the preliminary classification of the pumped storage power data to be stored according to the message type field; On the basis of the preliminary classification, the secondary classification of the pumped storage power data to be stored is determined according to the data type field.

5. The method for storing pumped storage data according to claim 2, characterized in that: In the step of performing rationality check and data null value check on the classified power pumped storage data to be stored, the method of data null value check is as follows: Identifying a data null value time point in the power pumped storage data to be stored; The data null value check result is determined according to the proportion of the data null value time point to the above time.

6. The method for storing pumped storage data according to claim 5, characterized in that: According to the proportion of the data null value time point to the above time, the data null value check result is determined, including: Calculate the proportion of the data null value time points to the above time; When the ratio is within a preset range, the data null value check passes; When the ratio exceeds a preset range, the data null value check fails.

7. The method for storing pumped storage data according to claim 1, characterized in that: The verified pumped storage data to be stored is stored according to the corresponding category and unique code, including: Determine the corresponding time partition and object partition according to the timestamp and object code of the data; Prepare corresponding data tables according to the storage partition division results; Insert the parsed and verified data into the data table under the corresponding time partition and object partition.

8. An electric power pumped storage data storage device, characterized in that: include: An identification module, used to identify a type field code and a unique code from a message of electric power pumped storage data to be stored; A classification module, used for classifying the pumped-storage power data to be stored based on the type field code to obtain the category of the pumped-storage power data to be stored; A verification module, used to perform rationality verification and data null value verification on the classified power pumped storage data to be stored; The storage module is used to store the verified power pumped storage data to be stored according to the corresponding category and unique code.

9. An electronic device, characterized in that: It comprises a processor and a memory, wherein the processor is used to execute a computer program stored in the memory to implement the power pumped storage data storage method as claimed in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores at least one instruction, and when the at least one instruction is executed by a processor, the method for storing pumped-storage power data according to any one of claims 1 to 7 is implemented.

Citation Information

Cited By

  • Power dispatching service data processing method, system and equipment and medium

    CN121235307A