CN115544183B - Data visualization method, device, computer equipment and storage medium - Google Patents
Data visualization method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN115544183B CN115544183B CN202211497228.7A CN202211497228A CN115544183B CN 115544183 B CN115544183 B CN 115544183B CN 202211497228 A CN202211497228 A CN 202211497228A CN 115544183 B CN115544183 B CN 115544183B
- Authority
- CN
- China
- Prior art keywords
- data
- identifier
- target
- chart
- data set
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
- G06F16/287—Visualization; Browsing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
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 includes 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 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 diagrammed sheet and a billboard. By adopting the method, the flexibility of data visualization can be improved.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a data visualization method, apparatus, computer device, and storage medium.
Background
With the development of computer technology, various business data of enterprises can be counted and displayed through visualization tools aiming at data visualization tasks in enterprise management. At present, in the process of configuring a visual task, workers are required to participate deeply in the processes of production, development, testing and the like, so that the users can smoothly perform visual query according to participation results given by the workers.
Therefore, aiming at the problem that the user cannot flexibly inquire the visual interface due to the higher configuration threshold of the visual task, how to improve the flexibility of data visualization is the problem to be solved by the application.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a data visualization method, apparatus, computer device, and computer-readable storage medium that can improve the 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 associated 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 said determining the data identifier 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 stage of the data source management, chart management of the next stage of the data set management and signboard management of the next stage 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 identifier to be configured, and obtaining a field table corresponding to the data identifier to be configured; returning to the process of obtaining the data configuration request, continuing to take the management type of the next stage of the management type as a new management type until a field table corresponding to the data identifier to be configured in the process of managing the signboard is obtained; and integrating the field tables corresponding to the data identifiers to be configured to obtain configuration information.
In one embodiment, the data identifier to be configured includes a signboard identifier, a chart identifier of a higher level of the signboard identifier, a data set identifier of a higher level of the chart identifier, and a data source identifier of a higher level of the data set identifier; the responding to the configuration operation for the data identifier to be configured obtains a field table corresponding to the data identifier to be configured, which comprises the following steps: 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; determining an association identifier of a higher level of the data identifier to be configured in response to the association operation aiming at the data identifier to be configured and the configuration list; if the association identifier is not the data source identifier in the data source identifier list, the association identifier is used as a new data identifier to be configured, and the process of responding to the association operation for the data identifier to be configured and the configuration list is returned to continue until the association identifier is obtained as the data source identifier; responding to attribute configuration operation aiming at the data identifier to be configured to obtain attribute information corresponding to the data identifier to be configured; and integrating a plurality of the association identifications and the attribute information to obtain a field table corresponding to the data identification to be configured.
In one embodiment, the data identification includes a billboard identification; the association identifier comprises a plurality of data source identifiers, a plurality of data set identifiers and a plurality of chart identifiers; the screening the target data set from the data warehouse according to the association identifier comprises the following steps: determining a current data source identifier and a current data set identifier corresponding to the current chart identifier from the associated identifiers aiming at each chart identifier in 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 includes a query field; querying the data warehouse through the query 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 attribute information includes a child visualization type and a chart position corresponding to each chart identifier; before the target data set is assembled according to the visualization type to obtain an initial assembly result, the method further comprises the following steps: screening sub-data sets corresponding to each chart identifier from the target data set; the step of assembling the target data set according to the visualization type to obtain an initial assembly result, which comprises the following steps: assembling the sub-data sets through the sub-visualization types corresponding to the chart identifications respectively to obtain sub-assembly results corresponding to the chart identifications respectively; and respectively associating each sub-assembly result to a chart position corresponding to the corresponding chart identifier to obtain an initial assembly result.
In one embodiment, the data identification includes a chart identification; the step of assembling the target data set according to the visualization type to obtain an initial assembly result, which comprises the following steps: determining a visualization template corresponding to the visualization type; the visual template comprises grouping types and configuration indexes; the configuration index at least comprises summation, counting or calculating the maximum value; grouping the target data sets through the grouping type to obtain a plurality of groups of grouping data sets; according to the configuration index, each group of grouping data sets is calculated to obtain calculation results corresponding to the grouping data sets; and integrating each calculation result and the corresponding grouping type to obtain an initial assembly result corresponding to the data identifier.
In one embodiment, the performing data rendering on the target assembly result to obtain a visual 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 identifier.
In a second aspect, the present application also provides a data visualization apparatus. The device comprises:
the device comprises a field table determining module, a field searching module and a field searching module, wherein the field table determining module is used for determining a data identifier in a data searching request when the data searching request is acquired; determining a target field table corresponding to the data identifier according to preset configuration information; the target field table comprises an associated 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 which when executing the computer program performs the steps of:
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 associated 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 a fourth aspect, the present application also 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:
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 associated 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.
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 associated identifier and attribute information, wherein the attribute information comprises a visualization type and a display format. When a target data set is screened out from a data warehouse according to the association identifier, the target data set can be assembled according to the visualization type to obtain an initial assembly result, and then the initial assembly result is subjected to format conversion according to the display format to obtain a target assembly result; therefore, the visual page corresponding to the data identifier can be obtained by carrying out 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 performed only after participation results are obtained, the method and the device can flexibly obtain different target assembly results according to the associated identifications and attribute information in the target field tables after the target field tables corresponding to different data identifications are obtained, and therefore the flexibility of query of charts or signboards in visual pages is improved.
Drawings
FIG. 1 is an application environment diagram of a data visualization method in one embodiment;
FIG. 2 is a flow diagram of a method of visualizing data 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 a query for data in one embodiment;
FIG. 5 is a flow diagram of one embodiment of determining configuration information;
FIG. 6 is a block diagram of a data visualization device in one embodiment;
fig. 7 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
The data visualization method provided by the embodiment of the application can be applied to an 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 each independently perform the data visualization method provided in the embodiment of the present application, or may cooperatively perform the data visualization method provided in the embodiment of the present application. Taking the example that the terminal 102 and the server 104 cooperate to perform the data visualization method, the terminal 102 is configured to send the 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 association 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 converts the format of 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, smartphones, tablet computers, and portable wearable devices, and the server 104 may be implemented as a stand-alone server or a server cluster composed of a plurality of servers.
In one embodiment, as shown in fig. 2, a data visualization method is provided, and the method is applied to a computer device, which may be a terminal or a server in fig. 1, for example. The data visualization method comprises the following steps:
step 202, when a data query request is obtained, determining a data identifier in the data query request.
The data query request may be a request for querying a chart or a billboard, the chart may be a pie chart, a histogram, etc. in the data visualization process, and the billboard may be obtained after the chart is combined and laid out. It is easy to understand that when a chart request is queried, the data identifier in the data query request is the chart identifier, and when a billboard request is queried, the data identifier in the data query request is the billboard 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 the 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 presentation 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 page interaction module inquires the request for data; when the request type is a POST request, the request is configured for data.
In one embodiment, FIG. 4 is a timing diagram for querying data. When a user triggers a data query request of a signboard or a chart, a Web server in the computer equipment performs system login verification on the user, and the data query request at the moment comprises a user name and a data identifier. And after the login verification of the system is passed, authentication service is carried out through an authentication center, so that the Web server carries out authority verification on the user name. When the authority verification is passed, the Web server can carry out loading configuration according to the data identification. Wherein the loading configuration characterization has completed the configuration of the sign or chart, i.e., has configured configuration information.
In one embodiment, after each billboard or chart is configured, unique abstract processing is performed on the billboard or chart, so as to generate a character string corresponding to the data identifier.
In one embodiment, referring to FIG. 3, a Web server includes a business layer, a presentation layer, log records, and rights management in a data visualization system. The log records mainly record related operations of the business layer, and facilitate subsequent security audit.
In one embodiment, the computer device may combine the chart and the billboard and convert it into a report that can be subscribed for viewing, where the data identifier in the data query request is the report identifier.
Step 204, determining a target field table corresponding to the data identifier according to preset configuration information.
The target field table comprises an associated 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 the billboard corresponding to the data identifier, a data table recording all relevant information of the chart or the billboard 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 identification to be configured, which is the same as the data identification, from the plurality of data identifications to be configured, and takes the field table in which the data identification to be configured is positioned as a target field table corresponding to the data identification.
In one embodiment, when a data configuration request is acquired, determining a data identifier to be configured in the data query request, and responding to a configuration operation of a user aiming at the data identifier to be configured to obtain configuration information corresponding to the data identifier to be configured.
And step 206, screening the target data set from the data warehouse according to the association identification.
When the data identifier is a chart identifier, the corresponding association identifier comprises a data set identifier of the upper level of the chart identifier and a data source identifier of the upper level of the data set identifier; when the data identifier is a billboard identifier, the corresponding associated identifier comprises a chart identifier of the upper level of the billboard identifier, a data set identifier of the upper level of the chart identifier and a data source identifier of the upper level of the data set identifier. The data source identification characterization of the previous stage of the data set identification needs to be configured on the basis of configuring the data source identification; likewise, the data set identifier characterization of the previous stage of the chart identifier needs to be configured on the basis of the data set identifier configuration process.
The data source corresponding to the data set identifier is mainly represented 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 identifier comprises a virtual table or an entity table, the virtual table can be obtained by executing SQL query from a data source, the virtual table is a table which is virtualized when SQL queries data, no actually corresponding table exists in the data source, and the entity table has an actually corresponding table in the data source.
In particular, 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. Wherein the data sources in the data warehouse include at least MySQL, impala, hadoop, 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 identifier from the data warehouse according to the first field table and the second field table.
It is easy to understand that, because the signboard is obtained by combining multiple charts, when the data identifier is the signboard identifier, the corresponding association identifier includes multiple chart identifiers, and for each chart identifier in the association identifier, the respective corresponding sub-data set of each chart identifier can be screened out from the data warehouse, and the target data set corresponding to the signboard identifier can be obtained by integrating the multiple sub-data sets.
In one 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. The cache is provided with a target data set representation which is used for inquiring the chart or the billboard corresponding to the data identification.
And step 208, assembling the target data set according to the visualization type to obtain an initial assembly result, and converting the format of the initial assembly result according to the display format to obtain the target assembly result.
The visualization type can be a pie chart type, a two-dimensional histogram type and the like corresponding to the chart, and the type of different layouts of the charts corresponding to the signboards; the list data in the display format characterization chart is displayed as integers, decimal numbers or a format with special characters. Wherein the attribute information further includes dimension information.
Specifically, referring to fig. 4, when the data layer screens out the target data set corresponding to the chart 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 the filtered target data set is obtained. For example, the dimension information is two-dimensional, only two-dimensional data in the target dataset 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 header data and list data in the target data set, and obtains an initial assembly result. And the Web server converts the data format of the initial assembly result according to the display format so as to enable the target assembly result.
In one embodiment, the data query request may further include query conditions, and before the target data set is assembled according to the visualization type to obtain the initial assembly result, the Web server may further perform condition screening on the target data set through the query conditions to obtain a screened target data set. The inquiry condition is, for example, a designated time. Thus, the information which is more focused by the user can be obtained.
And 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 billboard.
In one embodiment, performing data rendering on the target assembly result to obtain a visual page corresponding to the data identifier, including: 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 identifier.
The front end tool is a front end UI, and man-machine interaction and operation logic design can be performed. The document object model can be a DOM, the document type DOM is mainly used for operating the contents of an HTML document and an XML document, the DOM depicts a hierarchical node tree, and the document contents are added, deleted and revised through the operation of the nodes. Text formats include plain text and rich text.
Specifically, referring to fig. 3, the presentation layer further includes a template engine rendering module, where the presentation layer responds to the front end UI with two formats of messages in different scenes. When the text format corresponding to the target assembly result is plain text, determining that the corresponding target message is an AJAX JSON format message. When the front end UI acquires a target assembly result corresponding to the AJAX JSON format message, binding the target assembly result into the document object model to obtain a bound target document object model. When the text format corresponding to the target assembly result is rich text, the target message can be obtained to be 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 to obtain a target document object model. Aiming at messages with different formats, the visual page corresponding to the data identifier can be obtained through rendering the target assembly result by the target document object model.
In one embodiment, the front end UI may include a React development framework, a CSS development framework, an Html development framework, and the like. Referring to FIG. 3, the data visualization system may be deployed in a cloud host, local and third party virtual hosts, and other operating environments.
In the data visualization method, 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 preset configuration information; the target field table comprises an associated identifier and attribute information, wherein the attribute information comprises a visualization type and a display format. When a target data set is screened out from a data warehouse according to the association identifier, the target data set can be assembled according to the visualization type to obtain an initial assembly result, and then the initial assembly result is subjected to format conversion according to the display format to obtain a target assembly result; therefore, the visual page corresponding to the data identifier can be obtained by carrying out 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 the visual query can be performed only after the participation result is obtained, the method and the device can flexibly obtain different target assembly results according to the associated identifications and attribute information in the target field table after obtaining the target field table corresponding to different data identifications, and therefore the flexibility of displaying charts or signboards 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, including the steps of:
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 stage of data source management, chart management of the next stage of data set management and billboard management of the next stage of chart management. The data set management characterization of the next stage of data source management needs to complete the configuration of the data set identification to be configured through the data set management after completing the configuration of the data source identification to be configured through the data source management; likewise, the chart management characterization of the next level of data set management requires that the process of configuring the chart identification to be configured is completed through the chart management on the basis that the configuration of the data set identification to be configured is completed through the data set management.
Specifically, referring to fig. 3, the data visualization system further includes a business layer, and management types in the business layer include data source management, data set management, chart management, billboard management, subscription report, and rights management. When the presentation layer responds to the request operation of the user, the page interactive interface in the presentation layer can determine the request type of the request operation, and when the request type is a POST request, the request is configured for data.
And step 504, determining the data identification to be configured according to the management type.
The data identifier to be configured can be an ID corresponding to the 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 used for managing the data set, 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; when the management type is billboard management, the corresponding data identifier to be configured is a billboard identifier.
Step 506, responding to the configuration operation for the data identifier to be configured, and obtaining a field table corresponding to the data identifier to be configured.
The data identifiers to be configured comprise a billboard identifier, a chart identifier of the upper level of the billboard identifier, a data set identifier of the upper level of the chart identifier and a data source identifier of the upper level of the data set identifier.
In one embodiment, in response to a configuration operation for a data identifier to be configured, a field table corresponding to the data identifier to be configured is obtained, including: displaying a configuration interface comprising a configuration list; determining an associated identifier of a higher level 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 association identifier is not the data source identifier in the data source identifier list, the association identifier is used as a new data identifier to be configured, and the process of responding to the association operation aiming at the data identifier to be configured and the configuration list is returned to continue until the association identifier is obtained as the data source identifier; responding to attribute configuration operation aiming at the data identifier to be configured, and obtaining attribute information corresponding to the data identifier to be configured; and integrating the plurality of associated identifiers and the attribute information to obtain a field table corresponding to the data identifier 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. Wherein the configuration list includes at least one of a data source identification list, a data set identification list, and a chart identification list. In response to a user selection operation for a data source identifier in the data source identifier list, the computer device uses the selected data source identifier as an associated identifier associated with the data identifier to be configured. Because the association identifier at this time is the data source identifier in the data source identifier list, the configuration operation of the association identifier corresponding to the data set identifier can be regarded as completed, that is, the configuration between the data set identifier and the data source identifier of the previous stage is 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 user selection operation for a data set identifier in the data set identifier list, the computer device regards the selected data set identifier as an associated identifier associated with the data identifier 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. Thus, the configuration between the chart identifier and the data set identifier of the upper stage and the configuration between the chart identifier and the data source identifier of the upper stage are finally obtained. For example, the association corresponding to chart identification A is identified as data set 1 and the association of data set 1 is identified as data source a, and thus, the association corresponding to chart identification A is identified as data set 1 and data source a.
Likewise, when the data identifier to be configured is a billboard 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 billboard identifier is substantially the same as a process of configuring the chart identifier, which is not described herein.
Further, the computer equipment responds to the attribute configuration operation aiming at the data identifier to be configured to obtain attribute information corresponding to the data identifier to be configured, and synthesizes a plurality of associated identifiers and the attribute information to obtain a field table corresponding to the data identifier to be configured. The data source management field table is shown in table 1, the data set management field table is shown in table 2, the chart management field table is shown in table 3, and the billboard management field table is shown in table 4.
Table 1:
table 2:
table 3:
table 4:
and step 508, returning to the process of obtaining the data configuration request, and continuing to take the management type of the next stage of the management type as a new management type until a field table corresponding to the data identifier to be configured in the management of the signboard 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 identifier is managed, the computer device responds to the creation and configuration operation of the user for each data source identifier to obtain a configured data source identifier list, and displays the 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 identifier is managed by the data set, the computer device responds to the creation and configuration operation of the user for each data set identifier to obtain a configured data set identifier list, 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, chart management, the computer device responds to the creation and configuration operation of the user for each chart identifier to obtain a chart identifier list with completed configuration. 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 chart identification list by a user, and various signboards can be constructed.
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 equipment can periodically send the configured report to the corresponding user through a mail or the like. The field table obtained by subscribing to the report is shown in table 5.
Table 5:
in one embodiment, after completing the configuration of the signboard identifier to be configured through the signboard management, the configuration of the authority user can be completed through the authority management, and a field table corresponding to the authority user is obtained. The field table corresponding to the authority user comprises a user table, a role table and a user role association table, wherein the user table corresponds to a user such as employee a or employee B, and the role table corresponds to a role such as a financial staff or developer. The user table is shown in table 6, the role 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, integrating the field table corresponding to each data identifier to be configured to obtain configuration information.
In this embodiment, the configuration operation of the data identifier to be configured is further completed by determining the data identifier to be configured corresponding to the management type, so as to obtain the field table corresponding to the data identifier to be configured, so that the configured field table can be accurately obtained when the visual query is performed on the signboard or the chart later, and the efficiency of the visual query of the data is improved. Meanwhile, as the user can flexibly configure the corresponding management type, the development cost and the configuration threshold are reduced, and the flexibility of data visual inquiry is also improved.
In one embodiment, screening the target data set from the data warehouse based on the association identification includes: 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; 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 integrating the current data sets corresponding to the data set identifiers to obtain the target data set.
When the data identifier is a billboard identifier, the association identifier comprises a plurality of data source identifiers, a plurality of data set identifiers and a plurality of chart identifiers. The first field table includes a connection address; the second field table includes a query field.
Specifically, since the signboard is obtained by combining multiple charts, for each chart identifier in the associated identifier, the computer device can determine the current data source identifier and the current data set identifier corresponding to the current chart identifier, and determine the first field table corresponding to the current data source identifier and the second field table corresponding to the current data set identifier. The process of screening the target data set corresponding to the chart identifier from the data warehouse according to the first field table and the second field table may refer to step 206, which is not described herein.
Further, since the data warehouse includes a plurality of data sources, including a plurality of data sets, the computer device needs to query the data warehouse through the query field to determine the current location in the data warehouse to which the current data set identifies. When the current location of the current dataset identification is determined, the current dataset at the current location may be extracted by the connection address of the data source. Therefore, the computer equipment synthesizes the current data set corresponding to each data set identifier, and the target data set corresponding to the signboard identifier can be obtained.
In this embodiment, since the management type of the previous stage is required to be associated with each management type of the previous stage, a multi-stage association identifier corresponding to the data identifier to be configured is obtained, so that when the target data set is queried, the position of the target data set in the data warehouse can be rapidly located.
In one embodiment, before assembling the target data set according to the visualization type, the method further comprises: and screening the sub-data sets corresponding to each chart identifier from the target data sets.
In one embodiment, assembling the target data set according to the visualization type to obtain an initial assembly result includes: assembling the sub-data sets through the sub-visualization types corresponding to each chart identifier respectively to obtain sub-assembly results corresponding to each chart identifier; and respectively associating each sub-assembly result to a chart position corresponding to the corresponding chart identifier to obtain an initial assembly result.
The attribute information comprises a sub-visualization type and a chart position corresponding to each chart identifier; the sub-data sets are assembled through the sub-visualization types corresponding to each chart identifier, so as to obtain the specific implementation process of the sub-assembly result corresponding to each chart identifier, and reference may be made to the specific implementation process of step 208, which is not repeated herein.
In particular, the multiple chart combinations in different signs are not identical, i.e., the chart positions where each chart is placed in the sign are not identical. When the computer equipment obtains the sub-assembly results corresponding to each chart identifier, each sub-assembly result can be respectively associated to the corresponding chart position, and the initial assembly result corresponding to the billboard identifier is obtained.
In this embodiment, a plurality of chart identifications corresponding to the billboard identifications are determined through billboard management, so as to obtain sub-visualization types corresponding to each chart identification, and when charts of the sub-visualization types are flexibly laid out through chart positions in the attribute information, the flexibility of billboard 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 sets through grouping types to obtain a plurality of groups of grouping data sets; according to the configuration index, calculating each group of group data sets to obtain calculation results corresponding to the group data sets; and integrating each calculation result and the corresponding grouping type to obtain an initial assembly result corresponding to the data identifier.
The visual template comprises grouping types and configuration indexes; the configuration index includes at least summing, counting, or maximizing.
In particular, when the data identifier is a chart identifier, the computer device may obtain a visualization template, such as a two-dimensional histogram template, corresponding to the visualization type from the corresponding database. The computer device groups the target data set by the group type, for example, when the group type is the user ID, the data corresponding to different user IDs can be divided into multiple groups, so as to obtain multiple groups of group data sets. The computer device calculates each group of group data sets according to the configuration index, for example, when the configuration index is summation, the group data sets corresponding to the user 1 can be summed to obtain the calculation results corresponding to the group data sets. And the computer equipment assembles each calculation result and the corresponding grouping type 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 obtained rapidly 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 performed efficiently.
It should be understood that, although the steps in the flowcharts related to the above embodiments are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a data visualization device for realizing the data visualization method. The implementation of the solution provided by the device is similar to the implementation described in the above method, so specific limitations in one or more embodiments of the data visualization device provided below may be referred to above as limitations of the data visualization method, and will not be described herein.
In one embodiment, as shown in FIG. 6, there is provided a data visualization apparatus 600 comprising: a segment 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, when a data query request is acquired, 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 includes a visualization type and a display format;
an assembly result determining module 604, configured to screen the 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 606 is configured to perform 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 diagrammed sheet and a billboard.
In one embodiment, the data visualization apparatus 600 further includes a data configuration module 608, configured to obtain the data configuration request, and determine a management type corresponding to the data configuration request; the management type comprises data source management, data set management of the next stage of data source management, chart management of the next stage of data set management and signboard management of the next stage of chart management; determining a data identifier to be configured according to the management type; responding to configuration operation aiming at the data identifier to be configured, and obtaining a field table corresponding to the data identifier to be configured; returning to the process of obtaining the data configuration request, continuing to take the management type of the next stage of the management type as a new management type until a field table corresponding to the data identifier to be configured in the management of the signboard is obtained; and integrating the field tables corresponding to each data identifier to be configured to obtain configuration information.
In one embodiment, data configuration module 608 is further configured to present 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; determining an associated identifier of a higher level 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 association identifier is not the data source identifier in the data source identifier list, the association identifier is used as a new data identifier to be configured, and the process of responding to the association operation aiming at the data identifier to be configured and the configuration list is returned to continue until the association identifier is obtained as the data source identifier; responding to attribute configuration operation aiming at the data identifier to be configured, and obtaining attribute information corresponding to the data identifier to be configured; and integrating the plurality of associated identifiers and the attribute information to obtain a field table corresponding to the data identifier to be configured.
In one embodiment, the assembly result determining module 604 further includes a dataset screening module 6041, configured to determine, for each chart identifier in the association identifiers, a current data source identifier and a current dataset identifier corresponding to the current chart identifier from the association 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 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 the target data set.
In one embodiment, the assembly result determining module 604 further includes a dataset assembly module 6042 for screening each chart identifier from the target dataset for a respective sub-dataset; assembling the sub-data sets through the sub-visualization types corresponding to each chart identifier respectively to obtain sub-assembly results corresponding to each chart identifier; and respectively associating each sub-assembly result to a chart position corresponding to the corresponding chart identifier to obtain an initial assembly result.
In one embodiment, the dataset assembly module 6042 is further configured to determine a visualization template corresponding to the visualization type; the visualization template comprises grouping types and configuration indexes; grouping the target data sets through grouping types to obtain a plurality of groups of grouping data sets; according to the configuration index, calculating each group of group data sets to obtain calculation results corresponding to the group data sets; and integrating each calculation result and the corresponding grouping type to obtain an initial assembly result corresponding to the data identifier.
In one embodiment, the data rendering module 606 is further configured to construct an initial document object model through 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 identifier.
The various modules in the data visualization apparatus described above may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a terminal, and the internal structure of which may be as shown in fig. 7. The computer device includes a processor, a memory, an Input/Output interface (I/O), a communication interface, a display unit, and an Input device. 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 includes a non-volatile 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 the operating system and computer programs in the non-volatile storage media. The input/output interface of the computer device is used to exchange information between the processor and the 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 mode 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 data visualization method. The display unit of the computer equipment is used for forming a visual picture, and can be a display screen, a projection device or a virtual reality imaging device, wherein the display screen can be a liquid crystal display screen or an electronic ink display screen, and 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.
It will be appreciated by those skilled in the art that the structure shown in fig. 7 is merely a block diagram of a portion of the structure associated with the present application and is not intended to limit the computer device to which the present application is applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.
In an embodiment, there is also provided a computer device comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of the method embodiments described above when the computer program is executed.
In one embodiment, a computer-readable storage medium is provided, storing a computer program which, when executed by a processor, implements the steps of the method embodiments described above.
In one embodiment, a computer program product or computer program is provided that includes computer instructions stored in a computer readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device performs the steps in the above-described method embodiments.
Those skilled in the art will appreciate that implementing all or part of the above-described embodiment methods may be accomplished by way of a computer program that instructs associated hardware to perform the method, and that the computer program may be stored on a non-volatile computer readable storage medium, which when executed, may comprise the embodiment flows of the above-described methods. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-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 units, quantum computing-based data processing logic units, etc., without being limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The foregoing examples represent only a few embodiments of the present application, which are described in more detail and are not thereby to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.
Claims (10)
1. A method of visualizing data, the method comprising:
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 stage of the data source management, chart management of the next stage of the data set management and signboard management of the next stage of the chart management;
Determining a data identifier to be configured according to the management type, and responding to configuration operation aiming at the data identifier to be configured to obtain a field table corresponding to the data identifier to be configured;
returning to the process of obtaining the data configuration request, continuing to take the management type of the next stage of the management type as a new management type until a field table corresponding to the data identifier to be configured in the process of managing the signboard is obtained;
integrating the field table corresponding to each data identifier to be configured to obtain configuration information;
when a data query request is acquired, determining a data identifier in the data query request; the data identifier comprises a chart identifier;
determining a target field table corresponding to the data identifier according to the configuration information; the target field table comprises an associated 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, and determining a visualization template corresponding to the visualization type; the visual template comprises grouping types and configuration indexes; the configuration index at least comprises summation, counting or calculating the maximum value;
Grouping the target data sets through the grouping types to obtain a plurality of groups of grouping data sets, and respectively calculating each group of grouping data sets according to the configuration indexes to obtain calculation results corresponding to the grouping data sets;
synthesizing each calculation result and the corresponding grouping type to obtain an initial assembly result corresponding to the data identifier, and converting the format of 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 visual page comprises at least one of a chart and a billboard;
wherein, the association identifier comprises a data set identifier of the upper level of the chart identifier and a data source identifier of the upper level of the data set identifier; the screening the target data set from the data warehouse according to the association identifier comprises the following steps:
determining a first field table corresponding to a data source identifier in the associated identifier and a second field table corresponding to a data set identifier in the associated identifier;
and screening a target data set corresponding to the chart identifier from a data warehouse according to the first field table and the second field table.
2. The method of claim 1, wherein the attribute information comprises dimension information.
3. The method of claim 1, wherein the data identifier to be configured comprises a billboard identifier, a chart identifier of a higher level of the billboard identifier, a dataset identifier of a higher level of the chart identifier, and a data source identifier of a higher level of the dataset identifier;
the responding to the configuration operation for the data identifier to be configured obtains a field table corresponding to the data identifier to be configured, which comprises the following steps:
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;
determining an association identifier of a higher level of the data identifier to be configured in response to the association operation aiming at the data identifier to be configured and the configuration list;
if the association identifier is not the data source identifier in the data source identifier list, the association identifier is used as a new data identifier to be configured, and the process of responding to the association operation for the data identifier to be configured and the configuration list is returned to continue until the association identifier is obtained as the data source identifier;
Responding to attribute configuration operation aiming at the data identifier to be configured to obtain attribute information corresponding to the data identifier to be configured;
and integrating a plurality of the association 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 identifier comprises a plurality of data source identifiers, a plurality of data set identifiers and a plurality of chart identifiers; the screening the target data set from the data warehouse according to the association identifier comprises the following steps:
determining a current data source identifier and a current data set identifier corresponding to the current chart identifier from the associated identifiers aiming at each chart identifier in 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 includes a query field;
querying the data warehouse through the query 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.
5. The method of claim 4, wherein the attribute information includes a respective child visualization type and chart position for each of the chart identifications; before the target data set is assembled according to the visualization type to obtain an initial assembly result, the method further comprises:
screening sub-data sets corresponding to each chart identifier from the target data set;
the step of assembling the target data set according to the visualization type to obtain an initial assembly result, which comprises the following steps:
assembling the sub-data sets through the sub-visualization types corresponding to the chart identifications respectively to obtain sub-assembly results corresponding to the chart identifications respectively;
and respectively associating each sub-assembly result to a chart position corresponding to the corresponding chart identifier to obtain an initial assembly result.
6. The method of claim 1, wherein the visualization template comprises a two-dimensional histogram template.
7. The method of claim 1, wherein the performing data rendering on the target assembly result to obtain the visual 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 identifier.
8. A data visualization apparatus, the apparatus comprising:
the field table determining module is used for 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 stage of the data source management, chart management of the next stage of the data set management and signboard management of the next stage of the chart management; determining a data identifier to be configured according to the management type, and responding to configuration operation aiming at the data identifier to be configured to obtain a field table corresponding to the data identifier to be configured; returning to the process of obtaining the data configuration request, continuing to take the management type of the next stage of the management type as a new management type until a field table corresponding to the data identifier to be configured in the process of managing the signboard is obtained; integrating the field table corresponding to each data identifier to be configured to obtain configuration information; when a data query request is acquired, determining a data identifier in the data query request; the data identifier comprises a chart identifier; determining a target field table corresponding to the data identifier according to the configuration information; the target field table comprises an associated 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 and determining a visualization template corresponding to the visualization type; the visual template comprises grouping types and configuration indexes; the configuration index at least comprises summation, counting or calculating the maximum value; grouping the target data sets through the grouping types to obtain a plurality of groups of grouping data sets, and respectively calculating each group of grouping data sets according to the configuration indexes to obtain calculation results corresponding to the grouping data sets; synthesizing each calculation result and the corresponding grouping type to obtain an initial assembly result corresponding to the data identifier, and converting the format of the initial assembly result according to the display format to obtain a target assembly result; wherein, the association identifier comprises a data set identifier of the upper level of the chart identifier and a data source identifier of the upper level of the data set identifier; the screening the target data set from the data warehouse according to the association identifier comprises the following steps: determining a first field table corresponding to a data source identifier in the associated identifier and a second field table corresponding to a data set identifier in the associated identifier; screening a target data set corresponding to the chart identifier from a data warehouse according to the first field table and the second field table;
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.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211497228.7A CN115544183B (en) | 2022-11-28 | 2022-11-28 | Data visualization method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211497228.7A CN115544183B (en) | 2022-11-28 | 2022-11-28 | Data visualization method, device, computer equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN115544183A CN115544183A (en) | 2022-12-30 |
CN115544183B true CN115544183B (en) | 2023-05-09 |
Family
ID=84721945
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202211497228.7A Active CN115544183B (en) | 2022-11-28 | 2022-11-28 | Data visualization method, device, computer equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN115544183B (en) |
Families Citing this family (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN115685858B (en) * | 2023-01-05 | 2023-04-07 | 苏州慧工云信息科技有限公司 | JIT-based electronic billboard data controller and control method |
CN115858633B (en) * | 2023-02-27 | 2023-10-20 | 广州汇通国信科技有限公司 | Time sequence data analysis method and device based on data lake |
CN117271527B (en) * | 2023-11-13 | 2024-02-09 | 煤炭科学研究总院有限公司 | Organization management method and device for mine data, electronic equipment and storage medium |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021184571A1 (en) * | 2020-03-17 | 2021-09-23 | 平安国际智慧城市科技股份有限公司 | Dynamic form generation method, apparatus, computer device, and storage medium |
CN115061721A (en) * | 2022-07-12 | 2022-09-16 | 平安科技(深圳)有限公司 | Report generation method and device, computer equipment and storage medium |
Family Cites Families (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8321781B2 (en) * | 2007-02-08 | 2012-11-27 | Microsoft Corporation | User interface pane for an interactive chart |
US10572473B2 (en) * | 2013-10-09 | 2020-02-25 | International Business Machines Corporation | Optimized data visualization according to natural language query |
US11176125B2 (en) * | 2018-10-31 | 2021-11-16 | Sap Se | Blended retrieval of data in transformed, normalized data models |
CN114676182A (en) * | 2022-03-25 | 2022-06-28 | 深圳市优必选科技股份有限公司 | Chart generation method and device, computer equipment and computer readable storage medium |
CN114969193A (en) * | 2022-05-16 | 2022-08-30 | 成都数之联科技股份有限公司 | Method, system, device and medium for generating chart data |
-
2022
- 2022-11-28 CN CN202211497228.7A patent/CN115544183B/en active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021184571A1 (en) * | 2020-03-17 | 2021-09-23 | 平安国际智慧城市科技股份有限公司 | Dynamic form generation method, apparatus, computer device, and storage medium |
CN115061721A (en) * | 2022-07-12 | 2022-09-16 | 平安科技(深圳)有限公司 | Report generation method and device, computer equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN115544183A (en) | 2022-12-30 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN115544183B (en) | Data visualization method, device, computer equipment and storage medium | |
CN109522357A (en) | A kind of data processing method, device, server and storage medium | |
US10192330B2 (en) | Rendering data visualizations in different analytical applications | |
US9652203B1 (en) | Application development framework using configurable data types | |
CN111046237A (en) | User behavior data processing method and device, electronic equipment and readable medium | |
CN116305895A (en) | Product model generation method, device, computer equipment and storage medium | |
US20090319537A1 (en) | Method And System of Using Structured Social Networks and Communities to Create And Maintain Relationships Between Configuration Items in a Configuration Management Database | |
CN117390011A (en) | Report data processing method, device, computer equipment and storage medium | |
CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
CN115658794B (en) | Data query method, device, computer equipment and storage medium | |
CN109783491B (en) | Material product information interaction system used in graphic tool and cloud data | |
CN114860819A (en) | Method, device, equipment and storage medium for constructing business intelligent system | |
CN115293685A (en) | Logistics order state tracking method, device, equipment and storage medium | |
CN111191057A (en) | User-defined retrieval method and device, electronic equipment and storage medium thereof | |
US11507554B2 (en) | Tree-like metadata structure for composite datasets | |
CN117435589A (en) | Data transfer method, device, computer equipment and storage medium | |
CN116383138A (en) | Document changing method, device, computer equipment and storage medium | |
CN117951223A (en) | Data synchronization method, device, computer equipment and storage medium | |
CN116610667A (en) | Service data processing method, device, computer equipment and storage medium | |
CN117435668A (en) | Data synchronization method, device, computer equipment and storage medium | |
CN117033452A (en) | Database processing method, device, computer equipment and storage medium | |
CN116415914A (en) | Service data processing method, device, computer equipment and storage medium | |
CN118193043A (en) | Processing method and device of business attribute data, computer equipment and storage medium | |
CN116893846A (en) | Data flow processing method, device, equipment, medium and program product | |
CN117370281A (en) | Data maintenance method, device, computer equipment and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |