Dynamic index system construction method and device, electronic equipment and storage medium

Abstract

The invention provides a dynamic index system construction method and device, electronic equipment and a storage medium, and relates to the technical field of digital management, the method comprises the following steps: obtaining basic data used for constructing an index system, the basic data at least comprising main data, dimension data and measurement data; catalog information is configured, and the main data, the dimension data and the measurement data are associated through the catalog information; generating a system menu according to the directory information, and defining metadata attributes of the system menu by creating a physical table; and filling basic data into a system menu according to the directory information, and calculating index data to obtain an index system. According to the method, index systems of different users are dynamically constructed based on the basic data, repeated development and customization work are avoided, the operation and maintenance difficulty and cost are reduced, the SaaS system achieves the effects of dimensionality configurability, parameter dynamic adjustment and index traceability, and the method has the advantages of being high in universality and configurability.

Description

Technical Field

[0001] The present invention relates to the field of digital management technology, and in particular to a method, device, electronic equipment and storage medium for constructing a dynamic indicator system. Background Art

[0002] Software as a Service (SaaS) systems have become a common way for enterprises to deploy and use software. The company's SaaS system is committed to serving different customers. Through physical isolation, database isolation, function permission configuration, data permission configuration and other means, it ensures that each company can enjoy the SaaS system services while also ensuring the independence of the company. However, with the continuous increase in the number of companies, customers have put forward diversified requirements for SaaS systems based on their own development perspectives, especially in terms of parameters and indicator systems.

[0003] The existing SaaS system adopts inheritance mode, where company-level code inherits product-level functions, and creates a unique processing strategy for each company, achieving logical independence between companies and ensuring that later changes do not affect each other. However, due to the different operating strategies of each company, the indicator system varies greatly, and a large number of personalized indicator requirements have led to a sharp increase in development volume, resulting in a large amount of company-level code, which wastes resources and seriously affects the subsequent expansion of the system. Therefore, it is urgent to solve the problem of poor scalability and adaptability of SaaS systems. Summary of the invention

[0004] In view of the above-mentioned deficiencies in the prior art, the present invention provides a method, device, electronic device and storage medium for constructing a dynamic indicator system, which effectively solve the problems of poor scalability and adaptability of the existing SaaS system.

[0005] In a first aspect, the present invention provides a method for constructing a dynamic indicator system, the method comprising:

[0006] Acquire basic data for building an indicator system, wherein the basic data includes at least master data, dimension data, and measurement data;

[0007] configuring catalog information, and respectively associating the master data, the dimension data, and the metric data through the catalog information;

[0008] Generate a system menu according to the directory information, and define metadata attributes of the system menu by creating a physical table;

[0009] The basic data is filled into the system menu according to the catalog information, and the index data is calculated to obtain an index system.

[0010] In an alternative embodiment, the master data is used to define the source of the basic information of the metric system, the dimension data is used to define the analysis perspectives of the metric system, and the measure data is used to define the statistical metrics and logic of the metric system.

[0011] In an alternative embodiment, the configuration directory information associates the master data, the dimension data, and the measure data respectively through the directory information, including:

[0012] Define the basic information of the directory, and configure the target statistical dimensions and target calculation metrics of the metric system to obtain the directory information;

[0013] Select the master data for association according to the directory information to obtain a master data set;

[0014] Associate the target statistical dimensions with the dimension data to obtain a dimension set;

[0015] Associate the target calculation metrics with the measure data to obtain a measure set.

[0016] In an alternative embodiment, generating a system menu according to the directory information and defining the metadata attributes of the system menu by creating physical tables includes:

[0017] Generate the system menu according to the directory information in combination with the parent-child structure relationship;

[0018] Create a physical table according to the basic information in the directory information;

[0019] Create a dimension data table and a measure data table respectively according to the target statistical dimensions and the target calculation metrics in the directory information;

[0020] Define the metadata attributes of the system menu according to the physical table, the dimension data table, and the measure data table.

[0021] In an alternative embodiment, populating the basic data into the system menu according to the directory information and calculating the metric data to obtain a metric system includes:

[0022] Automatically populate the dimension data and the measure data into the system menu according to the directory information to obtain a target data set;

[0023] Calculate the metric data according to the target data set and the directory information to obtain the metric system.

[0024] In an alternative embodiment, automatically populating the dimension data and the measure data into the system menu according to the directory information to obtain a target data set includes:

[0025] Determine a data source according to the master data set;

[0026] Filter the data source according to the dimension set;

[0027] Query the data source according to the target attributes of the dimension set and the metric set to obtain the target data set.

[0028] In an optional embodiment, the calculating the index data according to the target data set and the catalog information to obtain the index system includes:

[0029] Query metric formula data according to the master data set to obtain a metric formula data set;

[0030] Traverse the metric formula data set and calculate the index data according to the target data set;

[0031] Store the index data in a data table to obtain the index system.

[0032] In a second aspect, the present invention provides a dynamic index system construction device, and the device includes:

[0033] A data acquisition module, configured to acquire basic data for constructing an index system, where the basic data at least includes master data, dimension data, and metric data;

[0034] A catalog maintenance module, configured to configure catalog information, and respectively associate the master data, the dimension data, and the metric data through the catalog information;

[0035] A catalog generation module, configured to generate a system menu according to the catalog information, and define metadata attributes by creating a physical table;

[0036] A system construction module, configured to populate the system menu with the basic data according to the catalog information, and calculate index data to obtain an index system.

[0037] In a third aspect, the present invention provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor executes the computer program to implement the dynamic index system construction method according to any one of the first aspects of the present invention.

[0038] In a fourth aspect, the present invention provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the dynamic index system construction method according to any one of the first aspects of the present invention is implemented.

[0039] The method, device, electronic device and storage medium for constructing a dynamic indicator system provided by the present invention dynamically construct indicator systems for different users based on basic data. Guided by user needs, through interface configuration means, each indicator can be implemented through configuration, greatly improving the user's independent configuration ability, enabling each user to independently configure their respective parameters and indicator systems based on the new capabilities of the product. Through the method of replacing development with configuration, the construction of indicator systems for different users is realized, avoiding repeated development and customization work, thereby reducing the operation and maintenance difficulty and cost. Users can intuitively view information such as the source and calculation formula of indicators on the interface, achieving the effects of configurable dimensions, dynamically adjustable parameters and traceable indicators, significantly improving the adaptive ability of the system, and having the advantages of strong universality and strong configurability, and can be widely applied to different industries and scenarios to meet the personalized needs of users. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings required for use in the embodiments will be briefly introduced below. It should be understood that the following drawings only show some embodiments of the present invention, and thus should not be regarded as limiting the scope. For those of ordinary skill in the art, without creative efforts, other related drawings can also be obtained based on these drawings.

[0041] Figure 1 It is the first schematic diagram of the process of the method for constructing a dynamic indicator system provided by an embodiment of the present invention;

[0042] Figure 2 It is the second schematic diagram of the process of the method for constructing a dynamic indicator system provided by an embodiment of the present invention;

[0043] Figure 3 It is the third schematic diagram of the process of the method for constructing a dynamic indicator system provided by an embodiment of the present invention;

[0044] Figure 4 It is the fourth schematic diagram of the process of the method for constructing a dynamic indicator system provided by an embodiment of the present invention;

[0045] Figure 5 It is the fifth schematic diagram of the process of the method for constructing a dynamic indicator system provided by an embodiment of the present invention;

[0046] Figure 6 It is the sixth schematic diagram of the process of the method for constructing a dynamic indicator system provided by an embodiment of the present invention;

[0047] Figure 7 It is the schematic diagram of the structure of the device for constructing a dynamic indicator system provided by an embodiment of the present invention;

[0048] Figure 8 It is the schematic diagram of the structure of an electronic device provided by an embodiment of the present invention.

[0049] Description of main component symbols:

[0050] 700, dynamic indicator system construction device; 710, data acquisition module; 720, directory maintenance module; 730, directory generation module; 740, system construction module; 800, electronic device; 810, processor; 820, communication interface; 830, memory; 840, communication bus. DETAILED DESCRIPTION

[0051] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be further clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. It should be noted that the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.

[0052] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include one or more of the features. In the description of the present invention, the meaning of "plurality" is two or more, unless otherwise clearly and specifically defined.

[0053] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which this application belongs. The terms used in this specification are only for the purpose of describing specific embodiments and are not intended to limit the present invention. The term "and / or" used herein includes any and all combinations of one or more of the related listed items.

[0054] The SaaS system defines product-level business process specifications, but each company has its own personalized parts, so in addition to product-level codes, a company-level code library is also defined for company-level business needs to meet user needs to the greatest extent. According to long-term operating results, the most different needs of each company are in basic data, parameters and indicators.

[0055] In the existing system, the company-level code inherits the product-level functions through inheritance to implement different business needs. Each company has a set of processing strategies to achieve logical independence between the companies, and the subsequent changes do not affect each other. The personalized indicator system of each company is implemented through a custom development model, and a separate team will perform secondary iterations and maintenance in the later stage. However, due to the different operating strategies of the companies, the indicator systems vary greatly, and the large number of personalized indicator requirements have led to a sharp increase in the amount of development, resulting in a large amount of company-level code, which not only wastes resources, but also seriously affects the subsequent expansion of the system.

[0056] Example 1

[0057] The embodiment of the present invention provides a method for constructing a dynamic indicator system, which effectively solves the problems of poor scalability and adaptability of the existing SaaS system. Figure 1 is a first schematic diagram of the process of the method for constructing a dynamic indicator system provided by an embodiment of the present invention, such as Figure 1 As shown, the method comprises the following steps:

[0058] S100. Obtain basic data for building an indicator system, where the basic data includes at least master data, dimension data, and measurement data.

[0059] In the embodiment of the present invention, taking the SaaS system related to the battery business as an example, the indicator systems of different settled companies are different, and there are many possible combinations of basic data. Therefore, when the SaaS system settles in a new company, it is necessary to obtain the basic data for building the indicator system, which includes at least master data, dimension data and measurement data.

[0060] The master data is used to define the basic information source of the indicator system, which can be entered through the interface input method and stored in the relational database. The main attribute is the name. In the embodiment of the present invention, the master data includes but is not limited to calendar, location, battery, consumer and order data.

[0061] Dimension data is used to define the analysis angle of the indicator system. It can also be entered through the interface and stored in a relational database. It also supports dynamic expansion. The main attributes of dimensional data include name, master data, data source and filter conditions, where name is required and unique, master data is required and single-choice, data source is required and defined through table fields, and filter conditions are optional. Dimension data is filtered through expressions, for example, by defining the expression "order payment status = unpaid" to filter unpaid orders. In an embodiment of the present invention, dimensional data includes but is not limited to city, month, battery type, battery model, battery capacity, battery status, consumer age group, order status and other data.

[0062] Measurement data is used to define the statistical indicators and logics of the indicator system. It can be entered through the interface and stored in a relational database, defining the indicators that the settled companies need to count, personalized context parameters, and specific external data fetching logics. The same indicator may have different calibers, so it is necessary to define the calculation logic of the measurement separately, support online editing and dynamic expansion, and take effect in real time. The main attributes of measurement data include name, classification, value type, value length, value taking method, value taking formula, and value taking script. Among them, the name is a required and unique item, the classification is a required item, such as dimension data and indicator data, the value type is an optional item, such as integer type, floating-point type, date type, and string type. The value length is an optional item, and the default value can be set. The value taking method is a required item, such as including methods like entry, calculation formula, and script. The value taking formula and value taking script are optional items. For example, when the value taking method is the calculation formula method, it needs to be filled in and presented in the form of an expression, such as sum(order.payment amount).

[0063] S200. Configure the directory information, and respectively associate the master data, dimension data, and measurement data through the directory information.

[0064] After obtaining the master data, dimension data, and measurement data, it is necessary to dynamically assemble the indicator systems of different dimensions and different perspectives through directory maintenance, and define the dimensions to be counted and the indicators to be calculated for each directory menu. Figure 2 It is the second schematic diagram of the dynamic indicator system construction method process provided by the embodiment of the present invention, as Figure 2 shown. The directory maintenance specifically includes the following steps:

[0065] S210. Define the basic information of the directory, and configure the target statistical dimension and target calculation indicator of the indicator system to obtain the directory information.

[0066] In the embodiment of the present invention, the basic information of the directory is entered through the interface and stored in a relational database. The main attributes of the basic information of the directory include name, parent directory, icon, whether it is default collapsed, and database table name. Among them, the name, parent directory, and database table name are required and unique items, the icon is an optional item, and whether it is default collapsed is defaulted to yes.

[0067] At the same time, it is necessary to configure the target statistical dimensions and target calculation indicators of the indicator system. The target statistical dimensions define the specific dimensions of the statistics, such as "Calendar.Month", "Order.Amount", "Customer.Province", etc. Filter conditions can be set for each dimension, such as "Month = {Current Month}", "Status = {Paid}", etc. These conditions are used to filter data that meet specific requirements, so as to achieve precise control of the statistical dimensions. The target calculation indicators define the specific indicators of the statistics, such as "Paid Amount", "Payment Ratio", "Event Quantity", "Event Ratio", etc. These indicators are calculated through formulas, such as "sum(Order.Amount)", "Paid Amount / sum(Paid Amount)", etc. The formulas can be calculated based on the fields in the dimension set, so as to achieve quantitative analysis of the statistical results.

[0068] S220. Select master data for association according to the catalog information to obtain a set of master data.

[0069] In the embodiment of the present invention, master data is entered in the way of multiple selections through the interface, and sub-table data is generated in an n-to-n manner and stored in a relational database, thereby defining which master data is used in the catalog. Subsequent dimension data and metric data need to be filtered according to the selected master data. If none is selected, the default is not to filter.

[0070] S230. Associate the target statistical dimensions with the dimension data to obtain a dimension set.

[0071] In the embodiment of the present invention, dimension data is entered in the way of multiple selections through the interface, and sub-table data is generated in an n-to-n manner, thereby defining the dimensions that need to be statistically analyzed subsequently. The data source is the dimension data defined previously, and the filtering condition is the associated master data. At least one must be selected and cannot be empty.

[0072] S240. Associate the target calculation indicators with the metric data to obtain a metric set.

[0073] In the embodiment of the present invention, it is entered in the way of multiple selections through the interface, and sub-table data is generated in an n-to-n manner, thereby defining the indicators that need to be statistically analyzed subsequently. The data source is the metric data defined previously, and the filtering condition is also the associated master data. At least one must be selected and cannot be empty.

[0074] S300. Generate a system menu according to the catalog information, and define the metadata attributes of the system menu by creating a physical table.

[0075] In an embodiment of the present invention, a system menu is automatically generated according to directory information, and operations such as creating and changing the physical table structure and generating metadata of the system menu are sequentially executed, so as to generate functions such as interface query, data export, and data refresh. The triggering timing can be selected after saving the directory information configuration, or can be triggered by manually clicking a button. Figure 3 It is the third schematic diagram of the method flow for constructing a dynamic index system provided by an embodiment of the present invention. As Figure 3 shown, the directory generation module specifically includes the following steps:

[0076] S310. Generate a system menu according to the directory information in combination with the parent-child structure relationship.

[0077] In an embodiment of the present invention, the system menu corresponds to the directory one by one and maintains the same parent-child structure relationship as the directory. The primary key in the data of the system menu is equal to the primary key of the source directory. When generating the system menu, first query whether there is corresponding data in the menu list according to the directory id. If there is directory data, perform a modification operation. The menu name is globally unique. If there is no directory data, perform an addition operation. The newly added system menu is by default only visible to the administrator and the creator. The main attributes of the system menu include the primary key, name, parent id, icon, and standard template path. Among them, the primary key is derived from the directory primary key, the name is derived from the directory name, the parent id is derived from the directory pid, and the icon is derived from the directory icon. The standard template path embeds the database table name as a dynamic parameter into the URL. For example, tableName = database table, where the database table is derived from the directory database table name.

[0078] S320. Create a physical table according to the basic information in the directory information.

[0079] In an embodiment of the present invention, first query in the database whether there is an existing physical table according to the database table name in the directory information. If not, create a physical table. The default attributes of the physical table include the primary key, creation time, creator, last modification time, modifier, status, and remarks. If there is already an existing physical table, the physical table creation ends, and the addition operation is recorded in the log system.

[0080] S330. Create a dimension data table and a metric data table respectively according to the target statistical dimension and the target calculation index in the directory information.

[0081] In the embodiment of the present invention, traverse the target statistical dimensions in the directory information, and determine whether the dimension data already exists in the data table according to the dimension name. If the dimension data does not exist in the data table, create the same fields according to the data source and name of the dimension data table configured with the dimension data. If the dimension data exists in the data table, determine whether there are changes in the comparison of the field type, field length, and directory information. If there are changes, perform DDL changes; if there are no changes, no operation is performed. The strategy for the extra fields in the dimension data table can be to delete them to ensure that the definition of the dimension data table is consistent with the directory information, and the new operations are recorded in the log system.

[0082] Traverse the target calculation metrics in the directory information, and determine whether the measurement data already exists in the data table according to the metric name. If the measurement data does not exist in the data table, create fields according to the field name, field type, and field length of the measurement data table configured with the measurement data. If the measurement data exists in the data table, determine whether there are changes in the comparison of the field type, field length, and directory information. If there are changes, perform DDL changes; if there are no changes, no operation is performed. The strategy for the extra fields in the measurement data table can be to delete them to ensure that the definition of the measurement data table is consistent with the directory information, and the new operations are recorded in the log system.

[0083] S340. Define the metadata attributes of the system menu according to the physical table, dimension data table, and measurement data table.

[0084] In the embodiment of the present invention, the metadata defines the system menu name and interface content displayed to the client, and the interface content includes, but is not limited to, query forms, query conditions, table attributes, and interface button functions, etc. Create corresponding metadata according to the physical table, dimension data table, and measurement data table to form a metadata table. Add or change the metadata table definition in the corresponding metadata table. The multiple field attributes of each metadata table definition correspond one by one to the attributes in the physical table, dimension data table, and measurement data table, and are stored in the database.

[0085] Optionally, the business unique key of the metadata table is the meta-attribute name formed by the ID of the metadata table + the field attribute name. The meta-attribute name is converted according to the small camel case rule from the database field name, and the meta-attribute type is defined according to the database field type. For example, varchar and text correspond to the String type, numeric types correspond to the Long type and the Double type, the date type corresponds to the Date type, etc. After the metadata table is changed, the field attributes in the metadata are created or changed according to the fields in the metadata table. The interface content defaults to configure the query, export, and refresh data button functions of the metadata table. The query conditions are default to the attribute fields corresponding to the dimension data. The list display interface defaults to include attributes such as the primary key, dimension attributes, metric attributes, new person, new time, modifier, modification time, status, and remarks.

[0086] S400. Populate the system menu with basic data according to the catalog information, and calculate the metric data to obtain the metric system.

[0087] In the embodiments of the present invention, after defining metadata attributes such as interface elements and functions, it is necessary to populate the system menu with basic data according to the catalog information, and at the same time calculate the metric data to obtain the metric system. Figure 4 It is the fourth schematic diagram of the dynamic metric system construction method flow provided by the embodiments of the present invention. As Figure 4 shown, the system construction specifically includes the following steps:

[0088] S410. Automatically populate the dimension data and metric data into the system menu according to the catalog information to obtain the target data set.

[0089] Figure 5 It is the fifth schematic diagram of the dynamic metric system construction method flow provided by the embodiments of the present invention. As Figure 5 shown, the data population specifically includes the following steps:

[0090] S411. Determine the data source according to the master data set.

[0091] The first record in the master data set is the master table 1, which is also the main source of the metric data. The subsequent master data records are associated with the master table 1 through a foreign key. The association method is as follows: First, determine whether there is a field master table 2_id in the master table 1. If it exists, execute the concatenated sql: master table 1.master table 2_id = master table 2.id. If it does not exist, no concatenated association is performed.

[0092] S412. Filter the data source according to the dimension set.

[0093] In the embodiment of the present invention, data can be filtered according to the dimension set in the catalog information. When splicing SQL, the filtering conditions in the dimension data can be added. For example, sql.append('main table 1.level >= 3').

[0094] S413. Query the data source according to the target attributes of the dimension set and the metric set to obtain the target data set.

[0095] In the embodiment of the present invention, all the target attributes involved in the dimension set and the metric set in the catalog information are used to define the data columns to be queried, such as calendar.month, battery.model, event.level, and event.province, etc. Finally, the SQL for querying data is assembled, and the target data set is obtained by executing the SQL.

[0096] S420. Calculate the index data according to the target data set and the catalog information to obtain the index system.

[0097] Figure 6 This is the sixth schematic diagram of the dynamic index system construction method flow provided by the embodiment of the present invention. As Figure 6 shown, the calculation of the index data specifically includes the following steps:

[0098] S421. Query the metric formula data according to the master data set to obtain the metric formula data set.

[0099] Obtain the master data set according to the catalog information, and query the metric formula data set and the metric attributes according to the master data set.

[0100] S422. Traverse the metric formula data set and calculate the index data according to the target data set.

[0101] In the embodiment of the present invention, traverse the metric formula data set and calculate different index data according to the target data set. For example, the sum formula groups according to the dimension data and uses the metric attribute to sum to obtain the index data; the avg formula groups according to the dimension data and uses the metric attribute to calculate the average value to obtain the index data; the max formula groups according to the dimension data and uses the metric attribute to take the maximum value to obtain the index data; the min formula groups according to the dimension data and uses the metric attribute to take the minimum value to obtain the index data; for complex expressions, replace the descriptions in the formula with values and call the executor to calculate the index data; for scripts, interface methods, or other custom formulas, pass the target data set into the corresponding rule engine to calculate the index data.

[0102] S423. Store the index data in the data table to obtain the index system.

[0103] In an embodiment of the present invention, the calculated index data is stored in a data table to obtain an index system, which supports adding or modifying the data table, and the unique key is the dimension combination. The main attributes of the index system include primary key, dimension 1, dimension 2, …, dimension n, measure 1, measure 2, …, measure n, new person, new time, modifying person, modifying time, and status, etc.

[0104] The dynamic index system construction method provided by the embodiment of the present invention dynamically constructs the index systems of different users based on basic data. Oriented by user requirements, through interface configuration means, each index can be realized through configuration, greatly improving the user's independent configuration ability, enabling each user to independently configure their respective parameters and index systems based on the new capabilities of the product. Through the method of replacing development with configuration, the construction of index systems for different users is realized, avoiding repeated development and customization work, thereby reducing the operation and maintenance difficulty and cost.

[0105] Embodiment 2

[0106] Based on the same technical concept as in Method Embodiment 1 above, an embodiment of the present invention provides a dynamic index system construction device. Figure 7 It is a schematic structural diagram of the dynamic index system construction device provided by the embodiment of the present invention. As Figure 7 shown, the dynamic index system construction device 700 includes:

[0107] A data acquisition module 710, configured to acquire basic data for constructing an index system, where the basic data includes at least master data, dimension data, and measure data.

[0108] A directory maintenance module 720, configured to configure directory information, and respectively associate the master data, dimension data, and measure data through the directory information.

[0109] A directory generation module 730, configured to generate a system menu according to the directory information, and define metadata attributes by creating a physical table.

[0110] A system construction module 740, configured to populate the system menu with basic data according to the directory information, calculate index data, and obtain an index system.

[0111] For the dynamic index system construction device provided by the embodiment of the present invention, users can intuitively view information such as the source and calculation formula of the index on the interface, achieving the effects of configurable dimensions, dynamically adjustable parameters, and traceable indexes, significantly improving the adaptive ability of the system, having the advantages of strong universality and strong configurability, and being able to be widely applied to different industries and scenarios to meet the personalized needs of users.

[0112] It can be understood that the implementation manners in the method for constructing the dynamic index system described in the above Embodiment 1 are equally applicable to this embodiment and can achieve the same technical effects, so they will not be described repeatedly here.

[0113] Embodiment 3

[0114] Based on the same concept, an embodiment of the present invention further provides an electronic device. Figure 8 FIG. is a schematic structural diagram of an electronic device provided by an embodiment of the present invention. As Figure 8 shown, the electronic device 800 may include: a processor 810, a communication interface 820, a memory 830, and a communication bus 840. Among them, the processor 810, the communication interface 820, and the memory 830 complete mutual communication through the communication bus 840. The processor 810 may call logical instructions in the memory 830 to execute the steps of the method for constructing the dynamic index system described in the above embodiments. For example, it includes:

[0115] S100. Obtain the basic data for constructing the index system, where the basic data at least includes master data, dimension data, and metric data;

[0116] S200. Configure directory information, and associate the master data, dimension data, and metric data through the directory information respectively;

[0117] S300. Generate a system menu according to the directory information, and define the metadata attributes of the system menu by creating a physical table;

[0118] S400. Populate the basic data into the system menu according to the directory information, and calculate the index data to obtain the index system.

[0119] Among them, the processor 810 may be a central processing unit (CPU). The processor may also be other general-purpose processors, digital signal processors (DSPs), application specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. chips, or a combination of the above types of chips.

[0120] In addition, when the logical instructions in the above-mentioned memory 830 are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or a part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in various embodiments of the present invention. The foregoing storage medium includes: various media such as USB flash drives, mobile hard disks, read-only memories (ROMs), random access memories (RAMs), magnetic disks, or optical discs that can store program codes.

[0121] The memory 830 may include a program storage area and a data storage area. Among them, the program storage area can store an operating system and application programs required for at least one function; the data storage area can store data created by the processor, etc. In addition, the memory may include high-speed random access memory and may also include non-transitory memory, such as at least one magnetic disk storage device, a flash memory device, or other non-transitory solid-state storage devices. In some embodiments, the memory may optionally include a memory remotely set relative to the processor, and these remote memories can be connected to the processor through a network. Examples of the above-mentioned network include but are not limited to the Internet, enterprise intranets, local area networks, mobile communication networks, and combinations thereof.

[0122] Embodiment 4

[0123] Based on the same concept, an embodiment of the present invention further provides a computer-readable storage medium. The computer-readable storage medium stores a computer program, and the computer program includes at least one segment of code. The at least one segment of code can be executed by a main control device to control the main control device to implement the steps of the method for constructing a dynamic index system as described in the above-mentioned various embodiments. For example, it includes:

[0124] S100. Obtain the basic data for constructing the index system. The basic data includes at least master data, dimension data, and metric data;

[0125] S200. Configure directory information and associate the master data, dimension data, and metric data respectively through the directory information;

[0126] S300. Generate a system menu according to the directory information and define the metadata attributes of the system menu by creating a physical table;

[0127] S400. Populate the basic data into the system menu according to the directory information and calculate the index data to obtain the index system.

[0128] Based on the same inventive concept, an embodiment of the present invention further provides a computer program, which, when executed by a master device, is used to implement the above method embodiment.

[0129] The computer program may be stored in whole or in part on a computer-readable storage medium packaged together with the processor, or may be stored in whole or in part on a memory not packaged together with the processor.

[0130] Based on the same inventive concept, an embodiment of the present invention further provides a processor, which is used to implement the above method embodiment. The above processor may be a chip.

[0131] In summary, the method, device, electronic device, and storage medium for constructing a dynamic index system provided by the present invention dynamically construct index systems for different users based on basic data, are oriented to user needs, and through interface configuration means, allow each index to be implemented through configuration, greatly improving the user's independent configuration ability, enabling each user to independently configure their respective parameters and index systems based on the new capabilities of the product. By replacing development with configuration, the construction of index systems for different users is achieved, avoiding repetitive development and customization work, thereby reducing the operation and maintenance difficulty and cost. Users can intuitively view information such as the source and calculation formula of the index on the interface, achieving the effects of configurable dimensions, dynamically adjustable parameters, and traceable indexes, significantly improving the adaptive ability of the system, and having the advantages of strong universality and strong configurability, and can be widely applied to different industries and scenarios to meet the personalized needs of users.

[0132] Referring to "embodiment" in this text means that the specific features, structures, or characteristics described in connection with the embodiment may be included in at least one embodiment of the present application. The phrase appears in various positions in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment mutually exclusive with other embodiments. Those skilled in the art explicitly and implicitly understand that the embodiments described herein may be combined with other embodiments.

[0133] The above-described embodiments merely represent several implementation manners of the present invention, and the description thereof is relatively specific and detailed, but should not be construed as a limitation on the scope of the patent of the present invention. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present invention, several modifications and improvements can still be made, and these all belong to the protection scope of the present invention. Therefore, the protection scope of the patent of the present invention should be subject to the appended claims.

[0134] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements on some of the technical features; and these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for constructing a dynamic index system, characterized in that, The method includes: Obtaining basic data for constructing an index system, where the basic data includes at least master data, dimension data, and metric data; Configuring directory information, and respectively associating the master data, the dimension data, and the metric data through the directory information; Generating a system menu according to the directory information, and defining metadata attributes of the system menu by creating a physical table; Populating the system menu with the basic data according to the directory information, and calculating index data to obtain an index system.

2. The method for constructing a dynamic index system according to claim 1, wherein The master data is used to define the source of basic information of the index system, the dimension data is used to define the analysis angle of the index system, and the metric data is used to define the statistical indicators and logic of the index system.

3. The method for constructing a dynamic index system according to claim 2, wherein, The configuring directory information, and respectively associating the master data, the dimension data, and the metric data through the directory information, includes: Defining basic information of the directory, and configuring the target statistical dimension and target calculation indicators of the index system to obtain the directory information; Selecting the master data for association according to the directory information to obtain a master data set; Associating with the dimension data according to the target statistical dimension to obtain a dimension set; Associating with the metric data according to the target calculation indicator to obtain a metric set.

4. The method for constructing a dynamic index system according to claim 3, wherein The generating a system menu according to the directory information, and defining metadata attributes of the system menu by creating a physical table, includes: Generating the system menu according to the directory information in combination with the parent-child structure relationship; Creating a physical table according to the basic information in the directory information; Respectively creating a dimension data table and a metric data table according to the target statistical dimension and the target calculation indicator in the directory information; Defining metadata attributes of the system menu according to the physical table, the dimension data table, and the metric data table.

5. The method for constructing a dynamic index system according to claim 4, wherein The populating the system menu with the basic data according to the directory information, and calculating index data to obtain an index system, includes: Automatically populating the dimension data and the metric data into the system menu according to the directory information to obtain a target data set; Calculating the index data according to the target data set and the directory information to obtain the index system.

6. The method for constructing a dynamic index system according to claim 5, wherein The automatically populating the dimension data and the metric data into the system menu according to the directory information to obtain a target data set, includes: Determining a data source according to the master data set; Filtering the data source according to the dimension set; Querying the data source according to the target attributes of the dimension set and the metric set to obtain the target data set.

7. The method for constructing a dynamic index system according to claim 5, characterized in that The calculating the index data according to the target data set and the directory information to obtain the index system, includes: Querying metric formula data according to the master data set to obtain a metric formula data set; Traversing the metric formula data set, and calculating the index data according to the target data set; Storing the index data into a data table to obtain the index system.

8. A device for constructing a dynamic index system, characterized in that, The device includes: A data acquisition module, configured to acquire basic data for constructing an index system, where the basic data at least includes master data, dimension data, and metric data; A directory maintenance module, configured to configure directory information, and respectively associate the master data, the dimension data, and the metric data through the directory information; A directory generation module, configured to generate a system menu according to the directory information, and define metadata attributes by creating physical tables; A system construction module, configured to populate the system menu with the basic data according to the directory information, calculate index data, and obtain an index system.

9. An electronic device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, The processor executes the computer program to implement the dynamic index system construction method according to any one of claims 1 to 7.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the dynamic index system construction method according to any one of claims 1 to 7.

Images