Data display method and device, electronic equipment, medium and product
By analyzing the target query statement format and detection logic, and determining and analyzing the target data items, the problem of low data item detection and display efficiency in the prior art is solved, and efficient and intuitive data item display and analysis are achieved.
Patent Information
- Application Number
- CN202411884401.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-19
- Publication Date
- 2025-03-14
- Estimated Expiration
- 2044-12-19
AI Technical Summary
It is difficult for the prior art to efficiently detect and display a large number of data items, especially when the number of data items increases. The detection method based on the report platform does not support data reports produced by SQL models, and script detection and maintenance costs are high and difficult to visually display.
Provide a data display method, by obtaining configuration information, analyzing the target query statement format, determining the target data item from the preset data item storage table, and analyzing and displaying the target data item according to the detection logic.
It realizes simple and efficient data item detection and display, reduces maintenance costs, improves the efficiency of data item analysis, and provides an intuitive visual interface.
Smart Images

Figure CN119621807A_ABST
Abstract
Description
Technical Field
[0001] The present disclosure relates to the field of data processing technology, and in particular to a data display method, system, electronic device, medium and product. Background Art
[0002] As the business continues to grow, the number of data reports that need to be processed increases rapidly, and the corresponding data items that need to be tested will also increase. By testing and displaying these data items, we can understand the operation status of the business and provide an important basis for decision-making. Summary of the invention
[0003] The present disclosure provides a method, an apparatus, an electronic device, and a storage medium for data presentation.
[0004] According to one aspect of the present disclosure, a data display method is provided, including: obtaining configuration information input for a detection request, the configuration information including 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 a detection logic of the data item corresponding to the detection request, the first information having a target query statement format; determining a target data item with 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; analyzing the target data item according to the detection logic to obtain an analysis result; and displaying the analysis result.
[0005] According to another aspect of the present disclosure, a data display device is provided, including: an acquisition module, used to acquire configuration information input for a detection request, the configuration information including 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 a detection logic of the data item corresponding to the detection request, and the first information having a target query statement format; a determination module, used to determine a target data item with 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, used to analyze the target data item according to the detection logic to obtain an analysis result; and a display module, used to display the analysis result.
[0006] According to another aspect of the present 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, and the instructions are executed by the at least one processor so that the at least one processor can execute a method according to an embodiment of the present disclosure.
[0007] According to another aspect of the present disclosure, a non-transitory computer-readable storage medium storing computer instructions is provided, wherein the computer instructions are used to cause the computer to execute the method according to an embodiment of the present disclosure.
[0008] According to another aspect of the present disclosure, a computer program product is provided, including a computer program, and when the computer program is executed by a processor, the method according to the embodiment of the present disclosure is implemented.
[0009] It should be understood that the content described in this section is not intended to identify the key or important features of the embodiments of the present disclosure, nor is it intended to limit the scope of the present disclosure. Other features of the present disclosure will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS
[0010] The accompanying drawings are used to better understand the present solution and do not constitute a limitation of the present disclosure.
[0011] Figure 1 is a schematic diagram of an exemplary system architecture to which a data presentation method and apparatus can be applied according to an embodiment of the present disclosure;
[0012] Figure 2 is a flow chart of a data display method according to an embodiment of the present disclosure;
[0013] Figure 3 is a schematic diagram of a newly added interface according to an embodiment of the present disclosure;
[0014] Figure 4 is a schematic diagram of an editing interface according to an embodiment of the present disclosure;
[0015] Figure 5 is a schematic diagram of a management interface according to an embodiment of the present disclosure;
[0016] Figure 6 is a schematic diagram of a database configuration interface according to an embodiment of the present disclosure;
[0017] Figure 7 is a schematic diagram of an analysis result display page according to an embodiment of the present disclosure;
[0018] Figure 8 is a schematic diagram of a data display device according to an embodiment of the present disclosure;
[0019] Fig. 9 is a schematic diagram of an application architecture for implementing a data display method according to an embodiment of the present disclosure;
[0020] Fig.10 A schematic block diagram of an example electronic device that can be used to implement embodiments of the present disclosure is shown. DETAILED DESCRIPTION
[0021] The following is a description of exemplary embodiments of the present disclosure in conjunction with the accompanying drawings, including various details of the embodiments of the present disclosure to facilitate understanding, which should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the present disclosure. Similarly, for the sake of clarity and conciseness, descriptions of well-known functions and structures are omitted in the following description.
[0022] As the business develops, business-related data reports are also increasing rapidly. Correspondingly, the number of data items that need to be detected in data reports is also gradually increasing. Data items can be detected by using a detection method based on the reporting platform or by using scripts. However, the detection method based on the reporting platform only supports the report output method of the data model. Currently, a large number of data reports are produced using SQL models, and the reporting platform does not support data item detection for data reports produced using SQL models. The maintenance cost of using scripts for data item detection is high, and it usually lacks an intuitive visual interface, making it difficult to display data intuitively. And as the number of data items increases, the management and update of scripts will become more complicated.
[0023] Therefore, in order to realize data display based on data item detection in a concise and efficient manner, the present disclosure provides a data display method, which is schematically described below.
[0024] Figure 1 It is a schematic diagram of an exemplary system architecture to which a data presentation method and apparatus can be applied according to an embodiment of the present disclosure.
[0025] It should be noted that Figure 1 What is shown is merely an example of a system architecture to which the embodiments of the present disclosure can be applied, in order to help those skilled in the art understand the technical content of the present disclosure, but it does not mean that the embodiments of the present 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 a terminal device 101, a terminal device 102, a terminal device 103, a network 104, and a server 105. The network 104 is used to provide a medium for communication links between the terminal devices 101, 102, 103, and the server 105. The network 104 may include various connection types, such as wired and / or wireless communication links, etc.
[0027] Terminal device 101, terminal device 102, and terminal device 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, desktop computers, and the like.
[0028] The server 105 may be a server that provides various services, such as a background management server that provides support for the content browsed by the user using the terminal device 101, the terminal device 102, and the terminal device 103 (for example only). The background management server may analyze and process the received data such as the user request, and feed back the processing results (such as the web page, information, or data obtained or generated according to the user request) to the terminal device. The server may be a cloud server, also known as a cloud computing server or a cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services ("Virtual Private Server", or "VPS" for short). The server may also be a server of a distributed system, or a server combined with a blockchain.
[0029] It should be noted that the data display method provided in the embodiment of the present disclosure can generally be executed by the terminal device 101, the terminal device 102 or the terminal device 103. Accordingly, the data display device provided in the embodiment of the present disclosure can also be set in the terminal device 101, the terminal device 102 or the terminal device 103.
[0030] Alternatively, the data display method provided in the embodiment of the present disclosure may also be generally performed by the server 105. Accordingly, the data display device provided in the embodiment of the present disclosure may generally be arranged in the server 105. The data display method provided in the embodiment of the present disclosure may also be performed by a server or server cluster that is different from the server 105 and can communicate with the terminal device 101, the terminal device 102, the terminal device 103 and / or the server 105. Accordingly, the data display device provided in the embodiment of the present disclosure may also be arranged in a server or server cluster that is different from the server 105 and can communicate with the terminal device 101, the terminal device 102, the terminal device 103 and / or the server 105.
[0031] Understandably, Figure 1 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.
[0032] It is understood that the system architecture of the present invention is described above, and the method of the present invention will be described below. It is also understood that the sequence number of each operation in the following method is only used as a representation of the operation for the purpose of description, and should not be regarded as indicating the execution order of the various operations. Unless explicitly stated, the method does not need to be executed completely in the order shown.
[0033] In the technical solution of the present invention, the collection, storage, use, processing, transmission, provision and disclosure of user personal information involved are in compliance 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 obtaining or collecting the user's personal information.
[0035] Figure 2 is a flow chart 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 input for a detection request is acquired.
[0038] In the disclosed embodiment, 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 according to the business direction pointed to by the data item stored in the database. For example, the business direction is live broadcast, shopping, etc. For the target category of shopping, the data items of the target category may include, for example, the number of product knowledge views, the number of product purchase views, the number of entity class views, etc.
[0039] In the embodiment of the present 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 for retrieving a target data item.
[0040] In the embodiment of the present disclosure, the configuration information includes second information. The second information represents the detection logic of the data item corresponding to the detection request. The detection logic may be a fluctuation calculation of the data item and / or a delay calculation of the data value of the data item.
[0041] In operation S220, a target data item having a target category is determined from a preset data item storage table by parsing the target query sentence format of the first information.
[0042] In the embodiment of the present disclosure, the preset data item storage table is used to store data items in the target query statement format.
[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, the data item storage table stores historical data values of data items.
[0044] The data item storage table is stored in a database. The database may be a relational database that supports SQL statement queries. For example, MySQl database, Oracle database, Palo database, etc. In the database, each data item table has a table name, and the table name of each data item table in the same database is different.
[0045] As can be appreciated, data items can generally be stored in columns in a data item table, while rows record the data values of the data items.
[0046] In operation S230, the target data item is analyzed according to the detection logic to obtain an analysis result.
[0047] For example, the detection logic includes performing a fluctuation calculation on the data value of the data item. The analysis result includes the fluctuation value of the data value of the data item. For another example, the detection logic includes performing a delay calculation on the data value of the data item, and the analysis result includes whether to output the data item.
[0048] In operation S240, the analysis result is displayed.
[0049] In some embodiments, the analysis results may be presented in at least one presentation mode such as a table, a chart, a text report, etc. The present disclosure does not limit this.
[0050] Through the disclosed embodiment, only the configuration information including the first information and the second information is input. Since the data items are stored in the target query statement format, the target data items with the target category can be determined by parsing the first information in the target query statement format, and then the target data items are analyzed using the second information representing the detection logic, thereby realizing the analysis of the target data items. The configuration method is simple and helps to improve the analysis efficiency of the data items.
[0051] It can be understood that the method of the present disclosure is described above, and the method of the present disclosure is further described below in conjunction with a visualization interface.
[0052] Figure 3 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. The 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 the implementation of the present disclosure, the elements of the first information may include at least one of a target category (also known as a business direction), a data retrieval method, a database name (also known as a library name) storing data items, a table name, and SQL.
[0055] The first information may be received by selecting the target library name in the input field 302 corresponding to the "library name" item in the information item field 301. After selecting the target library name, the "sql" item will appear under the "library name" item. Then, a custom-written sql statement may be entered in the input field 32 corresponding to the "sql" item to input the first information. In some implementations of the above operation S210, obtaining the first information input for the detection request may be obtaining the first information input in a custom-written sql statement.
[0056] The first information may be received by selecting a data item table name in the "Table Name" item in the information item column 301 to input the first information. In other implementations of the above operation S210, obtaining the first information input for the detection request may be obtaining a table name input for the detection request, and the first information is obtained by searching a data item table indicated by the data item table name in a data item storage table.
[0057] In the implementation of the present disclosure, the elements of the second information may include at least one of the dimension field of the data item, the data item field of the data item, the production time, the detection level, whether it is in the detection state, the fluctuation threshold, whether to delay the alarm for the data item exceeding the fluctuation threshold, and the alarm delay time.
[0058] To receive the second information, the second information can be input by selecting a dimension in the input column 302 corresponding to the "dimension field" item in the information item column 301 and a data item in the input column 302 corresponding to the "data item field" item.
[0059] In some embodiments, the configuration information may also include the detection name, creator, follower, duty table ID, analysis result receiving ID, alarm robot ID, etc. The specific settings may be set according to actual needs.
[0060] Figure 4 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. The 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 input as a custom target query statement, the first information can be edited by rewriting the custom sql statement in the edit field 402 corresponding to the "sql" item in the information item field 401. When the first information is input as a data item table name, the first information can be edited by reselecting the data item table name in the edit field 402 corresponding to the "table name" item in the information item field 401.
[0063] To edit the second information, elements included in the second information, such as dimension fields, data item fields, etc., may be reselected or input in the editing interface 400 .
[0064] Figure 5 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. The configuration information includes first information and second information. The management interface 500 includes a "new library detection" button 501, a "new SQL detection" button 502 and a display bar 503.
[0066] The user can enter the new page 300 by clicking the “Add a new library check” button 501 or the “Add a new SQL check” button 502 .
[0067] In some embodiments, a button for entering an editing interface and a database configuration interface may also be provided in the management interface 500. The editing interface and the database configuration interface may be entered by clicking on the corresponding icons. For example, the button for entering the editing interface in the display bar 503 may be displayed as the word "Edit".
[0068] Through the embodiments of the present disclosure, by inputting or editing configuration information in a visual interface, the configuration information can be intuitively managed and observed, thereby improving the detection efficiency of data items.
[0069] Figure 6 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 item column 601 and an editing column 602. The information items in the information item column 601 may include parameters that can characterize the address information of the database where the data item storage table is located, such as the database name, host, port, user, password, and database. The address information of the database where the preset data item storage table is located can be determined by entering the specific values of these parameters in the corresponding places of the editing column 602. This allows the user to independently select the database where the target data item is located.
[0071] It can be understood that the visualization interface of the present disclosure is described above, and the method of the present disclosure is further described below.
[0072] In the disclosed embodiment, a visualization interface is displayed; in response to a detection request received through the visualization 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 an analysis result; and the analysis result is displayed.
[0073] In an embodiment of the present disclosure, a target data item is analyzed according to a detection logic to obtain an analysis result, including: determining the detection logic of the 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; analyzing the target data item according to the detection logic based on the data related to the detection logic of the target data item to obtain an analysis result.
[0074] It is understandable that the data item information table can be stored in a database, which can be a relational database that supports SQL statement queries.
[0075] In some embodiments, the database storing the data item information table may also store at least one of the data item storage table and the data item status table at the same time. The description of the data item storage table can be found above and will not be repeated here. The data item information table may store data related to the detection logic of the data item. For example, the data item name, caliber definition, fluctuation threshold, detection level (e.g., day level, hour level), and the output time of the data item, etc. For example, the day-level data item is output in a few days. The data item status table is used to store the analysis results, and the analysis results may include the detection status and status value of the data item. The detection status may include at least one of the data item name, whether the output of the data item is delayed, whether the data value of the data item fluctuates, the fluctuation of the data value of the data item, whether the data item has been detected, etc. In some embodiments, the detection status of at least one data item may be displayed in the analysis results, and the value of the detection status may be obtained through the data item status table.
[0076] In some embodiments, the detection logic may be set according to actual needs. The detection logic may include performing fluctuation calculation on the target data item. When the data value of the target data item exceeds a preset fluctuation threshold, the target data item is output. For another example, the detection logic may include performing delay calculation on the data value of the target data item. When the current time exceeds a preset delay time, the target data item is output.
[0077] It can be understood that the fluctuation calculation can be to calculate the daily year-on-year, weekly year-on-year and other data of the data item. The present disclosure does not limit this and can be set according to actual needs.
[0078] Therefore, the above analysis of the target data item according to the detection logic may include: determining whether the fluctuation value of the data value of the target data item is greater than a preset fluctuation threshold, and / or, when 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 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 result 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 second information can be displayed in the title bar 701, which can be set according to actual needs. For example, it can include business direction and detection name. For another example, it can include detection level, library name, and alarm robot id.
[0082] Data column 702 is used to display the analysis results. The analysis results that can be displayed in data column 702 include at least one of 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. For example, the analysis results displayed in data column 702 include target data items such as product knowledge pageviews (pv, pageview), product purchase pv, etc., and the fluctuation items of the data value of the target data item include day-on-day and week-on-week. The analysis results can be displayed to users in various ways such as emails and text messages to remind users to pay attention to changes in data items in the analysis results and improve work efficiency.
[0083] Figure 8 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 obtain 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, the second information represents the detection logic of the data item corresponding to the detection request, and 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, and 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 item according to the detection logic to obtain the analysis result.
[0088] The display module 840 is used to display the analysis results.
[0089] According to an embodiment of the present disclosure, the acquisition module 810 includes: a statement acquisition submodule, which is used to acquire first information input by custom-writing a target query statement.
[0090] According to an embodiment of the present disclosure, the acquisition module 810 includes: a table name acquisition submodule, used to obtain the data item table name input for the detection request; and a search submodule, used to obtain the first information by searching the data item table indicated by the data item table name from the data item storage table.
[0091] According to an embodiment of the present disclosure, the analysis module 830 includes: a detection logic determination submodule, which is used to determine the detection logic of the target data item from a preset data item information table, and the preset data item information table stores data related to the detection logic of the data item; an analysis submodule, which is 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 an analysis result.
[0092] According to an embodiment of the present disclosure, the target data item is analyzed according to the detection logic, including performing 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; in the case where the target data item requires a delayed alarm, determining whether the current time exceeds the delayed alarm time of the target data item.
[0093] According to an embodiment of the present disclosure, the data display device 800 may also include: an interface display module, used to display a visual interface, the visual interface includes at least one of a management interface, a new addition interface, an editing interface and a database configuration interface; and an acquisition module, which is also used to respond to a detection request received through the visual interface and execute an operation of acquiring configuration information input for the detection request; wherein the management interface is used to display configuration information; the new addition 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 address information of the database where the preset data item storage table is located.
[0094] According to an embodiment of the present disclosure, the second information includes at least one of the following: the name of the database storing the data item; the dimension field of the data item; the field of the data item; the production 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 the alarm for the data item that exceeds the fluctuation threshold; the delay time for delaying the alarm for the data item that exceeds the fluctuation threshold.
[0095] According to an embodiment of the present disclosure, the analysis result includes at least one of the following: a data value of the target data item; a fluctuation value of the data value of the target data item; and whether the data value of the target data item is abnormal.
[0096] Fig. 9 It is a schematic diagram of an application architecture for implementing a data display method according to an embodiment of the present disclosure.
[0097] like Fig. 9 As shown, the application architecture 900 for implementing the data display method may include three layers, namely, from top to bottom, an application layer 910, a service layer 920, and a storage layer 930. The application layer 910, the service layer 920, and the storage layer 930 are connected via a software interface.
[0098] In the embodiment of the present disclosure, the application layer 910 may include a management platform 911 and an alarm push module 912 .
[0099] The management platform 911 may provide the visualization interface described above. The user may input configuration information by operating the visualization interface, or view configuration information on the visualization interface, or edit configuration information on the visualization interface.
[0100] The alarm push module 912 can push the detected abnormal information after executing the detection request. It can also be sent according to the set time. The push method can be determined according to the ID received by the analysis result in the second information.
[0101] In the disclosed embodiment, 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 process requests from the management platform, such as the detection request described above. The management API 921 can also perform compliance checks on the 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] The calculation API 923 can detect the target data item. The target data item is calculated according to the detection logic. The detection logic can be a fluctuation calculation of the target data item, or a delayed calculation of the data value of the target data item. The present disclosure does not limit this. The calculation of the target data item according to the detection logic can refer to the description of the relevant parts above.
[0105] In the embodiment of the present 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 the introduction 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 description above.
[0106] Understandably, Fig. 9 The architecture diagram shown is only an example. The application architecture for implementing the data display method may have more or fewer software modules, or combine certain software modules, or split certain software modules, etc., and the embodiments of the present disclosure are not limited to this.
[0107] According to an embodiment of the present disclosure, the present disclosure also provides an electronic device, a readable storage medium and a computer program product.
[0108] Fig.10 A schematic block diagram of an example electronic device that can be used to implement an embodiment 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 can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present disclosure described and / or required herein.
[0109] like Fig.10 As shown, the device 1000 includes a computing unit 1001, which can perform various appropriate actions and processes according to a computer program stored in a read-only memory (ROM) 1002 or a computer program loaded from a storage unit 1008 into a random access memory (RAM) 1003. In the RAM 1003, various programs and data required for the operation of the device 1000 can also be stored. The computing unit 1001, the ROM 1002, and the RAM 1003 are connected to each other via a bus 1004. An input / output (I / O) interface 1005 is also connected to the bus 1004.
[0110] A number of components in the device 1000 are connected to the I / O interface 1005, including: an input unit 1006, such as a keyboard, a mouse, etc.; an output unit 1007, such as various types of displays, speakers, etc.; a storage unit 1008, such as a disk, an optical disk, etc.; and a communication unit 1009, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 1009 allows the device 1000 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.
[0111] The computing unit 1001 may be a variety of general and / or special 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 dedicated artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, digital signal processors (DSPs), and any appropriate processors, controllers, microcontrollers, etc. The computing unit 1001 performs the various methods and processes described above, such as the data display method. For example, in some embodiments, the data display method may be implemented as a computer software program, which is tangibly contained in a machine-readable medium, such as a storage unit 1008. In some embodiments, part or all of the computer program may be loaded and / or installed on the device 1000 via the ROM 1002 and / or the communication unit 1009. When the computer program is loaded into the RAM 1003 and executed by the computing unit 1001, one or more steps of the data display method described above may be performed. Alternatively, in other embodiments, the computing unit 1001 may be configured to perform the data display method in any other appropriate manner (e.g., by means of firmware).
[0112] Various implementations 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 chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.
[0113] The program code for implementing the method of the present disclosure may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that the program code, when executed by the processor or controller, enables the functions / operations specified in the flow chart and / or block diagram to be implemented. The program code may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.
[0114] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, 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 (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the computer. Other types of devices can also be used to provide interaction with the user; for example, the 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 acoustic input, voice input, or tactile input).
[0116] The systems and techniques described herein may be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, or front-end components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), and the Internet.
[0117] A computer system may include clients and servers. Clients and servers are generally remote from each other and usually interact through a communication network. The relationship of client and server is generated by computer programs running on respective computers and having a client-server relationship to each other.
[0118] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps recorded in this disclosure can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solutions disclosed in this disclosure can be achieved, and this document does not limit this.
[0119] The above specific implementations do not constitute a limitation on the protection scope of the present disclosure. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present disclosure shall be included in the protection scope of the present disclosure.
Claims
1. A data display method, comprising: Acquire 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 a detection logic of the data item corresponding to the detection request, and the first information having a target query statement format; By parsing the target query statement format of the first information, determining the target data item having the target category from a preset data item storage table, the preset data item storage table being used to store data items in the target query statement format; Analyze the target data item according to the detection logic to obtain an analysis result; as well as The analysis results are presented.
2. The method according to claim 1, wherein: The obtaining of first information input for the detection request includes: Get the first information entered with a custom written target query statement.
3. The method according to claim 1, wherein: The obtaining of first information input for the detection request includes: Get the data item table name for the detection request input; The first information is acquired by searching the data item storage table for the data item table indicated by the data item table name.
4. The method according to claim 1, wherein: The step of analyzing the target data item according to the detection logic to obtain an analysis result 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; According to the detection logic, the target data item is analyzed based on data related to the detection logic of the target data item to obtain an analysis result.
5. The method according to claim 4, wherein: The analyzing the target data item according to the detection logic includes at least one of performing the following operations: Determine whether a fluctuation value of the data value of the target data item is greater than a preset fluctuation threshold; In the case that the target data item requires delayed alarm, it is determined whether the current time exceeds the delayed alarm time of the target data item.
6. The method according to claim 1, further comprising: Displaying a visualization interface, wherein the visualization interface includes at least one of a management interface, a new addition interface, an editing interface, and a database configuration interface; as well as In response to a detection request received through the visualization interface, performing the operation of obtaining configuration information input for the detection request; Among them, the management interface is used to display the configuration information; the new interface is used to receive the configuration information; the editing 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.
7. The method according to claim 1, wherein: The second information includes at least one of the following: Dimension fields of the data item; data item fields of the data item; The production time of the data item; a detection level of the data item; whether the data item is in a detection state; a fluctuation threshold of the data item; Whether to delay alarming for data items exceeding the fluctuation threshold; The delay time for delaying the alarm for data items exceeding the fluctuation threshold.
8. 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; A fluctuation value of the data value of the target data item; Whether the data value of the target data item is abnormal.
9. A data display device, comprising: an acquisition module, configured to acquire 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 a 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 the target category from a preset data item storage table by parsing a target query statement format of the first information, wherein the preset data item storage table is used to store data items in the target query statement format; An analysis module, used to analyze the target data item according to the detection logic to obtain an analysis result; as well as The display module is used to display the analysis results.
10. The device according to claim 9, wherein: The acquisition module comprises: The statement acquisition submodule is used to acquire first information input by custom-writing a target query statement.
11. The device according to claim 9, wherein: The acquisition module comprises: A table name acquisition submodule, used to obtain the table name input for the detection request; A search submodule is used to obtain the first information by searching the data item table indicated by the data item table name from the data item storage table.
12. The device according to claim 9, wherein: The analysis module comprises: A detection logic determination submodule, used to determine 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; The analysis submodule is 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 an analysis result.
13. The device according to claim 9, wherein: The analyzing the target data item according to the detection logic includes at least one of performing the following operations: Determine whether a fluctuation value of the data value of the target data item is greater than a preset fluctuation threshold; In the case that the target data item requires delayed alarm, it is determined whether the current time exceeds the delayed alarm time of the target data item.
14. The device according to claim 9, wherein: The device also includes: An interface display module, used to display a visual interface, wherein the visual interface includes at least one of a management interface, a new addition interface, an editing interface, and a database configuration interface; and The acquisition module is further used to execute the operation of acquiring the configuration information input for the detection request in response to the detection request received through the visual interface; Among them, the management interface is used to display the configuration information; the new interface is used to receive the configuration information; the editing 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.
15. The device according to claim 9, wherein: The second information includes at least one of the following: the name of the database storing the data item; Dimension fields of the data item; data item fields of the data item; The production time of the data item; a detection level of the data item; whether the data item is in a detection state; a fluctuation threshold of the data item; Whether to delay alarming for data items exceeding the fluctuation threshold; The delay time for delaying the alarm for data items exceeding the fluctuation threshold.
16. The device according to claim 9, wherein: The analysis results include at least one of the following: The data value of the target data item; A fluctuation value of the data value of the target data item; Whether the data value of the target data item is abnormal.
17. 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, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method according to any one of claims 1 to 8.
18. A non-transitory computer-readable storage medium storing computer instructions, wherein: The computer instructions are used to cause the computer to execute the method according to any one of claims 1-8.
19. A computer program product, comprising a computer program, which, when executed by a processor, implements the method according to any one of claims 1 to 8.
Citation Information
Patent Citations
Method and device for identifying abnormal data of monitoring index data
CN111984503A
Index anomaly detection method and device, equipment and storage medium
CN113326177A
Database query method and device, storage medium and electronic equipment
CN114996554A
Early warning method, device and equipment and computer readable storage medium
CN116483820A
Cloud monitoring and analysis method and system
WO2024002327A1