CN113641735A - Visual display method of federal cluster data, electronic equipment and storage medium - Google Patents
Visual display method of federal cluster data, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN113641735A CN113641735A CN202110938736.3A CN202110938736A CN113641735A CN 113641735 A CN113641735 A CN 113641735A CN 202110938736 A CN202110938736 A CN 202110938736A CN 113641735 A CN113641735 A CN 113641735A
- Authority
- CN
- China
- Prior art keywords
- chart
- data
- query
- attribute information
- page
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 57
- 230000000007 visual effect Effects 0.000 title description 4
- 238000009877 rendering Methods 0.000 claims abstract description 30
- 238000013079 data visualisation Methods 0.000 claims abstract description 24
- 238000013507 mapping Methods 0.000 claims abstract description 24
- 238000004891 communication Methods 0.000 claims description 18
- 238000010586 diagram Methods 0.000 description 12
- 238000012545 processing Methods 0.000 description 11
- 238000006243 chemical reaction Methods 0.000 description 4
- 238000012800 visualization Methods 0.000 description 2
- 238000013461 design Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000011022 operating instruction Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
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/24—Querying
- G06F16/248—Presentation of query results
-
- 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a federal cluster data visualization display method, electronic equipment and a storage medium, wherein the federal cluster data comprises data of different index dimensions of a plurality of databases, and the method comprises the following steps: acquiring at least one attribute information of a page and at least one chart to be rendered of the page; wherein, the chart dynamically associates the corresponding chart configuration template and the data source; the chart configuration template corresponds to the index dimension; converting at least one attribute information according to the chart configuration template to obtain a query condition corresponding to at least one chart; sending the query conditions and the data source associated with the chart to a server, so that the server generates query statements corresponding to the data source according to the query conditions and returns corresponding query results; and mapping the query result to at least one chart, and rendering and displaying the at least one chart. By dynamically associating the chart configuration template, the data request is separated from the chart rendering, and the chart is compatible with different data displays.
Description
Technical Field
The invention relates to the field of clusters, in particular to a federal cluster data visualization display method, electronic equipment and a storage medium.
Background
Different services can be deployed on the server, and the services depend on a plurality of different databases of the back end, such as mysql, redis, mongdb and the like. The different types of databases constitute a federated clustered database. Different databases are maintained by different database administrators, and service deployment, management and the like are maintained by different business parties, so that the whole operating environment needs to be associated with a plurality of different departments, different personnel roles and the like. Different departments have different attention points, and the requirements of the departments correspond to a plurality of different data index dimensions, such as resource occupancy rates of services based on different databases, execution response time of different services and the like, so that the generated data are scattered. Different data cannot be displayed compatibly for a data visualization engine, and the data display of multiple different index dimensions also cannot be displayed by using a chart.
Disclosure of Invention
In view of the above, the present invention is proposed to provide a federated cluster data visualization display method, an electronic device and a storage medium, which overcome or at least partially solve the above problems.
According to one aspect of the invention, a federal cluster data visualization display method is provided, wherein the federal cluster data contains data of different index dimensions of a plurality of databases, and the method comprises the following steps:
acquiring at least one attribute information of a page and at least one chart to be rendered of the page; wherein, the chart dynamically associates a corresponding chart configuration template and a data source; the chart configuration template corresponds to the index dimension;
converting the at least one attribute information according to the chart configuration template to obtain a query condition corresponding to the at least one chart;
sending the query condition and the data source associated with the chart to a server, so that the server generates a query statement corresponding to the data source according to the query condition and returns a corresponding query result;
and mapping the query result to the at least one chart, and rendering and displaying the at least one chart.
According to another aspect of the present invention, there is provided an electronic apparatus including: the processor, the memory and the communication interface complete mutual communication through the communication bus;
the memory is used for storing at least one executable instruction, and the executable instruction causes the processor to execute the following operations:
acquiring at least one attribute information of a page and at least one chart to be rendered of the page; wherein, the chart dynamically associates a corresponding chart configuration template and a data source; the chart configuration template corresponds to the index dimension; the federal cluster data comprise data of different index dimensions of a plurality of databases;
converting the at least one attribute information according to the chart configuration template to obtain a query condition corresponding to the at least one chart;
sending the query condition and the data source associated with the chart to a server, so that the server generates a query statement corresponding to the data source according to the query condition and returns a corresponding query result;
and mapping the query result to the at least one chart, and rendering and displaying the at least one chart.
According to another aspect of the present invention, a computer storage medium is provided, where at least one executable instruction is stored in the storage medium, and the executable instruction causes a processor to execute an operation corresponding to any one of the federal cluster data visualization display methods.
According to the federal cluster data visualization display method, the electronic device and the storage medium provided by the invention, the chart of the page is dynamically associated with the chart configuration template and the data source, so that the data request of the page is separated from the chart rendering, and the chart can compatibly display the index dimensions of different data aiming at different index dimensions of different federal cluster data, thereby realizing data visualization.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
FIG. 1 is a flow chart diagram illustrating a federated cluster data visualization display method according to an embodiment of the present invention;
FIG. 2 is a flow chart of a federated cluster data visualization display method according to another embodiment of the present invention;
fig. 3 shows a schematic structural diagram of an electronic device according to an embodiment of the invention.
Detailed Description
Example one
Fig. 1 is a schematic flow chart of a federated cluster data visualization display method according to an embodiment of the present invention, and as shown in fig. 1, the method includes the following steps:
step S101, at least one attribute information of a page and at least one chart to be rendered of the page are obtained.
The embodiment is implemented on a client side, a data visualization engine is configured on the client side, the federated cluster includes different types of databases, and services of different businesses store data corresponding to respective required databases, so that the federated cluster data includes data of different index dimensions of a plurality of databases. The federated cluster data is processed and stored in one or more data sources, but the data contained in different cluster data is different, for example, different types of databases such as mysql, redis, mongdb and the like are contained in the federated cluster, the data generated by different services are stored in different databases in the federated cluster, the generated data are different due to services, the data stored in the databases are different, and the data are diversified. In the prior art, when chart data is displayed in a page, a chart is often fixed in the page, and data items displayed in the chart are also fixed, so that a data visualization engine cannot compatibly display different data stored in different databases of a federated cluster.
In this embodiment, when data is displayed on a page, a graph in the page is dynamically associated with a corresponding graph configuration template and a corresponding data source, a page data request is separated from graph rendering, and data display is implemented in a non-fixed code manner, so that the graph can be associated with different graph configuration templates and compatibly display data with different index dimensions. According to the display requirements, the chart is dynamically associated with different chart configuration templates, the chart can display various data, and the display requirements of the federal cluster data are met. The chart can dynamically associate the data source, show the data acquired by the associated data source and facilitate the change of the data source to show different data. The data source may be any of various databases, and is not limited herein.
Specifically, the graphs may include different graphs such as a pie chart, a bar chart, a line chart, and the like, and different graph configuration templates, data sources, and the like may be dynamically associated with the picture, where the graph configuration templates correspond to index dimensions of the data, and different graph configuration templates may correspondingly display data of different index dimensions.
The page includes at least one attribute information, such as attribute information of a service name, a machine room to which the service belongs, an ip address, a port, a query data segment, and the like, and specific data displayed by the graph needs to be screened according to the attribute information. When a user (users of different departments, such as operation and maintenance users, data administrators, business department users and the like) inputs attribute information on a page according to requirements to perform data query, a corresponding query request is sent, and a data visualization engine receives the query request, acquires at least one attribute information of the page and at least one chart to be rendered contained in the page from the query request, and performs data query.
And step S102, converting at least one attribute information according to the chart configuration template to obtain a query condition corresponding to at least one chart.
The attribute information of the page is selected or input by a user, the chart configuration template comprises index dimension data to be displayed by the chart, and the attribute information, the index dimension data of the chart configuration template and the like are query limit information of the page chart display data. And configuring index dimension data of the template according to the graphs, converting the attribute information, and determining query fields and the like corresponding to the attribute information and the data source so as to obtain query conditions corresponding to at least one graph, such as data with a service name XX, a service machine room XX and an index dimension XX, queried from the data source.
And step S103, sending the query condition and the data source associated with the chart to a server so that the server can generate a query statement corresponding to the data source according to the query condition and return a corresponding query result.
And sending the query conditions obtained by conversion processing and the data source associated with the chart to a server, analyzing the query conditions by the server, generating query statements suitable for the data source according to the data source, executing the query statements, and obtaining and returning corresponding query results. Specifically, if the query condition includes a service name X1, a service room X2, an index dimension is a resource occupancy rate, and the resource occupancy rate corresponds to aa, bb, cc fields of a data table in the database, which respectively represent, for example, a memory, a cpu, a bandwidth, and the like. Combining the above query conditions with a data source, such as a database, to generate a query statement applicable to the database, selectaa, bb, ccfromthable 1 where X1 and dseverrom X2. The above query statement is executed in the database to obtain a query result containing data of the corresponding fields aa, bb, cc. And the server returns the query result obtained by the query to the client so as to be mapped to the chart for displaying.
And step S104, mapping the query result to at least one chart, and rendering and displaying the at least one chart.
And mapping each field data in the query result to a corresponding chart, filling the chart data, finishing chart rendering, and displaying the rendered chart. According to the method and the device, the data request is separated from the chart rendering, the whole process from the data request to the chart rendering is completed without using a solidified code, scattered data with different index dimensions are gathered together and displayed in the chart, and the chart dynamically displays different data.
During mapping, data items to be displayed, such as data of a memory, a cpu, a bandwidth and the like, are determined according to a chart configuration template of the chart, and data of fields aa, bb and cc contained in the query result are mapped to the data items of the chart one by one to complete rendering of the chart.
According to the visual display method of the federal cluster data, the chart of the page is dynamically associated with the chart configuration template and the data source, so that the data request of the page is separated from the chart rendering, and the chart can compatibly display the index dimensions of different data aiming at different index dimensions of different federal cluster data, thereby realizing data visualization.
Example two
Fig. 2 is a flowchart illustrating a federated cluster data visualization display method according to another embodiment of the present invention, and as shown in fig. 2, the method includes the following steps:
step S201, pre-configuring the diagram to be loaded in the container in the page, and dynamically associating the diagram with a corresponding diagram configuration template and data source.
Before the page utilizes the chart to display data, the chart to be loaded in the page can be configured in advance, for example, a display pie chart in a certain area of the page, a display histogram in a certain area, and the like are set. The chart is loaded to the page in a container mode, different charts correspond to different components, and the chart corresponding to the components is loaded to the page by changing the components in the container. The page can contain one chart to be rendered or a plurality of charts to be rendered, and the data of the plurality of charts can be displayed simultaneously.
When the diagram is configured, the corresponding diagram configuration template and the data source are also needed to be dynamically associated with the corresponding diagram. The data sources of different graphs may be the same or different, that is, in this embodiment, one page may include multiple graphs, each graph may show data acquired from different data sources, and the data of different data sources are shown in the same page, so that the scattered data is conveniently shown in a converged manner, regularity among the data is more conveniently found, and an association relationship among the data is known.
Furthermore, the chart configuration template is dynamically associated with the chart, the chart configuration template can be multiplexed and dynamically associated with different charts, and can also be dynamically associated with charts of different pages, so that the reusability of the chart configuration template is improved; at the same time, the page configuration diagram is made more efficient.
Step S202, at least one attribute information of the page and at least one chart to be rendered of the page are obtained.
The page can comprise a plurality of graphs to be rendered, at least one attribute information is attribute information shared by the plurality of graphs, and each graph searches data based on the attribute information and respectively displays the respective data. If the page includes chart 1, chart 2, and chart 3, the attribute information of the page is common attribute information of chart 1, chart 2, and chart 3. The chart 1, the chart 2 and the chart 3 are inquired based on the common attribute information, so that the data displayed in the chart 1, the chart 2 and the chart 3 are all data related to the common attribute, a user can conveniently check the association among the data related to the common attribute, the federal cluster data are collected, and the multiple chart display data are convenient for the user to check and know the regularity among the scattered federal cluster data from the data display of the multiple charts.
Step S203, according to the chart configuration template of the chart, analyzing to obtain the corresponding relation between at least one attribute information and each data in the data source.
And step S204, converting the at least one attribute information according to the corresponding relationship to obtain a query condition corresponding to the at least one chart.
In this case, the attribute information needs to be analyzed from the service dimension according to the index dimension data included in the chart configuration template to obtain the corresponding relationship between the attribute information and each data in the data source. The corresponding relationship between the attribute information and each data in the data source includes, for example, a one-to-one relationship, a one-to-many relationship, a many-to-one relationship, a correspondence determined by calculation processing, and the like, and at least one attribute information needs to be converted according to a specific corresponding relationship. Specifically, when the data is in a one-to-one relationship, the attribute information is directly converted into each data field in the corresponding data source; when the one-to-many relationship exists, the attribute information is split, and each split information is converted into each data field in the corresponding data source; when the data source is in a many-to-one relation, combining a plurality of attribute information and converting the attribute information into data fields in the corresponding data source; when the corresponding relationship is determined through calculation processing, calculation needs to be performed according to specific implementation conditions, and the calculated attribute information is converted into each data field in the corresponding data source. Meanwhile, generating query conditions according to the index dimensions contained in the chart configuration template. The query conditions limit the data query according to the attribute information and index dimension of the page. If the attribute information of the page contains a certain service name and a time period, the index dimension of the chart configuration template is the resource occupancy rate, and the query condition is to query the resource occupancy data of a certain service in a certain time period. For example, the chart configuration template is specifically set according to the implementation situation, and the chart configuration template is parsed by using, for example, the grammar corresponding to the template, so as to complete the conversion processing on the attribute information, and obtain the query condition corresponding to the chart.
And when the page contains a plurality of charts to be rendered, respectively configuring a template based on the charts of each chart according to the common attribute information, and converting to obtain the query conditions of each chart.
Step S205, sending the query conditions and the data sources associated with the graphs to the server, so that the server can analyze the query conditions of the graphs, respectively generate query statements for the corresponding data sources to perform a query, and return query results corresponding to the graphs obtained by the query.
And sending the obtained query conditions and the data sources associated with the graphs to a server, analyzing the query statements and the data sources by the server, respectively generating corresponding query statements according to the data sources of different graphs, wherein the query statements comprise query conditions, query fields, query tables and the like, and combining the query statements with the query conditions to obtain the query statements. And executing the query sentences to obtain and return query results of the query sentences, wherein the query results correspond to the graphs respectively.
And step S206, mapping the query result according to the output template of each chart to obtain the data item information to be displayed corresponding to the chart.
And step S207, rendering and displaying at least one chart according to the data item information to be displayed.
And if the data of the query result correspond to the data items to be displayed in the chart one by one, directly mapping the data of the query result to the data items of the chart, and finishing the rendering display of the chart. If the data in the query result cannot be directly mapped to the data items of the graph, the graph is also configured with an output template, and the query result is mapped according to the output template, for example, the data in the query result is mapped, including various processes such as splitting, merging, calculation and conversion, so that a mapping relation is established between the data and the data items to be displayed corresponding to the graph, and the data item information to be displayed corresponding to the graph is obtained, so that at least one graph is rendered and displayed according to the data item information to be displayed. The mapping processing is set by the output template according to the service condition, the output template is dynamically associated with the chart, the mapping processing is carried out on the query result, and the query result is mapped through various processing such as splitting processing, merging processing, calculation conversion and the like to obtain the data item information to be displayed corresponding to the specific chart. The output template is set according to the specific implementation, and is not limited herein.
The chart can be dynamically configured into a container of the page to be loaded, the chart configuration template, the output template, the data source and the chart are dynamically associated, the page can display different charts conveniently according to requirements, query requirements of different users can be met quickly, a large number of codes do not need to be written for implementation, the method is more convenient and quicker, labor cost required by code writing is reduced, and the technical threshold of query display is lowered.
In an alternative embodiment, the federated cluster data is federated cluster time sequence data, and the data source is a time sequence database, and the stored time sequence data includes federated cluster data composed of different databases such as redis database, mysql database, mongdb database, etc. The time sequence data is obtained by converting and extracting data in the federal cluster, the data types, fields and the like of the federal cluster database are stored according to respective service settings, the problems of inconsistency and the like exist, and the page attributes are converted through the chart configuration template, so that the chart can be displayed aiming at different types of data, and the problem that the data is scattered and cannot be visualized is solved. Furthermore, the federated cluster data can also contain other types of data besides the time sequence data, the data source can also be other databases, and the generated query statement can meet the query statement specification of the data source only by dynamically associating the chart configuration template and the data source of the chart, so that the federated cluster data visualization display method is suitable for various databases and solves the problem of the federated cluster data visualization display.
According to the visual display method of the federal cluster data, the chart to be loaded is configured in advance on the page, the chart is dynamically associated with the chart configuration template and the data source, and the query requirements of different users can be conveniently and quickly met. The output module can solve the problem that different data in the query result cannot be used for directly rendering the chart, and maps each data in the query result to each data item of the chart to complete chart rendering, so that visualization of the federal cluster data is realized.
EXAMPLE III
The third embodiment of the present application provides a non-volatile computer storage medium, where the computer storage medium stores at least one executable instruction, and the computer executable instruction may execute the federated cluster data visualization display method in any method embodiment described above.
The executable instructions may be specifically configured to cause the processor to: acquiring at least one attribute information of a page and at least one chart to be rendered of the page; wherein, the chart dynamically associates the corresponding chart configuration template and the data source; the chart configuration template corresponds to the index dimension; the federal cluster data comprise data of different index dimensions of a plurality of databases; converting at least one attribute information according to the chart configuration template to obtain a query condition corresponding to at least one chart; sending the query conditions and the data source associated with the chart to a server, so that the server generates query statements corresponding to the data source according to the query conditions and returns corresponding query results; and mapping the query result to at least one chart, and rendering and displaying the at least one chart.
In an alternative embodiment, a page contains a plurality of charts to be rendered; at least one attribute information is attribute information shared by a plurality of charts; the multiple graphs correspond to different data sources, and the multiple graphs are respectively used for displaying different index dimension data.
In an alternative embodiment, the executable instructions further cause the processor to: according to a chart configuration template of the chart, analyzing to obtain a corresponding relation between at least one attribute information and each data in the data source; and converting the at least one attribute information according to the corresponding relationship to obtain a query condition corresponding to the at least one chart.
In an alternative embodiment, the executable instructions further cause the processor to: mapping the query result according to the output template of each chart to obtain the data item information to be displayed corresponding to the chart; and rendering and displaying at least one chart according to the data item information to be displayed.
In an alternative embodiment, the executable instructions further cause the processor to: and sending the query conditions and the data sources associated with the charts to a server so that the server can analyze the query conditions of the charts, respectively generate query statements for the corresponding data sources to query, and return query results corresponding to the charts obtained by the query.
In an alternative embodiment, the charts are loaded to the pages in a container.
In an alternative embodiment, the executable instructions further cause the processor to: the method comprises the steps of pre-configuring graphs to be loaded in a container in a page, and dynamically associating corresponding graph configuration templates and data sources for the graphs.
Example four
Fig. 3 is a schematic structural diagram of an electronic device according to a fourth embodiment of the present invention, and the specific embodiment of the present invention does not limit the specific implementation of the electronic device.
As shown in fig. 3, the electronic device may include: a processor (processor)302, a communication Interface 304, a memory 306, and a communication bus 308.
Wherein:
the processor 302, communication interface 304, and memory 306 communicate with each other via a communication bus 308.
A communication interface 304 for communicating with network elements of other devices, such as clients or other servers.
The processor 302 is configured to execute the program 310, and may specifically execute relevant steps in the above federated cluster data visualization display method embodiment.
In particular, program 310 may include program code comprising computer operating instructions.
The processor 302 may be a central processing unit CPU, or an Application Specific Integrated Circuit (ASIC), or one or more Integrated circuits configured to implement an embodiment of the present invention. The server comprises one or more processors, which can be the same type of processor, such as one or more CPUs; or may be different types of processors such as one or more CPUs and one or more ASICs.
And a memory 306 for storing a program 310. Memory 306 may comprise high-speed RAM memory and may also include non-volatile memory (non-volatile memory), such as at least one disk memory.
The program 310 may specifically be configured to cause the processor 302 to perform the following operations: acquiring at least one attribute information of a page and at least one chart to be rendered of the page; wherein, the chart dynamically associates the corresponding chart configuration template and the data source; the chart configuration template corresponds to the index dimension; the federal cluster data comprise data of different index dimensions of a plurality of databases; converting at least one attribute information according to the chart configuration template to obtain a query condition corresponding to at least one chart; sending the query conditions and the data source associated with the chart to a server, so that the server generates query statements corresponding to the data source according to the query conditions and returns corresponding query results; and mapping the query result to at least one chart, and rendering and displaying the at least one chart.
In an alternative embodiment, a page contains a plurality of charts to be rendered; at least one attribute information is attribute information shared by a plurality of charts; the multiple graphs correspond to different data sources, and the multiple graphs are respectively used for displaying different index dimension data.
In an alternative embodiment, the program 310 is configured to enable the processor 302 to obtain a corresponding relationship between at least one attribute information and each data in the data source by parsing according to a diagram configuration template of the diagram; and converting the at least one attribute information according to the corresponding relationship to obtain a query condition corresponding to the at least one chart.
In an optional implementation manner, the program 310 is configured to enable the processor 302 to perform mapping processing on the query result according to an output template of each graph, so as to obtain data item information to be displayed corresponding to the graph; and rendering and displaying at least one chart according to the data item information to be displayed.
In an optional implementation manner, the program 310 is configured to enable the processor 302 to send the query condition and the data source associated with each graph to the server, so that the server analyzes the query condition of each graph, generates a query statement for the corresponding data source to perform query, and returns a query result corresponding to each graph obtained by the query.
In an alternative embodiment, the charts are loaded to the pages in a container.
In an alternative embodiment, program 310 is configured to cause processor 302 to pre-configure a chart to be loaded from a container in a page and dynamically associate a corresponding chart configuration template and data source for the chart.
For specific implementation of each step in the program 310, reference may be made to the corresponding description in the corresponding step in the above federal visualization display embodiment of cluster data, which is not described herein again. It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described devices and modules may refer to the corresponding process descriptions in the foregoing method embodiments, and are not described herein again.
According to the scheme provided by the embodiment, the chart of the page is dynamically associated with the chart configuration template and the data source, so that the data request of the page is separated from the chart rendering, and the chart can compatibly display the index dimensions of different data aiming at different index dimensions of different federal cluster data, thereby realizing data visualization.
In the description provided herein, numerous specific details are set forth. It is understood, however, that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.
Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be interpreted as reflecting an intention that: that the invention as claimed requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.
Those skilled in the art will appreciate that the modules in the device in an embodiment may be adaptively changed and disposed in one or more devices different from the embodiment. The modules or units or components of the embodiments may be combined into one module or unit or component, and furthermore they may be divided into a plurality of sub-modules or sub-units or sub-components. All of the features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or elements of any method or apparatus so disclosed, may be combined in any combination, except combinations where at least some of such features and/or processes or elements are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.
Furthermore, those skilled in the art will appreciate that while some embodiments described herein include some features included in other embodiments, rather than other features, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the claims, any of the claimed embodiments may be used in any combination.
It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. The usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names.
The invention discloses: A1. a federal cluster data visualization display method comprises data of different index dimensions of a plurality of databases, and comprises the following steps:
acquiring at least one attribute information of a page and at least one chart to be rendered of the page; wherein, the chart dynamically associates a corresponding chart configuration template and a data source; the chart configuration template corresponds to the index dimension;
converting the at least one attribute information according to the chart configuration template to obtain a query condition corresponding to the at least one chart;
sending the query condition and the data source associated with the chart to a server, so that the server generates a query statement corresponding to the data source according to the query condition and returns a corresponding query result;
and mapping the query result to the at least one chart, and rendering and displaying the at least one chart.
A2. The method of A1, wherein the page contains a plurality of charts to be rendered; the at least one attribute information is attribute information shared by a plurality of charts; the multiple graphs correspond to different data sources, and the multiple graphs are respectively used for displaying different index dimension data.
A3. The method according to a1 or a2, wherein the converting the at least one attribute information according to the chart configuration template to obtain the query condition corresponding to the at least one chart includes:
analyzing to obtain the corresponding relation between the at least one attribute information and each data in the data source according to the chart configuration template of the chart;
and converting at least one attribute information according to the corresponding relation to obtain a query condition corresponding to the at least one chart.
A4. The method of A1 or A2, wherein the mapping the query results to the at least one chart, rendering the presentation of the at least one chart further comprises:
mapping the query result according to the output template of each chart to obtain data item information to be displayed corresponding to the chart;
and rendering and displaying the at least one chart according to the data item information to be displayed.
A5. The method according to a2, wherein the sending the query condition and the data source associated with the graph to a server for the server to generate a query statement corresponding to the data source according to the query condition and return a corresponding query result includes:
and sending the query conditions and the data sources associated with the charts to a server so that the server can analyze the query conditions of the charts, respectively generate query statements for the corresponding data sources to query, and return query results corresponding to the charts obtained by the query.
A6. The method of any of A1-A5, wherein the chart is loaded to a page in a container.
A7. The method according to a6, wherein before the obtaining at least one attribute information of a page and at least one chart of the page to be rendered, the method further comprises:
the method comprises the steps of pre-configuring graphs to be loaded in a container in a page, and dynamically associating corresponding graph configuration templates and data sources for the graphs.
The invention also discloses: B8. an electronic device, comprising: the system comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete mutual communication through the communication bus;
the memory is configured to store at least one executable instruction that causes the processor to:
acquiring at least one attribute information of a page and at least one chart to be rendered of the page; wherein, the chart dynamically associates a corresponding chart configuration template and a data source; the chart configuration template corresponds to the index dimension; the federal cluster data comprise data of different index dimensions of a plurality of databases;
converting the at least one attribute information according to the chart configuration template to obtain a query condition corresponding to the at least one chart;
sending the query condition and the data source associated with the chart to a server, so that the server generates a query statement corresponding to the data source according to the query condition and returns a corresponding query result;
and mapping the query result to the at least one chart, and rendering and displaying the at least one chart.
B9. The electronic device of B8, the page including a plurality of charts to be rendered; the at least one attribute information is attribute information shared by a plurality of charts; the multiple graphs correspond to different data sources, and the multiple graphs are respectively used for displaying different index dimension data.
B10. The electronic device of B8 or B9, the executable instructions further cause the processor to:
analyzing to obtain the corresponding relation between the at least one attribute information and each data in the data source according to the chart configuration template of the chart;
and converting at least one attribute information according to the corresponding relation to obtain a query condition corresponding to the at least one chart.
B11. The electronic device of B8 or B9, the executable instructions further cause the processor to:
mapping the query result according to the output template of each chart to obtain data item information to be displayed corresponding to the chart;
and rendering and displaying the at least one chart according to the data item information to be displayed.
B12. The electronic device of B9, the executable instructions further cause the processor to:
and sending the query conditions and the data sources associated with the charts to a server so that the server can analyze the query conditions of the charts, respectively generate query statements for the corresponding data sources to query, and return query results corresponding to the charts obtained by the query.
B13. The electronic device of any of B8-B12, the chart being loaded to a page in a container.
B14. The electronic device of B13, the executable instructions further cause the processor to:
the method comprises the steps of pre-configuring graphs to be loaded in a container in a page, and dynamically associating corresponding graph configuration templates and data sources for the graphs.
The invention also discloses: C15. a computer storage medium having stored therein at least one executable instruction for causing a processor to perform operations corresponding to the method for visually presenting federal cluster data as in any of a1-a 7.
Claims (10)
1. A federal cluster data visualization display method comprises data of different index dimensions of a plurality of databases, and comprises the following steps:
acquiring at least one attribute information of a page and at least one chart to be rendered of the page; wherein, the chart dynamically associates a corresponding chart configuration template and a data source; the chart configuration template corresponds to the index dimension;
converting the at least one attribute information according to the chart configuration template to obtain a query condition corresponding to the at least one chart;
sending the query condition and the data source associated with the chart to a server, so that the server generates a query statement corresponding to the data source according to the query condition and returns a corresponding query result;
and mapping the query result to the at least one chart, and rendering and displaying the at least one chart.
2. The method of claim 1, wherein the page contains a plurality of charts to be rendered; the at least one attribute information is attribute information shared by a plurality of charts; the multiple graphs correspond to different data sources, and the multiple graphs are respectively used for displaying different index dimension data.
3. The method according to claim 1 or 2, wherein the converting the at least one attribute information according to the chart configuration template to obtain the query condition corresponding to the at least one chart comprises:
analyzing to obtain the corresponding relation between the at least one attribute information and each data in the data source according to the chart configuration template of the chart;
and converting at least one attribute information according to the corresponding relation to obtain a query condition corresponding to the at least one chart.
4. The method of claim 1 or 2, wherein the mapping the query results to the at least one graph, the rendering the at least one graph further comprises:
mapping the query result according to the output template of each chart to obtain data item information to be displayed corresponding to the chart;
and rendering and displaying the at least one chart according to the data item information to be displayed.
5. The method of claim 2, wherein the sending the query condition and the data source associated with the graph to a server for the server to generate a query statement corresponding to the data source according to the query condition and return a corresponding query result comprises:
and sending the query conditions and the data sources associated with the charts to a server so that the server can analyze the query conditions of the charts, respectively generate query statements for the corresponding data sources to query, and return query results corresponding to the charts obtained by the query.
6. The method of any of claims 1-5, wherein the chart is loaded to a page in a container.
7. The method of claim 6, wherein before the obtaining at least one attribute information of the page and at least one graph of the page to be rendered, the method further comprises:
the method comprises the steps of pre-configuring graphs to be loaded in a container in a page, and dynamically associating corresponding graph configuration templates and data sources for the graphs.
8. An electronic device, comprising: the system comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete mutual communication through the communication bus;
the memory is configured to store at least one executable instruction that causes the processor to:
acquiring at least one attribute information of a page and at least one chart to be rendered of the page; wherein, the chart dynamically associates a corresponding chart configuration template and a data source; the chart configuration template corresponds to the index dimension; the federal cluster data comprise data of different index dimensions of a plurality of databases;
converting the at least one attribute information according to the chart configuration template to obtain a query condition corresponding to the at least one chart;
sending the query condition and the data source associated with the chart to a server, so that the server generates a query statement corresponding to the data source according to the query condition and returns a corresponding query result;
and mapping the query result to the at least one chart, and rendering and displaying the at least one chart.
9. The electronic device of claim 8, the page including a plurality of charts to be rendered; the at least one attribute information is attribute information shared by a plurality of charts; the multiple graphs correspond to different data sources, and the multiple graphs are respectively used for displaying different index dimension data.
10. A computer storage medium having stored therein at least one executable instruction that causes a processor to perform operations corresponding to the federate clustered data visualization display method as recited in any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110938736.3A CN113641735A (en) | 2021-08-16 | 2021-08-16 | Visual display method of federal cluster data, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110938736.3A CN113641735A (en) | 2021-08-16 | 2021-08-16 | Visual display method of federal cluster data, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113641735A true CN113641735A (en) | 2021-11-12 |
Family
ID=78422131
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110938736.3A Pending CN113641735A (en) | 2021-08-16 | 2021-08-16 | Visual display method of federal cluster data, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113641735A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117520617A (en) * | 2024-01-08 | 2024-02-06 | 慧新全智工业互联科技(青岛)有限公司 | Data information display method based on chart component |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105653678A (en) * | 2015-12-30 | 2016-06-08 | 城云科技（杭州）有限公司 | Data chart subscription method and data chart subscription system |
| CN108874926A (en) * | 2018-05-31 | 2018-11-23 | 康键信息技术（深圳）有限公司 | Mass data inquiry method, device, computer equipment and storage medium |
| CN112182074A (en) * | 2020-09-27 | 2021-01-05 | 中国建设银行股份有限公司 | Data visualization method and device, electronic equipment and readable storage medium |
| CN112861494A (en) * | 2021-02-05 | 2021-05-28 | 青岛海信网络科技股份有限公司 | Road network data-based visual report generation method, equipment and storage medium |
| CN113157779A (en) * | 2020-01-22 | 2021-07-23 | 北京沃东天骏信息技术有限公司 | Data chart generation method and device |
| CN113177171A (en) * | 2021-04-16 | 2021-07-27 | 百果园技术(新加坡)有限公司 | Chart display method and device, terminal device and storage medium |
-
2021
- 2021-08-16 CN CN202110938736.3A patent/CN113641735A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105653678A (en) * | 2015-12-30 | 2016-06-08 | 城云科技（杭州）有限公司 | Data chart subscription method and data chart subscription system |
| CN108874926A (en) * | 2018-05-31 | 2018-11-23 | 康键信息技术（深圳）有限公司 | Mass data inquiry method, device, computer equipment and storage medium |
| CN113157779A (en) * | 2020-01-22 | 2021-07-23 | 北京沃东天骏信息技术有限公司 | Data chart generation method and device |
| CN112182074A (en) * | 2020-09-27 | 2021-01-05 | 中国建设银行股份有限公司 | Data visualization method and device, electronic equipment and readable storage medium |
| CN112861494A (en) * | 2021-02-05 | 2021-05-28 | 青岛海信网络科技股份有限公司 | Road network data-based visual report generation method, equipment and storage medium |
| CN113177171A (en) * | 2021-04-16 | 2021-07-27 | 百果园技术(新加坡)有限公司 | Chart display method and device, terminal device and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117520617A (en) * | 2024-01-08 | 2024-02-06 | 慧新全智工业互联科技(青岛)有限公司 | Data information display method based on chart component |
| CN117520617B (en) * | 2024-01-08 | 2024-04-23 | 慧新全智工业互联科技(青岛)有限公司 | Data information display method based on chart component |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108519967B (en) | Chart visualization method and device, terminal and storage medium | |
| CN107665228B (en) | Associated information query method, terminal and equipment | |
| US9753960B1 (en) | System, method, and computer program for dynamically generating a visual representation of a subset of a graph for display, based on search criteria | |
| US9367289B2 (en) | Method and apparatus for enabling agile development of services in cloud computing and traditional environments | |
| CN112527848B (en) | Report data query method, device and system based on multiple data sources and storage medium | |
| US10185743B2 (en) | Method and system for optimizing reduce-side join operation in a map-reduce framework | |
| CN110990143B (en) | Task processing method, system, electronic device and storage medium | |
| CN109388395A (en) | A kind of instrument board configuration rendering method, system, equipment and storage medium | |
| CN110738038A (en) | Contract text generation method, device, equipment and computer readable storage medium | |
| CN112711512A (en) | Prometheus monitoring method, device and equipment | |
| CN110784377A (en) | Method for uniformly managing cloud monitoring data in multi-cloud environment | |
| US20150317336A1 (en) | Data reconstruction | |
| CN113641735A (en) | Visual display method of federal cluster data, electronic equipment and storage medium | |
| US20110295872A1 (en) | Method for Visualizing Resource Relationships Stored in SQL Tables Within a Mainframe Environment | |
| US11204925B2 (en) | Enabling data source extensions | |
| CN113722533B (en) | Information pushing method and device, electronic equipment and readable storage medium | |
| CN111858617A (en) | User searching method and device, computer readable storage medium and electronic equipment | |
| EP2830289A1 (en) | Adaptable reporting in a multi-client telecommunication network | |
| US8856152B2 (en) | Apparatus and method for visualizing data | |
| CN115544089A (en) | Data processing method, device, equipment and storage medium | |
| CN114564270A (en) | List component rendering method, list component rendering method, page front-end display method, device, equipment and medium | |
| US20170161359A1 (en) | Pattern-driven data generator | |
| CN103631797A (en) | Operation method and device used for data lists | |
| US9269074B2 (en) | Facilitating viewing of temporal values for multiple fields | |
| CN112597185A (en) | Big data query method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20211112 |