CN116069996A - Data visualization processing method, device, equipment and medium - Google Patents

Abstract

The invention belongs to the field of big data, and particularly relates to a data visualization processing method, device, equipment and medium. The invention aims to solve the problems of high difficulty and low efficiency in generating a visualized data chart by the existing data visualization method. According to the data visualization processing method, device, equipment and medium, the server determines the dimension according to the measurement information, the function information and the graph database sent by the terminal equipment and sends the dimension information to the terminal equipment, the user determines the filter according to the dimension information, the measurement information and the graph database and sends the filter to the terminal equipment, the user sends the filter information to the server through the terminal equipment, and the server generates a visualized data graph according to the measurement information, the function information, the dimension information and the filter information and the graph database and sends the visualized data graph to the terminal equipment to be displayed to the user, so that the difficulty of generating the visualized data graph is reduced, and the efficiency of generating the visualized data graph is improved.

Description

Data visualization processing method, device, equipment and medium

technical field

Embodiments of the present invention belong to the field of big data, and specifically relate to a data visualization processing method, device, equipment, and medium.

Background technique

With the rapid development of society, it has come to the era of big data. Users need to use various data to make charts to realize data visualization. Through the display of charts, it can intuitively reflect the changing trend of data, the proportion of data, etc., which is convenient for people understanding.

In the prior art, the user preprocesses the data that needs to be formed into a chart by writing a Structured Query Language (Structured Query Language, referred to as: sql) code, and inputs the preprocessed data and sql code into the server. The data and sql code get the corresponding measure and dimension of the data and the corresponding relationship between the measure and the dimension. The server sends the selectable measure to the terminal to display to the user. The user selects the measure he needs, and the terminal device sends the measure selected by the user to the server. The server finds the dimension corresponding to the measurement according to the measurement selected by the user and the corresponding relationship between the measurement and the dimension, and then sends the dimension to the terminal to display to the user. The user selects the dimension he needs, and the terminal device sends the dimension selected by the user to the server. The metrics and dimensions selected by the user process the data to form a graph, and then send the graph to the terminal device for display to the user.

To sum up, the existing data visualization methods require users to use SQL language to write codes to preprocess the data before they can generate charts, which have high requirements for ordinary users, making it difficult and inefficient to generate charts.

Contents of the invention

In order to solve the above problems in the prior art, that is, to solve the difficulty and low efficiency of generating visualized data charts in the prior art, embodiments of the present invention provide a data visualization processing method, device, equipment, and medium.

In the first aspect, an embodiment of the present invention provides a data visualization processing method, which is applied to a server, and the method includes:

Acquire metric information and function information selected by the terminal device, where the metric information includes all metrics selected by the user, and the function information includes all functions selected by the user;

According to the metric information and the pre-acquired graph database, determine the dimensions related to each metric in the metric information, wherein the graph database includes data, and the metrics, dimensions, filters, functions, and Measure-to-measure, measure-filter, measure-function, measure-dimension, dimension-dimension, and dimension-filter relationships;

returning the dimensions related to each metric in the metric information to the terminal device;

Obtain dimension information selected by the terminal device, where the dimension information includes all dimensions selected by the user;

Determine filters associated with all dimensions in the dimension information and filters associated with all metrics in the measurement information according to the dimension information, the measurement information, and the graph database;

sending the filters associated with all dimensions in the dimensional information and the filters associated with all metrics in the metric information to the terminal device;

receiving filter information sent by the terminal device, where the filter information includes all filters selected by the user;

generating a visual data chart according to the metric information, the function information, the dimension information, the filter information and the data in the graph database;

returning the visualized data chart to the terminal device.

In the preferred technical solution of the above data visualization processing method, the acquisition of the metric information and function information selected by the terminal device includes:

receiving a selected metric and function sent by the terminal device, and recording the cumulative number of selections;

Obtain all metrics associated with the once-selected metric based on the once-selected metric and the relationship between metrics and metrics in the graph database, and return all metrics associated with the once-selected metric to the terminal equipment;

Repeating the above steps until the cumulative number of selections reaches a preset number of times, acquiring all metrics sent by the terminal device to obtain the metric information, and acquiring all functions sent by the terminal device to obtain the function information.

In the preferred technical solution of the above data visualization processing method, the method also includes:

After the accumulated number of times of selection reaches the preset number of times, an indication of prohibiting selection is sent to the terminal device, where the indication of prohibiting selection is used to instruct the user to no longer perform metric selection.

In the preferred technical solution of the above data visualization processing method, the acquisition of dimension information selected by the terminal device includes:

receiving a selected dimension sent by the terminal device;

Based on the dimensions and the relationship between dimensions and dimensions in the graph database, obtain all the dimensions associated with the once-selected dimension, and return all the dimensions associated with the once-selected dimension to the first terminal device ;

Repeat the above steps until there is no other dimension to choose, and acquire all the selected dimensions sent by the terminal device to obtain the dimension information.

In the preferred technical solution of the above data visualization processing method, before obtaining the metrics and dimensions related to each metric in the metric information according to the metric information and the pre-acquired graph database, the method further includes :

The graph database is generated and stored according to the worker's configuration of the relationship among measures, dimensions, filters and functions in the data to be processed.

In the second aspect, an embodiment of the present invention provides a data visualization processing method, which is applied to a terminal device, and the method includes:

In response to the user's first selection operation on the graphical user interface, the metric information and function information are sent to the server, the metric information includes all metrics selected by the user, the function information includes all functions selected by the user, and the graphical All selectable metrics and functions provided by the server are displayed on the user interface;

receiving and displaying on the graphical user interface the dimensions returned by the server that are related to each metric in the metric information;

sending 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;

receiving and displaying the filters associated with all dimensions in the dimensional information and the filters associated with all metrics in the metric information returned by the server on the graphical user interface;

acquiring filter information in response to a third selection operation by the user on the graphical user interface, where the filter information includes all filters selected by the user;

sending the filter information to the server;

receiving and displaying the visual data chart returned by the server on the graphical user interface.

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

sending a selected metric and function to the server in response to a first selection by the user on the graphical user interface;

receiving and displaying on the graphical user interface all metrics returned by the server associated with the once-selected metrics;

The above steps are repeated until the server returns an instruction to prohibit selection; 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.

In the preferred technical solution of the above data visualization processing method, the sending dimension information to the server in response to the user's second selection operation on the graphical user interface includes:

sending a selected dimension to the server in response to a second selection operation by the user on the graphical user interface;

receiving and displaying on the graphical user interface all dimensions returned by the server and associated with the once-selected dimension;

The above steps are repeated until the server returns no selectable dimensions; wherein, the dimension information includes the dimensions selected by the user each time.

In a third aspect, an embodiment of the present invention provides a data visualization processing device, including:

An acquisition module, configured to acquire metric information and function information selected by the terminal device, the metric information including all metrics selected by the user, and the function information including all functions selected by the user;

A processing module, configured to determine a dimension related to each metric in the metric information according to the metric information and the pre-acquired graph database;

a sending module, configured to return the dimensions related to each metric in the metric information to the terminal device;

The acquiring module is further configured to acquire dimension information selected by the terminal device, where the dimension information includes all dimensions selected by the user;

The processing module is further configured to determine, according to the dimension information, the measurement information and the graph database, the filters associated with all the dimensions in the dimension information and the filters associated with all the metrics in the measurement information filter;

The sending module is further configured to send the filter associated with all dimensions in the dimension information and the filter associated with all metrics in the metric information to the terminal device;

The acquiring module is further configured to receive filter information sent by the terminal device, where the filter information includes all filters selected by the user;

The processing module is further configured to generate a visualized data chart according to the metric information, the function information, the dimension information, the filter information, and the data in the graph database;

The sending module is further configured to return the visualized data chart to the terminal device.

In a fourth aspect, an embodiment of the present invention provides a data visualization processing device, including:

A sending module, configured to send metric information and function information to the server in response to the user's first selection operation on the graphical user interface, where the metric information includes all metrics selected by the user, and the function information includes all metrics selected by the user. function, all optional metrics and functions provided by the server are displayed on the graphical user interface;

A processing module, configured 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;

The sending module is further configured to send dimension information to the server in response to the user's second selection operation on the graphical user interface, where the dimension information includes all dimensions selected by the user;

The processing module is further configured to receive and display on the GUI the filters associated with all dimensions in the dimension information and the filters associated with all metrics in the metric information returned by the server;

An acquiring module, configured to acquire filter information in response to a third selection operation by the user on the graphical user interface, where the filter information includes all filters selected by the user;

The sending module is further configured to send the filter information to the server;

The processing module is further configured to receive and display the visual data chart returned by the server on the graphical user interface.

In a fifth aspect, an embodiment of the present invention provides a server, including:

Processor, memory, communication interface;

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

Wherein, the processor is configured to execute the data visualization processing method described in any one of the first aspect by executing the executable instructions.

In a sixth aspect, an embodiment of the present invention provides a terminal device, including:

processor, memory, display and communication interface;

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

Wherein, the processor is configured to execute the data visualization processing method according to any one of the second aspect by executing the executable instructions.

In a seventh aspect, an embodiment of the present invention provides a data visualization processing system, including:

server, terminal equipment;

The server is configured to execute the data visualization processing method described in any one of the first aspect;

The terminal device is configured to execute the data visualization processing method described in any one of the second aspect.

In an eighth aspect, an embodiment of the present invention provides a readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the data visualization processing method described in any one of the first to second aspects is realized .

In a ninth aspect, an embodiment of the present invention provides a computer program product, including a computer program, which is used to implement the data visualization processing method described in any one of the first to second aspects when the computer program is executed by a processor

Those skilled in the art can understand that the data visualization processing method, device, device, and medium provided by the embodiments of the present invention determine and measure the data based on the metric information and function information sent by the terminal device and the pre-acquired graph database through the server. The dimensions related to each measurement in the information are sent to the terminal device. The user selects a dimension through the terminal device and sends the dimension information to the server. The server determines the filters associated with all dimensions in the dimension information and Filters associated with all metrics in the metric information are sent to the terminal device. The user selects the filter through the terminal device and sends the filter information to the server. The server uses the metric information, function information, dimension information, and filter information in the graph database Generate visual data charts from the data and send them to terminal devices for display to users. In this solution, the server sends metrics, functions, dimensions, and filters to the terminal device sequentially through the server according to the relationship between the metrics, functions, dimensions, and filters in the graph database. After the user makes a selection on the terminal device, the server can generate a visual data chart to the terminal device. User presentations reduce the difficulty of generating visual data charts and improve efficiency.

Description of drawings

The preferred implementation of the data visualization processing method of the present invention will be described below with reference to the accompanying drawings. Attached are:

FIG. 1 is a schematic diagram of a scene of a data visualization processing method provided by the present invention;

Fig. 2a is a schematic flowchart of Embodiment 1 of the data visualization processing method provided by the present invention;

Figure 2b is a schematic diagram of the relationship between metrics and functions provided by the embodiment of the present invention;

Figure 2c is a schematic diagram of the relationship between dimensions and dimensions provided by the embodiment of the present invention;

FIG. 3 is a schematic flowchart of Embodiment 2 of the data visualization processing method provided by the present invention;

FIG. 4 is a schematic flowchart of Embodiment 3 of the data visualization processing method provided by the present invention;

FIG. 5 is a schematic structural diagram of Embodiment 1 of a data visualization processing device provided by the present invention;

FIG. 6 is a schematic structural diagram of Embodiment 2 of a data visualization processing device provided by the present invention;

FIG. 7 is a schematic structural diagram of a server provided by the present invention;

FIG. 8 is a schematic structural diagram of a terminal device provided by the present invention.

Detailed ways

First of all, those skilled in the art should understand that these embodiments are only used to explain the technical principles of the present invention, and are not intended to limit the protection scope of the present invention. Those skilled in the art can make adjustments as needed so as to adapt to specific applications.

Secondly, it should be noted that in the description of the embodiments of the present invention, terms such as "inside" and "outside" indicate directions or positional relationships based on the directions or positional relationships shown in the drawings, which are only for convenience Describes, but does not indicate or imply that the device or component must have a particular orientation, be constructed in a particular orientation, and operate in a particular orientation, and thus should not be construed as limiting the invention.

In addition, it should be noted that in the description of the embodiments of the present invention, unless otherwise specified and limited, the terms "connected" and "connected" should be interpreted in a broad sense, for example, it can be a fixed connection or a flexible connection. Detachable connection, or integral connection; it can be mechanical connection or electrical connection; it can be direct connection or indirect connection through an intermediary, and it can be the internal communication of two components. Those skilled in the art can understand the specific meanings of the above terms in the embodiments of the present invention according to specific situations.

In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

With the rapid development of society, users encounter more and more data in their life and work. Faced with a large number of data, users cannot directly discover the relationship between data and the trend of data changes, so they need to convert data into visualization. In the form of data charts, users can intuitively see how data changes and the relationship between data through visual data charts, which is convenient for users to understand.

In the process of data forming a visual data chart, the user needs to preprocess the data, use sql code to process the data, and input the preprocessed data and sql code into the server. The server obtains the metrics and dimensions corresponding to the data and the correspondence between metrics and dimensions according to the preprocessed data and sql code, and the server sends selectable metrics to the terminal for display to the user. The user selects the measurement he needs, and the terminal device sends the measurement selected by the user to the server. The server finds the dimension corresponding to the measurement according to the measurement selected by the user and the corresponding relationship between the measurement and the dimension, and then sends the dimension to the terminal for display to the user. The user selects For the dimension you need, the terminal device sends the dimension selected by the user to the server, and the server processes the data according to the measurement and dimension selected by the user to form a visual data chart, and then sends the visual data chart to the terminal device for display to the user. Existing data visualization methods require users to use SQL to write codes to preprocess data, resulting in low efficiency in generating visual data charts.

This embodiment provides a data visualization processing method. When the user needs to convert data into a visual data chart, the data is first sent to the server through the terminal device, and the server sends the data to the staff's terminal device. Configure the graph database for the data. The graph database includes metrics, dimensions, functions, filters, and their relationships. After the graph database is configured, it is sent to the server through the terminal device, and the server sends all metrics and functions related to the metrics to the terminal device for users to choose. After the user selects a metric and a function, the server sends the metric's function related to the metric selected by the user to the terminal device for the user to select. After the user selects the desired metric and function, the server sends the dimension related to the metric selected by the user to the terminal for the user to choose. After the user selects the dimension, the server sends the dimension related to the dimension selected by the user to the terminal for the user to choose. After the user selects the desired dimension, the server sends the filter related to the measurement and dimension selected by the user to the terminal for the user to select. After the user selects the required filters, the server processes the data according to the metrics, functions, dimensions, and filters selected by the user to form a visual data chart and send it to the terminal device for display to the user. The difficulty of generating visual data charts is reduced, and the efficiency of generating visual data charts is improved.

The principles and features of the embodiments of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the embodiments of the present invention, and are not used to limit the scope of the embodiments of the present invention.

FIG. 1 is a schematic diagram of a scenario of a data visualization processing method provided by the present invention. As shown in FIG. 1 , the application scenario includes: a terminal device 11 and a server 12 .

Exemplarily, the server 12 can acquire the metric information, function information, dimension information and filter information selected by the terminal device 11, can generate and store the graph database, and can also Determine the metric, dimension and filter related to the metric and dimension in the information sent by the terminal device 11, and can also send the metric, dimension, function, filter, forbidden selection instruction and visual data icon to the terminal device 11 .

The terminal device 11 can send metric information, function information, dimension information and filter information to the server 12, and can receive and display the metric, dimension, function, filter and visualized data chart sent by the server on the graphical user interface.

It should be noted that FIG. 1 is only a schematic diagram of the application scenario of the data visualization processing method provided by the present invention. The embodiment of the present invention does not limit the actual form and specific quantity of various devices included in FIG. The positional relationship and interaction mode between devices are limited, and can be set according to actual needs in the specific application of the solution.

It should be noted that the terminal device may be a computer or other smart terminals such as smart phones. The embodiment of the present invention does not limit the specific form of the terminal device, which may be determined according to actual needs.

Fig. 2a is a schematic flowchart of Embodiment 1 of the data visualization processing method provided by the present invention. As shown in Fig. 2a, the data visualization processing method specifically includes the following steps:

S201: Send metric information and function information to a server in response to a user's first selection operation on a graphical user interface.

When users want to use data to generate visual data charts, they need to send the data to the server through the terminal device, and after receiving the data, the server sends the data to the staff for processing. Workers configure according to the measures, dimensions, filters and functions in the data and the relationship between them, and send the configuration to the server. After receiving the configuration, the server generates and stores the graph database. After the server generates the graph database, it obtains all the metrics from the graph database and the functions related to the metrics and sends them to the terminal device. Among them, the graph database includes data, the corresponding measures, dimensions, filters, functions and the relationship between measures and measures, the relationship between measures and filters, the relationship between measures and functions, the relationship between measures and dimensions, and the relationship between dimensions and dimensions and dimension-to-filter relationships.

Exemplarily, Fig. 2b is a schematic diagram of the relationship between the measurement and the function provided by the embodiment of the present invention. As shown in Fig. 2b, when the measurement is offline volume, the functions related to the offline volume include total, new addition, year-on-year and chain ratio .

Exemplarily, FIG. 2c is a schematic diagram of the relationship between dimensions and dimensions provided by the embodiment of the present invention. As shown in FIG. 2c, when the dimension is region, the dimensions related to the dimension include province, city, and district.

It should be noted that Fig. 2b and Fig. 2c are only illustrative examples of the relationship between metrics and functions and the relationship between dimensions and dimensions. Specific limitations can be set according to actual conditions.

In this step, the terminal device displays the metrics and functions to the user on the graphical user interface after receiving them, and the user can select the metrics they need. After the user selects, the terminal device sends the measurement information and function information to the server. Furthermore, the server can determine the dimensions according to the measurement information.

It should be noted that when the staff configures the metrics, dimensions, filters, and functions in the data to be processed and the relationship between them, the metrics, dimensions, filters, and functions are used as vertices, and if there is a relationship between them, they will be configured. Connected to configure.

S202: According to the metric information and the pre-acquired graph database, determine a dimension related to each metric in the metric information.

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

In the above steps, after receiving the metric information and function information sent by the terminal device, the server can further determine the dimension related to each metric in the metric information according to the relationship between the metric and the dimension in the graph database. The server then sends the dimension related to each metric in the metric information to the terminal device for display to the user, and the user can continue to select the dimension they need.

It should be noted that before the user selects the measurement, the staff configures the relationship between the measurement, dimension, filter and function in the data to be processed, and the server generates a graph database according to the configuration and data, which is used to determine and measure, dimension Functions, Measures, Dimensions and Filters with relationships.

Exemplarily, when the measurement selected by the user is the usage time, according to the relationship between the measurement and the dimension in the graph database, the dimensions related to the usage duration include region, date and program. It should be noted that the embodiment of the present invention does not specifically limit the metric, the dimension, and the relationship between the metric and the dimension, which can be set according to actual conditions.

S204: Receive and display on the graphical user interface the dimensions returned by the server that are related to each metric in the metric information.

In this step, after receiving the dimension related to each metric in the metric information returned by the server, the terminal device displays it on the graphical user interface, so that the user can select the desired dimension.

It should be noted that, when the user wants to modify the metric selected by himself, he can click the return button on the GUI of the terminal device, and the terminal device sends a first return instruction to the server. According to the first return instruction, the server obtains all metrics from the graph database and sends them to the terminal device, and then returns to step S201.

S205: In response to the user's second selection operation on the GUI, send dimension information to the server.

In this step, after the terminal device displays the dimension related to each metric in the metric information on the graphical user interface, the user can select the desired dimension. After the user selects, the terminal device sends the dimension information to the server. In turn, the server can determine the filter according to the dimension information.

S206: According to the dimension information, the measurement information and the graph database, determine the filters associated with all the dimensions in the dimension information and the filters associated with all the metrics in the measurement information.

S207: Send the filters associated with all the dimensions in the dimension information and the filters associated with all the metrics in the measurement information to the terminal device.

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 filters associated with all metrics in the measurement information, and then the determined filters are sent to the terminal device, so that the user can select the filter he needs on the terminal device.

Exemplarily, when the dimension selected by the user is region, according to the relationship between the dimension and the filter in the graph database, there is a filter related to the region, and the region can be filtered. It should be noted that the embodiment of the present invention does not specifically limit the dimension, the filter, and the relationship between the dimension and the filter, which can be set according to actual conditions.

S208: Receive and display on the graphical user interface the filters associated with all dimensions in the dimension information and the filters associated with all metrics in the measurement information returned by the server.

In this step, after receiving the filters associated with all the dimensions in the dimension information and the filters associated with all the metrics in the measurement information returned by the server, the terminal device will display them on the user graphical interface, so that the user can choose what they need filter.

It should be noted that, when the user wants to modify the dimension selected by himself, he can click the return button on the GUI of the terminal device, and the terminal device sends a second return instruction to the server. The server returns to step S203 according to the second return instruction.

S209: Obtain filter information in response to a third selection operation performed by the user on the graphical user interface.

S210: Send the filter information to the server.

In the above steps, after the terminal device displays the filters associated with all the dimensions in the dimension information and the filters associated with all the metrics in the measurement information on the graphical user interface, the user can select the desired filter. After the user selects, the terminal can obtain the filter information selected by the user, and then send the filter information to the server. Furthermore, the server can generate visual data charts according to the measurement information, function information, dimension information, filter information and data in the graph database.

It should be noted that the number of filters selected by the user may be one or multiple, and this embodiment of the present invention does not specifically limit the number of filters selected by the user, which may be selected according to actual conditions.

S211: Generate a visual data chart according to the measurement information, function information, dimension information, and filter information and data in the graph database.

S212: Return the visualized data chart to the terminal device.

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

It should be noted that the server has the ability to automatically generate visual data charts, and the embodiment of the present invention does not specifically limit the method for the server to generate visual data charts based on measurement information, function information, dimension information, filter information, and data in the graph database. It can be set according to the actual situation.

S213: Receive and display the visual data chart returned by the server on the GUI.

In this step, the terminal device displays the visual data graph returned by the server on the user graphical interface, so that the user can view it freely.

It should be noted that, when the user wants to modify the filter selected by himself, he can click the return button on the GUI of the terminal device, and the terminal device sends a third return instruction to the server. The server returns to step S207 according to the third return instruction.

In the data visualization processing method provided in this embodiment, the staff configures the data, the server generates a graph database according to the configuration, and the user selects the metrics and functions he needs on the terminal device and sends them to the server. The server determines the dimension according to the relationship between the measurement and the dimension in the graph database and sends it to the terminal device to display to the user. The user selects the dimension he needs and sends it to the server. The server determines the filter according to the relationship between metrics, dimensions, and the metrics and filters, and dimensions and filters in the graph database, and then sends it to the terminal device for display to the user. Users select the filters they need and send them to the server, and then the server can generate visual data charts based on metrics, functions, dimensions, and filters and send them to terminal devices for display to users. Compared with the prior art, the user needs to use SQL language to write codes to preprocess the data. In this solution, the user only needs to select metrics, functions, dimensions and filters on the user graphical interface, and the server selects the metrics, functions, and Dimensions and the pre-acquired graph database can determine the dimensions and filters that are related to the metrics and dimensions selected by the user. Finally, after obtaining the measurement information, function information, dimension information, and filter information, a visual data chart can be generated and sent to The display of the terminal device to the user effectively reduces the difficulty of generating the visualized data graph and increases the efficiency of generating the visualized data graph.

Fig. 3 is a schematic flowchart of the second embodiment of the data visualization processing method provided by the present invention. As shown in Fig. 3, in this embodiment, the above step S201 can be realized by the following steps:

S301: Send a selected metric and function to the server in response to a first selection operation by a user on a graphical user interface.

In this step, the terminal device displays the metrics and functions to the user on the graphical user interface after receiving them, and the user can select the metrics and functions they need. After the user selects a metric and function, the terminal device sends the selected metrics and functions to the server . In turn, the server can determine the metrics that are related to the selected metrics from the graph database.

S302: Receive the metric and function of one selection sent by the terminal device, and record the cumulative number of selections.

In this step, after receiving the metrics and functions sent by the terminal device, the server records the accumulated selection times for comparison with the preset times. When the cumulative number of selections is less than the preset number of times, the user can continue to select the metric, and when the cumulative number of selections is equal to the preset number of times, the user cannot continue to select the metric.

S303: Obtain all metrics associated with the once-selected metric based on the once-selected metric and the relationship between the metric and the metric in the graph database, and return all the metrics associated with the once-selected metric to the terminal device.

In this step, the relationship between metrics and metrics exists in the graph database stored on the server, and all metrics associated with a selected metric can be obtained according to the relationship between metrics and metrics, and then sent to the terminal device for display to the user, so that the user You can continue to select metrics.

S304: Receive and display on the graphical user interface all metrics associated with the once-selected metrics returned by the server.

In this step, the terminal device displays all the metrics associated with the once-selected metrics returned by the server and displays them on the graphical user interface, so that the user can continue to select the metrics he needs.

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

In this step, the user can continuously select metrics until the number of times of selecting metrics is equal to the preset number of times, and the user cannot continue to select metrics, so as to avoid running problems of the server. The server receives the metric selected by the user each time sent by the terminal device, and then obtains metric information, and the server receives the function selected by the user each time sent by the terminal device, and then obtains the function information.

It should be noted that the preset number of times is set by the staff on the server before the user sends the data to the server, and is used for comparison with the accumulated selection times of the user selection metric. When the cumulative number of selections is less than the preset number of times, the user can continue to select the metric, and when the cumulative number of selections is equal to the preset number of times, the user cannot continue to select the metric. The embodiment of the present invention does not specifically limit the preset times, which can be set according to actual conditions.

It should be noted that when the number of times the user selects metrics does not reach the preset number of times, but wants to terminate the selection of metrics and functions, the user can click the button to terminate the selection of metrics on the user graphical interface on the terminal device, and the terminal device sends the selection to the server. Dimension directives. Based on the measurement information and the graph database, the server can determine the dimension related to each measurement in the measurement information and send it to the terminal device, so that the user can select the dimension.

It should be noted that when the user selects a metric, he also selects a function related to the metric. When the terminal device sends a function to the server, it can send the function at the same time when sending the metric to the server, or when the number of times the user selects the metric reaches the preset value. All the functions selected by the user are sent to the server at one time, and all the functions selected by the user can be sent to the server at one time when the terminal device sends an instruction to select the dimension to the server. The embodiment of the present invention does not send the terminal device to the server. The timing of the function is specifically limited and can be set according to the actual situation.

S306: Send a prohibition selection indication to the terminal device.

In this step, when the cumulative number of selections reaches the preset number of times, the server sends a prohibition of selection command to the terminal device, and the terminal device prohibits the user from making selections on the GUI to avoid misuse.

In the data visualization processing method provided in this embodiment, the user selects a metric and a function on the terminal device, and the terminal device sends the metric and the function to the server. The server determines the metric that is related to the metric selected by the user according to the relationship between the metric and the metric in the graph database, and then sends it to the terminal device for the user to choose, until the cumulative number of selections by the user reaches the preset number of times and then stops the selection. Compared with the existing technology, which only selects the measurement once, this solution can select the measurement multiple times, and the generated visual data chart is more in line with the user's needs.

Fig. 4 is a schematic flow chart of the third embodiment of the data visualization processing method provided by the present invention. As shown in Fig. 4, in this embodiment, step S205 in the above-mentioned embodiment 1 can be realized by the following steps:

S401: Send a selected dimension to the server in response to a second selection operation by the user on the graphical user interface;

In this step, the terminal device displays the dimension to the user on the graphical user interface after receiving the dimension, and the user can select the dimension he needs. After the user selects a dimension, the terminal device sends the selected dimension to the server. Furthermore, the server can determine the dimensions related to the selected dimension according to the graph database.

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

In this step, the relationship between dimensions and dimensions exists in the graph database stored on the server. According to the relationship between dimensions and dimensions, all the dimensions associated with the selected dimension can be obtained, and then sent to the terminal device for display to the user, so that the user can You can continue to select dimensions.

S403: Receive and display on the graphical user interface all dimensions returned by the server and associated with the once selected dimension.

In this step, the terminal device displays all the dimensions associated with the once-selected dimension returned by the server on the graphical user interface, so that the user can continue to select the dimension he needs.

S404: Repeat the above steps until there are no other dimensions to choose, and obtain all selected dimensions sent by the terminal device to obtain dimension information.

In this step, the user can continue to select dimensions until there is no other dimension to choose and no more dimensions can be selected. The server receives the dimension selected by the user each time sent by the terminal device, and then obtains dimension information.

Exemplarily, when the dimension selected by the user is a mixing program, according to the relationship between dimensions and dimensions in the graph database, the dimensions related to the mixing program include drying mode parameters, rinsing times parameters, temperature parameters and dehydration speed parameters. It should be noted that the embodiment of the present invention does not specifically limit the dimension and the relationship between the dimension and the dimension, which can be set according to the actual situation.

It should be noted that, when the user can still select a dimension, but wants to terminate the selection of the dimension, the user can click the stop selecting the dimension button on the user graphical interface on the terminal device, and the terminal device sends an instruction to select a filter to the server. Based on the measurement information, dimension information and graph database, the server can determine the filters associated with all the dimensions in the dimension information and the filters associated with all the measurements in the measurement information and send them to the terminal device, so that the user can select the filter.

In the data visualization processing method provided in this embodiment, the user selects a dimension on the terminal device, and the terminal device sends the dimension to the server. According to the relationship between the dimensions in the graph database, the server determines the dimension that is related to the dimension selected by the user, and then sends it to the terminal device for the user to choose, until there is no dimension to choose, and the selection stops. Compared with the existing technology, which can only select dimensions once, this solution can select dimensions multiple times, and the generated visual data charts are more in line with user needs.

FIG. 5 is a schematic structural diagram of Embodiment 1 of a data visualization processing device provided by the present invention; as shown in FIG. 5 , the data visualization processing device 50 includes:

An acquisition module 51, configured 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;

A processing module 52, configured to determine a dimension related to each metric in the metric information according to the metric information and the pre-acquired graph database;

A sending module 53, configured to return the dimensions related to each metric in the metric information to the terminal device;

The acquiring module 51 is further configured to acquire dimension information selected by the terminal device, where the dimension information includes all dimensions selected by the user;

The processing module 52 is further configured to determine, according to the dimension information, the metric information and the graph database, the filters associated with all the dimensions in the dimensional information and the filters associated with all the metrics in the metric information filter for

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 metrics in the metric information to the terminal device;

The acquiring module 51 is further configured to receive filter information sent by the terminal device, where the filter information includes all filters selected by the user;

The processing module 52 is further configured to generate a visualized data chart according to the metric information, the function information, the dimension information, the filter information, and the data in the graph database;

The sending module 53 is further configured to return the visualized data chart to the terminal device.

Further, the acquisition module 51 is further configured to receive a selected metric and function sent by the terminal device.

Further, the processing module 52 is also configured to record the cumulative selection times.

Further, the processing module 52 is further configured to obtain all metrics associated with the once-selected metric based on the once-selected metric and the relationship between metrics in the graph database.

Further, the sending module 53 is further configured to return all metrics associated with the once-selected metrics to the terminal device.

Further, the sending module 53 is further configured to send an instruction to prohibit selection to the terminal device after the accumulated number of times of selection reaches the preset number of times.

Further, the obtaining module 51 is further configured to receive a selected dimension sent by the terminal device.

Further, the processing module 52 is further configured to obtain all dimensions associated with the once-selected dimension based on the dimension and the relationship between dimensions in the graph database.

Further, the sending module 53 is further configured to return all dimensions associated with the dimension selected once to the first terminal device.

Further, the processing module 52 is also configured to generate and store the graph database according to the staff's configuration of the relationship among the metrics, dimensions, filters and functions in the data to be processed.

The data visualization processing device provided in this embodiment is used to execute the technical solution of the server in any of the foregoing method embodiments, and its implementation principle and technical effect are similar. The server can determine the metrics, dimensions, and filters that are related to the metrics and dimensions sent by the terminal device according to the relationship between metrics, functions, dimensions, and filters in the graph database, and then send them to the terminal for user selection. The difficulty of generating visual data charts is reduced, and the efficiency of generating visual data charts is improved.

FIG. 6 is a schematic structural diagram of Embodiment 2 of a data visualization processing device provided by the present invention; as shown in FIG. 6 , the data visualization processing device 60 includes:

The sending module 61 is configured 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 the metric selected by the user. All functions, all optional metrics and functions provided by the server are displayed on the graphical user interface;

A processing module 62, configured 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;

The sending module 61 is further configured to send dimension information to the server in response to the user's second selection operation on the graphical user interface, where the dimension information includes all dimensions selected by the user;

The processing module 62 is further configured to receive and display on the GUI the filters associated with all dimensions in the dimension information and the filters associated with all metrics in the metric information returned by the server ;

An obtaining module 63, configured to obtain filter information in response to a third selection operation by the user on the graphical user interface, where the filter information includes all filters selected by the user;

The sending module 61 is further configured to send the filter information to the server;

The processing module 62 is further configured to receive and display the visual data chart returned by the server on the graphical user interface.

Further, the sending module 61 is also configured to send a selected metric and function to the server in response to a first selection operation by the user on the graphical user interface;

Further, the processing module 62 is further configured to receive and display on the graphical user interface all metrics associated with the once-selected metrics returned by the server.

Further, the sending module 61 is further configured to send a selected dimension to the server in response to a second selection operation by the user on the graphical user interface.

Further, the processing module 62 is further configured to receive and display on the graphical user interface all the dimensions returned by the server and associated with the once-selected dimension.

The data visualization processing device provided in this embodiment is used to implement the technical solution of the terminal device in any of the foregoing method embodiments, and its implementation principle and technical effect are similar, and will not be repeated here.

FIG. 7 is a schematic structural diagram of a server provided by the present invention. As shown in Figure 7, the server 70 includes:

Processor 71, memory 72, and communication interface 73;

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

Wherein, the processor 71 is configured to execute the technical solution of the server in any of the foregoing method embodiments by executing the executable instructions.

Optionally, the memory 72 can be independent or integrated with the processor 71 .

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

The bus is used to connect the above devices together.

The server is used to implement the server-side technical solutions in any of the foregoing method embodiments, and its implementation principles and technical effects are similar, and will not be repeated here.

FIG. 8 is a schematic structural diagram of a terminal device provided by the present invention. As shown in Figure 8, the terminal device 80 includes:

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

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

Wherein, 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.

Optionally, the memory 82 can be independent or integrated with the processor 81 .

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

The bus is used to connect the above devices together.

The terminal device is used to implement the technical solution on the terminal device side in any of the foregoing method embodiments, and its implementation principles and technical effects are similar, and details are not repeated here.

An embodiment of the present invention also provides a readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the technical solution on the server or terminal device side provided in any of the foregoing embodiments is implemented.

An embodiment of the present invention also provides a computer program product, including a computer program, and when the computer program is executed by a processor, it is used to implement the technical solution on the server or terminal device side provided by any of the foregoing method embodiments.

Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present invention, rather than limiting them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: It is still possible to modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements for some or all of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the technical solutions of the various embodiments of the present invention. scope.

Claims (15)

1. A processing method for data visualization, characterized in that it is applied to a central server, and the method comprises: Acquire metric information and function information selected by the terminal device, where the metric information includes all metrics selected by the user, and the function information includes all functions selected by the user; According to the metric information and the pre-acquired graph database, determine the dimensions related to each metric in the metric information, wherein the graph database includes data, and the metrics, dimensions, filters, functions, and Measure-to-measure, measure-filter, measure-function, measure-dimension, dimension-dimension, and dimension-filter relationships; returning the dimensions related to each metric in the metric information to the terminal device; Obtain dimension information selected by the terminal device, where the dimension information includes all dimensions selected by the user; Determine filters associated with all dimensions in the dimension information and filters associated with all metrics in the measurement information according to the dimension information, the measurement information, and the graph database; sending the filters associated with all dimensions in the dimensional information and the filters associated with all metrics in the metric information to the terminal device; receiving filter information sent by the terminal device, where the filter information includes all filters selected by the user; generating a visual data chart according to the metric information, the function information, the dimension information, the filter information and the data in the graph database; returning the visualized data chart to the terminal device. 2. The method according to claim 1, wherein said obtaining the metric information and function information selected by the terminal device comprises: receiving a selected metric and function sent by the terminal device, and recording the cumulative number of selections; Obtain all metrics associated with the once-selected metric based on the once-selected metric and the relationship between metrics and metrics in the graph database, and return all metrics associated with the once-selected metric to the terminal equipment; Repeating the above steps until the cumulative number of selections reaches a preset number of times, acquiring all metrics sent by the terminal device to obtain the metric information, and acquiring all functions sent by the terminal device to obtain the function information. 3. The method according to claim 2, wherein the method further comprises: After the accumulated number of times of selection reaches the preset number of times, an indication of prohibiting selection is sent to the terminal device, where the indication of prohibiting selection is used to instruct the user to no longer perform metric selection. 4. The method according to claim 1 or 2, wherein the acquiring dimension information selected by the terminal device comprises: receiving a selected dimension sent by the terminal device; Based on the dimensions and the relationship between dimensions and dimensions in the graph database, obtain all the dimensions associated with the once-selected dimension, and return all the dimensions associated with the once-selected dimension to the first terminal device ; Repeat the above steps until there is no other dimension to choose, and acquire all the selected dimensions sent by the terminal device to obtain the dimension information. 5. The method according to claim 1 or 2, wherein, before obtaining the metrics and dimensions related to each metric in the metric information according to the metric information and the pre-acquired graph database, the The method also includes: The graph database is generated and stored according to the worker's configuration of the relationship among measures, dimensions, filters and functions in the data to be processed. 6. A processing method for data visualization, characterized in that it is applied to a terminal device, the method comprising: In response to the user's first selection operation on the graphical user interface, the metric information and function information are sent to the server, the metric information includes all metrics selected by the user, the function information includes all functions selected by the user, and the graphical All selectable metrics and functions provided by the server are displayed on the user interface; receiving and displaying on the graphical user interface the dimensions returned by the server that are related to each metric in the metric information; sending 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; receiving and displaying the filters associated with all dimensions in the dimensional information and the filters associated with all metrics in the metric information returned by the server on the graphical user interface; acquiring filter information in response to a third selection operation by the user on the graphical user interface, where the filter information includes all filters selected by the user; sending the filter information to the server; receiving and displaying the visual data chart returned by the server on the graphical user interface. 7. The method according to claim 6, wherein the sending the metric information and function information to the server in response to the user's first selection operation on the graphical user interface comprises: sending a selected metric and function to the server in response to a first selection by the user on the graphical user interface; receiving and displaying on the graphical user interface all metrics returned by the server associated with the once-selected metrics; The above steps are repeated until the server returns an instruction to prohibit selection; 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, wherein the sending dimension information to the server in response to the user's second selection operation on the graphical user interface comprises: sending a selected dimension to the server in response to a second selection operation by the user on the graphical user interface; receiving and displaying on the graphical user interface all dimensions returned by the server and associated with the once-selected dimension; The above steps are repeated until the server returns no selectable dimensions; wherein, the dimension information includes the dimensions selected by the user each time. 9. A processing device for data visualization, comprising: An acquisition module, configured 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; A processing module, configured to determine a dimension related to each metric in the metric information according to the metric information and the pre-acquired graph database; a sending module, configured to return the dimensions related to each metric in the metric information to the terminal device; The acquiring module is further configured to acquire dimension information selected by the terminal device, where the dimension information includes all dimensions selected by the user; The processing module is further configured to determine, according to the dimension information, the measurement information and the graph database, the filters associated with all the dimensions in the dimension information and the filters associated with all the metrics in the measurement information filter; The sending module is further configured to send the filter associated with all dimensions in the dimension information and the filter associated with all metrics in the metric information to the terminal device; The acquiring module is further configured to receive filter information sent by the terminal device, where the filter information includes all filters selected by the user; The processing module is further configured to generate a visualized data chart according to the metric information, the function information, the dimension information, the filter information, and the data in the graph database; The sending module is further configured to return the visualized data chart to the terminal device. 10. A processing device for data visualization, comprising: A sending module, configured to send metric information and function information to the server in response to the user's first selection operation on the graphical user interface, where the metric information includes all metrics selected by the user, and the function information includes all metrics selected by the user. function, all optional metrics and functions provided by the server are displayed on the graphical user interface; A processing module, configured 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; The sending module is further configured to send dimension information to the server in response to the user's second selection operation on the graphical user interface, where the dimension information includes all dimensions selected by the user; The processing module is further configured to receive and display on the GUI the filters associated with all dimensions in the dimension information and the filters associated with all metrics in the metric information returned by the server; An acquiring module, configured to acquire filter information in response to a third selection operation by the user on the graphical user interface, where the filter information includes all filters selected by the user; The sending module is further configured to send the filter information to the server; The processing module is further configured to receive and display the visual data chart returned by the server on the graphical user interface. 11. A server, characterized in that, comprising: Processor, memory, communication interface; The memory is used to store executable instructions of the processor; Wherein, 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 it comprises: processor, memory, display and communication interface; The memory is used to store executable instructions of the processor; Wherein, 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, comprising: server, terminal equipment; The server is used to execute the data visualization processing method described in any one of claims 1 to 5; The terminal device is configured to execute the data visualization processing method described in any one of claims 6 to 8. 14. A readable storage medium, on which a computer program is stored, wherein when the computer program is executed by a processor, the data visualization processing method according to any one of claims 1 to 8 is realized. 15. A computer program product, characterized by comprising a computer program, the computer program is used to implement the data visualization processing method according to any one of claims 1 to 8 when executed by a processor.

Images