Power grid dispatching automation report management method based on dispatching automation system

Abstract

The invention provides a power grid dispatching automation report management method based on a dispatching automation system, and the method comprises the steps: report configuration: configuring a display field and a query condition field; the configuration of the display field comprises defining tables and fields needing to be displayed in the report, and the configuration of the query condition field comprises configuring one table according to which fields can be queried; report design: designing a report style required by a user through an Excel-like table designer; the method comprises the following steps: dragging a table and a field which need to be displayed in a report to a specified position of an Excel-like table control, and automatically generating a query condition control according to a query field configured by a current table in report configuration; and report query: automatically querying, sorting, screening and filtering data according to the dragged fields, the configured attributes, the set query conditions and the query time during report design, and displaying a query result. According to the method, the actual business requirements and database design characteristics of the power grid dispatching report are fully considered, the engineering deployment can be effectively simplified, and the user experience is optimized.

Description

Technical Field

[0001] The present invention relates to the technical field of power grid dispatching automation report management, and in particular to a power grid dispatching automation report management method based on a dispatching automation system. Background Art

[0002] With the rapid development of the power industry and the advancement of smart grid construction, the power grid dispatching automation system has become the core key system for the operation of the power system. As an important part of the power grid dispatching automation system, the power grid dispatching automation report management system is of great significance for ensuring the safe and efficient operation of the power system. It provides important data support for the professional personnel of power companies to conduct grid load analysis, alarm statistical analysis, equipment status evaluation and grid development planning through query statistics, analysis and display of massive historical data of the dispatching automation system. It is an important data source for the daily work of various professional grids. After years of development, the existing dispatching report management function still has the disadvantages of large workload, high difficulty, difficult to learn, complex production process, poor flexibility and low adaptability in the actual application process, which cannot meet the flexible and changeable report data query business needs. Therefore, it has become an urgent need for power companies to develop a set of simple, easy-to-use, flexible and convenient power grid dispatching automation report management system with high practical level.

[0003] In order to solve the problems existing in the dispatching automation report management system, dispatching departments at all levels have introduced third-party general report management systems, such as Fanruan, and developed customized report management systems according to their own business needs. However, the existing reports focus on building a third-party data sharing platform, which has disadvantages such as large investment, large data integration workload, and large maintenance workload, and still cannot solve the pain points of the existing reporting system. There is an urgent need for an automated report management method that can rely on the current dispatching automation system and is designed and developed based on the database structure characteristics of the current dispatching automation system and the historical inventory access method. Summary of the invention

[0004] The present invention aims to solve at least one of the above-mentioned technical problems existing in the prior art.

[0005] To this end, a first aspect of the present invention provides a power grid dispatching automation report management method based on a dispatching automation system.

[0006] The present invention provides a power grid dispatching automation report management method based on a dispatching automation system, wherein the data dictionary table of the dispatching automation system includes a table information table and a domain information table; wherein the table information table is used to store attribute information of all tables related to the dispatching automation system, and the domain information table stores attribute information of all fields related to the dispatching automation system; the method comprises:

[0007] Report configuration, the report configuration includes display field configuration and query condition field configuration; the display field configuration includes defining the tables and fields that the report needs to display, wherein the user can configure the tables and fields that the user needs to care about in advance through the display field configuration function, that is, determine the selection range; the query condition field configuration includes configuring which fields a table can be queried based on;

[0008] Report design, design the report style required by the user through the Excel-like table designer; drag the table and fields to be displayed in the report to the specified position of the Excel-like table control, automatically generate the query condition control according to the query field of the current table configuration in the report configuration, set the data acquisition method of the field, and define the data statistics type of the cell;

[0009] Report query, automatically query, sort, screen, and filter data according to the fields dragged during report design, configured properties, set query conditions and query time, and display the query results in the format specified during report design; among them, the query method includes automatically generating query SQL statements based on the tables and fields dragged by the user and the foreign key reference relationship between tables, and querying the database of the scheduling automation system through the database access interface.

[0010] The power grid dispatching automation report management method based on the dispatching automation system according to the above technical solution of the present invention may also have the following additional technical features:

[0011] In the above technical solution, the tables and fields that the user needs to be concerned about include a device table or an alarm table, and the device table and the alarm table are stored in a scheduling automation system.

[0012] In the above technical solution, the Excel-like table designer has a report design interface, which includes a display field list area, a report query condition area, an Excel-like table control area, and a field property configuration area;

[0013] When designing a report, use the mouse to drag the table or field that needs to be displayed in the report from the display field list area to the specified position in the Excel-like table control area. The designer automatically generates query condition controls in the report query condition area based on the query fields configured in the current table in the report configuration; click the dragged field on the table, and the field property configuration area lists the property information of the field.

[0014] In the above technical solution, the attribute information includes: data acquisition method, sorting method, statistical type, filtering method and mathematical function.

[0015] In the above technical solution, the automatic generation of the query condition control according to the query field of the current table configuration in the report configuration includes:

[0016] Automatically generate query condition controls according to the data type of the field and the foreign key reference relationship; the data type of the field includes string type, numeric type and time type;

[0017] Among them, the query fields of string type and numeric type generate text input box controls;

[0018] A query field of the time type generates a time selection control.

[0019] In the above technical solution, the data acquisition method of the setting field includes:

[0020] Define the way to obtain data from the database for the current field;

[0021] The data acquisition methods include: directly querying the database according to the field, querying the database by configuring SQL, statistical analysis through custom functions, automatically expanding according to the result data of the field, and directly associating with specified records in the database.

[0022] In the above technical solution, the data statistics type of the defined cell includes:

[0023] Determine the statistical type of the current field in the cell, where the statistical types include maximum value, minimum value, average value, sum, and peak-to-valley difference.

[0024] In the above technical solution, the report query includes:

[0025] Read the report design style content, and parse and display fields, field attributes, query condition fields, and report formats according to the report style content;

[0026] Traverse the displayed fields and determine whether the current field is a telemetry sampling field according to the configuration of the domain information table of the scheduling automation system;

[0027] For fields that are not telemetry sampling fields, add the fields to the query field list, and automatically generate query statements based on the query field list and the query condition fields set by the user;

[0028] For telemetry sampling fields, you need to query the history table and history domain of the telemetry sampling data storage of the field according to the telemetry sampling definition table, and then compose a new SQL statement based on the history table and history domain for query;

[0029] Join the query result data of all fields to obtain the report query result data;

[0030] The report query result data is grouped, filtered, and sorted before being displayed in the designed style.

[0031] In the above technical solution, for the field that is a telemetry sampling field, it is necessary to first query the history table and history domain of the telemetry sampling data storage of the field according to the telemetry sampling definition table, and then compose a new SQL according to the history table and history domain for query, including:

[0032] Add the fields to the query field list, and automatically generate query statements based on the query field list and the query condition fields set by the user to obtain the record ID;

[0033] Unify the base of record ID and telemetry sampling field ID;

[0034] The record ID and the telemetry sampling field ID are ANDed to obtain the telemetry ID.

[0035] According to the telemetry ID, the historical table and historical domain storing the sampling value of the field are read from the telemetry sampling definition table of the scheduling automation system.

[0036] In the above technical solution, the group statistics include: grouping the report query result data according to the grouping criteria, and calculating the average value, sum, maximum value, minimum value or quantity of each group of data according to the statistical needs;

[0037] The data sorting includes: using a TreeMap algorithm to sort and display at least one column of query results in the report query result data.

[0038] In summary, due to the adoption of the above technical features, the beneficial effects of the present invention are:

[0039] The power grid dispatching automation report management method proposed in the present invention can be deeply integrated into the current dispatching automation system (D5000), fully considering the actual business needs and database design characteristics of the power grid dispatching report, simplifying project deployment, optimizing user experience, reducing user investment, and solving the pain points of the existing report system such as complex design, high learning difficulty, and difficulty in data acquisition, providing strong data support for the development of power grid dispatching, analysis, planning and other work.

[0040] Additional aspects and advantages of the present invention will become apparent from the following description or may be learned by practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] The above and / or additional aspects and advantages of the present invention will become apparent and easily understood from the description of the embodiments in conjunction with the following drawings, in which:

[0042] Figure 1 This is a system architecture diagram of a power grid dispatching automation report management method based on a dispatching automation system according to an embodiment of the present invention;

[0043] Figure 2 It is a schematic diagram of a report design interface in a power grid dispatch automation report management method based on a dispatch automation system according to an embodiment of the present invention;

[0044] Figure 3 The present invention is a report query flow chart of a method for managing power grid dispatching automation reports based on a dispatching automation system according to an embodiment of the present invention. DETAILED DESCRIPTION

[0045] In order to more clearly understand the above-mentioned purpose, features and advantages of the present invention, the present invention is further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that the embodiments of the present application and the features in the embodiments can be combined with each other without conflict.

[0046] In the following description, many specific details are set forth to facilitate a full understanding of the present invention. However, the present invention may also be implemented in other ways different from those described herein. Therefore, the protection scope of the present invention is not limited to the specific embodiments disclosed below.

[0047] Refer to the following Figures 1 to 3 The following describes a power grid dispatching automation report management method based on a dispatching automation system according to some embodiments of the present invention.

[0048] Some embodiments of the present application provide a method for managing power grid dispatching automation reports based on a dispatching automation system. The D5000 dispatching automation system is currently the mainstream power grid dispatching automation system for provincial and prefectural dispatching of the State Grid and the Southern Power Grid. In the present disclosure, the research is mainly based on the D5000 system, and the design and development are fully considered with full consideration of the database structure characteristics and historical library access methods of the D5000 system. Among them, the data dictionary table of the dispatching automation system D5000 includes a table information table and a domain information table; the table information table is used to store the attribute information of all tables related to the dispatching automation system, and the domain information table stores the attribute information of all fields related to the dispatching automation system.

[0049] Reports are used to dynamically display data in the form of tables, charts, etc. The source of data can be a database, document, interface, etc. The report management method referred to in this disclosure refers to using tables to dynamically query and display D5000 scheduling automation database data.

[0050] The first embodiment of the present invention proposes a power grid dispatching automation report management method based on a dispatching automation system, which mainly includes three parts: report configuration, report design and report query. Using an Excel-like table designer, drag the tables and fields that need to be displayed in the report to the corresponding position of the table by dragging. When querying the report, the query SQL (Structured Query Language) statement is automatically generated according to the tables and fields dragged by the user and the foreign key reference relationship between the tables, and the database is queried through the database access interface. When querying the report, if the report field is not a telemetry sampling field, the database is directly queried according to the automatically assembled SQL. If the dragged field is a telemetry sampling field, it is necessary to query the historical table and historical domain of the telemetry sampling data storage of the field according to the telemetry sampling definition table, and then assemble the new SQL according to the historical table and historical domain for query. Finally, the obtained result data set is further processed, such as summary statistics, sorting, numerical filtering and function calculation before display, and supports exporting the report query data into Excel files. The report management system architecture built based on the disclosed method is as follows: Figure 1 As shown below, report configuration, report design and report query will be described respectively.

[0051] Report configuration: The report configuration includes display field configuration and query condition field configuration; the display field configuration includes defining the tables and fields that the report needs to display, wherein the user can configure the tables and fields that the user needs to care about in advance through the display field configuration function, that is, determine the selection range; the query condition field configuration includes configuring which fields a table can be queried based on.

[0052] Specifically, since there are thousands of tables in the dispatching automation system D5000, each table has dozens or even hundreds of fields, and professional users are not familiar with the table structure of D5000, in order to enable users to quickly and conveniently select the fields to be displayed when designing reports, users can use the display field configuration function to configure the tables and fields that users need to care about in advance, generally equipment tables and alarm tables, with several to a dozen fields in each table. This can greatly reduce the difficulty of defining display fields when users design reports.

[0053] After the above report configuration, the system can automatically generate query SQL based on user-defined tables and fields when querying reports. Usually, users do not need to query the data of the entire table, and generally filter the table data according to actual business needs. The report query field configuration function is used to configure which fields a table is queried based on. Accurate queries can be achieved by combining query fields from multiple tables.

[0054] Report design: The report design uses an Excel-like table designer to design the report style required by the user; wherein, the table and fields to be displayed in the report are dragged to the specified position of the Excel-like table control, and the query condition control is automatically generated according to the query field of the current table configuration in the report configuration, and the data acquisition method of the field is set, and the data statistical type of the cell is defined.

[0055] The Excel-like table designer refers to a tool that imitates the functions and interface of Excel and allows users to create, edit and design tables in a similar way to Excel. This concept is clear to those skilled in the art and will not cause misunderstanding. In some embodiments, the report design interface of the Excel-like table designer includes a display field list area, a report query condition area, an Excel-like table control area and a field property configuration area.

[0056] like Figure 2 As shown, in a specific embodiment, the left side of the report design interface is a display field list area configured in the report configuration, the middle is a report query condition area and an Excel-like table control area, and the right side is a field attribute configuration area. When designing a report, use the mouse to drag the fields that need to be displayed in the report from the list on the left to the specified position of the Excel-like table control. The designer automatically generates a query condition control in the report query condition area according to the query field configured in the table in the report configuration. Click the dragged field on the table, and the field attribute configuration area lists the attribute information of the field, including data acquisition method, sorting method, statistical type, filtering method, mathematical function, etc.

[0057] In some embodiments, since the fields of the database have multiple data types, such as string type, numeric type, and time type, there will be foreign key reference relationships between the fields of different tables. When the report system generates a query condition control that can be set by the user based on the configured query field, it is necessary to automatically generate different controls based on the different data types and foreign key reference relationships of the field. For example: query fields of string type and numeric type generate text input box controls, query fields with foreign key reference relationships generate drop-down box controls, and query fields of time type generate time selection controls.

[0058] In some embodiments, when dragging a display field onto a table, it is necessary to define the data acquisition method for the field from the database. The present disclosure designs five data acquisition methods. The first is to directly query the database based on the field; the second is to query the database by configuring SQL; the third is to perform statistical analysis through custom functions; the fourth is to automatically expand the result data based on the field; and the fifth is to directly associate the specified record in the library.

[0059] Specifically, the first method of querying the database based on the displayed fields is to automatically generate query SQL based on the dragged displayed fields, and call the database interface to execute SQL to obtain data. For example, query the device name, plant station name, voltage level, etc.

[0060] The second method of querying the database by configuring SQL is mainly for situations where there is no ready-made data in the database, and it is cumbersome to write a separate program for statistics and the scalability is poor. There are two situations for querying the database by configuring SQL. One situation is to display the queried data directly as the result, such as counting five types of alarms. The other situation is that the queried data needs to be queried twice, and the data after the second query is displayed as the result. For example, to query the maximum load of the same interval line of the main transformer, you need to find out the line ID first, and then query the maximum value of the line in the history database according to the line ID.

[0061] The third statistical analysis method through custom functions is mainly aimed at the statistics and analysis of complex indicator data. In addition to conventional data queries, users often need to perform multi-dimensional data analysis, arbitrary combination drilling and in-depth calculation based on existing data. For example, statistics on the duration of violations, the number of violations, and the period of violations. These complex indicator data cannot be obtained by directly querying the database or configuring SQL. The method of custom functions has good scalability and high consistency with other data acquisition methods, which is easy for users to understand and use.

[0062] The fourth automatic expansion method based on the result data of a field is to automatically query the related data based on the query result data of the field, such as day-on-day, week-on-week, month-on-month and year-on-year data.

[0063] The fifth method of directly associating a specified record in the library is to directly define the specified record ID in the library corresponding to the cell. The system lists all the records in the table according to the table corresponding to the field, and the user can select the corresponding record ID.

[0064] In some embodiments, since it is often necessary to summarize and count massive amounts of grid operation data in grid analysis, dispatching and planning in order to better analyze and understand the operation mode of the grid, the data statistics type of the cell can be defined when designing the report, such as maximum value, minimum value, average value, total and peak-to-valley difference.

[0065] Report query: automatically query, sort, screen, and filter data according to the fields dragged, configured properties, set query conditions, and query time during report design, and display the query results in the format specified during report design; the query method includes automatically generating query SQL statements based on the tables and fields dragged by the user and the foreign key reference relationship between tables, and querying the database of the scheduling automation system through the database access interface.

[0066] In some embodiments, the report query mainly includes the following steps S1-S6.

[0067] S1. Read the report design style content, and parse and display fields, field attributes, query condition fields, and report formats according to the report style content.

[0068] Specifically, in the present disclosure, the report design style content adopts Json (a lightweight data exchange format) format. Based on this, the Json parser provided by Java can be used to parse the report design style content into display fields, field attributes, query condition fields and report formats.

[0069] S2. Traverse the displayed fields and determine whether the current field is a telemetry sampling field according to the configuration of the domain information table of the dispatching automation system D5000.

[0070] S3. For fields that are not telemetry sampling fields, add the fields to the query field list, and automatically generate a query statement based on the query field list and the query condition fields set by the user.

[0071] In a specific embodiment, the query statement generated is as follows:

[0072] Select the query field list from the table

[0073] where query condition field list

[0074] In the above query statements, the word after Select indicates the filtered content, the word after from indicates the location where the filtered content comes from, and the word after where indicates the filtering conditions.

[0075] S4. For the telemetry sampling field, it is necessary to first query the historical table and historical domain of the telemetry sampling data storage of the field according to the telemetry sampling definition table, and then compose a new SQL based on the historical table and historical domain for query.

[0076] Specifically, step S4 includes steps S41-S44.

[0077] S41. Add the field to the query field list, and automatically generate a query statement based on the query field list and the query condition field set by the user to obtain the record ID.

[0078] S42. Unify the recording ID and the telemetry sampling field ID. In a specific embodiment, the telemetry sampling field ID is converted into hexadecimal using the Java Integer.toHexString function. For example, hex_yc_field_id is defined as the hexadecimal code of the telemetry sampling field ID after conversion, and yc_field_id is the decimal code before conversion, then:

[0079] hex_yc_field_id=Integer.toHexString(yc_field_id).

[0080] S43, performing an AND operation on the record ID and the telemetry sampling field ID to obtain a telemetry ID, including:

[0081] Telemetry ID = record ID & hex_yc_field_id.

[0082] S44, read the history table and history domain storing the field sampling value from the telemetry sampling definition table of the dispatch automation system according to the telemetry ID. In a specific embodiment, the generated SQL, i.e., the query statement is as follows:

[0083] Select history_table_name,history_column_name

[0084] from svr_yc_sample_define

[0085] where yc_id = telemetry ID

[0086] Among them, history_table_name is the history table name, history_column_name is the history domain name, and svr_yc_sample_define is the telemetry sampling definition table of D5000.

[0087] In some embodiments, it is also necessary to determine whether the current field query is statistical data or historical data. If the field query is statistical data, the historical table name in step S44 needs to be replaced with the statistical table name. The historical table of the D5000 system starts with YC_HS and the statistical table starts with YC_STAT. Therefore, the statistical table name of the field can be obtained by replacing HS in the historical table name of the field with STAT.

[0088] S5. Join the query result data of all fields to obtain report query result data.

[0089] S6. After grouping, filtering and sorting the report query result data, the data is displayed in the designed style.

[0090] Specifically, grouping statistics of report data is a data analysis method that groups data according to certain standards and then performs statistics on each group to reveal the correlation and internal structure between the data. The method proposed in this disclosure supports further grouping statistics of data based on the data query results. For example, the number of remote signal change alarms can be counted by substation, and the three-side unbalance can be counted by transformer. The steps of grouping statistics are as follows:

[0091] The report query result data is grouped according to the grouping criteria. First, select appropriate grouping criteria according to the purpose of analysis, such as substation, equipment name, etc., to divide the data into different groups. In a specific embodiment, the HashMap provided by Java is used to automatically group the data. HashMap is a storage mechanism based on Key-Value. Define the following variables:

[0092] HashMap <String,List <object>>stat_map

[0093] Among them, key stores the grouping field, and value stores the grouped query result data list.

[0094] Based on the data grouping, data statistical operations are performed, and the average value, total, maximum value, minimum value and quantity of each group are obtained by calculating the value of stat_map.

[0095] In some embodiments, the data sorting includes: using a TreeMap algorithm to sort and display at least one column of query results in the report query result data.

[0096] Specifically, when displaying a report, it is usually necessary to sort and display the query results according to one or more columns. TreeMap is a Map based on a red-black tree provided by Java. Its key-value pairs are sorted according to the natural order of the keys. In a specific embodiment, a 5-level TreeMap is defined to realize automatic sorting of data, and a maximum of 5 fields are supported for sorting. For example, the following resultSortTreeMap is defined:

[0097] TreeMap <String,TreeMap<String,TreeMap<String,TreeMap<String,TreeMap<String,Object> >>>>resultSortTreeMap

[0098] The query result data is put into resultSortTreeMap in the order of the sorting fields. After being automatically sorted by the sorting mechanism of TreeMap, it is taken out and put into a list for data display.

[0099] Based on any of the above embodiments, a power grid dispatching automation report management system can be developed. In a specific embodiment, the power grid dispatching automation report management system adopts a B / S architecture, is deployed in the safety zone III, and has functions such as report configuration, report design, report query function and report display. It supports the generation of reports based on multi-dimensional data such as model data, alarm data, sampling data, extreme value data, etc. The system does not require additional software and hardware investment, no intermediate library, and no need to maintain data sets. It shares the database and server of the D5000 system, and the installation and deployment are simple and convenient. It provides a set of flexible, convenient, easy-to-use report management system that meets the actual needs of actual business for various professionals such as dispatching, mode, substation and planning.

[0100] In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described can be combined in any one or more embodiments or examples in a suitable manner.

[0101] Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the protection scope of the present invention.< / object>

Claims

1. A method for managing power grid dispatching automation reports based on a dispatching automation system, wherein the data dictionary table of the dispatching automation system includes a table information table and a domain information table; wherein: The table information table is used to store the attribute information of all tables related to the scheduling automation system, and the field information table stores the attribute information of all fields related to the scheduling automation system; characterized in that the method includes: Report configuration, the report configuration includes display field configuration and query condition field configuration; the display field configuration includes defining the tables and fields that the report needs to display, wherein the user can configure the tables and fields that the user needs to care about in advance through the display field configuration function, that is, determine the selection range; the query condition field configuration includes configuring which fields a table can be queried based on; Report design, design the report style required by the user through the Excel-like table designer; drag the table and fields to be displayed in the report to the specified position of the Excel-like table control, automatically generate the query condition control according to the query field of the current table configuration in the report configuration, set the data acquisition method of the field, and define the data statistics type of the cell; Report query, automatically query, sort, screen, and filter data according to the fields dragged during report design, configured properties, set query conditions and query time, and display the query results in the format specified during report design; among them, the query method includes automatically generating query SQL statements based on the tables and fields dragged by the user and the foreign key reference relationship between tables, and querying the database of the scheduling automation system through the database access interface.

2. The power grid dispatching automation report management method based on the dispatching automation system according to claim 1 is characterized in that: The tables and fields that the user needs to be concerned about include a device table or an alarm table, and the device table and the alarm table are stored in the dispatching automation system.

3. The power grid dispatching automation report management method based on the dispatching automation system according to claim 1 is characterized in that: The Excel-like table designer has a report design interface, which includes a display field list area, a report query condition area, an Excel-like table control area, and a field property configuration area; When designing a report, use the mouse to drag the table or field that needs to be displayed in the report from the display field list area to the specified position in the Excel-like table control area. The designer automatically generates query condition controls in the report query condition area based on the query fields configured in the current table in the report configuration; click the dragged field on the table, and the field property configuration area lists the property information of the field.

4. The power grid dispatching automation report management method based on the dispatching automation system according to claim 3 is characterized in that: The attribute information includes: data acquisition method, sorting method, statistical type, filtering method and mathematical function.

5. The power grid dispatching automation report management method based on the dispatching automation system according to claim 1 is characterized in that: The automatic generation of query condition controls according to the query fields of the current table configuration in the report configuration includes: Automatically generate query condition controls according to the data type of the field and the foreign key reference relationship; the data type of the field includes string type, numeric type and time type; Among them, the query fields of string type and numeric type generate text input box controls; A query field of the time type generates a time selection control.

6. The power grid dispatching automation report management method based on the dispatching automation system according to claim 1 is characterized in that: The data acquisition method of the setting field includes: Define the way to obtain data from the database for the current field; The data acquisition methods include: directly querying the database according to the field, querying the database by configuring SQL, statistical analysis through custom functions, automatically expanding according to the result data of the field, and directly associating with specified records in the database.

7. The power grid dispatching automation report management method based on the dispatching automation system according to claim 1 is characterized in that: The data statistics type of the defined cell includes: Determine the statistical type of the current field in the cell, where the statistical types include maximum value, minimum value, average value, sum, and peak-to-valley difference.

8. The power grid dispatching automation report management method based on the dispatching automation system according to claim 1 is characterized in that: The report query includes: Read the report design style content, and parse and display fields, field attributes, query condition fields, and report formats according to the report style content; Traverse the displayed fields and determine whether the current field is a telemetry sampling field according to the configuration of the domain information table of the scheduling automation system; For fields that are not telemetry sampling fields, add the fields to the query field list, and automatically generate query statements based on the query field list and the query condition fields set by the user; For telemetry sampling fields, you need to query the history table and history domain of the telemetry sampling data storage of the field according to the telemetry sampling definition table, and then compose a new SQL statement based on the history table and history domain for query; Join the query result data of all fields to obtain the report query result data; The report query result data is grouped, filtered, and sorted before being displayed in the designed style.

9. The power grid dispatching automation report management method based on the dispatching automation system according to claim 8, characterized in that: For the telemetry sampling field, it is necessary to first query the history table and history domain of the telemetry sampling data storage of the field according to the telemetry sampling definition table, and then compose a new SQL to query according to the history table and history domain, including: Add the fields to the query field list, and automatically generate query statements based on the query field list and the query condition fields set by the user to obtain the record ID; Unify the base of record ID and telemetry sampling field ID; The record ID and the telemetry sampling field ID are ANDed to obtain the telemetry ID. According to the telemetry ID, the historical table and historical domain storing the sampling value of the field are read from the telemetry sampling definition table of the scheduling automation system.

10. The power grid dispatching automation report management method based on the dispatching automation system according to claim 8, characterized in that: The grouping statistics include: grouping the report query result data according to the grouping criteria, and calculating the average value, sum, maximum value, minimum value or quantity of each group of data according to the statistical needs; The data sorting includes: using a TreeMap algorithm to sort and display at least one column of query results in the report query result data.

Images