Method and apparatus for generating visualization result for indicator, device, medium, and product

Abstract

The present application relates to a method and apparatus for generating a visualization result for an indicator, a device, a medium, and a product. The method comprises: acquiring a data query file and a visualization transformation file, wherein the data query file comprises target database table information of each indicator among at least one indicator, the target database table information of each indicator indicates a database table for storing indicator data of said indicator, and the visualization transformation file comprises at least one transformation file; in response to an indicator query instruction carrying an indicator to be queried, on the basis of the data query file, determining target database table information of the indicator to be queried, and determining a target transformation file matching the indicator to be queried from among the at least one transformation file; and on the basis of the target database table information of the indicator to be queried and the target transformation file, generating a visualization result for the indicator to be queried. Use of the method can improve the efficiency of generating visualization results for indicators to be queried.

Description

Methods, devices, equipment, media, and products for generating visualization results of indicators Cross-references

[0001] This application incorporates Chinese Patent Application No. 202411952634.7, filed on December 26, 2024, entitled “Method, Apparatus, Device, Medium and Product for Generating Visualization Results of Indicators”, which is incorporated herein by reference in its entirety. Technical Field

[0002] This application relates to the field of new energy technology, and in particular to a method, apparatus, equipment, medium and product for generating visualization results of an indicator. Background Technology

[0003] With the development of information technology, the demand for data querying is also increasing. Taking energy storage scenarios as an example, a great deal of data needs to be collected in energy storage scenarios, thus generating a large amount of data. This data is usually stored in the deployed database in a cross-database and cross-table manner.

[0004] In some cases, when a user needs to query a metric, they need to input the metric into a computer device. The computer device then queries the metric data from a deployed database and generates a visualization of the metric based on that data.

[0005] However, in this case, there is a problem with the low efficiency of generating visualization results for the metrics to be queried. Summary of the Invention

[0006] Based on this, this application provides a method, apparatus, device, medium, and product for generating visualization results of indicators, which can improve the efficiency of generating visualization results of indicators to be queried.

[0007] In a first aspect, this application provides a method for generating visualization results of an indicator. The method includes: acquiring a data query file and a visualization conversion file; the data query file includes target library table information for each indicator in at least one indicator, the target library table information for each indicator indicating a library table used to store indicator data for each indicator; the visualization conversion file includes at least one conversion file; in response to an indicator query instruction carrying an indicator to be queried, determining the target library table information of the indicator to be queried based on the data query file, and determining a target conversion file matching the indicator to be queried from at least one conversion file; and generating a visualization result of the indicator to be queried based on the target library table information and the target conversion file.

[0008] In the technical solution of this application embodiment, when the user-inputted query indicator is obtained, the target database table information of the query indicator is determined by using the target database table information of each indicator in at least one pre-configured indicator. The target conversion file matching the query indicator is determined by using at least one conversion file included in the pre-configured visualization conversion file. Therefore, based on the user-inputted query indicator, the computer device can automatically determine the target database table information and conversion file corresponding to the query indicator according to the pre-configured data query file and visualization conversion file. Then, using the pre-configured data query file and visualization conversion file, the reading of the query indicator data and the visualization conversion of the read data are completed. This eliminates the need for the user to input the database table information of the query indicator through cumbersome operations, and also eliminates the need for the user to input the conversion requirement information for visualizing the query indicator data through cumbersome operations. The computer device generates the target conversion file based on the conversion requirement information. Thus, this application embodiment can improve the efficiency of obtaining the database table information of the query indicator and the target conversion file matching the query indicator, thereby improving the efficiency of generating the visualization results of the query indicator.

[0009] In some embodiments, the data query file includes a target query statement for each indicator, and the target query statement for each indicator includes target database table information for each indicator. Determining the target database table information for the indicator to be queried based on the data query file includes: determining the target query statement for the indicator to be queried from the target query statements for each indicator included in the data query file; and determining the database table information in the target query statement as the target database table information for the indicator to be queried. In the technical solution of this application embodiment, the target query statement is included in the data query file. This eliminates the need for the user to input the target query statement, and also eliminates the need for computer equipment to generate the target query statement based on the indicator to be queried and its target database table information. Instead, the target query statement for the indicator to be queried is directly searched from the data query file based on the indicator to be queried. Therefore, the determination time of the target query statement for the indicator to be queried can be reduced, thereby improving data query efficiency. Furthermore, the target query statement for each indicator in the data query file can not only perform data queries but also determine the target database table information for each indicator. This allows direct location of the target database table information through the target query statement, eliminating the need to obtain the target database table information through other means, thus improving data query efficiency.

[0010] In some embodiments, the data query file includes database attribute information and an initial query statement for each metric. The database attribute information includes a mapping relationship between the initial database table information in the initial query statement and the target database table information of the deployed database. Determining the target database table information for the metric to be queried based on the data query file includes: determining the initial query statement for the metric to be queried based on the initial query statement for each metric included in the data query file; and determining the target database table information of the metric to be queried mapped from the initial database table information in the initial query statement based on the database attribute information. In the technical solution of this application embodiment, the initial query statement for each metric is determined before database deployment. After database deployment is completed or when the database is modified, there is no need to change the initial query statement; only the mapping relationship between the initial database table information in the initial query statement and the target database table information of the deployed database needs to be maintained, thereby improving the flexibility and scalability of the data query file.

[0011] In some embodiments, the indicator query instruction also carries attribute information of the device to be queried and / or the business type of the service to be queried; determining the target database table information of the indicator to be queried, mapped from the initial database table information in the initial query statement of the indicator to be queried, based on the database attribute information and the attribute information of the device to be queried and / or the business type of the service to be queried, includes: determining preset database table information associated with the attribute information of the device to be queried and / or the business type of the service to be queried, based on the database attribute information and the attribute information of the device to be queried and / or the business type of the service to be queried; and determining the target database table information of the indicator to be queried from the preset database table information. In the technical solution of this application embodiment, the target database table information of the indicator to be queried not only matches the indicator to be queried, but also adapts to the business type of the device to be queried and / or the service to be queried, so that the indicator data of the indicator to be queried obtained through the target database table information also matches the attribute information of the device to be queried and / or the business type of the service to be queried that the user needs to query, thereby improving the accuracy of the query.

[0012] In some embodiments, each indicator is associated with a transformation file; determining the target transformation file matching the query indicator from at least one transformation file includes: determining the transformation file associated with the query indicator among the at least one transformation file as the target transformation file matching the query indicator. In the technical solution of this application embodiment, the transformation file associated with each indicator is pre-configured, so the computer device can select the corresponding transformation file according to the query indicator, without needing to generate or adjust the transformation file in real time based on the query indicator. This improves the efficiency of determining the target transformation file matching the query indicator, thereby improving data display efficiency. Furthermore, since each indicator is associated with a transformation file, the transformation file associated with each indicator can meet the data display requirements under each indicator, thereby reducing the possibility of incorrect data presentation due to improper transformation of related data of the indicator, and improving the accuracy of data display.

[0013] In some embodiments, generating a visualization result for the queried indicator based on the target database table information and the target transformation file includes: querying the indicator data of the queried indicator based on the target database table information; performing a visualization transformation on the indicator data of the queried indicator using the target transformation file to obtain visualization data with a preset data structure; and performing chart transformation on the visualization data using the obtained target chart type to generate a visualization result. In the technical solution of this application embodiment, the visualization data is transformed using the target chart type to obtain the visualization result, thereby making the chart type of the visualization result the target chart type. This allows the visualization data to be presented in the manner of the target chart type, thereby improving data readability.

[0014] In some embodiments, a target conversion file is used to perform a visualization conversion on the indicator data of the query indicator to obtain visualized data with a preset data structure. This includes: obtaining the data conversion function and data display format from the target conversion file; processing the indicator data of the query indicator using the data conversion function to obtain the processing result; and converting the processing result using the data display format to obtain visualized data. In the technical solution of this application embodiment, the indicator data of the query indicator is processed by the configured data conversion function, and the resulting processing result can meet the user's display needs, improve the accuracy of data presentation, and the visualization result can be displayed using the configured data display format, improving the understandability of the displayed data.

[0015] In some embodiments, obtaining a data query file includes: obtaining a data query template; the data query template includes field characteristic information; determining database attribute information based on the field characteristic information; and generating a data query file based on the database attribute information. In the technical solution of this application embodiment, the database attribute information is determined based on the field characteristic information in the data query template, making the database information flexibly determined based on the field characteristic information in the query template, thereby improving the flexibility of the data query file generated through the database attribute information.

[0016] In some embodiments, determining database attribute information based on field characteristic information includes: obtaining fill data matching the field characteristic information; storing the fill data in an information table in a deployed database; and determining database attribute information based on the information table storing the fill data. In the technical solution of this application embodiment, obtaining fill data matching the field characteristic information ensures that the fill data meets the indicator data characteristics of the corresponding field characteristic information, thereby improving the accuracy of the obtained fill data. Furthermore, storing the fill data in an information table in a deployed database and determining database attribute information based on the information table storing the fill data allows the database attribute information to be updated accordingly based on the storage of the fill data, thus improving the accuracy of the determined database attribute information.

[0017] In some embodiments, obtaining fill data matching field characteristic information includes: when a single field characteristic information matches at least two types of parameter data, obtaining the priority order of the at least two types of parameter data; and determining fill data matching the single field characteristic information from the at least two types of parameter data according to the priority order of the at least two types of parameter data. In the technical solution of this application embodiment, by using a pre-set priority order of at least two types of parameter data, the most suitable fill data can be flexibly selected from at least two types of parameter data, improving the flexibility of data filling and avoiding the process of comparing and selecting at least two types of parameter data, thereby enabling rapid determination of fill data and improving the efficiency of data filling.

[0018] In some embodiments, obtaining fill data matching field characteristic information includes: obtaining initial data matching field characteristic information; and processing the initial data using data processing functions defined in the field characteristic information to obtain fill data matching field characteristic information. In the technical solution of this application embodiment, the initial data is processed using data processing functions defined in the field characteristic information, thereby enabling at least one of the following processing methods: data cleaning, data transformation, and data validation, thus improving the accuracy and consistency of the obtained fill data.

[0019] In some embodiments, the indicator query instruction also carries the business type of the business to be queried; obtaining data query files and visualization conversion files includes: obtaining information query files and information conversion files for each business type under at least one business type; and determining the information query files and information conversion files of the business type of the business to be queried as data query files and visualization conversion files. In the technical solution of this application embodiment, by pre-configuring information query files and information conversion files for each business type under at least one business type, the corresponding information query files and information conversion files can be flexibly determined according to the needs of the business type, thereby flexibly responding to the data query needs of different business types and improving the effectiveness of data query.

[0020] In some embodiments, the method further includes: obtaining an indicator query directory; the indicator query directory includes the identifier of at least one indicator; storing data query files and / or visualization conversion files according to the indicator query directory, and generating a read path corresponding to each indicator; the read path corresponding to each indicator is used to read the content related to each indicator in the data query file and the conversion file corresponding to each indicator in the visualization conversion file. In the technical solution of this application embodiment, each directory item in the indicator query directory corresponds to a pre-set indicator. By storing the data query files and visualization conversion files according to the indicator query directory, they can be stored according to the content related to each indicator in the data query file and the conversion file corresponding to each indicator in the visualization conversion file, making the storage of data query files and visualization conversion files structured storage, which helps to reduce the chaos of file storage and improve the effectiveness of file storage; and generating a read path corresponding to each indicator according to each type of storage is beneficial for reading the content related to each indicator in the data query file and the conversion file corresponding to each indicator in the visualization conversion file according to the read path, thus improving data reading efficiency.

[0021] In some embodiments, the method further includes: in response to a modification instruction to modify the template file, obtaining modification information of the template file; the template file includes a data query file and / or a visualization conversion file; updating the template file according to the modification information of the template file; and outputting an indication that the modification of the template file is complete. In the technical solution of this application embodiment, when it is determined that the user needs to modify the template file, updating the template file according to the modification information is sufficient, thereby improving the efficiency of template file modification.

[0022] Secondly, this application provides an apparatus for generating visualization results of an indicator. The apparatus includes: an acquisition module for acquiring a data query file and a visualization conversion file; the data query file includes target library table information for each indicator in at least one indicator, and the target library table information for each indicator indicates a library table used to store indicator data for each indicator; the visualization conversion file includes at least one conversion file; a determination module for determining, in response to an indicator query instruction carrying an indicator to be queried, the target library table information of the indicator to be queried is determined according to the data query file, and the target conversion file matching the indicator to be queried is determined from at least one conversion file; and a generation module for generating a visualization result of the indicator to be queried based on the target library table information and the target conversion file.

[0023] Thirdly, this application provides a computer device including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps of the method of any one of the first aspects.

[0024] Fourthly, this application provides a computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the steps of the method of any one of the first aspects.

[0025] Fifthly, this application provides a computer program product, including a computer program, wherein when the computer program is executed by a processor, it implements the steps of the method of any one of the first aspects. Attached Figure Description

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

[0027] Figure 1 is a schematic diagram of the structure of an index query system provided in some embodiments;

[0028] Figure 2 is a flowchart illustrating the method for generating visualization results of indicators provided in the first embodiment;

[0029] Figure 3 is a flowchart illustrating the method for generating visualization results of indicators provided in the second embodiment;

[0030] Figure 4 is a flowchart illustrating the method for generating visualization results of indicators provided in the third embodiment;

[0031] Figure 5 is a flowchart illustrating the method for generating visualization results of indicators provided in the fourth embodiment;

[0032] Figure 6 is a flowchart illustrating the method for generating visualization results of indicators provided in the fifth embodiment;

[0033] Figure 7 is a flowchart illustrating the method for generating visualization results of indicators provided in the sixth embodiment;

[0034] Figure 8 is a flowchart illustrating the template file generation method and indicator query process provided in some embodiments;

[0035] Figure 9 is a schematic diagram of the format of the data query file provided in some embodiments;

[0036] Figure 10 is a flowchart illustrating the template file storage method provided in some embodiments;

[0037] Figure 11 is a schematic diagram of determining the fill data provided in some embodiments;

[0038] Figure 12 is a flowchart illustrating the template file update method and indicator query process provided in some embodiments;

[0039] Figure 13 is a schematic diagram of the structure of the visualization result generation device for indicators provided in some embodiments;

[0040] Figure 14 is a schematic diagram of the structure of a computer device provided in some embodiments. Detailed Implementation

[0041] The embodiments of the technical solution of this application will now be described in detail with reference to the accompanying drawings. These embodiments are only used to more clearly illustrate the technical solution of this application and are therefore merely examples, and should not be used to limit the scope of protection of this application.

[0042] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application pertains; the terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit the application; the terms “comprising” and “having”, and any variations thereof, in the specification, claims, and foregoing description of the drawings are intended to cover non-exclusive inclusion.

[0043] In the description of the embodiments of this application, technical terms such as "first" and "second" are used only to distinguish different objects and should not be construed as indicating or implying relative importance or implicitly specifying the number, specific order, or primary and secondary relationship of the indicated technical features. In the description of the embodiments of this application, "multiple" means two or more, unless otherwise explicitly defined.

[0044] In this document, the term "embodiment" means that a particular feature, structure, or characteristic described in connection with an embodiment may be included in at least one embodiment of this application. The appearance of this phrase in various places throughout the specification does not necessarily refer to the same embodiment, nor is it a separate or alternative embodiment mutually exclusive with other embodiments. It will be explicitly and implicitly understood by those skilled in the art that the embodiments described herein can be combined with other embodiments.

[0045] In the description of the embodiments in this application, the term "and / or" is merely a description of the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can represent: A existing alone, A and B existing simultaneously, and B existing alone. Additionally, the character " / " in this document generally indicates that the preceding and following related objects have an "or" relationship.

[0046] With the rapid development of technologies such as the Internet, the Internet of Things, and artificial intelligence, data is experiencing explosive growth. Taking energy storage as an example, energy storage scenarios involve numerous devices, each requiring the collection of various data types, resulting in massive amounts of data, typically stored across multiple databases and tables. When a user needs to query data related to a specific indicator, they must input the indicator to be queried, the database / table information to be queried, and the data visualization requirements into the computer. The computer reads the indicator data based on the user-input database / table information, generates a target transformation file for data visualization based on the transformation requirements, and uses this target transformation file to perform the visualization transformation of the queried indicator data, thus obtaining the visualized result of the queried indicator.

[0047] However, research has found that during the generation of visualization results for indicators, computer equipment often needs to wait a long time for users to input the database information of the indicator to be queried and the conversion requirements to match the indicator. As a result, the acquisition time of the database information of the indicator to be queried and the target conversion file to match the indicator is long. Therefore, if the acquisition time of the database information of the indicator to be queried and the target conversion file to match the indicator to be queried can be reduced, the acquisition efficiency of the database information of the indicator to be queried and the target conversion file to match the indicator to be queried can be improved, thereby improving the generation efficiency of visualization results of the indicator to be queried.

[0048] To alleviate the aforementioned problems, research revealed that if data query files and visualization conversion files are pre-configured, each time a query command carrying the query indicator is received, the computer automatically determines the target database table information for the query indicator based on the data query file and the target conversion file matching the query indicator based on the visualization conversion file. This eliminates the need for users to manually input the database table information or the conversion requirements for visualizing the query indicator data. The computer does not need to wait for extended periods for users to input the database table information and the matching conversion requirements, thus reducing the time required to acquire these information and improving the efficiency of obtaining the query indicator's database table information and the matching conversion file. This, in turn, improves the efficiency of generating the visualization results for the query indicator.

[0049] Based on the above considerations, this application provides a method for generating visualization results of an indicator, which involves obtaining a data query file and a visualization conversion file; the data query file includes target library table information for each indicator in at least one indicator, and the target library table information for each indicator indicates a library table used to store indicator data for each indicator; the visualization conversion file includes at least one conversion file; in response to an indicator query instruction carrying an indicator to be queried, the target library table information for the indicator to be queried is determined according to the data query file, and a target conversion file matching the indicator to be queried is determined from at least one conversion file; and the visualization result of the indicator to be queried is generated according to the target library table information and the target conversion file.

[0050] In this way, upon obtaining the user-inputted query indicator, the target database table information of the query indicator is determined using the target database table information of each indicator in at least one pre-configured indicator set. The target conversion file matching the query indicator is determined using at least one pre-configured visualization conversion file. Therefore, based on the user-inputted query indicator, the computer device can automatically determine the corresponding target database table information and conversion file according to the pre-configured data query file and visualization conversion file. Then, using the pre-configured data query file and visualization conversion file, the computer device completes the reading of the query indicator data and the visualization conversion of the read data. This eliminates the need for the user to manually input the database table information of the query indicator or the conversion requirements for visualizing the query indicator data. The computer device generates the target conversion file based on the conversion requirements. Thus, this embodiment of the application improves the efficiency of obtaining the database table information of the query indicator and the target conversion file matching the query indicator, thereby improving the efficiency of generating the visualization results of the query indicator.

[0051] The methods described in this application embodiment can be applied to computer devices or any other devices with computing capabilities. Exemplarily, a computer device may include one or more of the following: a server, a mobile phone, a tablet computer, a computer with transceiver capabilities, a handheld computer, a desktop computer, a personal digital assistant, a portable media player, a smart speaker, a navigation device, a smartwatch, smart glasses, a smart necklace, and other wearable devices, a pedometer, a digital TV, a virtual reality (VR) terminal device, an augmented reality (AR) terminal device, a terminal in industrial control, a terminal in self-driving, a terminal in remote medical surgery, a terminal in a smart grid, a terminal in transportation safety, a terminal in a smart city, a terminal in a smart home, a vehicle in a vehicle-to-everything (V2X) system, in-vehicle equipment, in-vehicle modules, etc.

[0052] Figure 1 is a schematic diagram of the structure of an indicator query system provided in some embodiments. As shown in Figure 1, the indicator query system includes a user terminal device, a computer device, and a database service node. Exemplarily, the database service node includes at least one service node. A database is deployed in the database service node.

[0053] For example, the user terminal device can be a mobile phone, computer, or industrial control computer. The user terminal device can display an indicator query system interface, which displays at least one indicator so that the user can select the indicator to be queried from the at least one indicator, so that the user terminal device obtains the indicator to be queried; or, the indicator query system interface can display an indicator input box so that the user can input the indicator to be queried, so that the user terminal device obtains the indicator to be queried.

[0054] The user-end device can send an indicator query command carrying the indicator to be queried to the computer device, so that the computer device can determine the target database table information of the indicator to be queried based on the data query file, and determine the target transformation file matching the indicator to be queried from at least one transformation file; and generate a visualization result of the indicator to be queried based on the target database table information and the target transformation file. In some embodiments, the computer device can output the visualization result of the indicator to be queried to the user-end device.

[0055] The indicator query scheme provided in this application is not limited to any particular application scenario. For example, it can be used in new energy scenarios or other scenarios. Other scenarios include communication scenarios, industrial production scenarios, or Internet of Things scenarios.

[0056] Figure 2 is a flowchart illustrating the method for generating visualization results of indicators provided in the first embodiment. This method is applied to a computer device and includes:

[0057] S201. Obtain the data query file and the visualization conversion file; the data query file includes target database table information for each indicator in at least one indicator, and the target database table information for each indicator indicates the database table used to store the indicator data for each indicator; the visualization conversion file includes at least one conversion file.

[0058] In some embodiments, the data query files and visualization conversion files can be obtained from the current device (also referred to as the local device or computer device). In other embodiments, the data query files and visualization conversion files can be obtained from a third-party device other than the current device.

[0059] In some embodiments, at least one metric may be a predefined metric. For example, at least one metric may be determined based on at least one of the following: user needs, business needs, functional needs, etc. In some embodiments, a metric may include at least one of the following: metric identifier, metric content, metric description information, metric indicating fields, etc. For example, a metric identifier may include a metric code. For example, a metric identifier may include metric 1, metric 2, metric 3, etc.

[0060] In some embodiments, an indicator may indicate at least one field, and different indicators may indicate different fields. The associated data of an indicator may include data under at least one field. For example, if an indicator indicates both a temperature field and a voltage field, then the associated data of the indicator may include data under the temperature field and data under the voltage field. As another example, if an indicator indicates a temperature field, then the associated data of the indicator may include data under the temperature field.

[0061] In some embodiments, a database table includes an information table in a database. In some embodiments, the database table information includes at least one of the following: a database table identifier, database table attribute information, a database table storage location, and a database table read path. For example, the database table identifier may include a database identifier and an information table identifier. For instance, the database identifier may include a database name, and the information table identifier may include an information table name. For example, the database table attribute information may include database attribute information and information table attribute information. For example, the database table storage location may include the storage location of the information table in the database. For example, the database table storage location may include the storage location of the information table in the database. For example, the database table read path may include the read path of the information table in the database.

[0062] In some embodiments, the target table information represents table information in the deployed database. Exemplarily, the table information in the deployed database can be actual table information. In one application scenario, the deployed database may include at least one database deployed in the actual application scenario, each database including at least one information table containing stored data.

[0063] In some embodiments, the target database table information for each metric may indicate a database table used to store all relevant data for each metric. In other embodiments, the target database table information for each metric may indicate a database table for relevant data corresponding to at least one user permission information. For example, the target database table information for each metric may indicate a database table for relevant data corresponding to permission 1, and a database table for relevant data corresponding to permission 2.

[0064] In some embodiments, the data query file includes the association between each of at least one indicator and a corresponding target database table. In other embodiments, the data query file includes the association between each of at least one indicator and a corresponding initial database table, as well as the association between the initial database table and the target database table.

[0065] For example, a visualization transformation file may include transformation files of at least one transformation type, and each transformation type of transformation file includes at least one transformation file. For example, transformation files of different transformation types are used to perform different transformations on relevant data of an indicator. In some embodiments, different transformation files under the same transformation type differ in at least one of the following: data transformation function, data display format.

[0066] For example, a conversion file of at least one conversion type may include three types of conversion files: a single-value single-field conversion file, a multi-value list conversion file, and a multi-value single-field conversion file. For example, a multi-value list conversion file may include a multi-value multi-field conversion file. Furthermore, for example, a conversion file of at least one conversion type may be one type of conversion file listed above, or two types of conversion files, or at least one type of conversion file listed above, as well as other types of conversion files not shown in this application.

[0067] In some embodiments, each conversion file corresponds to at least one category of metric, wherein different conversion files correspond to different categories of metric, so that for each category of metric, a conversion file corresponding to that category of metric can be found.

[0068] For example, the category of the indicator to be queried is the first category. The first category indicates the field analysis requirement of the field indicated by the indicator to be queried, which is to analyze one value in a single field. The corresponding transformation file is a single-value single-field transformation file. For example, analyzing the maximum value of the data in the temperature field each day.

[0069] For example, the category of the queried indicator is the second category. The second category indicates the field analysis requirements for the field indicated by the queried indicator, which is to perform correlation analysis on the data in at least two fields. The corresponding transformation file is a multi-value list transformation file. For example, performing correlation analysis on the data under the temperature field and the data under the voltage field.

[0070] For example, the category of the indicator to be queried is the third category. The third category indicates the field analysis requirements of the field indicated by the indicator to be queried, which is to analyze multiple values ​​in a single field. The corresponding conversion file is a multi-value single-field conversion file. For example, analyzing at least two values ​​of the temperature field, such as the maximum, minimum, average, and median, for each day.

[0071] S202. In response to an indicator query instruction carrying an indicator to be queried, determine the target database table information of the indicator to be queried based on the data query file, and determine the target transformation file that matches the indicator to be queried from at least one transformation file.

[0072] In some embodiments, the indicator query instruction can be sent from the user terminal device to the computer device, or it can be generated by the user entering (or selecting) the indicator to be queried in the indicator query system interface displayed on the user terminal device. In other embodiments, the indicator query instruction can be generated by the user entering (or selecting) the indicator to be queried in the indicator query system interface displayed on the computer device.

[0073] In some embodiments, the indicator query instruction carries at least one of the following for the indicator to be queried: indicator identifier, indicator content, indicator description information, and fields indicated by the indicator. For example, the indicator query instruction carries the indicator identifier of the indicator to be queried.

[0074] In some embodiments, the metric to be queried can be a single metric. In other embodiments, the metric to be queried can be at least two metrics. Exemplarily, the metric to be queried can be all metrics under at least one device or at least one metric selected from all metrics.

[0075] In some embodiments, the indicator query instruction may also carry at least one of the following: attribute information of the device to be queried, business type of the business to be queried, and time period information corresponding to the data. For example, the attribute information of the device to be queried may include at least one of the following: the identifier of the device to be queried, the type of the device to be queried, and the description information of the device to be queried. For example, the business type of the business to be queried may include at least one of the following: the business type of sales business, the business type of procurement business, the business type of production business, the business type of logistics business, etc. For example, the time period information corresponding to the data may include one of the following: the past month, the past two months, the past three months, the past six months, the past year, or all time periods, etc.

[0076] The following describes an implementation method using an indicator query command that carries the attribute information of the device to be queried, the business type of the service to be queried, and the corresponding time period information: In some implementation scenarios, the indicator query system interface may include at least one business type. In response to a trigger operation on the business type of the service to be queried within the at least one business type, at least one device under the business type of the service to be queried is displayed. In response to a trigger operation on the device to be queried within the at least one device, at least one indicator under the device to be queried is displayed. In response to a trigger operation on the indicator to be queried within the at least one indicator, at least one time period is displayed. In response to a trigger operation on the target time period within the at least one time period, an indicator query command is generated. In other implementation scenarios, the indicator query system interface may include business type options, device options, indicator options, and time period options. In response to a trigger operation on the business type of the service to be queried under the business type option, a trigger operation on the device to be queried under the device option, a trigger operation on the indicator to be queried under the indicator option, and a trigger operation on the target time period under the time period option, an indicator query command is generated.

[0077] In some embodiments, the target database table information for the queried indicator may include target database table information that matches the queried indicator. In some embodiments, the indicator query instruction may also carry user identification information, and the target database table information that matches the target user permission information and the queried indicator can be determined based on the data query file and the target user permission information corresponding to the user identification information.

[0078] In some embodiments, determining the target transformation file that matches the query metric may include: determining the category of the query metric, determining the target transformation file type based on the category of the query metric, and determining the target transformation file that matches the query metric based on the target transformation file type.

[0079] For example, the target conversion file can be one of at least one conversion file under the target conversion file type.

[0080] In other embodiments, each indicator is associated with a transformation file. Determining the target transformation file that matches the query indicator may include: determining the transformation file associated with the query indicator in at least one transformation file as the target transformation file that matches the query indicator.

[0081] S203. Based on the target database table information and target transformation file of the indicator to be queried, generate the visualization results of the indicator to be queried.

[0082] In some embodiments, the indicator data of the indicator to be queried can be queried based on the target database table information of the indicator to be queried, and the indicator data of the indicator to be queried can be visualized based on the target transformation file to obtain the visualization result of the indicator to be queried.

[0083] In some instances, the computer device can output a visualization of the metric to be queried. For example, when the metric query command is sent by the user's terminal device, the visualization is sent to the user's terminal device. Another example is when the metric query command is generated by the user entering the metric to be queried into the metric query system interface displayed on the computer device, and the visualization is output to the metric query system interface.

[0084] In some embodiments, the target information table in the target database corresponding to the target database table information can be determined based on the target database table information of the queried indicator, and the indicator data of the queried indicator can be queried from the target information table in the target database. In some embodiments, the indicator data of the queried indicator can be queried based on the target database table information of the queried indicator and the query statement of the queried indicator.

[0085] In some implementations, a target transformation file can be used to perform a visualization transformation on the indicator data of the query indicator to obtain visualized data; based on the visualized data, a visualization result can be generated.

[0086] For example, the visualization data can be transformed according to the default chart type corresponding to the target transformation file to obtain the visualization result. For instance, the default chart type corresponding to the target transformation file may include the default chart type corresponding to the target transformation file type to which the target transformation file belongs.

[0087] For example, in response to the target chart type entered by the user through the indicator query system interface, the visualization data can be transformed according to the target chart type to obtain the visualization result.

[0088] In the technical solution of this application embodiment, when the user-inputted query indicator is obtained, the target database table information of the query indicator is determined by using the target database table information of each indicator in at least one pre-configured indicator. The target conversion file matching the query indicator is determined by using at least one conversion file included in the pre-configured visualization conversion file. Therefore, based on the user-inputted query indicator, the computer device can automatically determine the target database table information and conversion file corresponding to the query indicator according to the pre-configured data query file and visualization conversion file. Then, using the pre-configured data query file and visualization conversion file, the reading of the query indicator data and the visualization conversion of the read data are completed. This eliminates the need for the user to input the database table information of the query indicator through cumbersome operations, and also eliminates the need for the user to input the conversion requirement information for visualizing the query indicator data through cumbersome operations. The computer device generates the target conversion file based on the conversion requirement information. Thus, this application embodiment can improve the efficiency of obtaining the database table information of the query indicator and the target conversion file matching the query indicator, thereby improving the efficiency of generating the visualization results of the query indicator.

[0089] Figure 3 is a flowchart illustrating the method for generating visualization results of indicators provided in the second embodiment. This method is applied to a computer device. The difference between the embodiment in Figure 3 and the embodiment in Figure 2 is that the data query file includes the target query statement for each indicator, the target query statement for each indicator includes the target database table information for each indicator, and S202 includes S2021 to S2023:

[0090] S2021. In response to an indicator query instruction carrying an indicator to be queried, determine the target query statement of the indicator to be queried from the target query statements of each indicator included in the data query file.

[0091] In some embodiments, the query statement may include a Structured Query Language (SQL) query statement.

[0092] In some embodiments, the data query file includes at least one indicator identifier and at least one target query statement corresponding one-to-one with the at least one indicator identifier. In some embodiments, the target query statement for an indicator may include at least one query statement.

[0093] S2022. Determine the database table information in the target query statement as the target database table information for the query metric.

[0094] In some embodiments, each target query statement in at least one target query statement includes database table information, and the database table information included in each target query statement is the target database table information for each indicator.

[0095] In some embodiments, the indicator data of the indicator to be queried can be queried based on the target database table information of the indicator to be queried and the target query statement of the indicator to be queried.

[0096] S2023. From at least one transformation file, determine the target transformation file that matches the query metric.

[0097] In the technical solution of this application embodiment, the target query statement is included in the data query file. Users do not need to input the target query statement, nor does the computer device need to generate the target query statement based on the queried indicator and its target database table information. Instead, the target query statement for the queried indicator is directly retrieved from the data query file based on the queried indicator. This reduces the determination time of the target query statement for the queried indicator, thereby improving data query efficiency. Furthermore, the target query statement for each indicator in the data query file can not only perform data queries but also determine the target database table information for each indicator. Thus, the target database table information can be directly located through the target query statement without needing to obtain it through other means, further improving data query efficiency.

[0098] Figure 4 is a flowchart illustrating the visualization result generation method for indicators provided in the third embodiment. This method is applied to a computer device. The difference between the embodiment in Figure 4 and the embodiment in Figure 2 is that the data query file includes database attribute information and an initial query statement for each indicator. The database attribute information includes the mapping relationship between the initial database table information in the initial query statement and the target database table information of the deployed database. S202 includes S2024, S2025, and S2023.

[0099] S2024. In response to an indicator query instruction carrying an indicator to be queried, determine the initial query statement for the indicator to be queried based on the initial query statement for each indicator included in the data query file.

[0100] In some embodiments, the initial query statement is a predefined query statement.

[0101] In some embodiments, the data query file includes database attribute information, an identifier for each metric, and an initial query statement for each metric associated with the identifier. In other embodiments, the data query file includes database attribute information, an identifier for each metric, and a metric file associated with the identifier, each metric file including an initial query statement for each metric.

[0102] In some embodiments, the initial query statement for a metric may include at least one query statement. In some embodiments, the initial query statement for a metric includes initial database table information. In some embodiments, the database table information in the initial query statement is not the database table information of the deployed database; therefore, it is necessary to determine the target database table information mapped to the initial database table information based on the database attribute information.

[0103] S2025. Based on the database attribute information included in the data query file, determine the target database table information of the query indicator mapped from the initial database table information in the initial query statement of the query indicator.

[0104] In some embodiments, database attribute information may include target database table information of the deployed database mapped from the initial database table information in each initial query statement.

[0105] S2023. From at least one transformation file, determine the target transformation file that matches the query metric.

[0106] In the technical solution of this application embodiment, the initial query statement for each indicator is determined before the database is deployed. After the database is deployed or when the database is modified, there is no need to change the initial query statement. It is only necessary to maintain the mapping relationship between the initial database table information in the initial query statement and the target database table information of the deployed database, thereby improving the flexibility and scalability of the data query file.

[0107] In some embodiments, the indicator query instruction also carries attribute information of the device to be queried; determining the target database table information of the indicator to be queried, which is mapped from the initial database table information in the initial query statement of the indicator to be queried, based on the database attribute information, includes: determining preset database table information associated with the attribute information of the device to be queried, based on the database attribute information and the attribute information of the device to be queried; and determining the target database table information of the indicator to be queried from the preset database table information.

[0108] In some embodiments, the indicator query instruction also carries the business type of the business to be queried; determining the target database table information of the indicator to be queried, which is mapped from the initial database table information in the initial query statement of the indicator to be queried, based on the database attribute information, includes: determining the preset database table information associated with the business type of the business to be queried, based on the database attribute information and the business type of the business to be queried; and determining the target database table information of the indicator to be queried from the preset database table information.

[0109] In some embodiments, the indicator query instruction also carries attribute information of the device to be queried and the business type of the service to be queried; determining the target database table information of the indicator to be queried, which is mapped from the initial database table information in the initial query statement of the indicator to be queried, based on the database attribute information, and based on the attribute information of the device to be queried and the business type of the service to be queried, based on the business type of the service to be queried, based on the database attribute information; and determining the target database table information of the indicator to be queried from the preset database table information.

[0110] For example, the indicator query instruction instructs the presentation of data under the voltage field of device A in the production process.

[0111] For example, the preset database table information may include at least one information table under each database in at least one database.

[0112] In some implementations, when the indicator query instruction also carries the attribute information of the device to be queried and the service type of the service to be queried, determining the preset database table information associated with the device to be queried and the service type of the service to be queried based on the attribute information of the device to be queried and the service type of the service to be queried can be achieved in the following ways: determining the set database table information associated with the service type of the service to be queried based on the service type of the service to be queried; determining the preset database table information associated with the device to be queried from the set database table information based on the attribute information of the device to be queried.

[0113] In the technical solution of this application embodiment, the target database table information of the query indicator not only matches the query indicator, but also adapts to the business type of the query device and / or the query service. Thus, the indicator data of the query indicator obtained through the target database table information also matches the attribute information of the query device and / or the business type of the query service that the user needs to query, thereby improving the accuracy of the query.

[0114] In some embodiments, querying the indicator data of the indicator to be queried based on the target database table information of the indicator to be queried includes: replacing the initial database table information in the initial query statement of the indicator to be queried with the target database table information of the indicator to be queried to obtain the target query statement; and querying the indicator data of the indicator to be queried based on the target query statement.

[0115] In some embodiments, the indicator data of the indicator to be queried can be queried based on the target database table information of the indicator to be queried and the target query statement of the indicator to be queried.

[0116] In the technical solution of this application embodiment, there is no need for the user to input the target query statement, nor is there a need for the computer device to generate the target query statement based on the queried indicator and the target database table information of the queried indicator. Instead, the initial query statement of the queried indicator is directly found from the data query file based on the queried indicator, and the target query statement of the queried indicator is determined based on the initial query statement of the queried indicator. Therefore, the determination time of the target query statement of the queried indicator can be reduced, thereby improving the data query efficiency. Furthermore, by replacing the initial database table information in the initial query statement of the queried indicator with the target database table information of the queried indicator, the database table information in the target query statement is the actual database table information of the deployed database. This allows the computer device to accurately locate the position of the indicator data of the queried indicator based on the database table information in the target query statement, thereby improving the effectiveness of data retrieval.

[0117] Figure 5 is a flowchart illustrating the method for generating visualization results of indicators provided in the fourth embodiment. This method is applied to computer equipment. The difference between the embodiment in Figure 5 and the embodiment in Figure 2 is that each indicator is associated with a conversion file; S202 includes S2026 and S2027:

[0118] S2026. In response to an indicator query command carrying the indicator to be queried, determine the target database table information of the indicator to be queried based on the data query file.

[0119] S2027. Determine the transformation file associated with the query indicator in at least one transformation file as the target transformation file that matches the query indicator.

[0120] In some embodiments, the data query file includes N indicator identifiers, and the visualization transformation file also includes N transformation files, with a one-to-one correspondence between the N indicator identifiers and the N transformation files. For example, each transformation file may include a corresponding indicator identifier.

[0121] In the technical solution of this application embodiment, the conversion file associated with each indicator is pre-configured, so that the computer device can select the corresponding conversion file according to the indicator to be queried, without having to generate or adjust the conversion file in real time according to the indicator to be queried. This improves the efficiency of determining the target conversion file to match the indicator to be queried, thereby improving the efficiency of data display. Furthermore, since each indicator is associated with a conversion file, the conversion file associated with each indicator can meet the data display requirements of each indicator, thereby reducing the situation where improper conversion of the relevant data of the indicator leads to incorrect data presentation and improving the accuracy of data display.

[0122] In some embodiments, generating visualization results for the queried indicator based on the target database table information and the target transformation file includes: querying the indicator data of the queried indicator based on the target database table information; performing visualization transformation on the indicator data of the queried indicator using the target transformation file to obtain visualization data with a preset data structure; and performing chart transformation on the visualization data using the obtained target chart type to generate visualization results.

[0123] For example, the target chart type may include one of the following: column chart, pie chart, area chart, bar chart, line chart, scatter plot, histogram, donut chart, etc.

[0124] In some embodiments, the target chart type of the chart to be displayed may be carried in the indicator query instruction. In other embodiments, the computer device may obtain the target chart type from the user terminal device. In still other embodiments, the target chart type of the chart to be displayed may be determined in response to an operation instruction to select a target chart type in the indicator query system interface.

[0125] In some embodiments, the visualized data represents analytical data of the metric data to be queried. For example, the visualized data may include data for display. For instance, the visualized data may include: data for device A under the temperature field over three months. Another example is: data on the mapping relationship between the temperature and voltage fields for device A over three months. Yet another example is: the maximum, minimum, and average data for device A under the temperature field each day over three months. Yet another example is: the visualized data may be the sum of daily sales of device B over the past month. Yet another example is: the visualized data may be the sum of sales of devices B, C, and D over the past month, as a percentage of the total sales of devices B, C, and D.

[0126] In the technical solution of this application embodiment, the target chart type is used to perform chart transformation on the visualization data to obtain the visualization result, so that the chart type of the visualization result is the target chart type. In this way, the visualization data can be presented in the form of the target chart type, thereby improving the readability of the data.

[0127] In some embodiments, a target conversion file is used to perform a visualization conversion on the indicator data of the query indicator to obtain visualization data with a preset data structure. This includes: obtaining the data conversion function and data display format in the target conversion file; processing the indicator data of the query indicator using the data conversion function to obtain the processing result; and converting the processing result using the data display format to obtain visualization data.

[0128] In some embodiments, data conversion functions may include at least one of the following: type functions (e.g., string functions or double functions), functions for converting decimal points, time conversion functions, data operation functions, etc. For example, data operation functions may include at least one of the following: addition functions, subtraction functions, multiplication functions, division functions, exponentiation functions, logarithmic functions, etc. For instance, addition may include adding a preset value to data in a certain field.

[0129] In some embodiments, data transformation functions can be used to perform function transformations on data under at least one of the fields indicated by an indicator. For example, an indicator may indicate fields A, B, and C. The data transformation function can be used to perform an addition transformation on the data under field A using an addition function, and to perform a time transformation on the data under field B using a time transformation function.

[0130] In some embodiments, the data display format can be determined based on the business type of the service to be queried. For example, if the business type of the service to be queried indicates a sum calculation, the visualized data may include data plus a sum indicator. For example, if the business type of the service to be queried indicates a maximum value calculation, the visualized data may include data plus a maximum value indicator. For example, if the business type of the service to be queried indicates data from devices in a warehouse, the visualized data may include data plus a warehouse indicator.

[0131] In the technical solution of this application embodiment, the indicator data of the query indicator is processed by the configured data transformation function, and the processing result can meet the user's display needs, improve the accuracy of data presentation, and the visualization result can be displayed in the configured data display format, which improves the understandability of the displayed data.

[0132] Figure 6 is a flowchart illustrating the method for generating visualization results of indicators provided in the fifth embodiment. This method is applied to computer equipment. The difference between the embodiment in Figure 6 and the embodiment in Figure 2 is that, based on the embodiment in Figure 2, S201 includes S2011 to S2013:

[0133] S2011. Obtain the data query template; the data query template includes field characteristic information.

[0134] In some embodiments, the data query template may be determined before database deployment. For example, the data query template can be determined based on the user's business needs. For instance, based on the user's business needs, the fields that the user needs to collect and the required data information under those fields can be determined, and based on the required data information under those fields, the field characteristic information can be determined.

[0135] For example, field characteristic information may include at least one of the following: field identifier, field name information, access mode information, data type information, and output type information. For example, data type information may include at least one of the following: data specification information, minimum value information, maximum value information, and data processing function.

[0136] In some embodiments, the data query template may further include a target query statement for each metric. In other embodiments, the data query template may further include an initial query statement for each metric.

[0137] S2012. Determine database attribute information based on field characteristic information.

[0138] In some embodiments, target database table information matching the field characteristic information can be determined based on the field characteristic information, and database attribute information can be determined based on the target database table information. For example, database attribute information can be determined based on the mapping relationship between the target database table information and the initial database table information in the mapped initial query statement.

[0139] S2013. Generate a data query file based on the database attribute information and obtain a visualization conversion file.

[0140] In some embodiments, a data query file can be generated based on database attribute information and the target query statement for each indicator. In other embodiments, a data query file can be generated based on database attribute information and the initial query statement for each indicator.

[0141] In the technical solution of this application embodiment, database attribute information is determined based on field characteristic information in the data query template, so that the database information is flexibly determined based on field characteristic information in the query template, thereby improving the flexibility of the data query file generated by the database attribute information.

[0142] In some embodiments, determining database attribute information based on field characteristic information includes: obtaining fill data that matches the field characteristic information; storing the fill data in an information table in the deployed database; and determining database attribute information based on the information table storing the fill data.

[0143] In some implementations, the populated data for matching a single field characteristic is a type of parameter data. For example, the populated data for matching a single field characteristic may be one of the following: user-input parameters, parameters generated by the parameter engine, built-in parameters from the configuration center, built-in parameters from a file, built-in parameters from a table, dynamic built-in parameters, constant parameters, etc.

[0144] For example, database attribute information can be determined based on the name and / or address information of the information table storing the population data. For example, target database table information can be determined based on the name and / or address information of the information table storing the population data; and database attribute information can be determined based on the mapping relationship between the target database table information and the initial database table information in the mapped initial query statement.

[0145] In some embodiments, the information tables in the deployed database correspond to the data query templates, including field characteristic information. Therefore, the populated data matching the field characteristic information can be populated into the information tables in the deployed database.

[0146] In the technical solution of this application embodiment, the fill data that matches the field characteristic information is obtained. The fill data can meet the indicator data characteristics of the corresponding field characteristic information, thereby improving the accuracy of the obtained fill data. The fill data is stored in the information table of the deployed database. Based on the information table storing the fill data, the database attribute information is determined. Thus, the database attribute information can be updated accordingly based on the storage of the fill data, thereby improving the accuracy of the determined database attribute information.

[0147] In some embodiments, obtaining fill data that matches field characteristic information includes: obtaining the priority order of at least two types of parameter data when a single field characteristic information matches at least two types of parameter data; and determining fill data that matches the single field characteristic information from the at least two types of parameter data according to the priority order of the at least two types of parameter data.

[0148] For example, the priority order of at least two types of parameter data from high to low is as follows: user-input parameters, parameters generated by the parameter engine, built-in parameters from the configuration center, built-in parameters from files, built-in parameters from tables, dynamic built-in parameters, constant parameters, etc.

[0149] In the technical solution of this application embodiment, by pre-setting the priority order of at least two types of parameter data, the most suitable filling data can be flexibly selected from at least two types of parameter data, which improves the flexibility of data filling and avoids the process of comparing and selecting at least two types of parameter data, thereby enabling the filling data to be determined quickly and thus improving the filling efficiency of data filling.

[0150] In some embodiments, obtaining fill data that matches field characteristic information includes: obtaining initial data that matches field characteristic information; and processing the initial data using data processing functions in the field characteristic information to obtain fill data that matches field characteristic information.

[0151] For example, the initial data for matching field characteristic information may include the raw collected data.

[0152] For example, a data processing function may include at least one of the following: addition function, subtraction function, multiplication function, division function, exponentiation function, logarithmic function, unit conversion function, etc. For instance, a data processing function may include: setting or removing data outside the maximum and minimum value range defined in the field's characteristic information.

[0153] In the technical solution of this application embodiment, the data processing function defined in the field characteristic information is used to process the initial data, thereby enabling at least one of the following processes to be performed on the initial data: data cleaning, data conversion, data verification, etc., thereby improving the accuracy and uniformity of the obtained fill data.

[0154] Figure 7 is a flowchart illustrating the method for generating visualization results of indicators provided in the sixth embodiment. This method is applied to computer equipment. The difference between the embodiment in Figure 7 and the embodiment in Figure 2 is that, based on the embodiment in Figure 2, the indicator query instruction also carries the business type of the business to be queried. S201 includes S2014 to S2015:

[0155] S2014. Obtain information query files for each business type and information conversion files for each business type under at least one business type.

[0156] Different business types correspond to different information query files. For example, the information query file for each business type can be configured according to each business type.

[0157] Different business types correspond to different information conversion files. For example, the information conversion file for each business type can be configured according to each business type.

[0158] S2015. The information query file of the business type of the business to be queried and the information conversion file of the business type of the business to be queried are identified as the data query file and the visualization conversion file, respectively.

[0159] In the technical solution of this application embodiment, by pre-configuring at least one information query file and information conversion file for each business type under at least one business type, the corresponding information query file and information conversion file can be flexibly determined according to the needs of the business type, thereby flexibly responding to the data query needs of different business types and improving the effectiveness of data query.

[0160] In some embodiments, the method further includes: obtaining an indicator query directory; the indicator query directory includes the identifier of at least one indicator; storing a data query file and a visualization conversion file according to the indicator query directory, and generating a read path corresponding to each indicator; the read path corresponding to each indicator is used to read the content related to each indicator in the data query file and the conversion file corresponding to each indicator in the visualization conversion file.

[0161] In some embodiments, the content related to each metric in the data query file may include at least one of the following: target database table information for each metric, target query statement for each metric, initial query statement for each metric, and target database table information mapped from the initial database table information in the initial query statement for each metric.

[0162] In some embodiments, storing data query files and visualization conversion files according to an indicator query directory may include: if the current device has storage space for storing data query files and visualization conversion files, storing the data query files and visualization conversion files in the storage space of the current device according to the indicator query directory. In this way, the content related to each indicator in the data query file and the conversion file corresponding to each indicator in the visualization conversion file can be read from the current device via the read path corresponding to each indicator.

[0163] In some embodiments, storing data query files and visualization conversion files according to an indicator query directory may include: if the current device does not have storage space for storing data query files and visualization conversion files, storing the data query files and visualization conversion files in the storage space of a third-party device outside the current device, according to the indicator query directory. In this way, the content related to each indicator in the data query file and the corresponding conversion file in the visualization conversion file can be read from the third-party device through the read path corresponding to each indicator.

[0164] In the technical solution of this application embodiment, each directory item in the indicator query directory corresponds to a pre-set indicator. Data query files and visualization conversion files are stored according to the indicator query directory, so that they can be stored according to the content related to each indicator in the data query file and the conversion file corresponding to each indicator in the visualization conversion file. This makes the storage of data query files and visualization conversion files structured, which helps to reduce the chaos of file storage and improve the effectiveness of file storage. Furthermore, a reading path corresponding to each indicator is generated according to each type of storage, which is beneficial to reading the content related to each indicator in the data query file and the conversion file corresponding to each indicator in the visualization conversion file according to the reading path, thereby improving the data reading efficiency.

[0165] In some embodiments, the method further includes: in response to a modification instruction to modify the template file, obtaining modification information of the template file; the template file includes a data query file and / or a visualization conversion file; updating the template file according to the modification information of the template file; and outputting an indication that the modification of the template file is complete.

[0166] In the technical solution of this application embodiment, when it is determined that the user needs to modify the template file, the template file can be updated according to the modification information of the template file, thereby improving the modification efficiency of the template file.

[0167] The following example, using an energy storage scenario, illustrates the data query method in this application's embodiments:

[0168] In some embodiments, a data query method is provided. This method defines energy storage query data through a data query file and defines the page template structure through a visual conversion file. In some embodiments, for energy storage scenarios, indicator query statements for newly connected devices can be dynamically generated based on configured indicator query statements. In some embodiments, for energy storage scenarios, target database table information for newly connected devices can be dynamically generated based on configured initial database table information. In some embodiments, the indicator data of newly connected devices can be converted and displayed using data conversion functions in the visual conversion file.

[0169] In some embodiments, SQL and data structure descriptions are provided by providing data query files and visualization transformation files, and SQL maintenance is performed in file form.

[0170] In some instances, the target query statement can be dynamically generated by matching the fields indicated by the metrics in the data query file with the fields in the target environment's storage table (i.e., the information table in the deployed database), avoiding redundant metric configuration. In some embodiments, when obtaining the queried data, data transformation can be performed through function processing or script processing to achieve the final desired purpose.

[0171] In some embodiments, the provided data query method can be applied to an indicator visualization data model device in energy storage scenarios. This method proposes a dynamic generation approach using template files and a template engine, providing a full-cycle description of the energy storage indicator data layer, processing layer, and presentation layer. It also proposes a data processing engine specifically for energy storage scenarios. Based on existing data definitions, the engine adds capabilities such as function computation or script execution to adapt to the display requirements of multi-scenario data (e.g., various business types) in energy storage scenarios. The template files include data query files and visualization conversion files.

[0172] In some embodiments, a dynamic generation method for data indicators in energy storage scenarios is proposed. When a new energy storage device (e.g., any one or more devices in an energy storage scenario) is added, the existing template data fields are adapted through data definitions and / or algorithm definitions in the field characteristic information. After adaptation, a data query template can be generated in the corresponding deployment environment (deployed database) using the existing device indicators. The data query template determines the data query file and visualization conversion file. The template engine locates the target environment's query database table information and indicator query statements (SQL query statements) through the data query file, and completes the conversion of data to a visualization format through the visualization conversion file.

[0173] In some embodiments, the metric data is typically multi-level data. For example, there may be a multi-level situation where a bank maps to three containers and a container maps to ten racks. Therefore, in some scenarios, bank metrics are used on containers, and the metric can be adapted to containers based on the data definition of the bank.

[0174] In some embodiments, extended function processing capabilities or script processing capabilities are defined for the current data. That is, after the data is acquired, the data can be processed into visual data by executing functions, scripts, or code blocks. This process can be configured in the visualization conversion file. In some embodiments, it is not necessary to uninstall the service application when updating or upgrading the file.

[0175] Figure 8 is a flowchart illustrating the template file generation method and indicator query process provided in some embodiments. As shown in Figure 8, the file management module, indicator module, and dynamic template module are included in the computer device, and the file storage module may be included in the computer device or in a third-party device outside the computer device. The method includes:

[0176] S801, The user terminal device configures a data query template to the file management module.

[0177] For example, the data query template includes field characteristic information. For example, the data query template also includes an initial query statement for each metric. For example, the data query template also includes a visualization transformation file, which includes a transformation file for each metric.

[0178] S802, the file management module loads data query templates and parameters.

[0179] For example, the file management module can load parameters based on field characteristic information, such as obtaining fill data matching the field characteristic information; store the fill data in an information table in the deployed database; and determine the database attribute information based on the information table storing the fill data. A data query file is generated using the database attribute information and the initial query statement for each metric. The target database table information in the data query file is the actual database table information of the deployed database.

[0180] S803, Store data query files and visualization conversion files in the file storage module.

[0181] S804, The file storage module returns a configuration completion indication to the user terminal device.

[0182] S805, the user terminal device sends an indicator query command to the indicator module.

[0183] S806, the indicator module sends a template information retrieval request to the file storage module.

[0184] S807, The file storage module sends template information to the indicator module.

[0185] In some embodiments, the template information may include the corresponding target query statement and the corresponding conversion file.

[0186] S808, the indicator module sends template information to the dynamic template module.

[0187] S809 The dynamic template module determines the visualization result based on the template information content.

[0188] The S810 dynamic template module sends visual results to the user terminal device.

[0189] In some embodiments, a user interaction system may also be provided, which provides a set of visual pages (corresponding to the indicator query system interface mentioned above), and users can complete the above workflow operations and checks by referring to the visual pages.

[0190] In some embodiments, a method for dynamically generating indicator templates in energy storage scenarios is defined. The device generates indicator template data for the target environment by combining the indicator data definition of the target environment and related algorithm results with existing indicator templates. The generated indicator templates are available for querying. The indicator templates can be used independently, and modifications to the indicators do not require redeployment of the service itself, greatly improving modification efficiency.

[0191] In some embodiments, function processing and script processing capabilities based on existing data descriptions are provided. For existing indicator data, the process of processing from underlying data to visible data is completed through function execution, script processing, or code blocks, which greatly simplifies service coupling.

[0192] In some embodiments, the template engine can load two types of files: a data query file and a visualization transformation file. The data query file defines the database information of the target environment (i.e., the deployed database) and the corresponding SQL for the metrics. The parameters in the SQL can be assembled using a parameter engine. The visualization transformation file defines the return structure of the metrics, the content processing of the target fields (including function processing or script processing), and the return format of the target fields.

[0193] Figure 9 is a schematic diagram of the format of a data query file provided in some embodiments. As shown in Figure 9, the data query file includes database attribute information and at least one indicator identifier (indicator identifier 1 to indicator identifier N, where N is an integer greater than or equal to 1) with a query statement associated with each indicator identifier. For example, each indicator identifier can be directly associated with a corresponding query statement, or each indicator identifier can be associated with an indicator file, and the indicator file associated with each indicator identifier includes the query statement for each indicator.

[0194] The parameters in the SQL query can be assembled using a parameter engine. The data query file can contain a single indicator or multiple indicators; the template engine will locate the corresponding SQL query based on the indicator identifier.

[0195] In some embodiments, within an energy storage scenario, different data definitions (i.e., field characteristic information) can be obtained. These data definitions can include: field identifiers, field name information, access mode information, data type information, and output type information. For example, the data type information may include at least one of the following: data specification information, minimum value information, maximum value information, and data processing functions.

[0196] In some embodiments, the acquired parameters can be calculated and replaced according to different data definitions. At the same time, the template file can be dynamically upgraded and modified according to the parameters of different target environments to generate a new template file for the target environment.

[0197] In some embodiments, the visualization conversion file may include three types of conversion files: single-value single-field conversion file, multi-value list conversion file, and multi-value single-field conversion file.

[0198] For example, the format of a single-value single-field conversion file may include at least one of the following: indicator identifier, return type is single-value single-field type, field for which data return value needs to be grouped, group key value, group name, field corresponding to the value, script / function operation corresponding to the value, return value type (e.g., string), return value display format (e.g., value + sum, or value + average), and unit of display of the value (e.g., %).

[0199] For example, the format of a multi-value list conversion file may include at least one of the following: indicator identifier, a multi-value list return type, fields for which the data return values ​​need to be grouped, and the multi-value list content. The multi-value list content may include at least one of the following: the display format of the group key values, the display format of the group names, the field from which the value corresponding to the name is obtained, the field type (e.g., string) from which the value corresponding to the name is obtained, the return value display format, and the unit of numerical display. For example, the multi-value list content may also include scripts / functions corresponding to the numerical values.

[0200] For example, the format of a multi-value single-field conversion file may include at least one of the following: indicator identifier, return type multi-value single-field, fields for which data return values ​​need to be grouped, group key value, group name, and list of multi-value single-field types. The list of multi-value single-field types includes at least one of the following: group key value, group name, field corresponding to the value, script / function operation corresponding to the value, return value type (e.g., string), return value display format, and unit of display for the value (e.g., %).

[0201] In some embodiments, each transformation file in the visualization transformation file includes an indicator identifier, thereby determining the transformation file corresponding to the queried indicator based on the matching of the queried indicator in the indicator query instruction.

[0202] The following explains the process of loading and storing files:

[0203] In some embodiments, when the file management module receives template files (including data query files and visualization transformation files), it can deploy them to the file storage module of the current device via an Application Programming Interface (API). If no file storage module exists in the current deployment environment, the template files are stored in the file storage module of a third-party device (e.g., a resource device). File links are generated based on the stored template files. Parameters under the fields indicated by various metrics in the data query file are populated when the data query template is loaded.

[0204] Figure 10 is a flowchart illustrating a method for storing template files according to some embodiments. As shown in Figure 10, this method is applied to a computer device, or to a file management module in a computer device. The method includes:

[0205] S1001, Obtain the data query template.

[0206] S1002. Obtain the deployed database.

[0207] S1003, parameter engine fills in parameters.

[0208] S1004. Should the template file be stored in the file storage module of the current device?

[0209] If S1004 is true, execute S1005; if S1004 is true, execute S1006.

[0210] S1005. Based on the indicator query directory, store the template file in the file storage module of the current device and generate the reading path corresponding to each indicator.

[0211] S1006. Based on the indicator query directory, store the template file to the file storage module of the third-party device and generate the reading path corresponding to each indicator.

[0212] After the templates are loaded, the global parameters in each template need to be populated.

[0213] Figure 11 is a schematic diagram of determining the fill data provided in some embodiments. As shown in Figure 11, the computer device can obtain built-in parameters of the configuration center (e.g., SQL), dynamic built-in parameters generated by the computer device, parameters input by the user, and constant parameters, and determine the fill data based on these parameters.

[0214] For example, the configuration priority of parameters is as follows: user input parameters > parameters generated by the parameter engine > built-in parameters from the configuration center > built-in parameters from files > built-in parameters from tables > dynamic built-in parameters > constant parameters.

[0215] For example, in SQL, you can configure a time parameter, ${today}. When the user executes the SQL, they can pass in the parameter today, such as today = "2024-08-29 00:00:00". The parameter engine will then replace ${today} in the parameter node with the passed parameter.

[0216] For example, in some scenarios in the battery field, some logic needs to be included for parameters, such as the need to perform some offset operations on time. In this case, some scripting processing can be performed on these parameters. For example, a calibration process will process the time of the hour before the current time. When the user executes the script, the parameter engine will execute the script, calculate the current execution time forward by one hour to generate the final time and fill it into the parameter.

[0217] In energy storage scenarios, data in certain display fields requires function or script processing. Therefore, the visualization conversion file provides corresponding configuration capabilities to configure the required function or script processing for the corresponding fields. For example, functions such as retaining two decimal places, time conversion, addition, subtraction, multiplication, and division are required.

[0218] In some embodiments, after template loading and parameter assembly are completed, the user transmits the required query indicator identifier to the computer device. The computer device first confirms whether the template file is in the device's own resource directory or in the target environment's storage medium based on the path link. After confirmation, the computer device retrieves the template to its local cache. For example, it finds the corresponding target query statement based on the indicator identifier, or it can obtain the target database table information of the target environment corresponding to the indicator identifier by querying the database attribute information configured in the template, and then obtains the corresponding SQL query statement for the indicator identifier. After the SQL query statement is executed successfully, the device obtains the conversion file corresponding to the indicator identifier, and performs data structure assembly and data result calculation based on the conversion file.

[0219] Figure 12 is a flowchart illustrating the template file update method and indicator query process provided in some embodiments. As shown in Figure 12, the file management module and the indicator query module are included in the computer device. The method includes:

[0220] S1201 The file management module receives modification instructions sent by the user terminal device to modify the template file.

[0221] S1202, The file management module obtains the modification information of the template file carried in the modification instruction.

[0222] S1203. The file management module sends the modification information of the template file to the file storage module so that the file storage module can update the template file.

[0223] S1204. The file storage module sends an indication message to the user terminal device that the template file modification is complete.

[0224] S1205, The user terminal device sends an indicator query command to the indicator query module.

[0225] S1206, The indicator query module sends a template information retrieval request to the file storage module.

[0226] S1207, The file storage module sends template information to the indicator query module.

[0227] S1208, the indicator query module sends data query information to the database device.

[0228] For example, the data query information includes the target query statement for the metric to be queried.

[0229] S1209. The database device sends the data corresponding to the data query information to the indicator query module.

[0230] S1210 The indicator query module uses the conversion file of the indicator to be queried to perform a visualization conversion on the data and obtain the visualization result.

[0231] S1211, The indicator query module outputs visual results to the user terminal device.

[0232] For example, when a user needs to upgrade a certain metric (e.g., change the target database table information, or change the calculation method in the conversion file), or handle online issues (e.g., metric lookup anomalies), the data query file and / or visualization conversion file need to be modified. After the file is modified, debugging can be performed. For example, two debugging methods can be provided: API and message body. The API method is applicable to both cloud and client-side environments, while the message body method is applicable to cloud environments.

[0233] Based on the same concept, this application also provides an apparatus for generating visualization results of indicators to implement the visualization result generation method of the indicators involved above. The solution provided by this apparatus is similar to the implementation scheme described in the above method. Therefore, the specific limitations of one or more embodiments of the visualization result generation apparatus for indicators provided below can be found in the limitations of the visualization result generation method of indicators above, and will not be repeated here.

[0234] In an exemplary embodiment, FIG13 is a schematic diagram of the structure of a visualization result generation device for indicators provided in some embodiments. As shown in FIG13, the visualization result generation device 1300 for indicators includes:

[0235] The acquisition module 1301 is used to acquire a data query file and a visualization conversion file; the data query file includes target library table information for each indicator in at least one indicator, and the target library table information for each indicator indicates the library table used to store the indicator data for each indicator; the visualization conversion file includes at least one conversion file; the determination module 1302 is used to, in response to an indicator query instruction carrying the indicator to be queried, determine the target library table information of the indicator to be queried according to the data query file, and determine the target conversion file matching the indicator to be queried from at least one conversion file; the generation module 1303 is used to generate the visualization result of the indicator to be queried according to the target library table information and the target conversion file of the indicator to be queried.

[0236] In some embodiments, the data query file includes a target query statement for each indicator, and the target query statement for each indicator includes target database table information for each indicator; the determination module 1302 includes a query statement determination unit and a database table information determination unit; the query statement determination unit is used to determine the target query statement for the indicator to be queried from the target query statements for each indicator included in the data query file; the database table information determination unit is used to determine the database table information in the target query statement as the target database table information for the indicator to be queried.

[0237] In some embodiments, the data query file includes database attribute information and an initial query statement for each indicator; the database attribute information includes a mapping relationship between the initial database table information in the initial query statement and the target database table information of the deployed database; the determination module 1302 includes a query statement determination unit and a database table information determination unit; the query statement determination unit is used to determine the initial query statement of the indicator to be queried based on the initial query statement of each indicator included in the data query file; the database table information determination unit is used to determine the target database table information of the indicator to be queried, which is mapped by the initial database table information in the initial query statement of the indicator to be queried, based on the database attribute information.

[0238] In some embodiments, the indicator query instruction also carries attribute information of the device to be queried and / or the business type of the service to be queried; the database table information determination unit is used to determine, based on the database attribute information and based on the attribute information of the device to be queried and / or the business type of the service to be queried, preset database table information associated with the attribute information of the device to be queried and / or the business type of the service to be queried; and to determine, from the preset database table information, the target database table information of the indicator to be queried.

[0239] In some embodiments, each indicator is associated with a transformation file; the determining module 1302 is further configured to determine the transformation file associated with the indicator to be queried in at least one transformation file as the target transformation file that matches the indicator to be queried.

[0240] In some embodiments, the visualization conversion module includes a query unit, a visualization conversion unit, and a chart conversion unit; the query unit is used to query the indicator data of the indicator to be queried based on the target database table information of the indicator to be queried; the visualization conversion unit is used to perform visualization conversion on the indicator data of the indicator to be queried using a target conversion file to obtain visualization data with a preset data structure; the chart conversion unit is used to perform chart conversion on the visualization data using the obtained target chart type to generate visualization results.

[0241] In some embodiments, the visualization conversion unit is further configured to: obtain the data conversion function and data display format in the target conversion file; process the indicator data of the query indicator using the data conversion function to obtain the processing result; and convert the processing result using the data display format to obtain visualized data.

[0242] In some embodiments, the acquisition module 1301 includes a template acquisition unit, a database attribute information determination unit, and a data query file generation unit; the template acquisition unit is used to acquire a data query template; the data query template includes field characteristic information; the database attribute information determination unit is used to determine database attribute information based on the field characteristic information; and the data query file generation unit is used to generate a data query file based on the database attribute information.

[0243] In some embodiments, the database attribute information determination unit is further configured to obtain fill data matching field characteristic information; store the fill data in an information table in the deployed database; and determine database attribute information based on the information table storing the fill data.

[0244] In some embodiments, the database attribute information determination unit is further configured to obtain the priority order of at least two types of parameter data when a single field attribute information matches at least two types of parameter data; and to determine the fill data that matches the single field attribute information from the at least two types of parameter data according to the priority order of the at least two types of parameter data.

[0245] In some embodiments, the database attribute information determination unit is further used to obtain initial data matching the field attribute information; and to process the initial data using the data processing function in the field attribute information to obtain fill data matching the field attribute information.

[0246] In some embodiments, the indicator query instruction also carries the business type of the business to be queried; the acquisition module 1301 is further configured to acquire the information query file of each business type and the information conversion file of each business type under at least one business type; and determine the information query file of the business type of the business to be queried and the information conversion file of the business type of the business to be queried as the data query file and the visualization conversion file.

[0247] In some embodiments, the acquisition module 1301 is further configured to acquire an indicator query directory; the indicator query directory includes the identifier of at least one indicator; the indicator visualization result generation device 1300 further includes a storage processing module, which is configured to store the data query file and the visualization conversion file according to the indicator query directory, and generate a reading path corresponding to each indicator; the reading path corresponding to each indicator is used to read the content related to each indicator in the data query file and the conversion file corresponding to each indicator in the visualization conversion file.

[0248] In some embodiments, the acquisition module 1301 is further configured to acquire modification information of the template file in response to a modification instruction to modify the template file; the template file includes a data query file and / or a visualization conversion file; the determination module 1302 is further configured to update the template file according to the modification information of the template file; the visualization result generation device for indicators further includes an output module for outputting indication information indicating that the modification of the template file is complete.

[0249] The descriptions of the above device embodiments are similar to those of the above method embodiments, and have similar beneficial effects. For technical details not disclosed in the device embodiments of this application, please refer to the descriptions of the method embodiments of this application for understanding.

[0250] Each module in the visualization result generation device for the above indicators can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in the processor of a computer device in hardware form or independent of it, or stored in the memory of a computer device in software form, so that the processor can call and execute the operations corresponding to each module.

[0251] In one exemplary embodiment, Figure 14 is a schematic diagram of the structure of a computer device provided in some embodiments. The computer device includes a processor, memory, input / output interface, communication interface, display unit, and input device. The processor, memory, and input / output interface are connected via a system bus, and the communication interface, display unit, and input device are also connected to the system bus via the input / output interface. The processor of the computer device provides computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and internal memory. The non-volatile storage medium stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage medium. The input / output interface of the computer device is used for exchanging information between the processor and external devices. The communication interface of the computer device is used for wired or wireless communication with external terminals, which can be implemented through Wireless Fidelity (WIFI), mobile cellular networks, Near Field Communication (NFC), or other technologies. When the computer program is executed by the processor, it implements a method for generating visualization results of an indicator. The display unit of the computer device is used to form a visually visible image and can be a display screen, a projection device, or a virtual reality imaging device. The display screen can be an LCD screen or an e-ink screen. The input device of the computer device can be a touch layer covering the display screen, or buttons, trackballs, or touchpads set on the casing of the computer device, or external keyboards, touchpads, or mice, etc.

[0252] Those skilled in the art will understand that the structure shown in Figure 14 is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or may combine certain components, or may have different component arrangements.

[0253] For example, a computer device includes a memory and a processor, the memory storing a computer program, and the processor executing the computer program to implement the steps of the method of any of the above embodiments.

[0254] For example, in one exemplary embodiment, when the processor executes a computer program, it performs the following: acquiring a data query file and a visualization conversion file; the data query file includes target library table information for each of at least one indicator, the target library table information for each indicator indicating a library table used to store indicator data for each indicator; the visualization conversion file includes at least one conversion file; in response to an indicator query instruction carrying an indicator to be queried, determining the target library table information for the indicator to be queried based on the data query file, and determining a target conversion file matching the indicator to be queried from at least one conversion file; and generating a visualization result for the indicator to be queried based on the target library table information and the target conversion file.

[0255] Figure 14 is a schematic diagram of an energy storage control system provided in some embodiments. The energy storage control system includes the aforementioned computer equipment and an energy storage valve control device connected to the computer equipment.

[0256] In one embodiment, a computer-readable storage medium is provided, wherein a computer program, when executed by a processor, implements the steps of the method provided in any of the above embodiments.

[0257] For example, in one exemplary embodiment, a computer-readable storage medium is provided having a computer program stored thereon, which, when executed by a processor, performs the following steps: acquiring a data query file and a visualization conversion file; the data query file includes target library table information for each of at least one indicator, the target library table information for each indicator indicating a library table used to store indicator data for each indicator; the visualization conversion file includes at least one conversion file; in response to an indicator query instruction carrying an indicator to be queried, determining the target library table information for the indicator to be queried based on the data query file, and determining a target conversion file matching the indicator to be queried from at least one conversion file; and generating a visualization result for the indicator to be queried based on the target library table information and the target conversion file.

[0258] In one embodiment, a computer program product is provided, including a computer program that, when executed by a processor, implements the steps of the method provided in any of the above embodiments.

[0259] For example, in one exemplary embodiment, a computer program product is provided, including a computer program that, when executed by a processor, performs the following steps: acquiring a data query file and a visualization conversion file; the data query file includes target library table information for each of at least one indicator, the target library table information for each indicator indicating a library table used to store indicator data for each indicator; the visualization conversion file includes at least one conversion file; in response to an indicator query instruction carrying an indicator to be queried, determining the target library table information for the indicator to be queried based on the data query file, and determining a target conversion file matching the indicator to be queried from at least one conversion file; and generating a visualization result for the indicator to be queried based on the target library table information and the target conversion file.

[0260] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the methods described above.

[0261] The processor, functional modules, or functional units in any embodiment of this application may include an integration of one or more of the following: a general-purpose processor, an application-specific integrated circuit (ASIC), a digital signal processor (DSP), a digital signal processing device (DSPD), a programmable logic device (PLD), a field-programmable gate array (FPGA), a central processing unit (CPU), a graphics processing unit (GPU), an embedded neural network processing unit (NPU), a controller, a microcontroller, a microprocessor, a programmable logic device, a discrete gate or transistor logic device, a discrete hardware component, a quantum computing-based data processing logic unit, an artificial intelligence (AI) processor, etc. The general-purpose processor may be a microprocessor or any conventional processor.

[0262] The memory or computer-readable storage medium in any embodiment of this application may include at least one of non-volatile memory and volatile memory. Non-volatile memory includes integration of one or more of the following: Read Only Memory (ROM), Programmable Read-Only Memory (PROM), Erasable Programmable Read-Only Memory (EPROM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Ferromagnetic Random Access Memory (FRAM), Flash Memory, Magnetic Surface Memory, Optical Disc, Compact Disc Read-Only Memory (CD-ROM), Magnetic Tape, Floppy Disk, Flash Memory, Optical Memory, High-Density Embedded Non-Volatile Memory, Resistive Random Access Memory (ReRAM), Magnetoresistive Random Access Memory (MRAM), Ferroelectric Random Access Memory (FRAM), and Phase Change Memory. Memory (PCM), graphene memory, volatile memory, etc. Volatile memory includes the integration of one or more of the following: Random Access Memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can be in at least two forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), etc.

[0263] The technical features of the above embodiments can be combined arbitrarily. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as the combination of these technical features does not contradict each other, it should be considered within the scope of this application. The above embodiments only illustrate several implementation methods of this application, and their descriptions are relatively specific and detailed, but they should not be construed as limiting the scope of this application. It should be noted that for those skilled in the art, several modifications and improvements can be made without departing from the concept of this application, and these all fall within the protection scope of this application. Therefore, the protection scope of this application should be determined by the appended claims.

Claims

1. A method of generating a visualized result of an indicator, wherein, The method includes: Obtain a data query file and a visualization conversion file; the data query file includes target database table information for each indicator in at least one indicator, and the target database table information for each indicator indicates the database table used to store the indicator data for each indicator; the visualization conversion file includes at least one conversion file; In response to an indicator query instruction carrying an indicator to be queried, the target database table information of the indicator to be queried is determined according to the data query file, and the target transformation file matching the indicator to be queried is determined from the at least one transformation file; Based on the target database information of the queried indicator and the target transformation file, a visualization result of the queried indicator is generated.

2. The method of claim 1, wherein, The data query file includes the target query statement for each indicator, and the target query statement for each indicator includes the target database table information for each indicator; The step of determining the target database table information of the queried indicator based on the data query file includes: From the target query statements of each indicator included in the data query file, determine the target query statement of the indicator to be queried; The database table information in the target query statement is determined as the target database table information of the queried indicator.

3. The method of claim 1, wherein, The data query file includes database attribute information and an initial query statement for each indicator; the database attribute information includes the mapping relationship between the initial database table information in the initial query statement and the target database table information of the deployed database; The step of determining the target database table information of the queried indicator based on the data query file includes: Based on the initial query statement of each indicator included in the data query file, determine the initial query statement of the indicator to be queried; Based on the database attribute information, determine the target database table information of the query indicator mapped from the initial database table information in the initial query statement of the query indicator.

4. The method of claim 3, wherein, The indicator query instruction also carries attribute information of the device to be queried and / or the service type of the service to be queried; the step of determining the target database table information of the indicator to be queried, mapped from the initial database table information in the initial query statement of the indicator to be queried, based on the database attribute information, includes: Based on the database attribute information, and based on the attribute information of the device to be queried and / or the business type of the service to be queried, determine the preset database table information associated with the attribute information of the device to be queried and / or the business type of the service to be queried; The target database table information for the queried indicator is determined from the preset database table information.

5. The method according to any one of claims 1 to 4, wherein, Each indicator is associated with one of the transformation files; determining the target transformation file matching the query indicator from the at least one transformation file includes: The transformation file associated with the query metric in the at least one transformation file is determined as the target transformation file that matches the query metric.

6. The method according to any one of claims 1 to 5, wherein, The step of generating a visualization result for the queried indicator based on the target database table information and the target transformation file includes: Based on the target database table information of the queried indicator, query the indicator data of the queried indicator; Using the target transformation file, the indicator data of the indicator to be queried is transformed into visualization data with a preset data structure; The visualization data is transformed using the acquired target chart type to generate the visualization result.

7. The method of claim 6, wherein, The step of using the target transformation file to perform a visualization transformation on the indicator data of the indicator to be queried, to obtain visualized data with a preset data structure, includes: Obtain the data conversion functions and data display format from the target conversion file; The data transformation function is used to process the indicator data of the indicator to be queried, and the processing result is obtained; The processing result is converted using the data display format to obtain the visualized data.

8. The method according to any one of claims 1 to 7, wherein, The data query file to be obtained includes: Obtain a data query template; the data query template includes field characteristic information; Based on the field characteristic information, determine the database attribute information; The data query file is generated based on the database attribute information.

9. The method of claim 8, wherein, The step of determining the database attribute information based on the field characteristic information includes: Obtain the fill data that matches the field characteristic information; The populated data is stored in the information table of the deployed database; The database attribute information is determined based on the information table storing the populated data.

10. The method of claim 9, wherein, The step of obtaining the fill data that matches the field characteristic information includes: When a single field characteristic information matches at least two types of parameter data, obtain the priority order of the at least two types of parameter data; Based on the priority order of the at least two types of parameter data, determine the fill data that matches the single field characteristic information from the at least two types of parameter data.

11. The method of claim 9, wherein, The step of obtaining the fill data that matches the field characteristic information includes: Obtain initial data that matches the field characteristic information; The initial data is processed using the data processing function in the field characteristic information to obtain fill data that matches the field characteristic information.

12. The method according to any one of claims 1 to 11, wherein, The indicator query instruction also carries the business type of the business to be queried; the acquisition of data query files and visualization conversion files includes: Obtain information query files for each business type and information conversion files for each business type under at least one business type; The information query file of the business type of the business to be queried and the information conversion file of the business type of the business to be queried are determined as the data query file and the visualization conversion file, respectively.

13. The method according to any one of claims 1 to 12, wherein, The method further includes: Obtain the indicator query directory; the indicator query directory includes the identifier of the at least one indicator; The data query file and the visualization conversion file are stored according to the indicator query directory, and a read path corresponding to each indicator is generated; the read path corresponding to each indicator is used to read the content related to each indicator in the data query file and the conversion file corresponding to each indicator in the visualization conversion file.

14. The method according to any one of claims 1 to 13, wherein, The method further includes: In response to a modification instruction to modify a template file, the modification information of the template file is obtained; the template file includes the data query file and / or the visualization conversion file; Update the template file according to the modification information in the template file; Output a message indicating that the template file modification is complete.

15. An indicator visualisation result generation apparatus wherein, The visualization result generation device for the indicator includes: The acquisition module is used to acquire a data query file and a visualization conversion file; the data query file includes target library table information for each indicator in at least one indicator, and the target library table information for each indicator indicates the library table used to store the indicator data of each indicator; the visualization conversion file includes at least one conversion file; The determination module is used to respond to an indicator query instruction carrying an indicator to be queried, determine the target database table information of the indicator to be queried based on the data query file, and determine the target transformation file that matches the indicator to be queried from the at least one transformation file. The generation module is used to generate a visualization result of the query indicator based on the target library table information and the target transformation file.

16. A computer device comprising a memory and a processor, the memory storing a computer program, wherein, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 14.

17. A computer readable storage medium having stored thereon a computer program, wherein, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 14.

18. A computer program product comprising a computer program, wherein, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 14.

Images