CN115113862A - Method and device for creating derived indexes, electronic equipment and storage medium - Google Patents

Method and device for creating derived indexes, electronic equipment and storage medium Download PDF

Info

Publication number
CN115113862A
CN115113862A CN202210753919.2A CN202210753919A CN115113862A CN 115113862 A CN115113862 A CN 115113862A CN 202210753919 A CN202210753919 A CN 202210753919A CN 115113862 A CN115113862 A CN 115113862A
Authority
CN
China
Prior art keywords
index
derived
configuration
creation interface
interface
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
CN202210753919.2A
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 CN202210753919.2A priority Critical patent/CN115113862A/en
Publication of CN115113862A publication Critical patent/CN115113862A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/34Graphical or visual programming
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/38Creation or generation of source code for implementing user interfaces
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/70Software maintenance or management
    • G06F8/71Version control; Configuration management
    • 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
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0639Performance analysis of employees; Performance analysis of enterprise or organisation operations
    • G06Q10/06393Score-carding, benchmarking or key performance indicator [KPI] analysis

Landscapes

  • Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Educational Administration (AREA)
  • Strategic Management (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Marketing (AREA)
  • Game Theory and Decision Science (AREA)
  • Computer Security & Cryptography (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Human Computer Interaction (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The invention discloses a method and a device for creating a derived index, electronic equipment and a storage medium, wherein the method comprises the following steps: responding to a derivative index creating instruction sent by a client, and displaying an index creating interface, wherein the index creating interface displays an index calculation logic configuration area, an index basic information setting area and a plurality of visual program controls; responding to an index configuration operation acted on the index creation interface, and determining the configuration of the derived index, wherein the index configuration operation at least comprises a logic operation setting operation of a visual program control selected in the index calculation logic configuration area and a basic information setting operation performed in the index basic information setting area; and in response to a saving operation acting on the index creation interface, saving the configuration of the derived index to generate a derived index. The invention solves the problems that the current index has poor flexibility and is difficult to flexibly process more complex index data statistical logic.

Description

Method and device for creating derived indexes, electronic equipment and storage medium
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for creating a derived index, electronic equipment and a storage medium.
Background
At present, logic based on data statistics is usually selected by a rule preset by a system, each index is usually system default statistics, general indexes are mainly divided into two large types including a numerical type and a counting type, wherein the numerical type is money, quantity and the like obtained by directly calculating through business logic, the counting type is divided into unique counting and non-unique counting, the counting type is obtained by counting code values in a certain field, the traditional index has a single function and poor flexibility, more complex index data statistical logic is difficult to flexibly process, when the logic needs to be applied to the complex index data statistical logic, professional personnel are needed to carry out program design, the logic is inconvenient to use, and the professional requirements are high.
Disclosure of Invention
The invention aims to overcome the technical defects, provides a method, a device, electronic equipment and a storage medium for creating a derived index, and solves the technical problems that indexes in the prior art are poor in flexibility and are difficult to flexibly process more complex index data statistical logic.
In order to achieve the technical purpose, the invention adopts the following technical scheme:
in a first aspect, the present invention provides a method for creating a derived index, including:
responding to a derivative index creating instruction sent by a client, and displaying an index creating interface, wherein the index creating interface displays an index calculation logic configuration area, an index basic information setting area and a plurality of visual program controls;
responding to an index configuration operation acted on the index creation interface, and determining the configuration of the derived index, wherein the index configuration operation at least comprises a logic operation setting operation of a visual program control selected in the index calculation logic configuration area and a basic information setting operation performed in the index basic information setting area;
and in response to a saving operation acting on the index creation interface, saving the configuration of the derived index to generate a derived index.
In some embodiments, the logical operation setting operation includes a selection operation and a drag operation, and the determining the configuration of the derived indicator in response to an indicator configuration operation applied to the indicator creation interface includes:
displaying a visual program control selected by a user in the index calculation logic configuration area based on a selection operation acted on the index creation interface;
combining the selected visual program controls based on a dragging operation acting on an index creation interface to realize logic operation configuration of derived indexes;
and configuring the basic information of the derived index based on a basic information setting operation acting on the index basic information setting area.
In some embodiments, the visualization program controls include at least an atomic index type visualization program control, a function type visualization program control, and an operator type visualization program control.
In some embodiments, the displaying, in the indicator calculation logic configuration area, the user-selected visual program control based on the selection operation performed on the indicator creation interface includes:
selecting a plurality of atom index type visualization program controls based on selection operation acting on an index creation interface, and then displaying the atom index type visualization program controls in the index calculation logic configuration area; and
selecting a plurality of function type visualization program controls to perform parameter configuration on the selected function type visualization program controls based on selection operation acting on an index creation interface, and displaying the function type visualization program controls in the index calculation logic configuration area; and/or
And based on the selection operation acted on the index creation interface, selecting a plurality of operator type visual program controls and then displaying the operator type visual program controls in the index calculation logic configuration area.
In some embodiments, said saving the configuration of the derived metrics to generate derived metrics in response to a save operation acting on the metric creation interface comprises:
responding to a saving operation acted on the index creating interface, and verifying the configuration of the derived index;
and when the configuration verification of the derived indexes passes, storing the configuration of the derived indexes to generate the derived indexes, otherwise, generating configuration failure information and displaying the configuration failure information on the index creation interface.
In some embodiments, the verifying the configuration of the derived metric in response to the save operation acting on the metric creation interface includes:
and in response to a saving operation acting on the index creation interface, verifying the configuration of the derived index by adopting a preset index verification control, wherein the index verification control is configured with an index verification rule, and the index verification rule is used for performing logical operation verification on the configuration of the derived index.
In some embodiments, after saving the configuration of the derived metrics to generate derived metrics in response to a save operation performed on the metrics creation interface, the method further comprises:
and generating index information corresponding to the derived indexes according to the metadata corresponding to the derived indexes.
In a second aspect, the present invention further provides a derived index creating apparatus, including:
the interface display module is used for responding to a derivative index creation instruction sent by a client and displaying an index creation interface, wherein the index creation interface displays an index calculation logic configuration area, an index basic information setting area and a plurality of visual program controls;
the index configuration module is used for responding to index configuration operation acted on the index creation interface and determining the configuration of the derived index, wherein the index configuration operation at least comprises the logical operation setting operation of a visual program control selected in the index calculation logical configuration area and the basic information setting operation performed in the index basic information setting area;
and the index generation module is used for responding to the storage operation acted on the index creation interface and storing the configuration of the derived index so as to generate the derived index.
In a third aspect, the present invention also provides an electronic device, including: a processor and a memory;
the memory having stored thereon a computer program executable by the processor;
the processor, when executing the computer program, implements the steps in the derived index creation method as described above.
In a fourth aspect, the present invention also provides a computer-readable storage medium storing one or more programs, which are executable by one or more processors to implement the steps in the derived index creation method as described above.
According to the method, the device, the electronic equipment and the storage medium for creating the derived indexes, provided by the invention, the index creation interface with various visual program controls is provided for a user, so that the user can operate on the index creation interface, the visual program controls are utilized to carry out logic operation configuration and basic information configuration on the derived indexes required by the user, the operation is simple, the development period is short, the development efficiency and the creation usability of the derived indexes are improved, the derived indexes are more flexible, more complex index data statistical logic can be flexibly processed, the utilization efficiency is higher, and a business party can reduce the dependence on data development.
Drawings
FIG. 1 is a system architecture diagram of an embodiment of a derived metric creation platform provided by the present invention;
FIG. 2 is a flowchart of an embodiment of a method for creating derived indicators according to the present invention;
fig. 3 is a flowchart of an embodiment of step S200 in the method for creating derived index provided by the present invention;
fig. 4 is a flowchart of an embodiment of step S300 in the method for creating derived index provided by the present invention;
FIG. 5 is a schematic diagram of functional modules of a derived index creation apparatus provided in the present invention;
fig. 6 is a schematic diagram of a hardware structure of the electronic device provided by the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The technical scheme of the embodiment of the invention can be applied to scenes in which a large number of repeated and fixed operations need to be executed in the fields of IT technical field, human resource service field, supply chain field, financial field and the like, a plurality of visual program controls with different functions are provided for users in the fields through the index creation interface, the users can select the visual program controls with corresponding functions on the index creation interface according to specific requirements, derivative indexes which are suitable for the requirements of the users and used for executing a large number of repeated and fixed index data statistical logics can be created for the users according to the setting and combination of the visual program controls by the users, the creation of the derivative indexes can be completed without much development knowledge mastered by the users, the development period and the development difficulty of the derivative indexes are shortened, and the users can quickly develop the derivative indexes which need to be developed, and the user can create a derived index which has strong flexibility and can flexibly process the complex index data statistical logic according to the requirement.
Referring to fig. 1, fig. 1 is a schematic diagram of a system architecture of a derived index creation platform according to an embodiment of the present invention, and as shown in the figure, the derived index creation platform may include a derived index creation server 101 and a display terminal 102, where the derived index creation server 101 is a "backend device" of the derived index creation platform, and one or more of the derived index creation servers 101 may be used to provide support and services for the display terminal 102. The derived index creation server 101 stores therein a plurality of application controls having different functions, and the plurality of application controls having different functions can be displayed in a visual form on the display terminal 102. The display terminal 102 is a "front-end device" of the derived metric creation platform, which can be used to display a metric creation interface to a user. The display terminal 102 may interact with the user, obtain a user operation of the user on the indicatable creation interface, and feed back the user operation to the derived indicator creation server 101 in a direct or indirect manner. Specifically, the display terminal 102 may be a mobile phone, a computer, a tablet computer, or the like. The derived index creation platform may be a platform of a client/server (C/S) architecture, and at this time, the display terminal 102 is a client corresponding to the derived index creation platform. The derived index creating platform may also be a browser/server (B/S) architecture platform, and in this case, the display terminal 102 is a browser installed with the derived index creating platform.
Referring to fig. 2, fig. 2 is a flowchart illustrating a method for creating a derived index according to an embodiment of the present invention, where the method can be implemented on the derived index creating server shown in fig. 1, and as shown in the figure, the method includes steps S100 to S300.
S100, responding to a derivative index creating instruction sent by a client, and displaying an index creating interface, wherein the index creating interface displays an index calculation logic configuration area, an index basic information setting area and a plurality of visual program controls.
In this embodiment, the derivative indicator creating instruction is used to create a derivative indicator, and the derivative indicator is an indicator obtained by performing addition, subtraction, multiplication, and division or restriction on a modifier on an atomic indicator. The derived index can be applied to occasions where statistical logic calculation of index data is needed, such as IT technology, human resource service, supply chain, finance and the like.
The client is used for providing a visual interface according to the control of the server, and the server realizes the creation of the derived indexes according to the content received on the visual interface. The client may be a display terminal and may provide a login interface, and after the user logs in successfully through login information such as an account of the user, the user sends a derivative indicator creation instruction to the server through the client, where the derivative indicator creation instruction may include an instruction for requesting to open an indicator creation interface, and the server responds to the instruction and displays the indicator creation interface at the client.
The index creation interface is provided with an index calculation logic configuration area and an index basic information setting area, wherein the index calculation logic configuration area is used for a user to perform calculation logic configuration of the derived index, for example, atomic indexes and operators in the area are combined to generate an operation logic, the operation logic can perform logic calculation, and the index basic information setting area is used for setting basic information of the derived index, such as index aperture, index similarity, service line and the like. In addition, the index creation interface displays a plurality of visualization program controls, and after the user clicks or selects one of the visualization program controls, the index creation interface may also display a subroutine control corresponding to each function that the visualization program control can provide, for example, a subroutine control that is an operation transferred to a parameter configuration page of the visualization program control.
S200, responding to an index configuration operation acted on the index creation interface, and determining the configuration of the derived index, wherein the index configuration operation at least comprises a logic operation setting operation of a visual program control selected in the index calculation logic configuration area and a basic information setting operation performed in the index basic information setting area.
In this embodiment, the index configuration operation of the user on the index creation interface may be an operation that the user indirectly acts on the index creation interface through a mouse, a keyboard, or the like; the index configuration operation of the user on the index creation interface may also be an operation in which the user directly acts on the index creation interface by a finger, a stylus, or the like. The index configuration operation may include an operation of selecting a visual program control on the index creation interface by a user, a logical operation setting operation of the visual program control selected in the index calculation logical configuration area, and a basic information setting operation performed in the index basic information setting area.
And S300, responding to the saving operation acted on the index creation interface, and saving the configuration of the derived index to generate the derived index.
In this embodiment, the operation of saving the configuration of the derived index on the index creation interface by the user refers to an operation of saving the configuration of the derived index on the index creation interface after the user completes the configuration of the derived index. Illustratively, a 'save' button is provided on the index creation interface, and when the user configuration is completed, the 'save' button is clicked, so that the derived index configuration can be saved, and the required derived index is generated.
The embodiment of the invention provides the index creation interface with various visual program controls for the user, so that the user can operate on the index creation interface, the visual program controls are utilized to carry out logic operation configuration and basic information configuration on the derived indexes required by the user, the operation is simple, the development period is short, the development efficiency and the creation usability of the derived indexes are improved, the derived indexes have stronger flexibility, more complex index data statistical logic can be flexibly processed, the utilization efficiency is higher, and a business party can reduce the dependence on data development.
In some embodiments, referring to fig. 3, the logic operation setting operation includes a selection operation and a drag operation, and the determining the configuration of the derived indicator in response to the indicator configuration operation applied to the indicator creation interface includes:
s210, displaying a visual program control selected by a user in the index calculation logic configuration area based on a selection operation acted on an index creation interface;
s220, combining the selected visual program control based on a dragging operation acted on an index creation interface to realize logic operation configuration of a derived index;
and S230, configuring the basic information of the derived index based on the basic information setting operation acted on the index basic information setting area.
In the embodiment, a user selects a required visual program control on a visual interface, specifically, the visual program control on the interface can be created by clicking the index, after clicking, the name of the visual program control is displayed in the index calculation logic configuration area, then the user can drag the selected visual program control in the index calculation logic configuration area, so that each visual program control is combined according to the user requirement and appears at a proper position, and logic calculation is performed according to the user requirement, thereby obtaining the configuration of the derived index meeting the user requirement, and the creation rule is simple and clear, and the visual index creation is adopted, so that the usability of the derived index creation is increased, in addition, the user can quickly obtain the required derived index by only performing logic operation combination on each visual program control, is simple and convenient.
After the configuration is completed, a user can input basic information of the derived indexes, such as basic information of the index caliber, similar indexes, belonging business lines and the like, through input operation directly in the index basic information setting area of the index creation interface, and the method is simple and convenient.
In some embodiments, the visualization program controls include at least an atomic index type visualization program control, a function type visualization program control, and an operator type visualization program control.
In this embodiment, in order to increase the computing power of the derivative indicators, the required derivative indicators can be obtained by combining multiple different types of visualization program controls. The atom index type visualization program control is various atom indexes, such as numerical indexes, counting indexes and the like. Each atomic index is configured with dimension information such as mechanisms, channels, product types, wealth grades and the like in a background of the derived index creation platform, and when a plurality of different atomic indexes are selected, the derived index creation platform can check whether the dimensions of the atomic indexes have intersection or not so as to carry out merging calculation operation.
The function type visualization program control is used for setting calculation rules among all atomic indexes, and the function type visualization program control is used for realizing the standard of data statistical calculation, wherein the function type visualization degree control comprises but is not limited to a mean function, a maximum value function, a minimum value function, a median function, a fixed value function, a time migration function, a conditional filtering function and the like.
The operator type visualization program controls are controls that perform four arithmetic operations on the atomic index, and include, but are not limited to, plus signs, minus signs, multiply signs, divide signs, brackets, and the like.
According to the embodiment of the invention, the configuration of the derived index can be rapidly obtained according to the requirement by combining the atomic index and the operation function or operator, so that the purpose of rapidly creating the derived index is achieved, the flexibility is strong, and more complex index data statistical logic can be flexibly processed.
In some embodiments, the step S210 includes:
selecting a plurality of atom index type visualization program controls based on selection operation acting on an index creation interface, and then displaying the atom index type visualization program controls in the index calculation logic configuration area; and
selecting a plurality of function type visualization program controls to perform parameter configuration on the selected function type visualization program controls based on selection operation acting on an index creation interface, and displaying the function type visualization program controls in the index calculation logic configuration area; and/or
And selecting a plurality of operator type visual program controls based on selection operation acted on the index creation interface, and then displaying the operator type visual program controls in the index calculation logic configuration area.
In this embodiment, a user first clicks an index control on an index creation interface, selects a derived index to be calculated, displays a derived index name in an index calculation logic configuration area, then clicks an operator or a function, the operator and the function are also present in the index calculation logic configuration area, and each selected control in the index calculation logic configuration area appears in a sequential order, and needs to drag a "+" sign to a correct position, and performs calculation according to four rules of operation.
When selecting a function, the function needs to be configured with parameters. Specifically, the maximum function, the minimum function, the average function, and the median function find corresponding values in the range of the selected dimension code value, for example, if a branch is selected as the analysis dimension, the maximum value, the minimum value, the average value, and the median of the amount of money in all the branch ranges are found. The fixed value function is a special function, the amount of money of a certain atomic index can be locked so that the atomic index does not receive the influence of the filtering condition, for example, if the proportion of the dividend of the amount of money of the normal fund to the whole line is calculated, the denominator can be set as the fixed value of the amount of money of the normal fund, the numerator is the amount of money of the normal fund (the amount of money of the normal fund/the fixed value [ the amount of money of the normal fund ]), and when the index is checked, the users of the Shanghai dividend line and the Shenzhen dividend can respectively see the proportion of the amount of money of the normal fund to the whole line. The Tianjian filtering function may filter filtering conditions for the index, for example, only care about the general money amount of the Shanghai branch, and then set the filtering conditions to be summarized for the Shanghai branch. The time migration function can set up the query time for the index, and support dynamic N days ago, N weeks ago, N months ago, or fixed date; for example, if the user wants to know the amount of the common money 30 days ago, the offset of 30 days ago can be configured; or if the value of 12 months and 31 days in 2021 is to be known, the fixed date can be set to 2021-12-31; by means of the time offset, it is possible to calculate indicators such as parity, growth versus a fixed date, etc. By the condition filtering and time migration calculation function functions designed around the scene, the capability of deriving the indexes is greatly expanded, and the derived indexes can be applied in a wider range.
In some embodiments, referring to fig. 4, the step S300 includes:
s310, responding to the storage operation acted on the index creation interface, and verifying the configuration of the derived index;
s320, when the configuration verification of the derived indexes passes, storing the configuration of the derived indexes to generate derived indexes, otherwise, generating configuration failure information and displaying the configuration failure information on the index creation interface.
In this embodiment, to ensure the reasonability of the configuration of the derived index by the user, the configuration of the derived index needs to be checked first when the configuration of the derived index is stored, so that the derived index is prevented from being unusable due to unreasonable configuration. When the configuration of the derived indexes is reasonable, the derived indexes are directly stored. And when the configuration of the derived indexes is unreasonable, generating and displaying configuration failure information, wherein the configuration failure information comprises information for prompting configuration failure and reason information for configuration failure. Illustratively, when the verification is passed, the success of the creation of the index can be displayed through a pop-up window, and the derived index after the verification is passed can be applied to occasions such as an index map, an index billboard and the like. When the verification fails, the verification failure can be prompted through a popup window, and the reason of the verification failure is displayed on the popup window.
In some embodiments, the step S310 includes:
and in response to a saving operation acting on the index creation interface, verifying the configuration of the derived index by adopting a preset index verification control, wherein the index verification control is configured with an index verification rule, and the index verification rule is used for performing logical operation verification on the configuration of the derived index.
In this embodiment, an index verification control configured with an index verification rule is preset on the derived index creation platform, and when a user clicks a "save" button, the index verification control verifies the configuration of the derived index by using the index verification rule, for example, whether there is an unpaired bracket, whether there is a derived index that is not connected by an operator, and the like.
In some embodiments, to facilitate searching for the created derived index, the derived index creating method further includes:
and generating index information corresponding to the derived indexes according to the metadata corresponding to the derived indexes.
In this embodiment, after the derived index is stored, an index may be set for the derived index, so that the index may be directly used to find the required derived index in the application stage. In specific implementation, the index information can be set by using the metadata corresponding to the indexes in the derived index creation platform, so that the search of a user is facilitated. In application, for example, a user firstly queries metadata corresponding to a derived index, then obtains index information generated in advance by the derived index, and then queries a required derived index through an SQL query statement after generating the SQL query statement according to the index information.
According to the embodiment of the invention, through the index derivation function, the utilization efficiency of the index can be greatly improved, and the dependence on data development can be reduced by a business party; through the visual index creating technology, the usability of the index creation is improved, and the creating rule is simple and clear; in addition, the function of condition filtering and time migration calculation functions designed around the scene greatly expands the capability of index derivation, so that the index derivation can be applied in a wider range.
Referring to fig. 5, the apparatus for creating a derived index according to another embodiment of the present invention includes an interface display module 11, an index configuration module 12, and an index generation module 13.
The interface display module 11 is configured to display an index creation interface in response to a derived index creation instruction sent by a client, where the index creation interface displays an index calculation logic configuration area, an index basic information setting area, and a plurality of visual program controls;
the index configuration module 12 is configured to determine the configuration of the derived index in response to an index configuration operation acting on the index creation interface, where the index configuration operation at least includes a logical operation setting operation of a visual program control selected in the index calculation logical configuration area and a basic information setting operation performed in the index basic information setting area;
the index generation module 13 is configured to save the configuration of the derived index in response to a saving operation acting on the index creation interface to generate a derived index.
The embodiment of the invention provides the index creation interface with various visual program controls for the user, so that the user can operate on the index creation interface, the visual program controls are utilized to carry out logic operation configuration and basic information configuration on the derived indexes required by the user, the operation is simple, the development period is short, the development efficiency and the creation usability of the derived indexes are improved, the derived indexes have stronger flexibility, more complex index data statistical logic can be flexibly processed, the utilization efficiency is higher, and a business party can reduce the dependence on data development.
It should be noted that the modules referred to in the present invention refer to a series of computer program instruction segments capable of performing specific functions, and are more suitable for describing the execution process of creating the derived indicators than the program.
In some embodiments, the logical operation setting operation includes a selection operation and a drag operation, and the index configuration module 12 includes a selection unit, a drag unit, and a basic information setting unit.
The selection unit is used for displaying the visual program control selected by the user in the index calculation logic configuration area based on the selection operation acted on the index creation interface.
The dragging unit is used for combining the selected visual program control based on dragging operation acting on the index creation interface so as to realize logic operation configuration of the derived index.
The basic information setting unit is configured to configure the basic information of the derived index based on a basic information setting operation that acts on the index basic information setting area.
In some embodiments, the visualization program controls include at least an atomic index type visualization program control, a function type visualization program control, and an operator type visualization program control.
In some embodiments, the selecting unit includes an index presenting unit, a function presenting unit and an operator presenting unit.
The index display unit is used for selecting a plurality of atom index type visualization program controls based on selection operation acting on the index creation interface and displaying the atom index type visualization program controls in the index calculation logic configuration area.
The function display unit is used for selecting a plurality of function type visualization program controls to carry out parameter configuration on the selected function type visualization program controls based on selection operation acting on the index creation interface, and displaying the function type visualization program controls in the index calculation logic configuration area.
The operator display unit is used for selecting a plurality of operator type visual program controls based on the selection operation acted on the index creation interface and then displaying the operator type visual program controls in the index calculation logic configuration area.
In some embodiments, the indicator generating module 13 comprises a checking unit and a saving unit.
The verification unit is used for responding to the storage operation acted on the index creation interface and verifying the configuration of the derived index.
And the storage unit is used for storing the configuration of the derived indexes to generate the derived indexes when the configuration verification of the derived indexes passes, and otherwise, generating configuration failure information and displaying the configuration failure information on the index creation interface.
In some embodiments, the verification unit is specifically configured to, in response to a save operation acting on the index creation interface, verify the configuration of the derived index by using a preset index verification control, where the index verification control is configured with an index verification rule, and the index verification rule is used to perform logical operation verification on the configuration of the derived index.
In some embodiments, the derived index creating apparatus further includes an index generating module, configured to generate index information corresponding to the derived index according to metadata corresponding to the derived index.
Another embodiment of the present invention provides an electronic device, as shown in fig. 6, an electronic device 10 includes:
one or more processors 110 and a memory 120, where one processor 110 is illustrated in fig. 4, the processor 110 and the memory 120 may be connected by a bus or other means, and where fig. 6 illustrates a bus connection.
The processor 110 is used to implement various control logic for the electronic device 10, which may be a general purpose processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA), a single chip microcomputer, an ARM (Acorn RISC machine) or other programmable logic device, discrete gate or transistor logic, discrete hardware components, or any combination of these components. Also, the processor 110 may be any conventional processor, microprocessor, or state machine. Processor 110 may also be implemented as a combination of computing devices, e.g., a combination of a DSP and a microprocessor, a plurality of microprocessors, one or more microprocessors in conjunction with a DSP, and/or any other such configuration.
The memory 120 is a non-volatile computer-readable storage medium, and can be used to store non-volatile software programs, non-volatile computer-executable programs, and modules, such as program instructions corresponding to the derived index creating method in the embodiment of the present invention. The processor 110 executes various functional applications and data processing of the electronic device 10 by executing the nonvolatile software programs, instructions and units stored in the memory 120, that is, implements the derived index creation method in the above method embodiment.
The memory 120 may include a storage program area and a storage data area, wherein the storage program area may store an application program required for operating the platform, at least one function; the stored data area may store data created from use of the electronic device 10, and the like. Further, the memory 120 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some embodiments, memory 120 optionally includes memory located remotely from processor 110, which may be connected to electronic device 10 via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
One or more units are stored in the memory 120, and when executed by the one or more processors 110, perform the derived index creation method in any of the above-described method embodiments, e.g., performing the above-described method steps S100-S300 in fig. 2.
Another embodiment of the present invention provides a computer-readable storage medium storing computer-executable instructions for execution by one or more processors, for example, to perform method steps S100 to S300 of fig. 2 described above.
By way of example, computer-readable storage media can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), electrically erasable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM), which acts as external cache memory. By way of illustration and not limitation, RAM is available in many forms such as Synchronous RAM (SRAM), dynamic RAM, (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchlink DRAM (SLDRAM), and Direct Rambus RAM (DRRAM). The disclosed memory components or memory of the operating environment described herein are intended to comprise one or more of these and/or any other suitable types of memory.
In summary, the method, the apparatus, the electronic device, and the storage medium for creating derived indicators provided by the present invention provide an indicator creation interface with multiple visual program controls for a user, so that the user can operate on the indicator creation interface, and perform logical operation configuration and basic information configuration on derived indicators required by the user by using the visual program controls, which is simple in operation, short in development cycle, and capable of improving development efficiency and ease of creation of derived indicators, and making derived indicators more flexible, capable of flexibly processing more complex indicator data statistics logic, and more efficient in utilization, and making a business party reduce dependence on data development.
The above-described embodiments of the present invention should not be construed as limiting the scope of the present invention. Any other corresponding changes and modifications made according to the technical idea of the present invention should be included in the protection scope of the claims of the present invention.

Claims (10)

1. A method for creating a derived index, comprising:
responding to a derivative index creating instruction sent by a client, and displaying an index creating interface, wherein the index creating interface displays an index calculation logic configuration area, an index basic information setting area and a plurality of visual program controls;
responding to an index configuration operation acted on the index creation interface, and determining the configuration of the derived index, wherein the index configuration operation at least comprises a logic operation setting operation of a visual program control selected in the index calculation logic configuration area and a basic information setting operation performed in the index basic information setting area;
and in response to a saving operation acting on the index creation interface, saving the configuration of the derived index to generate a derived index.
2. The method for creating the derived index according to claim 1, wherein the logical operation setting operation includes a selecting operation and a dragging operation, and the determining the configuration of the derived index in response to the index configuration operation acting on the index creation interface includes:
displaying a visual program control selected by a user in the index calculation logic configuration area based on a selection operation acted on the index creation interface;
combining the selected visual program controls based on a dragging operation acting on an index creation interface to realize logic operation configuration of derived indexes;
and configuring the basic information of the derived index based on a basic information setting operation acting on the index basic information setting area.
3. A derived metric creation method as recited in claim 2, wherein the visualization program controls include at least an atomic metric type visualization program control, a function type visualization program control, and an operator type visualization program control.
4. A derived index creation method according to claim 3, wherein said presenting a user-selected visual program control in said index calculation logic configuration area based on a selection operation acting on an index creation interface comprises:
selecting a plurality of atom index type visualization program controls based on selection operation acting on an index creation interface, and then displaying the atom index type visualization program controls in the index calculation logic configuration area; and
selecting a plurality of function type visualization program controls to perform parameter configuration on the selected function type visualization program controls based on selection operation acting on an index creation interface, and displaying the function type visualization program controls in the index calculation logic configuration area; and/or
And based on the selection operation acted on the index creation interface, selecting a plurality of operator type visual program controls and then displaying the operator type visual program controls in the index calculation logic configuration area.
5. A derived metric creation method as described in claim 1 wherein said saving the configuration of the derived metric to generate a derived metric in response to a save operation acting on the metric creation interface comprises:
responding to a saving operation acted on the index creating interface, and verifying the configuration of the derived index;
and when the configuration verification of the derived indexes passes, storing the configuration of the derived indexes to generate the derived indexes, otherwise, generating configuration failure information and displaying the configuration failure information on the index creation interface.
6. The method for creating a derived metric according to claim 5, wherein the verifying the configuration of the derived metric in response to the save operation acting on the metric creation interface comprises:
and in response to a saving operation acting on the index creation interface, verifying the configuration of the derived index by adopting a preset index verification control, wherein the index verification control is configured with an index verification rule, and the index verification rule is used for performing logical operation verification on the configuration of the derived index.
7. The method for creating a derived index according to claim 1, wherein after saving the configuration of the derived index in response to a saving operation performed on the index creation interface to generate a derived index, the method further comprises:
and generating index information corresponding to the derived indexes according to the metadata corresponding to the derived indexes.
8. A derived index creation apparatus, comprising:
the interface display module is used for responding to a derivative index creation instruction sent by a client and displaying an index creation interface, wherein the index creation interface displays an index calculation logic configuration area, an index basic information setting area and a plurality of visual program controls;
the index configuration module is used for responding to index configuration operation acted on the index creation interface and determining the configuration of the derived index, wherein the index configuration operation at least comprises the logical operation setting operation of a visual program control selected in the index calculation logical configuration area and the basic information setting operation performed in the index basic information setting area;
and the index generation module is used for responding to the saving operation acted on the index creation interface and saving the configuration of the derived index so as to generate the derived index.
9. An electronic device, comprising: a processor and a memory;
the memory having stored thereon a computer program executable by the processor;
the processor, when executing the computer program, implements the steps in the derived index creation method according to any of claims 1-7.
10. A computer-readable storage medium storing one or more programs, the one or more programs being executable by one or more processors to implement the steps in the derivative index creation method according to any one of claims 1 to 7.
CN202210753919.2A 2022-06-28 2022-06-28 Method and device for creating derived indexes, electronic equipment and storage medium Pending CN115113862A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210753919.2A CN115113862A (en) 2022-06-28 2022-06-28 Method and device for creating derived indexes, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210753919.2A CN115113862A (en) 2022-06-28 2022-06-28 Method and device for creating derived indexes, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN115113862A true CN115113862A (en) 2022-09-27

Family

ID=83330989

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210753919.2A Pending CN115113862A (en) 2022-06-28 2022-06-28 Method and device for creating derived indexes, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN115113862A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116777297A (en) * 2023-07-10 2023-09-19 三峡科技有限责任公司 Machine room evaluation index configuration method and system based on IDC equipment monitoring data

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116777297A (en) * 2023-07-10 2023-09-19 三峡科技有限责任公司 Machine room evaluation index configuration method and system based on IDC equipment monitoring data
CN116777297B (en) * 2023-07-10 2024-03-05 三峡科技有限责任公司 Machine room evaluation index configuration method and system based on IDC equipment monitoring data

Similar Documents

Publication Publication Date Title
WO2019109485A1 (en) Echarts tool-based chart making method, apparatus and device, and medium
CN109144997A (en) Data correlation method, device and storage medium
CN111241444A (en) Webpage embedded point code adding method and device, computer equipment and storage medium
WO2019019702A1 (en) Algorithm generation method and device, terminal device and storage medium
CN106503224A (en) A kind of method and device for recommending application according to keyword
CN111309991B (en) Query statement generation method and device and data query method and system
CN108875048B (en) Report generation method and device, electronic equipment and readable storage medium
CN115113862A (en) Method and device for creating derived indexes, electronic equipment and storage medium
CN114416891B (en) Method, system, apparatus and medium for data processing in a knowledge graph
CN110543450A (en) Electronic document generation method and device, computer equipment and storage medium
US11341197B2 (en) Recommendation system based on adjustable virtual indicium
US8984455B1 (en) Methods for generating schematic diagrams and apparatuses using the same
CN113377608A (en) Method and device for alarming task abnormity, terminal equipment and storage medium
CN111814029A (en) Data query method, system and computing device
CN113157779A (en) Data chart generation method and device
CN111126012B (en) Custom generation expression method and device
CN114995728A (en) Rule configuration method and device, electronic equipment and storage medium
CN109766093B (en) Method and device for collaborative real-time editing, electronic equipment and storage medium
US20070156775A1 (en) Metadata transformation in copy and paste scenarios between heterogeneous applications
CN113971074A (en) Transaction processing method and device, electronic equipment and computer readable storage medium
CN109871214B (en) Program code generation method, program code generation device, computer device, and storage medium
CN113535650A (en) File naming method and computing device
CN112667141A (en) Input revocation method, device, electronic equipment and computer-readable storage medium
CN112257403A (en) PDF report generation method and device
CN116225288A (en) Data processing method, device and equipment

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