Data display method and device, electronic equipment, medium and product

Abstract

The present disclosure provides a data display method and device, electronic equipment and storage medium, and relates to the field of data processing. The data display method comprises: obtaining configuration information input for a detection request, the configuration information comprising first information and second information, the first information representing a target category of a data item corresponding to the detection request, the second information representing detection logic of the data item corresponding to the detection request, and the first information having a target query statement format; determining a target data item having the target category from a preset data item storage table by analyzing the target query statement format of the first information, the preset data item storage table being used to store data items in the target query statement format; analyzing the target data item according to the detection logic to obtain an analysis result; and displaying the analysis result.

Description

Technical Field

[0001] This disclosure relates to the field of data processing technology, and in particular to a data display method, system, electronic device, medium and product. Background Technology

[0002] As business continues to grow, the number of data reports that need to be processed is increasing rapidly, and the number of data items that need to be monitored will also increase accordingly. By monitoring and displaying these data items, we can understand the operational status of the business and provide important information for decision-making. Summary of the Invention

[0003] This disclosure provides a method, apparatus, electronic device, and storage medium for data display.

[0004] According to one aspect of this disclosure, a data display method is provided, comprising: acquiring configuration information input for a detection request, the configuration information including first information and second information, the first information representing the target category of a data item corresponding to the detection request, the second information representing the detection logic of the data item corresponding to the detection request, the first information having a target query statement format; determining target data items with target categories from a preset data item storage table by parsing the target query statement format of the first information, the preset data item storage table being used to store data items in the target query statement format; analyzing the target data items according to the detection logic to obtain analysis results; and displaying the analysis results.

[0005] According to another aspect of this disclosure, a data display device is provided, comprising: an acquisition module, configured to acquire configuration information input in response to a detection request, the configuration information including first information and second information, the first information representing the target category of a data item corresponding to the detection request, the second information representing the detection logic of the data item corresponding to the detection request, the first information having a target query statement format; a determination module, configured to determine a target data item having a target category from a preset data item storage table by parsing the target query statement format of the first information, the preset data item storage table being used to store data items in the target query statement format; an analysis module, configured to analyze the target data item according to the detection logic to obtain analysis results; and a display module, configured to display the analysis results.

[0006] According to another aspect of this disclosure, an electronic device is provided, comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to perform a method according to an embodiment of this disclosure.

[0007] According to another aspect of this disclosure, a non-transitory computer-readable storage medium is provided storing computer instructions, wherein the computer instructions are used to cause the computer to perform a method according to an embodiment of this disclosure.

[0008] According to another aspect of this disclosure, a computer program product is provided, including a computer program that, when executed by a processor, implements a method according to an embodiment of this disclosure.

[0009] It should be understood that the description in this section is not intended to identify key or essential features of the embodiments of this disclosure, nor is it intended to limit the scope of this disclosure. Other features of this disclosure will become readily apparent from the following description. Attached Figure Description

[0010] The accompanying drawings are provided to better understand this solution and do not constitute a limitation of this disclosure. Wherein:

[0011] Figure 1 This is an exemplary system architecture diagram of a data display method and apparatus applicable according to an embodiment of the present disclosure;

[0012] Figure 2 This is a flowchart of a data display method according to an embodiment of the present disclosure;

[0013] Figure 3 This is a schematic diagram of a newly added interface according to an embodiment of the present disclosure;

[0014] Figure 4 This is a schematic diagram of an editing interface according to an embodiment of the present disclosure;

[0015] Figure 5 This is a schematic diagram of a management interface according to an embodiment of the present disclosure;

[0016] Figure 6 This is a schematic diagram of a database configuration interface according to an embodiment of the present disclosure;

[0017] Figure 7 This is a schematic diagram of an analysis result display page according to an embodiment of the present disclosure;

[0018] Figure 8 This is a schematic diagram of a data display device according to an embodiment of the present disclosure;

[0019] Figure 9 This is a schematic diagram of the application architecture for implementing a data display method according to an embodiment of the present disclosure;

[0020] Figure 10 A schematic block diagram of an example electronic device that can be used to implement embodiments of the present disclosure is shown. Detailed Implementation

[0021] The exemplary embodiments of this disclosure are described below with reference to the accompanying drawings, including various details of the embodiments to aid understanding, and should be considered merely exemplary. Therefore, those skilled in the art will recognize that various changes and modifications can be made to the embodiments described herein without departing from the scope and spirit of this disclosure. Similarly, for clarity and brevity, descriptions of well-known functions and structures are omitted in the following description.

[0022] As business grows, the number of business-related data reports is also increasing rapidly. Correspondingly, the number of data items requiring inspection in these reports is also gradually increasing. Data item inspection can be performed using reporting platform-based methods or scripts. However, platform-based inspection only supports reports generated from data models. Currently, many data reports are generated using SQL models, and reporting platforms do not support data item inspection for reports generated using SQL models. Using scripts for data item inspection is costly to maintain, typically lacks an intuitive visualization interface, and makes data display difficult. Furthermore, as the number of data items increases, script management and updates become more complex.

[0023] Therefore, in order to achieve simple and efficient data display based on data item detection, this disclosure provides a data display method, which is illustrated below.

[0024] Figure 1 This is an exemplary system architecture diagram of a data display method and apparatus applicable according to an embodiment of the present disclosure.

[0025] It is important to note that Figure 1 The examples shown are merely examples of system architectures that can be applied to the embodiments of this disclosure, in order to help those skilled in the art understand the technical content of this disclosure, but do not mean that the embodiments of this disclosure cannot be used in other devices, systems, environments or scenarios.

[0026] like Figure 1 As shown, the system architecture 100 according to this embodiment may include terminal device 101, terminal device 102, terminal device 103, network 104, and server 105. Network 104 serves as a medium for providing communication links between terminal device 101, terminal device 102, terminal device 103, and server 105. Network 104 may include various connection types, such as wired and / or wireless communication links, etc.

[0027] Terminal devices 101, 102, and 103 can be various electronic devices with displays and web browsing capabilities, including but not limited to smartphones, tablets, laptops, and desktop computers.

[0028] Server 105 can be a server providing various services, such as a backend management server supporting the content browsed by users using terminal devices 101, 102, and 103 (this is just an example). The backend management server can analyze and process received user requests and other data, and feed back the processing results (such as web pages, information, or data obtained or generated according to user requests) to the terminal devices. The server can be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the shortcomings of traditional physical hosts and VPS services ("Virtual Private Server", or simply "VPS") in terms of high management difficulty and weak business scalability. The server can also be a server for a distributed system, or a server combined with blockchain.

[0029] It should be noted that the data display method provided in this embodiment can generally be executed by terminal device 101, terminal device 102, or terminal device 103. Accordingly, the data display device provided in this embodiment can also be disposed in terminal device 101, terminal device 102, or terminal device 103.

[0030] Alternatively, the data display method provided in this embodiment can also be executed by server 105. Correspondingly, the data display device provided in this embodiment can generally be located in server 105. The data display method provided in this embodiment can also be executed by a server or server cluster that is different from server 105 and capable of communicating with terminal devices 101, 102, 103, and / or server 105. Correspondingly, the data display device provided in this embodiment can also be located in a server or server cluster that is different from server 105 and capable of communicating with terminal devices 101, 102, 103, and / or server 105.

[0031] Understandable. Figure 1 The number of terminal devices, networks, and servers shown is merely illustrative. Depending on implementation needs, any number of terminal devices, networks, and servers can be included.

[0032] It is understood that the system architecture of this disclosure has been described above, and the methods of this disclosure will be described below. It is also understood that the sequence numbers of each operation in the following methods are only for descriptive purposes and should not be considered as indicating the execution order of the operations. Unless explicitly stated otherwise, the method does not need to be executed in the exact order shown.

[0033] The collection, storage, use, processing, transmission, provision, and disclosure of user personal information involved in the technical solution of this invention all comply with the provisions of relevant laws and regulations and do not violate public order and good morals.

[0034] In the technical solution of the present invention, the user's authorization or consent is obtained before acquiring or collecting the user's personal information.

[0035] Figure 2 This is a flowchart of a data display method according to an embodiment of the present disclosure.

[0036] like Figure 2 As shown, the method 200 may include operations S210 to S230.

[0037] In operation S210, configuration information for the detection request input is obtained.

[0038] In this embodiment of the disclosure, the configuration information includes first information. The first information represents the target category of the data item corresponding to the detection request. The target category can be determined based on the business direction pointed to by the data items stored in the database. For example, if the business direction is live streaming, shopping, etc., for the target category of shopping, the data items of the target category may include, for example, the number of views of product knowledge, the number of views of product purchases, the number of views of entity categories, etc.

[0039] In this embodiment of the disclosure, the first information has a target query statement format. The target query statement format may be a format of a Structured Query Language (SQL) statement used to retrieve target data items.

[0040] In this embodiment of the disclosure, the configuration information includes second information. The second information characterizes the detection logic for the data item corresponding to the detection request. The detection logic may involve performing fluctuation calculations on the data item, and / or performing delayed calculations on the data value of the data item.

[0041] In operation S220, the target data item with the target category is determined from the preset data item storage table by parsing the target query statement format of the first information.

[0042] In this embodiment of the disclosure, a preset data item storage table is used to store data items in the format of a target query statement.

[0043] It can be understood that data items are stored in data item tables. All data item tables are stored in data item storage tables. That is, data item storage tables store the historical data values ​​of data items.

[0044] Data item storage tables are stored in a database. This database can be a relational database that supports SQL queries, such as MySQL, Oracle, Palo Alpha, etc. Each data item table in this database has a name, and each data item table within the same database has a unique name.

[0045] Understandably, data items are typically stored in columns of a data item table, while rows record the data values ​​of the data items.

[0046] In operation S230, the target data items are analyzed according to the detection logic to obtain the analysis results.

[0047] For example, the detection logic includes calculating the fluctuation of the data value of a data item. The analysis result includes the fluctuation value of the data item's data value. As another example, the detection logic includes performing a delayed calculation on the data value of a data item, and the analysis result includes whether to output the data item.

[0048] The S240 is used to display the analysis results.

[0049] In some embodiments, the analysis results may be presented using at least one display method, such as tables, charts, or text reports. This disclosure does not impose any limitations on this.

[0050] Through the embodiments of this disclosure, only configuration information including first and second information is input. Since data items are stored in a target query statement format, by parsing the first information with the target query statement format, target data items with target categories can be determined. Then, the second information representing the detection logic is used to analyze the target data items, thus realizing the analysis of target data items. The configuration method is simple and helps to improve the efficiency of data item analysis.

[0051] As can be understood, the method of this disclosure has been described above, and the following will further explain the method of this disclosure in conjunction with a visual interface.

[0052] Figure 3 This is a schematic diagram of a newly added interface according to an embodiment of the present disclosure.

[0053] like Figure 3 As shown, the newly added interface 300 is used to receive configuration information. This configuration information includes first information and second information. The newly added interface 300 includes an information item bar 301 and an input bar 302.

[0054] In this disclosure, the elements of the first information may include at least one of the following: target category (also known as business direction), data retrieval method, database name for storing data items (also known as database name), table name, and SQL.

[0055] To receive the first information, you can select the target database name in the input field 302 corresponding to the "Database Name" field in information field 301. After selecting the target database name, an "sql" field will appear under the "Database Name" field. Then, you can enter a custom-written SQL statement in the input field 32 corresponding to the "sql" field to input the first information. In some implementations of the above operation S210, obtaining the first information input in response to the detection request can be done by obtaining the first information input using a custom-written SQL statement.

[0056] Receiving the first information allows you to select a data item table name in the "Table Name" field of information item column 301, thus inputting the first information. In another implementation of the above operation S210, obtaining the first information input in response to the detection request can be achieved by obtaining the table name input in response to the detection request, and by searching the data item table indicated by the data item table name in the data item storage table.

[0057] In this disclosure, the elements of the second information may include at least one of the following: dimension field of the data item, data item field of the data item, output time, detection level, whether it is in detection state, fluctuation threshold, whether to issue a delayed alarm for data items exceeding the fluctuation threshold, and alarm delay time.

[0058] To receive the second information, you can select the dimension in the input field 302 corresponding to the "Dimension Field" item in the information item column 301 and select the data item in the input field 302 corresponding to the "Data Item Field" item, thus inputting the second information.

[0059] In some embodiments, the configuration information may also include the detection name, creator, follower, duty roster ID, analysis result receiving ID, alarm robot ID, etc. Specific settings can be configured according to actual needs.

[0060] Figure 4 This is a schematic diagram of an editing interface according to an embodiment of the present disclosure.

[0061] like Figure 4 As shown, the editing interface 400 is used to edit configuration information. This configuration information includes first information and second information. The editing interface 400 includes an information item bar 401 and an editing bar 402.

[0062] When the first information is entered as a custom query statement, it can be edited by rewriting the custom SQL statement in the edit bar 402 corresponding to the "sql" item in information item 401. Similarly, when the first information is entered as a table name, it can be edited by reselecting the table name in the edit bar 402 corresponding to the "table name" item in information item 401.

[0063] Editing the second information allows you to reselect or input elements such as dimension fields and data item fields in the editing interface 400.

[0064] Figure 5 This is a schematic diagram of a management interface according to an embodiment of the present disclosure.

[0065] like Figure 5 As shown, the management interface 500 is used to display configuration information. This configuration information includes first information and second information. The management interface 500 includes a "Add Database Detection" button 501, a "Add SQL Detection" button 502, and a display bar 503.

[0066] Users can access the new page 300 by clicking the "Add Database Detection" button 501 or the "Add SQL Detection" button 502.

[0067] In some embodiments, the management interface 500 may also include buttons for accessing the editing interface and the database configuration interface. Users can access these interfaces by clicking the corresponding icons. For example, the button for accessing the editing interface in the display bar 503 is displayed as the word "Edit".

[0068] Through the embodiments of this disclosure, configuration information can be intuitively managed and observed by inputting or editing configuration information in a visual interface, thereby improving the detection efficiency of data items.

[0069] Figure 6 This is a schematic diagram of a database configuration interface according to an embodiment of the present disclosure.

[0070] like Figure 6 As shown, the database configuration interface 600 is used to receive the address information of the database where the preset data item storage table is located. The database configuration interface 600 includes an information field 601 and an edit field 602. The information fields in the information field 601 can include parameters that characterize the address information of the database where the data item storage table is located, such as database name, host, port, user, password, and database. By entering the specific values ​​of these parameters in the corresponding fields of the edit field 602, the address information of the database where the preset data item storage table is located can be determined. This allows users to independently select the database where the target data item is located.

[0071] As can be understood, the above has described the visual interface of this disclosure, and the following will further explain the method of this disclosure.

[0072] In this embodiment of the disclosure, a visual interface is displayed; in response to a detection request received through the visual interface, operation S210 is performed to obtain configuration information input for the detection request; by parsing the target query statement format of the first information, a target data item with a target category is determined from a preset data item storage table; the target data item is analyzed according to the detection logic to obtain the analysis result; and the analysis result is displayed.

[0073] In this embodiment of the disclosure, the analysis of a target data item based on detection logic to obtain analysis results includes: determining the detection logic of the target data item from a preset data item information table, wherein the preset data item information table stores data related to the detection logic of the data item; and analyzing the target data item based on the data related to the detection logic of the target data item according to the detection logic to obtain analysis results.

[0074] Understandably, the data item information table can be stored in a database. This database can be a relational database that supports SQL query statements.

[0075] In some embodiments, the database storing the data item information table may also simultaneously store at least one of the data item storage table and the data item status table. A description of the data item storage table can be found above and will not be repeated here. The data item information table can store data related to the detection logic of the data item. For example, data item name, caliber definition, fluctuation threshold, detection level (e.g., daily, hourly), and the output time of the data item, etc., for example, a daily data item is produced after a few days. The data item status table is used to store analysis results, which may include the detection status and status value of the data item. The detection status may include at least one of the following: data item name, whether the data item output is delayed, whether the data item data value fluctuates, the fluctuation situation of the data item data value, and whether the data item has been detected. In some embodiments, the detection status of at least one data item can be displayed in the analysis results, and the value of this detection status can be obtained from the data item status table.

[0076] In some embodiments, the detection logic can be configured according to actual needs. The detection logic may include performing fluctuation calculations on the target data item. If the data value of the target data item exceeds a preset fluctuation threshold, the target data item is output. As another example, the detection logic may include performing delay calculations on the data value of the target data item. If the current time exceeds a preset delay time, the target data item is output.

[0077] It is understandable that fluctuation calculations can be used to calculate data such as day-on-day or week-on-week comparisons of data items. This disclosure does not limit this and can be set according to actual needs.

[0078] Therefore, the above analysis of the target data item based on the detection logic may include: determining whether the fluctuation value of the target data item's data value is greater than a preset fluctuation threshold, and / or, in the case that the target data item requires a delayed alarm, determining whether the current time exceeds the delayed alarm time of the target data item.

[0079] Figure 7 This is a schematic diagram of an analysis result display page according to an embodiment of the present disclosure.

[0080] like Figure 7 As shown, the analysis results display page 700 includes a title bar 701 and a data bar 702.

[0081] The title bar 701 can be used to display information related to the analysis results. At least one piece of secondary information can be displayed in the title bar 701, and can be set according to actual needs. For example, it can include the business direction and the detection name. Another example is that it can include the detection level, the library name, and the alarm robot ID.

[0082] Data panel 702 is used to display analysis results. The analysis results displayed in data panel 702 can include at least one of the following: the data value of the target data item, the fluctuation value of the target data item, and whether the data value of the target data item is abnormal. For example, the analysis results displayed in data panel 702 may include target data items such as product knowledge pageviews (PV), product purchase PV, etc., and the fluctuation values ​​of the target data items may include daily and weekly changes. Analysis results can be displayed to users via email, SMS, and other means to remind them to pay attention to changes in the data items in the analysis results, thereby improving work efficiency.

[0083] Figure 8 This is a schematic diagram of a data display device according to an embodiment of the present disclosure.

[0084] like Figure 8 As shown, the data display device 800 may include an acquisition module 810, a determination module 820, an analysis module 830, and a display module 840.

[0085] The acquisition module 810 is used to acquire configuration information input for the detection request. The configuration information includes first information and second information. The first information represents the target category of the data item corresponding to the detection request, and the second information represents the detection logic of the data item corresponding to the detection request. The first information has a target query statement format.

[0086] The determination module 820 is used to determine the target data item with the target category from the preset data item storage table by parsing the target query statement format of the first information. The preset data item storage table is used to store data items in the target query statement format.

[0087] The analysis module 830 is used to analyze the target data items according to the detection logic and obtain the analysis results.

[0088] Display module 840 is used to display the analysis results.

[0089] According to an embodiment of this disclosure, the acquisition module 810 includes: a statement acquisition submodule, used to acquire first information input in a custom-written target query statement.

[0090] According to an embodiment of this disclosure, the acquisition module 810 includes: a table name acquisition submodule, used to acquire the data item table name input in response to the detection request; and a search submodule, used to acquire first information by searching for the data item table indicated by the data item table name in the data item storage table.

[0091] According to an embodiment of this disclosure, the analysis module 830 includes: a detection logic determination submodule, used to determine the detection logic of a target data item from a preset data item information table, the preset data item information table storing data related to the detection logic of the data item; and an analysis submodule, used to analyze the target data item according to the detection logic and based on the data related to the detection logic of the target data item, to obtain analysis results.

[0092] According to embodiments of this disclosure, the target data item is analyzed according to the detection logic, including at least one of the following operations: determining whether the fluctuation value of the data value of the target data item is greater than a preset fluctuation threshold; and determining whether the current time exceeds the delayed alarm time of the target data item if the target data item requires a delayed alarm.

[0093] According to embodiments of this disclosure, the data display device 800 may further include: an interface display module for displaying a visual interface, the visual interface including at least one of a management interface, a new interface, an editing interface, and a database configuration interface; and an acquisition module for responding to a detection request received through the visual interface and performing an operation to acquire configuration information input in response to the detection request; wherein the management interface is used to display configuration information; the new interface is used to receive configuration information; the editing interface is used to edit configuration information; and the database configuration interface is used to receive the address information of the database where the preset data item storage table is located.

[0094] According to embodiments of this disclosure, the second information includes at least one of the following: the database name storing the data item; the dimension field of the data item; the field of the data item; the generation time of the data item; the detection level of the data item; whether the data item is in a detection state; the fluctuation threshold of the data item; whether to issue a delayed alarm for data items exceeding the fluctuation threshold; and the delay time for issuing a delayed alarm for data items exceeding the fluctuation threshold.

[0095] According to embodiments of this disclosure, the analysis results include at least one of the following: the data value of the target data item; the fluctuation value of the data value of the target data item; and whether the data value of the target data item is abnormal.

[0096] Figure 9 This is a schematic diagram of the application architecture for implementing a data display method according to an embodiment of the present disclosure.

[0097] like Figure 9 As shown, the application architecture 900 used to implement the data display method may include three layers, from top to bottom: application layer 910, service layer 920, and storage layer 930. The application layer 910, service layer 920, and storage layer 930 are connected through a software interface.

[0098] In this embodiment of the disclosure, the application layer 910 may include a management platform 911 and an alarm push module 912.

[0099] The management platform 911 can provide the visual interface described above. Users can input configuration information, view configuration information, or edit configuration information through the visual interface.

[0100] The alarm push module 912 can push detected anomaly information after executing a detection request. It can also send alerts at set intervals. The push method can be determined based on the receive ID from the analysis results in the second information.

[0101] In this embodiment of the disclosure, the service layer 920 may include a management API 921, an alarm API 922, and a calculation API 923.

[0102] The Management API 921 can handle requests from the management platform, such as the detection request mentioned above. The Management API 921 can also perform compliance checks on input custom SQL statements to ensure the correctness of the input custom SQL language.

[0103] The alarm API 922 can push the calculation results after the detection logic is executed.

[0104] API923 can be used to detect target data items. Calculations are performed on the target data items according to detection logic. The detection logic can be a fluctuation calculation of the target data item, or a delayed calculation of the target data item's data value. This disclosure does not limit this. For details on how the target data item is calculated according to the detection logic, please refer to the relevant descriptions above.

[0105] In this embodiment of the disclosure, the storage layer 930 may store a data item storage table 931, a data item information table 932, and a data item status table 933. For a description of the data item storage table 931, the data item information table 932, and the data item status table 933, please refer to the relevant descriptions above.

[0106] Understandable, Figure 9 The architecture diagram shown is for illustrative purposes only. The application architecture for implementing the data display method may have more or fewer software modules, or combine some software modules, or split some software modules, etc. This disclosure does not limit this.

[0107] According to embodiments of this disclosure, this disclosure also provides an electronic device, a readable storage medium, and a computer program product.

[0108] Figure 10 A schematic block diagram of an example electronic device that can be used to implement embodiments of the present disclosure is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device may also represent various forms of mobile devices, such as personal digital processors, cellular phones, smartphones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the present disclosure described and / or claimed herein.

[0109] like Figure 10 As shown, device 1000 includes a computing unit 1001, which can perform various appropriate actions and processes according to a computer program stored in read-only memory (ROM) 1002 or a computer program loaded into random access memory (RAM) 1003 from storage unit 1008. The RAM 1003 may also store various programs and data required for the operation of device 1000. The computing unit 1001, ROM 1002, and RAM 1003 are interconnected via bus 1004. Input / output (I / O) interface 1005 is also connected to bus 1004.

[0110] Multiple components in device 1000 are connected to I / O interface 1005, including: input unit 1006, such as keyboard, mouse, etc.; output unit 1007, such as various types of monitors, speakers, etc.; storage unit 1008, such as disk, optical disk, etc.; and communication unit 1009, such as network card, modem, wireless transceiver, etc. Communication unit 1009 allows device 1000 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.

[0111] The computing unit 1001 can be a variety of general-purpose and / or special-purpose processing components with processing and computing capabilities. Some examples of the computing unit 1001 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special-purpose artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. The computing unit 1001 performs the various methods and processes described above, such as data presentation methods. For example, in some embodiments, the data presentation method may be implemented as a computer software program tangibly contained in a machine-readable medium, such as storage unit 1008. In some embodiments, part or all of the computer program may be loaded and / or installed on device 1000 via ROM 1002 and / or communication unit 1009. When the computer program is loaded into RAM 1003 and executed by the computing unit 1001, one or more steps of the data presentation method described above may be performed. Alternatively, in other embodiments, the computing unit 1001 may be configured to perform the data presentation method by any other suitable means (e.g., by means of firmware).

[0112] Various embodiments of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems-on-a-chip (SoCs), payload-programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments may include implementations in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which may be a dedicated or general-purpose programmable processor, capable of receiving data and instructions from a storage system, at least one input device, and at least one output device, and transmitting data and instructions to the storage system, the at least one input device, and the at least one output device.

[0113] The program code used to implement the methods of this disclosure may be written in any combination of one or more programming languages. This program code may be provided to a processor or controller of a general-purpose computer, special-purpose computer, or other programmable data processing apparatus, such that when executed by the processor or controller, the program code causes the functions / operations specified in the flowcharts and / or block diagrams to be implemented. The program code may be executed entirely on a machine, partially on a machine, as a standalone software package partially on a machine and partially on a remote machine, or entirely on a remote machine or server.

[0114] In the context of this disclosure, a machine-readable medium can be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, apparatus, or device. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can be, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0115] To provide interaction with a user, the systems and techniques described herein can be implemented on a computer having: a display device for displaying information to the user (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor); and a keyboard and pointing device (e.g., a mouse or trackball) through which the user provides input to the computer. Other types of devices can also be used to provide interaction with the user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including sound input, voice input, or tactile input).

[0116] The systems and technologies described herein can be implemented in computing systems that include backend components (e.g., as a data server), or computing systems that include middleware components (e.g., an application server), or computing systems that include frontend components (e.g., a user computer with a graphical user interface or web browser through which a user can interact with implementations of the systems and technologies described herein), or any combination of such backend, middleware, or frontend components. The components of the system can be interconnected via digital data communication of any form or medium (e.g., a communication network). Examples of communication networks include local area networks (LANs), wide area networks (WANs), and the Internet.

[0117] Computer systems can include clients and servers. Clients and servers are generally located far apart and typically interact through communication networks. Client-server relationships are created by computer programs running on the respective computers and having a client-server relationship with each other.

[0118] It should be understood that the various forms of processes shown above can be used to rearrange, add, or delete steps. For example, the steps described in this disclosure can be executed in parallel, sequentially, or in different orders, as long as the desired result of the technical solution disclosed in this disclosure can be achieved, and this is not limited herein.

[0119] The specific embodiments described above do not constitute a limitation on the scope of protection of this disclosure. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of this disclosure should be included within the scope of protection of this disclosure.

Claims

1. A data display method, comprising: Obtain configuration information for the input of the detection request. The configuration information includes first information and second information. The first information represents the target category of the data item corresponding to the detection request, and the second information represents the detection logic of the data item corresponding to the detection request. The first information has a target query statement format. By parsing the target query statement format of the first information, target data items with the target category are determined from a preset data item storage table, which is used to store data items in the target query statement format. The target data item is analyzed according to the detection logic to obtain the analysis result; as well as Present the analysis results; The method further includes: displaying a visualization interface; and, in response to a detection request received through the visualization interface, performing the operation of obtaining configuration information input for the detection request. The second piece of information is entered or edited by the user through the visual interface; The step of analyzing the target data item according to the detection logic to obtain the analysis result includes: determining the detection logic of the target data item represented by the second information from a preset data item information table, wherein the preset data item information table stores data related to the detection logic of the data item; and analyzing the target data item according to the detection logic represented by the second information, based on the data related to the detection logic of the target data item, to obtain the analysis result.

2. The method according to claim 1, wherein, The step of obtaining the first information input in response to the detection request includes: Retrieve the first information input when writing a custom target query statement.

3. The method according to claim 1, wherein, The step of obtaining the first information input in response to the detection request includes: Retrieve the table name of the data item input for the detection request; The first information is obtained by searching the data item table indicated by the data item table name in the data item storage table.

4. The method according to claim 1, wherein, The analysis of the target data item according to the detection logic includes at least one of the following operations: Determine whether the fluctuation value of the target data item is greater than a preset fluctuation threshold; If the target data item requires a delayed alarm, determine whether the current time exceeds the delayed alarm time of the target data item.

5. The method according to claim 1, wherein the visual interface includes at least one of a management interface, a new addition interface, an editing interface, and a database configuration interface; in, The management interface is used to display the configuration information; the add interface is used to receive the configuration information; the edit interface is used to edit the configuration information; and the database configuration interface is used to receive the address information of the database where the preset data item storage table is located.

6. The method according to claim 1, wherein, The second information includes at least one of the following: The dimension field of the data item; The data item fields of the data item; The generation time of the data item; The detection level of the data item; Whether the data item is in a detection state; The fluctuation threshold of the data item; Whether to delay alarms for data items exceeding the fluctuation threshold; The delay time for issuing a delayed alarm for data items exceeding the fluctuation threshold.

7. The method according to claim 1, wherein, The analysis results include at least one of the following: The data value of the target data item; The fluctuation value of the data value of the target data item; Whether the data value of the target data item is abnormal.

8. A data display device, comprising: The acquisition module is used to acquire configuration information input for the detection request. The configuration information includes first information and second information. The first information represents the target category of the data item corresponding to the detection request, and the second information represents the detection logic of the data item corresponding to the detection request. The first information has a target query statement format. The determination module is used to determine the target data item with the target category from a preset data item storage table by parsing the target query statement format of the first information. The preset data item storage table is used to store data items in the target query statement format. The analysis module is used to analyze the target data item according to the detection logic and obtain the analysis results; as well as The display module is used to display the analysis results; The device further includes: an interface display module for displaying a visual interface; The acquisition module is also configured to, in response to a detection request received through the visualization interface, perform the operation of acquiring configuration information input for the detection request; The second piece of information is entered or edited by the user through the visual interface; The analysis module includes: The detection logic determination submodule is used to determine the detection logic of the target data item represented by the second information from a preset data item information table, wherein the preset data item information table stores data related to the detection logic of the data item; The analysis submodule is used to analyze the target data item based on the detection logic related to the detection logic of the target data item, according to the detection logic represented by the second information, and to obtain the analysis result.

9. The apparatus according to claim 8, wherein, The acquisition module includes: The statement retrieval submodule is used to retrieve the initial information from the input of a custom-written target query statement.

10. The apparatus according to claim 8, wherein, The acquisition module includes: The table name retrieval submodule is used to retrieve the table name of the data item input for the detection request. The lookup submodule is used to obtain the first information by searching the data item table indicated by the data item table name in the data item storage table.

11. The apparatus according to claim 8, wherein, The analysis of the target data item according to the detection logic includes at least one of the following operations: Determine whether the fluctuation value of the target data item is greater than a preset fluctuation threshold; If the target data item requires a delayed alarm, determine whether the current time exceeds the delayed alarm time of the target data item.

12. The apparatus according to claim 8, wherein, The visual interface includes at least one of the following: a management interface, a new addition interface, an editing interface, and a database configuration interface; The management interface is used to display the configuration information; the add interface is used to receive the configuration information; the edit interface is used to edit the configuration information; and the database configuration interface is used to receive the address information of the database where the preset data item storage table is located.

13. The apparatus according to claim 8, wherein, The second information includes at least one of the following: The name of the database that stores the data items; The dimension field of the data item; The data item fields of the data item; The generation time of the data item; The detection level of the data item; Whether the data item is in a detection state; The fluctuation threshold of the data item; Whether to delay alarms for data items exceeding the fluctuation threshold; The delay time for issuing a delayed alarm for data items exceeding the fluctuation threshold.

14. The apparatus according to claim 8, wherein, The analysis results include at least one of the following: The data value of the target data item; The fluctuation value of the data value of the target data item; Whether the data value of the target data item is abnormal.

15. An electronic device comprising: At least one processor; as well as A memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-7.

16. A non-transitory computer-readable storage medium storing computer instructions, wherein, The computer instructions are used to cause the computer to perform the method according to any one of claims 1-7.

17. A computer program product comprising a computer program that, when executed by a processor, implements the method according to any one of claims 1-7.

Images