Visual chart configuration device and method for introducing multiple data sources into page, equipment and medium

Abstract

The invention discloses a visual chart configuration device and method for introducing multiple data sources into a page, equipment and a medium. The device comprises a BI data modeling layer, a BI configuration layer, a BI display layer and the like. The method comprises the following steps: firstly, modeling by utilizing a low-code engine, and creating a database table for BI visualization; screening the content of the database table, and determining a data set for display; screening the data set to create a data source; binding a plurality of charts of the display page to the same data source; when the charts are displayed, the multiple bound charts of the display page are updated based on the same data source. According to the method, the configuration steps of the association charts are simplified by introducing the intermediate layer data source, and for modification and maintenance of the data in the display scene and linkage of the data among the charts, the configuration mode of utilizing the data source is efficient and visual, so that data management and display relying on BI visualization are more flexible and convenient.

Description

Technical Field

[0001] The present invention relates to the technical field of visualization chart configuration and use, and in particular to a visualization chart configuration device, method, equipment and medium for introducing multiple data sources into a page. Background Art

[0002] BI visualization is an important part of the Business Intelligence (BI) system. BI visualization makes data more intuitive and easy to understand by using visual elements such as charts, graphs, and maps. It can not only help users discover patterns, trends, and correlations in the data, but also enable users to interact with the data through interactive design to further explore and analyze the data.

[0003] Currently in the field of BI visualization, for situations where a page contains multiple charts, the current standard practice is to bind each chart to specific background data; in this mode, users can select single or multiple data for synchronous filtering during the filtering operation, thereby achieving synchronous control of multiple filter groups by a single filtering component. This approach shows a certain degree of complexity in the configuration link. In particular, when the same data is displayed in a variety of different forms on the page, the amount of configuration and modification work that needs to be performed simultaneously will increase significantly. In addition, if there is any change in the displayed data, the user needs to modify all related charts one by one. This process is not only cumbersome, but also has the risk of omissions.

[0004] The invention application with application number 202311637491.6 discloses a data security design method based on BI visualization. The application scheme effectively solves the security issues and usage restrictions caused by the use of traditional sqlAPI in BI visualization tools, while retaining the convenience and advantages of the traditional sqlAPI online direct SQL statement mode. However, it can be seen from its scheme that the displayed chart data is directly bound to the CDN or server side, which is not conducive to the management and update of related charts. Summary of the invention

[0005] In view of the above-mentioned problems, the purpose of the present invention is to provide a visual chart configuration device, method, equipment and medium for introducing multiple data sources into a page, thereby simplifying the process of modifying the associated chart data and simplifying the associated chart configuration steps.

[0006] The embodiments of the present invention provide a device, method, equipment and medium for configuring a visualization chart for introducing multiple data sources into a page.

[0007] A first aspect: A visual chart configuration device for introducing multiple data sources into a page, comprising:

[0008] BI data modeling layer uses low-code engines for modeling and creating database tables;

[0009] BI configuration layer, used to configure data sets and data sources, and bind multiple related charts to the same data source;

[0010] BI display layer, which displays multiple charts;

[0011] When the contents of multiple related charts are updated, the bound data source is used for updating.

[0012] Optionally, the BI configuration layer includes:

[0013] Dataset configuration layer, select database table content and filter the dataset used to display the page;

[0014] The data source configuration layer selects the data source used for the chart based on the data set and chart display requirements;

[0015] Chart configuration layer, binds multiple charts to the same data source.

[0016] Optionally, the diagram configuration layer includes:

[0017] Filters are used to manage data source data and update multiple related charts in a linked manner.

[0018] Optionally, the charts include: a bar chart, a pie chart, a line chart and a scatter chart.

[0019] A second aspect: A method for configuring a visualization chart based on the device of the first aspect, comprising the steps of:

[0020] SA1. Use the low-code engine to model and create database tables;

[0021] SA2. Select the database table content and determine the data set to be displayed;

[0022] SA3. Create data sources based on data sets and display requirements;

[0023] SA4. Bind multiple charts on the display page to the same data source;

[0024] SA5. Update multiple bound charts on the display page based on the same data source.

[0025] Optionally, another method for configuring a visualization chart based on the device of the first aspect comprises the following steps:

[0026] SB1. Use the low-code engine to model and create database tables;

[0027] SB2. Select the database table content and determine the data set to be displayed;

[0028] SB3. Bind the data set data to a single chart on the display page;

[0029] SB4. Get the data source based on the data of a single chart bound to a data set;

[0030] SB5. Bind multiple charts associated with a single chart based on the acquired data source;

[0031] SB6. Update multiple charts associated with the display page based on the same data source.

[0032] A third aspect: An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the method provided in the second aspect when executing the program.

[0033] A fourth aspect: A non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the method provided in the second aspect.

[0034] Beneficial effects of the present invention:

[0035] 1. By introducing an intermediate layer data source, the present invention provides a convenient way for those scenarios where multiple effects of the same data need to be displayed on the same page, reduces the complexity of large-capacity data processing of data sets, and greatly simplifies the subsequent chart configuration steps.

[0036] 2. The present invention introduces an intermediate data source to modify and maintain the later data in the display scene, as well as the linkage of data between charts. The configuration method of the data source is efficient and intuitive, making data management and display more flexible and convenient.

[0037] 3. By introducing an intermediate layer data source, the present invention can still maintain perfect compatibility with the original configuration and interaction mode for non-specific scenarios, ensure the consistency and smoothness of the overall operation of the system, and avoid adding any unnecessary complexity.

[0038] 4. The data source of the present invention can be obtained in various forms. It can be obtained by screening data sets according to the content of the displayed chart, or it can be directly obtained according to the content of the chart, which has strong applicability. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] Figure 1 It is a structural schematic diagram of a visual chart configuration device of the present invention;

[0040] Figure 2 A schematic diagram of a visualization chart display page of the present invention;

[0041] Figure 3 A schematic diagram of a flow chart of a method for configuring a visualization chart according to the present invention;

[0042] Figure 4 Another schematic diagram of a flow chart of the method for configuring a visualization chart of the present invention;

[0043] Figure 5 It is a schematic diagram of the chart type of the present invention;

[0044] Figure 6 It is a schematic diagram of the configuration of the chart of the present invention;

[0045] Figure 7 It is a schematic diagram of the structure of the electronic device of the present invention. DETAILED DESCRIPTION

[0046] Embodiments of the present invention are described in detail below, examples of which are shown in the accompanying drawings, wherein the same or similar symbols throughout represent the same or similar elements or elements with the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present invention, and cannot be understood as limiting the present invention.

[0047] In the existing BI visualization field, when the same data is displayed on a page using multiple different charts, the need to configure and modify the charts at the same time will increase significantly. If there is any change in the displayed data, the user needs to modify all related charts one by one. This process is not only cumbersome, but also has the risk of omissions.

[0048] In view of the above problems, the present invention provides a method for configuring a visual chart for introducing multiple data sources into a page. Figure 1 A structural diagram of a visual chart configuration device for introducing multiple data sources into a page provided in an embodiment of the present invention, the device includes: a BI data modeling layer, a BI configuration layer, and a BI configuration layer, etc.

[0049] Among them, the BI data modeling layer uses a low-code engine for modeling to create database tables. The database tables include fields and data. The amount of data in the database tables is huge, usually including data from multiple years and regions.

[0050] The BI configuration layer can be implemented using the BI configuration page, and mainly consists of the dataset configuration layer, data source configuration layer, chart configuration layer, and filtering components.

[0051] The data set configuration layer filters the data sets for display in the entire database table according to the subject content to be displayed on the display page. For example, data sets can be formed according to regional differences, such as the power purchase and sales data set in XX area, or they can be formed according to time periods, such as the power purchase and sales data set in XX year. The filtered data sets still have a large amount of data, and the data content involves multiple aspects of the display theme. When the display data changes and the display content needs to be adjusted, it is often difficult to achieve quick adjustments using data sets, and the content displayed in the associated charts needs to be adjusted manually. This process is not only cumbersome, but also has the risk of omissions.

[0052] like Figure 6 As shown, the data source configuration layer filters and forms the data source within the data set of this display theme according to the content of the chart to be displayed on the display page. The data source is generated for the content of the specific chart, and the data volume is small. It can be easily managed and adjusted using filters.

[0053] like Figure 5 As shown, chart styles include: bar chart, pie chart, line chart and scatter chart, etc.

[0054] For example, in a regional display theme, it is necessary to display a chart of the electricity sales situation of a power station. According to the needs of the display chart, the filter component can be used to filter out the relevant data on the electricity sales situation of a power station in the regional data set to form a data source.

[0055] The chart configuration layer binds multiple charts to the same data source. For example, in a regional display theme, it is necessary to display the electricity sales of a power station in a synchronized bar chart and pie chart. In the BI configuration page, the same data source can be bound to the bar chart and pie chart to form an associated chart. The data source can be managed using filters, thereby achieving joint management of the associated charts of the bar chart and pie chart.

[0056] The BI display layer is implemented using display pages and is used to display multiple charts; for example, the overall display of the power purchase and sales situation in a certain area is displayed through the display page. When a bar chart and a pie chart are needed to display the power sales situation of a certain power station, the bar chart and the pie chart are bound to the same data source. When the power sales situation data of a certain power station needs to be adjusted, the data source is managed through the filter, the data source data value is updated, and the linkage update of multiple related charts is realized, so that the bar chart and pie chart content bound to the data source can be updated synchronously.

[0057] Through the introduction of data sources, data sources are targeted at specific charts, have small data volumes, and are easy to adjust and use. Multiple related charts can be uniformly bound to the data source, thereby simplifying the linkage relationship between charts to the linkage between data sources, thereby significantly improving configuration efficiency and providing users with a more stable and efficient data analysis environment.

[0058] like Figure 3 As shown, based on the above-mentioned visualization chart configuration device, the present invention also discloses a configuration method, comprising the steps of:

[0059] SA1. Use the low-code engine to model and create database tables;

[0060] SA2. Select the database table content and determine the data set to be displayed;

[0061] SA3. Create data sources based on data sets and display requirements;

[0062] SA4. Bind multiple charts on the display page to the same data source;

[0063] SA5. Update multiple bound charts on the display page based on the same data source.

[0064] First, modeling is carried out through the low-code engine to create a database table. The database table includes fields and data. Focusing on the theme that needs to be displayed, the data set is filtered according to the database table on the BI configuration page. The data source is introduced according to the chart that needs to be displayed on the BI configuration page. According to the display requirements of the chart, the data set is filtered to obtain the data source corresponding to the chart, and multiple related charts can be bound to the same data source. When the data value displayed in the chart needs to be adjusted, the data source can be managed through the filter and the data source data can be updated. In this way, the linkage of multiple related charts can be realized based on one data source, thereby significantly improving the configuration efficiency and providing users with a more stable and efficient data analysis environment.

[0065] like Figure 4 As shown, based on the above-mentioned visualization chart configuration device, the present invention also discloses a configuration method, comprising the steps of:

[0066] SB1. Use the low-code engine to model and create database tables;

[0067] SB2. Select the database table content and determine the data set to be displayed;

[0068] SB3. Bind the data set data to a single chart on the display page;

[0069] SB4. Get the data source based on the data of a single chart bound to a data set;

[0070] SB5. Bind multiple charts associated with a single chart based on the acquired data source;

[0071] SB6. Update multiple charts associated with the display page based on the same data source.

[0072] The key difference between the above two methods is that the data source is generated in different ways. The second method is to use the database table to filter and obtain the data set. You can first drag a chart, such as a bar chart, to the display page according to the display chart requirements, and bind the bar chart directly to the data of the data set. Then drag the filter to the display page, set the filter to bind the bar chart data, generate a data source, and then the bar chart can be re-bound to the obtained data source; then drag a chart, such as a pie chart, to the display page, and the pie chart is also bound to the obtained data source, so that the bar chart and the pie chart form an associated chart, so that multiple associated charts can be linked based on one data source, thereby significantly improving configuration efficiency and providing users with a more stable and efficient data analysis environment.

[0073] The present invention also provides an electronic device, Figure 7 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention, such as Figure 7 As shown, the electronic device may include: a processor, a communications interface, a memory, and a communications bus, wherein the processor, the communications interface, and the memory communicate with each other via the communications bus. The processor may call the logic instructions in the memory, for example, to execute the following method:

[0074] SA1. Use the low-code engine to model and create database tables;

[0075] SA2. Select the database table content and determine the data set to be displayed;

[0076] SA3. Create data sources based on data sets and display requirements;

[0077] SA4. Bind multiple charts on the display page to the same data source;

[0078] SA5. Update multiple bound charts on the display page based on the same data source.

[0079] In addition, the logic instructions in the above-mentioned memory can be implemented in the form of software functional units and can be stored in a computer-readable storage medium when sold or used as an independent product. Based on such an understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art or the part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including several instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk and other media that can store program codes.

[0080] An embodiment of the present invention further provides a non-transitory computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the method provided in each of the above embodiments is implemented, for example, including:

[0081] SA1. Use the low-code engine to model and create database tables;

[0082] SA2. Select the database table content and determine the data set to be displayed;

[0083] SA3. Create data sources based on data sets and display requirements;

[0084] SA4. Bind multiple charts on the display page to the same data source;

[0085] SA5. Update multiple bound charts on the display page based on the same data source.

[0086] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.

[0087] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0088] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A visual chart configuration device for introducing multiple data sources into a page, characterized in that: include: BI The data modeling layer uses the low-code engine to perform modeling and create database tables; BI configuration layer, used to configure data sets and data sources, and bind multiple related charts to the same data source; BI display layer, which displays multiple charts; When the contents of multiple related charts are updated, the bound data source is used for updating.

2. The visual chart configuration device according to claim 1, characterized in that: The BI configuration layer includes: Dataset configuration layer, select database table content and filter the dataset used to display the page; The data source configuration layer selects the data source used for the chart based on the data set and chart display requirements; Chart configuration layer, binds multiple charts to the same data source.

3. The visual chart configuration device according to claim 2, characterized in that: The configuration layers shown in the diagram include: Filters are used to manage data source data and update multiple related charts in a linked manner.

4. The visual chart configuration device according to claim 1, characterized in that: The charts include: bar charts, pie charts, line charts and scatter charts.

5. A method for configuring a visualization chart based on the device according to any one of claims 1 to 4, characterized in that: Includes steps: SA1. Use the low-code engine to model and create database tables; SA2. Select the database table content and determine the data set to be displayed; SA3. Create data sources based on data sets and display requirements; SA4. Bind multiple charts on the display page to the same data source; SA5. Update multiple bound charts on the display page based on the same data source.

6. A method for configuring a visualization chart based on the device according to any one of claims 1 to 4, characterized in that: Includes steps: SB1. Use the low-code engine to model and create database tables; SB2. Select the database table content and determine the data set to be displayed; SB3. Bind the data set data to a single chart on the display page; SB4. Get the data source based on the data of a single chart bound to a data set; SB5. Bind multiple charts associated with a single chart based on the acquired data source; SB6. Update multiple charts associated with the display page based on the same data source.

7. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, the steps of the visual chart configuration method according to any one of claims 5 or 6 are implemented.

8. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the visual chart configuration method as described in any one of claims 5 or 6 are implemented.

Images