CN114238455A

CN114238455A - Visualization method, visualization device, visualization terminal and storage medium

Info

Publication number: CN114238455A
Application number: CN202111554408.XA
Authority: CN
Inventors: 衷鑫
Original assignee: Ubtech Robotics Corp
Current assignee: Ubtech Robotics Corp
Priority date: 2021-12-17
Filing date: 2021-12-17
Publication date: 2022-03-25

Abstract

The embodiment of the invention discloses a visualization method, a visualization device, a terminal and a storage medium, wherein the method comprises the following steps: determining the chart type and acquiring configuration information of a user; the configuration information comprises chart attribute information and key fields corresponding to the chart attribute information, and a blank chart is generated according to the chart type and the configuration information; and acquiring visual data in a database according to the configuration information, and filling the blank chart to form a final chart. The data stored in the database by the user can be simply and easily converted into the visual chart, and the user does not need to difficultly redefine and develop each chart and carry out repeated development work.

Description

Visualization method, visualization device, visualization terminal and storage medium

Technical Field

The present invention relates to the field of visualization, and in particular, to a visualization method, apparatus, terminal, and storage medium.

Background

The human brain processes visual information better than text, so using elements such as charts, graphs, etc. can help people quickly understand the meaning, trend and relevance in data. That is to say, data visualization is actually a process of visually expressing abstract concepts and graphically visualizing abstract languages. In the existing program system, more and more data are displayed and visualized by using data, and the representation of chart types is more diversified and richer in the aspect of the representation form of a visual chart tool. Besides the traditional common figures such as pie charts, bar charts, line charts and the like, the cool and dazzling charts such as bubble charts, area charts, province maps, word clouds, waterfall charts, funnel charts and the like, and even GIS maps. These wide variety of graphics can meet different presentation and analysis requirements.

In a general software system, each chart needs to be redeveloped, so that a large amount of repeated development work exists, and a large amount of labor and time are consumed.

Disclosure of Invention

In view of the above, the present application provides a visualization method, including:

determining the chart type and acquiring configuration information of a user; the configuration information comprises chart attribute information and key fields corresponding to the chart source data;

generating a blank chart according to the chart type and the chart attribute information;

and obtaining chart source data in a database according to the key fields, and generating a final chart based on the chart source data and the blank chart.

Further, the chart attribute information includes: chart names, legends, abscissa names, and ordinate names.

Further, the generating a blank chart according to the chart type and the chart attribute information includes:

generating an initial blank chart based on the chart type;

adding a chart name, a legend, an abscissa name, an ordinate name and a screening condition to the initial blank chart to generate a blank chart.

Further, the generating a final chart based on the chart source data and the blank chart comprises:

obtaining chart source data in a database according to the key fields;

if the screening condition of the user is obtained, screening data is obtained from the obtained chart source data based on the screening condition;

generating a final graph based on the screening data and the blank graph.

Further, after generating the final chart, the method further includes:

storing the current configuration information of the final chart in a database.

Further, the chart types include one or more of a discount chart, a bar chart, a sector chart, a scatter chart, an area chart, and a bar chart.

Further, an embodiment of the present application further provides a visualization apparatus, including:

the configuration module is used for determining the chart type and acquiring the configuration information of a user; the configuration information comprises chart attribute information and key fields corresponding to the chart source data;

the initialization module is used for generating a blank chart according to the chart type and the configuration information;

and the generating module is used for acquiring chart source data in the database according to the key fields and generating a final chart based on the chart source data and the blank chart.

Further, the apparatus further comprises:

and the storage module is used for storing the current configuration information of the final chart into a database after the final chart is generated.

Further, an embodiment of the present application further provides a computer terminal, which includes a processor and a memory, where the memory stores a computer program, and the computer program executes the visualization method in any one of the foregoing embodiments when running on the processor.

Further, an embodiment of the present application also provides a readable storage medium, which stores a computer program, and the computer program, when executed on a processor, performs the visualization method described in any of the above embodiments.

The application provides a visualization method comprising the following steps: determining the chart type and acquiring configuration information of a user; the configuration information comprises chart attribute information and key fields corresponding to the chart source data; generating a blank chart according to the chart type and the chart attribute information; and obtaining chart source data in a database according to the key fields, and generating a final chart based on the chart source data and the blank chart. When the user needs to generate the chart, the chart can be quickly generated only by simple setting without re-editing and developing according to various charts, the burden of repeated work is reduced, and the user does not need to difficultly re-develop each chart.

Drawings

In order to more clearly illustrate the technical solution of the present invention, the drawings required to be used in the embodiments will be briefly described below, and it should be understood that the following drawings only illustrate some embodiments of the present invention, and therefore should not be considered as limiting the scope of the present invention. Like components are numbered similarly in the various figures.

Fig. 1 is a schematic flow chart illustrating a visualization method according to an embodiment of the present application;

FIG. 2 shows a visualization chart initialization diagram according to an embodiment of the present application;

FIG. 3 shows a schematic diagram of a visualization chart according to an embodiment of the present application;

fig. 4 shows a schematic view of a visualization apparatus according to an embodiment of the present application.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments.

The components of embodiments of the present invention generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present invention without making any creative effort, shall fall within the protection scope of the present invention.

Hereinafter, the terms "including", "having", and their derivatives, which may be used in various embodiments of the present invention, are only intended to indicate specific features, numbers, steps, operations, elements, components, or combinations of the foregoing, and should not be construed as first excluding the existence of, or adding to, one or more other features, numbers, steps, operations, elements, components, or combinations of the foregoing.

Furthermore, the terms "first," "second," "third," and the like are used solely to distinguish one from another and are not to be construed as indicating or implying relative importance.

Unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which various embodiments of the present invention belong. The terms (such as those defined in commonly used dictionaries) should be interpreted as having a meaning that is consistent with their contextual meaning in the relevant art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein in various embodiments of the present invention.

The following explains the visualization method of the present application with specific embodiments.

Example 1

As shown in fig. 1, the present embodiment provides a visualization method, which includes the specific steps of:

step S100, determining the chart type and acquiring the configuration information of a user; the configuration information comprises chart attribute information and key fields corresponding to the chart source data;

in this embodiment, when a user wants to perform visualization operation on data in a database, the chart type is determined first, and configuration information of the user is obtained, where the icon type is naturally a visualization chart form, such as a chart form of a line chart, a bar chart, a scale chart, and the like, and after the chart type is determined, some configuration information of the chart needs to be configured, where the configuration information includes chart attribute information and key fields corresponding to chart source data.

The chart attribute information refers to elements of an abscissa name, an ordinate name and a legend in a chart, which are different attributes of data display of the chart according to different chart types, for example, a company performance table is visualized, the table shows performance data of a first department and a second department from 2019 to 2021 as shown in table one, in order to visualize the table, time can be used as the abscissa, and performance can be used as the ordinate to show performance of the first department and the second department, a specific embodiment mode can be a line graph or a bar graph, therefore, the first department and the second department are represented by different legends, and if the table is a line graph, different line segments are needed as the legends to represent the two departments, and the bar graph is similar.

Further, for the user, it is not enough to see the performance of each year, and the user may want to see the performance change of each month, so it is necessary to record the performance data of the two departments per month, and it is also necessary to determine a filtering condition, which may also be time, where the time may be year, month, and day, which controls whether the data of the abscissa is year unit, month unit, or day unit, and similarly, the filtering condition may also be a department, and different graphs are displayed by selecting different departments, so that it is not necessary to illustrate an example, and which category the specific filtering condition is preset by the user.

The key fields are the time, department, and specific department name and year in table 1, and all have data associated with them in the database as the chart data source for the chart. In this embodiment, the entire table is the source of the chart data.

Watch 1

Time/department	First department	Second department
			2019	20	30
2020	30	40
			2021	40	45

Step S200, generating a blank chart according to the chart type and the chart attribute information;

after the chart type and the chart attribute information are determined, initializing a blank chart can be started, and the method takes a histogram as an example, sets time as an abscissa, performance as an ordinate, departments as a legend, and takes time as a screening condition. The screening condition may be presented in a number axis, a pull-down list, or a search input box, and is mainly used for controlling selection of an abscissa or a legend.

First, an initial blank chart is generated according to the histogram, that is, a blank area is used for loading the next histogram, obviously, the histogram has the elements of abscissa, ordinate, legend and screening conditions, so that a blank chart is generated by adding all the above chart attribute information to the initial blank table for preliminary filling. The blank chart is shown in fig. 2, but only fills a frame, and no specific chart is generated by importing data.

When a certain key field is used as a screening condition, an enumeration value needs to be configured for the key field, and specifically, if time is used as the screening condition, the time is of three types, namely year, month and day, then enumeration values need to be configured for the three types, so that the three types can be identified when switching is performed.

And step S300, obtaining chart source data in a database according to the key fields, and generating a final chart based on the chart source data and the blank chart.

After the blank icon is generated, the original chart data in the database can be obtained according to the key resources, wherein the chart source data refers to all data needing visualization next, namely, a form is selected from the database, and then the final chart is generated according to the blank chart.

Furthermore, after the chart source data is acquired, the screening conditions set by the user need to be confirmed first.

Some chart types are not provided with abscissas or legends, such as sector charts, proportion charts and the like, but the charts are used for displaying data in a database, abstract data is visualized, so that the relationship between two or more key fields is necessarily reflected, and therefore, screening conditions for controlling the abscissas or the legends are necessarily present to adjust the display of the charts.

Therefore, after generating the blank chart, the filtering condition is determined, the chart elements such as the abscissa or the legend are determined based on the filtering condition, and then the data query is performed. For example, if the screening condition is determined as the year in the time category, the abscissa data is determined according to the year, then a specific database query language is generated according to the abscissa data and the legend, the required chart source data is queried in the database, and finally the data in the table one is obtained, and then the blank chart generated in front of the chart type network is refilled to generate the final chart shown in fig. 3.

In fig. 3, the first department and the second department are distinguished by using black and white blocks as legends, performance is used as an ordinate, time is used as an abscissa, and a screening condition is displayed, so that the change and comparison of the performances of the first department and the second department in the three years are displayed, wherein the screening condition is a pull-down menu mode, only three types of the year, month and day are provided, if the month is selected, the abscissa is set according to the month in the step, the abscissa is from one month to twelve months, and then the performances of the two departments in the three years, each month or each month in a certain year are inquired according to the month. Then generating a chart according to the inquired data.

After the chart is generated, the configuration of the chart is stored in the database, so that when different data are needed to be visualized next time, the existing chart can be directly called from the database for visualization, configuration operation is omitted, and the chart can be repeatedly used in different data tables.

Example 2

The embodiment of the present application further provides a visualization apparatus, as shown in fig. 4, including a configuration module 10, an initialization module 20, a generation module 30, and a storage module 40.

The configuration module 10 is used for determining the chart type and acquiring the configuration information of the user; the configuration information includes chart attribute information and key fields corresponding to the chart source data.

And the initialization module 20 is configured to generate a blank chart according to the chart type and the configuration information.

And the generating module 30 is configured to obtain chart source data in the database according to the key field, and generate a final chart based on the chart source data and the blank chart.

And the storage module 40 is configured to store the current configuration information of the final chart in a database after the final chart is generated.

In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method can be implemented in other ways. The apparatus embodiments described above are merely illustrative and, for example, the flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

In addition, each functional module or unit in each embodiment of the present invention may be integrated together to form an independent part, or each module may exist separately, or two or more modules may be integrated to form an independent part.

The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention or a part of the technical solution that contributes to the prior art in essence can be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a smart phone, a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.

The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and all the changes or substitutions should be covered within the scope of the present invention.

Claims

1. A visualization method, comprising:

2. A visualization method as recited in claim 1, wherein said chart attribute information comprises: chart names, legends, abscissa names, and ordinate names.

3. A visualization method as recited in claim 2, wherein said generating a blank chart from said chart type and said chart attribute information comprises:

generating an initial blank chart based on the chart type;

4. A visualization method as recited in claim 1, wherein said generating a final chart based on the chart source data and the blank chart comprises:

obtaining chart source data in a database according to the key fields;

generating a final graph based on the screening data and the blank graph.

5. A visualization method as recited in claim 1, further comprising, after generating the final chart:

storing the current configuration information of the final chart in a database.

6. A visualization method as recited in claim 1, wherein the chart types include one or more of a discount chart, a bar chart, a sector chart, a scatter chart, an area chart, and a bar chart.

7. A visualization device, comprising:

8. A visualization device as recited in claim 7, further comprising:

9. A computer terminal, characterized in that it comprises a processor and a memory, said memory storing a computer program which, when run on said processor, performs the visualization method according to any one of claims 1 to 6.

10. A readable storage medium, characterized in that it stores a computer program which, when run on a processor, performs the visualization method according to any one of claims 1 to 6.