Construction method of chart linkage display

Abstract

The present invention belongs to the field of data display technology, and in particular relates to a method for constructing a linked chart display. The method comprises: S1: obtaining data sources of multiple types and retrieving metadata for each data source; S2: performing data correlation analysis on each data source, constructing a data relationship map based on the data correlation analysis results for each data source, and setting the data correlation method and display attribute information for the data relationship map; S3: creating a subwindow according to user-defined display attribute information, and the subwindow is used to display data nodes; S4: implementing linked display of data nodes in multiple windows based on user operations. The present invention can meet users' needs for dynamic data display and provide a good user experience.

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 data display field, implementing data linkage can help improve data analysis efficiency and simplify operational processes. Current client technologies typically use static display methods, without implementing linked charts or information linkage between multiple windows. This fails to meet user needs for dynamic data display, resulting in 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 existing technology 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:

[0005] A method for constructing a linked display of charts, specifically comprising the following steps:

[0006] S1: Obtain data sources of multiple types and retrieve metadata of each data source;

[0007] S2: Perform data correlation analysis on each data source, build a data relationship map based on the data correlation analysis results of each data source, and set the data correlation method and display attribute information of the data relationship map;

[0008] S3: Create a sub-window according to the display attribute information defined by the user. The sub-window is used to display the data node.

[0009] S4: Realize the linkage display of data nodes in multiple windows according to user operations.

[0010] Furthermore, 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; and the data source includes text information and geographic information data.

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

[0012] Furthermore, in step S2, the specific steps of performing data correlation analysis on each data source are as follows:

[0013] 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, execute step S24; otherwise, execute step S22.

[0014] 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 data sources have data association, and the current data association type between the two data sources is defined as a semantic relationship, and step S24 is executed; otherwise, step S23 is executed;

[0015] 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 overlay relationship, they are considered to 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.

[0016] S24: Replace the two current data sources and repeat steps S21-S23 until all data sources are traversed.

[0017] 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 where the association data type is a field relationship. The association data type includes field relationship, semantic relationship, and spatial relationship:

[0018] Field relationships support equality relationships, left join relationships, right join relationships, and outer join relationships;

[0019] Semantic relations support nearest neighbor relations;

[0020] 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.

[0021] Furthermore, in step S2, the user sets display attribute information for each data node corresponding to the data source. 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.

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

[0023] Furthermore, step S3 specifically includes the following steps:

[0024] S31: Based on the display attribute information defined by the user, starting from the central data node, traverse all data nodes according to the breadth-first traversal method;

[0025] S32: creating a sub-window according to the visualization type configured for each data node;

[0026] A single data node is configured with at least one visualization type. Each visualization type creates a corresponding sub-window, which is used to display the data node.

[0027] 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;

[0028] S34: Based on the visualization type adjusted in step S33, the data node is displayed on a sub-window corresponding to the visualization type.

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

[0030] 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.

[0031] Compared with the prior art, the present invention can achieve the following beneficial effects:

[0032] (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.

[0033] (2) The present invention creates a method for constructing a linked chart display, which improves the efficiency of data association management and visualization, and enhances the data display experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] The accompanying drawings, which constitute part of the present invention, are intended to provide a further understanding of the present invention. The exemplary embodiments of the present invention and their descriptions are intended to explain the present invention and do not constitute an undue limitation of the present invention. In the accompanying drawings:

[0035] Figure 1 A flowchart of a method for constructing a linked display of charts according to an embodiment of the present invention;

[0036] Figure 2 This is a diagram showing the linkage effect of the charts described in the embodiment of the present invention;

[0037] 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

[0038] In order to make the purpose, technical solutions and advantages of the present invention more clearly understood, the present invention is further described in detail below with reference to the accompanying drawings and specific embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and do not constitute a limitation of the present invention.

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

[0040] 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 orientations or positional relationships based on the orientations 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" and the like are only used for descriptive purposes and cannot be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, features defined as "first", "second" and the like 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.

[0041] In the description of the present invention, it should be noted that, unless otherwise expressly specified or limited, the terms "installed," "connected," and "connected" should be understood in a broad sense. For example, they can refer to fixed connections, detachable connections, or integral connections; they can refer to mechanical connections or electrical connections; they can refer to direct connections or indirect connections through an intermediate medium; and they can refer to internal connections between two components. Those skilled in the art can understand the specific meanings of the above terms in the present invention based on specific circumstances.

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

[0043] like Figure 1 As shown, the method for constructing 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 based on 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.

[0044] In some embodiments, 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.

[0045] 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.

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

[0047] 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.

[0048] 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, convert the geographic information data of the first data source 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, execute step S24; otherwise, the current two data sources do not have data association; S24: replace the current two data sources, repeat steps S21-S23 until all data sources are traversed.

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

[0050] In some embodiments, 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 where the association data type is a field relationship. The association data type includes field relationship, semantic relationship, and spatial relationship:

[0051] Field relationships support equality relationships, left join relationships, right join relationships, and outer join relationships;

[0052] Semantic relations support nearest neighbor relations;

[0053] 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.

[0054] It should be noted that field relationships support equality by default, semantic relationships support nearest neighbor by default, and spatial relationships support equality by default. However, if one of the geographic data sources is point data and the other is polygon data, the spatial relationship supports containment by default. Spatial relationships are defined based on topological relationships, depending on whether the geographic data is point or polygon.

[0055] 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.

[0056] 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.

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

[0058] It should be noted that manual association editing of the edited data relationship graph includes manually removing or adding associations, associated fields, and association types. For each data node, set the data source's display attribute information. Display attribute information includes whether it is a central data node, display type (raw 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 graph, and there must be only one central data point globally.

[0059] 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, traverse all data nodes according to the breadth-first traversal method; S32: create 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: establish an independent window on the graphical window interface, and synchronously render the data relationship graph, and dynamically adjust the visualization type of each data node by clicking in the independent window; S34: based on the visualization type adjusted in step S33, display the data node on the sub-window corresponding to the visualization type.

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

[0061] It should be noted that when the graphical interface is started, 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 as follows: starting from the central data node, all data nodes are traversed according to the breadth-first traversal method. 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 to synchronously render the data relationship map, and the display type can be dynamically adjusted by clicking.

[0062] 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.

[0063] It should be noted that the user uses the mouse to operate the sub-window 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 sub-window corresponding to the central data node changes (user's active operation), the data of other sub-windows also changes in real time, and always keeps data synchronized with the data of the sub-window 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.

[0064] 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 It is a display effect for updating interface charts in linkage based on data relationship graphs.

[0065] It should be understood that the various forms of the processes shown above can be used to reorder, add, or delete steps. For example, the steps described in the present disclosure can be performed in parallel, sequentially, or in a different order, as long as the desired results of the technical solutions disclosed in the present disclosure can be achieved. This is not limited herein.

[0066] The above specific embodiments do not limit the scope of protection of the present invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions may be made based on design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of the present invention are intended to be included within the scope of protection of the present invention.

Claims

1. A method for constructing a linked display of charts, characterized by: 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, build a data relationship map based on the data correlation analysis results of each data source, and set the data correlation method and display attribute information of the data relationship map; In step S2, the specific steps of performing data correlation analysis on each data source are as follows: 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, execute step S24; otherwise, execute step S22. 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 data sources have data association, and the current data association type between the two data sources is defined as a semantic relationship, and step S24 is executed; otherwise, step S23 is executed; 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 overlay relationship, they are considered to 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; Add an edge between two data sources with data association to connect them, and set the edge's connection attribute information. The connection attribute information includes the associated field and associated data type. The associated field is only set on the edge where the associated data type is a field relationship. The associated data type includes field relationships, semantic relationships, and spatial relationships: 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; In step S2, the user sets display attribute information for each data node corresponding to the data source. 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; 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; Step S3 specifically includes the following steps: S31: Based on the display attribute information defined by the user, starting from the central data node, traverse 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, which 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, display the data node on the sub-window corresponding to the visualization type; S4: Realize the linkage display of data nodes in multiple windows according to user operations; 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.

2. The method for constructing a linked chart 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 linked chart 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 linked chart display according to claim 1, characterized in that: Among all data nodes, there is only one central data node.

5. The method for constructing a linked chart 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.

Images