CN116069996A

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

Info

Publication number: CN116069996A
Application number: CN202111273014.7A
Authority: CN
Inventors: 张淑霞; 邹存璐; 许升
Original assignee: Haier Smart Home Co Ltd; Qingdao Jiaozhou Haier Washing Electric Appliance Co Ltd
Current assignee: Haier Smart Home Co Ltd; Qingdao Jiaozhou Haier Washing Electric Appliance Co Ltd
Priority date: 2021-10-29
Filing date: 2021-10-29
Publication date: 2023-05-05

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

The embodiment of the invention belongs to the field of big data, and particularly relates to a data visualization processing method, device, equipment and medium.

Background

With the rapid development of society, users need to make charts by using various data to realize the visualization of the data, and the change trend of the data, the duty ratio of the data and the like can be intuitively reflected through the display of the charts, so that the user can conveniently understand the charts.

In the prior art, a user preprocesses data needed to form a chart by writing a structured query language (Structured Query Language, abbreviated as sql) code, inputs the preprocessed data and the sql code into a server, the server obtains a corresponding measurement and dimension of the data and a corresponding relation between the measurement and the dimension according to the preprocessed data and the sql code, the server sends a selectable measurement to a terminal for displaying, the user selects the measurement needed by the user, the terminal equipment sends the measurement selected by the user to the server, the server finds the dimension corresponding to the measurement according to the corresponding relation between the measurement selected by the user and the dimension, the dimension is sent to the terminal for displaying, the user selects the dimension needed by the user, the terminal equipment sends the dimension selected by the user to the server, the server processes the data according to the measurement and the dimension selected by the user to form the chart, and the chart is sent to the terminal equipment for displaying.

In summary, the existing data visualization method needs the user to preprocess the data by using the sql language to write the code, so that the chart can be generated, and the requirement on the common user is high, so that the difficulty and the efficiency of generating the chart are high.

Disclosure of Invention

In order to solve the problems in the prior art, namely the problems of high difficulty and low efficiency in generating a visual data chart in the prior art, the embodiment of the invention provides a data visualization processing method, device, equipment and medium.

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

acquiring measurement information and function information selected by a terminal device, wherein the measurement information comprises all measurement selected by a user, and the function information comprises all functions selected by the user;

determining a dimension related to each measurement in the measurement information according to the measurement information and a pre-acquired graph database, wherein the graph database comprises data, and the measurement, the dimension, a filter, a function, a relation between the measurement and the measurement, a relation between the measurement and the filter, a relation between the measurement and the function, a relation between the measurement and the dimension, a relation between the dimension and a relation between the dimension and the filter corresponding to the data;

Returning the dimension related to each measurement in the measurement information to the terminal equipment;

acquiring dimension information selected by the terminal equipment, wherein the dimension information comprises all dimensions selected by the user;

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

transmitting the filter associated with all dimensions in the dimension information and the filter associated with all metrics in the metric information to the terminal equipment;

the method comprises the steps of receiving filter information sent by the terminal equipment, wherein the filter information comprises all filters selected by a user;

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

and returning the visual data chart to the terminal equipment.

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

Receiving one-time selection metrics and functions sent by the terminal equipment, and recording accumulated selection times;

based on the one-time selected metric and the relation between the metrics and the metrics in the graph database, acquiring all metrics associated with the one-time selected metric, and returning all metrics associated with the one-time selected metric to the terminal equipment;

repeating the steps until the accumulated selection times reach preset times, acquiring all metrics sent by the terminal equipment to obtain the metric information, and acquiring all functions sent by the terminal equipment to obtain the function information.

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

and after the accumulated selection times reach the preset times, sending a selection prohibition instruction to the terminal equipment, wherein the selection prohibition instruction is used for indicating that the user does not perform measurement selection any more.

In the preferred technical scheme of the data visualization processing method, the acquiring the dimension information selected by the terminal device includes:

receiving a dimension selected once and sent by the terminal equipment;

acquiring all dimensions associated with the once selected dimension based on the relationship between the dimension and the dimension in the graph database, and returning all dimensions associated with the once selected dimension to the first terminal equipment;

Repeating the steps until no other dimension is selectable, and acquiring all selected dimensions sent by the terminal equipment to obtain the dimension information.

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

and generating and storing the graph database according to the configuration of the relation between the measures, the dimensions, the screeners and the functions in the data to be processed of the staff.

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

in response to a first selection operation of a user on a graphical user interface, sending metric information and function information to a server, wherein the metric information comprises all metrics selected by the user, the function information comprises all functions selected by the user, and all selectable metrics and functions provided by the server are displayed on the graphical user interface;

receiving and displaying the dimension which is returned by the server and is related to each measurement in the measurement information on the graphical user interface;

Responsive to a second selection operation by a user on the graphical user interface, sending dimension information to the server, the dimension information including all dimensions selected by the user;

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

responding to a third selection operation of the user on the graphical user interface, and acquiring filter information, wherein the filter information comprises all filters selected by the user;

transmitting the filter information to the server;

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

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

responsive to a first selection operation of the user on the graphical user interface, sending the one-time selected metrics and functions to the server;

receiving and displaying all metrics returned by the server in association with the one-time selected metrics on the graphical user interface;

Repeating the steps until the server returns a forbidden selection instruction; the measurement information comprises measurement selected by the user each time, and the function information comprises functions selected by the user each time.

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

responsive to a second selection operation of the user on the graphical user interface, sending the one-time selected dimension to the server;

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

repeating the steps until the server does not return to the optional dimension; wherein the dimension information includes a dimension of each selection by the user.

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

the acquisition module is used for acquiring measurement information and function information selected by the terminal equipment, wherein the measurement information comprises all the measurement selected by a user, and the function information comprises all the functions selected by the user;

The processing module is used for determining the dimension related to each measurement in the measurement information according to the measurement information and a pre-acquired graph database;

a sending module, configured to return the dimension 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 metric information and the graph database, filters associated with all dimensions in the dimension information and filters associated with all metrics in the metric information;

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 acquisition 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 used for generating a visualized data chart according to the measurement information, the function information, the dimension information, the filter information and the data in the chart database;

And the sending module is also used for returning the visual data chart to the terminal equipment.

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

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

the processing module is used for receiving and displaying the dimension which is returned by the server and is related to each measurement in the measurement information on the graphical user interface;

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

the processing module is further used for receiving and displaying the screeners which are returned by the server and are associated with all the dimensions in the dimension information and the screeners which are associated with all the metrics in the metric information on the graphical user interface;

The acquisition module is used for responding to a third selection operation of the user on the graphical user interface and acquiring filter information, wherein the filter information comprises all filters selected by the user;

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

and the processing module is also used for receiving and displaying 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:

a processor, a memory, a communication interface;

the memory is used for storing executable instructions of the processor;

wherein the processor is configured to perform the processing method of data visualization of any of the first aspects via execution of the executable instructions.

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

a processor, a memory, a display, and a communication interface;

the memory is used for storing executable instructions of the processor;

wherein the processor is configured to perform the method of processing data visualization of any of the second aspects via execution of the executable instructions.

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

a server, a terminal device;

the server is used for executing the processing method of the data visualization in any one of the first aspects;

the terminal device is configured to perform the processing method for data visualization according to any one of the second aspects.

In an eighth aspect, an embodiment of the present invention provides a readable storage medium having stored thereon a computer program which, when executed by a processor, implements the processing method of data visualization of any one of the first to second aspects.

In a ninth aspect, embodiments of the present invention provide a computer program product comprising a computer program which, when executed by a processor, is adapted to implement a method of processing data according to any one of the first to second aspects

It can be understood by those skilled in the art that, according to the processing method, the device, the equipment and the medium for data visualization provided by the embodiment of the invention, the server determines the dimension related to each measurement in the measurement information according to the measurement information and the function information sent by the terminal equipment and the pre-acquired graph database, and sends the dimension information to the terminal equipment, the user selects the dimension through the terminal equipment and sends the dimension information to the server, the server determines the filter associated with all the dimensions in the dimension information and the filter associated with all the measurement in the measurement information according to the dimension information, the measurement information and the graph database, and sends the filter information to the terminal equipment, and the user selects the filter through the terminal equipment and sends the filter information to the server, and the server generates a visual data chart according to the measurement information, the function information, the dimension information and the data in the filter information and the graph database and sends the visual data chart to the terminal equipment for display to the user. According to the scheme, the server sequentially sends the metrics, the functions, the dimensions and the filters to the terminal equipment according to the relation among the metrics, the functions, the dimensions and the filters in the graph database, after the user selects the terminal equipment, the server can generate a visual data chart to be displayed to the user, so that the difficulty of generating the visual data chart is reduced, and the efficiency is improved.

Drawings

Preferred embodiments of the processing method of data visualization of the present invention are described below with reference to the accompanying drawings. The attached drawings are as follows:

FIG. 1 is a schematic view of a scenario of a processing method for data visualization provided by the present invention;

FIG. 2a is a schematic flow chart of a first embodiment of a data visualization processing method according to the present invention;

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

FIG. 2c is a schematic diagram of dimensions versus dimensions provided by an embodiment of the present invention;

FIG. 3 is a schematic flow chart of a second embodiment of a data visualization processing method according to the present invention;

FIG. 4 is a schematic flow chart of a third embodiment of a data visualization processing method according to the present invention;

FIG. 5 is a schematic diagram of a first embodiment of a data visualization processing apparatus according to the present invention;

FIG. 6 is a schematic structural diagram of a second embodiment of a data visualization processing apparatus according to the present invention;

fig. 7 is a schematic structural diagram of a server according to the present invention;

fig. 8 is a schematic structural diagram of a terminal device according to the present invention.

Detailed Description

First, it should be understood by those skilled in the art that these embodiments are merely for explaining the technical principles of the present invention, and are not intended to limit the scope of the present invention. Those skilled in the art can adapt it as desired to suit a particular application.

Further, it should be noted that, in the description of the embodiments of the present invention, terms such as directions or positional relationships indicated by the terms "inner", "outer", and the like are based on directions or positional relationships shown in the drawings, which are merely for convenience of description, and do not indicate or imply that the apparatus or the member must have a specific orientation, be constructed and operated in a specific orientation, and thus should not be construed as limiting the present invention.

Furthermore, it should be noted that, in the description of the embodiments of the present invention, unless explicitly specified and limited otherwise, the terms "connected," "connected," and "connected" are to be construed broadly, and may be, for example, fixedly connected, detachably connected, or integrally connected; can be mechanically or electrically connected; can be directly connected or indirectly connected through an intermediate medium, and can be the communication between the two components. The specific meaning of the above terms in the embodiments of the present invention can be understood by those skilled in the art according to the specific circumstances.

For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.

With the rapid development of society, more and more data are encountered by users in life and work, and the users cannot directly find the relationship among the data, the change trend of the data and the like in face of the various data, the data are required to be converted into a visual data chart form, and the users can intuitively see how the data change through the visual data chart, so that the understanding of the users is facilitated.

In the process of forming a visual data chart by data, a user needs to preprocess the data, process the data by using the sql code, and input the preprocessed data and the sql code into a server. And the server obtains the measurement and the dimension corresponding to the data and the corresponding relation between the measurement and the dimension according to the preprocessed data and the sql code, and sends the selectable measurement to the terminal for display to the user. The user selects the needed measurement, the terminal equipment sends the measurement selected by the user to the server, the server finds the dimension corresponding to the measurement according to the corresponding relation between the measurement and the dimension selected by the user, the dimension is sent to the terminal to be displayed to the user, the user selects the needed dimension, the terminal equipment sends the dimension selected by the user to the server, the server processes the data according to the measurement and the dimension selected by the user to form a visual data chart, and the visual data chart is sent to the terminal equipment to be displayed to the user. The existing data visualization method requires a user to preprocess data by using sql written codes, so that the efficiency of generating a visualized data chart is low.

The embodiment provides a data visualization processing method, when a user needs to convert data into a visualized data chart, the data is firstly sent to a server through a terminal device, the server sends the data to terminal devices of staff, and the staff performs chart database configuration on the data. The graph database comprises metrics, dimensions, functions, filters and relations among the metrics, the functions, the filters and the relations among the metrics, the filters, the dimensions, the functions, the filters and the relations among the metrics are transmitted to the server through the terminal equipment after the configuration of the graph database is completed, and the server transmits the functions with the relations among all the metrics and the metrics to the terminal equipment for the user to select. After the user selects one of the metrics and functions, the server sends the function of the metric related to the user selected metric to the terminal device for the user to select. After the user selects the required measurement and function, the server sends the dimension related to the measurement selected by the user to the terminal for the user to select, 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 select, and after the user selects the required 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 filter, the server processes the data according to the metrics, functions, dimensions and the filter selected by the user to form a visual data chart, and the visual data chart is sent to the terminal equipment to be displayed to the user. The difficulty of generating the visual data chart is reduced, and the efficiency of generating the visual data chart is improved.

The principles and features of embodiments of the present invention are described below with reference to the drawings, the examples are provided for the purpose of illustrating the embodiments of the present invention and are not intended to limit the scope of the embodiments of the present invention.

Fig. 1 is a schematic view of a scenario of a processing method for data visualization provided by the present invention, as shown in fig. 1, where the application scenario includes: a terminal device 11 and a server 12.

The server 12 may obtain the metric information, the function information, the dimension information and the filter information selected by the terminal device 11, and may generate and store a graph database, determine the metric, the dimension and the filter related to the metric and the dimension in the information sent by the terminal device 11 according to the relationship between the metric, the dimension, the function and the filter in the graph database, and may send the metric, the dimension, the function, the filter, the forbidden selection instruction and the visualized data icon to the terminal device 11.

The terminal device 11 may send metric information, function information, dimension information and filter information to the server 12, capable of receiving and displaying the metrics, dimensions, functions, filters and visual data charts sent by the server on the user graphical interface.

It should be noted that, fig. 1 is only an application scenario schematic diagram of the data visualization processing method provided by the present invention, and the embodiment of the present invention does not limit the actual form and specific number of the various devices included in fig. 1, nor limit the positional relationship and interaction manner between the devices in fig. 1, and in a specific application of the scheme, the method may be set according to actual requirements.

The embodiment of the invention does not limit the specific form of the terminal equipment, and can be determined according to actual requirements.

Fig. 2a is a schematic flow chart of a first embodiment of a data visualization processing method provided by the present invention, and as shown in fig. 2a, the data visualization processing method specifically includes the following steps:

s201: in response to a first selection operation by a user on the graphical user interface, the metric information and the function information are sent to the server.

When a user wants to generate a visual data chart by using data, the data is required to be sent to a server through terminal equipment, and the server receives the data and then sends the data to staff for processing. The worker configures the filter and function and the relationship between them according to the metrics, dimensions, filters and relationships in the data and sends the configuration to the server. After the server receives the configuration, a graph database is generated and stored, and after the server generates the graph database, all the metrics and the functions related to the metrics are acquired from the graph database and sent to the terminal equipment. The graph database comprises data, and the metrics, the dimensions, the filters, the functions, the relationships between the metrics and the metrics, the relationships between the metrics and the filters, the relationships between the metrics and the functions, the relationships between the metrics and the dimensions, the relationships between the dimensions and the relationships between the dimensions and the filters corresponding to the data.

Fig. 2b is a schematic diagram of a relationship between a metric and a function provided by an embodiment of the present invention, where, as shown in fig. 2b, when the metric is a offline amount, the function related to the offline amount has total, new increment, same ratio, and ring ratio.

Fig. 2c is a schematic diagram of a relationship between dimensions provided in an embodiment of the present invention, where, as shown in fig. 2c, when the dimensions are regions, the dimensions related to the dimensions have provinces, cities and regions.

It should be noted that, fig. 2b and fig. 2c are only examples for illustrating the relationship between the metric and the function and the relationship between the dimension and the dimension, and the embodiment of the present invention does not specifically limit the relationship between the metric, the function, the dimension, and the relationship between the metric and the function, and the relationship between the dimension and the dimension, and may be set according to practical situations.

In this step, after receiving the metrics and the functions, the terminal device displays the metrics and the functions to the user in the user graphical interface, and the user can select the metrics required by the user. After the user selects, the terminal equipment sends the measurement information and the function information to the server. The server may then determine the dimensions based on the metric information.

When the staff performs the configuration of the measurement, dimension, filter and function and the relation between them in the data to be processed, the configuration is performed in a mode that the relation between them is connected according to the measurement, dimension, filter and function as vertexes.

S202: and determining the dimension related to each measurement in the measurement information according to the measurement information and a pre-acquired graph database.

S203: the dimensions associated with each metric in the metric information are returned to the terminal device.

In the above step, after receiving the metric information and the function information sent by the terminal device, the server may further determine a dimension related to each metric in the metric information according to the relationship between the metrics and the dimensions in the graph database. The server sends the dimension related to each measurement in the measurement information to the terminal equipment for display to the user, and the user can continue to select the dimension required by the user.

Before the user selects the metrics, the staff member is used for processing the configuration of the relationships among the metrics, the dimensions, the filters and the functions in the data, and the server generates a graph database according to the configuration and the data and is used for determining the functions, the metrics, the dimensions and the filters related to the metrics and the dimensions.

Illustratively, when the user-selected metric is a time of use, there are regions, dates, and procedures for dimensions that are related to the time of use according to the relationship of the metric to the dimensions in the graph database. It should be noted that, the embodiment of the present invention does not specifically limit the metrics, the dimensions and the relationships between the metrics and the dimensions, and may be set according to practical situations.

S204: a dimension returned by the server in relation to each metric in the metric information is received and displayed on the graphical user interface.

In this step, the terminal device receives the dimensions related to each metric in the metric information returned by the server and displays the dimensions on the user graphical interface, so that the user can select the required dimensions.

When the user wants to modify the metric selected by the user, the user may click a return button on the user graphical interface of the terminal device, and the terminal device sends a first return instruction to the server. And the server acquires all the metrics from the graph database according to the first return instruction and sends the metrics to the terminal equipment, and then returns to the step S201.

S205: and transmitting dimension information to the server in response to a second selection operation of the user on the graphical user interface.

In this step, after the terminal device displays the dimensions related to each metric in the metric information on the user graphical interface, the user can select a desired dimension. After the user selects, the terminal equipment sends the dimension information to the server. And the server may determine the filter based on the dimension information.

S206: and determining filters associated with all dimensions in the dimension information and filters associated with all metrics in the dimension information according to the dimension information, the metric information and the graph database.

S207: and sending the filter associated with all the dimensions in the dimension information and the filter associated with all the metrics in the metric information to the terminal equipment.

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 the filters associated with all the metrics in the measurement information according to the dimensions in the dimension information, the metrics in the metric information, the relation between the dimensions and the filters in the graph database and the relation between the metrics and the filters, and then sends the determined filters to the terminal device, so that the user can select the filters required by the user on the terminal device.

Illustratively, when the dimension selected by the user is a region, the region can be screened by the existence of a screener related to the region according to the relationship between the dimension and the screener in the graph database. It should be noted that, the embodiment of the present invention does not specifically limit the dimensions, the screeners, and the relationships between the dimensions and the screeners, and may be set according to actual situations.

S208: and receiving and displaying the filter which is returned by the server and is associated with all the dimensions in the dimension information and the filter which is associated with all the metrics in the metric information on a graphical user interface.

In this step, after the terminal device receives 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, it displays them on the user graphical interface, so that the user can select the filters required by himself.

When the user wants to modify the dimension selected by the user, the user may click a return button on the user graphical interface 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: and responding to a third selection operation of the user on the graphical user interface, and acquiring filter information.

S210: and sending the filter information to a server.

In the above steps, after the terminal device displays the filter associated with all dimensions in the dimension information and the filter associated with all metrics in the metric information on the user graphical interface, the user can select a desired filter. After the user selects, the terminal can acquire the filter information selected by the user, and then the filter information is sent to the server. And the server can generate a visual data chart according to the measurement information, the function information, the dimension information, the filter information and the data in the chart database.

It should be noted that the number of the screeners selected by the user may be one or a plurality of screeners, and the embodiment of the invention does not specifically limit the number of the screeners selected by the user and can be selected according to actual situations.

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

S212: and returning the visual data chart to the terminal equipment.

In the step, after the server receives the filter information sent by the terminal equipment, the server generates a visual data chart by combining the measurement information, the function information, the dimension information and the data in the graph database. The server then transmits the visual 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 capability of automatically generating the visual data chart, and the embodiment of the invention does not specifically limit the method for generating the visual data chart according to the measurement information, the function information, the dimension information, the filter information and the data in the chart database by the server, and can be set according to actual conditions.

S213: a visual data chart returned by the server is received and displayed on a graphical user interface.

In this step, the terminal device receives the visual data chart returned by the server and then displays the visual data chart on the user graphical interface, so that the user can freely view the visual data chart.

When the user wants to modify the filter selected by the user, the user may click a return button on the user graphical interface of the terminal device, and the terminal device sends a third return instruction to the server. The server further returns to step S207 according to the third return instruction.

According to the data visualization processing method provided by the embodiment, the data is configured by the staff, the server generates a graph database according to the configuration, and a user selects the needed measurement and function on the terminal equipment and sends the measurement and function to the server. And the server determines the dimension according to the relation between the measurement and the dimension in the measurement and graph database, sends the dimension to the terminal equipment for display to the user, and the user selects the dimension required by the user and sends the dimension to the server. And the server determines the filter according to the measurement and the dimension and the relation between the measurement and the filter in the graph database and the relation between the dimension and the filter, and then sends the filter to the terminal equipment for display to the user. The user selects the filter needed by the user and sends the filter to the server, and then the server can generate a visual data chart according to the measurement, the function, the dimension and the filter and sends the visual data chart to the terminal equipment for display to the user. Compared with the prior art that a user needs to write codes by using the sql language to preprocess data, in the scheme, the user only needs to select the metrics, the functions, the dimensions and the filters on the user graphical interface, the server can determine the dimensions and the filters related to the metrics and the dimensions selected by the user according to the metrics and the dimensions selected by the user and the graph database obtained in advance, finally, after the metrics information, the functions information, the dimensions information and the filter information are obtained, a visual data chart can be generated and sent to the terminal equipment to be displayed for the user, the difficulty of generating the visual data chart is effectively reduced, and the efficiency of generating the visual data chart is increased.

Fig. 3 is a flow chart of a second embodiment of the data visualization processing method provided by the present invention, as shown in fig. 3, in this embodiment, the step S201 may be implemented by:

s301: in response to a first selection operation by the user on the graphical user interface, the metrics and functions of the first selection are sent to the server.

In the step, after the terminal equipment receives the metrics and the functions, the metrics and the functions are displayed to a user in a user graphical interface, the user can select the needed metrics and functions, and after the user selects one of the metrics and the functions, the terminal equipment sends the selected metrics and the selected functions to the server. The server may then determine metrics from the graph database that are relevant to the selected metrics.

S302: and receiving the metrics and the functions of one selection sent by the terminal equipment, and recording the accumulated selection times.

In this step, after the server receives the metrics and functions sent by the terminal device, the accumulated selection times are recorded for comparison with the preset times. When the accumulated selection times are smaller than the preset times, the user can continue to select the measurement, and when the accumulated selection times are equal to the preset times, the user cannot continue to select the measurement.

S303: based on the one-time selected metrics and the relationship between the metrics and the metrics in the graph database, all the metrics associated with the one-time selected metrics are obtained, and all the metrics associated with the one-time selected metrics are returned to the terminal equipment.

In this step, the relationship between the metrics is stored in the graph database stored in the server, and all the metrics associated with the metrics selected at one time can be obtained according to the relationship between the metrics and the metrics, and then sent to the terminal device to be displayed to the user, so that the user can continue to select the metrics.

S304: all metrics returned by the server associated with the one-time selected metrics are received and displayed on the graphical user interface.

In this step, the terminal device receives all the metrics associated with the metrics selected at one time and then displays them on the user graphical interface, so that the user can continue to select the metrics required by himself.

S305: repeating the steps until the accumulated selection times reach the preset times, acquiring all the metrics sent by the terminal equipment to obtain metric information, and acquiring all the functions sent by the terminal equipment to obtain function information.

In this step, the user may continuously select the metrics, and may not continue to select metrics until the number of times the metrics are selected is equal to the preset number of times, so as to avoid a problem of server operation. The server receives the measurement selected by the user each time and sent by the terminal equipment, so as to obtain measurement information, and the server receives the function selected by the user each time and sent by the terminal equipment, so as to obtain function information.

The preset number of times is set by a worker on the server before the user sends the data to the server, and is used for comparing the number of times with the cumulative selection number of times of the user selection metric. When the accumulated selection times are smaller than the preset times, the user can continue to select the measurement, and when the accumulated selection times are equal to the preset times, the user cannot continue to select the measurement. The embodiment of the invention does not limit the preset times specifically and can be set according to actual conditions.

It should be noted that, when the number of times of the user selecting the metrics does not reach the preset number of times, but the user wants to terminate selecting the metrics and the functions, the user may click a terminate selecting the metrics button on the user graphical interface on the terminal device, and the terminal device sends an instruction of selecting the dimension to the server. The server can determine dimensions associated with each metric in the metric information and send the dimensions to the terminal device based on the metric information and the graph database so that the user can select the dimensions.

It should be noted that, when the user selects the metrics, the functions related to the metrics are simultaneously selected, the terminal device sends the functions to the server, the functions can be simultaneously sent when the metrics are sent to the server, all the functions selected by the user can be sent to the server once when the number of times of selecting the metrics by the user reaches the preset number, and all the functions selected by the user can be sent to the server once when the terminal device sends the instruction of selecting the dimension to the server.

S306: and sending a forbidden selection instruction to the terminal equipment.

In the step, when the accumulated selection times reach the preset times, the server sends a selection prohibition instruction to the terminal equipment, and after the terminal equipment receives the selection prohibition instruction, the user is prohibited from selecting on the user graphical interface so as to avoid misoperation.

According to the data visualization processing method provided by the embodiment, the user selects one measurement and function on the terminal equipment, and the terminal equipment sends the measurement and function to the server. The server determines the measurement related to the measurement selected by the user according to the relation between the measurement and the measurement in the graph database, and then sends the measurement to the terminal equipment for the user to select, and the selection is stopped until the accumulated selection times of the user reach the preset times. Compared with the prior art, the method and the device have the advantages that the measurement can be selected for multiple times, and the generated visual data chart meets the requirements of users.

Fig. 4 is a flow chart of a 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 first embodiment may be implemented by the following steps:

s401: responsive to a second selection operation by the user on the graphical user interface, sending the one-time selected dimension to the server;

In the step, after receiving the dimension, the terminal equipment displays the dimension to the user in the user graphical interface, the user can select the dimension required by the user, and after selecting one dimension, the terminal equipment sends the selected dimension to the server. The server may then determine a dimension from the graph database that has a relationship with the selected dimension.

S402: based on the relation between the dimension and the dimension in the dimension and graph database, acquiring all the dimensions associated with the dimension selected at one time, and returning all the dimensions associated with the dimension selected at one time to the first terminal equipment.

In this step, the relationship between the dimension and the dimension is stored in the graph database stored in the server, and all dimensions associated with the dimension selected at one time can be obtained according to the relationship between the dimension and the dimension, and then sent to the terminal device to be displayed to the user, so that the user can continue to select the dimension.

S403: all dimensions returned by the server associated with the one-time selected dimension are received and displayed on the graphical user interface.

In this step, after receiving all dimensions associated with the dimension selected at one time returned by the server, the terminal device displays the dimensions on the user graphical interface, so that the user can continue to select the required dimension.

S404: repeating the steps until no other dimension is selectable, and acquiring all selected dimensions sent by the terminal equipment to obtain dimension information.

In this step, the user can select the dimension continuously until the dimension cannot be selected continuously without other dimension being selectable. The server receives the dimension selected by the user each time and sent by the terminal equipment, and further dimension information is obtained.

Illustratively, when the dimension selected by the user is a mixing program, according to the relationship between the dimension and the dimension in the graph database, the dimension related to the mixing program includes a drying mode parameter, a rinsing frequency parameter, a temperature parameter and a dehydration rotation speed parameter. 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, and may be set according to the actual situation.

It should be noted that, when the user may also select a dimension, but wants to terminate the selection dimension, the user may click a terminate selection dimension button on a user graphical interface on the terminal device, and the terminal device sends an instruction to select the filter to the server. The server may determine, based on the metric information, the dimension information, and the graph database, the filters associated with all dimensions in the dimension information and the filters associated with all metrics in the metric information and send the filters to the terminal device so that the user may select the filters.

According to the data visualization processing method provided by the embodiment, a dimension is selected on the terminal equipment by a user, and the terminal equipment sends the dimension to the server. The server determines the dimension related to the dimension selected by the user according to the relationship between the dimension and the dimension in the graph database, and then sends the dimension to the terminal equipment for the user to select, and the selection is stopped until no dimension can be selected. Compared with the prior art, the method and the device have the advantages that the dimension can be selected only once, the dimension can be selected for multiple times, and the generated visual data chart meets the requirements of users.

FIG. 5 is a schematic diagram of a first embodiment of a data visualization processing apparatus according to the present invention; as shown in fig. 5, the processing device 50 for visualizing data includes:

an obtaining module 51, configured to obtain metric information and function information selected by a terminal device, where the metric information includes all metrics selected by a user, and the function information includes all functions selected by the user;

a processing module 52, configured to determine, according to the metric information and a map database acquired in advance, a dimension related to each metric in the metric information;

a sending module 53, configured to return the dimension 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, filters associated with all dimensions in the dimension information and filters associated with all metrics in the metric information;

the sending module 53 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 obtaining 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 visual data chart to the terminal device.

Further, the obtaining module 51 is further configured to receive the once-selected metric and function sent by the terminal device.

Further, the processing module 52 is further configured to record the cumulative selection number.

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

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

Further, the sending module 53 is further configured to send a selection prohibition instruction to the terminal device after the accumulated number of selections reaches the preset number.

Further, the obtaining module 51 is further configured to receive the dimension of the primary selection sent by the terminal device.

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

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

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

The processing device for data visualization provided in this embodiment is configured to execute the technical solution of the server in any one of the foregoing method embodiments, and its implementation principle and technical effect are similar. The server can determine the measurement information, the measurement, the dimension and the filter which are related to the measurement information and the dimension information sent by the terminal equipment according to the relation among the measurement, the function, the dimension and the filter in the graph database, and then the measurement information, the dimension and the filter are sent to the terminal equipment for the user to select, so that the difficulty of generating the visual data chart is reduced, and the efficiency of generating the visual data chart is improved.

FIG. 6 is a schematic structural diagram of a second embodiment of a data visualization processing apparatus according to the present invention; as shown in fig. 6, the processing device 60 for visualizing data includes:

a sending module 61, configured to send, in response to a first selection operation by a user on a graphical user interface, metric information and function information to a server, where the metric information includes all metrics selected by the user, and the function information includes all functions selected by the user, and all selectable 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, dimensions returned by the server and 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 a second selection operation of the user 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 graphical user interface, the filter associated with all dimensions in the dimension information and the filter 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 of 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, on the graphical user interface, a visual data chart returned by the server.

Further, the sending module 61 is further configured to send, in response to a first selection operation of the user on the graphical user interface, the metrics and functions selected once to the server;

further, the processing module 62 is further configured to receive and display, on the graphical user interface, all metrics returned by the server that are associated with the one-time selected metric.

Further, the sending module 61 is further configured to send the dimension selected once to the server in response to a second selection operation of 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 dimensions returned by the server that are associated with the one-time selected dimension.

The processing device for data visualization provided in this embodiment is configured to execute the technical scheme of the terminal device in any one of the foregoing method embodiments, and its implementation principle and technical effect are similar, and are not described herein again.

Fig. 7 is a schematic structural diagram of a server according to the present invention. As shown in fig. 7, the server 70 includes:

a processor 71, a memory 72, and a communication interface 73;

the memory 72 is for storing executable instructions of the processor 71;

wherein the processor 71 is configured to execute the solution of the server in any of the method embodiments described above via execution of the executable instructions.

Alternatively, the memory 72 may be separate or integrated with the processor 71.

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

And a bus for connecting the devices.

The implementation principle and technical effects of the technical solution on the server side in the embodiment of any of the foregoing methods are similar, and are not described herein.

Fig. 8 is a schematic structural diagram of a terminal device according to the present invention. As shown in fig. 8, the terminal device 80 includes:

a processor 81, a memory 82, a display 83 and a communication interface 84;

the memory 82 is used for storing executable instructions of the processor;

wherein the processor 81 is configured to execute the technical solution of the terminal device in the processing method for providing data visualization according to any of the foregoing embodiments by executing the executable instructions.

Alternatively, the memory 82 may be separate or integrated with the processor 81.

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

and a bus for connecting the devices.

The terminal device is configured to execute the technical scheme on the terminal device side in any of the foregoing method embodiments, and its implementation principle and technical effects are similar, and are not described herein again.

The embodiment of the invention also provides a readable storage medium, on which a computer program is stored, which when executed by a processor, implements the technical scheme provided by any one of the foregoing embodiments on the server or terminal device side.

The embodiment of the invention also provides a computer program product, which comprises a computer program, wherein the computer program is used for realizing the technical scheme of the server or the terminal equipment side provided by any one of the method embodiments when being executed by a processor.

Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some or all of the technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit of the invention.

Claims

1. A method of processing data visualization, for application to a central server, the method comprising:

and returning the visual data chart to the terminal equipment.

2. The method according to claim 1, wherein the obtaining metric information and function information selected by the terminal device includes:

3. The method according to claim 2, wherein the method further comprises:

4. The method according to claim 1 or 2, wherein the obtaining dimension information selected by the terminal device comprises:

receiving a dimension selected once and sent by the terminal equipment;

5. The method according to claim 1 or 2, wherein before obtaining metrics and dimensions related to each metric in the metric information from the metric information and a pre-obtained graph database, the method further comprises:

6. A method for processing data visualization, applied to a terminal device, the method comprising:

transmitting the filter information to the server;

7. The method of claim 6, wherein the sending metric information and function information to the server in response to a first selection operation by the user on the graphical user interface comprises:

8. The method according to claim 6 or 7, wherein the sending dimension information to the server in response to a second selection operation by a user on the graphical user interface comprises:

9. A processing apparatus for visualizing data, comprising:

10. A processing apparatus for visualizing data, comprising:

11. A server, comprising:

a processor, a memory, a communication interface;

the memory is used for storing executable instructions of the processor;

wherein the processor is configured to perform the processing method of data visualization of any of claims 1 to 5 via execution of the executable instructions.

12. A terminal device, comprising:

a processor, a memory, a display, and a communication interface;

the memory is used for storing executable instructions of the processor;

wherein the processor is configured to perform the processing method of data visualization of any of claims 6 to 8 via execution of the executable instructions.

13. A processing system for data visualization, comprising:

A server, a terminal device;

the server is used for executing the processing method for visualizing the data according to any one of claims 1 to 5;

the terminal device is configured to perform the processing method for data visualization according to any one of claims 6 to 8.

14. A readable storage medium having stored thereon a computer program, wherein the computer program, when executed by a processor, implements the method of processing data visualization according to any of claims 1 to 8.

15. A computer program product comprising a computer program for implementing a processing method for data visualization according to any of claims 1 to 8 when executed by a processor.