Data display method and device, electronic equipment and storage medium

Abstract

The data display method, device, electronic equipment and storage medium provided by the application comprise the following steps: receiving a first operation instruction; the first operation instruction is an instruction generated by an operation of a user moving an identifier corresponding to a to-be-displayed data table to a view execution area; selecting a pre-created data view from a visual component management page according to field information of the to-be-displayed data table; receiving a second operation instruction; the second operation instruction is an instruction generated by a selection operation on to-be-displayed data in all data contained in the data view; and matching and displaying the to-be-displayed data in a table or a chart to generate a visual component. The data display method, device, electronic equipment and storage medium provided by the application can drag the data to be displayed from the visual component management page, and the required visual component can be generated, without the need to write front-end and back-end codes, so that even personnel who do not know programming can easily realize the visual display of the table, and the problem of standardized and repeated development is solved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computer, and in particular to a data display method and device, electronic equipment and storage medium. BACKGROUND

[0002] In the existing data visualization display process, if a user needs to display a table or a report in a view display area, the user needs to write an interface for displaying the table or the report related data in advance in the backend, and the front end displays the data in different tables or icons according to the interface. If the structure of the table or the report needs to be changed, the source code of the front end and the back end needs to be modified.

[0003] Therefore, the existing data visualization display needs to be customized and developed, requires professional programmers to perform, and has high code repetition, and the entire display process needs to consume a large amount of manpower and material resources.

[0004] Therefore, it is urgent to improve the existing customized data visualization display method to solve the problem of repeated development of customization, so as to meet the use requirements of different personnel. SUMMARY

[0005] The present application provides a data display method, device, electronic equipment and storage medium to solve the defect that the related data of the display chart needs to be customized in the prior art.

[0006] In a first aspect, the present application provides a data display method, comprising: receiving a first operation instruction; the first operation instruction is an instruction generated by the user moving the identifier corresponding to the to-be-displayed data table of the view display area to the view execution area;

[0007] In response to the first operation instruction, a target data view created in advance is determined from a visualization component management page according to the field information of the to-be-displayed data table;

[0008] Receiving a second operation instruction; the second operation instruction is an instruction generated by the user's selection operation on the to-be-displayed data in all metadata contained in the target data view;

[0009]

[0009] In response to the second operation instruction, the to-be-displayed data is matched and displayed in a table or a chart to generate a visualization component.

[0010] According to the data display method provided by the present application, the target data view is stored in a target database, and the target database is constructed based on the following steps:

[0011] Connect the data visualization platform with at least one data source, and obtain the field information of the database table of each data source;

[0012] Based on the field information of each database table, the metadata of each data source is saved to the target database corresponding to the data visualization platform.

[0013] According to a data visualization method provided by the present invention, the step of saving the metadata of each data source to the target database corresponding to the data visualization platform includes:

[0014] The metadata information related to the metadata in each of the data sources is saved to the corresponding field information table in the target database.

[0015] According to a data visualization method provided by the present invention, after saving the metadata of each data source to the target database corresponding to the data visualization platform, the method further includes:

[0016] Based on the data details related to each metadata in each of the data sources, the target data view is determined and created.

[0017] According to a data display method provided by the present invention, after generating the visualization component, it further includes:

[0018] Receive a third operation instruction, which is an instruction generated by the user's selection operation on the visualization component;

[0019] In response to the third operation command, the visualization component is displayed on the report display page and a data report is generated.

[0020] According to a data display method provided by the present invention, the data to be displayed includes dimensional data and indicator data.

[0021] According to a data display method provided by the present invention, the data view includes view information and data details information of the data table to be displayed;

[0022] The view information includes one or more of the following: view name, view creator, view creation time, view associated data source, and tables in the view associated data source.

[0023] Secondly, the present invention also provides a data display device, comprising:

[0024] The first receiving unit is used to receive a first operation instruction; the first operation instruction is an instruction generated by the user to move the identifier corresponding to the data table to be displayed in the view display area to the view execution area.

[0025] The first processing unit is configured to respond to the first operation instruction and determine the pre-created target data view from the visualization component management page based on the field information of the data table to be displayed;

[0026] The second receiving unit is used to receive a second operation instruction; the second operation instruction is an instruction generated by the user's selection operation of the data to be displayed from all the metadata contained in the target data view;

[0027] The second processing unit is used to respond to the second operation instruction to match and display the data to be displayed in a table or chart, and generate a visualization component.

[0028] Thirdly, the present invention provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the steps of any of the data display methods described above.

[0029] Fourthly, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of any of the data display methods described above.

[0030] The data display method, apparatus, electronic device, and storage medium provided by this invention allow users to drag and drop the data to be displayed from the visualization component management page to generate the required visualization components without writing front-end or back-end code. Even those who do not know programming can easily achieve the visualization display of tables, solving the problem of customized and repetitive development. Attached Figure Description

[0031] To more clearly illustrate the technical solutions in this invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of this invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0032] Figure 1 This is one of the flowcharts illustrating the data display method provided by the present invention;

[0033] Figure 2 This is the second flowchart illustrating the data display method provided by the present invention;

[0034] Figure 3 This is a schematic diagram of the data display device provided by the present invention;

[0035] Figure 4 This is a schematic diagram of the structure of the electronic device provided by the present invention. Detailed Implementation

[0036] To make the objectives, technical solutions, and advantages of this invention clearer, the technical solutions of this invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of this invention. All other embodiments obtained by those skilled in the art based on the embodiments of this invention without creative effort are within the scope of protection of this invention.

[0037] It should be noted that in the description of the embodiments of the present invention, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element. The terms "upper," "lower," etc., indicating orientation or positional relationships based on the orientation or positional relationships shown in the accompanying drawings, are only for the convenience of describing the present invention and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation, and therefore should not be construed as a limitation of the present invention. Unless otherwise expressly specified and limited, the terms "installed," "connected," and "linked" should be interpreted broadly, for example, they can refer to a fixed connection, a detachable connection, or an integral connection; they can refer to a mechanical connection or an electrical connection; they can refer to a direct connection or an indirect connection through an intermediate medium; they can refer to the internal communication of two elements. Those skilled in the art can understand the specific meaning of the above terms in this invention according to the specific circumstances.

[0038] The terms "first," "second," etc., used in the specification and claims of this application are used to distinguish similar objects and not to describe a specific order or sequence. It should be understood that such use of data can be interchanged where appropriate so that embodiments of this application can be implemented in orders other than those illustrated or described herein, and the objects distinguished by "first," "second," etc., are generally of the same class and the number of objects is not limited; for example, a first object can be one or more. Furthermore, in the specification and claims, "and / or" indicates at least one of the connected objects, and the character " / " generally indicates that the preceding and following objects are in an "or" relationship.

[0039] The main objective of this invention is to provide a data display method, apparatus, electronic device, and storage medium. Based on these, a multi-data source data visualization platform is developed to solve the problem of repetitive customization required when displaying different visualization reports from the same data source, necessitating the development of multiple corresponding pages.

[0040] The following is combined Figures 1-4 This invention describes the data display method, apparatus, electronic device, and storage medium provided in embodiments of the present invention.

[0041] Figure 1 This is one of the flowcharts illustrating the data display method provided by the present invention, such as... Figure 1 As shown, including but not limited to the following steps:

[0042] Step 101: Receive the first operation instruction.

[0043] The first operation instruction is generated by the user's operation of moving the identifier corresponding to the data table to be displayed in the view display area to the view execution area.

[0044] Having established communication connections between the multi-data source data visualization platform and other relevant data sources, it is possible to obtain data source information recorded in each relevant data source. When a user needs to visualize a data table to be displayed, they first select the identifier corresponding to the data table to be displayed in the view display area of ​​the front-end display interface of the multi-data source data visualization platform using the mouse; then, they drag the mouse to drag the identifier corresponding to the data table to the view execution area of ​​the front-end display interface of the multi-data source data visualization platform.

[0045] The view display area of ​​the front-end interface displays table details related to the data table to be displayed in real time, such as the field information of the data table to be displayed.

[0046] Step 102: In response to the first operation instruction, determine the pre-created target data view from the visualization component management page based on the field information of the data table to be displayed.

[0047] After receiving the user's first operation instruction, the backend server of the multi-source data visualization platform obtains the data details information from the data source table based on the metadata corresponding to the field information of the data table to be displayed. Then, based on the data details information, it selects the target data view corresponding to the field information of the data table to be displayed from among the many data views in the visualization component management page.

[0048] The field information mainly includes the field name, field type, and field length.

[0049] A data view mainly includes view information and table details. The view information mainly includes the view name, view creator, view creation time, data source associated with the view, and tables in the data source associated with the view.

[0050] A data view is a view that allows users to see information about a table in a data source. Data views only store metadata, which is the field information of that table.

[0051] Step 103: Receive the second operation instruction.

[0052] The second operation instruction is generated by the user's selection operation of the data to be displayed from all the metadata contained in the target data view.

[0053] After users query the field information of the data table to be displayed and save it as metadata, they can select the target data view that has been created on the visualization component management page. All the data of the target data view is then displayed on the front-end display interface. Users can select the data to be displayed from all the data in the target data view by entering a second operation command according to the actual display.

[0054] Optionally, the second operation instruction can be an instruction generated by the user using the mouse to select and confirm the data to be displayed.

[0055] Step 104: In response to the second operation instruction, match and display the data to be displayed in a table or chart to generate a visualization component.

[0056] After receiving the second operation instruction, the server backend responds to the second operation instruction by automatically matching a table or chart suitable for displaying the data to be displayed, so as to display the data table in the table or chart and save the table or chart containing the data to be displayed as a visualization component.

[0057] Optionally, the above method of matching a suitable table or chart to the data to be displayed can also be implemented based on manual user operation. If the user calls any table or chart, the server backend determines whether the table or chart called by the user can clearly and completely display the data to be displayed. If it can, the table or chart containing the data to be displayed is saved as a visualization component; if not, the user is prompted to select another table until a table or chart that meets the requirements for displaying the data to be displayed is obtained.

[0058] After the visualization component is generated, users can choose whether to call this visualization component in the report display page according to their display needs.

[0059] The data display method provided by this invention allows users to drag and drop the data they want to display from the visualization component management page to generate the required visualization components without writing front-end or back-end code. Even people who do not know programming can easily achieve the visualization display of tables, solving the problem of customized and repetitive development.

[0060] Based on the above embodiments, as an optional embodiment, the target data view is stored in a target database, which is constructed based on the following steps:

[0061] Establish a connection between the data visualization platform and at least one data source, and obtain the field information of the database tables of each data source;

[0062] Based on the field information of each database table, the metadata of each data source is saved to the target database corresponding to the data visualization platform.

[0063] The data display method provided by this invention supports calling data (including tables) from multiple data sources.

[0064] By pre-establishing data communication connections between the backend server of the data visualization platform and multiple data sources, the code snippet could be:

[0065] Connection conn=DriverManager.getConnection(url,user,password).

[0066] The data contained in the multiple data sources can be data imported from Excel and / or data from a MySQL database.

[0067] The method for obtaining field information of the database tables of each of the data sources, i.e., obtaining the metadata of the database tables of each connected data source, includes:

[0068] PreparedStatement pstmt = conn.prepareStatement("executable script sql");

[0069] ResultSet rs=pstmt.executeQuery();

[0070] ResultSetMetaData rs_metaData=rs.getMetaData();

[0071] String columnName=rs_metaData.getColumnName;

[0072] The code snippet above allows you to obtain the field information (mainly field names) of each data source table in the connected database table.

[0073] Furthermore, after obtaining the metadata of the database tables of each connected data source, the metadata of each database table can be saved to the target database corresponding to the data visualization platform through the MyBatis framework, and summarized and recorded in the field information table.

[0074] The data display method provided by this invention establishes connections with other multiple data sources. Users can execute scripts from a pre-compiled database and, through the following code snippet, directly obtain query results from the target database and encapsulate them into the data format required by the visualization component. This data format typically consists of column names and their corresponding value information:

[0075] PreparedStatement pstmt = conn.prepareStatement("executable script sql");

[0076] ResultSet rs=pstmt.executeQuery().

[0077] It should be noted that after a user creates a connection to any data source (which is the configuration information for connecting to the MySQL database) for the first time, the configuration information of that data source is saved. Subsequent connections to that data source can be directly invoked without having to recreate the connection.

[0078] Furthermore, the present invention can pre-set the data update frequency (e.g., once a day) and update the configuration information of the data source in real time to achieve real-time data refresh.

[0079] The data display method provided by this invention establishes connections with multiple data sources and builds a target database on the server backend to store relevant metadata of each data source, which can be directly called by users when generating visualization components. When users call relevant data from the data sources again, there is no need to recreate the connections with each data source, which provides convenience for users to display multiple data and improves the efficiency of data retrieval.

[0080] Based on the above embodiments, as an optional embodiment, saving the metadata from each data source to the target database corresponding to the data visualization platform includes:

[0081] The metadata information related to the metadata in each of the data sources is saved to the corresponding field information table in the target database.

[0082] The data display method provided by the present invention sets up a target database on a backend server to store metadata related to each data source that has been connected, and saves the corresponding field information table of each set of headers to the target database.

[0083] In this way, based on the field information corresponding to each set of metadata, the corresponding metadata can be extracted by querying the field information table, and then the corresponding data source data can be obtained based on this metadata.

[0084] For example, when a user needs to display a data table, after dragging the identifier of the data table to be displayed to the view execution area through the first operation command, the user can determine the corresponding target data view based on the field information of the data table to be displayed, and then determine the corresponding metadata from the target database based on the target data view, and finally obtain the corresponding table data from the data source.

[0085] The data display method provided by this invention constructs a target database on the server backend to uniformly store the relevant metadata of each data source in a field information table, so that users can directly call it when generating visualization components. This unified data management method provides convenience for users to display multiple data and also saves space.

[0086] Based on the above embodiments, as an optional embodiment, after saving the metadata from each data source to the target database corresponding to the data visualization platform, the method further includes:

[0087] Based on the data details related to each metadata in each of the data sources, the target data view is determined and created.

[0088] Figure 2 This is the second flowchart illustrating the data display method provided by the present invention, as shown below. Figure 2 As shown, the main steps in the entire data display process include:

[0089] 1) Connect to one or more data sources; the data sources can be Excel spreadsheets, relational database management systems (MySQL), etc.

[0090] 2) By connecting to the data source, receive the first operation command from the user when selecting the data table to be displayed in the view display area with the mouse and dragging it to the execution area of ​​the view display area. Display the table details in the front-end data display area and create a data view on the visualization component management page based on the data details information in the data source table.

[0091] 3) Save the field information from the data table as metadata information by querying it. On the visualization component management page, select the data view that has been created, select the relevant target data to be displayed, drag and drop the table or chart to match the data. The data source in the table or chart is the field value of the data source table. Save and generate the visualization component.

[0092] The data source connection only connects to the database. To access a specific chart from the data source, a data view needs to be created. The field information displayed in the visualization component is obtained from the data view. After creating the data view, you can create the visualization component, which consists of configurable chart styles such as pie charts and bar charts.

[0093] The data display method provided by this invention pre-creates a data view corresponding to each data source on the visualization component management page. When displaying a data table, the user only needs to select the corresponding data view based on the field information of the data table to be displayed. The relevant data table to be displayed can then be retrieved based on the data view and displayed on the front-end display interface. Users do not need to write front-end or back-end code. Even people who do not know programming can easily achieve the visualization display of tables, solving the problem of customized and repetitive development.

[0094] Based on the above embodiments, as an optional embodiment, the data display method provided by the present invention further includes, after generating the visualization component:

[0095] Receive a third operation instruction, which is an instruction generated by the user's selection operation on the visualization component;

[0096] In response to the third operation command, the visualization component is displayed on the report display page and a data report is generated.

[0097] Combination Figure 2 As shown, you can select pre-created visualization components and custom graphic modules on the report display page to generate a data report. The data report can include pre-created visualization components, custom text, custom images, custom hyperlinks, etc.

[0098] Custom content refers to template content pre-defined in the persistent database corresponding to the data visualization platform. Users can generate custom text, images, and custom hyperlinks based on the template content.

[0099] The data display method provided by this invention can display visualization components, custom text, custom images, custom hyperlinks, etc. on the front-end display interface by dragging and dropping according to the user's display needs. It can also complete data statistics and automatically generate data reports, enabling users to intuitively and comprehensively grasp the data content and providing users with more convenient and user-friendly services.

[0100] Optionally, the data to be displayed may include dimensional data and indicator data. Indicator data, also known as metric data, includes metrics such as population, GDP, income, number of users, profit margin, and retention rate. Dimensional data refers to data related to a specific characteristic of a thing, such as time, gender, and region. Dimensional data can be further divided into qualitative dimensional data (textual data) and quantitative dimensional data (numerical data).

[0101] Optionally, the data view includes view information and data details of the data table to be displayed;

[0102] The view information includes one or more of the following: view name, view creator, view creation time, view associated data source, and tables in the view associated data source.

[0103] Figure 3 This is a schematic diagram of the data display device provided by the present invention, as shown below. Figure 3 As shown, it mainly includes a first receiving unit 31, a first processing unit 32, a second receiving unit 33, and a second processing unit 34, wherein:

[0104] The first receiving unit 31 is mainly used to receive a first operation instruction; the first operation instruction is an instruction generated by the user moving the identifier corresponding to the data table to be displayed in the view display area to the view execution area;

[0105] The first processing unit 32 is mainly used to respond to the first operation instruction and determine the pre-created target data view from the visualization component management page according to the field information of the data table to be displayed;

[0106] The second receiving unit 33 is mainly used to receive a second operation instruction; the second operation instruction is an instruction generated by the user's selection operation of the data to be displayed from all the data contained in the target data view;

[0107] The second processing unit 34 is mainly used to respond to the second operation instruction, match and display the data to be displayed in a table or chart, and generate a visualization component.

[0108] Specifically, the data display device provided by the present invention serves a multi-data source data visualization platform, and is used to establish communication connections between the multi-data source data visualization platform and other relevant data sources, and to receive and acquire data source information recorded in each relevant data source.

[0109] When a user needs to visualize a data table, they first select the corresponding identifier of the data table in the view display area of ​​the front-end display interface of the multi-data source data visualization platform using the mouse; then, they drag the mouse to drag the identifier of the data table to the view execution area of ​​the front-end display interface of the multi-data source data visualization platform to generate the first operation command.

[0110] The first receiving unit 31 receives the first operation instruction and displays the table details related to the data table to be displayed, such as the field information of the data table to be displayed, in real time in the view display area of ​​the front-end display interface.

[0111] The first processing unit 32, in response to the first operation instruction, determines a pre-created target data view from the visualization component management page based on the field information of the data table to be displayed, and extracts all metadata contained in the target data view from the target database based on the field information.

[0112] After receiving the user's first operation instruction, the backend server of the multi-source data visualization platform obtains the data details information from the data source table based on the metadata corresponding to the field information of the data table to be displayed. Then, based on the data details information, it selects the target data view corresponding to the field information of the data table to be displayed from among the many data views in the visualization component management page.

[0113] Furthermore, the second receiving unit 33 receives a second operation instruction; the second operation instruction is a user's selection operation of the data to be displayed from all the data contained in the target data view.

[0114] After users query the field information of the data table to be displayed and save it as metadata, they can select the target data view that has been created on the visualization component management page. All the data of the target data view is then displayed on the front-end display interface. Users can select the data to be displayed from all the data in the target data view by entering a second operation command according to the actual display.

[0115] Optionally, the second operation instruction can be an instruction generated by the user using the mouse to select and confirm the data to be displayed.

[0116] Furthermore, in response to the second operation instruction, the second processing unit 34 matches and displays the data to be displayed in a table or chart to generate a visualization component.

[0117] After receiving the second operation instruction, the second processing unit 34 responds to the second operation instruction by automatically matching a table or chart suitable for displaying the data to be displayed, so as to display the data table in the table or chart and save the table or chart containing the data to be displayed as a visualization component.

[0118] Optionally, the above method of matching a suitable table or chart to the data to be displayed can also be implemented based on manual user operation. If the user calls any table or chart, the server backend determines whether the table or chart called by the user can clearly and completely display the data to be displayed. If it can, the table or chart containing the data to be displayed is saved as a visualization component; if not, the user is prompted to select another table until a table or chart that meets the requirements for displaying the data to be displayed is obtained.

[0119] After the visualization component is generated, users can choose whether to call this visualization component in the report display page according to their display needs.

[0120] It should be noted that the data display device provided in this embodiment of the invention can execute the data display method described in any of the above embodiments during specific operation, and this embodiment will not elaborate on this.

[0121] The data display device provided by this invention allows users to drag and drop the data they want to display from the visualization component management page to generate the required visualization components without writing front-end or back-end code. Even people who do not know programming can easily achieve the visualization display of tables, solving the problem of customized and repetitive development.

[0122] Figure 4 This is a schematic diagram of the structure of the electronic device provided by the present invention, such as... Figure 4As shown, the electronic device may include: a processor 410, a communication interface 420, a memory 430, and a communication bus 440, wherein the processor 410, the communication interface 420, and the memory 430 communicate with each other through the communication bus 440. The processor 410 can call logical instructions in the memory 430 to execute a data display method, which includes: receiving a first operation instruction; the first operation instruction is an instruction generated by a user moving the identifier corresponding to the data table to be displayed in the view display area to the view execution area; in response to the first operation instruction, determining a pre-created target data view from the visualization component management page according to the field information of the data table to be displayed; receiving a second operation instruction; the second operation instruction is an instruction generated by a user selecting data to be displayed from all metadata contained in the target data view; in response to the second operation instruction, matching and displaying the data to be displayed in a table or chart to generate a visualization component.

[0123] Furthermore, the logical instructions in the aforementioned memory 430 can be implemented as software functional units and, when sold or used as independent products, can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, essentially, or the part that contributes to the prior art, or a part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0124] On the other hand, the present invention also provides a computer program product, the computer program product comprising a computer program stored on a non-transitory computer-readable storage medium, the computer program comprising program instructions, wherein when the program instructions are executed by a computer, the computer is able to execute the data display method provided by the above methods, the method comprising: receiving a first operation instruction; the first operation instruction being an instruction generated by a user moving the identifier corresponding to the data table to be displayed in the view display area to the view execution area; responding to the first operation instruction, determining a pre-created target data view from the visualization component management page according to the field information of the data table to be displayed; receiving a second operation instruction; the second operation instruction being an instruction generated by a user selecting data to be displayed from all metadata contained in the target data view; responding to the second operation instruction, matching and displaying the data to be displayed in a table or chart, thereby generating a visualization component.

[0125] In another aspect, the present invention also provides a non-transitory computer-readable storage medium storing a computer program thereon, which, when executed by a processor, implements the data display method provided in the above embodiments. The method includes: receiving a first operation instruction; the first operation instruction being an instruction generated by a user moving the identifier corresponding to the data table to be displayed in the view display area to the view execution area; responding to the first operation instruction, determining an instruction generated by a pre-created target data view from the visualization component management page based on the field information of the data table to be displayed; receiving a second operation instruction; the second operation instruction being an instruction generated by a user selecting data to be displayed from all metadata contained in the target data view; and responding to the second operation instruction, matching and displaying the data to be displayed in a table or chart to generate a visualization component.

[0126] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0127] Through the above description of the embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus necessary general-purpose hardware platforms, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solutions, in essence or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute the methods described in the various embodiments or some parts of the embodiments.

[0128] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data display method, characterized in that, include: Receive the first operation command; The first operation instruction is generated by the user moving the identifier corresponding to the data table to be displayed in the view display area to the view execution area; In response to the first operation instruction, the target data view that has been pre-created is determined from the visualization component management page based on the field information of the data table to be displayed; Receive a second operation instruction; the second operation instruction is an instruction generated by the user's selection operation of the data to be displayed from all the metadata contained in the target data view; In response to the second operation command, the data to be displayed is matched and displayed in a table or chart to generate a visualization component.

2. The data display method according to claim 1, characterized in that, The target data view is stored in the target database, which is constructed based on the following steps: Establish a connection between the data visualization platform and at least one data source, and obtain the field information of the database tables of each data source; Based on the field information of each database table, the metadata of each data source is saved to the target database corresponding to the data visualization platform.

3. The data display method according to claim 2, characterized in that, Saving the metadata from each of the data sources to the target database corresponding to the data visualization platform includes: The metadata information related to the metadata in each of the data sources is saved to the corresponding field information table in the target database.

4. The data display method according to claim 2, characterized in that, After saving the metadata from each of the data sources to the target database corresponding to the data visualization platform, the process also includes: Based on the data details related to each metadata in each of the data sources, a data view is created on the visualization component management page.

5. The data display method according to claim 1, characterized in that, After generating the visualization components, the following is also included: Receive a third operation instruction, which is an instruction generated by the user's selection operation on the visualization component; In response to the third operation command, the visualization component is displayed on the report display page and a data report is generated.

6. The data display method according to any one of claims 1 to 5, characterized in that, The data to be displayed includes dimensional data and indicator data.

7. The data display method according to any one of claims 1 to 5, characterized in that, The data view includes view information and data details of the data table to be displayed; The view information includes one or more of the following: view name, view creator, view creation time, view associated data source, and tables in the view associated data source.

8. A data display device, characterized in that, include: The first receiving unit is used to receive the first operation command; The first operation instruction is generated by the user moving the identifier corresponding to the data table to be displayed in the view display area to the view execution area; The first processing unit is configured to respond to the first operation instruction and determine the pre-created target data view from the visualization component management page based on the field information of the data table to be displayed; The second receiving unit is used to receive the second operation command; The second operation instruction is generated by the user's selection operation on the data to be displayed from all the metadata contained in the target data view; The second processing unit is used to respond to the second operation instruction to match and display the data to be displayed in a table or chart, and generate a visualization component.

9. 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 computer program, it implements the data display method steps as described in any one of claims 1 to 7.

10. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the steps of the data display method as described in any one of claims 1 to 7.

Images