CN115544183A

CN115544183A - Data visualization method and device, computer equipment and storage medium

Info

Publication number: CN115544183A
Application number: CN202211497228.7A
Authority: CN
Inventors: 张民遐; 江坚
Original assignee: Shenzhen Gaodeng Computer Technology Co ltd
Current assignee: Shenzhen Gaodeng Computer Technology Co ltd
Priority date: 2022-11-28
Filing date: 2022-11-28
Publication date: 2022-12-30
Anticipated expiration: 2042-11-28
Also published as: CN115544183B

Abstract

The application relates to a data visualization method, a data visualization device, computer equipment and a storage medium. The method comprises the following steps: when a data query request is acquired, determining a data identifier in the data query request; determining a target field table corresponding to the data identifier according to preset configuration information; the target field table comprises an association identifier and attribute information; the attribute information comprises a visualization type and a display format; screening a target data set from the data warehouse according to the association identifier; assembling the target data set according to the visualization type to obtain an initial assembly result, and performing format conversion on the initial assembly result according to a display format to obtain a target assembly result; performing data rendering on the target assembly result to obtain a visual page corresponding to the data identifier; the visualization page includes at least one of a chart and a billboard. The method can improve the flexibility of data visualization.

Description

Data visualization method and device, computer equipment and storage medium

Technical Field

The present application relates to the field of computer technologies, and in particular, to a data visualization method and apparatus, a computer device, and a storage medium.

Background

With the development of computer technology, various business data of an enterprise can be counted and displayed through a visualization tool aiming at a data visualization task in enterprise management. At present, in the process of configuring a visualization task, workers are required to participate deeply in the processes of product, development, test and the like, so that a user can smoothly perform visualization query according to participation results given by the workers.

Therefore, the problem that a user cannot flexibly query the visual interface due to the fact that the configuration threshold of the visualization task is high is solved by the method and the device.

Disclosure of Invention

In view of the foregoing, there is a need to provide a data visualization method, apparatus, computer device and computer readable storage medium capable of improving flexibility of data visualization.

In a first aspect, the present application provides a data visualization method. The method comprises the following steps:

when a data query request is acquired, determining a data identifier in the data query request;

determining a target field table corresponding to the data identifier according to preset configuration information; the target field table comprises an association identifier and attribute information; the attribute information comprises a visualization type and a display format;

screening a target data set from a data warehouse according to the association identifier;

assembling the target data set according to the visualization type to obtain an initial assembly result, and performing format conversion on the initial assembly result according to the display format to obtain a target assembly result;

performing data rendering on the target assembly result to obtain a visual page corresponding to the data identifier; the visualization page includes at least one of a chart and a billboard.

In one embodiment, before the determining the data identifier in the data query request, the method further includes: acquiring a data configuration request, and determining a management type corresponding to the data configuration request; the management type comprises data source management, data set management of the next level of the data source management, chart management of the next level of the data set management, and kanban management of the next level of the chart management; determining a data identifier to be configured according to the management type; responding to the configuration operation aiming at the data identification to be configured, and obtaining a field table corresponding to the data identification to be configured; returning to the process of acquiring the data configuration request, continuing, and taking the management type at the next level of the management type as a new management type until a field table corresponding to the data identifier to be configured when the billboard is managed is obtained; and synthesizing the field table corresponding to each data identifier to be configured to obtain configuration information.

In one embodiment, the data identifier to be configured includes a kanban identifier, a chart identifier at a previous level of the kanban identifier, a data set identifier at a previous level of the chart identifier, and a data source identifier at a previous level of the data set identifier; the obtaining a field table corresponding to the data identifier to be configured in response to the configuration operation for the data identifier to be configured includes: displaying a configuration interface comprising a configuration list; the configuration list comprises at least one of a data source identification list, a data set identification list and a chart identification list; responding to the association operation aiming at the data identification to be configured and the configuration list, and determining the association identification at the upper level of the data identification to be configured; if the association identifier is not the data source identifier in the data source identifier list, taking the association identifier as a new data identifier to be configured, and returning to the process of responding to the association operation on the data identifier to be configured and the configuration list to continue until the association identifier is obtained and is the data source identifier; responding to attribute configuration operation aiming at the data identification to be configured to obtain attribute information corresponding to the data identification to be configured; and synthesizing a plurality of the associated identifications and the attribute information to obtain a field table corresponding to the data identification to be configured.

In one embodiment, the data identification comprises a billboard identification; the association identification comprises a plurality of data source identifications, a plurality of data set identifications and a plurality of chart identifications; the screening of the target data set from the data warehouse according to the association identifier comprises: for each chart identifier in the associated identifiers, determining a current data source identifier and a current data set identifier corresponding to the current chart identifier from the associated identifiers; determining a first field table corresponding to the current data source identifier and a second field table corresponding to the current data set identifier; the first field table includes a connection address; the second field table comprises a query field; querying the data warehouse through the query field to determine a corresponding current location of the current data set identifier in the data warehouse; and extracting the current data set at the current position through the connection address, and integrating the current data set corresponding to each data set identifier to obtain a target data set.

In one embodiment, the attribute information includes a sub-visualization type and a chart position corresponding to each chart identification; before the assembling the target data set according to the visualization type to obtain an initial assembly result, the method further includes: screening a subdata set corresponding to each chart identifier from the target data set; the assembling the target data set according to the visualization type to obtain an initial assembly result, comprising: respectively assembling the sub data sets through the sub visualization type corresponding to each chart identifier to obtain the sub assembly result corresponding to each chart identifier; and respectively associating each sub-assembly result to a diagram position corresponding to the corresponding diagram identifier to obtain an initial assembly result.

In one embodiment, the data identification comprises a chart identification; assembling the target data set according to the visualization type to obtain an initial assembly result, including: determining a visualization template corresponding to the visualization type; the visualization template comprises a grouping type and a configuration index; the configuration index comprises at least a summation, a counting or a minimization; grouping the target data set according to the grouping type to obtain a multi-group data set; according to the configuration indexes, calculating each group of the grouped data sets respectively to obtain respective calculation results corresponding to the grouped data sets; and synthesizing each calculation result and the corresponding grouping type to obtain an initial assembly result corresponding to the data identifier.

In an embodiment, the performing data rendering on the target assembly result to obtain a visualization page corresponding to the data identifier includes: constructing an initial document object model through a front-end tool, and determining a text format corresponding to the target assembly result; determining a target message corresponding to the target assembly result according to the text format, and modifying the document object model through the target message to obtain a target document object model; and rendering the target assembly result through the target document object model to obtain a visual page corresponding to the data identification.

In a second aspect, the application further provides a data visualization device. The device comprises:

the field table determining module is used for determining a data identifier in a data query request when the data query request is acquired; determining a target field table corresponding to the data identifier according to preset configuration information; the target field table comprises an association identifier and attribute information; the attribute information comprises a visualization type and a display format;

the assembly result determining module is used for screening out a target data set from the data warehouse according to the association identifier; assembling the target data set according to the visualization type to obtain an initial assembly result, and performing format conversion on the initial assembly result according to the display format to obtain a target assembly result;

the data rendering module is used for performing data rendering on the target assembly result to obtain a visual page corresponding to the data identifier; the visualization page includes at least one of a chart and a billboard.

In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the following steps when executing the computer program:

In a fourth aspect, the present application further provides a computer-readable storage medium. The computer-readable storage medium has stored thereon a computer program which, when executed by a processor, performs the steps of:

According to the data visualization method, the data visualization device, the computer equipment and the storage medium, the data identification in the data query request is determined, and then the target field table corresponding to the data identification is determined according to the preset configuration information; the target field table comprises an association identifier and attribute information, and the attribute information comprises a visualization type and a display format. When a target data set is screened out from the data warehouse according to the association identification, assembling the target data set according to the visualization type to obtain an initial assembly result, and then performing format conversion on the initial assembly result according to a display format to obtain a target assembly result; therefore, the visual page corresponding to the data identification can be obtained by performing data rendering on the target assembly result. Because the target data sets are directly assembled after being screened out, compared with the traditional process that visual query can be carried out only after the participation results are obtained, different target assembly results can be flexibly obtained according to the associated identification and the attribute information in the target field table after the target field table corresponding to different data identifications is obtained, and therefore the flexibility of querying charts or signboards in visual pages is improved.

Drawings

FIG. 1 is a diagram of an application environment for a data visualization method in one embodiment;

FIG. 2 is a schematic flow chart diagram of a data visualization method in one embodiment;

FIG. 3 is a system architecture diagram of a data visualization system in one embodiment;

FIG. 4 is a timing diagram of querying data in one embodiment;

FIG. 5 is an architecture diagram of the flow of determining configuration information in one embodiment;

FIG. 6 is a block diagram of a data visualization device in one embodiment;

FIG. 7 is a diagram of the internal structure of a computer device in one embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more clearly understood, the present application is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

The data visualization method provided by the embodiment of the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 may communicate with the server 104 via a network. The terminal 102 and the server 104 may both independently execute the data visualization method provided in the embodiment of the present application, and may also cooperatively execute the data visualization method provided in the embodiment of the present application. Taking an example of a method for performing data visualization by cooperation between the terminal 102 and the server 104, the terminal 102 is configured to send an acquired data query request to the server 104. The server 104 is configured to determine a data identifier in the data query request, and determine a target field table corresponding to the data identifier according to preset configuration information; and screening the target data set from the data warehouse according to the associated identification in the target field table. The server 104 assembles the target data set according to the visualization type to obtain an initial assembly result, and performs format conversion on the initial assembly result according to the display format to obtain a target assembly result; and rendering the data of the target assembly result to obtain a visual page corresponding to the data identifier, and displaying the visual page through the terminal 102. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.

In one embodiment, as shown in fig. 2, a data visualization method is provided, which is described by taking the method as an example applied to a computer device, which may be a terminal or a server in fig. 1. The data visualization method comprises the following steps:

step 202, when the data query request is obtained, the data identifier in the data query request is determined.

The data query request can be a request for querying a chart or a billboard, the chart can be a pie chart, a bar chart and the like in the data visualization process, and the billboard can be obtained after the charts are combined and laid out. It is easily understood that when a query is requested to the chart, the data identifier in the data query request is the chart identifier, and when a query is requested to the kanban, the data identifier in the data query request is the kanban identifier.

Specifically, the computer device may be a data visualization system, and fig. 3 is a system architecture diagram of the data visualization system, where the data visualization system includes a display layer, and a page interaction module in the display layer may be an Ajax interaction module. The page interaction module can provide a page interaction interface, when the display layer responds to the request operation of a user, the page interaction module can determine the request type of the request operation, and when the request type is a GET request, the request type is a data query request; when the request type is a POST request, the request is configured for data.

In one embodiment, FIG. 4 is a timing diagram of a query for data. When a user triggers a data query request of a billboard or a chart, a Web server in computer equipment performs system login verification on the user, wherein the data query request at the moment comprises a user name and a data identifier. And after the system passes the login verification, performing authentication service through an authentication center, so that the Web server performs authority verification on the user name. And when the authority passes the verification, the Web server can carry out loading configuration according to the data identification. The loading configuration representation is configured to finish the configuration of the kanban or the chart, that is, the configuration information is configured.

In one embodiment, after each kanban or chart is configured, unique summary processing is performed on the kanban or chart, and then a character string corresponding to the data identifier is generated.

In one embodiment, shown with reference to FIG. 3, a Web server includes a business layer, presentation layer, logging, and rights management in a data visualization system. The log records mainly record the relevant operations of the service layer, so that subsequent security audit is facilitated.

In one embodiment, the computer device may combine the report with the billboard and convert the combined report into a report that can be viewed by subscription, where the data identifier in the data query request is the report identifier.

And 204, determining a target field table corresponding to the data identifier according to preset configuration information.

The target field table comprises an association identifier and attribute information; the attribute information includes a visualization type and a display format. After the target field table representation configures the chart or kanban corresponding to the data identifier, a data table in which all associated information of the chart or kanban is recorded is obtained, such as creation time, title, latest modifier, and the like.

Specifically, the computer device may obtain preset configuration information from the database, where the preset configuration information includes a plurality of field tables, and each field table includes a data identifier to be configured. The computer equipment searches the data identifier to be configured which is the same as the data identifier from the plurality of data identifiers to be configured, and takes the field table where the data identifier to be configured is located as a target field table corresponding to the data identifier.

In one embodiment, when the data configuration request is acquired, the data identifier to be configured in the data query request is determined, and the configuration information corresponding to the data identifier to be configured is obtained in response to the configuration operation of the user for the data identifier to be configured.

And step 206, screening the target data set from the data warehouse according to the association identifier.

When the data identifier is a chart identifier, the corresponding association identifier comprises a data set identifier at the upper level of the chart identifier and a data source identifier at the upper level of the data set identifier; when the data identifier is a kanban identifier, the corresponding association identifier includes a chart identifier at a previous level of the kanban identifier, a data set identifier at a previous level of the chart identifier, and a data source identifier at a previous level of the data set identifier. The data source identification representation of the upper level of the data set identification needs to configure the data set identification on the basis of configuring the data source identification; similarly, the data set identifier representation of the upper level of the chart identifier needs a process of configuring the chart identifier on the basis of configuring the data set identifier.

The data source corresponding to the data set identifier is mainly expressed in the forms of a data service host, a service port, an account number, a secret key and the like; the data set corresponding to the data set identification comprises a virtual table or an entity table, and the data set identification can be obtained by executing SQL query from a data source, wherein the virtual table is a table virtualized when SQL queries are carried out on data, no actually corresponding table exists in the data source, and the entity table has an actually corresponding table in the data source.

Specifically, referring to fig. 3, the data visualization system further includes a data store and a data warehouse, the data store including a cache and a data layer. The data sources in the data warehouse at least comprise MySQL, impala, hadoop and clickhouse; the cache may be a redis cache; the data layer is a data query agent. When the data identifier is a chart identifier, the data layer determines a first field table corresponding to the data source identifier in the association identifier and a second field table corresponding to the data set identifier in the association identifier. The first field table is a field table obtained after the data source corresponding to the data source identifier is configured in advance, and the second field table is a field table obtained after the data set corresponding to the data set identifier is configured in advance. And the data layer screens out a target data set corresponding to the chart identification from the data warehouse according to the first field table and the second field table.

It is easy to understand that since the kanban is obtained by combining a plurality of charts, when the data identifier is a kanban identifier, the corresponding association identifier includes a plurality of chart identifiers, and for each chart identifier in the association identifier, a sub data set corresponding to each chart identifier can be screened from the data warehouse, and a target data set corresponding to the kanban identifier can be obtained by integrating a plurality of sub data sets.

In an embodiment, referring to fig. 4, a Web server in a computer device queries whether a target data set corresponding to a data identifier exists in a cache through a character string corresponding to the data identifier, and if so, directly extracts the target data set in the cache; and if not, screening the target data set from the data warehouse through the data layer. And the target data set exists in the cache to characterize that the graph or the billboard corresponding to the data identification is inquired.

And 208, assembling the target data set according to the visualization type to obtain an initial assembly result, and performing format conversion on the initial assembly result according to the display format to obtain a target assembly result.

The visualization type can be a pie chart type or a two-dimensional histogram type corresponding to the chart, and the like, and the bulletin board can be a type for performing different layouts on a plurality of charts corresponding to the bulletin board; display format the list data in the representation chart is displayed as integers, decimal numbers or in a format with special characters. Wherein the attribute information further comprises dimension information.

Specifically, referring to fig. 4, when the data layer screens out a target data set corresponding to the graph identifier from the data warehouse, the target data set is sent to the cache, so that the Web server filters the target data set according to the dimension information, and obtains the filtered target data set. For example, if the dimension information is two-dimensional, only two-dimensional data in the target data set is retained. And the Web server in the computer equipment performs data assembly on the filtered target data set according to the visualization type, namely, determines the header data and the list data in the target data set to obtain an initial assembly result. And the Web server performs data format conversion on the initial assembly result according to the display format so as to obtain a target assembly result.

In an embodiment, the data query request may further include a query condition, and before the target data set is assembled according to the visualization type and the initial assembly result is obtained, the Web server may further perform conditional screening on the target data set through the query condition to obtain the screened target data set. The query condition is, for example, a specified time or the like. Therefore, information which is more concerned by the user can be acquired.

And step 210, performing data rendering on the target assembly result to obtain a visual page corresponding to the data identifier.

Wherein the visualization page includes at least one of a chart and a kanban.

In one embodiment, the data rendering is performed on the target assembly result to obtain a visualization page corresponding to the data identifier, and the method includes: constructing an initial document object model through a front-end tool, and determining a text format corresponding to a target assembly result; determining a target message corresponding to the target assembly result according to the text format, and modifying the document object model through the target message to obtain a target document object model; and rendering the target assembly result through the target document object model to obtain a visual page corresponding to the data identification.

The front-end tool is a front-end UI, and human-computer interaction and operation logic can be designed. The document object model can be a DOM, the document type DOM is mainly used for operating the contents of HTML documents and XML documents, the DOM depicts a hierarchical node tree, and the document contents are subjected to increasing, deleting, modifying and checking through the operation of the nodes. The text format includes plain text and rich text.

Specifically, referring to fig. 3, the presentation layer further includes a template engine rendering module, and the presentation layer responds to the front-end UI messages in two formats in different scenes. And when the text format corresponding to the target assembly result is a plain text, determining that the corresponding target message is an AJAX JSON format message. And when the front-end UI obtains a target assembly result corresponding to the AJAX JSON format message, binding the target assembly result to the document object model to obtain the bound target document object model. And when the text format corresponding to the target assembly result is rich text, the target message can be obtained as an HTML DOM format message through the template engine rendering module. When the front-end UI acquires a target assembly result corresponding to the HTML DOM format message, the target assembly result is directly inserted into the document object model, and the target document object model is obtained. Aiming at messages with different formats, the target assembly result can be rendered through the target document object model, and the visual page corresponding to the data identification is obtained.

In one embodiment, a reach development framework, a CSS development framework, a Html development framework, and the like may be included in the front-end UI. Referring to fig. 3, the data visualization system may be deployed in operating environments such as cloud hosts, local and third-party virtual hosts, and the like.

In the data visualization method, the target field table corresponding to the data identification is determined according to preset configuration information by determining the data identification in the data query request; the target field table comprises an association identifier and attribute information, and the attribute information comprises a visualization type and a display format. When a target data set is screened out from the data warehouse according to the association identification, the target data set can be assembled according to the visualization type to obtain an initial assembly result, and then format conversion is carried out on the initial assembly result according to the display format to obtain a target assembly result; therefore, the visual page corresponding to the data identification can be obtained by performing data rendering on the target assembly result. Because the target data set is directly assembled after being screened out, compared with the traditional process that the visual query can be carried out only after the participation result is obtained, different target assembly results can be flexibly obtained according to the associated identification and the attribute information in the target field table after the target field table corresponding to different data identifications is obtained, and therefore the flexibility of displaying the chart or the signboard in the visual page is improved.

In one embodiment, as shown in fig. 5, before determining the data identifier in the data query request, a process of determining configuration information is further included, which includes the following steps:

step 502, a data configuration request is obtained, and a management type corresponding to the data configuration request is determined.

The management types comprise data source management, data set management of the next level of data source management, chart management of the next level of data set management and billboard management of the next level of chart management. The data source management representation of the next level of data source management needs to complete the configuration of the data source identification to be configured through the data source management, and then the configuration process of the data set identification to be configured is completed through the data set management on the basis; similarly, the chart management representation of the next stage of data set management needs to complete the configuration process of the chart identifier to be configured through the chart management on the basis of completing the configuration of the data set identifier to be configured through the data set management.

Specifically, referring to fig. 3, the data visualization system further includes a business layer, and the management types in the business layer include data source management, data set management, chart management, kanban management, subscription report, and authority management. When the display layer responds to the request operation of the user, the page interaction interface in the display layer can determine the request type of the request operation, and when the request type is a POST request, the request is a data configuration request.

Step 504, determining the data identifier to be configured according to the management type.

The data identifier to be configured may be an ID corresponding to a management type, and when the management type is data source management, the corresponding data identifier to be configured is a data source identifier; when the management type is data set management, the corresponding data identifier to be configured is a data set identifier; when the management type is chart management, the corresponding data identifier to be configured is a chart identifier; and when the management type is billboard management, the corresponding data identifier to be configured is a billboard identifier.

Step 506, in response to the configuration operation for the data identifier to be configured, a field table corresponding to the data identifier to be configured is obtained.

The data identification to be configured comprises a billboard identification, a chart identification at the upper level of the billboard identification, a data set identification at the upper level of the chart identification and a data source identification at the upper level of the data set identification.

In one embodiment, in response to a configuration operation for a data identifier to be configured, obtaining a field table corresponding to the data identifier to be configured includes: displaying a configuration interface comprising a configuration list; determining a higher-level associated identifier of the data identifier to be configured in response to the associated operation aiming at the data identifier to be configured and the configuration list; if the associated identifier is not the data source identifier in the data source identifier list, taking the associated identifier as a new data identifier to be configured, and returning to the process of responding to the associated operation of the data identifier to be configured and the configuration list to continue to be carried out until the associated identifier is obtained as the data source identifier; responding to attribute configuration operation aiming at the data identification to be configured to obtain attribute information corresponding to the data identification to be configured; and integrating the plurality of associated identifications and the attribute information to obtain a field table corresponding to the data identification to be configured.

Specifically, a configuration interface including a configuration list is displayed in the display layer, and when the data identifier to be configured is a data set identifier, the configuration list includes a data source identifier list. The configuration list comprises at least one of a data source identification list, a data set identification list and a chart identification list. In response to a user's selection operation for the data source identifier in the data source identifier list, the computer device takes the selected data source identifier as an association identifier associated with the data identifier to be configured. Since the association identifier at this time is the data source identifier in the data source identifier list, it can be regarded as that the configuration operation of the association identifier corresponding to the data set identifier has been completed, that is, the configuration between the data set identifier and the data source identifier of the previous stage has been completed. For example, the association of data set 1 is identified as data source a.

When the data identifier to be configured is a chart identifier, the configuration list comprises a data source identifier list and a data set identifier list. In response to a selection operation of the user for a data set identification in the data set identification list, the computer device takes the selected data set identification as an association identification associated with the data identification to be configured. Since the association identifier at this time is not the data source identifier in the data source identifier list, the configuration operation of the association identifier corresponding to the data set identifier needs to be continuously performed. Therefore, the configuration between the chart identifier and the data set identifier of the upper level and the data source identifier of the upper level is finally obtained. For example, the association identifier corresponding to the chart identifier a is identified as data set 1, and the association identifier of data set 1 is identified as data source a, so that the association identifier corresponding to the chart identifier a is determined as data set 1 and data source a.

Similarly, when the data identifier to be configured is a signboard identifier, the configuration list includes a data source identifier list, a data set identifier list, and a chart identifier list, and a process of configuring the signboard identifier is substantially the same as a process of configuring the chart identifier, which is not described herein again.

Further, the computer device responds to the attribute configuration operation aiming at the data identification to be configured, obtains attribute information corresponding to the data identification to be configured, and synthesizes the plurality of associated identifications and the attribute information to obtain a field table corresponding to the data identification to be configured. The field table obtained by data source management is shown in table 1, the field table obtained by data set management is shown in table 2, the field table obtained by chart management is shown in table 3, and the field table obtained by kanban management is shown in table 4.

Table 1:

table 2:

table 3:

table 4:

and step 508, returning to the process of acquiring the data configuration request, continuing, and taking the management type at the next level of the management type as a new management type until a field table corresponding to the data identifier to be configured during kanban management is obtained.

In one embodiment, when the data identifier to be configured is a plurality of data source identifiers, that is, when the data source identifiers are managed, the computer device obtains a configured data source identifier list in response to creation and configuration operations of a user for each data source identifier, and displays the configured data source identifier list in the configuration interface.

In one embodiment, when the data identifier to be configured is a plurality of data set identifiers, that is, when the data set is managed, the computer device obtains a configured data set identifier list in response to a creation and configuration operation of a user for each data set identifier, and displays the data set identifier list in the configuration interface.

In one embodiment, when the data identifier to be configured is a plurality of chart identifiers, that is, when the data identifier is managed by a chart, the computer device obtains a chart identifier list with completed configuration in response to creation and configuration operations of a user for each chart identifier. And displaying the chart identification list in a configuration interface. When the chart is managed, the computer equipment responds to the selection operation of the user on the chart identification list, and can construct various boards.

In one embodiment, after the configuration of the signboard identifier to be configured is completed through the signboard management, the configuration of the report can be completed through subscribing the report, so that the computer device can periodically send the configured report to the corresponding user through mails and the like. The field table obtained by subscribing to the report is shown in table 5.

Table 5:

in one embodiment, after the configuration of the signboard identification to be configured is completed through the signboard management, the configuration of the authority user can be completed through the authority management, and the field table corresponding to the authority user is obtained. The field table corresponding to the authority user includes a user table, a role table and a user role association table, for example, the user table corresponds to users such as employee a or employee B, and for example, the role table corresponds to roles such as financial staff or developers. The user table is shown in table 6, the character table is shown in table 7, and the user role association table is shown in table 8.

Table 6:

table 7:

table 8:

step 510, synthesizing the field table corresponding to each data identifier to be configured to obtain configuration information.

In the embodiment, the data identifier to be configured corresponding to the management type is determined, and then the configuration operation of the data identifier to be configured is completed, so that the field table corresponding to the data identifier to be configured is obtained, and therefore, the configured field table can be accurately obtained when visual query is subsequently performed on the billboard or the chart, and the efficiency of visual query of data is improved. Meanwhile, the user can flexibly configure the corresponding management type, so that the development cost and the configuration threshold are reduced, and the flexibility of data visualization query is improved.

In one embodiment, the screening out the target data set from the data warehouse according to the association identifier comprises: for each chart identifier in the associated identifiers, determining a current data source identifier and a current data set identifier corresponding to the current chart identifier from the associated identifiers; determining a first field table corresponding to the current data source identification and a second field table corresponding to the current data set identification; inquiring the data warehouse through the inquiry field, and determining the corresponding current position of the current data set identifier in the data warehouse; and extracting the current data set at the current position through the connection address, and synthesizing the current data sets corresponding to the data set identifications to obtain a target data set.

When the data identification is the signboard identification, the association identification comprises a plurality of data source identifications, a plurality of data set identifications and a plurality of chart identifications. The first field table includes a connection address; the second field table includes a query field.

Specifically, since the kanban is obtained by combining a plurality of charts, for each chart identifier in the association identifier, the computer device may determine a current data source identifier and a current data set identifier corresponding to the current chart identifier, and determine a first field table corresponding to the current data source identifier and a second field table corresponding to the current data set identifier. Step 206 may be referred to in the process of screening out the target data set corresponding to the chart identifier from the data warehouse according to the first field table and the second field table, which is not described herein again in this embodiment.

Further, since the data warehouse includes a plurality of data sources, and the data sources include a plurality of data sets, the computer device needs to query the data warehouse through the query field to determine the current location of the current data set identifier in the data warehouse. When the current position identified by the current data set is determined, the current data set at the current position can be extracted through the connection address of the data source. Therefore, the computer device synthesizes the current data set corresponding to each data set identification, and the target data set corresponding to the billboard identification can be obtained.

In this embodiment, for each level of management type, the management type of the previous level needs to be associated to obtain the multi-level associated identifier corresponding to the data identifier to be configured, so that when the target data set is queried, the position of the target data set in the data warehouse can be quickly located.

In one embodiment, before assembling the target data set according to the visualization type and obtaining the initial assembly result, the method further includes: and screening the subdata sets corresponding to the chart identifications from the target data set.

In one embodiment, assembling the target data set according to the visualization type to obtain an initial assembly result, includes: respectively assembling the sub-data sets through the sub-visualization type corresponding to each chart identifier to obtain a sub-assembly result corresponding to each chart identifier; and respectively associating each sub-assembly result to a diagram position corresponding to the corresponding diagram identifier to obtain an initial assembly result.

The attribute information comprises a sub-visualization type and a chart position which are respectively corresponding to each chart identifier; the sub-data sets are assembled respectively through the sub-visualization type corresponding to each chart identifier, so as to obtain a specific implementation process of the sub-assembly result corresponding to each chart identifier, which may refer to the specific implementation process of step 208, and this embodiment is not described herein again.

Specifically, the chart combinations in different kanban are not the same, that is, the positions of the charts placed in the kanban in each chart are not the same. When the computer equipment obtains the sub-assembly result corresponding to each chart identifier, each sub-assembly result can be associated to a corresponding chart position respectively, and the initial assembly result corresponding to the signboard identifier is obtained.

In this embodiment, a plurality of chart identifiers corresponding to the signboard identifiers are determined through signboard management, so that a sub-visualization type corresponding to each chart identifier is obtained, and when a chart of the sub-visualization type is flexibly laid out through the chart position in the attribute information, the flexibility of signboard visualization can be improved.

In one embodiment, assembling the target data set according to the visualization type to obtain an initial assembly result, includes: determining a visualization template corresponding to the visualization type; grouping the target data set according to the grouping type to obtain a multi-group data set; according to the configuration indexes, calculating each group of packet data sets respectively to obtain respective corresponding calculation results of the packet data sets; and synthesizing each calculation result and the corresponding grouping type to obtain an initial assembly result corresponding to the data identification.

The visualization template comprises a grouping type and a configuration index; the configuration index includes at least a summation, a counting, or a minimization.

Specifically, when the data identifier is a chart identifier, the computer device may obtain a visualization template corresponding to the visualization type from a corresponding database, for example, a two-dimensional histogram template. The computer device groups the target data set by the grouping type, for example, when the grouping type is a user ID, the computer device may divide the data corresponding to different user IDs into multiple groups to obtain a multiple-group data set. And the computer equipment respectively calculates each group of grouped data sets according to the configuration indexes, for example, when the configuration indexes are summation, the computer equipment can carry out summation calculation on the grouped data sets corresponding to the user 1 to obtain the calculation results corresponding to the grouped data sets respectively. And assembling each calculation result and the corresponding grouping type by the computer equipment according to the visual template to obtain an initial assembly result corresponding to the data identifier.

In the embodiment, the initial assembly result corresponding to the data identifier can be quickly obtained by obtaining the visual template corresponding to the visual type, so that the operation flow of data assembly is simplified, and the subsequent visual display of the chart or the billboard can be efficiently performed.

It should be understood that, although the steps in the flowcharts related to the above embodiments are shown in sequence as indicated by the arrows, the steps are not necessarily performed in sequence as indicated by the arrows. The steps are not limited to being performed in the exact order illustrated and, unless explicitly stated herein, may be performed in other orders. Moreover, at least a part of the steps in the flowcharts related to the above embodiments may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least a part of the steps or stages in other steps.

Based on the same inventive concept, the embodiment of the present application further provides a data visualization apparatus for implementing the above-mentioned data visualization method. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme described in the method, so specific limitations in one or more embodiments of the data visualization device provided below can refer to the limitations on the data visualization method in the foregoing, and details are not described here.

In one embodiment, as shown in fig. 6, there is provided a data visualization apparatus 600 comprising: a field table determination module 602, an assembly result determination module 604, and a data rendering module 606, wherein:

a field table determining module 602, configured to determine a data identifier in a data query request when the data query request is obtained; determining a target field table corresponding to the data identifier according to preset configuration information; the target field table comprises an association identifier and attribute information; the attribute information comprises a visualization type and a display format;

an assembly result determining module 604, configured to screen out a target data set from the data warehouse according to the association identifier; assembling the target data set according to the visualization type to obtain an initial assembly result, and performing format conversion on the initial assembly result according to a display format to obtain a target assembly result;

the data rendering module 606 is configured to perform data rendering on the target assembly result to obtain a visualization page corresponding to the data identifier; the visualization page includes at least one of a chart and a billboard.

In one embodiment, the data visualization apparatus 600 further includes a data configuration module 608, configured to obtain a data configuration request and determine a management type corresponding to the data configuration request; the management types comprise data source management, data set management of the next level of data source management, chart management of the next level of data set management and billboard management of the next level of chart management; determining a data identifier to be configured according to the management type; responding to the configuration operation aiming at the data identification to be configured, and obtaining a field table corresponding to the data identification to be configured; returning to the process of acquiring the data configuration request, continuing, and taking the management type at the next level of the management type as a new management type until a field table corresponding to the data identifier to be configured when the billboard is managed is obtained; and synthesizing the field table corresponding to each data identifier to be configured to obtain configuration information.

In one embodiment, the data configuration module 608 is further configured to present a configuration interface including a configuration list; the configuration list comprises at least one of a data source identification list, a data set identification list and a chart identification list; responding to the association operation aiming at the data identification to be configured and the configuration list, and determining the association identification at the upper level of the data identification to be configured; if the associated identifier is not the data source identifier in the data source identifier list, taking the associated identifier as a new data identifier to be configured, and returning to the process of responding to the associated operation on the data identifier to be configured and the configuration list to continue until the associated identifier is obtained as the data source identifier; responding to attribute configuration operation aiming at the data identification to be configured, and obtaining attribute information corresponding to the data identification to be configured; and integrating the plurality of associated identifications and the attribute information to obtain a field table corresponding to the data identification to be configured.

In one embodiment, the assembly result determining module 604 further includes a data set filtering module 6041, configured to determine, for each graph identifier in the association identifiers, a current data source identifier and a current data set identifier corresponding to the current graph identifier from the association identifiers; determining a first field table corresponding to the current data source identification and a second field table corresponding to the current data set identification; the first field table includes a connection address; the second field table includes a query field; inquiring the data warehouse through the inquiry field, and determining the corresponding current position of the current data set identifier in the data warehouse; and extracting the current data set at the current position through the connection address, and synthesizing the current data set corresponding to each data set identifier to obtain a target data set.

In one embodiment, the assembly result determining module 604 further includes a dataset assembling module 6042 configured to filter out a subset of data sets corresponding to each graph identifier from the target dataset; respectively assembling the sub-data sets through the sub-visualization type corresponding to each chart identifier to obtain a sub-assembly result corresponding to each chart identifier; and respectively associating each sub-assembly result to a diagram position corresponding to the corresponding diagram identifier to obtain an initial assembly result.

In one embodiment, the data set assembling module 6042 is further configured to determine a visualization template corresponding to the visualization type; the visualization template comprises a grouping type and a configuration index; grouping the target data set according to the grouping type to obtain a multi-group data set; according to the configuration indexes, calculating each group of packet data sets respectively to obtain respective corresponding calculation results of the packet data sets; and synthesizing each calculation result and the corresponding grouping type to obtain an initial assembly result corresponding to the data identification.

In one embodiment, the data rendering module 606 is further configured to construct an initial document object model by using a front-end tool, and determine a text format corresponding to the target assembly result; determining a target message corresponding to the target assembly result according to the text format, and modifying the document object model through the target message to obtain a target document object model; and rendering the target assembly result through the target document object model to obtain a visual page corresponding to the data identification.

The respective modules in the data visualization device may be wholly or partially implemented by software, hardware, and a combination thereof. The modules can be embedded in a hardware form or independent of a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 7. The computer device includes a processor, a memory, an Input/Output (I/O) interface, a communication interface, a display unit, and an Input apparatus. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The input/output interface of the computer device is used for exchanging information between the processor and an external device. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless communication can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a method of data visualization. The display unit of the computer equipment is used for forming a visual and visible picture and can be a display screen, a projection device or a virtual reality imaging device, the display screen can be a liquid crystal display screen or an electronic ink display screen, the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on a shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.

Those skilled in the art will appreciate that the configuration shown in fig. 7 is a block diagram of only a portion of the configuration associated with the present application and does not constitute a limitation on the computing device to which the present application may be applied, and that a particular computing device may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In an embodiment, a computer device is further provided, which includes a memory and a processor, the memory stores a computer program, and the processor implements the steps of the above method embodiments when executing the computer program.

In an embodiment, a computer-readable storage medium is provided, in which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.

In one embodiment, a computer program product or computer program is provided that includes computer instructions stored in a computer-readable storage medium. The computer instructions are read by a processor of a computer device from a computer-readable storage medium, and the computer instructions are executed by the processor to cause the computer device to perform the steps in the above-mentioned method embodiments.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware related to instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include a Read-Only Memory (ROM), a magnetic tape, a floppy disk, a flash Memory, an optical Memory, a high-density embedded nonvolatile Memory, a resistive Random Access Memory (ReRAM), a Magnetic Random Access Memory (MRAM), a Ferroelectric Random Access Memory (FRAM), a Phase Change Memory (PCM), a graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others. The databases referred to in various embodiments provided herein may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic devices, quantum computing based data processing logic devices, etc., without limitation.

All possible combinations of the technical features in the above embodiments may not be described for the sake of brevity, but should be considered as being within the scope of the present disclosure as long as there is no contradiction between the combinations of the technical features.

The above examples only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, and these are all within the scope of protection of the present application. Therefore, the protection scope of the present application shall be subject to the appended claims.

Claims

1. A method of data visualization, the method comprising:

2. The method of claim 1, wherein prior to said determining the data identity in the data query request, the method further comprises:

acquiring a data configuration request, and determining a management type corresponding to the data configuration request; the management type comprises data source management, data set management of the next level of the data source management, chart management of the next level of the data set management, and kanban management of the next level of the chart management;

determining a data identifier to be configured according to the management type;

responding to the configuration operation aiming at the data identification to be configured, and obtaining a field table corresponding to the data identification to be configured;

returning to the process of acquiring the data configuration request, continuing, and taking the management type at the next level of the management type as a new management type until a field table corresponding to the data identifier to be configured when the billboard is managed is obtained;

and synthesizing the field table corresponding to each data identifier to be configured to obtain configuration information.

3. The method according to claim 2, wherein the data identifier to be configured comprises a kanban identifier, a chart identifier at a higher level than the kanban identifier, a data set identifier at a higher level than the chart identifier, and a data source identifier at a higher level than the data set identifier;

the obtaining of the field table corresponding to the to-be-configured data identifier in response to the configuration operation for the to-be-configured data identifier includes:

displaying a configuration interface comprising a configuration list; the configuration list comprises at least one of a data source identification list, a data set identification list and a chart identification list;

responding to the association operation aiming at the data identification to be configured and the configuration list, and determining the association identification at the upper level of the data identification to be configured;

if the association identifier is not the data source identifier in the data source identifier list, taking the association identifier as a new data identifier to be configured, and returning to the process of responding to the association operation on the data identifier to be configured and the configuration list to continue until the association identifier is obtained and is the data source identifier;

responding to attribute configuration operation aiming at the data identification to be configured to obtain attribute information corresponding to the data identification to be configured;

and synthesizing a plurality of the associated identifications and the attribute information to obtain a field table corresponding to the data identification to be configured.

4. The method of claim 1, wherein the data identification comprises a billboard identification; the association identification comprises a plurality of data source identifications, a plurality of data set identifications and a plurality of chart identifications; the screening of the target data set from the data warehouse according to the association identifier comprises:

for each chart identifier in the associated identifiers, determining a current data source identifier and a current data set identifier corresponding to the current chart identifier from the associated identifiers;

determining a first field table corresponding to the current data source identifier and a second field table corresponding to the current data set identifier; the first field table includes a connection address; the second field table comprises a query field;

querying the data warehouse through the query field, and determining a corresponding current position of the current data set identifier in the data warehouse;

and extracting the current data set at the current position through the connection address, and synthesizing the current data set corresponding to each data set identifier to obtain a target data set.

5. The method of claim 4, wherein the attribute information comprises a sub-visualization type and a chart position corresponding to each chart identifier; before the assembling the target data set according to the visualization type to obtain an initial assembly result, the method further includes:

screening out a subdata set corresponding to each chart identification from the target data set;

assembling the target data set according to the visualization type to obtain an initial assembly result, including:

respectively assembling the sub data sets through the sub visualization type corresponding to each chart identifier to obtain the sub assembly result corresponding to each chart identifier;

and respectively associating each sub-assembly result to a diagram position corresponding to the corresponding diagram identifier to obtain an initial assembly result.

6. The method of claim 1, wherein the data identification comprises a chart identification; assembling the target data set according to the visualization type to obtain an initial assembly result, including:

determining a visualization template corresponding to the visualization type; the visualization template comprises a grouping type and a configuration index; the configuration index comprises at least a summation, a counting or a minimization;

grouping the target data set according to the grouping type to obtain a multi-group data set;

according to the configuration indexes, calculating each group of the grouped data sets respectively to obtain respective calculation results of the grouped data sets;

and synthesizing each calculation result and the corresponding grouping type to obtain an initial assembly result corresponding to the data identifier.

7. The method according to claim 1, wherein the data rendering the target assembly result to obtain a visualization page corresponding to the data identifier comprises:

constructing an initial document object model through a front-end tool, and determining a text format corresponding to the target assembly result;

determining a target message corresponding to the target assembly result according to the text format, and modifying the document object model through the target message to obtain a target document object model;

and rendering the target assembly result through the target document object model to obtain a visual page corresponding to the data identifier.

8. A data visualization device, the device comprising:

the assembly result determining module is used for screening a target data set from the data warehouse according to the association identifier; assembling the target data set according to the visualization type to obtain an initial assembly result, and performing format conversion on the initial assembly result according to the display format to obtain a target assembly result;

9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 7.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.