Data visualization processing method, device, equipment and medium

Abstract

The present application belongs to the field of big data, and particularly relates to a data visualization processing method, device, equipment and medium. The present application aims to solve the problem of high difficulty and low efficiency of generating a visualization data chart by using the existing data visualization method. The data visualization processing method, device, equipment and medium provided by the present application determine the dimensions sent to the terminal device by the server according to the metric information, function information and graph database sent by the terminal device. The user sends the dimension information to the server through the terminal device. The server determines the filter according to the dimension information, metric information and graph database and sends it to the terminal device. The user sends the filter information to the server through the terminal device. The server generates the visualization data chart according to the metric information, function information, dimension information and filter information and the graph database and sends it to the terminal device to show it to the user, thereby reducing the difficulty of generating the visualization data chart and improving the efficiency of generating the visualization data chart.

Description

Technical Field

[0001] This invention relates to the field of big data, specifically to a data visualization processing method, apparatus, device, and medium. Background Technology

[0002] With the rapid development of society, we have entered the era of big data. Users need to use various data to create charts to visualize the data. Through the display of charts, the changing trends and proportions of the data can be reflected intuitively, making it easier for people to understand.

[0003] In existing technologies, users preprocess the data to be used to generate charts by writing Structured Query Language (SQL) code. The preprocessed data and SQL code are then input into a server. The server obtains the corresponding measures and dimensions, as well as the correspondence between measures and dimensions, based on the preprocessed data and SQL code. The server sends selectable measures to the terminal for display to the user. The user selects the desired measure, and the terminal sends the selected measure to the server. The server finds the corresponding dimension for this measure based on the user's selected measure and the correspondence between measures and dimensions, and then sends the dimension to the terminal for display to the user. The user selects the desired dimension, and the terminal sends the selected dimension to the server. The server processes the data based on the user's selected measures and dimensions to generate a chart, and then sends the chart to the terminal for display to the user.

[0004] In summary, existing data visualization methods require users to preprocess data using SQL code before generating charts, which places high demands on ordinary users, resulting in high difficulty and low efficiency in chart generation. Summary of the Invention

[0005] In order to solve the above-mentioned problems in the prior art, namely the difficulty and low efficiency of generating visual data charts in the prior art, the present invention provides a data visualization processing method, apparatus, device and medium.

[0006] In a first aspect, embodiments of the present invention provide a data visualization processing method applied to a server, the method comprising:

[0007] Obtain the metric information and function information selected by the terminal device, wherein the metric information includes all metrics selected by the user, and the function information includes all functions selected by the user;

[0008] Based on the metric information and the pre-acquired graph database, the dimensions related to each metric in the metric information are determined. The graph database includes data, corresponding metrics, dimensions, filters, functions, and the relationships between metrics, between metrics and filters, between metrics and functions, between metrics and dimensions, between dimensions, and between dimensions and filters.

[0009] The dimension related to each metric in the metric information is returned to the terminal device;

[0010] Obtain the dimension information selected by the terminal device, the dimension information including all dimensions selected by the user;

[0011] Based on the dimension information, the metric information, and the graph database, determine the filters associated with all dimensions in the dimension information and the filters associated with all metrics in the metric information.

[0012] The filters associated with all dimensions in the dimensional information and the filters associated with all measures in the metric information are sent to the terminal device.

[0013] Receive filter information sent by the terminal device, the filter information including all filters selected by the user;

[0014] Based on the metric information, the function information, the dimension information, the filter information, and the data in the graph database, a visual data chart is generated;

[0015] The visualized data chart is returned to the terminal device.

[0016] In the preferred embodiment of the above data visualization processing method, obtaining the metric information and function information selected by the terminal device includes:

[0017] Receive the metric and function of a single selection sent by the terminal device, and record the cumulative number of selections;

[0018] Based on the metric selected in the first instance and the relationship between metrics in the graph database, all metrics associated with the metric selected in the first instance are obtained, and all metrics associated with the metric selected in the first instance are returned to the terminal device;

[0019] Repeat the above steps until the cumulative number of selections reaches a preset number, obtain all metrics sent by the terminal device to obtain the metric information, and obtain all functions sent by the terminal device to obtain the function information.

[0020] In a preferred embodiment of the above data visualization processing method, the method further includes:

[0021] After the cumulative number of selections reaches the preset number, a prohibition selection instruction is sent to the terminal device, which is used to instruct the user not to make any more measurement selections.

[0022] In the preferred embodiment of the above data visualization processing method, obtaining the dimension information selected by the terminal device includes:

[0023] Receive a selected dimension sent by the terminal device;

[0024] Based on the dimension and the relationship between dimensions in the graph database, all dimensions associated with the dimension selected in one step are obtained, and all dimensions associated with the dimension selected in one step are returned to the first terminal device;

[0025] Repeat the above steps until no other dimensions are available for selection, and obtain the dimension information by acquiring all selected dimensions sent by the terminal device.

[0026] In the preferred embodiment of the above data visualization processing method, before obtaining the measure and dimension related to each measure in the measure information based on the measure information and the pre-acquired graph database, the method further includes:

[0027] The graph database is generated and stored based on the configuration of relationships between metrics, dimensions, filters, and functions in the data to be processed by the staff.

[0028] Secondly, embodiments of the present invention provide a data visualization processing method applied to a terminal device, the method comprising:

[0029] In response to the user’s first selection operation on the graphical user interface, the system sends metric information and function information to the server. The metric information includes all metrics selected by the user, and the function information includes all functions selected by the user. The graphical user interface displays all selectable metrics and functions provided by the server.

[0030] Receive and display on the graphical user interface the dimensions returned by the server that relate to each metric in the metric information;

[0031] In response to a second selection operation by the user on the graphical user interface, dimension information is sent to the server, the dimension information including all dimensions selected by the user;

[0032] Receive and display on the graphical user interface the filters returned by the server that are associated with all dimensions in the dimension information and the filters that are associated with all measures in the metric information.

[0033] In response to the user's third selection operation on the graphical user interface, filter information is obtained, the filter information including all filters selected by the user;

[0034] Send the filter information to the server;

[0035] Receive and display the visual data charts returned by the server on the graphical user interface.

[0036] In the preferred embodiment of the above data visualization processing method, the step of sending metric information and function information to the server in response to the user's first selection operation on the graphical user interface includes:

[0037] In response to a user's first selection operation on the graphical user interface, a metric and function of the selection are sent to the server;

[0038] Receive and display on the graphical user interface all metrics returned by the server that are associated with the metric selected in the first instance;

[0039] Repeat the above steps until the server returns a prohibition indication; wherein, the metric information includes the metric selected by the user each time, and the function information includes the function selected by the user each time.

[0040] In the preferred embodiment of the above data visualization processing method, the step of sending dimension information to the server in response to a user's second selection operation on the graphical user interface includes:

[0041] In response to a second selection operation by the user on the graphical user interface, the selected dimension is sent to the server;

[0042] Receive and display on the graphical user interface all dimensions returned by the server that are associated with the dimension selected in the first instance;

[0043] Repeat the above steps until the server does not return any selectable dimensions; wherein, the dimension information includes the dimensions selected by the user each time.

[0044] Thirdly, embodiments of the present invention provide a data visualization processing apparatus, comprising:

[0045] The acquisition module is used to acquire metric information and function information selected by the terminal device. The metric information includes all metrics selected by the user, and the function information includes all functions selected by the user.

[0046] The processing module is used to determine the dimensions that are related to each metric in the metric information based on the metric information and the pre-acquired graph database.

[0047] A sending module is used to return the dimensions related to each metric in the metric information to the terminal device;

[0048] The acquisition module is further configured to acquire dimension information selected by the terminal device, the dimension information including all dimensions selected by the user;

[0049] The processing module is further configured to determine, based on the dimension information, the metric information, and the graph database, a filter associated with all dimensions in the dimension information and a filter associated with all metrics in the metric information.

[0050] The sending module is further configured to send the filters associated with all dimensions in the dimension information and the filters associated with all measures in the metric information to the terminal device;

[0051] The acquisition module is further configured to receive filter information sent by the terminal device, the filter information including all filters selected by the user;

[0052] The processing module is further configured to generate a visual data chart based on the metric information, the function information, the dimension information, the filter information, and the data in the graph database;

[0053] The sending module is also used to return the visualized data chart to the terminal device.

[0054] Fourthly, embodiments of the present invention provide a data visualization processing apparatus, comprising:

[0055] The sending module is used to send metric information and function information to the server in response to the user's first selection operation on the graphical user interface. The metric information includes all metrics selected by the user, and the function information includes all functions selected by the user. The graphical user interface displays all selectable metrics and functions provided by the server.

[0056] A processing module is configured to receive and display on the graphical user interface the dimensions returned by the server that relate to each metric in the metric information;

[0057] The sending module is further configured to send dimension information to the server in response to a second selection operation by the user on the graphical user interface, the dimension information including all dimensions selected by the user;

[0058] The processing module is also configured to receive and display on the graphical user interface the filters associated with all dimensions in the dimension information and the filters associated with all measures in the metric information returned by the server.

[0059] The acquisition module is configured to acquire filter information in response to a third selection operation by the user on the graphical user interface, the filter information including all filters selected by the user;

[0060] The sending module is also used to send the filter information to the server;

[0061] The processing module is also configured to receive and display the visual data charts returned by the server on the graphical user interface.

[0062] Fifthly, embodiments of the present invention provide a server, comprising:

[0063] Processor, memory, communication interface;

[0064] The memory is used to store the executable instructions of the processor;

[0065] The processor is configured to execute the data visualization processing method according to any one of the first aspects by executing the executable instructions.

[0066] Sixthly, embodiments of the present invention provide a terminal device, including:

[0067] Processor, memory, display, and communication interface;

[0068] The memory is used to store the executable instructions of the processor;

[0069] The processor is configured to execute the data visualization processing method described in any of the second aspects by executing the executable instructions.

[0070] In a seventh aspect, embodiments of the present invention provide a data visualization processing system, comprising:

[0071] Servers, terminal devices;

[0072] The server is used to execute the data visualization processing method described in any of the first aspects;

[0073] The terminal device is used to execute the data visualization processing method described in any of the second aspects.

[0074] Eighthly, embodiments of the present invention provide a readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the data visualization processing method described in any one of the first to second aspects.

[0075] Ninthly, embodiments of the present invention provide a computer program product, including a computer program, which, when executed by a processor, is used to implement the data visualization processing method described in any one of the first to second aspects.

[0076] Those skilled in the art will understand that the data visualization processing method, apparatus, device, and medium provided in the embodiments of the present invention, through a server determining the dimensions related to each metric in the metric information based on the metric information and function information sent by the terminal device and a pre-acquired graph database, sends these dimensions to the terminal device. The user selects a dimension through the terminal device and sends dimension information to the server. The server determines filters associated with all dimensions in the dimension information and filters associated with all metrics in the metric information based on the dimension information, metric information, and graph database, and sends these filters to the terminal device. The user selects a filter through the terminal device and sends filter information to the server. The server generates a visualized data chart based on the metric information, function information, dimension information, filter information, and data in the graph database, and sends it to the terminal device for display to the user. This solution, by having the server sequentially send metrics and functions, dimensions, and filters to the terminal device based on the relationships between metrics, functions, dimensions, and filters in the graph database, allows the server to generate a visualized data chart for display after the user makes a selection on the terminal device, reducing the difficulty of generating visualized data charts and improving efficiency. Attached Figure Description

[0077] A preferred embodiment of the data visualization processing method of the present invention will now be described with reference to the accompanying drawings. The drawings are as follows:

[0078] Figure 1 This is a schematic diagram illustrating a scenario of the data visualization processing method provided by the present invention;

[0079] Figure 2a This is a flowchart illustrating an embodiment of the data visualization processing method provided by the present invention;

[0080] Figure 2b This is a schematic diagram illustrating the relationship between measurement and function provided in an embodiment of the present invention;

[0081] Figure 2c This is a schematic diagram illustrating the relationship between dimensions provided in an embodiment of the present invention;

[0082] Figure 3 A flowchart illustrating a second embodiment of the data visualization processing method provided by the present invention;

[0083] Figure 4 A flowchart illustrating Embodiment 3 of the data visualization processing method provided by the present invention;

[0084] Figure 5 A schematic diagram of the structure of a data visualization processing device according to a first embodiment of the present invention;

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

[0086] Figure 7 A schematic diagram of the structure of a server provided by the present invention;

[0087] Figure 8 This is a schematic diagram of the structure of a terminal device provided by the present invention. Detailed Implementation

[0088] First, those skilled in the art should understand that these embodiments are merely for explaining the technical principles of the present invention and are not intended to limit the scope of protection of the present invention. Those skilled in the art can make adjustments as needed to adapt to specific application scenarios.

[0089] Secondly, it should be noted that in the description of the embodiments of the present invention, the terms "inner" and "outer", etc., which indicate the direction or positional relationship, are based on the direction or positional relationship shown in the drawings. This is only for the convenience of description and is not intended to indicate or imply that the device or component must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, it should not be construed as a limitation of the present invention.

[0090] Furthermore, it should be noted that, in the description of the embodiments of the present invention, unless otherwise explicitly specified and limited, the terms "connected" and "linked" should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral connection; they can refer to a mechanical connection or an electrical connection; they can refer to a direct connection or an indirect connection through an intermediate medium; and they can refer to the internal connection of two components. Those skilled in the art can understand the specific meaning of the above terms in the embodiments of the present invention according to the specific circumstances.

[0091] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0092] With the rapid development of society, users encounter more and more data in their lives and work. Faced with a large amount of data, users cannot directly discover the relationships between data or the trends of data change. Therefore, it is necessary to transform data into the form of visual data charts. Through visual data charts, users can intuitively see how the data changes and the relationships between data, which facilitates users' understanding.

[0093] In the process of creating visualized data charts, users need to preprocess the data using SQL code, and then input the preprocessed data and SQL code into the server. The server, based on the preprocessed data and SQL code, obtains the corresponding measures and dimensions, as well as the correspondence between measures and dimensions. The server then sends selectable measures to the terminal for display to the user. Users select their desired measures, the terminal sends the selected measures to the server, the server finds the corresponding dimensions based on the selected measures and the correspondence between measures and dimensions, and then sends the dimensions to the terminal for display. Users select their desired dimensions, the terminal sends the selected dimensions to the server, and the server processes the data based on the selected measures and dimensions to create a visualized data chart, which is then sent to the terminal for display to the user. Existing data visualization methods require users to write SQL code for data preprocessing, resulting in low efficiency in generating visualized data charts.

[0094] This embodiment provides a data visualization processing method. When a user needs to transform data into a visual data chart, the data is first sent to a server via a terminal device. The server then sends the data to the operator's terminal device, where the operator configures a graph database. The graph database includes measures, dimensions, functions, filters, and their relationships. After configuration, the data is sent to the server via the terminal device. The server then sends all measures and related functions to the terminal device for the user to select. After the user selects a measure and function, the server sends functions related to those measures to the terminal device. Following the user's selection, the server sends dimensions related to those dimensions, and finally, filters related to those dimensions. Finally, the server processes the data based on the selected measures, functions, dimensions, and filters to create a visual data chart, which is then sent to the terminal device for display. It reduces the difficulty of generating visual data charts and improves the efficiency of generating visual data charts.

[0095] The principles and features of the embodiments of the present invention are described below with reference to the accompanying drawings. The examples given are only used to explain the embodiments of the present invention and are not intended to limit the scope of the embodiments of the present invention.

[0096] Figure 1 This is a schematic diagram illustrating a scenario of the data visualization processing method provided by the present invention, such as... Figure 1 As shown, the application scenario includes: terminal device 11 and server 12.

[0097] For example, server 12 can obtain the metric information, function information, dimension information and filter information selected by terminal device 11, generate and store graph database, and determine the metrics, dimensions and filters related to the metrics and dimensions in the information sent by terminal device 11 based on the relationship between the metrics, dimensions, functions and filters in the graph database. It can also send the metrics, dimensions, functions, filters, prohibition of selection instructions and visualization data icons to terminal device 11.

[0098] Terminal device 11 can send metric information, function information, dimension information and filter information to server 12, and can receive and display the metrics, dimensions, functions, filters and visual data charts sent by the server on the user's graphical interface.

[0099] It should be noted that, Figure 1 This is merely a schematic diagram illustrating an application scenario of the data visualization processing method provided by the present invention. The embodiments of the present invention do not necessarily reflect the intended use of this method. Figure 1 The document does not limit the actual form and specific quantity of the various devices included, nor does it specify... Figure 1 The location relationships and interaction methods between devices are defined, and can be set according to actual needs in the specific application of the solution.

[0100] It should be noted that the terminal device can be a computer, a smartphone, or other smart terminals. The embodiments of the present invention do not limit the specific form of the terminal device, which can be determined according to actual needs.

[0101] Figure 2a This is a flowchart illustrating an embodiment of the data visualization processing method provided by the present invention, as shown below. Figure 2a As shown, the data visualization processing method specifically includes the following steps:

[0102] S201: In response to the user's first selection operation on the graphical user interface, send measurement information and function information to the server.

[0103] When users want to generate data visualization charts, they need to send the data to the server via their terminal devices. After receiving the data, the server forwards it to staff for processing. Staff configure the data based on the measures, dimensions, filters, and functions, as well as the relationships between them, and then send the configuration to the server. Upon receiving the configuration, the server generates and stores a graph database. After generating the graph database, the server retrieves all measures and related functions from it and sends them to the terminal devices. The graph database includes the data, its corresponding measures, dimensions, filters, functions, and the relationships between measures, between measures and filters, between measures and functions, between measures and dimensions, between dimensions, and between dimensions and filters.

[0104] For example, Figure 2b This is a schematic diagram illustrating the relationship between measurement and function provided in an embodiment of the present invention, such as... Figure 2b As shown, when the metric is the offline quantity, the functions related to the offline quantity are total, new, year-on-year, and month-on-month.

[0105] For example, Figure 2c This is a schematic diagram illustrating the relationship between dimensions provided in an embodiment of the present invention, such as... Figure 2c As shown, when the dimension is a region, the dimensions related to the dimension are province, city, and district.

[0106] It should be noted that, Figure 2b and Figure 2c This invention merely illustrates the relationship between metrics and functions, and the relationship between dimensions. The embodiments of this invention do not specifically limit the metrics, functions, dimensions, the relationship between metrics and functions, or the relationship between dimensions, and can be set according to the actual situation.

[0107] In this step, after receiving the metric and function, the terminal device displays them to the user in a graphical interface, allowing the user to select the desired metric. After selection, the terminal device sends the metric and function information to the server. The server then determines the dimension based on the metric information.

[0108] It should be noted that when staff configure the metrics, dimensions, filters, and functions in the data to be processed, as well as the relationships between them, they configure them by using metrics, dimensions, filters, and functions as vertices, and connecting them if there are relationships between them.

[0109] S202: Based on the metric information and the pre-acquired graph database, determine the dimensions that are related to each metric in the metric information.

[0110] S203: Return the dimensions related to each metric in the metric information to the terminal device.

[0111] In the above steps, after receiving the metric and function information from the terminal device, the server can determine the dimensions related to each metric in the metric information based on the relationship between metrics and dimensions in the graph database. The server then sends the dimensions related to each metric in the metric information to the terminal device for display to the user, who can then select the dimensions they need.

[0112] It should be noted that before the user selects a metric, the staff configures the relationships between metrics, dimensions, filters, and functions in the data to be processed. The server generates a graph database based on the configuration and data to determine the functions, metrics, dimensions, and filters that are related to the metrics and dimensions.

[0113] For example, when the user selects usage duration as the metric, based on the relationship between metrics and dimensions in the graph database, the dimensions related to usage duration include region, date, and program. It should be noted that this embodiment of the invention does not specifically limit the metrics, dimensions, or the relationship between metrics and dimensions; these can be set according to actual circumstances.

[0114] S204: Receive and display on the graphical user interface the dimensions returned by the server that relate to each metric in the metric information.

[0115] In this step, the terminal device receives the dimensions related to each metric in the measurement information returned by the server and displays them on the user's graphical interface so that the user can select the dimension they need.

[0116] It should be noted that when a user wants to modify their selected metric, they can click the back button on the user's graphical interface of the terminal device. The terminal device then sends a first return command to the server. Based on the first return command, the server retrieves all metrics from the graph database and sends them to the terminal device, thus returning to step S201.

[0117] S205: In response to the user's second selection action on the graphical user interface, send dimension information to the server.

[0118] In this step, the terminal device displays the dimensions related to each metric in the measurement information on the user's graphical interface, allowing the user to select the desired dimensions. After the user's selection, the terminal device sends the dimension information to the server. The server then determines the filter based on the dimension information.

[0119] S206: Based on the dimension information, metric information, and graph database, determine the filters associated with all dimensions in the dimension information and the filters associated with all metrics in the metric information.

[0120] S207: Send the filters associated with all dimensions in the dimension information and the filters associated with all measures in the measure information to the terminal device.

[0121] In the above steps, after receiving the dimension information sent by the terminal device, the server determines the filters associated with all dimensions in the dimension information and all measures in the measurement information based on the dimensions in the dimension information, the measures in the measurement information, and the relationship between dimensions and filters in the graph database. The server then sends the determined filters to the terminal device so that the user can select the filter they need on the terminal device.

[0122] For example, when the user selects a region as the dimension, based on the relationship between dimensions and filters in the graph database, there are filters related to regions, allowing for filtering by region. It should be noted that this embodiment of the invention does not specifically limit the dimensions, filters, or the relationship between dimensions and filters; these can be set according to actual circumstances.

[0123] S208: Receive and display on the graphical user interface the filters returned by the server that are associated with all dimensions in the dimension information and all measures in the measurement information.

[0124] In this step, the terminal device receives the filters associated with all dimensions in the dimension information and all measures in the measurement information returned by the server and displays them on the user's graphical interface so that the user can select the filters they need.

[0125] It should be noted that when a user wants to modify their selected dimension, they can click the back button on the user's graphical interface of the terminal device. The terminal device then sends a second return command to the server. Based on the second return command, the server returns to step S203.

[0126] S209: In response to a third selection action by the user on the graphical user interface, obtain filter information.

[0127] S210: Send the filter information to the server.

[0128] In the steps described above, the terminal device displays filters associated with all dimensions in the dimension information and filters associated with all measures in the measure information on the user's graphical interface. The user can then select the desired filter. After the user's selection, the terminal obtains the selected filter information and sends it to the server. The server can then generate a visual data chart based on the measure information, function information, dimension information, filter information, and data in the graph database.

[0129] It should be noted that the number of filters selected by the user can be one or more. This embodiment of the invention does not impose a specific limit on the number of filters selected by the user, and the selection can be made according to the actual situation.

[0130] S211: Generate visual data charts based on metric information, function information, dimension information, filter information, and data in the graph database.

[0131] S212: Return the visualized data charts to the terminal device.

[0132] In the above steps, after receiving the filter information sent by the terminal device, the server combines the metric information, function information, dimension information, and data from the graph database to generate a visual data chart. The server then sends the visual data chart to the terminal device so that the user can view it on the terminal device.

[0133] It should be noted that the server has the ability to automatically generate visual data charts. This embodiment of the invention does not specifically limit the method by which the server generates visual data charts based on metric information, function information, dimension information, filter information and data in the graph database. The method can be set according to the actual situation.

[0134] S213: Receive and display the visual data charts returned by the server on the graphical user interface.

[0135] In this step, the terminal device receives the visualized data charts returned by the server and displays them on the user's graphical interface so that the user can view them freely.

[0136] It should be noted that when a user wants to modify their selected filter, they can click the back button on the user's graphical interface of the terminal device. The terminal device then sends a third return instruction to the server. Based on the third return instruction, the server returns to step S207.

[0137] The data visualization processing method provided in this embodiment involves staff configuring data, the server generating a graph database based on the configuration, and the user selecting the desired metrics and functions on their terminal device and sending them to the server. The server determines the dimensions based on the relationship between metrics and dimensions in the graph database and sends this information to the terminal device for user display. The user then selects the desired dimensions and sends them to the server. The server determines the filters based on the metrics, dimensions, and the relationships between metrics and filters, and between dimensions and filters in the graph database, and then sends these filters to the terminal device for user display. Finally, the user selects the desired filters and sends them to the server, which then generates a visualized data chart based on the metrics, functions, dimensions, and filters, and sends it to the terminal device for user display. Compared to existing technologies where users need to write SQL code to preprocess data, in this solution, users only need to select metrics, functions, dimensions, and filters on the user's graphical interface. The server can then determine the dimensions and filters related to the user's selected metrics and dimensions based on the pre-acquired graph database. Finally, after obtaining the metric information, function information, dimension information, and filter information, a visual data chart can be generated and sent to the terminal device for display to the user. This effectively reduces the difficulty of generating visual data charts and increases the efficiency of generating visual data charts.

[0138] Figure 3 A flowchart illustrating Embodiment Two of the data visualization processing method provided by the present invention is shown below. Figure 3 As shown, in this embodiment, step S201 can be implemented through the following steps:

[0139] S301: In response to a user's first selection operation on the graphical user interface, send the measurement and function of the selection to the server.

[0140] In this step, after receiving the metrics and functions, the terminal device displays them to the user in a graphical interface. The user can select the metrics and functions they need. After the user selects a metric and function, the terminal device sends the selected metric and function to the server. The server can then determine the metrics related to the selected metric based on the graph database.

[0141] S302: Receive the measurement and function of a single selection sent by the terminal device, and record the cumulative number of selections.

[0142] In this step, after the server receives the metric and function sent by the terminal device, it records the cumulative number of selections and compares it with a preset number. If the cumulative number of selections is less than the preset number, the user can continue to select a metric; if the cumulative number of selections equals the preset number, the user cannot continue to select a metric.

[0143] S303: Based on the metric selected in one step and the relationship between metrics in the graph database, retrieve all metrics associated with the metric selected in one step, and return all metrics associated with the metric selected in one step to the terminal device.

[0144] In this step, the graph database stored on the server contains the relationships between metrics. Based on these relationships, all metrics associated with a selected metric can be retrieved and then sent to the terminal device to be displayed to the user so that the user can continue to select metrics.

[0145] S304: Receive and display on the graphical user interface all measures associated with a single selected measure returned by the server.

[0146] In this step, the terminal device receives all the metrics associated with the selected metric from the server and displays them on the user's graphical interface so that the user can continue to select the metrics they need.

[0147] S305: Repeat the above steps until the cumulative number of selections reaches the preset number, obtain all metrics sent by the terminal device to obtain metric information, and obtain all functions sent by the terminal device to obtain function information.

[0148] In this step, the user can continuously select metrics until the number of selections reaches a preset limit, at which point further selections are prohibited to prevent server malfunctions. The server receives each metric selected by the user from the terminal device and obtains the metric information. The server also receives each function selected by the user from the terminal device and obtains the function information.

[0149] It should be noted that the preset number of times is set by staff on the server before the user sends the data. This preset number is used to compare the number of times the user has selected a metric cumulatively. If the cumulative number of selections is less than the preset number, the user can continue selecting metrics; if the cumulative number of selections equals the preset number, the user cannot continue selecting metrics. This embodiment of the invention does not specifically limit the preset number of times; it can be set according to actual circumstances.

[0150] It should be noted that if a user wants to terminate the selection of measures and functions before reaching the preset number of times they have selected a metric, they can click the "Terminate Measurement Selection" button on the user's graphical interface on their terminal device. The terminal device then sends a command to the server to select dimensions. The server can then determine the dimensions related to each metric in the measurement information based on the measurement information and the graph database, and send them to the terminal device so that the user can select dimensions.

[0151] It should be noted that when a user selects a metric, they will also select a function related to the metric. The terminal device sends the function to the server at the same time as sending the metric, or it can send all the functions selected by the user to the server at once when the number of times the user selects the metric reaches a preset number, or it can send all the functions selected by the user to the server at once when the terminal device sends the instruction to select the dimension. This embodiment of the invention does not specifically limit the timing of the terminal device sending functions to the server, and it can be set according to the actual situation.

[0152] S306: Send a prohibition selection instruction to the terminal device.

[0153] In this step, once the cumulative number of selections reaches the preset number, the server sends a prohibition command to the terminal device. Upon receiving the command, the terminal device prohibits the user from making selections on the user's graphical interface to avoid accidental operation.

[0154] The data visualization processing method provided in this embodiment involves a user selecting a metric and a function on a terminal device, which then sends the metric and function to a server. The server determines the metrics related to the user's selection based on the relationships between metrics in the graph database, and then sends these metrics back to the terminal device for the user to choose from. This process continues until the user's cumulative selection count reaches a preset number, at which point selection stops. Compared to existing technologies that only allow for one metric selection, this solution allows for multiple metric selections, resulting in visualized data charts that better meet user needs.

[0155] Figure 4 A flowchart illustrating Embodiment 3 of the data visualization processing method provided by the present invention is shown below. Figure 4 As shown, in this embodiment, step S205 in Embodiment 1 above can be implemented through the following steps:

[0156] S401: In response to a second selection operation by the user on the graphical user interface, send the selected dimension to the server;

[0157] In this step, after receiving the dimensions, the terminal device displays them to the user's graphical interface. The user can select the desired dimensions, and after selection, the terminal device sends the selected dimensions to the server. The server can then determine the dimensions related to the selected dimensions based on the graph database.

[0158] S402: Based on the dimensions and the relationship between dimensions in the graph database, obtain all dimensions associated with the selected dimension and return all dimensions associated with the selected dimension to the first terminal device.

[0159] In this step, the graph database stored on the server contains the relationships between dimensions. Based on these relationships, all dimensions associated with a selected dimension can be retrieved and then sent to the terminal device to be displayed to the user so that the user can continue to select dimensions.

[0160] S403: Receive and display on the graphical user interface all dimensions associated with a single selected dimension returned by the server.

[0161] In this step, the terminal device receives all dimensions associated with the selected dimension from the server and displays them on the user's graphical interface so that the user can continue to select the dimensions they need.

[0162] S404: Repeat the above steps until no other dimensions are available for selection, and obtain the dimension information by acquiring all selected dimensions sent by the terminal device.

[0163] In this step, the user can continuously select dimensions until no more dimensions are available, at which point selection is no longer possible. The server receives each dimension selected by the user from the terminal device, thus obtaining the dimension information.

[0164] For example, when the user selects a mixing program as the dimension, based on the relationships between dimensions in the graph database, the dimensions related to the mixing program include drying method parameters, rinsing frequency parameters, temperature parameters, and dehydration speed parameters. It should be noted that this embodiment of the invention does not specifically limit the dimensions or the relationships between dimensions; these can be set according to actual circumstances.

[0165] It should be noted that when a user can still select dimensions but wants to terminate the selection, they can click the "Terminate Dimension Selection" button on the user's graphical interface on the terminal device. The terminal device then sends a filter selection command to the server. The server can then determine the filters associated with all dimensions in the dimension information and the filters associated with all measures in the measurement information based on the metric information, the dimension information, and the graph database, and send these results to the terminal device so that the user can select a filter.

[0166] The data visualization processing method provided in this embodiment involves a user selecting a dimension on a terminal device, which then sends the dimension to a server. The server determines dimensions related to the user's selected dimension based on the relationships between dimensions in the graph database, and then sends these dimensions back to the terminal device for the user to choose from. This process continues until no dimensions are available for selection. Compared to existing technologies that only allow one dimension selection, this solution allows multiple dimension selections, and the generated visualization charts better meet user needs.

[0167] Figure 5A schematic diagram of the structure of a data visualization processing device according to an embodiment of the present invention; as shown below. Figure 5 As shown, the data visualization processing device 50 includes:

[0168] The acquisition module 51 is used to acquire the metric information and function information selected by the terminal device. The metric information includes all metrics selected by the user, and the function information includes all functions selected by the user.

[0169] Processing module 52 is used to determine the dimensions that are related to each metric in the metric information based on the metric information and the pre-acquired graph database.

[0170] The sending module 53 is used to return the dimension related to each metric in the metric information to the terminal device;

[0171] The acquisition module 51 is further configured to acquire dimension information selected by the terminal device, the dimension information including all dimensions selected by the user;

[0172] The processing module 52 is further configured to determine, based on the dimension information, the metric information, and the graph database, a filter associated with all dimensions in the dimension information and a filter associated with all metrics in the metric information.

[0173] The sending module 53 is further configured to send the filters associated with all dimensions in the dimension information and the filters associated with all measures in the metric information to the terminal device.

[0174] The acquisition module 51 is further configured to receive filter information sent by the terminal device, the filter information including all filters selected by the user;

[0175] The processing module 52 is further configured to generate a visual data chart based on the metric information, the function information, the dimension information, the filter information, and the data in the graph database;

[0176] The sending module 53 is also used to return the visualized data chart to the terminal device.

[0177] Furthermore, the acquisition module 51 is also used to receive a metric and function of a single selection sent by the terminal device.

[0178] Furthermore, the processing module 52 is also used to record the cumulative number of selections.

[0179] Furthermore, the processing module 52 is also used to obtain all metrics associated with the metric selected in the first selection based on the metric selected in the first selection and the relationship between metrics in the graph database.

[0180] Furthermore, the sending module 53 is also configured to return all metrics associated with the metric selected in the first instance to the terminal device.

[0181] Furthermore, the sending module 53 is also used to send a prohibition selection instruction to the terminal device after the cumulative selection count reaches the preset number.

[0182] Furthermore, the acquisition module 51 is also used to receive a selected dimension sent by the terminal device.

[0183] Furthermore, the processing module 52 is also used to obtain all dimensions associated with the dimension selected in the first selection based on the dimension and the relationship between dimensions in the graph database.

[0184] Furthermore, the sending module 53 is also configured to return all dimensions associated with the dimension selected in the first instance to the first terminal device.

[0185] Furthermore, the processing module 52 is also used to generate and store the graph database based on the configuration of the relationships between metrics, dimensions, filters, and functions in the data to be processed by the staff.

[0186] The data visualization processing device provided in this embodiment is used to execute the server's technical solution in any of the aforementioned method embodiments, and its implementation principle and technical effect are similar. The server can determine the metrics, dimensions, and filters related to the metric and dimension information sent by the terminal device based on the relationships between metrics, functions, dimensions, and filters in the graph database, and then send them to the terminal device for the user to select, thereby reducing the difficulty of generating visualized data charts and improving the efficiency of generating visualized data charts.

[0187] Figure 6 A schematic diagram of the structure of a second embodiment of the data visualization processing device provided by the present invention; as shown. Figure 6 As shown, the data visualization processing device 60 includes:

[0188] The sending module 61 is used to send metric information and function information to the server in response to the user's first selection operation on the graphical user interface. The metric information includes all metrics selected by the user, and the function information includes all functions selected by the user. The graphical user interface displays all selectable metrics and functions provided by the server.

[0189] Processing module 62 is used to receive and display on the graphical user interface the dimensions returned by the server that are related to each metric in the metric information;

[0190] The sending module 61 is further configured to send dimension information to the server in response to a second selection operation by the user on the graphical user interface, the dimension information including all dimensions selected by the user;

[0191] The processing module 62 is also configured to receive and display on the graphical user interface the filters associated with all dimensions in the dimension information and the filters associated with all measures in the metric information returned by the server.

[0192] The acquisition module 63 is configured to acquire filter information in response to a third selection operation by the user on the graphical user interface, the filter information including all filters selected by the user;

[0193] The sending module 61 is also used to send the filter information to the server;

[0194] The processing module 62 is also configured to receive and display the visual data charts returned by the server on the graphical user interface.

[0195] Furthermore, the sending module 61 is also configured to send a measurement and function of a selection to the server in response to a first selection operation by the user on the graphical user interface;

[0196] Furthermore, the processing module 62 is also configured to receive and display on the graphical user interface all metrics returned by the server that are associated with the metric selected in the first instance.

[0197] Furthermore, the sending module 61 is also configured to send a selected dimension to the server in response to a second selection operation by the user on the graphical user interface.

[0198] Furthermore, the processing module 62 is also configured to receive and display on the graphical user interface all dimensions returned by the server that are associated with the dimension selected in the first instance.

[0199] The data visualization processing device provided in this embodiment is used to execute the technical solution of the terminal device in any of the aforementioned method embodiments. Its implementation principle and technical effect are similar, and will not be described again here.

[0200] Figure 7 This is a schematic diagram of the structure of a server provided by the present invention. For example... Figure 7 As shown, the server 70 includes:

[0201] Processor 71, memory 72, and communication interface 73;

[0202] The memory 72 is used to store the executable instructions of the processor 71;

[0203] The processor 71 is configured to execute the server technical solution in any of the foregoing method embodiments by executing the executable instructions.

[0204] Optionally, the memory 72 can be either standalone or integrated with the processor 71.

[0205] Optionally, when the memory 72 is a device independent of the processor 71, the server 70 may further include:

[0206] A bus is used to connect the aforementioned devices.

[0207] The server is used to execute the server-side technical solution in any of the aforementioned method embodiments. Its implementation principle and technical effect are similar, and will not be described again here.

[0208] Figure 8 This is a schematic diagram of the structure of a terminal device provided by the present invention. (See diagram below.) Figure 8 As shown, the terminal device 80 includes:

[0209] Processor 81, memory 82, display 83, and communication interface 84;

[0210] The memory 82 is used to store the executable instructions of the processor;

[0211] The processor 81 is configured to execute the technical solution of the terminal device in the data visualization processing method provided in any of the foregoing embodiments by executing the executable instructions.

[0212] Optionally, the memory 82 can be either standalone or integrated with the processor 81.

[0213] Optionally, when the memory 82 is a device independent of the processor 81, the terminal device 80 may further include:

[0214] A bus is used to connect the aforementioned devices.

[0215] The terminal device is used to execute the technical solution on the terminal device side in any of the aforementioned method embodiments. Its implementation principle and technical effect are similar, and will not be described again here.

[0216] This invention also provides a readable storage medium storing a computer program thereon, which, when executed by a processor, implements the technical solutions provided on the server or terminal device side of any of the foregoing embodiments.

[0217] This invention also provides a computer program product, including a computer program, which, when executed by a processor, is used to implement the technical solutions provided on the server or terminal device side of any of the foregoing method embodiments.

[0218] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some or all of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data visualization processing method, characterized in that, Applied to a central server, the method includes: Obtain the metric information and function information selected by the terminal device, wherein the metric information includes all metrics selected by the user, and the function information includes all functions selected by the user; Based on the metric information and the pre-acquired graph database, the dimensions related to each metric in the metric information are determined. The graph database includes data, corresponding metrics, dimensions, filters, functions, and the relationships between metrics, between metrics and filters, between metrics and functions, between metrics and dimensions, between dimensions, and between dimensions and filters. The dimension related to each metric in the metric information is returned to the terminal device; Obtain the dimension information selected by the terminal device, the dimension information including all dimensions selected by the user; Based on the dimension information, the metric information, and the graph database, determine the filters associated with all dimensions in the dimension information and the filters associated with all metrics in the metric information. The filters associated with all dimensions in the dimensional information and the filters associated with all measures in the metric information are sent to the terminal device. Receive filter information sent by the terminal device, the filter information including all filters selected by the user; Based on the metric information, the function information, the dimension information, the filter information, and the data in the graph database, a visual data chart is generated; The visualized data chart is returned to the terminal device.

2. The method according to claim 1, characterized in that, The acquisition of the metric information and function information selected by the terminal device includes: Receive the metric and function of a single selection sent by the terminal device, and record the cumulative number of selections; Based on the metric selected in the first instance and the relationship between metrics in the graph database, all metrics associated with the metric selected in the first instance are obtained, and all metrics associated with the metric selected in the first instance are returned to the terminal device; Repeat the above steps until the cumulative number of selections reaches a preset number, obtain all metrics sent by the terminal device to obtain the metric information, and obtain all functions sent by the terminal device to obtain the function information.

3. The method according to claim 2, characterized in that, The method further includes: After the cumulative number of selections reaches the preset number, a prohibition selection instruction is sent to the terminal device, which is used to instruct the user not to make any more measurement selections.

4. The method according to claim 1 or 2, characterized in that, The step of obtaining the dimension information selected by the terminal device includes: Receive a selected dimension sent by the terminal device; Based on the dimension and the relationship between dimensions in the graph database, all dimensions associated with the dimension selected in the first step are obtained, and all dimensions associated with the dimension selected in the first step are returned to the terminal device; Repeat the above steps until no other dimensions are available for selection, and obtain the dimension information by acquiring all selected dimensions sent by the terminal device.

5. The method according to claim 1 or 2, characterized in that, Before obtaining the metrics and dimensions related to each metric in the metric information based on the metric information and the pre-acquired graph database, the method further includes: The graph database is generated and stored based on the configuration of relationships between metrics, dimensions, filters, and functions in the data to be processed by the staff.

6. A data visualization processing method, characterized in that, Applied to a terminal device, the method includes: In response to the user’s first selection operation on the graphical user interface, the system sends metric information and function information to the server. The metric information includes all metrics selected by the user, and the function information includes all functions selected by the user. The graphical user interface displays all selectable metrics and functions provided by the server. Receive and display on the graphical user interface the dimensions returned by the server that relate to each metric in the metric information; In response to a second selection operation by the user on the graphical user interface, dimension information is sent to the server, the dimension information including all dimensions selected by the user; Receive and display on the graphical user interface the filters returned by the server that are associated with all dimensions in the dimension information and the filters that are associated with all measures in the metric information. In response to the user's third selection operation on the graphical user interface, filter information is obtained, the filter information including all filters selected by the user; Send the filter information to the server; Receive and display the visual data charts returned by the server on the graphical user interface.

7. The method according to claim 6, characterized in that, The step of sending measurement information and function information to the server in response to the user's first selection operation on the graphical user interface includes: In response to a user's first selection operation on the graphical user interface, a metric and function of the selection are sent to the server; Receive and display on the graphical user interface all metrics returned by the server that are associated with the metric selected in the first instance; Repeat the above steps until the server returns a prohibition indication; wherein, the metric information includes the metric selected by the user each time, and the function information includes the function selected by the user each time.

8. The method according to claim 6 or 7, characterized in that, The step of sending dimension information to the server in response to a second selection operation by the user on the graphical user interface includes: In response to a second selection operation by the user on the graphical user interface, the selected dimension is sent to the server; Receive and display on the graphical user interface all dimensions returned by the server that are associated with the dimension selected in the first instance; Repeat the above steps until the server does not return any selectable dimensions; wherein, the dimension information includes the dimensions selected by the user each time.

9. A data visualization processing device, characterized in that, include: The acquisition module is used to acquire metric information and function information selected by the terminal device. The metric information includes all metrics selected by the user, and the function information includes all functions selected by the user. The processing module is used to determine the dimensions that are related to each metric in the metric information based on the metric information and the pre-acquired graph database. A sending module is used to return the dimensions related to each metric in the metric information to the terminal device; The acquisition module is further configured to acquire dimension information selected by the terminal device, the dimension information including all dimensions selected by the user; The processing module is further configured to determine, based on the dimension information, the metric information, and the graph database, a filter associated with all dimensions in the dimension information and a filter associated with all metrics in the metric information. The sending module is further configured to send the filters associated with all dimensions in the dimension information and the filters associated with all measures in the metric information to the terminal device; The acquisition module is further configured to receive filter information sent by the terminal device, the filter information including all filters selected by the user; The processing module is further configured to generate a visual data chart based on the metric information, the function information, the dimension information, the filter information, and the data in the graph database; The sending module is also used to return the visualized data chart to the terminal device.

10. A data visualization processing apparatus, characterized in that, include: The sending module is used to send metric information and function information to the server in response to the user's first selection operation on the graphical user interface. The metric information includes all metrics selected by the user, and the function information includes all functions selected by the user. The graphical user interface displays all selectable metrics and functions provided by the server. A processing module is configured to receive and display on the graphical user interface the dimensions returned by the server that relate to each metric in the metric information; The sending module is further configured to send dimension information to the server in response to a second selection operation by the user on the graphical user interface, the dimension information including all dimensions selected by the user; The processing module is also configured to receive and display on the graphical user interface the filters associated with all dimensions in the dimension information and the filters associated with all measures in the metric information returned by the server. The acquisition module is configured to acquire filter information in response to a third selection operation by the user on the graphical user interface, the filter information including all filters selected by the user; The sending module is also used to send the filter information to the server; The processing module is also configured to receive and display the visual data charts returned by the server on the graphical user interface.

11. A server, characterized in that, include: Processor, memory, communication interface; The memory is used to store the executable instructions of the processor; The processor is configured to execute the data visualization processing method according to any one of claims 1 to 5 by executing the executable instructions.

12. A terminal device, characterized in that, include: Processor, memory, display, and communication interface; The memory is used to store the executable instructions of the processor; The processor is configured to execute the data visualization processing method according to any one of claims 6 to 8 by executing the executable instructions.

13. A data visualization processing system, characterized in that, include: Servers, terminal devices; The server is used to execute the data visualization processing method according to any one of claims 1 to 5; The terminal device is used to execute the data visualization processing method according to any one of claims 6 to 8.

14. A readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the data visualization processing method according to any one of claims 1 to 8.

15. A computer program product, characterized in that, Includes a computer program, which, when executed by a processor, is used to implement the data visualization processing method according to any one of claims 1 to 8.

Images