Database-based index monitoring method, system, equipment and medium

Abstract

The invention discloses an index monitoring method, system and equipment based on a database and a medium, belongs to the technical field of data analysis, and aims to solve the technical problem of how to improve the accuracy of database index monitoring, improve the working efficiency and reduce the labor investment. Selecting the indexes created in the database table; according to the monitoring rule, selecting the index updating frequency, including every year, every quarter, every month, every week, every day and real time; selecting data types of the indexes, wherein the data types comprise digits, characters and floating-point numbers; and finishing the configuration.

Description

Technical Field

[0001] The present invention relates to the technical field of data analysis, and in particular to a method, system, device and medium for monitoring indicators based on a database. Background Art

[0002] With the help of advanced visualization technology and big data analysis capabilities, the monitoring data of urban operation signs can be fully integrated to mine data resources, support the intuitive display of key data in the form of geographic information, assist users in urban operation monitoring, evaluation, decision-making, analysis and other purposes, and build a smart, open and humanized information application system. Based on the situation indicators and urban operation event indicators in different fields of urban operation. Through system construction, a complete urban operation evaluation system can be realized, and a good urban supervision mechanism can be formed. This requires long-term and continuous monitoring of the update frequency, data type, data accuracy and data range of some indicators. Traditional monitoring methods require manual inspection of the compliance of each indicator, which requires staff to understand the update frequency and other standards of each indicator in detail, and consume a lot of manpower for inspection. A large number of indicator inspections are not only inefficient, but also have a high error rate.

[0003] Therefore, how to improve the accuracy of database indicator monitoring, improve work efficiency and reduce manpower input is a technical problem that needs to be solved urgently. Summary of the invention

[0004] The technical task of the present invention is to provide a database-based indicator monitoring method, system, device and medium to solve the problem of how to improve the accuracy of database indicator monitoring while improving work efficiency and reducing manual input.

[0005] The technical task of the present invention is achieved in the following way: a method for monitoring indicators based on a database, the method is as follows:

[0006] According to the indicator list, select the indicator that has been created in the database table;

[0007] According to the monitoring rules, select the frequency of indicator updates: annually, quarterly, monthly, weekly, daily, and real-time;

[0008] Select the data type of the indicator: including numeric, character and floating point;

[0009] The configuration is complete.

[0010] As a preferred embodiment, the monitoring rules are as follows:

[0011] If the monitoring time of the current cycle has passed, check the current cycle;

[0012] If the monitoring time of the current cycle has not arrived, check the previous cycle.

[0013] As a preferred option, select the indicator update frequency as annual, and configure the monitoring range as the beginning of each year to the month, day, and time of the current year;

[0014] Select the indicator update frequency as quarterly, and configure the monitoring range as the beginning of each quarter to the month, day, and hour of the current quarter;

[0015] Select the indicator update frequency as monthly, and configure the monitoring range as the beginning of each month to the day and time of the month;

[0016] Select the indicator update frequency as weekly, and configure the monitoring range from the beginning of each week to the day and time of the week;

[0017] Select the indicator update frequency as daily, and configure the monitoring range from the beginning of 0:00 to a certain time of the day;

[0018] Select the indicator update frequency as real-time and configure the monitoring range as monitoring interval.

[0019] Preferably, when selecting the data type of the indicator as the data type, configure the legal range interval of the number;

[0020] When the data type of the indicator is selected as character type, configure the character range dictionary;

[0021] When the indicator data type is selected as floating point number, configure the legal range of the data and the number of floating point digits.

[0022] A database-based indicator monitoring system, the system comprising:

[0023] The database table selection module is used to select the indicators created in the database table according to the indicator list;

[0024] The frequency selection module is used to select the frequency of indicator updates according to the monitoring rules: annually, quarterly, monthly, weekly, daily and real-time;

[0025] The type selection module is used to select the data type of the indicator: including numbers, characters, and floating point numbers.

[0026] As a preferred embodiment, the monitoring rules are as follows:

[0027] If the monitoring time of the current cycle has passed, check the current cycle;

[0028] If the monitoring time of the current cycle has not arrived, check the previous cycle.

[0029] As a preferred option, select the indicator update frequency as annual, and configure the monitoring range as the beginning of each year to the month, day, and time of the current year;

[0030] Select the indicator update frequency as quarterly, and configure the monitoring range as the beginning of each quarter to the month, day, and hour of the current quarter;

[0031] Select the indicator update frequency as monthly, and configure the monitoring range as the beginning of each month to the day and time of the month;

[0032] Select the indicator update frequency as weekly, and configure the monitoring range from the beginning of each week to the day and time of the week;

[0033] Select the indicator update frequency as daily, and configure the monitoring range from the beginning of 0:00 to a certain time of the day;

[0034] Select the indicator update frequency as real-time and configure the monitoring range as monitoring interval.

[0035] Preferably, when selecting the data type of the indicator as the data type, configure the legal range interval of the number;

[0036] When the data type of the indicator is selected as character type, configure the character range dictionary;

[0037] When the indicator data type is selected as floating point number, configure the legal range of the data and the number of floating point digits.

[0038] An electronic device comprising: a memory and at least one processor;

[0039] Wherein, the memory stores a computer program;

[0040] The at least one processor executes the computer program stored in the memory, so that the at least one processor performs the above-mentioned database-based indicator monitoring method.

[0041] A computer-readable storage medium stores a computer program, and the computer program can be executed by a processor to implement the above-mentioned database-based indicator monitoring method.

[0042] The database-based indicator monitoring method, system, device and medium of the present invention have the following advantages:

[0043] (1) The present invention reduces manual input and improves the configurability and accuracy of monitoring by customizing the data type, precision, update frequency and data range of monitoring indicators;

[0044] (ii) The present invention improves the configurability and accuracy of data monitoring to a certain extent by selecting indicators in the database table, setting the update frequency and monitoring time range, selecting data types and configuring the legal range, and has certain social value and economic benefits;

[0045] (III) The present invention can continuously monitor data indicators, improve dynamic monitoring capabilities, meet business needs, reduce duplication of work, improve work efficiency and user experience, and reduce monitoring error rates;

[0046] (IV) The present invention has significant social value and economic benefits, and provides an efficient and accurate technical solution for urban operation monitoring.

[0047] (V) The present invention can meet the needs of continuous monitoring of data indicators and improve the dynamic monitoring capability of data. Compared with the current conventional indicator monitoring methods, the present invention has the following technical advantages:

[0048] ① The present invention meets business needs: it meets the data monitoring capabilities in daily statistical work and continuously monitors data types and update cycles;

[0049] ② The present invention improves the user's work efficiency and user experience, reduces a lot of repetitive work, and can continuously monitor indicators with one configuration;

[0050] ③ The present invention improves the accuracy of indicator monitoring: it can greatly reduce the error rate of manual monitoring. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] The present invention is further described below in conjunction with the accompanying drawings.

[0052] Attached Figure 1 The flowchart of the indicator monitoring method based on database is shown in Figure 2. DETAILED DESCRIPTION

[0053] The following detailed description is made of the database-based indicator monitoring method, system, device and medium of the present invention with reference to the accompanying drawings and specific embodiments.

[0054] Embodiment 1:

[0055] As attached Figure 1 As shown, this embodiment provides an indicator monitoring method based on a database, and the method is specifically as follows:

[0056] S1. According to the indicator list, select the indicator that has been created in the database table;

[0057] S2. According to the monitoring rules, select the frequency of indicator updates: annually, quarterly, monthly, weekly, daily, and real-time;

[0058] S3. Select the data type of the indicator: including numbers, characters and floating point numbers;

[0059] S4. Configuration is complete.

[0060] The monitoring rules in step S2 of this embodiment are as follows:

[0061] If the monitoring time of the current cycle has passed, check the current cycle;

[0062] If the monitoring time of the current cycle has not arrived, check the previous cycle.

[0063] The frequency of updating the selection index in step S2 of this embodiment is every year, and the configuration monitoring range is from the beginning of each year to a certain month, day and time of the current year.

[0064] The frequency of updating the selection index in step S2 of this embodiment is every quarter, and the configuration monitoring range is from the beginning of each quarter to the month, day and time of the current quarter.

[0065] The frequency of updating the selection index in step S2 of this embodiment is monthly, and the configuration monitoring range is from the beginning of each month to the day and time of the month.

[0066] The frequency of updating the selection index in step S2 of this embodiment is weekly, and the monitoring range is configured from the beginning of each week to the day and time of the week.

[0067] The frequency of updating the selection index in step S2 of this embodiment is daily, and the monitoring range is configured from the beginning of 0 o'clock every day to a certain time of the day.

[0068] In step S2 of this embodiment, the frequency of updating the selection index is real-time, and the monitoring range is configured as the monitoring interval.

[0069] In this embodiment, when the data type of the selection indicator in step S3 is a data type, a legal range interval of a configuration number is configured.

[0070] In this embodiment, when the data type of the selection indicator in step S3 is a character type, a character range dictionary is configured.

[0071] In this embodiment, when the data type of the selection indicator in step S3 is a floating point number, the legal range of the data and the number of floating point digits are configured.

[0072] Embodiment 2:

[0073] This embodiment provides an indicator monitoring system based on a database, the system comprising:

[0074] The database table selection module is used to select the indicators created in the database table according to the indicator list;

[0075] The frequency selection module is used to select the frequency of indicator updates according to the monitoring rules: annually, quarterly, monthly, weekly, daily and real-time;

[0076] The type selection module is used to select the data type of the indicator: including numbers, characters, and floating point numbers.

[0077] The monitoring rules in this embodiment are as follows:

[0078] If the monitoring time of the current cycle has passed, check the current cycle;

[0079] If the monitoring time of the current cycle has not arrived, check the previous cycle.

[0080] In this embodiment, the frequency of updating the selection index is every year, and the configuration monitoring range is from the beginning of each year to a certain month, day and time of the current year.

[0081] In this embodiment, the frequency of updating the selection index is every quarter, and the configuration monitoring range is from the beginning of each quarter to the month, day and time of the current quarter.

[0082] In this embodiment, the frequency of updating the selection index is monthly, and the configuration monitoring range is from the beginning of each month to the day and time of the month.

[0083] In this embodiment, the frequency of updating the selection index is weekly, and the configuration monitoring range is from the beginning of each week to the day and time of the week.

[0084] In this embodiment, the frequency of updating the selection index is daily, and the configuration monitoring range is from the beginning of 0 o'clock every day to a certain time of the day.

[0085] In this embodiment, the frequency of updating the selection index is real-time, and the configuration monitoring range is the monitoring interval.

[0086] In this embodiment, when the data type of the selection indicator is a data type, a legal range interval of a number is configured.

[0087] In this embodiment, when the data type of the selection indicator is a character type, a character range dictionary is configured.

[0088] In this embodiment, when the data type of the selection indicator is a floating point number, the legal range of the data and the number of floating point digits are configured.

[0089] Embodiment 3:

[0090] This embodiment also provides an electronic device, including: a memory and a processor;

[0091] Wherein, the memory stores computer-executable instructions;

[0092] The processor executes the computer-executable instructions stored in the memory, so that the processor executes the database-based indicator monitoring method in any embodiment of the present invention.

[0093] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor may be a microprocessor or any conventional processor, etc.

[0094] The memory can be used to store computer programs and / or modules. The processor realizes various functions of the electronic device by running or executing the computer programs and / or modules stored in the memory, and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function, etc.; the data storage area can store data created according to the use of the terminal, etc. In addition, the memory can also include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (SMC), a secure digital (SD) card, a flash memory card, at least one disk storage period, a flash memory device, or other volatile solid-state storage devices.

[0095] Embodiment 4:

[0096] This embodiment also provides a computer-readable storage medium, in which a plurality of instructions are stored, and the instructions are loaded by a processor, so that the processor executes the indicator monitoring method based on the database in any embodiment of the present invention. Specifically, a system or device equipped with a storage medium can be provided, on which a software program code that implements the functions of any of the above embodiments is stored, and a computer (or CPU or MPU) of the system or device reads and executes the program code stored in the storage medium.

[0097] In this case, the program code itself read from the storage medium can realize the function of any one of the above-mentioned embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.

[0098] The storage medium embodiments for providing the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RYM, DVD-RW, DVD+RW), a magnetic tape, a non-volatile memory card, and a ROM. Alternatively, the program code can be downloaded from a server computer via a communication network.

[0099] In addition, it should be clear that the functions of any of the above embodiments can be implemented not only by executing the program code read by the computer, but also by enabling an operating system operating on the computer to complete part or all of the actual operations based on instructions from the program code.

[0100] In addition, it can be understood that the program code read from the storage medium is written to a memory provided in an expansion board inserted into the computer or written to a memory provided in an expansion unit connected to the computer, and then based on the instructions of the program code, a CPU installed on the expansion board or the expansion unit is enabled to perform part or all of the actual operations, thereby realizing the functions of any of the above-mentioned embodiments.

[0101] 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 aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A database-based indicator monitoring method, characterized in that: The method is as follows: According to the indicator list, select the indicator that has been created in the database table; According to the monitoring rules, select the frequency of indicator updates: annually, quarterly, monthly, weekly, daily, and real-time; Select the data type of the indicator: including numeric, character and floating point; The configuration is complete.

2. The database-based indicator monitoring method according to claim 1, characterized in that: The monitoring rules are as follows: If the monitoring time of the current cycle has passed, check the current cycle; If the monitoring time of the current cycle has not arrived, check the previous cycle.

3. The indicator monitoring method based on a database according to claim 1, characterized in that: When the indicator update frequency is selected as annual, the monitoring range is configured as the beginning of each year to the month, day and time of the current year; Select the indicator update frequency as quarterly, and configure the monitoring range as the beginning of each quarter to the month, day, and hour of the current quarter; Select the indicator update frequency as monthly, and configure the monitoring range as the beginning of each month to the day and time of the month; Select the indicator update frequency as weekly, and configure the monitoring range from the beginning of each week to the day and time of the week; Select the indicator update frequency as daily, and configure the monitoring range from the beginning of 0:00 to a certain time of the day; Select the indicator update frequency as real-time and configure the monitoring range as monitoring interval.

4. The method for monitoring indicators based on a database according to any one of claims 1 to 3, characterized in that: When selecting the data type of the indicator as data type, configure the legal range of numbers; When the data type of the indicator is selected as character type, configure the character range dictionary; When the indicator data type is selected as floating point number, configure the legal range of the data and the number of floating point digits.

5. A database-based indicator monitoring system, characterized in that: The system includes: The database table selection module is used to select the indicators created in the database table according to the indicator list; The frequency selection module is used to select the frequency of indicator updates according to the monitoring rules: annually, quarterly, monthly, weekly, daily and real-time; The type selection module is used to select the data type of the indicator: including numbers, characters, and floating point numbers.

6. The database-based indicator monitoring system according to claim 5, characterized in that: The monitoring rules are as follows: If the monitoring time of the current cycle has passed, check the current cycle; If the monitoring time of the current cycle has not arrived, check the previous cycle.

7. The database-based indicator monitoring system according to claim 5, characterized in that: When the indicator update frequency is selected as annual, the monitoring range is configured as the beginning of each year to the month, day and time of the current year; Select the indicator update frequency as quarterly, and configure the monitoring range as the beginning of each quarter to the month, day, and hour of the current quarter; Select the indicator update frequency as monthly, and configure the monitoring range as the beginning of each month to the day and time of the month; Select the indicator update frequency as weekly, and configure the monitoring range from the beginning of each week to the day and time of the week; Select the indicator update frequency as daily, and configure the monitoring range from the beginning of 0:00 to a certain time of the day; Select the indicator update frequency as real-time and configure the monitoring range as monitoring interval.

8. The database-based indicator monitoring system according to any one of claims 5 to 7, characterized in that: When selecting the data type of the indicator as data type, configure the legal range of numbers; When the data type of the indicator is selected as character type, configure the character range dictionary; When the indicator data type is selected as floating point number, configure the legal range of the data and the number of floating point digits.

9. An electronic device, characterized in that: include: memory and at least one processor; Wherein, the memory stores a computer program; The at least one processor executes the computer program stored in the memory, so that the at least one processor performs the database-based indicator monitoring method according to any one of claims 1 to 4.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, which can be executed by a processor to implement the database-based indicator monitoring method as described in any one of claims 1 to 4.

Images