Index state information display method and device, equipment and storage medium

Abstract

The invention discloses an index state information display method and device, equipment and a storage medium, and relates to the technical field of computers.The method comprises the steps that multiple standard dimensions and associated information of multiple standard indexes are obtained, and each standard index is associated and bound with at least one standard dimension; acquiring state information under a standard dimension corresponding to the standard index based on the associated information; based on a service monitoring target and the state information, converting the service monitoring target into a state SQL statement corresponding to a target dimension and a target index; executing the state SQL statement, and updating the state information under the standard dimension corresponding to the standard index; and matching and displaying target completion information and state information corresponding to the target index based on an interactive operation of a user on the target index and the target dimension. According to the method, the service monitoring target is converted into the executable SQL statement by standardizing the dimension and configuring the management page, so that the system flexibility is enhanced, and the development efficiency is improved.

Description

Technical Field

[0001] This application relates to the field of computer technology, and in particular to a method, apparatus, device and storage medium for displaying indicator status information. Background Technology

[0002] In the current field of enterprise operations and data analytics, with the expansion of business scale and the improvement of management sophistication, multi-dimensional and visualized monitoring and analysis of key performance indicators (KPIs) has become a common requirement. Especially in large group companies that span multiple regions and business lines, managers often need to flexibly view the achievement status, early warning information, and business highlights of various indicators through multiple dimensions (such as time, organization, channel, region, etc.) in order to identify problems and seize opportunities in a timely manner.

[0003] However, existing technologies typically employ fixed and customized development approaches to meet such requirements. Specifically, during the system design phase, a strong, hard-coded correlation must be established between each metric and its display dimension. For example, the head office's KPIs can only access preset headquarters-level data interfaces, while branch office alerts are restricted to loading and displaying within their dedicated business modules. In this model, the data presentation is deeply bound to specific dimensions, making it difficult to adjust once established.

[0004] Therefore, when business strategies change, a complete development process from requirements analysis and code modification to functional testing needs to be initiated, which is seriously lagging behind the agile iteration of business and causes a lot of repetitive functional development work. This model, which relies heavily on custom development, has serious architectural rigidity problems.

[0005] The above content is only used to help understand the technical solution of this application and does not represent an admission that the above content is prior art. Summary of the Invention

[0006] The main purpose of this application is to provide a method, device, equipment and storage medium for displaying indicator status information, which aims to solve the technical problem that when business strategies change, the complete development process causes a large amount of repetitive functional development work and a strong reliance on customized development.

[0007] To achieve the above objectives, this application proposes a method for displaying indicator status information, the method comprising: Obtain the association information of multiple standard dimensions and multiple standard indicators, wherein each standard indicator is associated and bound to at least one standard dimension; Based on the aforementioned association information, obtain the status information under the corresponding standard dimension of the standard indicator; Based on the business monitoring objectives and the status information, the business monitoring objectives are converted into status SQL statements corresponding to the target dimensions and target indicators; Execute the status SQL statement to update the status information under the standard dimension corresponding to the standard indicator; Based on the user's interactive operations on the target indicators and target dimensions, the target completion information and status information corresponding to the target indicators are matched and displayed.

[0008] In one embodiment, the status information includes at least warning status and highlight information, and the step of obtaining the status information under the standard dimension corresponding to the standard indicator based on the association information includes: Based on the aforementioned standard dimensions and standard indicators, a status information result table containing the warning status and highlight information is pre-constructed.

[0009] In one embodiment, the step of converting the business monitoring target into a status SQL statement corresponding to the target dimension and target indicator based on the business monitoring target and the status information includes: The business monitoring target is parsed into an indicator identifier, one or more dimension identifiers, and business rule conditions consisting of comparison operators and thresholds; Based on the indicator identifier and dimension identifier, a corresponding basic SQL template is matched from a predefined SQL template, wherein the basic SQL template contains dynamic parameter placeholders. After semantic validation and standardization of the business rule conditions, they are filled into the dynamic parameter placeholders to generate intermediate SQL with definite data query logic. The intermediate SQL is subjected to syntax tree analysis and pre-compilation optimization to generate status SQL statements for querying or calculating the warning status and highlight information.

[0010] In one embodiment, the step of filling the dynamic parameter placeholders with the business rule conditions after semantic validation and standardization includes: Identify the logical operators in the business rule conditions, and break down multiple sub-conditions connected by AND or OR into independent sub-unit conditions; Map the dimension identifier associated with each sub-unit condition to a specific parameter placeholder in the corresponding WHERE or HAVING clause in the basic SQL template; For standard dimensions that do not participate in the current business rule conditions, fill in the corresponding parameter placeholders in the basic SQL template with system-predefined null identifiers.

[0011] In one embodiment, the step of executing the status SQL statement to update the status information under the standard dimension corresponding to the standard indicator includes: The status SQL statement is submitted to the asynchronous task queue and executed in near real-time by the distributed task scheduler. During execution, a database transaction mechanism is used to ensure the atomicity of status information updates, and an operation log is recorded after successful execution. By comparing the current execution result with the historical data in the status information result table, the combination of indicators-dimensions that indicate a change in status is identified. The combination of metrics and dimensions that changes based on the status of the front-end configuration page update.

[0012] In one embodiment, the user's interactive operations based on the target metrics and target dimensions include: Receive initial creation or editing instructions from the user in the component library of the configuration page for the displayed cards; In response to the initial creation or editing command, an indicator-dimension selection panel is provided, which includes a standard indicator list, a standard dimension list, and a dimension value filter. Listen for user selection events on the selection panel. The selection events include: selecting one or more target indicators from the standard indicator list, dragging or selecting one or more target dimensions from the standard dimension list to form a multi-dimensional observation perspective, and specifying filter condition values ​​for each target dimension in the dimension value filter. The selection event is encapsulated and a multidimensional query condition object is generated. The multidimensional query condition object includes at least a set of target indicator IDs, a set of target dimension IDs, and a set of dimension filter key-value pairs.

[0013] In one embodiment, the step of matching and displaying the target completion information and status information corresponding to the target indicator includes: Receive the multidimensional query condition object and query the preprocessing status information that matches the multidimensional query condition object from the cache server; If the query result is not found, a real-time search is performed in the status information result table based on the target indicator identifier and dimension filtering conditions, and the search results are synchronized to the cache server. Based on predefined visual rule mapping, the acquired warning status is converted into corresponding color codes and charts, the highlight information is converted into highlighted text templates, and the target completion information is filled into the progress bar component; The target completion information and status information are rendered and integrated in the configurable interface to generate a unified data display card.

[0014] Furthermore, to achieve the above objectives, this application also proposes an indicator status information display device, which includes: The association information management module is used to obtain association information of multiple standard dimensions and multiple standard indicators, wherein each standard indicator is associated and bound to at least one standard dimension; The status information processing module is used to obtain the status information of the standard indicator under the corresponding standard dimension based on the association information; The SQL statement generation module is used to convert the business monitoring target into a status SQL statement corresponding to the target dimension and target indicator based on the business monitoring target and the status information. The status information update module is used to execute the status SQL statement and update the status information under the standard dimension corresponding to the standard indicator; The interactive display module is used to match and display the target completion information and status information corresponding to the target indicators based on the user's interactive operations on the target indicators and target dimensions.

[0015] In addition, to achieve the above objectives, this application also proposes an indicator status information display device, the device comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, the computer program being configured to implement the steps of the indicator status information display method as described above.

[0016] In addition, to achieve the above objectives, this application also proposes a storage medium, which is a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, it implements the steps of the indicator status information display method described above.

[0017] In addition, to achieve the above objectives, this application also provides a computer program product, which includes a computer program that, when executed by a processor, implements the steps of the indicator status information display method described above.

[0018] One or more technical solutions proposed in this application have at least the following technical effects: This application obtains association information of multiple standard dimensions and multiple standard indicators, wherein each standard indicator is associated with at least one standard dimension; based on the association information, it obtains the status information under the corresponding standard dimension of the standard indicator; based on the business monitoring target and the status information, it converts the business monitoring target into status SQL statements corresponding to the target dimension and target indicator; it executes the status SQL statements to update the status information under the corresponding standard dimension of the standard indicator; based on the user's interactive operations on the target indicator and target dimension, it matches and displays the target completion information and status information corresponding to the target indicator. This application enhances system flexibility and improves development efficiency by converting business monitoring targets into executable SQL statements through standardized dimensions and a configurable management page. Attached Figure Description

[0019] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application.

[0020] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, for those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0021] Figure 1 This is a flowchart illustrating an embodiment of the method for displaying indicator status information in this application. Figure 2 This is a flowchart illustrating Embodiment 2 of the method for displaying indicator status information in this application. Figure 3 This is a flowchart illustrating Embodiment 3 of the method for displaying indicator status information in this application. Figure 4 This is a flowchart illustrating Embodiment 4 of the method for displaying indicator status information in this application. Figure 5 This is a schematic diagram of the module structure of the indicator status information display device according to an embodiment of this application; Figure 6 This is a schematic diagram of the device structure of the hardware operating environment involved in the indicator status information display method in the embodiments of this application.

[0022] The purpose, features, and advantages of this application will be further explained in conjunction with the embodiments and with reference to the accompanying drawings. Detailed Implementation

[0023] It should be understood that the specific embodiments described herein are merely illustrative of the technical solutions of this application and are not intended to limit this application.

[0024] To better understand the technical solution of this application, a detailed description will be provided below in conjunction with the accompanying drawings and specific implementation methods.

[0025] Because changes in business strategy in existing technologies require the initiation of a complete development process, which is severely lagging behind the agile iteration of business and results in a large amount of repetitive feature development work, it is highly dependent on custom development.

[0026] This application provides a solution that obtains association information of multiple standard dimensions and multiple standard indicators, wherein each standard indicator is associated with at least one standard dimension; obtains status information under the standard dimension corresponding to the standard indicator based on the association information; converts the business monitoring target into a status SQL statement corresponding to the target dimension and the target indicator based on the business monitoring target and the status information; executes the status SQL statement to update the status information under the standard dimension corresponding to the standard indicator; and matches and displays the target completion information and status information corresponding to the target indicator based on the user's interactive operations on the target indicator and the target dimension.

[0027] Based on this, embodiments of this application provide a method for displaying indicator status information, referring to... Figure 1 , Figure 1 This is a flowchart illustrating the first embodiment of the indicator status information display method of this application.

[0028] In this embodiment, the indicator status information display method includes steps S10 to S50: Step S10: Obtain the association information of multiple standard dimensions and multiple standard indicators, wherein each standard indicator is associated and bound to at least one standard dimension; It should be noted that, in this embodiment, standard dimensions refer to different angles or perspectives for observing and analyzing business data, including but not limited to time dimensions, organizational dimensions, channel dimensions, and product dimensions, each with a unique dimension identifier; standard indicators refer to specific business values ​​that are measured and monitored, and are the core manifestation of KPIs, including but not limited to new premium income, loss ratio, and policy persistency rate, each with a unique indicator identifier. Related information refers to the binding relationship between standard dimensions and standard indicators; the system establishes a many-to-many relationship mapping through dimension identifiers and indicator identifiers. By constructing a unified data model foundation, organization and querying are performed based on standardized dimension-indicator relationships, thereby achieving flexibility and configurability in display.

[0029] Optionally, the system predefines three standard dimensions: time, institution, and channel, and defines two standard indicators: "new policy premium income" and "loss ratio". In the configuration interface, the administrator binds "new policy premium income" to all three dimensions: time, institution, and channel, and binds "loss ratio" to the two dimensions: time and institution. The system records these relationships in the "indicator dimension association table".

[0030] Step S20: Obtain the status information under the standard dimension corresponding to the standard indicator based on the association information; It should be noted that, in this embodiment, the status information refers to the business status judgment result corresponding to a standard indicator under a specific combination of standard dimensions, which includes at least a warning status and highlight information. The warning status is used to identify the degree of abnormality of the business indicator, such as normal, general warning, and severe warning; the highlight information is used to identify the excellent performance of the business indicator, such as "KPI exceeded target by 50%". Through the association information, a unified overall information result table is pre-constructed. The structure of this table includes indicator identifiers, multiple dimension fields, a warning status field, and a highlight information field.

[0031] Step S30: Based on the business monitoring target and the status information, convert the business monitoring target into status SQL statements corresponding to the target dimension and target indicator; It should be noted that, in this embodiment, the business monitoring objective refers to the monitoring requirements and judgment rules proposed by business personnel for specific indicators under specific dimensions. The status SQL statement refers to a structured query language script used to query or calculate warning status and highlight information. This automatically and accurately transforms unstructured business requirements into executable data query logic.

[0032] Step S40: Execute the status SQL statement to update the status information under the standard dimension corresponding to the standard indicator; It should be noted that, in this embodiment, updating the status information refers to writing the latest status information into a pre-built status information result table to maintain the timeliness of the status information. This step ensures that the information displayed on the front end can reflect the latest developments of the business in a timely manner.

[0033] Optionally, the system employs a database transaction mechanism during execution to ensure the atomicity of status information updates, meaning that either all updates succeed or all fail and are rolled back, thus guaranteeing data consistency.

[0034] Step S50: Based on the user's interactive operations on the target indicators and target dimensions, match and display the target completion information and status information corresponding to the target indicators.

[0035] It should be noted that, in this embodiment, user interaction refers to actions such as selection, dragging, and filtering performed by the user through a graphical interface on the configuration page. Target metrics and target dimensions are the specific metrics and dimensions selected by the user in the current interaction scenario. Target completion information refers to the achievement status of key performance indicators (KPIs), such as actual values, target values, and completion rates. Matching refers to the system retrieving and associating corresponding data from the status information result table and related KPI data tables based on the user's selection. This step enables users to view business status on demand, flexibly, and dynamically.

[0036] Optionally, the data display card also provides a drill-down entry point, allowing users to drill down to view more detailed underlying data or trend analysis charts.

[0037] Optionally, in one specific implementation, business users drag "New Business Premium Income" from the indicator list as the target indicator in the configuration page, select "Institution" and "Time" as the target dimensions from the dimension list, and set "Time = July 2024" in the filter. Based on this operation, the system generates a query object, queries and matches the premium income completion status, warning status (e.g., a certain institution is displayed in yellow), and highlight information (e.g., another institution is displayed as "Ranked First in Achievement Rate") for each institution in July 2024. Finally, the data is presented to the user in an automatically generated data card using progress bars, color highlights, and text labels.

[0038] This embodiment establishes a standardized dimension-indicator correlation model, pre-builds a unified status information result table, intelligently converts business requirements into optimizable SQL, updates status data asynchronously in near real-time, and provides dynamic matching and visualization based on user interaction, forming a complete data processing and display chain. It fundamentally solves the problems of "slow response" and "development redundancy" caused by traditional customized development models. Through configuration, it achieves rapid response to business dimension adjustments, greatly improving development efficiency. Through methods such as "status information result table" and "SQL template generation," it enhances the system's maintainability, scalability, and stability. Through "near real-time updates" and "interactive visualization," it provides users with near real-time, flexible, multi-dimensional, and intuitive data insight capabilities, significantly improving the timeliness and accuracy of business decisions.

[0039] In one possible implementation, the status information includes at least warning status and highlight information, and the step of obtaining the status information under the standard dimension corresponding to the standard indicator based on the association information includes the following before: Based on the aforementioned standard dimensions and standard indicators, a status information result table containing the warning status and highlight information is pre-constructed.

[0040] It should be noted that, in this embodiment, the pre-construction operation of the status information result table refers to the system pre-creating a structured storage table at the data level. This table establishes a framework structure based on the correlation between standard dimensions and standard indicators, including indicator identifier fields, multiple dimension fields, warning status fields, and highlight information fields, forming a unified and standardized status information storage carrier. This provides a data structure foundation for status information storage, updating, and querying, and realizes standardized management at the data level.

[0041] Specifically, the status information result table can be implemented using a relational database table. Each indicator-dimension combination corresponds to one record in the table, and the system ensures the integrity and consistency of data updates through a database transaction mechanism.

[0042] Optionally, when constructing the status information result table, the system will determine the field structure of the table based on the association between standard dimensions and standard indicators; for those dimensions that are not involved in a specific indicator-dimensional combination, the system will fill in a uniform null value identifier (such as "@N") in the corresponding field to clearly indicate that the dimension does not participate in the business rule judgment in this combination.

[0043] Furthermore, referring to Figure 2 The second embodiment of the indicator status information display method of this application provides a flowchart, based on the above. Figure 2 The embodiment shown further refines the step S30, "based on the business monitoring target and the status information, converting the business monitoring target into a status SQL statement corresponding to the target dimension and target indicator," including steps A201-A204: Step A201: The business monitoring target is parsed into an indicator identifier, one or more dimension identifiers, and business rule conditions consisting of comparison operators and thresholds. It should be noted that in this embodiment, the business monitoring target refers to the monitoring requirements and judgment rules proposed by business personnel for specific business indicators under specific dimensions; the indicator identifier refers to a string or code that uniquely identifies a standard indicator; the dimension identifier refers to a string or code that uniquely identifies a standard dimension; and the business rule condition refers to a logical judgment expression composed of comparison operators (such as ">", "<", "=", "≥", "≤") and specific numerical thresholds. By decomposing unstructured business requirements into standardized elements that the system can recognize and process, precise input is generated for SQL statements. Specifically, the system uses a parsing engine to perform lexical and syntactic analysis on the business monitoring target, identify the indicators, dimensions, and judgment conditions involved, and map them to the standard identifiers and standardized expressions within the system.

[0044] Step A202: Based on the indicator identifier and dimension identifier, match the corresponding basic SQL template from the predefined SQL template, wherein the basic SQL template embeds dynamic parameter placeholders; It should be noted that, in this embodiment, the predefined SQL template refers to a pre-designed standard SQL statement framework that includes a fixed query structure and variable parameter positions. The basic SQL template refers to a template that matches a specific combination of metric types and dimensions. Dynamic parameter placeholders refer to replaceable markers in the template used to receive external parameters.

[0045] Step A203: After semantic validation and standardization of the business rule conditions, fill them into the dynamic parameter placeholders to generate intermediate SQL with definite data query logic; It should be noted that in this embodiment, semantic validation refers to checking the logical rationality and syntactic correctness of the business rule conditions, such as verifying whether comparison operators are supported and whether the threshold is a valid value. Standardization transformation refers to converting the parsed business rule conditions into standard expressions that conform to SQL syntax specifications. Intermediate SQL refers to SQL statements that have completed placeholder filling but have not yet undergone optimization. Furthermore, during the filling process, for standard dimensions that do not participate in the current business rule conditions, the system will fill in preset null identifiers in the corresponding dimension filter placeholders.

[0046] Step A204: Perform syntax tree analysis and pre-compilation optimization on the intermediate SQL to generate status SQL statements for querying or calculating the warning status and highlight information.

[0047] It should be noted that in this embodiment, syntax tree analysis refers to parsing the SQL statement into an abstract syntax tree structure to analyze its syntactic correctness and logical structure. Pre-compilation optimization refers to performance optimization of the SQL statement, including query rewriting, index suggestions, and execution plan optimization. State SQL statements refer to efficient query bases that have been processed and can be directly submitted to the database for execution. This embodiment uses an SQL optimizer to perform in-depth analysis and optimization of intermediate SQL, ultimately outputting high-performance state SQL statements.

[0048] Optionally, the SQL optimizer performs syntax tree analysis on the intermediate SQL to identify the tables and fields involved in the query, optimizes the subquery into a JOIN operation through query rewriting, and generates an optimal execution plan index suggestion based on statistical information. Finally, it outputs an efficient status SQL statement with query hints, which is used to query the data needed to calculate the warning status and highlight information from various business databases.

[0049] This embodiment solves the problems of poor consistency and low efficiency caused by manually writing SQL in the traditional mode by standardizing parsing and template generation, and realizes accurate and automatic conversion of business rules into data query logic. Secondly, by using semantic verification, standardization transformation and syntax tree analysis, the standardization and robustness of the generated SQL are significantly improved, avoiding syntax errors and logical ambiguities and ensuring system stability. Finally, through deep processing such as pre-compilation optimization, the execution performance of the final SQL statement is ensured, realizing near real-time calculation and querying of massive business data.

[0050] In one possible implementation, the step of filling the dynamic parameter placeholders with the business rule conditions after semantic validation and standardization includes: Identify the logical operators in the business rule conditions, and break down multiple sub-conditions connected by AND or OR into independent sub-unit conditions; It should be noted that in this implementation, logical operators are keywords used to connect multiple Boolean expressions, including AND (logical AND) and OR (logical OR). Sub-conditions refer to the basic logical judgment units that constitute the conditions of each business rule.

[0051] Specifically, the business rule condition is "(Institution='Shenzhen' OR Institution='Guangzhou') AND Month BETWEEN1 AND 6 AND Achievement Rate>1.0". The condition parser recognizes the logical operators AND and OR and breaks the condition down into three independent sub-conditions: "Institution='Shenzhen' OR Institution='Guangzhou'", "Month BETWEEN 1 AND 6", and "Achievement Rate>1.0".

[0052] Map the dimension identifier associated with each sub-unit condition to a specific parameter placeholder in the corresponding WHERE or HAVING clause in the basic SQL template; It should be noted that in this embodiment, the HAVING clause refers to a clause in an SQL statement used to filter the grouped result set. Specific parameter placeholders refer to dynamic parameter placeholders predefined in the basic SQL template used to receive conditional expressions of a specific type. The condition-position mapper analyzes the dimensions and computational characteristics involved in each sub-unit condition to determine whether it belongs to a row-level filtering condition (mapped to a WHERE clause) or an aggregated filtering condition (mapped to a HAVING clause), and then fills it into the corresponding parameter placeholder in the basic SQL template.

[0053] For standard dimensions that do not participate in the current business rule conditions, fill in the corresponding parameter placeholders in the basic SQL template with system-predefined null identifiers.

[0054] It should be noted that in this implementation, the null identifier refers to a special marker predefined by the system to indicate that "this dimension is not involved in the conditional judgment," such as "@N." The dimension status analyzer identifies related dimensions not involved in the current business rule conditions, and uniformly fills the corresponding parameter placeholders with predefined null identifiers, ensuring that all parameter placeholders in the SQL template are legally filled.

[0055] Furthermore, referring to Figure 3The third embodiment of the indicator status information display method of this application provides a flowchart, based on the above. Figure 3 The embodiment shown further refines the step of "executing the status SQL statement to update the status information under the standard dimension corresponding to the standard indicator" in step S40, including steps A301 to A304: Step A301: Submit the status SQL statement to the asynchronous task queue and trigger its execution in near real-time through the distributed task scheduler; It should be noted that in this embodiment, the asynchronous task queue refers to a buffer used to store tasks to be executed and process them sequentially, thereby decoupling task submission from task execution and avoiding blocking the main business process; the distributed task scheduler refers to a scheduling component in a distributed system environment that is responsible for coordinating and managing task execution on multiple computing nodes. The near-real-time method refers to completing data processing within a short, acceptable latency (usually on the order of seconds or minutes), which is neither fully real-time synchronous processing nor batch processing with longer latency on the order of hours or days, thus improving task processing efficiency and system throughput.

[0056] Step A302: During execution, a database transaction mechanism is used to ensure the atomicity of status information updates, and an operation log is recorded after successful execution. It should be noted that in this embodiment, the database transaction mechanism refers to a technical means provided by the database management system to ensure that a series of operations either all succeed or none fail. Atomicity means that a transaction, as an indivisible unit of work, contains operations that either all succeed or all fail and are rolled back. When updating the status information result table, the system starts a database transaction, executes the status SQL statement and updates the target record within the transaction, and only commits the transaction after all operations succeed; otherwise, it rolls back all changes. This avoids data inconsistency caused by partial success or partial failure of updates and ensures data consistency during the status information update process.

[0057] Step A303: By comparing the current execution result with the historical data in the status information result table, identify the combination of indicators-dimensions that indicate a change in status; It should be noted that in this embodiment, the execution result is the latest status calculation result set obtained by executing the status SQL statement; historical data refers to the status information record after the last update stored in the status information result table. The indicator-dimension combination refers to a business data instance uniquely identified by a specific indicator identifier and a set of specific dimension values, which accurately identifies specific data points where the business status has changed through comparison.

[0058] Step A304: Based on the changes in the status of the front-end configuration page update, the combination of the metrics and dimensions is updated.

[0059] It should be noted that in this embodiment, a lightweight notification message is sent to all front-end clients that are accessing the relevant configuration page through the message push service. The notification content usually includes core metadata such as the changed indicator ID and dimension combination identifier.

[0060] Furthermore, referring to Figure 4 The fourth embodiment of the indicator status information display method of this application provides a flowchart, based on the above. Figure 4 The illustrated embodiment further refines the step S50, "based on user interaction with target metrics and target dimensions," including steps A401 to A404: Step A401: Receive the user's initial creation or editing instructions for the display card in the component library of the configuration page; It should be noted that, in this embodiment, the configuration page component library refers to a collection of reusable interface elements provided by the system, containing various predefined visualization elements (such as charts, cards, tables, etc.). A display card refers to an independent visualization container used to integrate and display one or more metrics and their related status information in the user interface. An initial creation command refers to a user's command to create a new display card. An edit command refers to a user's command to modify an existing display card. The configuration page's interaction controller receives user interaction events such as mouse clicks and touch operations, identifies the user's intention to create or edit display cards, and replaces the traditional customized development model that requires developers to implement the code.

[0061] Step A402, in response to the initial creation or editing command, provides an indicator-dimension selection panel, which includes a standard indicator list, a standard dimension list, and a dimension value filter; It should be noted that, in this embodiment of the application, the indicator-dimensional selection panel is used to guide the user to select an indicator or configure a dimension; the dimension value filter refers to the interactive control provided for each standard dimension to limit the specific value range of that dimension, such as a drop-down selection box, an input box, a date picker, etc.

[0062] Step A403: Listen for selection events on the selection panel by the user. The selection events include: selecting one or more target indicators from the standard indicator list, dragging or selecting one or more target dimensions from the standard dimension list to form a multi-dimensional observation perspective, and specifying filter condition values ​​for each target dimension in the dimension value filter. It should be noted that, in this embodiment, the selection event is an event triggered by various interactive operations performed by the user on the graphical interface. A multi-dimensional observation perspective refers to a specific data analysis perspective formed by combining multiple target dimensions. The filter condition value refers to the specific filter value set by the user for the corresponding dimension in the dimension value filter. The event listening module continuously monitors user interactions on the selection panel, including the checked state of checkboxes, drag events of list items, and changes in filter control values, updating the internal state model in real time to reflect the user's selection.

[0063] Specifically, the user first selected two target indicators, "new business premium income" and "loss ratio," from the standard indicator list; then, from the standard dimension list, the "time" dimension and the "institution" dimension were dragged to the "selected dimensions" area to form a multi-dimensional observation perspective; then, in the filter configured for the "time" dimension, "third quarter of 2024" was selected, and in the filter configured for the "institution" dimension, "Shenzhen branch" and "Guangzhou branch" were selected.

[0064] Step A404: Encapsulate the selection event and generate a multidimensional query condition object. The multidimensional query condition object includes at least a set of target indicator IDs, a set of target dimension IDs, and a set of dimension filter key-value pairs.

[0065] It should be noted that, in this embodiment of the application, the multidimensional query condition object is used to represent all the necessary parameters of a data query request in a standardized way; the target indicator ID set refers to the set of unique identifiers of all target indicators selected by the user; the target dimension ID set refers to the set of unique identifiers of all target dimensions selected by the user; the dimension filter key-value pair set refers to the key-value pair stored in the form of each target dimension and its corresponding filter condition value, where the key is the dimension identifier and the value is the filter condition set by the user.

[0066] This embodiment transforms the traditional, coding-intensive process of creating display cards into a visual drag-and-drop configuration by configuring a page component library and a structured selection panel. This significantly lowers the barrier to entry for users and enables business personnel to independently configure data dashboards. Secondly, the synergistic effect of standard indicator lists, standard dimension lists, and dimension value filters ensures the standardization of user configuration behavior and the consistency of the system's data model, guaranteeing the accuracy and effectiveness of query conditions from the source of interaction. Finally, by encapsulating fragmented user selection events into structured multidimensional query condition objects, effective decoupling between front-end interaction and back-end query services is achieved. This provides reliable and standardized input for the system to perform accurate data matching and dynamic display, significantly improving the system's agility in responding to business changes and the smoothness of the user experience.

[0067] In one possible implementation, the step of matching and displaying the target completion information and status information corresponding to the target indicator includes: Receive the multidimensional query condition object and query the preprocessing status information that matches the multidimensional query condition object from the cache server; If the query result is not found, a real-time search is performed in the status information result table based on the target indicator identifier and dimension filtering conditions, and the search results are synchronized to the cache server. Based on predefined visual rule mapping, the acquired warning status is converted into corresponding color codes and charts, the highlight information is converted into highlighted text templates, and the target completion information is filled into the progress bar component; The target completion information and status information are rendered and integrated in the configurable interface to generate a unified data display card.

[0068] It should be noted that, in this embodiment, preprocessed status information refers to the calculated warning status and highlight information stored in the cache. Visual rule mapping refers to a predefined set of rules for converting data values ​​into visual elements, such as mapping warning levels to colors. Color coding refers to using specific colors to represent different warning states, such as red representing a severe warning. Highlighted text templates refer to standardized text formats used to display highlight information. Progress bar components refer to graphical interface elements used to visually display the degree of goal completion.

[0069] This embodiment achieves efficient matching and intuitive display of business data through intelligent cache retrieval and visualization rendering. Upon receiving structured query requests, it prioritizes retrieving preprocessed status information from the high-speed cache to improve response speed. If the cache misses, the query is switched to persistent storage, and the cache is updated synchronously to ensure subsequent query performance. Subsequently, the raw data is transformed into rich visualization elements according to predefined visual rules. Finally, the data is integrated and rendered in a configurable interface to generate unified data display cards, providing users with intuitive and timely insights into their business status.

[0070] Optionally, the system can adopt a multi-level caching strategy to store the query results of hot data in both local cache and distributed cache, thereby further improving data retrieval efficiency.

[0071] It should be noted that the above examples are only for understanding this application and do not constitute a limitation on the indicator status information display method of this application. Any simple modifications based on this technical concept are within the protection scope of this application.

[0072] This application also provides an indicator status information display device, please refer to... Figure 5 The indicator status information display device includes: The association information management module 10 is used to obtain association information of multiple standard dimensions and multiple standard indicators, wherein each standard indicator is associated and bound to at least one standard dimension. The status information processing module 20 is used to obtain status information under the standard dimension corresponding to the standard indicator based on the association information; SQL statement generation module 30 is used to convert the business monitoring target into a status SQL statement corresponding to the target dimension and target indicator based on the business monitoring target and the status information. The status information update module 40 is used to execute the status SQL statement and update the status information under the standard dimension corresponding to the standard indicator; The interactive display module 50 is used to match and display the target completion information and status information corresponding to the target indicator based on the user's interactive operations on the target indicator and target dimension.

[0073] The indicator status information display device provided in this application, employing the indicator status information display method in the above embodiments, can solve the technical problem of a large amount of repetitive functional development work caused by changes in business strategies, and a strong reliance on customized development. Compared with the prior art, the beneficial effects of the indicator status information display device provided in this application are the same as those of the indicator status information display method provided in the above embodiments, and other technical features in the indicator status information display device are the same as those disclosed in the methods of the above embodiments, and will not be repeated here.

[0074] This application provides an indicator status information display device, which includes: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute the indicator status information display method in the first embodiment described above.

[0075] The following is for reference. Figure 6 The diagram illustrates a structural schematic of an indicator status information display device suitable for implementing embodiments of this application. The indicator status information display device in the embodiments of this application may include, but is not limited to, mobile terminals such as mobile phones, laptops, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (Portable Application Description), PMPs (Portable Media Players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. Figure 6The indicator status information display device shown is merely an example and should not impose any limitations on the functionality and scope of use of the embodiments of this application.

[0076] like Figure 6 As shown, the indicator status information display device may include a processing unit 1001 (e.g., a central processing unit, a graphics processing unit, etc.), which can perform various appropriate actions and processes according to a program stored in a read-only memory 1002 or a program loaded from a storage device 1003 into a random access memory 1004. The random access memory 1004 also stores various programs and data required for the operation of the indicator status information display device. The processing unit 1001, the read-only memory 1002, and the random access memory 1004 are interconnected via a bus 1005. An input / output interface 1006 is also connected to the bus. Typically, the following systems can be connected to the input / output interface 1006: input devices 1007 including, for example, a touch screen, touchpad, keyboard, mouse, image sensor, microphone, accelerometer, gyroscope, etc.; output devices 1008 including, for example, a liquid crystal display (LCD), speaker, vibrator, etc.; storage devices 1003 including, for example, magnetic tape, hard disk, etc.; and communication devices 1009. Communication device 1009 allows the indicator status information display device to communicate wirelessly or wiredly with other devices to exchange data. Although the figure shows indicator status information display devices with various systems, it should be understood that implementing or having all the systems shown is not required. More or fewer systems may be implemented alternatively.

[0077] Specifically, according to the embodiments disclosed in this application, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments disclosed in this application include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via a communication device, or installed from storage device 1003, or installed from read-only memory 1002. When the computer program is executed by processing device 1001, it performs the functions defined in the methods of the embodiments disclosed in this application.

[0078] The indicator status information display device provided in this application, employing the indicator status information display method in the above embodiments, can solve the technical problem of a large amount of repetitive functional development work caused by changes in business strategies, and a strong reliance on customized development. Compared with the prior art, the beneficial effects of the indicator status information display device provided in this application are the same as those of the indicator status information display method provided in the above embodiments, and other technical features in this indicator status information display device are the same as those disclosed in the method of the previous embodiment, and will not be repeated here.

[0079] It should be understood that the various parts disclosed in this application can be implemented using hardware, software, firmware, or a combination thereof. In the description of the above embodiments, specific features, structures, materials, or characteristics can be combined in any suitable manner in one or more embodiments or examples.

[0080] The above description is merely a specific embodiment of this application, but the scope of protection of this application is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in this application should be included within the scope of protection of this application. Therefore, the scope of protection of this application should be determined by the scope of the claims.

[0081] This application provides a computer-readable storage medium having computer-readable program instructions (i.e., a computer program) stored thereon, which are used to execute the indicator status information display method in the above embodiments.

[0082] The computer-readable storage medium provided in this application may be, for example, a USB flash drive, but is not limited to, electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems or devices, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to: electrical connections having one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof. In this embodiment, the computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system or device. The program code contained on the computer-readable storage medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (Radio Frequency), etc., or any suitable combination thereof.

[0083] The aforementioned computer-readable storage medium may be included in the indicator status information display device; or it may exist independently and not be assembled into the indicator status information display device.

[0084] The aforementioned computer-readable storage medium carries one or more programs. When these programs are executed by the indicator status information display device, the indicator status information display device: acquires association information of multiple standard dimensions and multiple standard indicators, wherein each standard indicator is associated with at least one standard dimension; acquires status information under the standard dimension corresponding to the standard indicator based on the association information; converts the business monitoring target into a status SQL statement corresponding to the target dimension and the target indicator based on the business monitoring target and the status information; executes the status SQL statement to update the status information under the standard dimension corresponding to the standard indicator; and matches and displays the target completion information and status information corresponding to the target indicator based on the user's interactive operation on the target indicator and the target dimension.

[0085] Computer program code for performing the operations of this application can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, and C++, and conventional procedural programming languages ​​such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a Local Area Network (LAN) or a Wide Area Network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0086] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this application. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0087] The modules described in the embodiments of this application can be implemented in software or hardware. The names of the modules do not necessarily limit the functionality of the unit itself.

[0088] The readable storage medium provided in this application is a computer-readable storage medium that stores computer-readable program instructions (i.e., a computer program) for executing the above-described indicator status information display method. This addresses the technical problem of a large amount of repetitive functional development work resulting from changes in business strategies, and the strong reliance on customized development. Compared with the prior art, the beneficial effects of the computer-readable storage medium provided in this application are the same as those of the indicator status information display method provided in the above embodiments, and will not be elaborated upon here.

[0089] This application also provides a computer program product, including a computer program that, when executed by a processor, implements the steps of the indicator status information display method described above.

[0090] The computer program product provided in this application can solve the technical problem of a large amount of repetitive functional development work caused by changes in business strategy, and a strong reliance on customized development. Compared with the prior art, the beneficial effects of the computer program product provided in this application are the same as those of the indicator status information display method provided in the above embodiments, and will not be repeated here.

[0091] The above description is only a part of the embodiments of this application and does not limit the patent scope of this application. All equivalent structural transformations made under the technical concept of this application and using the contents of the specification and drawings of this application, or direct / indirect applications in other related technical fields, are included in the patent protection scope of this application.

Claims

1. An index state information display method characterized by comprising: The method for displaying indicator status information includes: Obtain the association information of multiple standard dimensions and multiple standard indicators, wherein each standard indicator is associated and bound to at least one standard dimension; Based on the aforementioned association information, obtain the status information under the corresponding standard dimension of the standard indicator; Based on the business monitoring objectives and the status information, the business monitoring objectives are converted into status SQL statements corresponding to the target dimensions and target indicators; Execute the status SQL statement to update the status information under the standard dimension corresponding to the standard indicator; Based on the user's interactive operations on the target indicators and target dimensions, the target completion information and status information corresponding to the target indicators are matched and displayed.

2. The indicator status information display method as described in claim 1, characterized in that, The status information includes at least warning status and highlight information. Prior to the step of obtaining the status information under the standard dimension corresponding to the standard indicator based on the association information, the following steps are included: Based on the aforementioned standard dimensions and standard indicators, a status information result table containing the warning status and highlight information is pre-constructed.

3. The indicator status information display method as described in claim 2, characterized in that, The step of converting the business monitoring target into status SQL statements corresponding to the target dimension and target indicator based on the business monitoring target and the status information includes: The business monitoring target is parsed into an indicator identifier, one or more dimension identifiers, and business rule conditions consisting of comparison operators and thresholds; Based on the indicator identifier and dimension identifier, a corresponding basic SQL template is matched from a predefined SQL template, wherein the basic SQL template contains dynamic parameter placeholders. After semantic validation and standardization of the business rule conditions, they are filled into the dynamic parameter placeholders to generate intermediate SQL with definite data query logic. The intermediate SQL is subjected to syntax tree analysis and pre-compilation optimization to generate status SQL statements for querying or calculating the warning status and highlight information.

4. The indicator status information display method as described in claim 3, characterized in that, The step of filling the dynamic parameter placeholders with the business rule conditions after semantic validation and standardization includes: Identify the logical operators in the business rule conditions, and break down multiple sub-conditions connected by AND or OR into independent sub-unit conditions; Map the dimension identifier associated with each sub-unit condition to a specific parameter placeholder in the corresponding WHERE or HAVING clause in the basic SQL template; For standard dimensions that do not participate in the current business rule conditions, fill in the corresponding parameter placeholders in the basic SQL template with system-predefined null identifiers.

5. The indicator status information display method as described in claim 4, characterized in that, The step of executing the status SQL statement to update the status information under the corresponding standard dimension of the standard indicator includes: The status SQL statement is submitted to the asynchronous task queue and executed in near real-time by the distributed task scheduler. During execution, a database transaction mechanism is used to ensure the atomicity of status information updates, and an operation log is recorded after successful execution. By comparing the current execution result with the historical data in the status information result table, the combination of indicators-dimensions that indicate a change in status is identified. The combination of metrics and dimensions that changes based on the status of the front-end configuration page update.

6. The indicator status information display method as described in claim 5, characterized in that, The user-based interactive operations on target metrics and target dimensions include: Receive initial creation or editing instructions from the user in the component library of the configuration page for the displayed cards; In response to the initial creation or editing command, an indicator-dimension selection panel is provided, which includes a standard indicator list, a standard dimension list, and a dimension value filter. Listen for user selection events on the selection panel. The selection events include: selecting one or more target indicators from the list of standard indicators, dragging or selecting one or more target dimensions from the list of standard dimensions to form a multi-dimensional observation perspective, and specifying filter condition values ​​for each target dimension in the dimension value filter. The selection event is encapsulated and a multidimensional query condition object is generated. The multidimensional query condition object includes at least a set of target indicator IDs, a set of target dimension IDs, and a set of dimension filter key-value pairs.

7. The indicator status information display method as described in claim 6, characterized in that, The step of matching and displaying the target completion information and status information corresponding to the target indicator includes: Receive the multidimensional query condition object and query the preprocessing status information that matches the multidimensional query condition object from the cache server; If the query result is not found, a real-time search is performed in the status information result table based on the target indicator identifier and dimension filtering conditions, and the search results are synchronized to the cache server. Based on predefined visual rule mapping, the acquired warning status is converted into corresponding color codes and charts, the highlight information is converted into highlighted text templates, and the target completion information is filled into the progress bar component; The target completion information and status information are rendered and integrated in the configurable interface to generate a unified data display card.

8. A device for displaying indicator status information, characterized in that, The indicator status information display device includes: The association information management module is used to obtain association information of multiple standard dimensions and multiple standard indicators, wherein each standard indicator is associated and bound to at least one standard dimension; The status information processing module is used to obtain the status information of the standard indicator under the corresponding standard dimension based on the association information; The SQL statement generation module is used to convert the business monitoring target into a status SQL statement corresponding to the target dimension and target indicator based on the business monitoring target and the status information. The status information update module is used to execute the status SQL statement and update the status information under the standard dimension corresponding to the standard indicator; The interactive display module is used to match and display the target completion information and status information corresponding to the target indicators based on the user's interactive operations on the target indicators and target dimensions.

9. A device for displaying indicator status information, characterized in that, The device includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, the computer program being configured to implement the steps of the indicator status information display method as described in any one of claims 1 to 7.

10. A storage medium, characterized in that, The storage medium is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by a processor, it implements the steps of the indicator status information display method as described in any one of claims 1 to 7.

Images