Data query method for regulation and control operation data and related equipment

Abstract

The invention discloses a data query method and related equipment for regulation and control operation data, and the method comprises the steps: taking the regulation and control operation data generated by a power grid dispatching automation system as to-be-sorted data, carrying out the field sorting of the to-be-sorted data, and carrying out the redundancy removal of the sorted field according to a preset screening rule, obtaining initial data; storing the initial data through a preset template to obtain basic data; and according to query information and preset dictionary data, determining data corresponding to the query information in the basic data as to-be-displayed data, and displaying the to-be-displayed data according to a preset display rule. The operation data (to-be-sorted data) generated by a power grid dispatching automation system (OCS system) is flexibly stored and / or inquired, so that the accuracy and high-efficiency statistics of regulation and control integrated data by power regulators are improved, and the problems of inaccurate inquiry result and time and labor waste caused by personal errors during item-by-item manual statistics according to dispatching operation instructions are avoided.

Description

Technical Field

[0001] The present invention relates to the technical field of data query, and in particular to a data query method for control operation data and related equipment. Background Art

[0002] The integrated control data is based on the power grid dispatching automation system and is used to characterize the working conditions of the equipment in the power grid. The staff at the power grid site (for example, substation) need to report the integrated control data to the management department at a certain period. It involves statistics on the number of operations of switches, knife switches, and protective soft pressure plates, and needs to be classified by voltage level, operation mode (remote control, on-site), and equipment type (station equipment, line equipment).

[0003] At present, the integrated control data is manually counted and generated item by item according to the dispatch operation instructions. The quantity is large and time-consuming. There are also inaccuracies caused by manual statistical errors. That is, the data query results are inefficient and inaccurate. Summary of the invention

[0004] Based on this, it is necessary to propose a data query method and system to address the technical problems of low efficiency and inaccuracy of data query results in the existing technology.

[0005] In a first aspect, a data query method for control operation data is provided, the method comprising:

[0006] The control operation data generated by the power grid dispatching automation system is used as the data to be sorted, the fields of the data to be sorted are sorted, and the sorted fields are de-redundant according to preset screening rules to obtain initial data;

[0007] The initial data is stored by using a preset template to obtain basic data;

[0008] According to the query information and preset dictionary data, data corresponding to the query information is determined in the basic data as data to be displayed, and the data to be displayed is displayed according to preset display rules.

[0009] Optionally, the step of using the control operation data generated by the power grid dispatching automation system as the data to be sorted, sorting the fields of the data to be sorted, and de-redundanting the sorted fields according to preset screening rules to obtain the initial data includes:

[0010] Performing content recognition on the data to be sorted to obtain first type data and second type data in the data to be sorted;

[0011] Performing field sorting on the first type of data and the second type of data respectively to obtain a first field for representing device information corresponding to the data to be sorted and a second field for representing action information corresponding to the device information;

[0012] The first field and the second field are deduplicated according to a preset screening rule to obtain initial data.

[0013] Optionally, the step of performing redundancy processing on the first field and the second field according to a preset screening rule to obtain initial data includes:

[0014] Matching the first device information in the preset screening rule with the first field;

[0015] If the first device information matches the first field, matching the second field with the first action information corresponding to the first device information in the preset screening rule;

[0016] If the second field matches the first action information, the first field and the second field are regarded as redundant data, and the redundant data is deleted;

[0017] If the preset device information does not match the first field, matching the first field with the second device information in the preset screening rule;

[0018] If the second device information matches the first field, matching the second field with the second action information corresponding to the second device information in the preset screening rule;

[0019] If the second field matches the second action information, the first field and the second field are regarded as redundant data, and the redundant data is deleted.

[0020] Optionally, the step of performing redundancy processing on the first field and the second field according to a preset screening rule to obtain initial data further includes:

[0021] Determine action data of the same device within a preset time period according to the first field and the second field;

[0022] Determining whether the action data satisfies a preset condition in the preset screening rule;

[0023] If the action data meets the preset conditions in the preset screening rule, the first field and the second field are regarded as redundant data, and the redundant data is deleted.

[0024] Optionally, before the step of determining, in the basic data, data corresponding to the query information as data to be displayed according to the query information and preset dictionary data, and displaying the data to be displayed according to preset display rules, the method further includes:

[0025] The preset dictionary data is constructed according to voltage level information and equipment classification information, wherein the voltage level information is used to map the identification information of the voltage level in the power grid dispatching automation system, and the equipment classification information is used to obtain equipment information from the dual equipment name of the initial data.

[0026] Optionally, the step of determining, in the basic data, data corresponding to the query information as data to be displayed according to the query information and preset dictionary data, and displaying the data to be displayed according to preset display rules includes:

[0027] Generate a query interface according to preset query information, and obtain user selection information for the query interface as the query information;

[0028] According to the query information and the preset dictionary data, determining data corresponding to the query information in the basic data as initial data to be displayed;

[0029] Using the data in the initial data to be displayed that meets the preset warning conditions in the preset display rules as data to be warned, and using the preset display mode in the preset display rules as the display mode of the data to be warned;

[0030] The data to be displayed is displayed in the display mode.

[0031] Optionally, the step of generating a query interface according to preset query information and obtaining user selection information for the query interface as the query information includes:

[0032] The user's authority information is obtained, and the query interface is generated according to preset query information corresponding to the authority information, and user selection information for the query interface is obtained as the query information.

[0033] On the other hand, the present application provides a data query device for control operation data, the device comprising:

[0034] The data acquisition module is used to use the control operation data generated by the power grid dispatching automation system as the data to be sorted, sort the fields of the data to be sorted, and perform redundancy processing on the sorted fields according to preset screening rules to obtain initial data;

[0035] An input module, used to store the initial data through a preset template to obtain basic data;

[0036] The display module is used to determine data corresponding to the query information in the basic data as data to be displayed according to the query information and preset dictionary data, and to display the data to be displayed according to preset display rules.

[0037] In a fourth aspect, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the above-mentioned data query method for control operation data are implemented.

[0038] This application uses the control operation data generated by the power grid dispatching automation system as the data to be sorted, sorts the fields of the data to be sorted, and performs redundancy processing on the sorted fields according to preset screening rules to obtain initial data; stores the initial data through a preset template to obtain basic data; determines the data corresponding to the query information in the basic data as the data to be displayed according to the query information and preset dictionary data, and displays the data to be displayed according to the preset display rules. The operation data (data to be sorted) generated by the power grid dispatching automation system (OCS system) can be flexibly stored and / or queried, so as to improve the accuracy and efficiency of the statistics of the integrated control data by the power controller, and avoid the problem of inaccurate query results due to human errors and time-consuming and labor-intensive problems when manually counting items one by one according to the dispatching operation instructions. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0040] in:

[0041] Figure 1 is a flow chart of a data query method for control operation data in one embodiment;

[0042] Figure 2 A data import flow chart of a data query method for control operation data in one embodiment;

[0043] Figure 3 A flowchart of dictionary data maintenance of yet another data query method for control operation data in one embodiment;

[0044] Figure 4 is a structural block diagram of a data query device for regulating operation data in one embodiment;

[0045] Figure 5 is a structural block diagram of a computer device in one embodiment;

[0046] Figure 6 It is a structural block diagram of a computer device in another embodiment. DETAILED DESCRIPTION

[0047] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0048] The present invention is described in detail below through specific embodiments.

[0049] See also Figure 1 As shown, Figure 1 A flow chart of a data query method for control operation data provided by an embodiment of the present invention includes the following steps:

[0050] S101, taking the control operation data generated by the power grid dispatching automation system as data to be sorted, sorting the fields of the data to be sorted, and performing redundancy processing on the sorted fields according to preset screening rules to obtain initial data;

[0051] Exemplarily, the data to be sorted is a large amount of operation data generated by the power grid dispatching automation system (OCS system), for example, data used to record the opening and closing of electrical equipment such as circuit breakers. The preset screening rules are formulated according to actual power grid rules. For example, tripping data does not need to be counted; the number of actions of automatic devices such as AVC (automatic voltage control) does not need to be counted.

[0052] In a possible implementation, the step of using the control operation data generated by the power grid dispatching automation system as the data to be sorted, sorting the fields of the data to be sorted, and de-redundanting the sorted fields according to preset screening rules to obtain the initial data includes:

[0053] Performing content recognition on the data to be sorted to obtain first type data and second type data in the data to be sorted;

[0054] Performing field sorting on the first type of data and the second type of data respectively to obtain a first field for representing device information corresponding to the data to be sorted and a second field for representing action information corresponding to the device information;

[0055] The first field and the second field are deduplicated according to the preset screening rules to obtain initial data.

[0056] Exemplarily, the control operation data generated by the power grid dispatching automation system is used as the data to be sorted. The process of field sorting of the data to be sorted can be understood as dividing the data to be sorted into a field representing device information (first field) and a field used to represent actions (second field), so as to facilitate subsequent data search based on dictionary data.

[0057] S102, storing the initial data using a preset template to obtain basic data;

[0058] For example, Figure 2 As shown, the OSC system source data (data to be sorted) is sorted, and the sorted data is imported into a template (preset template) through a tool for storage. Specifically, redundant data is filtered according to conditions (preset filtering rules) before the sorted data is imported into a template (preset template) through a tool for storage.

[0059] Exemplarily, the amount of data that has been stored is recorded so that the staff can understand the data entry status.

[0060] Exemplarily, the initial data is stored by using a preset template so that the format of the stored data is unified, which facilitates data query.

[0061] Exemplarily, the process of generating the preset template includes: acquiring the stored historical data, and determining the storage type and storage format of the historical data, and then generating the preset template according to the storage type and the storage format.

[0062] Exemplarily, the generation process of the preset template further includes: obtaining modification information of the user for the preset template, updating the preset template according to the modification information, storing the initial data through the updated preset template, and obtaining basic data.

[0063] S103 . According to the query information and preset dictionary data, determine data corresponding to the query information in the basic data as data to be displayed, and display the data to be displayed according to preset display rules.

[0064] In a possible real-time manner, before the step of determining, in the basic data, data corresponding to the query information as data to be displayed according to the query information and the preset dictionary data, and displaying the data to be displayed according to the preset display rule, the method further includes:

[0065] The preset dictionary data is constructed according to voltage level information and equipment classification information, wherein the voltage level information is used to map the identification information of the voltage level in the power grid dispatching automation system, and the equipment classification information is used to obtain equipment information from the dual equipment name of the initial data.

[0066] For example, Figure 3 As shown, by selecting the dictionary type, that is, selecting the type of dictionary to be maintained in the voltage level information and equipment classification information, enter the dictionary item name, that is, the name of the specific dictionary to be maintained, enter the dictionary item value, for example, fill in the dictionary value (voltage level id), such as 112871465660973061, enter the sort number and save the maintained dictionary. Specifically, the voltage level is used to associate the voltage level id in the power grid dispatching automation system (OCS system), such as the id is 112871465660973061, and the voltage level is 110kV; equipment classification, used to obtain equipment classification through keywords from the dual equipment names of the source data; such as switches, knife switches, etc., such as voltage levels; fill in the corresponding dictionary name, such as 110kV; fill in the sort, such as 3.

[0067] The control operation data generated by the power grid dispatching automation system is used as the data to be sorted, the fields of the data to be sorted are sorted, and the sorted fields are de-redundant according to preset screening rules to obtain initial data; the initial data is stored through a preset template to obtain basic data; according to query information and preset dictionary data, the data corresponding to the query information is determined in the basic data as the data to be displayed, and the data to be displayed is displayed according to preset display rules. The operation data (data to be sorted) generated by the power grid dispatching automation system (OCS system) can be flexibly stored and / or queried to improve the accuracy and efficiency of the statistics of integrated control data by power controllers, and avoid the problem of inaccurate query results due to human errors when manually counting items one by one according to dispatching operation instructions, and time-consuming and labor-intensive problems.

[0068] In a possible implementation, the step of performing redundancy processing on the first field and the second field according to a preset screening rule to obtain initial data includes:

[0069] Matching the first device information in the preset screening rule with the first field;

[0070] If the first device information matches the first field, matching the second field with the first action information corresponding to the first device information in the preset screening rule;

[0071] If the second field matches the first action information, the first field and the second field are regarded as redundant data, and the redundant data is deleted;

[0072] If the preset device information does not match the first field, matching the first field with the second device information in the preset screening rule;

[0073] If the second device information matches the first field, matching the second field with the second action information corresponding to the second device information in the preset screening rule;

[0074] If the second field matches the second action information, the first field and the second field are regarded as redundant data, and the redundant data is deleted.

[0075] Exemplarily, the “capacitor” (first device information) in the preset screening rule is matched with the first field;

[0076] If the first device information matches the first field, the second field is matched with “opening, closing” (first action information) corresponding to the first device information in the preset screening rule;

[0077] If the second field matches the first action information, the first field and the second field are regarded as redundant data, and the redundant data is deleted;

[0078] Specifically, the dual name of the device contains the string "capacitor", and the action is the data of opening and closing (the number of actions of the AVC automatic device does not need to be counted).

[0079] If the preset device information does not match the first field, the first field is matched with the "soft pressure plate" (second device information) in the preset screening rule;

[0080] If the second device information matches the first field, matching the second field with the “overlap” (second action information) corresponding to the second device information in the preset screening rule;

[0081] If the second field matches the second action information, the first field and the second field are regarded as redundant data, and the redundant data is deleted.

[0082] Specifically, the device dual name contains a "soft pressure plate" string and does not contain data of a "coincidence" string.

[0083] In a possible implementation manner, the step of performing redundancy processing on the first field and the second field according to a preset screening rule to obtain initial data further includes:

[0084] Determine action data of the same device within a preset time period according to the first field and the second field;

[0085] Determining whether the action data satisfies a preset condition in the preset screening rule;

[0086] If the action data meets the preset conditions in the preset screening rule, the first field and the second field are regarded as redundant data, and the redundant data is deleted.

[0087] Exemplarily, the preset condition is, for example, data of two actions within one minute (tripping data does not need to be counted).

[0088] In a possible implementation, the step of determining, in the basic data, data corresponding to the query information as data to be displayed based on the query information and preset dictionary data, and displaying the data to be displayed according to preset display rules includes:

[0089] Generate a query interface according to preset query information, and obtain user selection information for the query interface as the query information;

[0090] According to the query information and the preset dictionary data, determining data corresponding to the query information in the basic data as initial data to be displayed;

[0091] Using the data in the initial data to be displayed that meets the preset warning conditions in the preset display rules as data to be warned, and using the preset display mode in the preset display rules as the display mode of the data to be warned;

[0092] The data to be displayed is displayed in the display mode.

[0093] For example, dictionary data plays a vital role in data management and data use. First, dictionary data can help us better understand data. By recording the definition, description and relationship of data in detail, we can clearly understand the meaning and purpose of each data element. Secondly, data dictionary can improve the efficiency of data management. Through a unified data dictionary, you can quickly locate and find the required data assets and avoid data duplication and redundancy. In addition, data dictionary can also improve the efficiency of data use. Accurate data definition and description can help users find the required data faster and improve the value and utilization of data.

[0094] Exemplarily, the data in the initial data to be displayed that meets the preset alarm conditions in the preset display rules are used as the data to be warned, and the preset display mode in the preset display rules is used as the display mode of the data to be warned. For example, the query conditions can be entered, and combined queries can be performed according to the plant name (multiple selections), voltage level (multiple selections), equipment classification (multiple selections), equipment type (single selection), action date (time range), and dual equipment name (input fuzzy matching). The queried data is displayed in a list, and the number of actions of the dual equipment within 24 hours will be counted in the list. When the result is greater than or equal to 3, the data will be displayed in red font to serve as an alarm prompt.

[0095] Exemplarily, the process of displaying the data to be displayed according to preset display rules also includes: screen adaptation, specifically, generating corresponding configuration files for each preset display screen pixel parameter type; performing screen adaptation on the image to be displayed according to the configuration file corresponding to the display screen pixel width type of the current device; wherein the display screen pixel parameter type includes the pixel parameter type of a standard size display screen and / or the pixel parameter type of a non-standard size display screen; the configuration file contains a proportional value calculated according to the display screen pixel parameter type corresponding to the configuration file and the set reference display screen pixel parameter type.

[0096] Exemplarily, in an exemplary instance, generating a corresponding configuration file for each pre-set display pixel parameter type includes: generating a corresponding folder for each pre-set display pixel parameter type; generating a configuration file corresponding to each folder corresponding to each display pixel parameter type; performing screen adaptation on the image to be displayed according to the configuration file corresponding to the display pixel width type of the current device includes: loading a folder corresponding to the display pixel width type of the current device according to the display pixel width type of the current device; performing screen adaptation on the image to be displayed according to the configuration file corresponding to the loaded folder. In an exemplary instance, the display pixel parameter type includes a display pixel width type; generating a corresponding folder for each pre-set display pixel parameter type includes: generating a corresponding values ​​folder according to each display pixel width type. In the present application, the pre-set display pixel parameter types can be exhaustively derived based on third-party authoritative reports and cloud real machine test results, and when new display pixel parameter types appear, the types included in the pre-set display pixel parameter types can be increased accordingly.

[0097] In a possible implementation manner, the step of generating a query interface according to preset query information and obtaining user selection information for the query interface as the query information includes:

[0098] The user's authority information is obtained, and the query interface is generated according to preset query information corresponding to the authority information, and user selection information for the query interface is obtained as the query information.

[0099] Exemplarily, by querying the user's permission information, data security can be guaranteed. For example, when a low-authority person queries data, high-authority options will not be provided to the low-authority person, thereby preventing the low-authority person from querying high-authority data.

[0100] Exemplarily, the process of obtaining the user's permission information can be as follows: the user enters a personal username and password through the client; establishes a connection with the authorization server, and sends the username and password to the authorization server through the connection for authentication; the authorization server constructs a user permission feature code based on the user's permissions, and then notifies the client through the established connection; the specific operation steps include at least: using the client to encrypt the personal username and password, and then sending them to the authorization server; the authorization server monitors and receives user authentication requests; decrypts the personal username and password, and uses a high-speed user identity authentication function to authenticate the user identity; if the user identity authentication is successful, the user function permissions are obtained, and a user permission feature code representing the user permission information is constructed for return; the user permission feature code is encrypting, and the encrypted user permission feature code is sent to the client; the client configures the client according to the user permission feature code to achieve the connection between the client and the system, and when the client is successfully connected to the system, the query interface is provided to the user.

[0101] In a possible implementation, Figure 4 As shown, the present application provides a data query device for control operation data, the device comprising:

[0102] The data acquisition module 201 is used to use the control operation data generated by the power grid dispatching automation system as the data to be sorted, sort the fields of the data to be sorted, and perform redundancy processing on the sorted fields according to preset screening rules to obtain initial data;

[0103] An input module 202 is used to store the initial data through a preset template to obtain basic data;

[0104] The display module 203 is used to determine data corresponding to the query information in the basic data as data to be displayed according to the query information and preset dictionary data, and display the data to be displayed according to preset display rules.

[0105] In a possible implementation, the data acquisition module 201 is used to:

[0106] Performing content recognition on the data to be sorted to obtain first type data and second type data in the data to be sorted;

[0107] Performing field sorting on the first type of data and the second type of data respectively to obtain a first field for representing device information corresponding to the data to be sorted and a second field for representing action information corresponding to the device information;

[0108] The first field and the second field are deduplicated according to a preset screening rule to obtain initial data.

[0109] In a possible implementation, the data acquisition module 201 is used to:

[0110] Matching the first device information in the preset screening rule with the first field;

[0111] If the first device information matches the first field, matching the second field with the first action information corresponding to the first device information in the preset screening rule;

[0112] If the second field matches the first action information, the first field and the second field are regarded as redundant data, and the redundant data is deleted;

[0113] If the preset device information does not match the first field, matching the first field with the second device information in the preset screening rule;

[0114] If the second device information matches the first field, matching the second field with the second action information corresponding to the second device information in the preset screening rule;

[0115] If the second field matches the second action information, the first field and the second field are regarded as redundant data, and the redundant data is deleted.

[0116] In a possible implementation, the data acquisition module 201 is used to:

[0117] Determine action data of the same device within a preset time period according to the first field and the second field;

[0118] Determining whether the action data satisfies a preset condition in the preset screening rule;

[0119] If the action data meets the preset conditions in the preset screening rule, the first field and the second field are regarded as redundant data, and the redundant data is deleted.

[0120] In a possible implementation, the display module 203 is used to:

[0121] The preset dictionary data is constructed according to voltage level information and equipment classification information, wherein the voltage level information is used to map the identification information of the voltage level in the power grid dispatching automation system, and the equipment classification information is used to obtain equipment information from the dual equipment name of the initial data.

[0122] In a possible implementation, the display module 203 is used to:

[0123] Generate a query interface according to preset query information, and obtain user selection information for the query interface as the query information;

[0124] According to the query information and the preset dictionary data, determining data corresponding to the query information in the basic data as initial data to be displayed;

[0125] Using the data in the initial data to be displayed that meets the preset warning conditions in the preset display rules as data to be warned, and using the preset display mode in the preset display rules as the display mode of the data to be warned;

[0126] The data to be displayed is displayed in the display mode.

[0127] In a possible implementation, the display module 203 is used to:

[0128] Obtaining the user's authority information, generating the query interface according to the preset query information corresponding to the authority information, and obtaining the user selection information for the query interface as the query information

[0129] The control operation data generated by the power grid dispatching automation system is used as the data to be sorted, the fields of the data to be sorted are sorted, and the sorted fields are de-redundant according to preset screening rules to obtain initial data; the initial data is stored through a preset template to obtain basic data; according to query information and preset dictionary data, the data corresponding to the query information is determined in the basic data as the data to be displayed, and the data to be displayed is displayed according to preset display rules. The operation data (data to be sorted) generated by the power grid dispatching automation system (OCS system) can be flexibly stored and / or queried to improve the accuracy and efficiency of the statistics of integrated control data by power controllers, and avoid the problem of inaccurate query results due to human errors when manually counting items one by one according to dispatching operation instructions, and time-consuming and labor-intensive problems.

[0130] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 5As shown. The computer device includes a processor, a memory, a network interface and a database connected via a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile and / or volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with an external client via a network connection. When the computer program is executed by the processor, it implements a function or step on the server side of a data query method for regulating operation data.

[0131] In one embodiment, a computer device is provided. The computer device may be a client, and its internal structure diagram may be as follows: Figure 6 As shown. The computer device includes a processor, a memory, a network interface, a display screen and an input device connected via a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with an external server via a network connection. When the computer program is executed by the processor, it implements a function or step on the client side of a data query method for regulating operation data.

[0132] In one embodiment, a computer device is proposed, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the following steps when executing the computer program: using the control operation data generated by the power grid dispatching automation system as data to be sorted, sorting the fields of the data to be sorted, and de-redundanting the sorted fields according to preset screening rules to obtain initial data; storing the initial data through a preset template to obtain basic data; determining, according to query information and preset dictionary data, data corresponding to the query information in the basic data as data to be displayed, and displaying the data to be displayed according to preset display rules.

[0133] In one embodiment, a computer-readable storage medium is proposed, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the following steps are implemented: using the control operation data generated by the power grid dispatching automation system as the data to be sorted, sorting the fields of the data to be sorted, and de-redundanting the sorted fields according to preset screening rules to obtain initial data; storing the initial data through a preset template to obtain basic data; determining, according to the query information and preset dictionary data, data corresponding to the query information in the basic data as the data to be displayed, and displaying the data to be displayed according to preset display rules.

[0134] It should be noted that the above functions or steps that can be implemented by the computer-readable storage medium or computer device can refer to the relevant descriptions on the server side and the client side in the aforementioned method embodiment. To avoid repetition, they will not be described one by one here.

[0135] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

[0136] Those skilled in the art can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example. In actual applications, the above-mentioned functions can be distributed and completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above.

[0137] The embodiments described above are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be included in the protection scope of the present invention.

Claims

1. A data query method for control operation data, characterized in that: The method comprises: The control operation data generated by the power grid dispatching automation system is used as the data to be sorted, the fields of the data to be sorted are sorted, and the sorted fields are de-redundant according to preset screening rules to obtain initial data; The initial data is stored by using a preset template to obtain basic data; According to the query information and preset dictionary data, data corresponding to the query information is determined in the basic data as data to be displayed, and the data to be displayed is displayed according to preset display rules.

2. The data query method for control operation data according to claim 1, characterized in that: The step of using the control operation data generated by the power grid dispatching automation system as the data to be sorted, sorting the fields of the data to be sorted, and performing redundancy processing on the sorted fields according to preset screening rules to obtain the initial data includes: Performing content recognition on the data to be sorted to obtain first type data and second type data in the data to be sorted; Performing field sorting on the first type of data and the second type of data respectively to obtain a first field for representing device information corresponding to the data to be sorted and a second field for representing action information corresponding to the device information; The first field and the second field are deduplicated according to a preset screening rule to obtain initial data.

3. The data query method for control operation data according to claim 2, characterized in that: The step of performing redundancy processing on the first field and the second field according to the preset screening rule to obtain initial data includes: Matching the first device information in the preset screening rule with the first field; If the first device information matches the first field, matching the second field with the first action information corresponding to the first device information in the preset screening rule; If the second field matches the first action information, the first field and the second field are regarded as redundant data, and the redundant data is deleted; If the preset device information does not match the first field, matching the first field with the second device information in the preset screening rule; If the second device information matches the first field, matching the second field with the second action information corresponding to the second device information in the preset screening rule; If the second field matches the second action information, the first field and the second field are regarded as redundant data, and the redundant data is deleted.

4. The data query method for control operation data according to claim 2, characterized in that: The step of performing redundancy processing on the first field and the second field according to the preset screening rule to obtain initial data also includes: Determine action data of the same device within a preset time period according to the first field and the second field; Determining whether the action data satisfies a preset condition in the preset screening rule; If the action data meets the preset conditions in the preset screening rule, the first field and the second field are regarded as redundant data, and the redundant data is deleted.

5. The data query method for control operation data according to claim 1, characterized in that: Before the step of determining data corresponding to the query information in the basic data as data to be displayed according to the query information and the preset dictionary data, and displaying the data to be displayed according to the preset display rules, the method further includes: The preset dictionary data is constructed according to voltage level information and equipment classification information, wherein the voltage level information is used to map the identification information of the voltage level in the power grid dispatching automation system, and the equipment classification information is used to obtain equipment information from the dual equipment name of the initial data.

6. The data query method for control operation data according to claim 1, characterized in that: The step of determining data corresponding to the query information in the basic data as data to be displayed according to the query information and preset dictionary data, and displaying the data to be displayed according to preset display rules includes: Generate a query interface according to preset query information, and obtain user selection information for the query interface as the query information; According to the query information and the preset dictionary data, determining data corresponding to the query information in the basic data as initial data to be displayed; Using the data in the initial data to be displayed that meets the preset warning conditions in the preset display rules as data to be warned, and using the preset display mode in the preset display rules as the display mode of the data to be warned; The data to be displayed is displayed in the display mode.

7. The data query method for control operation data according to claim 6, characterized in that: The step of generating a query interface according to preset query information and obtaining user selection information for the query interface as the query information includes: The user's authority information is obtained, and the query interface is generated according to preset query information corresponding to the authority information, and user selection information for the query interface is obtained as the query information.

8. A data query device for control operation data, characterized in that: The device comprises: The data acquisition module is used to use the control operation data generated by the power grid dispatching automation system as the data to be sorted, sort the fields of the data to be sorted, and perform redundancy processing on the sorted fields according to preset screening rules to obtain initial data; An input module, used to store the initial data through a preset template to obtain basic data; The display module is used to determine data corresponding to the query information in the basic data as data to be displayed according to the query information and preset dictionary data, and to display the data to be displayed according to preset display rules.

9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the data query method for control operation data as described in any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the data query method for control operation data as described in any one of claims 1 to 7 are implemented.

Images