Database-based index configuration method

Abstract

The invention provides an index configuration method based on a database, belongs to the field of computer data analysis, and selects different generation modes to generate indexes based on databases which are connected in a system. Firstly, a library table mode is adopted, a basic data table is selected, connection is established according to requirements, and a user can flexibly select required statistical dimensions and statistical modes, so that corresponding indexes are generated. Secondly, a user can compile corresponding SQL statements according to needs, and directly select dimensions and statistical modes which need to be counted; finally, the invention further provides a calculation formula library established in the system, a user can select a proper formula according to specific requirements, and corresponding dimension indexes are appointed for parameters of the formula. The method not only improves the efficiency of index generation, but also ensures the consistency and accuracy of calculation.

Description

Technical Field

[0001] The present invention relates to the field of computer data analysis, and in particular to an indicator configuration method based on a database. Background Art

[0002] Provide a platform and support capabilities for the configuration of the city operation status monitoring model and the smart thematic spatiotemporal display, quickly build a city operation status indicator model, and display the city operation monitoring information in real time. Timely and comprehensive city operation status. Through information-based big data means, multi-dimensional analysis and display of city indicators and event data are carried out, integrating core business data, key indicators and other data from various departments, to achieve all-round, multi-angle, and three-dimensional monitoring and display integration of the city, and assist leaders, technicians, executives and other personnel in various positions to intuitively, clearly and quickly discover relevant information rules, helping users to fully and correctly understand the city's operation status and make correct judgments and decisions.

[0003] In modern enterprises, the diversity and complexity of data are increasing, so a flexible and efficient method is needed to generate and display indicators to better support the decision-making process. Summary of the invention

[0004] In order to solve the above technical problems, the present invention provides an indicator configuration method based on a database, which displays the same data with indicators of different types and dimensions; supports diversified definition of indicators, meets most management indicator requirements, realizes one piece of data and multiple indicators, and improves data utilization to a certain extent.

[0005] The technical solution of the present invention is:

[0006] A database-based indicator configuration method, comprising:

[0007] New indicators are generated by selecting a database table, establishing corresponding connection relationships, and selecting statistical dimensions.

[0008] Generate new indicators by selecting a database, writing the corresponding SQL, and selecting statistical dimensions.

[0009] By selecting a calculation formula and configuring corresponding indicators for the calculation formula parameters, a new indicator is generated.

[0010] Furthermore,

[0011] First, using the library table method, by selecting the basic data table and establishing a connection according to needs, users can flexibly select the required statistical dimensions and statistical methods to generate corresponding indicators.

[0012] Secondly, users can write corresponding SQL statements as needed and directly select the dimensions and statistical methods to be counted.

[0013] Finally, the present invention also provides a calculation formula library that has been established in the system, and users can select appropriate formulas according to specific needs and specify corresponding dimensional indicators for their parameters.

[0014] 1. Create through library table method.

[0015] 1) Select the database that has been connected through the system and read all indicator data tables under the database.

[0016] 2) Select the indicator data table and read the data table data structure and configuration; if multiple tables are selected, you need to select the data table connection method (including left connection, right connection, full connection, inner connection) and select the associated fields.

[0017] 3) Select the dimensions and indicator fields you want to display in the selected data table.

[0018] 4) Generate a temporary table and display the temporary table structure and type.

[0019] 5) Configure fields as dimensions or indicators. There must be at least one selected field as a dimension, and there is no limit on the number of indicator fields.

[0020] 6) Configure the indicator name, statistical unit, rate value, and select the indicator aggregation method (including sum, average, maximum, minimum, count) for the field used as the indicator

[0021] 7) Generate indicators.

[0022] 2. Create through SQL.

[0023] 1) Select the database that has been connected through the system and read all indicator data tables under the database.

[0024] 2) Write SQL according to requirements in the current database and verify the SQL syntax

[0025] 3) Generate a temporary table and display the temporary table structure and type.

[0026] 4) Configure fields as dimensions or indicators. There must be at least one selected field as a dimension, and there is no limit on the number of indicator fields.

[0027] 5) Configure the indicator name, statistical unit, rate value, and indicator aggregation method (including sum, average, maximum, minimum, count) for the field used as the indicator.

[0028] 6) Generate indicators.

[0029] 3. Create through indicators.

[0030] 1) Select the indicator calculation formula that has been created by the system.

[0031] 2) Select the indicator of the specified dimension for the formula parameter node

[0032] 3) Generate indicators according to the predetermined calculation method of the formula.

[0033] The beneficial effects of the present invention are

[0034] The technical solution provided by the present invention can meet the needs of multi-dimensional and multi-type indicator output in data statistics, improve data fusion and analysis capabilities, and improve data reuse capabilities. Compared with the current conventional indicator output method, the present invention has the following technical advantages:

[0035] (1) Can meet business needs: The technical solution provided by this patent can meet the data analysis capabilities in daily statistical work and integrate diversified data to generate multi-dimensional indicator output.

[0036] (2) Improve user work efficiency and user experience: By integrating and analyzing existing indicator data, there is no need to create a separate indicator data table for each indicator, which reduces the workload of data collection and maintenance and improves work efficiency.

[0037] (3) Improve the uniformity of indicators: Indicators of the same type but in different dimensions are generated from a single source through different aggregation calculation methods, reducing the problem of data inconsistency caused by inconsistent statistical channels in data statistics. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] Figure 1 It is a schematic diagram of the workflow of the present invention. DETAILED DESCRIPTION

[0039] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments in 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.

[0040] The present invention provides a database-based indicator configuration method, which selects different generation methods to generate indicators based on a database that has been connected in the system. First, by adopting the library table method, by selecting the basic data table and establishing a connection according to the needs, the user can flexibly select the required statistical dimensions and statistical methods, thereby generating corresponding indicators. This method can adapt to the ever-changing data structure, which is convenient for users to conduct in-depth analysis; secondly, users can write corresponding SQL statements as needed, and directly select the dimensions and statistical methods that need to be counted. This method provides greater freedom, and can perform accurate data extraction and calculation according to specific needs to meet complex data analysis needs; finally, the present invention also provides a calculation formula library that has been established in the system, and users can select appropriate formulas according to specific needs, and specify corresponding dimensional indicators for their parameters. This method not only improves the efficiency of indicator generation, but also ensures the consistency and accuracy of the calculation.

[0041] The specific steps include:

[0042] 1) Create through library table method.

[0043] (1) Select a database that has been connected to the system and read all indicator data tables under the database.

[0044] (2) Select the indicator data table and read the data structure and configuration of the data table; if multiple tables are selected, you need to select the data table connection method (including left join, right join, full join, inner join) and select the associated fields.

[0045] (3) Select the dimension and indicator fields you want to display in the selected data table.

[0046] (4) Generate a temporary table and display the temporary table structure and type.

[0047] (5) Configure fields as dimensions or indicators. There must be at least one selected field as a dimension, and there is no limit on the number of indicator fields.

[0048] (6) Configure the indicator name, statistical unit, rate value, and indicator aggregation method (including sum, average, maximum, minimum, and count) for the indicator field.

[0049] (7) Generate indicators.

[0050] 2) Create through SQL.

[0051] (1) Select a database that has been connected to the system and read all indicator data tables under the database.

[0052] (2) Write SQL according to requirements in the current database and verify the SQL syntax

[0053] (3) Generate a temporary table and display the temporary table structure and type.

[0054] (4) Configure fields as dimensions or indicators. There must be at least one selected field as a dimension, and there is no limit on the number of indicator fields.

[0055] (5) Configure the indicator name, statistical unit, rate value, and indicator aggregation method (including sum, average, maximum, minimum, and count) for the indicator field.

[0056] (6) Generate indicators.

[0057] 3) Created through indicators.

[0058] (1) Select the indicator calculation formula that has been created by the system.

[0059] (2) Select the indicator of the specified dimension for the formula parameter node

[0060] (3) Generate indicators according to the predetermined calculation method of the formula.

[0061] The above description is only a preferred embodiment of the present invention, which is only used to illustrate the technical solution of the present invention, and is not used to limit the protection scope of the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention are included in the protection scope of the present invention.

Claims

1. A method for configuring indicators based on a database, characterized in that: Based on the database that has been connected in the system, select different generation methods to generate indicators; Generate new indicators by selecting a database table, establishing corresponding connections, and selecting statistical dimensions; Generate new indicators by selecting a database, writing the corresponding SQL, and selecting statistical dimensions; By selecting a calculation formula and configuring corresponding indicators for the calculation formula parameters, a new indicator is generated.

2. The method according to claim 1, characterized in that Using the library table method, by selecting the basic data table and establishing a connection according to needs, users can flexibly select the required statistical dimensions and statistical methods to generate corresponding indicators.

3. The method according to claim 1, characterized in that: Users can write corresponding SQL statements as needed and directly select the dimensions and statistical methods to be counted.

4. The method according to claim 1, characterized in that A system-wide library of established calculation formulas is provided, and users can select appropriate formulas based on their specific needs and specify corresponding dimensional indicators for their parameters.

5. The method according to claim 1, characterized in that Created by library table, including (1) Select a database that has been connected through the system and read all indicator data tables under the database; (2) Select the indicator data table and read the data structure and configuration of the data table; if you select several tables, you need to select the data table connection method and select the associated fields; (3) Select the dimensions and indicator fields you want to display in the selected data table; (4) Generate a temporary table and display the temporary table structure and type; (5) Configure fields as dimensions or indicators. There must be at least one selected field as a dimension. There is no limit on the number of indicator fields. (6) Configure the indicator name, statistical unit, rate value, and indicator aggregation method for the indicator field; (7) Generate indicators.

6. The method according to claim 5, characterized in that The data table connection methods in step (2) include left connection, right connection, full connection, and inner connection.

7. The method according to claim 5, characterized in that The indicator aggregation method selected in step (8) includes sum, average, maximum, minimum, and count.

8. The method according to claim 5, characterized in that Created by SQL, including (1) Select a database that has been connected through the system and read all indicator data tables under the database; (2) Write SQL according to requirements in the current database and verify the SQL syntax; (3) Generate a temporary table and display the temporary table structure and type; (4) Configure fields as dimensions or indicators. At least one selected field exists as a dimension, and the number of indicator fields is not limited. (5) Configure the indicator name, statistical unit, rate value, and indicator aggregation method for the indicator field; (6) Generate indicators.

9. The method according to claim 8, characterized in that The indicator aggregation methods selected in step (5) include sum, average, maximum, minimum, and count.

10. The method according to claim 1, characterized in that Created by indicators, including (1) Select the indicator calculation formula created by the system; (2) Select an indicator of a specified dimension for a formula parameter node; (3) Generate indicators according to the predetermined calculation method of the formula.

Images