A power data arrangement method

Abstract

The application relates to the technical field of electric power data arrangement, and discloses an electric power data arrangement method, which comprises the following steps: obtaining selection information of a user, and selecting point table framework data corresponding to the selection information in preset point table data as initial point table data based on the selection information; obtaining parameter data corresponding to the selection information, and filling the initial point table data according to the parameter data to obtain to-be-detected point table data; detecting whether each naming field in the to-be-detected point table data meets a preset naming rule through a regular expression; if each naming field in the to-be-detected point table data meets the preset naming rule, judging whether a target parameter corresponding to the naming field meets a preset parameter rule; and if the target parameter meets the preset parameter rule, generating a target point table according to the to-be-detected point table data.

Description

Technical Field

[0001] This invention relates to the field of power data processing technology, and in particular to a method for processing power data. Background Technology

[0002] In power systems, point meters serve as the fundamental data carrier for information transmission among various devices such as remote control systems and monitoring systems. The creation and management of point meters is a massive and complex undertaking. Traditional manual methods are prone to problems such as inconsistent naming, data omissions, and unclear version differences, which in turn affect the accuracy of power dispatching and equipment monitoring. With the expansion of the power grid, the complexity and volume of point meter management are constantly increasing, making traditional manual methods insufficient to meet the requirements of efficiency and accuracy. Summary of the Invention

[0003] In view of this, the present invention provides a power data processing method to solve the problems of human error and low efficiency in the manual generation of point tables in the prior art.

[0004] To achieve one or more of the above objectives or other objectives, the present invention proposes a power data processing method, comprising: obtaining user selection information, and based on the selection information, selecting point table framework data corresponding to the selection information from preset point table data as initial point table data;

[0005] Obtain the parameter data corresponding to the selection information, and fill the initial point table data according to the parameter data to obtain the point table data to be detected;

[0006] The system uses regular expressions to detect whether each named field in the data of the point table to be detected meets the preset naming rules.

[0007] If each named field in the data of the point to be detected satisfies the preset naming rule, then determine whether the target parameter corresponding to the named field satisfies the preset parameter rule.

[0008] When all the target parameters meet the preset parameter rules, a target point table is generated based on the data of the point table to be detected.

[0009] Optionally, the step of obtaining parameter data corresponding to the selection information and filling the initial point table data according to the parameter data to obtain the point table data to be detected includes:

[0010] Obtain user input data corresponding to the selection information;

[0011] If the user input data is not empty, then the user input data is used as the parameter data, and the initial point table data is filled according to the parameter data to obtain the point table data to be detected;

[0012] If the user input data is empty, the operation data of the target substation corresponding to the selection information is obtained, and the parameter data is selected from the operation data according to the selection information. The initial point table data is then filled with the parameter data to obtain the point table data to be detected.

[0013] Optionally, the step of filling the initial point table data according to the parameter data to obtain the point table data to be detected includes:

[0014] Obtain the target data format of the parameter data and the preset data format of the initial point table data;

[0015] Match the target data format with the preset data format;

[0016] If the target data format is consistent with the preset data format, the initial point table data is filled according to the parameter data to obtain the point table data to be detected;

[0017] If the target data format and the preset data format are inconsistent, a conversion method between the target data format and the preset data format is determined from the preset data conversion method set. The conversion method between the target data format and the preset data format is taken as the target conversion method, and the parameter data is converted according to the target conversion method to obtain the target parameter data.

[0018] The initial point table data is filled with the target parameter data to obtain the point table data to be detected.

[0019] Optionally, the step of filling the initial point table data with the target parameter data to obtain the point table data to be detected includes:

[0020] Obtain the parameter fields used to characterize the point table parameters from the initial point table data;

[0021] The parameter type corresponding to the parameter field is identified based on the first attribute information of the parameter field;

[0022] The target parameter data is filled into the initial point table data according to the parameter type to obtain the point table data to be detected.

[0023] Optionally, the method further includes:

[0024] If at least one named field in the data table of points to be detected does not meet the preset naming rule, then the named field that does not meet the preset naming rule is regarded as a violation field, and the second attribute information of the violation field is obtained.

[0025] An alarm message is generated based on the second attribute information, and the alarm message is sent to the client corresponding to the selected information;

[0026] Obtain user request information for the alarm information, and update the violation field based on the user request information until the updated violation field meets the preset naming rule.

[0027] Optionally, the step of updating the violation field based on the user request information until the updated violation field satisfies the preset naming rule includes:

[0028] When the user request information is used to update the violation field, and the content data in the user request information is not empty, the content data is organized according to the preset naming rule to obtain updated data, and the violation field is updated according to the updated data until the updated violation field meets the preset naming rule.

[0029] When the user request information is used to update the violation field, and the content data in the user request information is empty, the named data in the violation field is obtained, and the named data is organized according to the preset naming rules to obtain updated named data. The violation field is updated according to the updated named data until the updated violation field meets the preset naming rules.

[0030] Optionally, the method further includes:

[0031] Obtain the historical point table and identify the historical data in the historical point table;

[0032] The historical data is classified according to data type to obtain name data that characterizes the data type and historical parameter data corresponding to the name data;

[0033] The name data is used as the selection information, and based on the selection information, the point table frame data corresponding to the selection information is selected from the preset point table data as the secondary point table data.

[0034] The secondary point table data is populated based on the historical parameter data to obtain the updated point table data;

[0035] The system uses regular expressions to check whether each named field in the update point table data meets the preset naming rules.

[0036] If each named field in the updated point table data satisfies the preset naming rule, then determine whether the target parameter corresponding to the named field satisfies the preset parameter rule;

[0037] When the target parameters meet the preset parameter rules, an updated point table of the historical point table is generated based on the updated point table data.

[0038] On the other hand, this application provides a power data processing device, the device comprising:

[0039] The data receiving module is used to acquire the user's selection information and, based on the selection information, select the point table frame data corresponding to the selection information from the preset point table data as the initial point table data.

[0040] The data filling module is used to acquire parameter data corresponding to the selection information, and fill the initial point table data according to the parameter data to obtain the point table data to be detected;

[0041] The naming detection module is used to detect whether each named field in the data of the point table to be detected meets the preset naming rules using regular expressions;

[0042] The data detection module is used to determine whether the target parameter corresponding to the named field satisfies the preset parameter rule if each named field in the data of the point to be detected table satisfies the preset naming rule.

[0043] The point table generation module is used to generate a target point table based on the point table data to be detected when all the target parameters meet the preset parameter rules.

[0044] On the other hand, this application provides an electronic device, including: a processor, a memory, and a bus. The memory stores machine-readable instructions executable by the processor. When the electronic device is running, the processor communicates with the memory via the bus. When the machine-readable instructions are executed by the processor, the following steps are performed: obtaining user selection information, and based on the selection information, selecting point table framework data corresponding to the selection information from preset point table data as initial point table data; obtaining parameter data corresponding to the selection information, and filling the initial point table data according to the parameter data to obtain point table data to be detected; detecting whether each named field in the point table data to be detected satisfies a preset naming rule using a regular expression; if each named field in the point table data to be detected satisfies the preset naming rule, determining whether the target parameter corresponding to the named field satisfies a preset parameter rule; and generating a target point table based on the point table data to be detected when all target parameters satisfy the preset parameter rule.

[0045] On the other hand, this application provides a computer-readable storage medium storing a computer program that is executed by a processor: acquiring user selection information and, based on the selection information, selecting point table framework data corresponding to the selection information from preset point table data as initial point table data; acquiring parameter data corresponding to the selection information and filling the initial point table data according to the parameter data to obtain point table data to be detected; detecting whether each named field in the point table data to be detected satisfies a preset naming rule using a regular expression; if each named field in the point table data to be detected satisfies the preset naming rule, determining whether the target parameter corresponding to the named field satisfies a preset parameter rule; and generating a target point table based on the point table data to be detected when all target parameters satisfy the preset parameter rule.

[0046] Implementing the embodiments of the present invention will have the following beneficial effects:

[0047] By acquiring user selection information and selecting point table framework data corresponding to the selection information from preset point table data as initial point table data, parameter data corresponding to the selection information is acquired and the initial point table data is filled according to the parameter data to obtain point table data to be tested. Regular expressions are used to detect whether each named field in the point table data to be tested meets preset naming rules. If each named field in the point table data to be tested meets the preset naming rules, it is determined whether the target parameter corresponding to the named field meets preset parameter rules. When all target parameters meet the preset parameter rules, a target point table is generated based on the point table data to be tested. This achieves automatic point table generation, reducing human error caused by manual operation during point table generation. Furthermore, using the point table framework data from the preset point table data to generate the target point table makes the generated point table more standardized. Attached Figure Description

[0048] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0049] in:

[0050] Figure 1 This is a flowchart of a power data processing method provided in an embodiment of this application;

[0051] Figure 2This is a flowchart illustrating the generation of point table framework data in a power data processing method provided in this application embodiment;

[0052] Figure 3 This is a flowchart of version comparison and difference checking between different point tables in a power data processing method provided in this application embodiment;

[0053] Figure 4 This is a flowchart of the naming convention check in a power data processing method provided in this application embodiment;

[0054] Figure 5 This is a flowchart of signal configuration checking in a power data processing method provided in an embodiment of this application;

[0055] Figure 6 This is a flowchart of address conflict detection in a power data processing method provided in an embodiment of this application;

[0056] Figure 7 This is a flowchart illustrating the generation of an inspection result report in a power data processing method provided in this application embodiment;

[0057] Figure 8 This is a schematic diagram of the structure of a power data processing device provided in an embodiment of this application;

[0058] Figure 9 This is a schematic diagram of the structure of a computer device according to an embodiment of the present invention;

[0059] Figure 10 This is another structural schematic diagram of a computer device according to one embodiment of the present invention.

[0060] Figure 11 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application;

[0061] Figure 12 This is a schematic diagram of the structure of a storage medium provided in an embodiment of this application. Detailed Implementation

[0062] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0063] like Figure 1 As shown in the figure, this application provides a method for processing power data, including:

[0064] S101. Obtain the user's selection information, and based on the selection information, select the point table frame data corresponding to the selection information from the preset point table data as the initial point table data.

[0065] For example, the selection information is the name of the data that the user prepares to record, such as voltage level, substation type, equipment name, etc.; the preset point table data may include different preset point tables and the format requirements of the parameters in the point table, for example, a point table including substation type and voltage level, and the format requirement of the parameters corresponding to the voltage level can be in volts.

[0066] For example, by using preset point table data, point tables of the same format can be generated for different scenarios under the same selection information, avoiding the generation of point tables of different formats under the same task (same selection information), facilitating data comparison, and standardizing the format of the point table.

[0067] For example, the preset point table data can also be a set of fields used to generate the point table, such as fields for naming in the point table, fields for parameters in the point table, and fields for parameter formats in the point table. When selecting point table framework data corresponding to the selection information in the preset point table data, the fields corresponding to the selection information can be selected, and point table framework data can be generated based on the fields.

[0068] S102. Obtain parameter data corresponding to the selection information, and fill the initial point table data according to the parameter data to obtain the point table data to be detected;

[0069] For example, the data source for the parameter data corresponding to the selection information can be the specific parameter value input by the user, or it can be the operating parameter value measured in real time.

[0070] For example, the initial point table data is a point table framework data generated by fields, which can be understood as a table without specific parameter values. The process of filling the parameter data into the initial point table data can be understood as filling the specific parameter values ​​into the corresponding positions in the table, that is, filling the specific parameter values ​​into the blank positions of the corresponding fields. The parameter data includes, but is not limited to, interval name, signal code, device type, acquisition point, etc.

[0071] S103. Use regular expressions to detect whether each named field in the data of the point table to be detected meets the preset naming rules;

[0072] For example, a regular expression is a tool for matching and manipulating text. It consists of a pattern composed of a series of characters and special characters, which describes the text pattern to be matched. That is, each named field in the data to be detected is described by a regular expression to determine whether each named field in the data to be detected meets a preset naming rule. The preset naming rule can be a naming rule defined by humans or a naming rule summarized from historical data.

[0073] S104. If each named field in the data of the point to be detected satisfies the preset naming rule, then determine whether the target parameter corresponding to the named field satisfies the preset parameter rule.

[0074] For example, the preset parameter rules include, but are not limited to, padding rules and abnormal data verification rules. The padding rule can be understood as follows: when the target parameter corresponding to the named field cannot be obtained, the field corresponding to the target parameter needs to be padded to ensure that the point table generated later will not be corrupted due to the absence of a single data point.

[0075] S105. When all the target parameters meet the preset parameter rules, a target point table is generated based on the data of the point table to be detected.

[0076] For example, when all the target parameters meet the preset parameter rules, a target point table is generated based on the data of the point table to be detected, and output as an Excel (spreadsheet software) or other format file.

[0077] By acquiring user selection information and selecting point table framework data corresponding to the selection information from preset point table data as initial point table data, parameter data corresponding to the selection information is acquired and the initial point table data is filled according to the parameter data to obtain point table data to be tested. Regular expressions are used to detect whether each named field in the point table data to be tested meets preset naming rules. If each named field in the point table data to be tested meets the preset naming rules, it is determined whether the target parameter corresponding to the named field meets preset parameter rules. When all target parameters meet the preset parameter rules, a target point table is generated based on the point table data to be tested. This achieves automatic point table generation, reducing human error caused by manual operation during point table generation. Furthermore, using the point table framework data from the preset point table data to generate the target point table makes the generated point table more standardized.

[0078] Optionally, the step of obtaining parameter data corresponding to the selection information and filling the initial point table data according to the parameter data to obtain the point table data to be detected includes:

[0079] Obtain user input data corresponding to the selection information;

[0080] If the user input data is not empty, then the user input data is used as the parameter data, and the initial point table data is filled according to the parameter data to obtain the point table data to be detected;

[0081] If the user input data is empty, the operation data of the target substation corresponding to the selection information is obtained, and the parameter data is selected from the operation data according to the selection information. The initial point table data is then filled with the parameter data to obtain the point table data to be detected.

[0082] In one possible implementation, the step of filling the initial point table data according to the parameter data to obtain the point table data to be detected includes:

[0083] Obtain the target data format of the parameter data and the preset data format of the initial point table data;

[0084] Match the target data format with the preset data format;

[0085] If the target data format is consistent with the preset data format, the initial point table data is filled according to the parameter data to obtain the point table data to be detected;

[0086] If the target data format and the preset data format are inconsistent, a conversion method between the target data format and the preset data format is determined from the preset data conversion method set. The conversion method between the target data format and the preset data format is taken as the target conversion method, and the parameter data is converted according to the target conversion method to obtain the target parameter data.

[0087] The initial point table data is filled with the target parameter data to obtain the point table data to be detected.

[0088] For example, since different devices are often manufactured by different companies, their parameter formats are often different. Taking the unit of the parameter as an example, some devices use watts (W) as the parameter format, while others use kilowatts (kW). When the preset data format of the initial point table is watts (W), if the parameter of a device with a kilowatt parameter format is directly entered into the initial point table without data conversion, it is easy to cause a large error. Therefore, it is necessary to convert kilowatts to watts before entering them into the initial point table. Similarly, when dealing with other units, it is also necessary to convert the parameters of other units into parameter values ​​in watts to avoid errors when comparing a large number of point tables with different data formats, and to more intuitively reflect the comparison effect of different point tables.

[0089] In one possible implementation, the step of filling the initial point table data according to the target parameter data to obtain the point table data to be detected includes:

[0090] Obtain the parameter fields used to characterize the point table parameters from the initial point table data;

[0091] The parameter type corresponding to the parameter field is identified based on the first attribute information of the parameter field;

[0092] The target parameter data is filled into the initial point table data according to the parameter type to obtain the point table data to be detected.

[0093] For example, the first attribute information can be understood as information that characterizes the function of the parameter field. For instance, the first attribute information characterizes the function of the parameter field in displaying device type / voltage level, and then identifies the parameter type of the parameter field based on its function.

[0094] For example, when the parameter field is of type used to display voltage levels, the parameter value of the voltage level in the parameter data is filled into the initial point table data.

[0095] In one possible implementation, the method further includes:

[0096] If at least one named field in the data table of points to be detected does not meet the preset naming rule, then the named field that does not meet the preset naming rule is regarded as a violation field, and the second attribute information of the violation field is obtained.

[0097] An alarm message is generated based on the second attribute information, and the alarm message is sent to the client corresponding to the selected information;

[0098] Obtain user request information for the alarm information, and update the violation field based on the user request information until the updated violation field meets the preset naming rule.

[0099] For example, check whether the signal naming conforms to the format "station name_device_signal type_number". The specific underlying code data is as follows:

[0100] pattern=r'^[A-Za-z0-9]+_[A-Za-z0-9]+_[A-Za-z]+_\d+$'

[0101] def check_naming_convention(name):

[0102] return re.match(pattern,name)is not None

[0103] For example, when there are non-compliant fields that do not meet the preset naming rules, they are promptly reported to the staff, and the non-compliant fields are modified according to the user request information provided by the user until the updated non-compliant fields meet the preset naming rules, thus ensuring the accuracy of the subsequently generated point tables.

[0104] In one possible implementation, the step of updating the violation field based on the user request information until the updated violation field satisfies the preset naming rule includes:

[0105] When the user request information is used to update the violation field, and the content data in the user request information is not empty, the content data is organized according to the preset naming rule to obtain updated data, and the violation field is updated according to the updated data until the updated violation field meets the preset naming rule.

[0106] When the user request information is used to update the violation field, and the content data in the user request information is empty, the named data in the violation field is obtained, and the named data is organized according to the preset naming rules to obtain updated named data. The violation field is updated according to the updated named data until the updated violation field meets the preset naming rules.

[0107] For example, when a user is provided with a name that meets the preset naming rules, the user-provided name is replaced in the violation field, allowing for faster error correction. When the user does not provide a name that meets the preset naming rules, a new name is generated based on the violation name in the violation field and the preset naming rules, making the update process for the violation field more intelligent. After a violation field is discovered, it can be updated automatically without the need for technical personnel.

[0108] In one possible implementation, the method further includes:

[0109] Obtain the historical point table and identify the historical data in the historical point table;

[0110] The historical data is classified according to data type to obtain name data that characterizes the data type and historical parameter data corresponding to the name data;

[0111] The name data is used as the selection information, and based on the selection information, the point table frame data corresponding to the selection information is selected from the preset point table data as the secondary point table data.

[0112] The secondary point table data is populated based on the historical parameter data to obtain the updated point table data;

[0113] The system uses regular expressions to check whether each named field in the update point table data meets the preset naming rules.

[0114] If each named field in the updated point table data satisfies the preset naming rule, then determine whether the target parameter corresponding to the named field satisfies the preset parameter rule;

[0115] When the target parameters meet the preset parameter rules, an updated point table of the historical point table is generated based on the updated point table data.

[0116] For example, updating the historical point table involves converting it into an updated point table that conforms to the current rules (preset naming rules and preset parameter rules), which facilitates comparison between different point tables and makes the comparison process more intuitive and efficient.

[0117] For example, such as Figure 2 As shown, the method further includes template creation (creating the point table framework data), template editing (editing the point table framework data), template saving (saving the point table framework data), and template application (applying the point table framework data).

[0118] In one possible implementation, the method further includes:

[0119] Obtain user request information, which includes basic information of the point table framework data, such as template name, applicable voltage level, and equipment type;

[0120] Obtain the signal type selected from a preset signal type library, such as telemetry, remote signaling, remote control, remote adjustment, etc.

[0121] A custom template is created based on the user request information and the signal type, and the custom template is used as the point table framework data.

[0122] For example, for a specific signal that does not exist in the preset signal type library, you can set default values, units, precision and other attributes to meet specific project requirements.

[0123] In one possible implementation, the method further includes:

[0124] Obtain user modification information, and add, delete, or modify the content in the point table framework data according to the modification information, such as adjusting the order of signals or updating the attributes of signals.

[0125] For example, when adding, deleting, or modifying content in the point table framework data based on real-time user information, the user's operation can be undone to ensure the safety of the user's operation during the editing process.

[0126] In one possible implementation, when the point table framework data is invoked, the permission information of the user invoking the point table framework data is obtained, and the permission information is matched with the preset permissions of the point table framework data. If the permission information is greater than or equal to the preset permissions of the point table framework data, the invocation of the point table framework data is completed; if the permission information is less than the preset permissions of the point table framework data, the invocation of the point table framework data is prohibited.

[0127] Ensure the security and privacy of templates by setting access permissions.

[0128] In one possible implementation, the generated point table can be further adjusted and optimized according to actual needs.

[0129] In one possible implementation, the point table framework data is classified according to a preset classification rule, making it easier for users to quickly find the template they need.

[0130] In one possible implementation, the call data of the point table framework data is recorded, allowing users to view the usage history of the point table framework data and understand its application.

[0131] For example, such as Figure 3 As shown, the method further includes:

[0132] Obtain different versions of the point table, and distinguish the different versions of the point table based on the content of the point table.

[0133] Specifically, the content comparison involves comparing each uploaded version item by item, including the addition, deletion, modification, and attribute changes of signal items. The comparison process is fast and accurate, identifying even the smallest differences.

[0134] Difference marking and highlighting: Differences found during comparison are automatically marked and highlighted, making it easy for users to quickly locate and understand the points of change.

[0135] Difference Report Generation: After the comparison is completed, a detailed difference report is generated, including the specific content of the difference, its location, and its potential impact. The report can be exported in multiple formats for easy sharing and discussion among users.

[0136] For example, it also includes:

[0137] Version management: Retrieves historical version records of the point table, allowing users to understand the creation time, modifier, and changes for each version. This helps users track the changes to the point table, ensuring project continuity and consistency. For example, such as... Figure 4 As shown, the device names in the point table are checked one by one according to the power grid company's naming rules (preset naming rules). The checks include character length, naming format, and the use of special characters, to ensure that each device name conforms to the standard.

[0138] For example, such as Figure 5 As shown, the signal configuration in the automatic checkpoint table includes signal type, signal attributes, signal range, etc. By comparing with preset signal configuration rules, the system can identify incorrectly configured or missing signal items and provide corresponding prompts.

[0139] For example, such as Figure 6 As shown, the system performs a full scan of the communication addresses in the address table to check for duplicate or conflicting addresses. If a conflict is found, the system will immediately report it and advise the user to make the necessary changes.

[0140] For example, such as Figure 7 As shown, after verification is completed, an inspection result report is generated, including the specific details of each inspection, the problems found, and suggested solutions. Users can revise the checklist based on the report to ensure it complies with specifications.

[0141] On the other hand, such as Figure 8 As shown, this application provides a power data processing device, the device comprising:

[0142] The data receiving module 201 is used to acquire the user's selection information and, based on the selection information, select the point table frame data corresponding to the selection information from the preset point table data as the initial point table data.

[0143] The data filling module 202 is used to acquire parameter data corresponding to the selection information, and fill the initial point table data according to the parameter data to obtain the point table data to be detected;

[0144] The naming detection module 203 is used to detect whether each named field in the data of the point table to be detected meets the preset naming rules through regular expressions;

[0145] The data detection module 204 is used to determine whether the target parameter corresponding to the named field satisfies the preset parameter rule if each named field in the data of the point to be detected table satisfies the preset naming rule.

[0146] The point table generation module 205 is used to generate a target point table based on the point table data to be detected when all the target parameters meet the preset parameter rules.

[0147] Specific limitations regarding the intelligent question-answering processing device can be found in the limitations of the intelligent question-answering method above, and will not be repeated here. Each module in the aforementioned report recommendation device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in or independent of the processor in the computer device in hardware form, or stored in the memory of the computer device in software form, so that the processor can call and execute the operations corresponding to each module.

[0148] In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as follows: Figure 9 As shown, the computer device includes a processor, memory, network interface, and database connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile and / or volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The network interface is used to communicate with external clients via a network connection. When the computer program is executed by the processor, it implements the functions or steps of a power data processing method on the server side.

[0149] In one embodiment, a computer device is provided, which may be a client, and its internal structure diagram may be as follows: Figure 10 As shown, the computer device includes a processor, memory, network interface, display screen, and input devices connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The network interface is used to communicate with an external server via a network connection. When the computer program is executed by the processor, it implements the functions or steps of a power data processing method on the client side.

[0150] In one possible implementation, such as Figure 11As shown, this application embodiment provides an electronic device 300, including: a memory 310, a processor 320, and a computer program 311 stored in the memory 310 and executable on the processor 320. When the processor 320 executes the computer program 311, it implements the following steps: obtaining user selection information, and selecting point table framework data corresponding to the selection information as initial point table data from preset point table data based on the selection information; obtaining parameter data corresponding to the selection information, and filling the initial point table data according to the parameter data to obtain point table data to be detected; detecting whether each named field in the point table data to be detected satisfies a preset naming rule using a regular expression; if each named field in the point table data to be detected satisfies the preset naming rule, determining whether the target parameter corresponding to the named field satisfies a preset parameter rule; and generating a target point table based on the point table data to be detected when all target parameters satisfy the preset parameter rule.

[0151] By acquiring user selection information and selecting point table framework data corresponding to the selection information from preset point table data as initial point table data, parameter data corresponding to the selection information is acquired and the initial point table data is filled according to the parameter data to obtain point table data to be tested. Regular expressions are used to detect whether each named field in the point table data to be tested meets preset naming rules. If each named field in the point table data to be tested meets the preset naming rules, it is determined whether the target parameter corresponding to the named field meets preset parameter rules. When all target parameters meet the preset parameter rules, a target point table is generated based on the point table data to be tested. This achieves automatic point table generation, reducing human error caused by manual operation during point table generation. Furthermore, using the point table framework data from the preset point table data to generate the target point table makes the generated point table more standardized.

[0152] In one possible implementation, such as Figure 12As shown, this application embodiment provides a computer-readable storage medium 400, on which a computer program 411 is stored. When executed by a processor, the computer program 411 implements the following steps: obtaining user selection information, and based on the selection information, selecting point table framework data corresponding to the selection information from preset point table data as initial point table data; obtaining parameter data corresponding to the selection information, and filling the initial point table data according to the parameter data to obtain point table data to be detected; detecting whether each named field in the point table data to be detected satisfies a preset naming rule using a regular expression; if each named field in the point table data to be detected satisfies the preset naming rule, determining whether the target parameter corresponding to the named field satisfies a preset parameter rule; and generating a target point table based on the point table data to be detected when all target parameters satisfy the preset parameter rule.

[0153] By acquiring user selection information and selecting point table framework data corresponding to the selection information from preset point table data as initial point table data, parameter data corresponding to the selection information is acquired and the initial point table data is filled according to the parameter data to obtain point table data to be tested. Regular expressions are used to detect whether each named field in the point table data to be tested meets preset naming rules. If each named field in the point table data to be tested meets the preset naming rules, it is determined whether the target parameter corresponding to the named field meets preset parameter rules. When all target parameters meet the preset parameter rules, a target point table is generated based on the point table data to be tested. This achieves automatic point table generation, reducing human error caused by manual operation during point table generation. Furthermore, using the point table framework data from the preset point table data to generate the target point table makes the generated point table more standardized.

[0154] The computer storage medium of this invention can be any combination of one or more computer-readable media. A computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. For example, a computer-readable storage medium can be, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples (a non-exhaustive list) of computer-readable storage media include: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this document, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

[0155] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, capable of sending, propagating, or transmitting programs for use by or in connection with an instruction execution system, apparatus, or device.

[0156] Program code contained on a computer-readable medium may be transmitted using any suitable medium, including but not limited to: wireless, wire, optical fiber, RF, etc., or any suitable combination thereof.

[0157] Computer program code for performing the operations of this invention can be written in one or more programming languages ​​or a combination thereof. These programming languages ​​include object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages—such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0158] Those skilled in the art will understand that the modules or steps of the present invention described above can be implemented using general-purpose computing devices. They can be centralized on a single computing device or distributed across a network of multiple computing devices. Optionally, they can be implemented using computer-executable program code, thereby allowing them to be stored in a storage device for execution by a computing device, or they can be fabricated as separate integrated circuit modules, or multiple modules or steps can be fabricated as a single integrated circuit module. Thus, the present invention is not limited to any particular combination of hardware and software.

[0159] Note that the above description is merely a preferred embodiment of the present invention and the technical principles employed. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and various obvious changes, readjustments, and substitutions can be made without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in detail through the above embodiments, the present invention is not limited to the above embodiments, and may include many other equivalent embodiments without departing from the concept of the present invention, the scope of which is determined by the scope of the appended claims.

[0160] The above description discloses only preferred embodiments of the present invention and should not be construed as limiting the scope of the present invention. Therefore, equivalent variations made in accordance with the claims of the present invention are still within the scope of the present invention.

Claims

1. A method for processing power data, characterized in that, include: Obtain the user's selection information, and based on the selection information, select the point table frame data corresponding to the selection information from the preset point table data as the initial point table data; Obtain the parameter data corresponding to the selection information, and fill the initial point table data according to the parameter data to obtain the point table data to be detected; The step of obtaining parameter data corresponding to the selection information and filling the initial point table data according to the parameter data to obtain the point table data to be detected includes: Obtain user input data corresponding to the selection information; If the user input data is not empty, then the user input data is used as the parameter data, and the initial point table data is filled according to the parameter data to obtain the point table data to be detected; If the user input data is empty, the operation data of the target substation corresponding to the selection information is obtained, and the parameter data is selected from the operation data according to the selection information. The initial point table data is filled according to the parameter data to obtain the point table data to be detected. The step of filling the initial point table data according to the parameter data to obtain the point table data to be detected includes: Obtain the target data format of the parameter data and the preset data format of the initial point table data; Match the target data format with the preset data format; If the target data format is consistent with the preset data format, the initial point table data is filled according to the parameter data to obtain the point table data to be detected; If the target data format and the preset data format are inconsistent, a conversion method between the target data format and the preset data format is determined from the preset data conversion method set. The conversion method between the target data format and the preset data format is taken as the target conversion method, and the parameter data is converted according to the target conversion method to obtain the target parameter data. The initial point table data is filled with the target parameter data to obtain the point table data to be detected; The system uses regular expressions to detect whether each named field in the data of the point table to be detected meets the preset naming rules. If each named field in the data of the point to be detected satisfies the preset naming rule, then determine whether the target parameter corresponding to the named field satisfies the preset parameter rule. When all the target parameters meet the preset parameter rules, a target point table is generated based on the data of the point table to be detected.

2. The power data processing method as described in claim 1, characterized in that, The step of filling the initial point table data according to the target parameter data to obtain the point table data to be detected includes: Obtain the parameter fields used to characterize the point table parameters from the initial point table data; The parameter type corresponding to the parameter field is identified based on the first attribute information of the parameter field; The target parameter data is filled into the initial point table data according to the parameter type to obtain the point table data to be detected.

3. The power data processing method as described in claim 1, characterized in that, The method further includes: If at least one named field in the data table of points to be detected does not meet the preset naming rule, then the named field that does not meet the preset naming rule is regarded as a violation field, and the second attribute information of the violation field is obtained. An alarm message is generated based on the second attribute information, and the alarm message is sent to the client corresponding to the selected information; Obtain user request information for the alarm information, and update the violation field based on the user request information until the updated violation field meets the preset naming rule.

4. The power data processing method as described in claim 3, characterized in that, The step of updating the violation field based on the user request information until the updated violation field meets the preset naming rule includes: When the user request information is used to update the violation field, and the content data in the user request information is not empty, the content data is organized according to the preset naming rule to obtain updated data, and the violation field is updated according to the updated data until the updated violation field meets the preset naming rule. When the user request information is used to update the violation field, and the content data in the user request information is empty, the named data in the violation field is obtained, and the named data is organized according to the preset naming rules to obtain updated named data. The violation field is updated according to the updated named data until the updated violation field meets the preset naming rules.

5. The power data processing method as described in claim 1, characterized in that, The method further includes: Obtain the historical point table and identify the historical data in the historical point table; The historical data is classified according to data type to obtain name data that characterizes the data type and historical parameter data corresponding to the name data; The name data is used as the selection information, and based on the selection information, the point table frame data corresponding to the selection information is selected from the preset point table data as the secondary point table data. The secondary point table data is populated based on the historical parameter data to obtain the updated point table data; The system uses regular expressions to check whether each named field in the update point table data meets the preset naming rules. If each named field in the updated point table data satisfies the preset naming rule, then determine whether the target parameter corresponding to the named field satisfies the preset parameter rule; When the target parameters meet the preset parameter rules, an updated point table of the historical point table is generated based on the updated point table data.

6. A power data processing device, characterized in that, The device includes: The data receiving module is used to acquire the user's selection information and, based on the selection information, select the point table frame data corresponding to the selection information from the preset point table data as the initial point table data. A data filling module is used to acquire parameter data corresponding to the selection information and fill the initial point table data according to the parameter data to obtain the point table data to be tested. The step of acquiring parameter data corresponding to the selection information and filling the initial point table data according to the parameter data to obtain the point table data to be tested includes: acquiring user input data corresponding to the selection information; if the user input data is not empty, then using the user input data as the parameter data and filling the initial point table data according to the parameter data to obtain the point table data to be tested; if the user input data is empty, then acquiring the operating data of the target substation corresponding to the selection information, selecting the parameter data from the operating data according to the selection information, and filling the initial point table data according to the parameter data to obtain the point table data to be tested; the step of filling the initial point table data according to the parameter data... The step of filling the initial point table data with parameter data to obtain the point table data to be detected includes: obtaining the target data format of the parameter data and the preset data format of the initial point table data; matching the target data format and the preset data format; if the target data format and the preset data format are consistent, then filling the initial point table data with the parameter data to obtain the point table data to be detected; if the target data format and the preset data format are inconsistent, then determining the conversion method between the target data format and the preset data format from a preset data conversion method set, using the conversion method between the target data format and the preset data format as the target conversion method, and converting the parameter data according to the target conversion method to obtain target parameter data; filling the initial point table data with the target parameter data to obtain the point table data to be detected. The naming detection module is used to detect whether each named field in the data of the point table to be detected meets the preset naming rules using regular expressions; The data detection module is used to determine whether the target parameter corresponding to the named field satisfies the preset parameter rule if each named field in the data of the point to be detected table satisfies the preset naming rule. The point table generation module is used to generate a target point table based on the point table data to be detected when all the target parameters meet the preset parameter rules.

7. An electronic device, characterized in that, include: The device includes a processor, a memory, and a bus. The memory stores machine-readable instructions executable by the processor. When the electronic device is running, the processor communicates with the memory via the bus. When the machine-readable instructions are executed by the processor, they perform the steps of the power data processing method as described in any one of claims 1 to 5.

8. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, performs the steps of the power data processing method as described in any one of claims 1 to 5.

Images