Intelligent analysis method and device for power transmission line, storage medium and computer equipment

Abstract

According to the intelligent analysis method and device for the power transmission line, the storage medium and the computer equipment provided by the invention, when statistical analysis is carried out on the power transmission line, the data query prompt word is generated according to the inquiry information input by the user and the first constraint rule; the query statement corresponding to the data query prompt word can be generated based on the preset query parameter information more objectively and comprehensively, so that the error rate and omission rate of query are reduced; then, the initial array is obtained through query from the local database by means of the query statement, duplicate removal processing is conducted on the initial array, the target array is obtained, and the efficiency can be improved through automatic information statistics conducted through the data of the multiple data sources in the local database; and finally, generating a data summary prompt word according to the target array and the second constraint rule, and generating a summary report corresponding to the data summary prompt word based on preset summary parameter information to assist operation and maintenance personnel to make decision judgment, so that the workload of manual repeated statistical verification is reduced, and the efficiency is further improved.

Description

Technical Field

[0001] The present application relates to the technical field of power systems, and in particular to a method, device, storage medium and computer equipment for intelligent analysis of power transmission lines. Background Art

[0002] In recent years, with the economic development, the demand for electricity supply has increased year by year, and the mileage of high-voltage transmission lines has increased year by year. More and more transmission lines cross railways, roads, rivers, etc. However, most transmission lines operate outdoors and are often affected by changes in bad weather, geographical conditions, operating conditions, etc., coupled with the influence of human factors and irresistible natural disasters, making transmission lines the weakest and most prone to failure in the power grid. Once a transmission line fails at an important intersection, it will not only affect the transmission of electricity, but may even cause serious public safety incidents.

[0003] In order to ensure the stable operation of high-voltage transmission lines and social public safety, the transmission line operation and maintenance units have formulated a series of strict operation and maintenance management measures for important crossing sections. All important sections of transmission lines that cross railways, highways, first-class highways and rivers must carry out corresponding operation and maintenance in accordance with the management measures to improve the overall safety factor of the transmission lines.

[0004] However, since the transmission lines are affected by many factors in the outdoor environment, the current statistics of important crossing sections usually adopt manual statistical methods, which is not only inefficient, but also difficult to discover and make up for information loss in time, and it is also difficult to collect information comprehensively and accurately, resulting in the omission of some key sections; more seriously, due to the unreliability of statistical information, the operation and maintenance units often require the operation and maintenance personnel to repeat the statistics and conduct multiple line equipment information verifications, which not only increases the workload of the operation and maintenance personnel, but also causes a lot of waste of manpower and material resources. In short, the traditional statistical methods for important crossing sections of transmission lines have low efficiency and accuracy, resulting in a low overall safety factor of the transmission line, which in turn affects the safe and stable operation of the line. Summary of the invention

[0005] The purpose of this application is to solve at least one of the above-mentioned technical defects, especially the technical defect that the statistical method of important crossing sections of transmission lines in the prior art has low working efficiency and accuracy, resulting in a low overall safety factor of the transmission line, which in turn affects the safe and stable operation of the line.

[0006] The present application provides a transmission line intelligent analysis method, the method comprising:

[0007] Generate a data query prompt word according to the query information input by the user and the preset first constraint rule, and generate a query statement corresponding to the data query prompt word based on the preset query parameter information;

[0008] Using the query statement to query the local database where the power transmission line is located to obtain an initial array, and performing deduplication processing on the initial array to obtain a target array;

[0009] A data summary prompt word is generated according to the target array and a preset second constraint rule, and a summary report corresponding to the data summary prompt word is generated based on preset summary parameter information.

[0010] Optionally, generating a data query prompt word according to the query information input by the user and a preset first constraint rule includes:

[0011] Acquire the query information input by the user and the first constraint rule set in the system; the first constraint rule is composed of multiple constraint operators;

[0012] The query information and each constraint operator are combined and spliced ​​in a preset order to obtain a data query prompt word;

[0013] Among them, the operator types of the constraint operator in the first constraint rule include a prompt word basic format, a limiting constraint condition, a cross-span table database, a cross-span table knowledge base and an output structure.

[0014] Optionally, the generating a query statement corresponding to the data query prompt word based on preset query parameter information includes:

[0015] The preset query parameter information and the data query prompt word are input into the sentence generation model, so as to use the query parameter information to perform parameter constraints on the sentence generation model, and the query sentence corresponding to the data query prompt word is output through the constrained data query model.

[0016] Optionally, the using the query statement to query a local database where the power transmission line is located to obtain an initial array includes:

[0017] After connecting to the local database where the power transmission line is located, the query statement is executed to obtain an initial array from a corresponding data table in the local database; the initial array includes at least one information array.

[0018] Optionally, performing deduplication processing on the initial array to obtain a target array includes:

[0019] When the initial array includes an information array, directly outputting the information array as the target array;

[0020] When the initial array includes multiple information arrays, matrix multiplication is used to deduplicate each information array to generate a deduplication matrix, and identical arrays and difference arrays are extracted from the deduplication matrix to form a target array.

[0021] Optionally, generating data summary prompt words according to the target array and a preset second constraint rule includes:

[0022] The target array and each constraint operator in the preset second constraint rule are combined in a preset order to obtain a data summary prompt word;

[0023] The operator types of the constraint operator in the second constraint rule include a prompt word basic format, query information, limited constraint conditions and output structure.

[0024] Optionally, generating a summary report corresponding to the data summary prompt word based on preset summary parameter information includes:

[0025] The preset summary parameter information and the data summary prompt words are input into the report summary model, so as to use the summary parameter information to perform parameter constraints on the report summary model, and the summary report corresponding to the data summary prompt words is output through the constrained report summary model.

[0026] The present application also provides a transmission line intelligent analysis device, comprising:

[0027] A statement generation module, used to generate a data query prompt word according to the query information input by the user and the preset first constraint rule, and generate a query statement corresponding to the data query prompt word based on the preset query parameter information;

[0028] A data processing module, used to query the local database where the power transmission line is located using the query statement to obtain an initial array, and perform deduplication processing on the initial array to obtain a target array;

[0029] The report summary module is used to generate data summary prompt words according to the target array and the preset second constraint rule, and generate a summary report corresponding to the data summary prompt words based on preset summary parameter information.

[0030] The present application also provides a storage medium, in which computer-readable instructions are stored. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the steps of the intelligent analysis method for power transmission lines as described in any of the above embodiments.

[0031] The present application also provides a computer device, comprising: one or more processors, and a memory;

[0032] The memory stores computer-readable instructions, and when the computer-readable instructions are executed by the one or more processors, the steps of the power transmission line intelligent analysis method as described in any one of the above embodiments are performed.

[0033] It can be seen from the above technical solutions that the embodiments of the present application have the following advantages:

[0034] The power transmission line intelligent analysis method, device, storage medium and computer equipment provided by the present application can first generate data query prompt words according to the query information input by the user and the preset first constraint rule when performing statistical analysis on the important crossing and spanning sections of the power transmission line, so that the query statement corresponding to the data query prompt word generated based on the preset query parameter information can be more objective and comprehensive, thereby reducing the error rate and omission rate of the query; then, the query statement can be used to query the local database where the transmission line is located to obtain an initial array, and the initial array is deduplicated to obtain a target array. Here, the automatic statistics of information carried out by multiple data source data in the local database can save the mutual communication and verification process of manual statistics, thereby improving work efficiency; finally, data summary prompt words can be generated according to the target array and the preset second constraint rule, and a summary report corresponding to the data summary prompt word can be generated based on the preset summary parameter information, so as to assist the operation and maintenance personnel in making decisions and judgments, while reducing the workload of manual repeated statistics and verification and the waste of human and material resources, improving the overall safety factor of the transmission line, and ensuring the safe and stable operation of the line. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] In order to more clearly illustrate the embodiments of the present application 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 application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0036] Figure 1 A schematic diagram of a flow chart of a transmission line intelligent analysis method provided in an embodiment of the present application;

[0037] Figure 2 A schematic diagram of a page of a summary report provided in an embodiment of the present application;

[0038] Figure 3 A schematic diagram of the structure of a power transmission line intelligent analysis device provided in an embodiment of the present application;

[0039] Figure 4 A schematic diagram of the internal structure of a computer device provided in an embodiment of the present application. DETAILED DESCRIPTION

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

[0041] Since the transmission lines are affected by many factors in the outdoor environment, the current statistics of important crossing sections usually adopt manual statistical methods, which is not only inefficient, but also difficult to timely discover and make up for information loss, and it is also difficult to collect information comprehensively and accurately, resulting in the omission of some key sections; more seriously, due to the unreliability of statistical information, the operation and maintenance units often require the operation and maintenance personnel to repeat the statistics and conduct multiple line equipment information verifications, which not only increases the workload of the operation and maintenance personnel, but also causes a lot of waste of manpower and material resources. In short, the traditional statistical methods for important crossing sections of transmission lines have low efficiency and accuracy, resulting in a low overall safety factor of the transmission line, which in turn affects the safe and stable operation of the line.

[0042] Based on this, this application proposes the following technical solutions, see below for details:

[0043] In one embodiment, Figure 1 As shown, Figure 1 A schematic diagram of a flow chart of a transmission line intelligent analysis method provided in an embodiment of the present application; the present application provides a transmission line intelligent analysis method, which specifically includes the following:

[0044] S110: Generate a data query prompt word according to the query information input by the user and a preset first constraint rule, and generate a query statement corresponding to the data query prompt word based on preset query parameter information.

[0045] In this step, when performing statistical analysis on important crossing sections of transmission lines, the computer device can first generate data query prompt words based on the query information input by the user and the preset first constraint rule, so that the query statements corresponding to the data query prompt words generated based on the preset query parameter information can be more objective and comprehensive, thereby reducing the error rate and omission rate of the query.

[0046] Among them, the first constraint rule refers to some rules or conditions pre-set by the computer device before conducting data query, which is mainly used to limit the scope and direction of the query to ensure that the query scope is not too broad, so as to accurately obtain relevant data; and the data query prompt word refers to the keyword or phrase that guides the computer device to conduct precise query, which represents a simplified expression of the query intent and can be used to construct query statements to reduce query errors and omissions.

[0047] In addition, query parameter information refers to the relevant parameters that limit the output of the query statement; different query statement generation methods correspond to different query parameter information. For example, when a large language model is used to generate a query statement, the query parameter information can be parameters such as the maximum number of tokens, sampling temperature, model ID, etc., which are mainly used to limit the large language model version of the reply, the maximum reply length, the reply temperature and other conditions.

[0048] Specifically, the query information input by the user includes the query object that the user is concerned about, such as the specific location, time period, or relationship with other facilities of an important cross-over section of a transmission line. After receiving the query information, the computer device can fuse and analyze the query information with the first constraint rule, and then generate data query prompt words, which can accurately represent the core content of the query and avoid the query being too broad or deviating from the actual needs of the user. Then, the computer device can automatically generate a query statement based on these query prompt words, so that the query statement can comprehensively cover the relevant data dimensions of the user's needs, ensuring that the query will not miss or deviate from the query target.

[0049] It should be noted that the first constraint rule here can be set by the user in the computer device according to the query question, or it can be a default parameter pre-set in the computer device, and there is no limitation here. In detail, after the user enters the query information, the computer device can detect whether the user has entered the corresponding constraint rule. If so, it can be used as the first constraint rule of this round of query analysis; if not, the transmission line corresponding to the query information can be determined first, and then the default constraint rule of the transmission line in the system can be used as the first constraint rule of this round of query analysis.

[0050] It can be understood that the method of generating query statements based on query information and constraint rules in this application can not only effectively reduce the error rate caused by improper user input or ambiguous query conditions, but also avoid missing important data needed for analysis, thereby improving the accuracy and efficiency of data query.

[0051] S120: using a query statement to query a local database where the power transmission line is located to obtain an initial array, and performing deduplication processing on the initial array to obtain a target array.

[0052] In this step, after the query statement is generated in step S110, the computer device can use the query statement to query the local database where the transmission line is located to obtain an initial array, and then deduplicate the initial array to obtain a target array, so that information automatically counted by multiple data source data in the local database can be obtained, eliminating the mutual communication and exchange verification process of manual statistics, thereby improving work efficiency.

[0053] Specifically, the computer device can directly apply the query statement to the local database where the corresponding transmission line is located to initiate a data query request to the local database. After the local database receives the query request, the computer device can extract an array that meets the conditions from the corresponding data table according to the conditions defined in the query statement to form an initial array. The initial array can come from multiple data sources, which contain various relevant information about the transmission line, such as geographical location, crossing section, time tag and other technical parameters, etc., which will not be described in detail here.

[0054] Since the same data records may exist in different data sources, after the initial array is returned to the computer device, the computer device can perform a deduplication operation on the returned initial array to improve the accuracy of subsequent analysis. The deduplication operation here can be to identify and eliminate duplicate items in the data through an algorithm to ensure that each record in the target array obtained after deduplication is unique.

[0055] It is understandable that manual statistics often require a lot of time to compare, check and organize data, and are prone to human errors. Automatic processing of queries, deduplication and statistical analysis by computer equipment can ensure the efficiency and accuracy of the data processing process and reduce the time delays and error risks caused by manual intervention. Automated statistical analysis by computer can not only improve work efficiency, but also provide reliable data support for subsequent data decision-making and analysis.

[0056] S130: Generate data summary prompt words according to the target array and the preset second constraint rule, and generate a summary report corresponding to the data summary prompt words based on the preset summary parameter information.

[0057] In this step, after obtaining the target array through step S120, the computer device can generate data summary prompt words according to the target array and the preset second constraint rule, and generate a summary report corresponding to the data summary prompt words based on the preset summary parameter information to assist operation and maintenance personnel in making decisions and judgments, while reducing the workload of manual repeated statistical verification and the waste of human and material resources, improving the overall safety factor of the transmission line and ensuring the safe and stable operation of the line.

[0058] It should be noted that the second constraint rule of the present application refers to some rules or conditions pre-set by the computer device before data summarization, and its principle is consistent with the first constraint rule. In addition, the generation process of data summary prompt words is consistent with the generation process of data query summary prompt words, which will not be repeated here.

[0059] Specifically, the computer equipment can further generate a summary report based on these generated summary prompts, which can summarize the operating status, risk points, abnormal conditions and other factors related to safety and stability of important cross-sections of transmission lines within a period of time or in a certain area. This summary report can not only show the results of statistical analysis, but also include preliminary judgments and suggestions for the problems found to help operation and maintenance personnel make decisions. For example, the summary report highlights the risk factors of a certain cross-section, or the abnormal status of certain equipment, and specifically recommends that operation and maintenance personnel strengthen monitoring or perform preventive maintenance in advance.

[0060] It is understandable that in the traditional manual statistical process, operation and maintenance personnel need to manually calculate, organize and analyze a large amount of data, which is not only time-consuming and labor-intensive, but also prone to errors and omissions; however, through the automated processing method of the present application, the target array can quickly generate an accurate summary report after precise deduplication and screening, while avoiding a large amount of waste of manpower and material resources, improving the decision-making efficiency of operation and maintenance personnel, and thereby improving the overall safety factor and stability of the transmission line.

[0061] In the above embodiment, when statistical analysis is performed on important crossing sections of the transmission line, data query prompt words can be first generated according to the query information input by the user and the preset first constraint rule, so that the query statement corresponding to the data query prompt word generated based on the preset query parameter information can be more objective and comprehensive, thereby reducing the error rate and omission rate of the query; then the query statement can be used to query the local database where the transmission line is located to obtain an initial array, and the initial array is deduplicated to obtain a target array. Here, the information is automatically counted through multiple data source data in the local database, which can save the mutual communication and verification process of manual statistics and improve work efficiency; finally, data summary prompt words can be generated according to the target array and the preset second constraint rule, and a summary report corresponding to the data summary prompt word can be generated based on the preset summary parameter information to assist operation and maintenance personnel in making decisions and judgments, while reducing the workload of manual repeated statistics and verification and the waste of manpower and material resources, improving the overall safety factor of the transmission line and ensuring the safe and stable operation of the line.

[0062] In one embodiment, the process of generating data query prompt words according to the query information input by the user and the preset first constraint rule in step S110 may include:

[0063] S111: Acquire the query information input by the user and the first constraint rule set in the system; the first constraint rule is composed of a plurality of constraint operators.

[0064] S112: combining the query information and each constraint operator in a preset order to obtain a data query prompt word.

[0065] In this embodiment, when generating a data query prompt word, the computer device can obtain the query information input by the user and the first constraint rule set in the system, and the first constraint rule is composed of multiple constraint operators, and the operator type of the constraint operator can include a prompt word basic format, a limiting constraint condition, a cross-span table database, a cross-span table knowledge base, and an output structure. Therefore, the computer device can splice and combine the query information and each constraint operator in a preset order to obtain the data query prompt word.

[0066] Specifically, the application can splice information in the order of prompt word basic format, query information, limited constraint conditions, cross-span table database, cross-span table knowledge base and output structure, and reassemble into data query prompt words for application in the subsequent query statement generation process. Here, the combination formula of data query prompt words can be expressed as follows:

[0067] T = f(U, Y, D, K, S)

[0068] In the formula, T represents the data query prompt word; f represents the basic format of the prompt word; U represents the query information; Y represents the limiting constraint condition; D represents the cross-spanning table database; K represents the cross-spanning table knowledge base; and S represents the output structure.

[0069] For example, when a data query prompt is generated during the intelligent analysis of an important crossing section of a transmission line, the basic format of the prompt is: "You are a data analysis engineer. Please accurately understand the user's intention based on the query information entered by the user, and construct a grammatically correct SQL query statement based on the given database and knowledge base resource information to query qualified data from the database. Query information: {user_input}; Constraints: {constraints}; Database: {database}; Knowledge base: {knowledge_base}; Output structure: {response_format}. When answering, please use the same language as the user."

[0070] The query information input by the user is: user_input="check the crossing sections of all transmission lines in the power grid system table".

[0071] The constraints are as follows: constraints="Constraint 1: Please strictly follow the given data table structure information and do not use non-existent fields; Constraint 2: The generated SQL query statement must comply with the specifications and be able to run normally; Constraint 3: If you only need to query data from a single table, please output the corresponding SQL query statement as required; Constraint 4: If you need to compare data in different tables, please output multiple SQL query statements as required to query data in multiple tables respectively."

[0072] The cross-spanning table database is the system's built-in cross-spanning table database name and the corresponding table structure definition. The data comes from different data sources. Here is the data table information manually entered in the power grid system and the data table information statistically collected by the map data source. It can be specifically expressed as: database="{'table_name1':'xitongjiaokua','table-field-separator1':'bian_hao,xian_lu_ming_cheng,gan_ta_qu_duan,gong_lu_ming_cheng','table_name2':'ditujiaokua','table-field-separator2':'bian_hao,xian_lu_ming_cheng,gan_ta_qu_duan,gong_lu_ming_cheng'}".

[0073] The cross-span table knowledge base is the knowledge of the system's built-in cross-span table data table structure, which can be specifically expressed as: knowledge_base="xitongjiaokua is a cross-span table manually entered in the power grid system, which stores important cross-span information of the transmission lines in the system. Each row in the table represents a cross-span. All cross-span issues related to the power grid system should be queried in this table. The specific field definitions are as follows: bian_hao is the important cross-span number of the transmission line; xian_lu_ming_cheng is the name of the line to which the important cross-span of the transmission line belongs; gan_ta_qu_duan is the tower section of the line to which the important cross-span of the transmission line belongs; gong_lu_ming_ch eng is the name of the highway under the important crossing of the transmission line. ditujiaokua is the crossing table of the map data source statistics, which stores the important crossing information of the transmission line counted by the map data source. Each row in the table represents a crossing. For any crossing problem related to map statistics, try to query this table. The specific field definitions are as follows: bian_hao is the number of the important crossing of the transmission line; xian_lu_ming_cheng is the name of the line to which the important crossing of the transmission line belongs; gan_ta_qu_duan is the tower section of the line to which the important crossing of the transmission line belongs; gong_lu_ming_cheng is the name of the highway under the important crossing of the transmission line. ".

[0074] The output structure is: response_format="{'thoughts': 'Summary of thoughts for users', 'sql': 'Executable SQL query statements. If there are multiple SQL query statements, just use list to display the statements'}.

[0075] In one embodiment, the process of generating a query statement corresponding to the data query prompt word based on the preset query parameter information in step S110 may include:

[0076] S113: inputting preset query parameter information and data query prompt words into a sentence generation model, so as to use the query parameter information to perform parameter constraints on the sentence generation model, and outputting a query sentence corresponding to the data query prompt word through the constrained data query model.

[0077] In this embodiment, the application can use a large prediction model to generate a query statement corresponding to a data query prompt word. First, the computer device can input the preset query parameter information into the statement generation model for parameter constraints, and then the data query prompt word can be input into the constrained sentence generation model to ask questions, thereby obtaining a query statement output by the model after answering the data query prompt word.

[0078] For example, query parameter information can include the maximum number of tokens, sampling temperature, model ID, etc., to limit the specific conditions for generating query statements. Specifically, the maximum number of tokens mainly limits the length of the generated query statement, preventing the generation of too long or unnecessary information, and ensuring that the query statement is concise and effective; the sampling temperature affects the randomness and diversity of the generation process. A higher temperature may generate more diverse statements, while a lower temperature will make the generation results more certain and consistent; the model ID indicates the version of the large language model used, ensuring that the most suitable model matching the task is used; the settings of these parameters can ensure that the query statements generated by the model meet specific formats and requirements, while controlling the scope and quality of the generated content.

[0079] It is understandable that after the sentence generation model is constrained, the computer device can input the generated data query prompt words into the model to ask questions. The data query prompt words here are a set of keywords or phrases automatically generated according to user needs and corresponding constraint rules, representing the core content of the user's query, and enabling the computer device to further focus on the specific dimensions of the query target. Therefore, after the query prompt words are input into the model, the sentence generation model can understand the query targets they represent, and accurately construct the query statements based on the previously input constraints, thereby ensuring the accuracy of the query while greatly reducing human intervention and errors, improving the efficiency and accuracy of data queries, and avoiding omissions and errors that may occur when traditional query statements are manually written.

[0080] In one embodiment, the process of using a query statement to query and obtain an initial array from a local database where the power transmission line is located in step S120 may include:

[0081] S121: After connecting to the local database where the power transmission line is located, a query statement is executed to obtain an initial array from a corresponding data table in the local database; the initial array includes at least one information array.

[0082] In this embodiment, after generating the query statement, the computer device can connect to the local database where the power transmission line is located and execute the query statement to query the corresponding data table in the local database to obtain the initial array. The initial array here includes at least one information array, and each information array corresponds to a data table in the local database.

[0083] For example, assuming that it is necessary to query the first n rows of data in the data table manually entered in the power grid system and the first m rows of data in the data table statistically collected by the map data source, the computer device can obtain the power grid system database information and the map database information through query. The power grid system database information includes "important crossing number Ax of the transmission line", "name of the line to which the crossing belongs Al", "tower section At of the line to which the crossing belongs", "name of the highway under the crossing Ag", and querying the first n rows of data can form the power grid system crossing information array Pa, which can be expressed as follows:

[0084]

[0085] The map database information includes "the number of important crossings of transmission lines Bx", "the name of the line where the crossings are located Bl", "the tower section of the line where the crossings are located Bt", and "the name of the highway under the crossings at the crossings Bg". By querying the first m rows of data, the map crossing information array Pb can be formed, which can be expressed as follows:

[0086]

[0087] In one embodiment, the process of performing deduplication processing on the initial array to obtain the target array in step S120 may include:

[0088] S122: When the initial array includes an information array, directly output the information array as the target array.

[0089] S123: When the initial array includes multiple information arrays, matrix multiplication is used to deduplicate each information array to generate a deduplication matrix, and identical arrays and difference arrays are extracted from the deduplication matrix to form a target array.

[0090] In this embodiment, the initial array may include at least one information array. When there is one information array, the computer device may directly output the information array as the target array. When there are multiple information arrays, the computer device may use matrix multiplication to deduplicate each information array, generate a deduplication matrix, and extract the same array and the difference array from the deduplication matrix to form a target array.

[0091] For example, assuming that the computer device queries and obtains two information arrays, namely, the power grid system cross-span information array Pa and the map cross-span information array Pb, the information array deduplication formula can be expressed as follows:

[0092]

[0093] Where Pa represents the cross-span information array of the power grid system; Represents the transposed matrix of the map cross-span information array; Pc represents the deduplication matrix. Because the data in the matrix Pa and the matrix Pb are all characters, the "multiplication" operation between characters is defined as follows: if "a"="b", then "a"×"b"=1; if "a"≠"b", then "a"×"b"=0.

[0094] According to the matrix multiplication operation, each row in the matrix Pa needs to be summed with the transposed matrix Multiply each column in Pc, and the result of the i-th row and j-th column in Pc is If the data in the i-th row of the matrix Pa is exactly the same as the data in the j-th row of the matrix Pb, then ; If the data in the i-th row of the matrix Pa is not exactly the same as the data in the j-th row of the matrix Pb, then . From this we can get the deduplication matrix .

[0095] Then, based on the results of the deduplication matrix Pc, the computer equipment can make duplicate data judgments on the power grid system cross-span information array Pa and the map cross-span information array Pb. Analyze the data of the deduplication matrix Pc. If the data in the i-th row and j-th column of Pc is 4, it means that the i-th row data in array Pa is exactly the same as the j-th row data in array Pb, otherwise it means that the i-th row data in array Pa is not exactly the same as the j-th row data in array Pb. Assuming that only the n-th row data among all the rows of the deduplication matrix does not contain the value 4, it means that the n-th row data in array Pa is not exactly the same as all the row data in array Pb; if only the m-th column data among all the columns of the deduplication matrix does not contain the value 4, it means that the m-th row data in array Pb is not exactly the same as all the row data in array Pa. Extract and recombine the identical data into the same array Pw, that is, ; The non-identical data are extracted and reassembled into a difference array Pq, that is, .

[0096] In one embodiment, the process of generating data summary prompt words according to the target array and the preset second constraint rule in step S130 may include:

[0097] S131: combining the target array and each constraint operator in the preset second constraint rule in a preset order to obtain a data summary prompt word.

[0098] In this embodiment, when generating data summary prompt words, the computer device can obtain the second constraint rule set in the system, the first constraint rule is composed of multiple constraint operators, and the operator type of the constraint operator can include the prompt word basic format, query information, limited constraint conditions and output structure. Therefore, the computer device can splice and combine the query information and each constraint operator in a preset order to obtain the data summary prompt word.

[0099] For example, the computer device can splice the basic format, query information, limited constraints, target array and output structure in order to reassemble them into data summary prompt words for application in the subsequent summary report generation process. Here, the combination formula of the data summary prompt words can be expressed as follows:

[0100] T = f(U, Y, D, S)

[0101] In the formula, T represents the data summary prompt word; f represents the basic format of the prompt word; U represents the query information; Y represents the limiting constraint condition; D represents the target array; and S represents the output structure.

[0102] For example, when generating data summary prompts during the intelligent analysis of an important crossing section of a transmission line, the basic format of the prompts is: "You are a data summary assistant. Please accurately understand the user's intention based on the query information entered by the user, summarize the data based on the given target array, and provide users with professional and concise answers to questions. Query information: {user_input}; Constraints: {constraints}; Target array: {data}; Output structure: {response_format}. When answering, please use the same language as the user."

[0103] The query information is: user_input="Check the intersection sections of all transmission lines in the power grid system table".

[0104] The constraints are as follows: constraints="Constraint 1: Please strictly follow the given target array and do not use non-existent data; Constraint 2: If you cannot get the answer from the provided content, please say: "The information provided in the knowledge base is not enough to answer this question." It is forbidden to make up information at will; Constraint 3: When answering, please summarize according to points 1, 2, and 3."

[0105] The target array is: data="Pw= ; Pq = ".

[0106] The output structure is: response_format="{'thoughts': 'Thoughts for users', 'conclustion': 'Data summary content', 'data': 'Original data', 'display_type': 'Data display method'}.

[0107] In one embodiment, the process of generating a summary report corresponding to the data summary prompt word based on the preset summary parameter information in step S130 may include:

[0108] S132: inputting preset summary parameter information and data summary prompt words into the report summary model, so as to use the summary parameter information to constrain the parameters of the report summary model, and outputting a summary report corresponding to the data summary prompt words through the constrained report summary model.

[0109] In this embodiment, the application can use a large prediction model to generate a summary report corresponding to the data summary prompt words. First, the computer device can input the preset summary parameter information into the report summary model for parameter constraints, and then the data summary prompt words can be input into the constrained report summary model to ask questions, and then obtain the summary report output after the model answers the data summary prompt words.

[0110] It should be noted that the generation process of the summary report in this application is consistent with the generation process of the query statement, which will not be repeated here.

[0111] Indicatively, if Figure 2 As shown, Figure 2 A schematic diagram of a summary report page provided in an embodiment of the present application, comprising Figure 2 It can be seen that the summary report generated by this application can include a detailed analysis of the similarities and differences between line tower sections between different crossing tables and an overall summary analysis. For operation and maintenance personnel, the statistical data obtained from the analysis has a high-quality reference role, which greatly improves the decision-making efficiency of operation and maintenance personnel, and can quickly check for omissions and errors in important crossing information to ensure safe and stable operation of the line.

[0112] The following is a description of a power transmission line intelligent analysis device provided in an embodiment of the present application. The power transmission line intelligent analysis device described below and the power transmission line intelligent analysis method described above can be referenced to each other.

[0113] In one embodiment, Figure 3 As shown, Figure 3 A schematic diagram of the structure of a transmission line intelligent analysis device provided in an embodiment of the present application; the present application also provides a transmission line intelligent analysis device, including a statement generation module 210, a data processing module 220 and a report summary module 230, specifically including the following:

[0114] The statement generation module 210 is used to generate a data query prompt word according to the query information input by the user and the preset first constraint rule, and to generate a query statement corresponding to the data query prompt word based on the preset query parameter information.

[0115] The data processing module 220 is used to query the local database where the power transmission line is located using a query statement to obtain an initial array, and perform deduplication processing on the initial array to obtain a target array.

[0116] The report summary module 230 is used to generate data summary prompt words according to the target array and the preset second constraint rule, and generate a summary report corresponding to the data summary prompt words based on the preset summary parameter information.

[0117] In the above embodiment, when statistical analysis is performed on important crossing sections of the transmission line, data query prompt words can be first generated according to the query information input by the user and the preset first constraint rule, so that the query statement corresponding to the data query prompt word generated based on the preset query parameter information can be more objective and comprehensive, thereby reducing the error rate and omission rate of the query; then the query statement can be used to query the local database where the transmission line is located to obtain an initial array, and the initial array is deduplicated to obtain a target array. Here, the information is automatically counted through multiple data source data in the local database, which can save the mutual communication and verification process of manual statistics and improve work efficiency; finally, data summary prompt words can be generated according to the target array and the preset second constraint rule, and a summary report corresponding to the data summary prompt word can be generated based on the preset summary parameter information to assist operation and maintenance personnel in making decisions and judgments, while reducing the workload of manual repeated statistics and verification and the waste of manpower and material resources, improving the overall safety factor of the transmission line and ensuring the safe and stable operation of the line.

[0118] In one embodiment, the statement generation module 210 may include:

[0119] The information acquisition submodule is used to acquire the query information input by the user and the first constraint rule set in the system; the first constraint rule is composed of multiple constraint operators.

[0120] The first combination submodule is used to combine the query information and each constraint operator in a preset order to obtain a data query prompt word.

[0121] Among them, the operator types of the constraint operator in the first constraint rule include the basic format of the prompt word, the limiting constraint condition, the cross-span table database, the cross-span table knowledge base and the output structure.

[0122] In one embodiment, the statement generation module 210 may further include:

[0123] The model query submodule is used to input preset query parameter information and data query prompt words into the sentence generation model, so as to use the query parameter information to parameter constrain the sentence generation model, and output the query sentence corresponding to the data query prompt word through the constrained data query model.

[0124] In one embodiment, the data processing module 220 may include:

[0125] The array query submodule is used to connect to the local database where the transmission line is located and then execute a query statement to query the corresponding data table in the local database to obtain an initial array; the initial array includes at least one information array.

[0126] In one embodiment, the data processing module 220 may further include:

[0127] The first output submodule is used to directly output the information array as the target array when the initial array includes an information array.

[0128] The second output submodule is used to deduplicate each information array by matrix multiplication when the initial array includes multiple information arrays, generate a deduplication matrix, and extract the same array and the difference array from the deduplication matrix to form a target array.

[0129] In one embodiment, the report summary module 230 may include:

[0130] The second combination submodule is used to combine the target array and each constraint operator in the preset second constraint rule in a preset order to obtain a data summary prompt word.

[0131] The operator types of the constraint operator in the second constraint rule include the basic format of the prompt word, the limiting constraint condition and the output structure.

[0132] In one embodiment, the report summary module 230 may further include:

[0133] The model summary submodule is used to input preset summary parameter information and data summary prompt words into the report summary model, so as to use the summary parameter information to constrain the parameters of the report summary model, and output a summary report corresponding to the data summary prompt words through the constrained report summary model.

[0134] In one embodiment, the present application also provides a storage medium, in which computer-readable instructions are stored. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the steps of the intelligent analysis method for transmission lines as described in any of the above embodiments.

[0135] In one embodiment, the present application also provides a computer device, in which computer-readable instructions are stored. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the steps of the intelligent analysis method for transmission lines as described in any of the above embodiments.

[0136] Indicatively, if Figure 4 As shown, Figure 4This is a schematic diagram of the internal structure of a computer device provided in an embodiment of the present application. The computer device 300 may be provided as a server. Figure 4 The computer device 300 includes a processing component 302, which further includes one or more processors, and a memory resource represented by a memory 301, for storing instructions executable by the processing component 302, such as an application. The application stored in the memory 301 may include one or more modules, each corresponding to a set of instructions. In addition, the processing component 302 is configured to execute instructions to perform the transmission line intelligent analysis method of any of the above embodiments.

[0137] The computer device 300 may further include a power supply component 303 configured to perform power management of the computer device 300, a wired or wireless network interface 304 configured to connect the computer device 300 to a network, and an input / output (I / O) interface 305. The computer device 300 may operate based on an operating system stored in the memory 301, such as Windows Server TM, Mac OS X TM, Unix TM, Linux TM, Free BSD TM, or the like.

[0138] Those skilled in the art will understand that Figure 4 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0139] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0140] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The various embodiments can be combined as needed, and the same or similar parts can refer to each other.

[0141] The above description of the disclosed embodiments enables those skilled in the art to implement or use the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A transmission line intelligent analysis method, characterized in that: The method comprises: Generate a data query prompt word according to the query information input by the user and the preset first constraint rule, and generate a query statement corresponding to the data query prompt word based on the preset query parameter information; Using the query statement to query the local database where the power transmission line is located to obtain an initial array, and performing deduplication processing on the initial array to obtain a target array; A data summary prompt word is generated according to the target array and a preset second constraint rule, and a summary report corresponding to the data summary prompt word is generated based on preset summary parameter information.

2. The intelligent analysis method for power transmission lines according to claim 1, characterized in that: The step of generating a data query prompt word according to the query information input by the user and the preset first constraint rule includes: Acquire the query information input by the user and the first constraint rule set in the system; the first constraint rule is composed of multiple constraint operators; The query information and each constraint operator are combined and spliced ​​in a preset order to obtain a data query prompt word; Among them, the operator types of the constraint operator in the first constraint rule include a prompt word basic format, a limiting constraint condition, a cross-span table database, a cross-span table knowledge base and an output structure.

3. The intelligent analysis method for power transmission lines according to claim 1, characterized in that: The generating of a query statement corresponding to the data query prompt word based on preset query parameter information includes: The preset query parameter information and the data query prompt word are input into the sentence generation model, so as to use the query parameter information to perform parameter constraints on the sentence generation model, and the query sentence corresponding to the data query prompt word is output through the constrained data query model.

4. The intelligent analysis method for power transmission lines according to claim 1, characterized in that: The step of using the query statement to query a local database where the power transmission line is located to obtain an initial array includes: After connecting to the local database where the power transmission line is located, the query statement is executed to obtain an initial array from a corresponding data table in the local database; the initial array includes at least one information array.

5. The intelligent analysis method for power transmission lines according to claim 1, characterized in that: The performing deduplication processing on the initial array to obtain a target array includes: When the initial array includes an information array, directly outputting the information array as the target array; When the initial array includes multiple information arrays, matrix multiplication is used to deduplicate each information array to generate a deduplication matrix, and identical arrays and difference arrays are extracted from the deduplication matrix to form a target array.

6. The intelligent analysis method for power transmission lines according to claim 1, characterized in that: The step of generating data summary prompt words according to the target array and the preset second constraint rule includes: The target array and each constraint operator in the preset second constraint rule are combined in a preset order to obtain a data summary prompt word; The operator types of the constraint operator in the second constraint rule include a prompt word basic format, query information, limited constraint conditions and output structure.

7. The intelligent analysis method for power transmission lines according to claim 1, characterized in that: The generating of a summary report corresponding to the data summary prompt word based on the preset summary parameter information includes: The preset summary parameter information and the data summary prompt words are input into the report summary model, so as to use the summary parameter information to perform parameter constraints on the report summary model, and the summary report corresponding to the data summary prompt words is output through the constrained report summary model.

8. A transmission line intelligent analysis device, characterized in that: include: A statement generation module, used to generate a data query prompt word according to the query information input by the user and the preset first constraint rule, and generate a query statement corresponding to the data query prompt word based on the preset query parameter information; A data processing module, used to query the local database where the power transmission line is located using the query statement to obtain an initial array, and perform deduplication processing on the initial array to obtain a target array; The report summary module is used to generate data summary prompt words according to the target array and the preset second constraint rule, and generate a summary report corresponding to the data summary prompt words based on preset summary parameter information.

9. A storage medium, characterized in that: The storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by one or more processors, the one or more processors execute the steps of the power transmission line intelligent analysis method as described in any one of claims 1 to 7.

10. A computer device, characterized in that: include: one or more processors, and memory; The memory stores computer-readable instructions, and when the computer-readable instructions are executed by the one or more processors, the steps of the power transmission line intelligent analysis method according to any one of claims 1 to 7 are performed.

Images