Index analysis system based on electrical public information dynamic query language model splicing

Through the index analysis system based on the splicing of the dynamic query language model of electrical public information, the problem of difficulty in flexibly adjusting traditional analysis methods is solved, and the analysis model is dynamically constructed, which improves the analysis efficiency and accuracy.

CN119903091APending Publication Date: 2025-04-29NR ELECTRIC CO LTD +1
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411111923.4
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-14
Publication Date
2025-04-29

AI Technical Summary

Technical Problem

Traditional indicator analysis methods are limited by fixed programming logic, and are difficult to make flexibly adjust according to actual needs, and cannot fully meet the rapidly changing analysis needs.

Method used

An index analysis system based on the splicing of dynamic query language models of electrical public information is adopted. Through the dynamic query model library, model generation module, data management module and analysis execution module, users are allowed to dynamically build and configure the index analysis model.

Benefits of technology

It realizes the dynamic construction of indicator analysis models based on actual needs, adapt to changing analysis scenarios, obtain accurate and comprehensive electrical indicator analysis results, and improves the efficiency and accuracy of data analysis.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119903091A_ABST
    Figure CN119903091A_ABST
Patent Text Reader

Abstract

The invention discloses an index analysis system based on electrical public information dynamic query language model splicing, and the system comprises a dynamic query model library which is configured to store electrical public information dynamic query language models; the model generation module is configured to generate an index analysis model based on a plurality of electrical public information dynamic query language models; a data management module configured to store electrical common information data; and an analysis execution module configured to execute the index analysis model and output an index analysis result based on the electrical public information data. According to the method, an electrical public information dynamic query language model splicing mechanism is introduced, a user can dynamically construct and configure an index analysis model through a simple operation interface according to actual requirements, the efficiency and accuracy of electrical data analysis are improved, the threshold and cost of data analysis are reduced, complex programming knowledge is not needed, and the user experience is improved. Therefore, the user can complete the index analysis task more easily.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The invention belongs to the field of power grid dispatching automation, and in particular relates to an index analysis method and system based on electrical public information dynamic query language model splicing. Background Art

[0002] With the urgent global demand for clean and low-carbon energy, building a new power system with new energy as the main body has become an inevitable choice to promote the clean and low-carbon development of electricity. The new power system has two significant characteristics: one is a high proportion of new energy, that is, new energy occupies a dominant position in the power structure; the other is a high proportion of power electronic equipment, such as new energy, DC, etc., which replace conventional units in large quantities. At the same time, electric vehicles, distributed energy, energy storage, etc. are widely used, making the power system "source-grid-load" show a trend of power electronics.

[0003] In this context, renewable energy power generation requires special analysis and evaluation due to its unique power generation characteristics. In order to comprehensively evaluate the quality of renewable energy power generation, it is particularly important to propose reasonable, effective and practical quantitative indicators. However, compared with traditional power systems, new power systems face unprecedented challenges in terms of continuous and reliable power supply, safe and stable power grids, and power grid dispatching and control.

[0004] In order to meet these challenges, the development of grid-connected new energy dispatching and operation business has become particularly critical. In order to promote the standardization and institutionalization of grid new energy dispatching and operation analysis, clarify the statistical calculation method of grid new energy operation analysis indicators, and improve the level of new energy dispatching and operation management, we need to systematically collect new energy data and reasonably analyze its indicators.

[0005] In the field of new energy and even the entire field of power dispatching, accurate and timely indicator analysis plays a vital role in optimizing energy production and improving operational efficiency. However, traditional indicator analysis methods are often limited by fixed programming logic and are difficult to flexibly adjust according to actual needs, thus failing to fully meet rapidly changing analysis needs. Summary of the invention

[0006] The purpose of the present invention is to provide an indicator analysis system based on the splicing of electrical public information dynamic query language models. By introducing the splicing mechanism of electrical public information dynamic query language models, users are allowed to dynamically build and configure indicator analysis models according to actual needs to adapt to the ever-changing analysis scenarios and obtain accurate and comprehensive electrical indicator analysis results.

[0007] In order to achieve the above object, the solution of the present invention is:

[0008] An index analysis system based on the splicing of electrical public information dynamic query language model, including:

[0009] A dynamic query model library is configured to store a dynamic query language model for electrical common information;

[0010] A model generation module is configured to generate an indicator analysis model based on a number of electrical public information dynamic query language models obtained by a user from a dynamic query model library;

[0011] A data management module is configured to store the collected electrical common information data; and

[0012] The analysis execution module is configured to execute the index analysis model based on the electrical common information data and output the index analysis result.

[0013] The electrical public information data stored in the data management module includes but is not limited to installed capacity, power generation, and power output data.

[0014] Wherein, the dynamic query model library is configured as follows:

[0015] Set the parameters of at least one query operator to specify the query content; wherein the parameters of the query operator include the operator name, data table path, operation type, field to be retrieved, preprocessing operation, and time operation;

[0016] A plurality of electrical public information dynamic query language models that meet the query content are obtained from a dynamic query model library.

[0017] Among them, it also includes:

[0018] The re-statistics module is configured to obtain historical basic sampling data at a specific historical time point or time period, and use a time series analysis algorithm to calculate the indicator value at the specific time.

[0019] Among them, it also includes:

[0020] The data quality evaluation module is configured to perform data quality evaluation on the electrical common information data to form a data quality evaluation table.

[0021] An index analysis method based on electrical public information dynamic query language model splicing, including:

[0022] Acquire several electrical common information dynamic query language models from a dynamic query model library;

[0023] The plurality of electrical public information dynamic query language models are spliced ​​to obtain an index analysis model;

[0024] The index analysis model is executed based on the collected electrical public information data to obtain the index analysis result.

[0025] Among them, the collected electrical public information data includes but is not limited to installed capacity, power generation, and power output data.

[0026] Among them, several electrical public information dynamic query language models are obtained from the dynamic query model library, including:

[0027] Set the parameters of at least one query operator to specify the query content; wherein the parameters of the query operator include the operator name, data table path, operation type, field to be retrieved, preprocessing operation, and time operation;

[0028] A plurality of electrical public information dynamic query language models that meet the query content are obtained from a dynamic query model library.

[0029] This also includes calculating the indicator values ​​at a specific historical time based on historical basic sampling data, including:

[0030] Obtain historical basic sampling data for a specific historical time point or time period, and use a time series analysis algorithm to calculate the indicator value at the specific time.

[0031] The method also includes performing data quality evaluation on the electrical public information data to form a data quality evaluation table.

[0032] After adopting the above scheme, the present invention uses the electrical public information dynamic query language to build a dynamic query model library. Users can select the required electrical public information through a simple operation interface, and quickly generate an index analysis model that meets the requirements by splicing the electrical public information dynamic query language model. This configuration method not only improves the efficiency and accuracy of electrical data analysis, but also reduces the threshold and cost of data analysis. It does not require complex programming knowledge, allowing users to complete index analysis tasks more easily.

[0033] The beneficial effects of the present invention are embodied in:

[0034] (1) The present invention uses the electrical public information dynamic query language to construct a dynamic query model library. The electrical public information dynamic query language has the characteristics of concise syntax, easy to learn and use, and reduces the technical threshold, so that more users can easily perform electrical new energy data analysis;

[0035] (2) Users can customize query statements according to the specific needs of the new energy power plant and modify or add index analysis models at any time without making large-scale changes to the system. This flexibility enables the present invention to easily cope with the increasingly complex index analysis needs in the field of new energy power;

[0036] (3) Through the dynamic query language of electrical public information, users can easily implement complex operations such as data screening, aggregation, and calculation, thereby improving the efficiency and accuracy of data analysis;

[0037] (4) The present invention has wide applicability. Whether it is a wind farm, a photovoltaic power station or other types of electrical plants, the present invention can be used to perform indicator analysis, which not only improves the accuracy and efficiency of the indicator analysis, but also provides strong support for the optimized operation of electrical new energy plants. It can be extended to other similar data analysis scenarios to provide more scientific data support for the development, operation and optimization of electrical new energy. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] Figure 1 It is the indicator analysis system architecture diagram;

[0039] Figure 2 It is the data extraction and transmission diagram of the indicator analysis system;

[0040] Figure 3 It is the statistical flow chart of the indicator analysis system;

[0041] Figure 4 This is the indicator analysis system formula editing screen;

[0042] Figure 5 This is the indicator analysis system formula retriever screen;

[0043] Figure 6 It is the main process of indicator analysis of the indicator analysis system;

[0044] Figure 7 It is the indicator analysis subprocess of the indicator analysis system;

[0045] Figure 8 It is the home page display screen of the indicator analysis system;

[0046] Fig. 9 It is the indicator analysis screen of the indicator analysis system;

[0047] Fig.10 This is the indicator analysis system report display screen;

[0048] Fig.11 It is the flow chart of data quality evaluation of indicator analysis system;

[0049] Among them, (a) is the procedure for refreshing the relevant measuring points, and (b) is the procedure for calculating the measuring point scores. DETAILED DESCRIPTION

[0050] The technical solutions and beneficial effects of the present invention will be described in detail below with reference to the accompanying drawings.

[0051] The present invention provides an index analysis system based on electrical public information dynamic query language model splicing, comprising:

[0052] A dynamic query model library is configured to use the electrical common information dynamic query language to store models; the dynamic query model library uses the electrical common information dynamic query language to store and define models, so that the models have high flexibility and scalability;

[0053] The model generation module is configured to generate an indicator analysis model based on the user's selection and configuration; the model generation module quickly generates an indicator analysis model by splicing the electrical public information dynamic query language model according to the selection and configuration of the display module. This module has a powerful model generation capability and can quickly build an analysis model that meets the requirements according to user needs;

[0054] The analysis execution module is configured to execute the indicator analysis model and output the results; the analysis execution module is used to execute the generated indicator analysis model and output the results. This module has efficient data processing capabilities and accurate analysis algorithms, and can provide users with accurate and comprehensive indicator analysis results; and

[0055] The data management module is configured to collect and store electrical public information data; the data management module is responsible for the collection, storage and management of electrical data to ensure the accuracy and integrity of the data. The module uses advanced data storage technology and can support fast reading and writing operations of large-scale data.

[0056] The system also includes a display module, which is configured as an operation interface for users to select and configure electrical common information and index analysis models; the display module provides an operation interface that enables users to easily select and configure the required electrical common information and index analysis models. The interface design is friendly and intuitive, reducing the difficulty of user use;

[0057] The system further includes an engine module, which is configured to operate the database according to the content of the model splicing configuration table; the engine module is the core component of the system and has the following functions:

[0058] (1) The engine module can automatically execute the dynamic library or SQL file to operate the real-time historical database table of the data access layer at a set time point or interval based on the content of the model splicing configuration table. This function ensures the timeliness and accuracy of data processing.

[0059] (2) The engine module also has powerful task scheduling capabilities and can handle multiple analysis tasks simultaneously, improving the system's concurrent processing capabilities and overall performance.

[0060] (3) The engine module also has an error handling and recovery mechanism, which can automatically perform error handling and recovery operations when encountering abnormal situations, ensuring the stability and reliability of the system.

[0061] The system also includes a data quality evaluation module, which is configured to obtain the model and associated measurement point information; the data quality evaluation module is an indispensable part of the indicator analysis system, and its functions and effects are as follows:

[0062] (1) The data quality evaluation module can automatically traverse all IDs under the electrical splicing model table, obtain relevant models and associated measurement point information, and provide basic data support for subsequent data quality evaluation.

[0063] (2) This module can refresh and update the data quality evaluation table according to the acquired information such as measurement point type, measurement point ID, model ID, etc., and store the results of data quality evaluation into the data quality evaluation table to ensure the real-time and accuracy of the data quality evaluation table.

[0064] (3) The data quality evaluation module can also generate different dynamic libraries for evaluation and statistical operations based on different devices. These dynamic libraries are a collection of evaluation algorithms and statistical methods for specific devices, which can improve the accuracy and pertinence of the evaluation.

[0065] The system further includes a re-statistics module configured to recalculate the indicator value at a specific historical time point based on historical data; the functions of the re-statistics module further include:

[0066] (1) The re-statistics module can simulate the passage of time and recalculate the indicator value at a specific point in the past based on historical basic sampling data, thereby providing users with an accurate review and analysis of historical data.

[0067] (2) This module supports users to customize the time points and time periods for re-statistics to meet the data analysis requirements of different time granularities.

[0068] (3) During the re-statistics process, the module can automatically handle missing data and abnormal situations to ensure the accuracy and reliability of the re-statistics results.

[0069] The system further includes a data extraction and transmission module configured to import key information from the real-time database into the commercial database; the functions of the data extraction and transmission module are further refined as follows:

[0070] (1) The data extraction and transmission module can efficiently import key information from the real-time database into the commercial database, ensuring the real-time and accuracy of the data.

[0071] (2) The module supports two extraction modes: timed extraction and real-time extraction. Users can choose different extraction methods according to actual needs.

[0072] (3) During the data extraction process, the module can automatically clean the data and convert the format to adapt to the data format requirements of different database systems.

[0073] Among them, the multi-level display function of the display module further includes:

[0074] (1) The display module can provide users with multi-angle data views from macro to micro through layered display, helping users to fully understand the overall and local conditions of electrical indicators.

[0075] (2) The module supports direct communication between the front-end and back-end, reducing data transmission delays and improving the response speed of the user interface.

[0076] (3) The display module also provides a wealth of data visualization tools, such as charts, curves, maps, etc., allowing users to intuitively view and analyze electrical indicator data.

[0077] The present invention also provides an index analysis method based on electrical public information dynamic query language model splicing. The core of the method is to use a specific electrical public information dynamic query language to perform efficient and flexible electrical index analysis, including:

[0078] Build a dynamic query model library, which is defined and stored in the electrical common information dynamic query language, making the model highly flexible and scalable, and able to meet the needs of multiple electrical index analysis;

[0079] Provides personalized configuration methods, supports users to select the required electrical common information through graphical operations, and facilitates users to perform personalized configuration according to their own needs;

[0080] By splicing the electrical public information dynamic query language model, an index analysis model that meets user needs is quickly generated; in this step, the system automatically selects the corresponding model from the dynamic query model library according to the user's selection and configuration, and splices it to form a complete analysis model;

[0081] Execute the generated indicator analysis model to complete the analysis of electrical indicators; the system can automatically run the generated analysis model, conduct in-depth mining and analysis of electrical data, and ultimately provide users with accurate and comprehensive indicator analysis results.

[0082] Among them, the personalized configuration method is a graphical interface that supports intuitive operations such as click selection, so that users can easily configure the required electrical common information and indicator analysis model without complex programming knowledge. Through the personalized configuration method, users can customize the parameters and configuration of the analysis model, including but not limited to the analysis time range, data screening conditions, output format, etc., to meet the analysis needs in different scenarios. After generating the indicator analysis model, the method also includes verifying and optimizing the model to ensure the accuracy and reliability of the model, thereby improving the credibility of the analysis results.

[0083] The electrical public information involved includes, but is not limited to, key data such as installed capacity, power generation, and power output data, which are the basis for electrical index analysis. Installed capacity includes the installed capacity of equipment, etc. This information is crucial for evaluating the overall penetration rate of new energy. Power generation and power output data are important indicators for evaluating the efficiency of new energy power generation. By analyzing these data, we can understand the operation and performance of power generation equipment.

[0084] First of all, data extraction and transmission are the starting links of the system of the present invention. Since electrical data is usually stored in a real-time database, and the data structure of the real-time database is often different from that of the commercial database, the data extraction and transmission module is responsible for efficiently and accurately importing key information from the real-time database into the commercial database. This module not only ensures the real-time and accuracy of the data, but also provides users with timely data support, laying a solid foundation for subsequent data analysis.

[0085] In the process of data extraction and transmission, the present invention adopts an efficient data processing algorithm, which can quickly and accurately extract the required data from the real-time database, and perform necessary data cleaning and format conversion to adapt to the data format requirements of the commercial database. At the same time, the module also supports two modes of time extraction and real-time extraction to meet the needs of users for data analysis at different time granularities.

[0086] Next, the system will collect statistics on basic electrical indicators. These basic indicators are important parameters for understanding the operating status and performance of the power system, including but not limited to renewable energy power generation, power output, installed capacity, etc. Through the statistics and analysis of these basic indicators, users can initially understand the overall operation of the power system, discover possible problems and anomalies, and provide strong data support for subsequent optimization and improvement.

[0087] In order to meet the user's demand for accurate review and analysis of historical data, the present invention introduces a re-statistics module. In practical applications, users often need to accurately review and analyze historical data in order to better understand the operating status and performance change trends of the power system. However, since historical data may be missing, abnormal, and other problems, directly counting and analyzing historical data may lead to inaccurate results. Therefore, the present invention designs a re-statistics module, which simulates the passage of time and recalculates the indicator value at a specific time point in the past based on historical basic sampling data. In this way, users can obtain accurate historical data analysis results and better understand the operating status and performance change trends of the power system.

[0088] The implementation principle of the re-statistics module is based on historical basic sampling data and time series analysis algorithms. The module first obtains the re-statistics time point and time period specified by the user, and then recalculates the indicator value at that time point based on the historical basic sampling data and time series analysis algorithm. During the re-statistics process, the module automatically handles data missing and abnormal situations to ensure the accuracy and reliability of the re-statistics results. At the same time, the module also supports multiple re-statistics methods, such as daily and monthly, to meet the user's needs for data analysis at different time granularities.

[0089] In addition to the basic indicator statistics and re-statistics functions, the core of the present invention is the introduction of a model splicing mechanism for the dynamic query language of electrical public information. The dynamic query language of electrical public information is a query language designed specifically for indicator analysis in the power field, with the characteristics of concise syntax, easy to learn and use. Unlike traditional static query languages, the dynamic query language of electrical public information allows users to dynamically build and configure indicator analysis models according to actual needs, thereby achieving flexible and changeable analysis needs.

[0090] Specifically, the present invention implements dynamic query by defining a configuration framework, which includes one or more query operators, each of which has clear parameter settings to specify the specific behavior of the query. These parameters include operator name, data table path, operation type (query or update), fields to be retrieved, preprocessing operations, and time operations.

[0091] The query operator's configuration is expressed in JSON format, which makes it easy to understand and modify. For example, you can define an operator named "SUFFIX" with the following configuration: [

[0093] {

[0094] "name":"SUFFIX",

[0095] "path":"Data table path",

[0096] "type":"select",

[0097] "field":"Field to be obtained",

[0098] "preprocess":"Preprocessing operation",

[0099] "invl":"Time operation"

[0100] } ]

[0102] In this configuration, "name" corresponds to a character in the SUFFIX configuration field. It is a required item and must be unique. It is used to uniquely identify the query task; "path" specifies the access path of the data table. Its structure allows users to accurately locate the required measurement point table or sampling table, providing a hierarchical method to locate data stored in a complex database structure, thereby simplifying access to different types of data in the electrical system (such as real-time data, historical data, etc.); "type" defines the operation type, that is, query or update; "field" is used to specify the field to be retrieved. If omitted, the VALUE field is retrieved by default, and the use of SQL aggregation functions is also supported; "preprocess" allows preprocessing operations after the data is retrieved, and additional conversion or cleaning of the data is performed; "invl" is used to add time restriction conditions to the sampling table query, especially for time series data, and supports multiple time representation methods.

[0103] In addition, when you need to read the UPDATE_TIME of a specific measurement point to set the time condition, you can use the EXT_JSON field to provide the necessary parameters.

[0104] Through the electrical public information dynamic query language, users can easily perform complex operations such as data screening, aggregation, and calculation without having to write complex SQL statements or rely on professional data analysts. This flexibility not only improves the efficiency of data analysis, but also lowers the threshold for data analysis, allowing more users to participate in electrical indicator analysis.

[0105] The implementation principle of the electrical public information dynamic query language model splicing mechanism is based on the model-driven development method. The mechanism first defines a rich set of model elements and operators to describe various electrical indicator analysis scenarios. Then, users can combine these model elements and operators to build an indicator analysis model that meets their own analysis needs.

[0106] Once the model is built, users can execute the model through the analysis execution module and obtain the corresponding analysis results. The electrical public information dynamic query language has a concise and clear syntax structure and supports various complex query operations, such as conditional screening, grouping aggregation, sorting, etc. At the same time, the electrical public information dynamic query language also supports functions such as nested queries and subqueries to meet more complex analysis needs.

[0107] In addition, the system of the present invention also includes a multi-level display module. This module provides users with multi-angle data views from macro to micro through layered display, helping users to better understand electrical indicator data and analysis results. The display module supports direct communication between the front and back ends, reduces the delay in data transmission, and improves the response speed of the user interface. At the same time, the module also provides a wealth of data visualization tools, such as charts, curves, maps, etc., so that users can intuitively view and analyze electrical indicator data. These visualization tools are not only beautiful and easy to use, but also support interactive operations, which facilitates users to explore and analyze data.

[0108] In addition to the core functions, the present invention also supports a variety of data import and export formats to meet the needs of data exchange and sharing with other systems. Users can import data into other software or platforms for further analysis or processing, or export the analysis results into common file formats, such as CSV, Excel, etc., for easy sharing and communication with other team members. It supports the evaluation of data quality and can generate different dynamic libraries for evaluation and statistical operations based on different devices. These dynamic libraries are a collection of evaluation algorithms and statistical methods for specific devices, which can improve the accuracy and pertinence of the evaluation.

[0109] This implementation example provides an implementation scheme of an index analysis system based on the splicing of an electrical public information dynamic query language model. It should be noted that although the following embodiments operate the index analysis model based on new energy data, the protection scope of the present invention cannot be limited by this, and the present invention is applicable to all electrical public information data including new energy data.

[0110] Figure 1 This is the architecture diagram of the new energy index analysis system, which illustrates the overall architecture of the new energy index analysis system based on the electrical public information dynamic query language model. It mainly includes the following steps:

[0111] (1) System deployment and initialization

[0112] First, the new energy index analysis system of the present invention needs to be deployed on the server. This step is crucial because it provides a solid foundation for subsequent data analysis. During the deployment process, it is necessary to ensure the stability and security of the system, while taking into account the scalability and maintainability of the system.

[0113] Next, the system is initialized. This includes configuring system parameters, such as database connection information, data extraction and transmission rules, and initialization of the DQL model library. These configuration information are key to the normal operation of the system and must be completed accurately.

[0114] In addition, it is also necessary to ensure that the network connection between the real-time database and the commercial database is unimpeded. This is the premise for data extraction and transmission, and is also an important guarantee for the smooth progress of subsequent data analysis.

[0115] (2) Data extraction and transmission

[0116] Data extraction and transmission is one of the core links of the system of the present invention. According to the preset rules, the system will extract key information related to new energy from the real-time database regularly or in real time. This information includes but is not limited to power generation, power output, installed capacity, etc., which is the basis for subsequent data analysis.

[0117] After extracting the data, the system will clean and convert the data. The purpose of this step is to eliminate noise and outliers in the data and convert it into a format acceptable to commercial databases. This not only improves the accuracy of the data, but also ensures the consistency and comparability of the data.

[0118] Finally, the cleaned data will be transferred to the commercial database. Figure 2 During this process, the system will ensure the real-time and accuracy of the data, providing reliable support for subsequent data analysis.

[0119] (3) Statistics of basic indicators of new energy

[0120] In the commercial database, the system aggregates and calculates data based on the definition of new energy basic indicators. These basic indicators include new energy power generation, power output, installed capacity, etc., which are important parameters for understanding the operating status and performance of new energy.

[0121] Through the statistics and analysis of these basic indicators, users can initially understand the overall operation of new energy. For example, through the power generation indicator, you can understand the production capacity of new energy.

[0122] The statistical results will be stored in the commercial database for subsequent analysis. These results can not only be used to generate various reports and charts, but also provide strong data support for decision-makers.

[0123] (4) Re-statistics

[0124] In order to meet the user's demand for accurate review and analysis of historical data, the present invention introduces a re-statistics module. Its operation process is as follows: Figure 3 , users can specify the time point and time period for re-statistics as needed, and the system will filter out the corresponding data from the historical basic sampling data for re-statistics.

[0125] During the re-statistics process, the system will use time series analysis algorithms to interpolate and smooth historical data. This can make up for the impact of missing data and abnormal situations and improve the accuracy of historical data analysis.

[0126] Through the re-statistics module, users can obtain accurate indicator values ​​at a specific time point in the past. This is of great significance for understanding the operating status and performance change trends of new energy. For example, users can evaluate the improvement of new energy production capacity by comparing power generation indicators at different time points.

[0127] (5) Electrical public information dynamic query language model splicing and dynamic query

[0128] The electrical public information dynamic query language model splicing and dynamic query is a highlight of the system of the present invention. Users can input the electrical public information dynamic query language through the user interface to specify the new energy indicators and analysis conditions to be analyzed without writing complex SQL statements or relying on professional data analysts.

[0129] The system will build a corresponding index analysis model based on the dynamic query language of electrical public information input by the user. Figure 4 , Figure 5 ,This model is dynamically generated and can be adjusted and optimized according to the actual needs of users. Through the model splicing mechanism, users can easily implement various complex data screening, aggregation and calculation operations.

[0130] Based on the constructed model, the system will dynamically query and aggregate data from commercial databases to meet the user's analysis needs. Figure 6 , Figure 7 This dynamic query method greatly improves the flexibility and efficiency of data analysis, allowing users to quickly adjust analysis strategies according to actual conditions and obtain the desired results.

[0131] (6) User interface interaction and data visualization deployment

[0132] In order to better meet the user's interactive needs and intuitively display the analysis results, the system of the present invention provides a multi-level display module and rich data visualization tools.

[0133] Users can view new energy indicator data and analysis results from macro to micro levels through the user interface. Figure 8 , Fig. 9 , Fig.10At the same time, the system also supports various data visualization methods such as charts, curves and maps, allowing users to intuitively understand the operating status and performance of new energy.

[0134] In addition, the display module also supports interactive operations, allowing users to adjust query conditions and visualization methods as needed to explore and analyze data. This interactive data analysis method not only improves user work efficiency but also provides users with a more flexible and convenient analysis experience.

[0135] (7) Data quality evaluation module

[0136] The new energy data quality evaluation function is implemented based on the data quality evaluation module. Its main function is to conduct targeted assessment and evaluation of the measurement points of some plants and stations. By analyzing and comparing the data of designated measurement points, it can effectively discover data quality problems and provide a basis and support for subsequent data quality inspections.

[0137] The data quality measurement point refresh program will first traverse all IDs under the model table, obtain relevant models and associated measurement point information, and refresh the obtained measurement point type, measurement point ID, and model ID into the data quality evaluation table; the data quality measurement point score calculation program generates different dynamic libraries based on different equipment, such as single machine information, booster station information, meteorological environment information, short-term power forecast, ultra-short-term power forecast, and statistical information, and conducts evaluation and statistics respectively. The dynamic library is called by the system engine at regular intervals in the early morning of each day, and the measurement point score calculation is performed according to the corresponding rules, and the data access layer is connected to refresh the relevant domains. Fig.11 ,The design and application of this function are of great significance to ,improving the management level and capability of the quality of renewable energy ,generation data.

[0138] It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes. The schemes in the embodiments of the present invention may be implemented in various computer languages, for example, object-oriented programming language Java and literal scripting language JavaScript, etc.

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

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

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

[0142] Although the preferred embodiments of the present invention have been described, those skilled in the art may make other changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.

[0143] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include these modifications and variations.

Claims

1. An index analysis system based on the splicing of electrical public information dynamic query language model, characterized by: include, A dynamic query model library is configured to store a dynamic query language model for electrical common information; A model generation module is configured to generate an indicator analysis model based on a number of electrical public information dynamic query language models obtained by a user from a dynamic query model library; a data management module configured to store electrical common information data; and, The analysis execution module is configured to execute the index analysis model based on the electrical common information data and output the index analysis result.

2. The system according to claim 1, characterized in that: The electrical public information data stored in the data management module includes but is not limited to installed capacity, power generation, and power output data.

3. The system according to claim 1, characterized in that: The dynamic query model library is configured as follows: Set the parameters of at least one query operator to specify the query content; wherein the parameters of the query operator include the operator name, data table path, operation type, field to be retrieved, preprocessing operation, and time operation; A plurality of electrical public information dynamic query language models that meet the query content are obtained from a dynamic query model library.

4. The system according to claim 1, characterized in that: Also includes, The re-statistics module is configured to obtain historical basic sampling data at a specific historical time point or time period, and use a time series analysis algorithm to calculate the indicator value at the specific time.

5. The system according to claim 1, characterized in that: Also includes, The data quality evaluation module is configured to perform data quality evaluation on the electrical common information data to form a data quality evaluation table.

6. An index analysis method based on the splicing of electrical public information dynamic query language model, characterized in that: include, Acquire several electrical common information dynamic query language models from a dynamic query model library; The plurality of electrical public information dynamic query language models are spliced ​​to obtain an index analysis model; The index analysis model is executed based on the electrical public information data to obtain the index analysis result.

7. The method according to claim 6, characterized in that: The collected electrical public information data includes but is not limited to installed capacity, power generation, and power output data.

8. The method according to claim 6, characterized in that: Obtain several electrical common information dynamic query language models from the dynamic query model library, including: Set the parameters of at least one query operator to specify the query content; wherein the parameters of the query operator include the operator name, data table path, operation type, field to be retrieved, preprocessing operation, and time operation; A plurality of electrical public information dynamic query language models that meet the query content are obtained from a dynamic query model library.

9. The method according to claim 6, characterized in that: It also includes calculating the indicator values ​​at a specific historical time based on historical basic sampling data, including: Obtain historical basic sampling data for a specific historical time point or time period, and use a time series analysis algorithm to calculate the indicator value at the specific time.

10. The method according to claim 6, characterized in that: The method also includes performing data quality evaluation on the electrical public information data to form a data quality evaluation table.