Construction method for chart linkage display

Abstract

The invention belongs to the technical field of data display, and particularly relates to a construction method for chart linkage display. Comprising the following steps: S1, acquiring multi-source type data sources, and retrieving metadata of each data source; s2, performing data correlation analysis on each data source, constructing a data relation graph according to a data correlation analysis result of each data source, and setting a data correlation mode and display attribute information of the data relation graph; s3, creating a sub-window according to display attribute information defined by a user, wherein the sub-window is used for displaying the data node; and S4, realizing linkage display of the data nodes in multiple windows according to user operation. According to the method, the requirement of a user for dynamic data display can be met, and the user experience is good.

Description

Technical Field

[0001] The present invention belongs to the technical field of data display, and in particular relates to a method for constructing a linked display of charts. Background Art

[0002] In the field of data display, realizing data linkage display helps improve data analysis efficiency and simplify operation procedures. At present, client technology usually uses static display to display data, fails to realize chart linkage display, fails to realize information linkage between multiple windows, fails to meet users' needs for dynamic data display, and has a poor user experience. Summary of the invention

[0003] In view of this, the present invention aims to provide a method for constructing a linked display of charts to solve the problem that the prior art cannot realize information linkage between multiple windows, cannot meet the user's demand for dynamic display of data, and has a poor user experience. The present invention can meet the user's demand for dynamic display of data and has a better user experience.

[0004] To achieve the above object, the technical solution created by the present invention is implemented as follows: A method for constructing a graph linkage display specifically includes the following steps: S1: Obtain data sources of multiple types and retrieve metadata of each data source; S2: Perform data correlation analysis on each data source, and build a data relationship map based on the data correlation analysis results of each data source, and set the data correlation mode and display attribute information of the data relationship map; S3: Create a sub-window according to the display attribute information defined by the user, and the sub-window is used to display the data node; S4: Realize linkage display of data nodes in multiple windows according to user operations.

[0005] Furthermore, in step S1, the data source of multiple source types at least includes table files, raster data, vector files, geographic databases, and relational database tables; the data source includes text information and geographic information data.

[0006] Furthermore, in step S1, the metadata includes at least field name, data type, key information, index, constraint, and geographic information constraint.

[0007] Furthermore, in step S2, the specific steps of performing data correlation analysis on each data source are: S21: randomly select two data sources from all data sources. If the metadata of the two data sources contain the same field name, the two data sources have data association, and the data association type of the two data sources is defined as a field relationship. Then, step S24 is executed. Otherwise, step S22 is executed. S22: Based on the pre-trained word vector model, perform vector conversion on each field name of the metadata in the two data sources or the text information of the two data sources, and calculate the cosine similarity of the two converted vectors. If it is greater than 0.8, the two data sources have data association, and the data association type of the current two data sources is defined as a semantic relationship, and execute step S24; otherwise, execute step S23; S23: Based on the GDAL library, the geographic information data of the first data source is converted to the spatial coordinate system of the second data source. If the two data sources have a spatial superposition relationship, it is considered that the two data sources have data association, and the data association type of the current two data sources is defined as a spatial relationship, and step S24 is executed. Otherwise, the current two data sources do not have data association. S24: Replace the two current data sources, and repeat steps S21-S23 until all data sources are traversed.

[0008] Furthermore, an edge is added between two data sources with data association to connect them, and the connection attribute information of the edge is set. The connection attribute information includes the association field and the association data type. The association field is only set on the edge whose association data type is the field relationship. The association data type includes field relationship, semantic relationship and spatial relationship: Field relationships support equality relationships, left join relationships, right join relationships, and outer join relationships; Semantic relations support nearest neighbor relations; Regarding the relationships supported by spatial relationships: if the geographic information data of the two data sources are both point data, the spatial relationship supports equality relationships; if one of the geographic information data of the two data sources is point data and the other is surface data, the spatial relationship supports inclusion relationships; if the geographic information data of the two data sources are both surface data, the spatial relationship supports equality relationships, inclusion relationships, and intersection relationships.

[0009] Furthermore, in step S2, the user sets display attribute information for each data node corresponding to the data source, and the display attribute information at least includes confirmation of whether it is a central data node, visualization type, statistical chart type, chart definition, and data field selection.

[0010] Furthermore, among all the data nodes, there is only one central data node.

[0011] Furthermore, step S3 specifically includes the following steps: S31: based on the display attribute information defined by the user, starting from the central data node, traversing all data nodes according to the breadth-first traversal method; S32: creating a sub-window according to the visualization type configured for each data node; A single data node is configured with at least one visualization type, and a sub-window is created for each visualization type. The sub-window is used to display the data node. S33: establishing an independent window on the graphic window interface, and synchronously rendering the data relationship graph, and dynamically adjusting the visualization type of each data node by clicking in the independent window; S34: Based on the visualization type adjusted in step S33, the data node is displayed on a sub-window corresponding to the visualization type.

[0012] Furthermore, in step S34, the isolated data nodes are independently displayed according to the configured display attribute information.

[0013] Furthermore, in step S4, when the user operates the sub-window where the central data node is located with the mouse, the data relationship map will automatically select the corresponding associated data source according to the data association type in the data relationship map based on the data changes brought about by the user operation, update the data nodes contained in the associated data source for other sub-windows, and synchronously render the data nodes contained in the associated data source according to the visualization type of each sub-window, so as to realize the linked display of data nodes in multiple windows.

[0014] Compared with the prior art, the invention can achieve the following beneficial effects: (1) The present invention creates a method for constructing a linked chart display, which realizes dynamic and effective management of related data sources and collaborative analysis between data sources.

[0015] (2) The method for constructing the linked display of graphs created by the present invention improves the efficiency of data association management and visualization, and enhances the data display experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] The drawings constituting part of the present invention are used to provide a further understanding of the present invention. The exemplary embodiments and descriptions of the present invention are used to explain the present invention and do not constitute an improper limitation on the present invention. In the drawings: Figure 1 A flowchart of a method for constructing a graph linkage display according to an embodiment of the present invention; Figure 2 A diagram showing the linkage effect of a chart as described in an embodiment of the present invention; Figure 3 This is a diagram showing the chart linkage effect after user operation as described in the embodiment of the present invention. DETAILED DESCRIPTION

[0017] In order to make the purpose, technical solution and advantages of the invention more clear, the invention is further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be understood that the specific embodiments described here are only used to explain the invention and do not constitute a limitation of the invention.

[0018] It should be noted that, in the absence of conflict, the embodiments of the present invention and the features in the embodiments may be combined with each other.

[0019] In the description of the present invention, it should be understood that the terms "center", "longitudinal", "lateral", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside", "outside" and the like indicate positions or positional relationships based on the positions or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as a limitation on the present invention. In addition, the terms "first", "second", etc. are only used for descriptive purposes, and cannot be understood as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, features defined as "first", "second", etc. may explicitly or implicitly include one or more of the features. In the description of the present invention, unless otherwise specified, "multiple" means two or more.

[0020] In the description of the invention, it should be noted that, unless otherwise clearly specified and limited, the terms "installation", "connection" and "connection" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium, or it can be the internal communication of two components. For ordinary technicians in this field, the specific meanings of the above terms in the invention can be understood according to specific circumstances.

[0021] The present invention will be described in detail below with reference to the accompanying drawings and in combination with embodiments.

[0022] like Figure 1 As shown, the construction method of the linked display of charts proposed in the present invention specifically includes the following steps: S1: obtaining data sources of multiple source types and retrieving metadata of each data source; S2: performing data correlation analysis on each data source, and constructing a data relationship map according to the data correlation analysis results of each data source, and setting the data correlation mode and display attribute information of the data relationship map; S3: creating a sub-window according to the display attribute information defined by the user, and the sub-window is used to display data nodes; S4: realizing the linked display of data nodes in multiple windows according to user operations.

[0023] In some embodiments, in step S1, the data source of multiple source types includes at least a table file, raster data, a vector file, a geographic database, and a relational database table; the data source includes text information and geographic information data.

[0024] It should be noted that the data types supported by multi-source data sources are not limited to the above data types and are not listed here.

[0025] In some embodiments, in step S1, the metadata includes field name, data type, key information, index, constraint, and geographic information constraint.

[0026] It should be noted that key information includes primary keys and foreign keys. Similarly, metadata is not limited to the above types and will not be listed here.

[0027] In some embodiments, in step S2, the specific steps of performing data correlation analysis on each data source are as follows: S21: arbitrarily select two data sources from all data sources. If the metadata in the two data sources contain the same field name, the two data sources have data correlation, and the data correlation type of the current two data sources is defined as a field relationship, and step S24 is executed; otherwise, step S22 is executed; S22: based on the pre-trained word vector model, each field name of the metadata in the two data sources or the text information of the two data sources is converted into a vector, and the cosine similarity of the two converted vectors is calculated. If it is greater than 0.8, the two vectors are similar. If the data sources have data association, and the data association type of the current two data sources is defined as a semantic relationship, execute step S24; otherwise, execute step S23; S23: Based on the GDAL library, the geographic information data of the first data source is converted to the spatial coordinate system of the second data source. If the two have a spatial overlay relationship, it is considered that the two have data association, and the data association type of the current two data sources is defined as a spatial relationship, and execute step S24; otherwise, the current two data sources do not have data association; S24: Replace the current two data sources, and repeat steps S21-S23 until all data sources are traversed.

[0028] It should be noted that the word vector model is Word2Vec, which is an existing technology.

[0029] In some embodiments, an edge is added between two data sources with data association to connect them, and connection attribute information of the edge is set. The connection attribute information includes an association field and an association data type. The association field is only set on the edge whose association data type is a field relationship. The association data type includes field relationship, semantic relationship, and spatial relationship: Field relationships support equality relationships, left join relationships, right join relationships, and outer join relationships; Semantic relations support nearest neighbor relations; Regarding the relationships supported by spatial relationships: if the geographic information data of the two data sources are both point data, the spatial relationship supports equality relationships; if one of the geographic information data of the two data sources is point data and the other is surface data, the spatial relationship supports inclusion relationships; if the geographic information data of the two data sources are both surface data, the spatial relationship supports equality relationships, inclusion relationships, and intersection relationships.

[0030] It should be noted that field relationships support equality relationships by default, semantic relationships support nearest neighbor relationships by default, and spatial relationships support equality relationships by default. However, if one of the geographic information data of the two data sources is point data and the other is surface data, the spatial relationship supports inclusion relationships by default. In addition, spatial relationships are defined based on whether the geographic information data is point type or surface type and based on topological relationships.

[0031] Furthermore, after completing the reading of metadata, a data relationship map is automatically constructed based on the field meaning (field ancient relationship), text semantics (semantic relationship) and geographic information data. In the data relationship map, multi-source data sources serve as data nodes, and data relationships (specifically including field relationships, semantic relationships and spatial relationships) serve as edges.

[0032] In some embodiments, in step S2, the user sets display attribute information for each data node, and the display attribute information at least includes confirmation of whether it is a central data node, display type, statistical chart type, chart definition, and data field selection.

[0033] In some embodiments, among all the data nodes, there is only one central data node.

[0034] It should be noted that manual relevance editing is performed on the edited data relationship map, including manually removing or adding relevance, associated fields, and associated types. The display attribute information of the data source is set for each data node. The display attribute information includes whether it is a central data node, display type (original data, chart display), statistical chart type, chart definition, data field selection, etc. Multiple display attribute information can be set for the same data node. The central data point can only be set for a data node in the entire data map, and it must be ensured that there is only one central data point in the world.

[0035] In some embodiments, step S3 specifically includes the following steps: S31: based on the display attribute information defined by the user, starting from the central data node, traversing all data nodes according to the breadth-first traversal method; S32: creating a sub-window according to the visualization type configured for each data node; a single data node is configured with no less than one visualization type, and a sub-window is created for each visualization type, which is used to display the data node; S33: establishing an independent window on the graphical window interface, and synchronously rendering the data relationship map, and dynamically adjusting the visualization type of each data node in the independent window by clicking; S34: based on the visualization type adjusted in step S33, displaying the data node on the sub-window corresponding to the visualization type.

[0036] In some embodiments, in step S34, isolated data nodes are independently displayed according to the configured display attribute information.

[0037] It should be noted that the graphical interface is started, and data or charts are displayed in each subwindow according to the display attribute information defined by the user. The process of displaying each subwindow one by one is: starting from the central data node, all data nodes are traversed according to the breadth-first traversal method, and for each data node traversed, a subwindow is created according to the configured display attribute information. Existing isolated nodes can also be displayed independently according to the configured display attribute information. An independent window is established on the graphical window interface, and the data relationship map is rendered synchronously. At the same time, the display type can be dynamically adjusted by clicking.

[0038] In some embodiments, in step S4, when the user operates the sub-window where the central data node is located with the mouse, the data relationship map will automatically select the corresponding associated data source according to the data association type in the data relationship map based on the data changes brought about by the user operation, update the data nodes contained in the associated data source for other sub-windows, and synchronously render the data nodes contained in the associated data source according to the visualization type of each sub-window, so as to realize the linked display of data nodes in multiple windows.

[0039] It should be noted that the user uses the mouse to operate the subwindow where the central data node is located. The operations here include clicking and selecting. During the running of the entire program, as the screen selected data of the subwindow corresponding to the central data node changes (user's active operation), the data of other subwindows are also changing in real time, and always keep data synchronized with the data of the subwindow corresponding to the central data node. Data changes include changes in geographic location and changes in data entries. If the data source is raster data, vector file, or geographic database, the data change is a change in geographic location. If the data source is a table file or a relational database table, the data change is a change in data entry.

[0040] The effect demonstration is carried out using data sources constructed from regional boundary vector data (shp file), optical image (tiff file), night light image (tiff file), real estate economic price data (excel file) and district and county economic data (excel file) as examples. Figure 2 As shown, with the optical image as the central data node, after clicking a random point on the optical image (the red circle in the figure is the click point), other types of data will be displayed in a linked manner. Figure 3 To display the effect of linking and updating interface charts based on the data relationship graph.

[0041] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the disclosure of the present invention can be performed in parallel, sequentially or in different orders, as long as the desired results of the technical solution disclosed in the present invention can be achieved, and this document does not limit this.

[0042] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for constructing a linked display of a chart, characterized in that: The specific steps include: S1: Obtain data sources of multiple types and retrieve metadata of each data source; S2: Perform data correlation analysis on each data source, and build a data relationship map based on the data correlation analysis results of each data source, and set the data correlation mode and display attribute information of the data relationship map; S3: creating a sub-window according to the display attribute information defined by the user, and the sub-window is used to display the data node; S4: Realize linkage display of data nodes in multiple windows according to user operations.

2. The method for constructing a graph linkage display according to claim 1, characterized in that: In step S1, the multi-source data source includes at least a table file, raster data, a vector file, a geographic database, and a relational database table; the data source includes text information and geographic information data.

3. The method for constructing a graph linkage display according to claim 1, characterized in that: In step S1, the metadata includes at least field name, data type, key information, index, constraint, and geographic information constraint.

4. The method for constructing a graph linkage display according to claim 1, characterized in that: In step S2, the specific steps of performing data correlation analysis on each data source are: S21: randomly select two data sources from all data sources. If the metadata of the two data sources contain the same field name, the two data sources have data association, and the data association type of the two data sources is defined as a field relationship. Then, step S24 is executed. Otherwise, step S22 is executed. S22: Based on the pre-trained word vector model, perform vector conversion on each field name of the metadata in the two data sources or the text information of the two data sources, and calculate the cosine similarity of the two converted vectors. If it is greater than 0.8, the two data sources have data association, and the data association type of the current two data sources is defined as a semantic relationship, and execute step S24; otherwise, execute step S23; S23: Based on the GDAL library, the geographic information data of the first data source is converted to the spatial coordinate system of the second data source. If the two data sources have a spatial superposition relationship, it is considered that the two data sources have data association, and the data association type of the current two data sources is defined as a spatial relationship, and step S24 is executed. Otherwise, the current two data sources do not have data association. S24: Replace the two current data sources, and repeat steps S21-S23 until all data sources are traversed.

5. The method for constructing a graph linkage display according to claim 4, characterized in that: Add an edge between two data sources with data association to connect them, and set the connection attribute information of the edge. The connection attribute information includes the association field and the association data type. The association field is only set on the edge whose association data type is the field relationship. The association data type includes field relationship, semantic relationship and spatial relationship: Field relationships support equality relationships, left join relationships, right join relationships, and outer join relationships; Semantic relations support nearest neighbor relations; Regarding the relationships supported by spatial relationships: if the geographic information data of the two data sources are both point data, the spatial relationship supports equality relationships; if one of the geographic information data of the two data sources is point data and the other is surface data, the spatial relationship supports inclusion relationships; if the geographic information data of the two data sources are both surface data, the spatial relationship supports equality relationships, inclusion relationships, and intersection relationships.

6. The method for constructing a graph linkage display according to claim 1, characterized in that: In step S2, the user sets display attribute information for each data node corresponding to a data source, and the display attribute information at least includes confirmation of whether it is a central data node, visualization type, statistical chart type, chart definition, and data field selection.

7. The method for constructing a graph linkage display according to claim 6, characterized in that: Among all data nodes, there is only one central data node.

8. The method for constructing a graph linkage display according to claim 1, characterized in that: Step S3 specifically includes the following steps: S31: based on the display attribute information defined by the user, starting from the central data node, traversing all data nodes according to the breadth-first traversal method; S32: creating a sub-window according to the visualization type configured for each data node; A single data node is configured with at least one visualization type, and a sub-window is created for each visualization type, and the sub-window is used to display the data node; S33: establishing an independent window on the graphic window interface, and synchronously rendering the data relationship graph, and dynamically adjusting the visualization type of each data node by clicking in the independent window; S34: Based on the visualization type adjusted in step S33, the data node is displayed on a sub-window corresponding to the visualization type.

9. The method for constructing a graph linkage display according to claim 1, characterized in that: In step S34, the isolated data nodes are independently displayed according to the configured display attribute information.

10. The method for constructing a graph linkage display according to claim 1, characterized in that: In step S4, when the user operates the sub-window where the central data node is located with the mouse, the data relationship map will automatically select the corresponding associated data source according to the data association type in the data relationship map based on the data changes brought about by the user operation, update the data nodes contained in the associated data source for other sub-windows, and synchronously render the data nodes contained in the associated data source according to the visualization type of each sub-window, so as to realize the linked display of data nodes in multiple windows.

Images