A data visualization method, device and system

Through standardized processing and visual controls, multiple types of charts are generated, which solves the problems of redundancy and low efficiency in massive data display, and realizes efficient data visualization display.

CN113761082BActive Publication Date: 2025-01-14INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202111060520.8
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-09-10
Publication Date
2025-01-14
Estimated Expiration
2041-09-10

AI Technical Summary

Technical Problem

When the existing technology faces the multi-dimensional display of massive data, the code redundancy is large, the development and display efficiency is low, and it is difficult to adapt to the needs of large and multi-type data visualization.

Method used

By obtaining the original business data, processing it in a standardized format, and using visual controls to generate multi-type business data charts, using data automatic loading and setting module, data standardization module and batch rendering generation chart module, to realize batch visual display of massive data.

Benefits of technology

It greatly reduces the amount of code redundancy, improves development and display efficiency, is suitable for visual display of massive data, and supports rapid iterative development.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN113761082B_ABST
    Figure CN113761082B_ABST
Patent Text Reader

Abstract

The embodiments of the present invention provide a data visualization method, device and system, which can be used in the field of artificial intelligence technology. The method includes: obtaining original business data; performing standardization processing on the original business data according to a set standardized format to generate standardized business data; using visualization controls, visually displaying the standardized business data according to different business types, generating multi-type business data charts, and batch visualization of massive data, which greatly reduces code redundancy and improves development efficiency and display efficiency.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, in particular to the field of artificial intelligence technology, and more particularly to a data visualization method, device and system. Background Art

[0002] At present, when it is necessary to display massive data in multiple dimensions, it is necessary to understand the information, scale, characteristics, connections, etc. of the massive data, and then evaluate whether the data can support the corresponding visualization. Secondly, determine the chart layout, chart type, page style characteristics, and display the massive data in a visual way. In related technologies, various indicators are analyzed one by one to obtain their characteristics, types, and meanings, and then visualized. However, the above method is only suitable for the analysis and display of a small amount of data. If the amount of data is huge and the types are many, the code redundancy of the above method is large, and the development and display efficiency is low. Summary of the invention

[0003] One object of the present invention is to provide a data visualization method, which can perform batch visualization display of massive data, greatly reducing the amount of code redundancy, thereby improving development efficiency and display efficiency. Another object of the present invention is to provide a data visualization device. Another object of the present invention is to provide a data visualization system. Another object of the present invention is to provide a computer-readable medium. Another object of the present invention is to provide a computer device.

[0004] In order to achieve the above objectives, the present invention discloses a data visualization method, comprising:

[0005] Optimize the acquisition of original business data;

[0006] Standardize the original business data according to the set standardized format to generate standardized business data;

[0007] Through visualization controls, standardized business data can be visualized according to different business types, generating multi-type business data charts.

[0008] Preferably, before obtaining the original business data, the method further includes:

[0009] Determine whether the current time conditions meet the set start conditions;

[0010] If so, determine whether the current time reaches the set acquisition time;

[0011] If the current time reaches the acquisition time, continue to execute the steps of acquiring the original business data.

[0012] Preferably, obtaining original business data includes:

[0013] The original business data is obtained from the set message queue, which stores the original business data of the data source.

[0014] Preferably, the opening condition includes a set opening time;

[0015] Determine whether the current time conditions meet the set start conditions, including:

[0016] Determine whether the current time reaches the start time;

[0017] If so, determine that the opening condition is met;

[0018] If not, it is determined that the opening condition is not met.

[0019] Preferably, before obtaining the original business data, the method further includes:

[0020] Count the amount of data in the statistical data source;

[0021] Determine whether the data quantity is greater than or equal to the set quantity threshold;

[0022] If yes, continue to perform the steps of obtaining original business data;

[0023] If not, repeat the steps to count the number of data in the statistical data source.

[0024] Preferably, the standardized format includes standard attributes of data and a standard output format;

[0025] Standardize the original business data according to the set standardized format to generate standardized business data, including:

[0026] According to the data standard attributes, the corresponding attribute data is extracted from the original business data;

[0027] Output attribute data according to standard output format to generate standardized business data.

[0028] Preferably, the standardized business data is visualized according to different business types through visualization controls to generate multi-type business data charts, including:

[0029] Generate business data charts corresponding to different business types based on standardized business data through visualization controls;

[0030] Based on the set reference coordinates, the business data charts corresponding to different business types are visualized in order from left to right to generate multi-type business data charts.

[0031] Preferably, based on the reference coordinates, business data charts corresponding to different business types are visualized in order from left to right to generate multi-type business data charts, including:

[0032] Check whether the number of horizontal business data charts is greater than the set horizontal number threshold;

[0033] If so, switch the business data chart corresponding to the quantity greater than the horizontal quantity threshold to the next row;

[0034] The visualization is performed in order from left to right, and the step of detecting whether the number of horizontal business data charts is greater than a set horizontal number threshold is repeated.

[0035] The present invention also discloses a data visualization system, comprising:

[0036] The system includes a data automatic loading setting module, a data standardization module, and a batch rendering and chart generation module;

[0037] The data automatic loading setting module is used to obtain original business data;

[0038] The data standardization module is used to standardize the original business data according to the set standardized format to generate standardized business data;

[0039] The batch rendering chart generation module is used to visualize standardized business data according to different business types through visualization controls and generate multi-type business data charts.

[0040] Preferably, the data automatic loading setting module also includes a scheduled task viewing and editing setting submodule;

[0041] The scheduled task viewing and editing setting submodule is used to receive update operations input by the user, and the update operation includes updating the acquisition time;

[0042] The update acquisition time is determined as the acquisition time.

[0043] The present invention also discloses a data visualization device, comprising:

[0044] An acquisition unit, used for acquiring original business data;

[0045] A standardization unit is used to perform standardization processing on the original business data according to a set standardized format to generate standardized business data;

[0046] The display unit is used to visualize the standardized business data according to different business types through visual controls and generate multi-type business data charts.

[0047] The present invention also discloses a computer-readable medium on which a computer program is stored. When the program is executed by a processor, the method described above is implemented.

[0048] The present invention also discloses a computer device, including a memory and a processor, wherein the memory is used to store information including program instructions, the processor is used to control the execution of program instructions, and the processor implements the above method when executing the program.

[0049] The present invention obtains original business data; performs standardization processing on the original business data according to a set standardized format to generate standardized business data; uses visualization controls to visualize the standardized business data according to different business types, generates multi-type business data charts, and can perform batch visualization of massive data, greatly reducing code redundancy, thereby improving development efficiency and display efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0050] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0051] Figure 1 A structural diagram of a data visualization system provided by an embodiment of the present invention;

[0052] Figure 2 A flowchart of a data visualization method provided by an embodiment of the present invention;

[0053] Figure 3 A flowchart of another data visualization method provided by an embodiment of the present invention;

[0054] Figure 4 A business data chart corresponding to a net profit provided by an embodiment of the present invention;

[0055] Figure 5 A schematic diagram of a multi-type business data chart provided by an embodiment of the present invention;

[0056] Figure 6 A schematic diagram of the structure of a data visualization device provided by an embodiment of the present invention;

[0057] Figure 7 A schematic diagram of the structure of a computer device provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0058] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0059] It should be noted that the data visualization method, device and system disclosed in the present application can be used in the field of artificial intelligence technology, and can also be used in any field other than the field of artificial intelligence technology. The application field of the data visualization method, device and system disclosed in the present application is not limited.

[0060] In order to facilitate the understanding of the technical solution provided by this application, the relevant contents of the technical solution of this application are first explained below. When visually displaying multi-type and multi-dimensional indicator data, the traditional method is to analyze the characteristics, types, and meanings of various indicators one by one and then display them visually. When faced with the need to visualize massive data, due to the large amount of data and many types, the workload of the traditional method will increase exponentially, and the code redundancy is large, resulting in low display efficiency and development efficiency, which is not conducive to the rapid iterative development of the project, and is not suitable for visual display of massive data.

[0061] In order to solve the above technical problems, Figure 1 A structural diagram of a data visualization system provided by an embodiment of the present invention is shown in FIG. Figure 1 As shown, the system includes a data automatic loading setting module 100, a data standardization module 200 and a batch rendering chart generation module 300. The data automatic loading setting module 100 is connected to the data standardization module 200, and the data standardization module 200 is connected to the batch rendering chart generation module 300.

[0062] The data automatic loading setting module 100 is a timed task setting list, through which a variety of different data sources can be set, including but not limited to Oracle database, MySql database and SQLServer database, and different loading tasks can be set for different data sources, so as to control different loading tasks in real time. The data automatic loading setting module 100 is used to obtain original business data, which is the data in the data source.

[0063] The data standardization module 200 is used to perform standardization processing on the original business data according to the set standardization format to generate standardized business data. The standardization format includes indicator name, indicator code, indicator classification, currency, unit, legend, etc.

[0064] The batch rendering chart generation module 300 is used to visualize the standardized business data according to different business types through visualization controls and generate multi-type business data charts.

[0065] In the embodiment of the present invention, the data automatic loading setting module 100 further includes a scheduled task viewing and editing setting submodule 110 .

[0066] The scheduled task viewing and editing setting submodule 110 is used to receive the update operation input by the user, and the update operation includes updating the acquisition time. The updated acquisition time is determined as the acquisition time. The scheduled task viewing and editing submodule 110 is also used to view the task execution status; it is also used to modify the triggering condition of the execution task. For example, if a task is executed according to a time period, it can be modified to be manually triggered through the scheduled task viewing and editing setting submodule 110.

[0067] In the embodiment of the present invention, the scheduled task viewing and editing setting submodule 110 also has a task timeout interruption function, a task failure re-execution function and a task failure warning function. The task timeout interruption function is set to interrupt the task execution when the execution time of the task is greater than the set timeout duration, indicating that the task has timed out. Among them, the timeout duration can be set according to the actual situation, and the embodiment of the present invention does not limit this. The task failure re-execution function is set to when the task fails to execute, the number of failures is added by 1; if the number of failures after adding 1 is less than the set failure threshold, the task is re-executed; if the number of failures after adding 1 is greater than or equal to the set failure threshold, the task is terminated. Among them, the initial value of the number of failures is set to 1, and the failure threshold can be processed according to the actual situation, and the embodiment of the present invention does not limit this. The task failure warning function is set to notify the staff to handle when the task fails to execute. The staff can be notified by email or by text message. The embodiment of the present invention does not limit the notification method of the staff.

[0068] In the embodiment of the present invention, the data automatic loading setting module 100 further includes a scheduled task execution strategy setting submodule 120 and a scheduled task start and stop setting submodule 130 .

[0069] In the embodiment of the present invention, the task triggering strategy can be set through the scheduled task execution strategy setting submodule 120, including but not limited to Cron triggering, time period triggering, manual triggering, parent-child task triggering, etc. It is worth noting that the specific task triggering strategy can be set according to the needs of the project task, and the embodiment of the present invention does not limit this.

[0070] In the embodiment of the present invention, the scheduled task execution strategy setting submodule 120 also has a task blocking processing strategy, which is used to deal with task blocking caused by high-frequency execution of relatively intensive tasks within a certain period of time, and provides a variety of blocking processing strategies, including but not limited to: task serial execution, ending blocked tasks and task re-execution. Task serial execution is to schedule tasks for serial execution; ending blocked tasks is to end the blocked tasks; task re-execution is to re-execute the blocked tasks. It is worth noting that other blocking processing strategies can also be adopted, and the embodiment of the present invention does not limit this.

[0071] In an embodiment of the present invention, the start and stop of the loading task can be set according to the needs of the project task through the scheduled task start and stop setting submodule 130. The start and stop time can be set, and the quantity threshold can be set. By comparing the number of data in the data source with the quantity threshold, the start and stop of the loading task can be controlled.

[0072] In the technical solution provided by the embodiment of the present invention, original business data is obtained; the original business data is standardized according to a set standardized format to generate standardized business data; the standardized business data is visualized according to different business types through visualization controls, and multi-type business data charts are generated, which can perform batch visualization of massive data, greatly reduce code redundancy, and thus improve development efficiency and display efficiency.

[0073] It is worth mentioning that Figure 1 The data visualization system shown is also applicable to Figure 2 or Figure 3 The data visualization method is not described here.

[0074] The following takes a data visualization device as an example to illustrate the implementation process of the data visualization method provided by the embodiment of the present invention. It is understandable that the execution subject of the data visualization method provided by the embodiment of the present invention includes but is not limited to the data visualization device.

[0075] Figure 2 A flowchart of a data visualization method provided by an embodiment of the present invention is shown in FIG. Figure 2 As shown, the method includes:

[0076] Step 101: Obtain original business data.

[0077] Step 102: Standardize the original business data according to the set standardized format to generate standardized business data.

[0078] Step 103: Visualize the standardized business data according to different business types through visualization controls to generate multi-type business data charts.

[0079] In the technical solution provided by the embodiment of the present invention, original business data is obtained; the original business data is standardized according to a set standardized format to generate standardized business data; the standardized business data is visualized according to different business types through visualization controls, and multi-type business data charts are generated, which can perform batch visualization of massive data, greatly reduce code redundancy, and thus improve development efficiency and display efficiency.

[0080] Figure 3 A flowchart of another data visualization method provided by an embodiment of the present invention is as follows: Figure 3 As shown, the method includes:

[0081] Step 201, determine whether the current time condition meets the set start condition; if so, execute step 202; if not, continue to execute step 203.

[0082] In the embodiment of the present invention, each step is performed by a data visualization device.

[0083] In the embodiment of the present invention, the start condition includes the set start time, and the current time condition includes the current time. Specifically, it is determined whether the current time reaches the start time; if so, it is determined that the start condition is met, and step 202 is continued; if not, it is determined that the start condition is not met, and step 203 is continued to further determine whether to start the task.

[0084] Step 202, determine whether the current time reaches the set acquisition time, if so, execute step 205; if not, repeat step 202.

[0085] In the embodiment of the present invention, the acquisition time can be set according to actual conditions, and the present invention does not limit the specific setting of the acquisition time.

[0086] In an embodiment of the present invention, if the current time condition satisfies the start time and the current time reaches the acquisition time, it indicates that the trigger task strategy for task execution is met, the task execution is triggered, and step 205 is executed; if the current time condition satisfies the start time but the current time does not reach the acquisition time, it indicates that the trigger task strategy for task execution is not met, the loading task cannot be executed, and step 202 is repeated until the current time reaches the set acquisition time.

[0087] In the embodiment of the present invention, the task triggering strategy includes but is not limited to Cron triggering, time cycle triggering, manual triggering, parent-child task triggering, etc. It is worth noting that the specific task triggering strategy can be set according to the needs of the project task, and the embodiment of the present invention does not limit this. For example: set the task triggering strategy to Cron triggering, set the loading task to start execution at the set acquisition time, and the setting format of the acquisition time follows the Cron expression syntax. The Cron expression is {seconds}{minutes}{hours}{days}{months}{weeks}{years}, and the acquisition time is set according to the Cron expression. After the Cron trigger is set, the loading task can be executed when the current time reaches the acquisition time, and the execution status of the loading task is returned.

[0088] Step 203: Count the amount of data in the data source.

[0089] In the embodiment of the present invention, different data sources are provided, including but not limited to Oracle database, MySql database and SQL Server database.

[0090] In the embodiment of the present invention, the amount of data in the statistical data source specifically refers to the total amount of data in all statistical data sources.

[0091] Step 204 , determine whether the data quantity is greater than or equal to the set quantity threshold, if so, execute step 205 ; if not, execute step 203 .

[0092] In an embodiment of the present invention, the quantity threshold can be set according to actual conditions. If the amount of data is greater than or equal to the quantity threshold, it indicates that a large amount of data that needs to be loaded has accumulated in the data source, and step 205 is continued; if the amount of data is less than the quantity threshold, it indicates that the amount of data that needs to be loaded in the data source is small, and step 203 is continued.

[0093] Furthermore, if the number of data is greater than or equal to the set number threshold, the trigger time point is recorded; the trigger time points recorded multiple times are averaged to obtain the average trigger time point, which provides a basis for the subsequent update of the start time. The average trigger time point can be determined as the start time to update the start time, thereby reducing memory pressure.

[0094] In an embodiment of the present invention, if a large amount of data that needs to be loaded has accumulated in the data source, in order to avoid a long time or low efficiency when triggering task execution, the task execution is triggered even if the task triggering strategy is not met, thereby improving the task execution efficiency and reducing the task execution time.

[0095] Step 205: Obtain original business data.

[0096] Specifically, the original business data is obtained from a set message queue, and the message queue stores the original business data of the data source. The data source stores the original business data in the message queue, and the data visualization device obtains the original business data from the message queue for subsequent processing.

[0097] In an embodiment of the present invention, by setting up a message queue for a data source to store original business data and for a data visualization device to obtain original business data, the data source and the data visualization device can be decoupled, and the asynchronous operation of the data source and the data visualization operation can improve the response speed.

[0098] Step 206: Standardize the original business data according to the set standardized format to generate standardized business data.

[0099] In the embodiment of the present invention, the standardized format includes data standard attributes and a standard output format.

[0100] In the embodiment of the present invention, step 206 specifically includes:

[0101] Step 2061: extract corresponding attribute data from the original business data according to the data standard attributes.

[0102] In the embodiment of the present invention, the data standard attributes include but are not limited to the indicator name, indicator code, indicator classification, currency, unit, and legend. Among them, the indicator name includes setting the indicator name of various indicator data; the indicator code includes setting the indicator code of various indicator data; the indicator classification includes setting the indicator classification to which the various indicator data belongs, such as: domestic and foreign currency deposits, RMB deposits, etc.; the currency includes setting the currency type of various indicator data, such as: RMB, US dollars, Japanese yen, etc.; the unit includes setting the unit of various indicator data, such as: yuan, US dollars, British pounds, etc.; the legend includes setting the legend when displaying various indicator data charts, such as: balance, increment, etc. In the embodiment of the present invention, the data standard attributes lay a foundation for the standardized data format for the output of standardized business data.

[0103] Specifically, the original business data is classified and sorted according to fields such as indicator name, indicator code, indicator classification, currency, unit and legend to obtain corresponding attribute data.

[0104] Step 2062: Output the attribute data in a standard output format to generate standardized business data.

[0105] In the embodiment of the present invention, the standard output format can be set according to the actual situation, and the present invention does not limit this. Specifically, the attribute data is converted into a format through the API interface to generate standardized business data. For example: the indicator name is net profit, the indicator code is 020010003009, the indicator category is 719, the currency is RMB, the unit is 100 million yuan, and the legend is balance. The standard output format is the json format shown below:

[0106] [{

[0107] "roundUnit": "100000000,100000000",

[0108] "indicatorName": "Net Profit", / / Indicator Name

[0109] "xAxis": [ / / horizontal axis

[0110] "202006",

[0111] "202009",

[0112] "202012",

[0113] "202103"

[0114] ],

[0115] "unit": [ / / Unit

[0116] "100 million yuan",

[0117] "100 million yuan"

[0118] ],

[0119] "legend": [ / / Legend

[0120] "Balance",

[0121] ],

[0122] "indicatorCode": "020010003009", / / Indicator code

[0123] "currency": "710", / / Indicator classification

[0124] "id": "A020010003009710",

[0125] "legendFir": [ / / Vertical axis

[0126] "300",

[0127] "400",

[0128] "500",

[0129] "600" ]

[0131] }, ...... ]

[0134] Step 207: Visually display the standardized business data according to different business types through visualization controls to generate multi-type business data charts.

[0135] In the embodiment of the present invention, step 207 specifically includes:

[0136] Step 2071: Generate business data charts corresponding to different business types based on standardized business data through visualization controls.

[0137] In the embodiment of the present invention, business data charts corresponding to different business types are generated according to standardized business data through the visualization controls of the visualization chart library (ECharts). Among them, the business type corresponds to the indicator name. The visualization controls include bar charts, line charts and pie charts. It is worth noting that the specific selection of visualization controls depends on actual needs, and the embodiment of the present invention does not limit this. Figure 4 A business data chart corresponding to a net profit provided by an embodiment of the present invention, such as Figure 4 As shown, the visualization control is a bar chart with time on the horizontal axis and balance on the vertical axis. Figure 4 It can be seen that net profit increases with time.

[0138] Step 2072: Based on the set reference coordinates, business data charts corresponding to different business types are visualized in order from left to right to generate multi-type business data charts.

[0139] In the embodiment of the present invention, the reference coordinates are located on the page, and the business type corresponds to the indicator name.

[0140] Specifically, detect whether the number of horizontal business data charts is greater than the set horizontal number threshold; if so, switch the business data charts corresponding to the number greater than the horizontal number threshold to the next row, visualize them in order from left to right, and repeat the step of detecting whether the number of horizontal business data charts is greater than the set horizontal number threshold; if not, continue to visualize them in order from left to right, and repeat the step of detecting whether the number of horizontal business data charts is greater than the set horizontal number threshold.

[0141] Figure 5A schematic diagram of a multi-type business data chart provided by an embodiment of the present invention, such as Figure 5 As shown in the figure, the horizontal quantity threshold is set to 3, the reference coordinate is (0, 0), and the business data charts corresponding to different business types are rendered from left to right based on the reference coordinate (0, 0) to visualize the business data charts; each row displays business data charts corresponding to 3 business types, and after rendering the business data charts corresponding to three types, switch to the next row and visualize them in order from left to right until all business data charts corresponding to all types are displayed. Figure 5 As shown, the multi-type business data charts include business data charts corresponding to the total RMB deposit increment, business data charts corresponding to the daily average RMB deposit increment, business data charts corresponding to the RMB loan increment, business data charts corresponding to the total foreign currency deposit increment and business data charts corresponding to the foreign currency loan increment. The balance is represented by a bar chart, with the left vertical axis representing 100 million yuan; the increment is represented by a line chart, with the right vertical axis representing the percentage; and the horizontal axis represents time. Figure 5 As shown in the figure, in a business data chart corresponding to a type, a line chart and a bar chart are used to display the balance and increment at the same time, making the page display smoother and quickly displaying multiple business data charts, greatly reducing code redundancy. The amount of code can be reduced by more than 90%, improving development efficiency, allowing the project to be quickly launched, and reducing the memory usage of the browser.

[0142] In the technical solution of the data visualization method provided by the embodiment of the present invention, original business data is obtained; the original business data is standardized according to a set standardized format to generate standardized business data; through visualization controls, the standardized business data is visualized according to different business types, and multi-type business data charts are generated, which can perform batch visualization of massive data, greatly reducing code redundancy, thereby improving development efficiency and display efficiency.

[0143] Figure 6 A schematic diagram of the structure of a data visualization device provided by an embodiment of the present invention, wherein the device is used to execute the above-mentioned data visualization method, such as Figure 6 As shown, the device includes: an acquisition unit 11, a standardization unit 12 and a display unit 13.

[0144] The acquisition unit 11 is used to acquire original service data.

[0145] The standardization unit 12 is used to perform standardization processing on the original business data according to the set standardized format to generate standardized business data.

[0146] The display unit 13 is used to display the standardized business data visually according to different business types through visual controls, and generate multi-type business data charts.

[0147] In the embodiment of the present invention, the device further includes: a first judgment unit 14 and a second judgment unit 15 .

[0148] The first judgment unit 14 is used to judge whether the current time condition meets the set start condition; if so, the second judgment unit 15 is used to judge whether the current time reaches the set acquisition time; if the current time reaches the acquisition time, the acquisition unit 11 is triggered to continue to execute the step of acquiring the original business data.

[0149] In the embodiment of the present invention, the acquisition unit 11 is specifically used to acquire original business data from a set message queue, and the message queue stores the original business data of the data source.

[0150] In the embodiment of the present invention, the first judgment unit 14 is specifically used to judge whether the current time reaches the start time; if so, determine that the start condition is met; if not, determine that the start condition is not met.

[0151] In the embodiment of the present invention, the device further includes: a statistical unit 16 and a third judgment unit 17 .

[0152] The statistical unit 16 is used to count the amount of data in the statistical data source;

[0153] The third judgment unit 17 is used to judge whether the data quantity is greater than or equal to the set quantity threshold; if so, trigger the acquisition unit 11 to continue to execute the step of acquiring the original business data; if not, trigger the statistical unit 16 to repeat the step of calculating the data quantity in the statistical data source.

[0154] In the embodiment of the present invention, the standardization unit 12 is specifically used to extract corresponding attribute data from the original business data according to the data standard attributes; output the attribute data according to the standard output format, and generate standardized business data.

[0155] In an embodiment of the present invention, the display unit 13 is specifically used to generate business data charts corresponding to different business types according to standardized business data through visualization controls; based on the set reference coordinates, the business data charts corresponding to different business types are visualized in order from left to right to generate multi-type business data charts.

[0156] In an embodiment of the present invention, the display unit 13 is further specifically used to detect whether the number of horizontal business data charts is greater than a set horizontal number threshold; if so, the business data charts corresponding to the number greater than the horizontal number threshold are switched to the next row; the visual display is performed in order from left to right, and the step of detecting whether the number of horizontal business data charts is greater than the set horizontal number threshold is repeated.

[0157] In the scheme of the embodiment of the present invention, original business data is obtained; the original business data is standardized according to a set standardized format to generate standardized business data; through visualization controls, the standardized business data is visualized according to different business types, and multi-type business data charts are generated, which can perform batch visualization of massive data, greatly reducing code redundancy, thereby improving development efficiency and display efficiency.

[0158] The systems, devices, modules or units described in the above embodiments may be implemented by computer chips or entities, or by products with certain functions. A typical implementation device is a computer device, and specifically, the computer device may be, for example, a personal computer, a laptop computer, a cellular phone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.

[0159] An embodiment of the present invention provides a computer device, including a memory and a processor, the memory is used to store information including program instructions, the processor is used to control the execution of the program instructions, and the program instructions, when loaded and executed by the processor, implement the steps of the embodiment of the above-mentioned data visualization method. For a specific description, please refer to the embodiment of the above-mentioned data visualization method.

[0160] Reference below Figure 7 , which shows a schematic diagram of the structure of a computer device 600 suitable for implementing an embodiment of the present application.

[0161] like Figure 7 As shown, the computer device 600 includes a central processing unit (CPU) 601, which can perform various appropriate tasks and processes according to a program stored in a read-only memory (ROM) 602 or a program loaded from a storage part 608 to a random access memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the computer device 600 are also stored. The CPU 601, the ROM 602, and the RAM 603 are connected to each other through a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.

[0162] The following components are connected to the I / O interface 605: an input section 606 including a keyboard, a mouse, etc.; an output section 607 including a cathode ray tube (CRT), a liquid crystal feedback device (LCD), etc., and a speaker, etc.; a storage section 608 including a hard disk, etc.; and a communication section 609 including a network interface card such as a LAN card, a modem, etc. The communication section 609 performs communication processing via a network such as the Internet. A drive 610 is also connected to the I / O interface 605 as needed. A removable medium 611, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 610 as needed, so that a computer program read therefrom is installed as needed as the storage section 608.

[0163] In particular, according to an embodiment of the present invention, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present invention includes a computer program product, which includes a computer program tangibly contained on a machine-readable medium, and the computer program includes program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through the communication part 609, and / or installed from the removable medium 611.

[0164] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.

[0165] For the convenience of description, the above device is described in various units according to their functions. Of course, when implementing the present application, the functions of each unit can be implemented in the same or multiple software and / or hardware.

[0166] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0167] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0168] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0169] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0170] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems or computer program products. Therefore, the present application may take the form of a complete hardware embodiment, a complete software embodiment or an embodiment combining software and hardware. Moreover, the present application may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes.

[0171] The present application may be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform specific tasks or implement specific abstract data types. The present application may also be practiced in distributed computing environments where tasks are performed by remote processing devices connected through a communication network. In a distributed computing environment, program modules may be located in local and remote computer storage media, including storage devices.

[0172] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0173] The above is only an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims

1. A data visualization method, characterized in that: The method comprises: Determine whether the current time conditions meet the set start conditions; If so, determine whether the current time reaches the set acquisition time; If the current time reaches the acquisition time, the trigger task strategy for task execution is satisfied, and the original business data is acquired; wherein the trigger task strategy includes Cron trigger, time period trigger, manual trigger, and parent-child task trigger; Standardizing the original business data according to a set standardized format to generate standardized business data; wherein the standardized format includes an indicator name, an indicator code, an indicator classification, a currency, a unit and a legend; Through the visualization controls of the visualization chart library, the standardized business data is visualized according to different business types to generate multi-type business data charts; wherein the business type corresponds to the indicator name; the visualization controls include bar charts, line charts and pie charts.

2. The data visualization method according to claim 1, characterized in that: The obtaining of the original business data includes: The original business data is obtained from a set message queue, in which the original business data of the data source is stored.

3. The data visualization method according to claim 1, characterized in that: The opening condition includes a set opening time; The determining whether the current time condition satisfies the set start condition includes: Determine whether the current time reaches the start time; If so, determining that the activation condition is met; If not, it is determined that the activation condition is not met.

4. The data visualization method according to claim 1, characterized in that: Before obtaining the original business data, the method further includes: Count the amount of data in the statistical data source; Determine whether the data quantity is greater than or equal to a set quantity threshold; If yes, continue to execute the step of obtaining the original business data; If not, repeat the step of calculating the amount of data in the statistical data source.

5. The data visualization method according to claim 1, characterized in that: The standardized format includes data standard attributes and standard output format; The step of performing standardization processing on the original business data according to the set standardized format to generate standardized business data includes: According to the data standard attributes, extracting corresponding attribute data from the original business data; The attribute data is output according to the standard output format to generate the standardized business data.

6. The data visualization method according to claim 1, characterized in that: The standardized business data is visualized according to different business types through the visualization controls of the visualization chart library to generate multiple types of business data charts, including: Generate business data charts corresponding to different business types based on the standardized business data through visual controls; Based on the set reference coordinates, the business data charts corresponding to the different business types are visualized in order from left to right to generate multi-type business data charts.

7. The data visualization method according to claim 6, characterized in that: Based on the set reference coordinates, the business data charts corresponding to the different business types are visually displayed in order from left to right to generate multi-type business data charts, including: Check whether the number of horizontal business data charts is greater than the set horizontal number threshold; If so, switching the business data chart corresponding to the quantity greater than the horizontal quantity threshold to the next row; The visualization is performed in order from left to right, and the step of detecting whether the number of horizontal business data charts is greater than a set horizontal number threshold is repeated.

8. A data visualization system, characterized in that: The system includes a data automatic loading setting module, a data standardization module and a batch rendering and chart generation module; The data automatic loading setting module is used for: Determine whether the current time conditions meet the set start conditions; If so, determine whether the current time reaches the set acquisition time; If the current time reaches the acquisition time, the trigger task strategy for task execution is satisfied, and the original business data is acquired; wherein the trigger task strategy includes Cron trigger, time period trigger, manual trigger, and parent-child task trigger; The data standardization module is used to perform standardization processing on the original business data according to the set standardized format to generate standardized business data; the standardized format includes indicator name, indicator code, indicator classification, currency, unit and legend; The batch rendering chart generation module is used to visualize the standardized business data according to different business types through the visualization controls of the visualization chart library, and generate multi-type business data charts; wherein the business type corresponds to the indicator name; the visualization controls include bar charts, line charts and pie charts.

9. The data visualization system according to claim 8, characterized in that: The data automatic loading setting module also includes a scheduled task viewing and editing setting submodule; The scheduled task viewing and editing setting submodule is used to receive an update operation input by a user, wherein the update operation includes updating the acquisition time; The update acquisition time is determined as the acquisition time.

10. A data visualization device, characterized in that: The device comprises: A first judgment unit, used to judge whether the current time condition reaches the set acquisition time; If yes, the second judgment unit is used to judge that the current time reaches the acquisition time, then the trigger task strategy of task execution is satisfied, and the original business data is acquired; wherein the trigger task strategy includes Cron trigger, time period trigger, manual trigger and parent-child task trigger; A standardization unit, used to perform standardization processing on the original business data according to a set standardized format to generate standardized business data; wherein the standardized format includes an indicator name, an indicator code, an indicator classification, a currency, a unit and a legend; A display unit is used to visualize the standardized business data according to different business types through the visualization controls of the visualization chart library, and generate multi-type business data charts; wherein the business type corresponds to the indicator name; the visualization controls include bar charts, line charts and pie charts.

11. A computer readable medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the data visualization method according to any one of claims 1 to 7 is implemented.

12. A computer device comprising a memory and a processor, wherein the memory is used to store information including program instructions, and the processor is used to control the execution of the program instructions, characterized in that: When the program instructions are loaded and executed by the processor, the data visualization method according to any one of claims 1 to 7 is implemented.

Citation Information

Patent Citations

  • Realization method and apparatus for data real-time collection and visualization

    CN108549671A