CN116821197A - Standardized performance query system, method, electronic equipment and storage medium - Google Patents

Standardized performance query system, method, electronic equipment and storage medium Download PDF

Info

Publication number
CN116821197A
CN116821197A CN202310778322.8A CN202310778322A CN116821197A CN 116821197 A CN116821197 A CN 116821197A CN 202310778322 A CN202310778322 A CN 202310778322A CN 116821197 A CN116821197 A CN 116821197A
Authority
CN
China
Prior art keywords
standardized
query
performance
index
platform
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310778322.8A
Other languages
Chinese (zh)
Inventor
谢鹏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Bank Co Ltd
Original Assignee
Ping An Bank Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ping An Bank Co Ltd filed Critical Ping An Bank Co Ltd
Priority to CN202310778322.8A priority Critical patent/CN116821197A/en
Publication of CN116821197A publication Critical patent/CN116821197A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2457Query processing with adaptation to user needs
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/26Visual data mining; Browsing structured data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/03Credit; Loans; Processing thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06TIMAGE DATA PROCESSING OR GENERATION, IN GENERAL
    • G06T11/002D [Two Dimensional] image generation
    • G06T11/20Drawing from basic elements, e.g. lines or circles
    • G06T11/206Drawing of charts or graphs
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • Databases & Information Systems (AREA)
  • Finance (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Accounting & Taxation (AREA)
  • Development Economics (AREA)
  • Computational Linguistics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application relates to the technical field of data processing, in particular to a standardized performance query system, a standardized performance query method, electronic equipment and a storage medium, wherein an online analysis processing OLAP (on-line analytical processing) data warehouse for storing index metadata is accessed through an index standardization platform, and custom standard description fields are added to construct a standardized index API (application program interface); configuring a standardized model connected with the constructed standardized index API through a component standardized model platform; selecting a plurality of target rendering components from the configured standardized model through a light-stream hand-assisting rapid configuration platform; therefore, the requirements for checking the performance of the bank in real time can be met by constructing the integrated light-flow hand-assisting rapid configuration platform with rich styles, the coupling among the platforms is low, and the upgrading and maintenance difficulty is reduced.

Description

Standardized performance query system, method, electronic equipment and storage medium
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a standardized performance query system, a standardized performance query method, an electronic device, and a storage medium.
Background
The performance index billboard is an important tool for monitoring the state of constructed health and making strategic decisions in the credit card operation process, is properly designed, has complete coverage of an index library, can help an operation decision maker to accurately know the current operation condition, adjusts resources aiming at insufficient points, and performs pushing and experience summarization aiming at dominant points, and is an important tool for enabling operation.
However, in the prior art, a customized iteration scheme is generally adopted in the industry, and the problems of long development period, slow iteration bulletin, non-uniform display logic, difficulty in understanding and the like exist for the data structure limited at the upper part and the display capability limited at the front end.
Disclosure of Invention
In order to overcome the defects in the prior art, the application provides a standardized performance query system, a standardized performance query device, a standardized performance query electronic device and a standardized performance query storage medium, which can be used for integrally and quickly building a light-flow hand-assisting quick configuration platform so as to meet the requirement of checking the variety of bank performance.
In a first aspect, the present application provides a standardized performance query system comprising:
the index standardization platform is used for accessing a data warehouse for online analysis processing (OLAP) to store index metadata, adding each custom standard description field and constructing a standardized index API;
the component standardized model platform is used for configuring a standardized model connected with the constructed standardized index API; the standardized model includes a plurality of rendering components;
and the light-flow hand-assisting rapid configuration platform is used for selecting a plurality of target rendering components from the configured standardized model.
In one possible embodiment, the system further comprises:
the query engine is used for carrying out query conversion, index routing, derivative query and searching a cache module, and setting a unified query interface connected with the standardized index API;
an OLAP engine, including a real-time data analysis engine and an offline data analysis engine;
wherein the real-time data analysis engine comprises one or more of Metrics, elasticSearch and the offline data analysis engine comprises one or more of Mysql, elasticSearch, starRock.
In one possible implementation, the standardized index API includes one or more of a query single index model queryOne, a time grouping query model queryTimeBatch of the index, a custom grouping query model queryGroup of the index, and a batch time grouping query model queryMultiTimeBatch of the index.
In one possible implementation, the rendering component includes a nine-grid component, a ranking distribution group price, a trend graph component, a funnel analysis component, a scatter plot component, a Vintage graph presentation component, and an index quick-view component.
In a second aspect, the present application provides a standardized performance query method applied to any one of the standardized performance query systems of the first aspect, the method comprising the steps of:
receiving a performance query request sent by a user based on a standardized index API of the index standardization platform, returning a query result corresponding to the performance query request, and sending the query structure to the rapid configuration platform of the light stream assistant;
and rendering the query result according to the rendering style of the target rendering component based on the target rendering component of the light-stream help rapid configuration platform, and displaying the query result to a user.
In one possible implementation manner, the system further comprises a query engine and an OLAP engine, the standardized index API based on the index standardization platform receives a performance query request sent by a user, and returns a query result corresponding to the performance query request, including the following steps:
receiving a performance query request sent by a user based on a standardized index API of the index standardization platform;
sending the performance query request to the OLAP engine to analyze the performance query request to obtain the to-be-processed performance data;
sending the to-be-processed performance data to the query engine to process the to-be-processed performance data to obtain a query result corresponding to the performance query request;
and sending the query result to the index standardization platform through a standardization index API.
In one possible implementation, the light-flow assist quick configuration platform sets a light-flow assist quick configuration interface that includes a standardized model selection area and a rendering component display area.
In one possible implementation manner, the target rendering component of the light-stream help rapid configuration platform is selected by the following manner:
selecting a target rendering component from the standardized model selection area according to the received rendering component selection instruction, and adding the target rendering component into the rendering component display area; wherein the rendering component selection instruction includes a drag instruction.
In a third aspect, the present application provides an electronic device comprising: a processor, a memory and a bus, the memory storing machine-readable instructions executable by the processor, the processor and the memory in communication over the bus when the electronic device is running, the machine-readable instructions when executed by the processor performing the steps of the standardized performance query method of any of the second aspects.
In a fourth aspect, the present application provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the standardized performance querying method of any of the second aspects.
The standardized performance query system, the standardized performance query method, the electronic device and the storage medium provided by the embodiment, wherein the index standardization platform is used for accessing a data warehouse for online analysis and processing of OLAP (on-line analytical processing) storage index metadata, adding custom standard description fields and constructing a standardized index API; the component standardization model platform is used for configuring a standardization model connected with the constructed standardization index API; the light-flow hand-assisting rapid configuration platform is used for selecting a plurality of target rendering components from the configured standardized model; receiving a performance query request sent by a user based on a standardized index API of the index standardization platform, returning a query result corresponding to the performance query request, and sending the query structure to the rapid configuration platform of the light stream assistant; and rendering the query result according to the rendering style of the target rendering component based on the target rendering component of the light-stream help rapid configuration platform, and displaying the query result to a user. Therefore, the requirements for checking the performance of the bank in real time can be met by constructing the integrated light-flow hand-assisting rapid configuration platform with rich styles, the coupling among the platforms is low, and the upgrading and maintenance difficulty is reduced.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments will be briefly described below, it being understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and other related drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of a standardized performance query system according to an embodiment of the present application;
FIG. 2 is a schematic structural diagram of an index standardization platform according to an embodiment of the present application;
FIG. 3 is a flow chart illustrating a standardized performance query method in accordance with one embodiment of the present application;
FIG. 4 illustrates a flow chart of returning query results corresponding to a performance query request in accordance with an embodiment of the present application;
FIG. 5 is a schematic diagram of a light-stream assist quick configuration interface according to an embodiment of the application;
FIG. 6 is a schematic diagram of a light stream assist quick configuration of a rendering assembly display area for a C-terminal product according to an embodiment of the application;
fig. 7 is a block diagram of an electronic device according to an embodiment of the application.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present application more apparent, the technical solutions of the embodiments of the present application will be clearly and completely described with reference to the accompanying drawings in the embodiments of the present application, and it should be understood that the drawings in the present application are for the purpose of illustration and description only and are not intended to limit the scope of the present application. In addition, it should be understood that the schematic drawings are not drawn to scale. A flowchart, as used in this disclosure, illustrates operations implemented according to some embodiments of the present application. It should be understood that the operations of the flow diagrams may be implemented out of order and that steps without logical context may be performed in reverse order or concurrently. Moreover, one or more other operations may be added to or removed from the flow diagrams by those skilled in the art under the direction of the present disclosure.
In addition, the described embodiments are only some, but not all, embodiments of the application. The components of the embodiments of the present application generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the application, as presented in the figures, is not intended to limit the scope of the application, as claimed, but is merely representative of selected embodiments of the application. All other embodiments, which can be made by a person skilled in the art without making any inventive effort, are intended to be within the scope of the present application.
It should be noted that the term "comprising" will be used in embodiments of the application to indicate the presence of the features stated hereafter, but not to exclude the addition of other features.
The performance index bulletin board is an important tool for monitoring the state of the constructed health and making strategic decisions in the credit card operation process, such as the indexes of the property scale, deposit increment rate, loan increment rate, credit card overdraft rate and the like, and the indexes are important references for helping banks evaluate the self operation condition and market competitiveness. However, at present, only a customized iteration scheme can be adopted for displaying various indexes in the industry, and the problem of low secondary development efficiency exists. Based on the above, the application provides a standardized performance query system, a standardized performance query method, electronic equipment and a storage medium, which can quickly build a platform for displaying different types of performance index data and respond to management results in real time.
In one embodiment, referring to fig. 1 of the specification, the present application provides a standardized performance query system, the system comprising:
the index standardization platform 101 is used for accessing a data warehouse for online analysis processing OLAP to store index metadata, adding each custom standard description field, and constructing a standardized index API;
a component standardization model platform 102 for configuring a standardization model connected with the constructed standardization index API; the standardized model includes a plurality of rendering components;
a light-flow hand-assisted quick configuration platform 103 for selecting a plurality of target rendering components from the standardized model of configuration.
In the present application, the index standardization platform 101 provides a standardized index API (Application Program Interface ), wherein the API interface is a set of definitions, programs and protocols, and the mutual communication between computer software is realized through the API interface. In this embodiment, the Standard Query Language (SQL) is mainly used as a standard query language for accessing data, and data sharing among application programs is realized through a database, specifically, a performance index query request sent by a client is received through the standardized index API.
The client can be a B-end product or a C-end product, and the two products are different in groups directly served by the B-end product and the C-end product, specifically, the B-end product is mainly oriented to enterprise organization, and the C-end product is mainly oriented to individual consumers. The main purpose of the B-end product is to surround the management target and the business target, the requirement on the user experience is not high, and the B-end product is simple, practical and effective, and pays attention to practical use; the C-terminal product is free of enterprise constraint for individuals, and is not used by people without good experience, so that the C-terminal product mainly focuses on user experience. The application herein is not limited and fixed with respect to the type of client.
In addition, referring to fig. 2 of the specification, in the present application, the system includes, in addition to the index standardization platform 101, the component standardization model platform 102 and the light-stream assistant quick configuration platform 103, a Query engine and an OLAP engine, where the Query engine (Query Engines) is focused on querying different data sources and formats in a unified manner, and in this embodiment, is mainly used to perform Query conversion, index routing, derivative Query, and search a cache module, and set a unified Query interface connected with the standardized index API; the OLAP engine provides a unified view of data, receipt of real-time and batch data, distributed indexing, its own data format, SQL support, JDBC interface, hot and cold data support, multiple integration and metadata storage. In this embodiment, specifically including a real-time data analysis engine and an offline data analysis engine; wherein the real-time data analysis engine comprises one or more of Metrics, elasticSearch and the offline data analysis engine comprises one or more of Mysql, elasticSearch, starRock.
In an embodiment, the standardized index API includes one or more of a query single index model queryOne, a time grouping query model queryTimeBatch for the index, a custom grouping query model queryGroup for the index, and a batch time grouping query model QueryMultiTimeBatch for the index.
The component standardization model platform 102 is connected with the index standardization platform 101 downwards and the light-flow hand-assistant quick configuration platform 103 upwards, and various standardization models are provided in the middle layer for providing different rendering components for the light-flow hand-assistant quick configuration platform 103. In an embodiment, the rendering component includes one or more of a nine-grid component, a ranking distribution set price, a trend graph component, a funnel analysis component, a scatter graph component, a Vintage graph presentation component, and an index quick-view component.
The light-stream help rapid configuration platform 103 is an aggregation platform of each rendering component, and mainly selects a suitable performance index from the component standardization model platform 102 for personalized display.
The standardized performance query system provided by the application is accessed into a data warehouse for online analysis processing OLAP to store index metadata through an index standardization platform, and each customized standard description field is added to construct a standardized index API; configuring a standardized model connected with the constructed standardized index API through a component standardized model platform; selecting a plurality of target rendering components from the configured standardized model through a light-stream hand-assisting rapid configuration platform; therefore, the requirements for checking the performance of the bank in real time can be met by constructing the integrated light-flow hand-assisting rapid configuration platform with rich styles, the coupling among the platforms is low, and the upgrading and maintenance difficulty is reduced.
Based on the same inventive concept, the embodiment of the present application further provides a standardized performance query method, and since the principle of solving the problem by the method in the embodiment of the present application is similar to that of the standardized performance query system described in the embodiment of the present application, the implementation of the method may refer to the implementation of the system, and the repetition is omitted.
As shown in fig. 3 of the specification, a standardized performance query method is applied to any one of the standardized performance query systems, and the method includes the following steps:
s1, receiving a performance query request sent by a user based on a standardized index API of the index standardization platform, returning a query result corresponding to the performance query request, and sending the query structure to the rapid configuration platform of the light stream assistant;
and S2, rendering the query result according to a rendering style of the target rendering component based on the target rendering component of the light-stream help rapid configuration platform, and displaying the query result to a user.
In step S1 and step S2, the performance query request sent by the user may be completed by the user based on an operation interface of the user side, and the operation interface used for sending the performance query request in the client side is connected with the standardized index API of the index standardization platform; specifically, the standardized index API of the index standardization platform receives a performance query request sent by a user, returns a query result corresponding to the performance query request, and simultaneously renders the query result.
In one embodiment, referring to fig. 4 of the specification, the system further includes a query engine and an OLAP engine, where the standardized index API based on the index standardization platform receives a performance query request sent by a user, and returns a query result corresponding to the performance query request, and includes the following steps:
s101, receiving a performance query request sent by a user based on a standardized index API of the index standardization platform;
s102, sending the performance query request to the OLAP engine to analyze the performance query request to obtain the to-be-processed performance data;
s103, sending the to-be-processed performance data to the query engine to process the to-be-processed performance data to obtain a query result corresponding to the performance query request;
s104, sending the query result to the index standardization platform through a standardization index API.
In step S101-step S104, namely after the standardized index API of the index standardization platform receives the performance query request sent by the user, the query engine and the OLAP engine process metadata in the performance query request sent by the user, specifically, the OLAP engine analyzes the performance query request to obtain the to-be-processed performance data, and then the query causes further query to the to-be-processed performance data, so as to finally obtain a corresponding query result; and after obtaining the query result corresponding to the performance query request, sending the query result to a light stream help rapid configuration platform for rendering through a corresponding rendering component, for example, rendering through a selected nine-grid component, a ranking distribution group price, a trend graph component, a funnel analysis component, a scatter diagram component, a Vintage graph display component or an index quick-view component, and finally returning the rendered query result to a client for displaying the user, thereby meeting the personalized style display of the credit card performance index condition of the user.
In addition, when the light-stream assisting hand rapid configuration platform is constructed, the corresponding configuration can be completed mainly by directly selecting the target rendering component from various rendering components preset in the component standardization model platform, and the configuration is simple and rapid.
Specifically, the light-flow hand-assisting quick configuration platform is provided with a light-flow hand-assisting quick configuration interface, and the light-flow hand-assisting quick configuration interface comprises a standardized model selection area and a rendering assembly display area.
In an embodiment, the target rendering component of the light-stream assist rapid configuration platform is selected by: and selecting a target rendering component from the standardized model selection area according to the received rendering component selection instruction, and adding the target rendering component to the rendering component display area.
Wherein the rendering component selection instruction includes a drag instruction, or by a combination of selection and movement, to select a target rendering component from the standardized model selection area and add to the rendering component display area.
Referring to fig. 5 of the drawings, in an embodiment, the light-current assist quick configuration interface includes a left standardized model selection area and a right rendering component display area, where the left standardized model selection area includes a "performance tracking module," a "performance analysis module," "a" screening condition module, "" a "goal management module," and "other modules," and each module includes a plurality of different units, where the "performance tracking module" includes 4 units, "the" performance analysis module "includes 8 units," the "screening condition module" includes 4 units, "the" goal management module "includes 1 unit," the "other modules" includes 9 units, and for example, the "performance tracking module" includes 4 units that are "an index list unit," "an index quick-view unit," "a ranking distribution unit," and an index ranking unit, respectively.
And marking a use prompt, namely clicking the dragging component, above the standardized model selection area. For example, by responding to a click operation sent by a user, a target rendering component "index quick view unit" is selected from a standardized model selection area on the left side, and then the selected target rendering component "index quick view unit" is moved to a rendering component display area on the right side by a drag operation. In this embodiment, the "index quick-view unit" mainly includes the indexes such as "the amount of the incoming part of the credit card", "the amount of the outgoing part of the credit card", "the new user amount", "the annual fee card duty ratio", "the real-time first-time rate of the new card", "the amount of the incoming part of the new user", and the like, and visually displays the current performance value of each index, the ring ratio value of the last day, and the homonymy value of the last week, respectively.
Just as the described client has the B-end product and the C-end product, the B-end product is mainly oriented to enterprise organization, so that when the light stream assisting hand quick configuration platform applied to the B-end product is built around the requirements of the management target and the business target, the target rendering component 'index list unit' can be added besides the target rendering component 'index quick list unit';
since the C-terminal product mainly focuses on user experience, referring to fig. 6 of the specification, a schematic diagram of a rendering component display area for the C-terminal product is quickly configured by a light-stream assistant in an embodiment, where when a platform for quickly configuring the light-stream assistant applied to the C-terminal product is built, a target rendering component "index quick-view unit" may be selected, and a target rendering component "index ranking unit" may be added, in this embodiment, a straight pipe center row is displayed, where the top-to-bottom ranking is sequentially "a straight pipe center", "B straight pipe center", "C straight pipe center", "D straight pipe center", and a corresponding numerical display is performed on a standard reaching rate and a standard reaching amount of the straight pipe center of each city.
In other embodiments, in constructing the light-stream assisting rapid configuration platform, different indexes and display modes thereof can be selected according to user requirements, and the application is not limited and fixed.
The standardized performance query method provided by the application is applied to a standardized performance query system, receives a performance query request sent by a user based on a standardized index API of the index standardized platform, returns a query result corresponding to the performance query request, and sends the query structure to the light stream help rapid configuration platform; and rendering the query result according to the rendering style of the target rendering component based on the target rendering component of the light-stream help rapid configuration platform, and displaying the query result to a user. Therefore, the requirements for checking the performance of the bank in real time can be met by constructing the integrated light-flow hand-assisting rapid configuration platform with rich styles, the coupling among the platforms is low, and the upgrading and maintenance difficulty is reduced.
Based on the same concept of the present application, fig. 7 of the present application shows a structure of an electronic device 700 according to an embodiment of the present application, where the electronic device 700 includes: at least one processor 701, at least one network interface 704 or other user interface 703, memory 705, at least one communication bus 702. The communication bus 702 is used to enable connected communications between these components. The electronic device 700 optionally includes a user interface 703 including a display (e.g., touch screen, LCD, CRT, holographic imaging (Holographic) or projection (Projector), etc.), keyboard or pointing device (e.g., mouse, trackball, touch pad or touch screen, etc.).
Memory 705 may include read-only memory and random access memory and provide instructions and data to the processor 701. A portion of the memory 705 may also include non-volatile random access memory (NVRAM).
In some implementations, the memory 705 stores the following elements, executable modules or data structures, or a subset thereof, or an extended set thereof:
the operating system 7051, which contains various system programs for implementing various basic services and handling hardware-based tasks;
the application program module 7052 contains various application programs such as a desktop (desktop), a Media Player (Media Player), a Browser (Browser), and the like for implementing various application services.
In the embodiment of the present application, the processor 701 is configured to execute steps in a standardized performance query method by calling a program or instructions stored in the memory 705, so as to integrally and quickly build a light-stream assisting quick configuration platform to meet the requirement of checking the variety of the bank performance.
The present application also provides a computer readable storage medium having stored thereon a computer program which when executed by a processor performs steps as in a standardized performance query method.
In particular, the storage medium can be a general-purpose storage medium, such as a removable disk, a hard disk, or the like, on which a computer program can be executed to perform the standardized performance query method described above.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other manners. The above-described apparatus embodiments are merely illustrative, for example, the division of units is merely a logical function division, and there may be other manners of division in actual implementation, and for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some communication interface, device or unit indirect coupling or communication connection, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed over a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments provided in the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method of the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
Finally, it should be noted that: the above examples are only specific embodiments of the present application for illustrating the technical solution of the present application, but not for limiting the scope of the present application, and although the present application has been described in detail with reference to the foregoing examples, it will be understood by those skilled in the art that the present application is not limited thereto: any person skilled in the art may modify or easily conceive of the technical solution described in the foregoing embodiments, or perform equivalent substitution of some of the technical features, while remaining within the technical scope of the present disclosure; such modifications, changes or substitutions do not depart from the spirit and scope of the corresponding technical solutions. Are intended to be encompassed within the scope of the present application. Therefore, the protection scope of the application is subject to the protection scope of the claims.

Claims (10)

1. A standardized performance query system, the system comprising:
the index standardization platform is used for accessing a data warehouse for online analysis processing (OLAP) to store index metadata, adding each custom standard description field and constructing a standardized index API;
the component standardized model platform is used for configuring a standardized model connected with the constructed standardized index API; the standardized model includes a plurality of rendering components;
and the light-flow hand-assisting rapid configuration platform is used for selecting a plurality of target rendering components from the configured standardized model.
2. The standardized performance query system of claim 1 wherein the system further comprises:
the query engine is used for carrying out query conversion, index routing, derivative query and searching a cache module, and setting a unified query interface connected with the standardized index API;
an OLAP engine, including a real-time data analysis engine and an offline data analysis engine;
wherein the real-time data analysis engine comprises one or more of Metrics, elasticSearch and the offline data analysis engine comprises one or more of Mysql, elasticSearch, starRock.
3. The standardized performance query system of claim 2 wherein the standardized metrics API comprises one or more of a query single metrics model queryOne, a time grouping query model queryTimeBatch for metrics, a custom grouping query model queryGroup for metrics, and a batch time grouping query model querymultittimebatch for metrics.
4. The standardized performance query system of claim 3 wherein the rendering component comprises a nine-grid component, a ranking distribution group price, a trend graph component, a funnel analysis component, a scatter plot component, a Vintage graph presentation component, an index quick-view component.
5. A standardized performance query method, applied to any one of the standardized performance query systems described above, comprising the steps of:
receiving a performance query request sent by a user based on a standardized index API of the index standardization platform, returning a query result corresponding to the performance query request, and sending the query structure to the rapid configuration platform of the light stream assistant;
and rendering the query result according to the rendering style of the target rendering component based on the target rendering component of the light-stream help rapid configuration platform, and displaying the query result to a user.
6. The standardized performance query method of claim 5 wherein the system further comprises a query engine and an OLAP engine, the standardized metrics API based on the metrics standardization platform receiving a user-sent performance query request and returning a query result corresponding to the performance query request, comprising the steps of:
receiving a performance query request sent by a user based on a standardized index API of the index standardization platform;
sending the performance query request to the OLAP engine to analyze the performance query request to obtain the to-be-processed performance data;
sending the to-be-processed performance data to the query engine to process the to-be-processed performance data to obtain a query result corresponding to the performance query request;
and sending the query result to the index standardization platform through a standardization index API.
7. The standardized performance query method of claim 6 wherein the light stream assist quick configuration platform sets a light stream assist quick configuration interface comprising a standardized model selection area and a rendering component display area.
8. The standardized performance query method of claim 6 wherein the target rendering component of the lightweight class assist rapid configuration platform is selected by:
selecting a target rendering component from the standardized model selection area according to the received rendering component selection instruction, and adding the target rendering component into the rendering component display area; wherein the rendering component selection instruction includes a drag instruction.
9. An electronic device, comprising: a processor, a memory and a bus, said memory storing machine readable instructions executable by said processor, said processor and said memory communicating over the bus when the electronic device is running, said machine readable instructions when executed by said processor performing the steps of the standardized performance query method of any of claims 5 to 8.
10. A computer readable storage medium, characterized in that the computer readable storage medium has stored thereon a computer program which, when executed by a processor, performs the steps of the standardized performance query method of any of claims 5 to 8.
CN202310778322.8A 2023-06-28 2023-06-28 Standardized performance query system, method, electronic equipment and storage medium Pending CN116821197A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310778322.8A CN116821197A (en) 2023-06-28 2023-06-28 Standardized performance query system, method, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310778322.8A CN116821197A (en) 2023-06-28 2023-06-28 Standardized performance query system, method, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN116821197A true CN116821197A (en) 2023-09-29

Family

ID=88127087

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310778322.8A Pending CN116821197A (en) 2023-06-28 2023-06-28 Standardized performance query system, method, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN116821197A (en)

Similar Documents

Publication Publication Date Title
US10628775B2 (en) Sankey diagram graphical user interface customization
US7571191B2 (en) Defining a data analysis process
US8340995B2 (en) Method and system of using artifacts to identify elements of a component business model
CN111177231A (en) Report generation method and report generation device
US9098858B2 (en) Visualizing expressions for dynamic analytics
US8032591B2 (en) Systems and methods for mapping event changes in network navigation
US20130159832A1 (en) Systems and methods for trading using an embedded spreadsheet engine and user interface
US20160063072A1 (en) Systems, methods, and apparatuses for detecting activity patterns
US20070038641A1 (en) Systems and methods for automated application updating
US20090327402A1 (en) Systems and methods for mapping user experiences in network navigation
US10067964B2 (en) System and method for analyzing popularity of one or more user defined topics among the big data
US20180018066A1 (en) Data visualization configuration system and method
US8239371B2 (en) Fast search views over business objects
CN117454278A (en) Method and system for realizing digital rule engine of standard enterprise
CN116594683A (en) Code annotation information generation method, device, equipment and storage medium
CN108781223A (en) The data packet transfer optimization of data for content item selection
CN112102099B (en) Policy data processing method and device, electronic equipment and storage medium
Kimball The evolving role of the enterprise data warehouse in the era of big data analytics
US20210090105A1 (en) Technology opportunity mapping
US8417594B2 (en) Dimension-based financial reporting using multiple combinations of dimensions
CN109189810B (en) Query method, query device, electronic equipment and computer-readable storage medium
US20150248685A1 (en) Automated identification of sales opportunities based on stored market data
CN116821197A (en) Standardized performance query system, method, electronic equipment and storage medium
US10540709B2 (en) Presentation of digital data
US20140149186A1 (en) Method and system of using artifacts to identify elements of a component business model

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination