CN114416736A

CN114416736A - Method, device, equipment, medium and product for mapping data association relation

Info

Publication number: CN114416736A
Application number: CN202111670908.XA
Authority: CN
Inventors: 贾天奇
Original assignee: Beijing Baidu Netcom Science and Technology Co Ltd
Current assignee: Beijing Baidu Netcom Science and Technology Co Ltd
Priority date: 2021-12-31
Filing date: 2021-12-31
Publication date: 2022-04-29

Abstract

The present disclosure provides a method, an apparatus, a device, a medium, and a product for mapping data association, which relate to the field of computer technologies, and in particular, to the field of computer vision and user interface display. The specific implementation scheme is as follows: determining a first data set and a second data set displayed on a page, wherein the first data set comprises one or more first data, the second data set comprises one or more second data, and the first data and the second data have a mapping relation; analyzing the first data set and the second data set to obtain one or more data combinations, wherein each data combination comprises first data and second data with a mapping relation; for each data combination of the one or more data combinations, a visual relationship between the first data and the second data is established. According to the method and the device, one or more data combinations with mapping relations are obtained by analyzing the first data set and the second data set, and the loading speed of the displayed visual relation page is increased.

Description

Method, device, equipment, medium and product for mapping data association relation

Technical Field

The present disclosure relates to the field of computer technology, and more particularly, to the field of computer vision and user interface display.

Background

There are one-to-one, one-to-many, many-to-one, and many-to-many associations between database tables. In some scenarios, in order to visually display the association relationship between a plurality of tables on the front-end interface, a connecting line needs to be drawn between the tables with the association relationship, and the association relationship between the tables needs to be mapped through the connecting line.

Disclosure of Invention

The present disclosure provides a method, apparatus, device, medium, and product for mapping data associations.

According to an aspect of the present disclosure, a method for mapping data association relationship is provided, including:

determining a first data set and a second data set displayed on a page, wherein the first data set comprises one or more first data, the second data set comprises one or more second data, and the first data and the second data have a mapping relation; analyzing the first data set and the second data set to obtain one or more data combinations, wherein each data combination comprises first data and second data with a mapping relation; and establishing a visual relationship between the first data and the second data for each data combination in the one or more data combinations, and displaying the visual relationship on the page.

According to another aspect of the present disclosure, there is provided an apparatus for mapping data association relationship, including:

the device comprises a determining unit, a display unit and a display unit, wherein the determining unit is used for determining a first data set and a second data set displayed on a page, the first data set comprises one or more first data, the second data set comprises one or more second data, and the first data and the second data have a mapping relation; the analysis unit is used for analyzing the first data set and the second data set to obtain one or more data combinations, and each data combination comprises first data and second data with a mapping relation; and the visualization unit is used for establishing a visualization relation between the first data and the second data aiming at each data combination in the one or more data combinations and displaying the visualization relation on the page.

According to still another aspect of the present disclosure, there is provided an electronic device including:

at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method.

According to yet another aspect of the present disclosure, there is provided a non-transitory computer readable storage medium having stored thereon computer instructions for causing the computer to perform the above method.

According to yet another aspect of the disclosure, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the method.

It should be understood that the statements in this section do not necessarily identify key or critical features of the embodiments of the present disclosure, nor do they limit the scope of the present disclosure. Other features of the present disclosure will become apparent from the following description.

Drawings

The drawings are included to provide a better understanding of the present solution and are not to be construed as limiting the present disclosure. Wherein:

FIG. 1 is a flow chart of a method of mapping data associations according to an embodiment of the present disclosure;

FIG. 2 is a functional option diagram of visualizing relationships according to an embodiment of the present disclosure;

FIG. 3 is a flow diagram of establishing a visualization relationship according to an embodiment of the present disclosure;

FIG. 4 is a flow chart of determining a first anchor point and a second anchor point according to an embodiment of the present disclosure;

FIG. 5 is a flow chart of determining a target anchor point according to an embodiment of the present disclosure;

FIG. 6 is a schematic diagram of relative positions of a source table and a destination table according to an embodiment of the present disclosure;

FIG. 7 is a schematic diagram of another relative position of a source table and a destination table according to an embodiment of the present disclosure;

FIG. 8 is a schematic diagram of determining a wiring pattern according to an embodiment of the present disclosure;

FIG. 9 is a schematic diagram of effects exhibited on a front-end interface according to an embodiment of the present disclosure;

FIG. 10 is a schematic diagram illustrating the effect of adding connecting lines on the front-end interface according to an embodiment of the disclosure;

FIG. 11 is an effect diagram showing a visualization relationship on a front-end interface according to an embodiment of the present disclosure;

FIG. 12 is a block diagram illustrating an apparatus for mapping data associations in accordance with an illustrative embodiment;

FIG. 13 is a block diagram of an electronic device for implementing a method of mapping data associations according to an embodiment of the present disclosure.

Detailed Description

Exemplary embodiments of the present disclosure are described below with reference to the accompanying drawings, in which various details of the embodiments of the disclosure are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the present disclosure. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

The embodiment of the disclosure is applied to a scene of displaying the incidence relation between the forms on the front-end interface. When the correlation between different tables is displayed on a front-end interface in the related art, the correlation needs to be realized by means of a data mapping component (exact-data-mapping or button-vue) which is secondarily encapsulated on the basis of a flow chart component (button-dag), but the exact-data-mapping or button-vue strongly depends on jquery and loadsh. When the data association relation is mapped by using the exact-data-mapping or the button-vue, a function library (load) has to be loaded, and the jquery library and the load library are not necessarily required when a front-end interface is displayed. Therefore, loading the jquery library causes the output resource package of project compilation to be overlarge, occupies memory, and causes the page loading speed to be slow.

In view of this, the embodiment of the present disclosure provides a method for mapping data association relationship. And packaging the open source library (jsplimb) for the second time to traverse the table with the incidence relation and determine the anchor point for establishing the connecting line. And establishing connecting lines among anchor points corresponding to the tables with the incidence relation. By using the method and the device for mapping the data association relationship, the jquery and the loadsh library do not need to be loaded, so that the page loading speed is increased, and the user experience is improved. Compared with the method of directly drawing the connecting line by using the open source library jsplimb, the method does not need a user to specify an anchor point for establishing the connecting line, and only needs to give a source end set and a target end set which have an incidence relation. The present disclosure determines a source table and a target table by parsing a source set and a target set. And traversing in the source end table to determine the row of the source end field name. And traversing in the target end table to determine the row of the target end field name. And then determining the source end anchor point and the target end anchor point by calculating the relative positions of the source end table and the target end table. And the source end anchor point and the target end anchor point are determined in a calculation mode, so that the workload of a user is reduced.

For convenience of description, the source end set is characterized by a first data set, and the target end set is characterized by a second data set. And representing the source end table and the source end field name by adopting first data. And characterizing the target end table and the target end field name by adopting second data. And representing the source end field name by adopting the first field name. And representing the target end field name by adopting a second field name. And characterizing the source anchor by adopting a first anchor. And representing the target end anchor point by adopting a second anchor point. The embodiment of the present disclosure reflects the mapping relationship between the source end set and the target end set through the connection line, so the connection line is also referred to as a mapping connection line. The following examples, when used in conjunction with the above-described terms that characterize the same meaning, are to be understood in all instances to be consistent.

The following embodiments will explain a method for mapping data association provided by the present disclosure with reference to the drawings.

FIG. 1 is a flowchart of a method of mapping data associations according to an embodiment of the present disclosure. As shown in fig. 1, a method for mapping data association provided by the present disclosure includes the following steps.

In step S101, a first data set and a second data set displayed on a page are determined.

In the present disclosure, a first data set and a second data set are displayed on a page. In generating a need to establish a visual relationship in a first data set and a second data set, the first data set and the second data set displayed on a page are determined using the present disclosure. It should be noted that the page in the embodiment of the present disclosure is different from the terminal display interface, the terminal display interface is limited by the size of the terminal display screen and/or user settings, and a complete page can be viewed through the scroll bar on the terminal display interface. The first data set comprises one or more first data, the second data set comprises one or more second data, and the first data and the second data have a mapping relation. Each first data in the first data set has a mapping relation with each second data in the second data set. Illustratively, the first data set comprises A and B, the second data set comprises C and D, A and C, A and D, and B and C, and B and D have mapping relationship.

And determining the mapping type of the first data set and the second data set according to the number of the first data in the first data set and the number of the second data in the second data set. And if the number of the first data in the first data set and the number of the second data in the second data set are both 1, the mapping type is one-to-one. If there is one first data in the first data set and there are multiple second data in the second data set, it is a one-to-many mapping type.

In step S102, the first data set and the second data set are analyzed to obtain one or more data combinations.

In the present disclosure, each data combination includes first data and second data having a mapping relationship. And analyzing the first data set and the second data set to obtain multiple groups of first data and second data with mapping relations. The first data and the second data having the mapping relationship are combined as one data, and a plurality of data combinations can be obtained.

In step S103, for each of the one or more data combinations, a visualization relationship between the first data and the second data is established, and the visualization relationship is displayed on the page.

And establishing a visual relationship between the first data and the second data in the data combination aiming at each data combination. The visualization relationship in the present disclosure may be to establish a connection line between the first data and the second data in the data combination. The visualization relationship in the present disclosure may also be to mark the first data and the second data in the data combination with the same style.

By the method provided by the disclosure, one or more data combinations with mapping relations are obtained by analyzing the first data set and the second data set, a visualization relation is established between the first data and the second data in each data combination, and the established visualization relation is displayed on a page. According to the method and the device, a third-party database does not need to be loaded, and the loading speed of the displayed visual relation page is increased.

In the embodiment of the present disclosure, the first data may include a first table and a first field name, and the second data may include a second table and a second field name.

In one embodiment, function options for visualizing the relationship are set on the page, and are used for acquiring the source end set and the target end set input by the user. Illustratively, as shown in FIG. 2, detecting that the user has triggered (clicked on) the function option displays a page on the front-end interface for inputting the source-end collection and the target-end collection. The input boxes for inputting the source table and the target table are respectively arranged on the page, and the format for prompting the user to input the content can be displayed. For example, table name-field name. The method comprises the steps of obtaining a table name and a field name of a source end table and a table name and a field name of a target end table which are input by a user in an input box, storing the table name and the field name of the source end table in a source end set as first data, and storing the table name and the field name of the target end table in a target end set as second data.

In another embodiment, the method for mapping data association provided by the present disclosure is packaged as an Application Programming Interface (API), and a source set and a target set are obtained through the API. Illustratively, the API is implemented by:

Const mappingLine＝tableMappingConnect({

Source：[ ]，

target：[ ]，

customCommonConfig

})；

in the transmission parameters of the API, source represents a source end set, target represents a destination end set, and both values are Array types, so that the requirement of drawing many-to-many connecting lines of a table is conveniently met. The custom style configuration parameter is drawn by the connection line and is merged with the default configuration parameter of defaultCommonConfig provided by the internal package for effect. The customcommmonconfig is convenient for developers to flexibly configure connection line patterns. The present disclosure performs rendering of multi-form connection lines through a preset form (JSON) configuration.

In the embodiment of the present disclosure, before analyzing the first data set and the second data set to obtain the data combination, the layout of the source table and the target table on the page may be determined according to the id of each source table in the source set and the id of each target table in the target set. And judging whether the source end table and the target end table meet the drawing conditions or not according to the layout of the source end table and the target end table on the page and the preset drawing conditions. And analyzing after the drawing condition is met so as to ensure the smooth establishment of the visual relationship and the spatial display of the visual relationship between the source table and the target table. The drawing conditions comprise that a source end table and/or a target end table which are arranged on the edge of the page need to meet a first drawing condition, and a distance between the source end table and the target end table needs to meet a second drawing condition. The judging process of the first drawing condition comprises the steps of determining a first distance between a source end table and/or a target end table which are/is arranged on the edge of the page and the edge of the page, and judging the relation between the first distance and the first drawing distance. And if the first distance is smaller than the first drawing distance, the source end table and/or the target end table which are arranged on the edge of the page do not meet the first drawing condition. If the first distance is greater than or equal to the first drawing distance, the source table and/or the target table laid out at the edge of the page need to satisfy a first drawing condition. The first drawing condition is set to ensure that the source table and the target table for drawing the connecting line are both laid out on the page. The second drawing condition determining process includes determining a transverse distance and/or a longitudinal distance between the source end table and the target end table, and determining a relationship between the transverse distance and/or the longitudinal distance between the source end table and the target end table and the second drawing distance. For the one-to-one association mapping relationship, and the source table and the target table are in the vertical layout, in this case, only the relationship between the longitudinal distance between the source table and the target table and the second drawing distance needs to be determined. For the one-to-one association mapping relationship, and the source table and the target table are in left-right layout, in this case, only the relationship between the lateral distance between the source table and the target table and the second drawing distance needs to be determined. For the one-to-many association mapping relationship, assuming that the target table is laid out around the source table, in this case, the relationship between the lateral distance and the longitudinal distance between the source table and the target table and the second drawing distance needs to be determined. And if the transverse distance and the longitudinal distance between the source end table and the target end table are smaller than the second drawing distance, the distance between the source end table and the target end table does not meet the second drawing condition. And if the transverse distance and the longitudinal distance between the source end table and the target end table are greater than or equal to the second drawing distance, the distance between the source end table and the target end table meets a second drawing condition. For the case where only a single lateral pitch or longitudinal pitch is judged, another condition is satisfied by default. The second drawing condition is set to ensure a space reserved for drawing the link. In this example, the first drawing distance and the second drawing distance may be set according to actual needs. The first drawing distance and the second drawing distance may be the same or different. The second drawing distance may include a second drawing transverse distance and a second drawing longitudinal distance, the second drawing transverse distance is used to determine a transverse distance between the source table and the target table, and the second drawing longitudinal distance is used to determine a longitudinal distance between the source table and the target table.

In the embodiment of the present disclosure, in the case that it is determined that the drawing condition is not satisfied, a preset prompt may be displayed on the interface for informing the user of the reason and the solution that do not satisfy the drawing condition. For example, when it is judged that the drawing condition is not satisfied, "adjustment of the inter-table space" is requested to be displayed on the page. In the embodiment of the present disclosure, after the drawing condition is satisfied, the first data set and the second data set may be parsed to obtain one or more data combinations. And establishing a visualization relation between the first data and the second data in each data combination, and displaying the visualization relation on a page.

Fig. 3 is a flow chart of establishing a visualization relationship according to an embodiment of the present disclosure. As shown in fig. 3, establishing a visual relationship between the first data and the second data includes the following steps.

In step S201, the first table is traversed, the first anchor point corresponding to the first field name is determined in the first table, and the second table is traversed, and the second anchor point corresponding to the second field name is determined in the second table.

It should be noted that the anchor point in the present disclosure refers to a start point and an end point of the connection line when the connection line is established to represent the mapping relationship between the first field name in the first table and the second field name in the second table.

In step S202, a visualization relationship is established between the first anchor point and the second anchor point.

In the method and the device, the anchor points for establishing the visual relationship are determined by traversing the first table and the second table, so that the user does not need to specify the anchor points for establishing the visual relationship, and the requirements on the user are reduced.

On the basis of any of the above embodiments, fig. 4 is a flowchart for determining a first anchor point and a second anchor point according to an embodiment of the present disclosure. As shown in fig. 4, the first anchor point and the second anchor point are determined as follows.

In step S301, the target table is traversed.

In the present disclosure, the target table includes the first table or the second table.

In step S302, in the target table, a row in which the target data is located is determined.

In the present disclosure, the target data is a first field name or a second field name. And traversing the first table, and determining the row of the first field name in the first table. And traversing the second table, and determining the row of the second field name in the second table.

In step S303, it is determined that the first column or the last column of the row where the target data is located is the target anchor point.

In the present disclosure, the target anchor includes a first anchor or a second anchor. The line where the target data is located is determined in a traversing mode, the first column or the last column where the target data is located is used as the target anchor point, the target anchor point can be determined, the anchor point does not need to be designated by a user, errors when the anchor point is designated by the user are reduced, and the efficiency of establishing the visualization relation is improved.

Fig. 5 is a flow chart of determining a target anchor point according to an embodiment of the present disclosure. As shown in fig. 5, determining whether the first column or the last column of the row where the target data is located is the target anchor point includes the following steps.

In step S3031, a first coordinate system is established with a first preset point in the first table as an origin, and a second coordinate system is established with a second preset point in the second table as an origin.

In the present disclosure, the first preset point is each vertex in the first table, and the second preset point is each vertex in the second table. For example, the first preset point may be the upper left corner of the first table, the lower right corner of the first table, and the like. The second preset point may be an upper left corner of the second table, a lower right corner of the second table, and the like, and the disclosure is not limited in particular.

In step S3032, the relative positions of the first table and the second table are determined in the target coordinate system.

The target coordinate system is a first coordinate system or a second coordinate system. In the first coordinate system established by the first preset point of the first table, the position of the first table is fixed, and the relative position of the second table and the first table needs to be determined. In the second coordinate system established by the second preset point of the second table, the position of the second table is fixed, and the relative position of the first table and the second table needs to be determined.

In step S3033, the first column or the last column of the row where the target data is located is determined as the target anchor point according to the relative position of the first table and the second table.

If the first column of the first table is closest to the last column of the second table in terms of horizontal distance and/or vertical distance, the first column of the first field name is taken as the first anchor point, and the second column of the second field name is taken as the second anchor point. And if the last column of the first table is closest to the horizontal distance and/or the vertical distance of the first column of the second table, taking the last column of the row with the first field name as a first anchor point and taking the second anchor point of the first column of the row with the second field name as a second anchor point.

In the disclosure, the relative position of the first table and the second table is determined by establishing a coordinate system, and the first column or the last column of the row where the target data is located is determined as the target anchor point according to the relative position of the first table and the second table. The relative position of the first table and the second table can be visually determined in a coordinate system mode, and the target anchor point can be rapidly determined conveniently.

In the embodiment of the present disclosure, for multiple mapping relationships between the same two target tables, such as one-to-many, many-to-one, and many-to-many, only one coordinate system needs to be established to determine whether the first column or the last column is the target anchor point. For the mapping relation between different target tables, a coordinate system needs to be established to determine the target anchor point before the visualization relation is established each time.

On the basis of any of the above embodiments, the first preset point is an upper left vertex of the first table, and the first coordinate system is established with the upper left vertex of the first table as an origin. The second preset point is the top point on the left side of the second table, and the top point on the left side of the second table is used as the origin to establish a second coordinate system. According to the relative position of the first table and the second table, determining that the first column or the last column of the row where the target data is located is the target anchor point, and the method comprises the following steps:

if the first table is located in the fourth quadrant and the second table is located in the first quadrant or the fourth quadrant in the first coordinate system, the last column of the row in which the first field name is located is the first anchor point.

If the first table is located in the fourth quadrant and the second table is located in the second quadrant or the third quadrant in the first coordinate system, the first column of the row with the first field name is the first anchor point.

In one embodiment, the source anchor position is determined as follows. And a first coordinate system with the upper left corner of the source table as an origin. And determining the quadrant to which the target end table belongs in the first coordinate system. In the first coordinate system, the target table may be located in the first, second, third, or fourth quadrant. For the source end table, if the target end table is in the first quadrant and the fourth quadrant, the last column of the row where the source end field name in the source end table is located is taken as the source end anchor point. And if the target end table is in the second quadrant and the third quadrant, taking a first column of a row where the name of the source end field in the source end table is positioned as a source end anchor point.

If the second table is located in the fourth quadrant and the first table is located in the first quadrant or the fourth quadrant in the second coordinate system, the last column of the row in which the second field name is located is the second anchor point.

If the second table is located in the fourth quadrant and the first table is located in the second quadrant or the third quadrant in the second coordinate system, the first column of the row with the second field name is the second anchor point.

In another embodiment, the target end anchor point location is determined as follows. And establishing a second coordinate system by taking the upper left corner of the target end table as an origin. And determining the quadrant to which the source table belongs in the second coordinate system. For the target table, if the source table is in the first quadrant and the fourth quadrant, the last column of the row where the target field name in the target table is located is used as the target anchor point. And if the source end table is in the second quadrant and the third quadrant, taking the first column of the row where the target end field name in the target end table is located as the target end anchor point.

In the embodiment of the disclosure, in the first coordinate system, the first table is used as a reference object, and a quadrant to which the second table belongs is determined so as to determine the first anchor point of the first table. In the second coordinate system, the quadrant to which the first table belongs is determined by taking the second table as a reference object so as to determine the second anchor point of the second table, and the positions of the first anchor point and the second anchor point can be accurately determined by the method and the device.

In one example, as shown in FIG. 6, the upper left corner of the source table is O₁Characterised by O₁A first coordinate system is established for the origin. Adopting O at the upper left corner of the target end table₂Characterised by O₂A second coordinate system is established for the origin. In the first coordinate system, the source end table is in the fourth quadrant, the target end table is in the first quadrant, and the last column of the line where the source end field name in the source end table is located is used as the source end anchor point. In the second coordinate system, the target table is in the fourth quadrant, the source table is in the fourth quadrant, and the last column of the row where the target field name in the target table is located is the target anchor point. And drawing a mapping connecting line by taking the source end anchor point as a starting point and the target end anchor point as an end point.

In yet another example, as shown in fig. 7, in the first coordinate system, the target table is located in the third quadrant, and the first column of the line where the source field name in the source table is located is the source anchor. In the second coordinate system, the source end table is located in the fourth quadrant, and the last column of the row where the target end field name in the target end table is located is used as the target end anchor point. And drawing a mapping connecting line by taking the source end anchor point as a starting point and the target end anchor point as an end point.

In one possible implementation, if there is a mapping between the source field names in the source table a and the destination field names in the destination table B. When the many-to-many mapping connecting lines are drawn, a first coordinate system is established by taking the upper left corner of the source end table A as an origin, and a second coordinate system is established by taking the upper left corner of the target end table B as the origin. And determining the relative positions of the source end table and the target end table in a first coordinate system, and determining the first column or the last column of the source end table as the range of the source end anchor point. And in a second coordinate system, determining the relative positions of the target end table and the source end table, and determining the first column or the last column of the target end table as the range of the target end anchor point. And after traversing the source end table to determine the line where the source end field name is located, determining the source end anchor point in the current mapping relation according to the range of the source end anchor point. And after traversing the target table to determine the line where the field name of the target is located, determining the target anchor point in the current mapping relation according to the range of the target anchor point. The source end anchor point and the target end anchor point do not need to be repeatedly calculated according to each mapping relation, so that the calculation resources can be saved, and the page loading speed is increased.

In another possible implementation, after determining the row of the source target field name through traversal in the source table, it may be queried whether the relative positions of the source table and the target table in the current mapping relationship have already been determined. And if the relative positions of the source end table and the target end table in the current mapping relation are determined, determining a source end anchor point according to the determined relative positions of the source end table and the target end table in the current mapping relation. And if the relative positions of the source end table and the target end table in the current mapping relation do not exist, establishing a first coordinate system, and determining the relative positions of the source end table and the target end table in the current mapping relation so as to determine the source end anchor point. The manner of determining the target anchor point is similar and is not described herein.

On the basis of any one of the above embodiments, establishing a visual relationship between a first anchor point and a second anchor point includes: and drawing the connecting line by taking the first anchor point as a starting point and the second anchor point as an end point. The connecting line has a custom style configuration parameter.

In the method, the visual relation between the first data and the second data is displayed by drawing the connecting line, so that the first data and the second data with the mapping relation can be visually checked.

Fig. 8 is a schematic diagram of determining a wiring pattern according to an embodiment of the present disclosure. When the functional option triggering the "wire style" is detected in fig. 2, the schematic diagram of the wire style shown in fig. 8 is called out, and the user can customize the wire style in the interface shown in fig. 8.

In an embodiment, a mapping relationship is drawn between a source table a and target tables C and B, and the obtained source set and target set are as follows:

{

Source：['A-a']

Target：['C-c'，'B-b']

}

and analyzing the source end set and the target end set, and determining that the correlation mapping relation is A-a- > C-C and A-a- > B-B. Where a represents the source field name, C represents the destination field name in the destination table C, and B represents the destination field name in the destination table B. And determining a mapping connection line for drawing the source end table A and the target end table C and a mapping connection line for drawing the source end table A and the target end table B according to the associated mapping relation. In this case, the relative positions of the source table a, the target table C, and the target table B need to be calculated respectively to determine the source anchor and the target anchor. The effect shown on the front-end interface is as shown in fig. 9, where a line in the source table a and B line in the destination table B are mapped, and a mapping line is drawn between a line in the source table a and C line in the destination table C.

In the embodiment of the disclosure, the user can be provided with the function options of adjusting the connection style, the color and the like. And setting the thickness of lines through function options, or adopting dotted lines of different forms to display the association mapping relation among the tables when multiple association mapping relations exist. It should be understood that in the case that the user does not set the connection mode, the connection between the tables is drawn in the default setting.

On the basis of any one of the above embodiments, if a mapping relationship change instruction is detected, determining to change the mapping relationship indicated by the mapping relationship change instruction, and updating the first data and the second data corresponding to the changed mapping relationship in the first data set and/or the second data set. Detecting a mapping relation changing instruction, comprising: and detecting a mapping relation changing instruction triggered by a mouse event or a touch event.

In the present disclosure, the mapping relationship is changed by detecting a mapping relationship change instruction, increasing flexibility.

For example, the user changes the connection line through a mouse and/or a touch event, and the mapping relationship is updated according to the connection line changed by the user. For example, if it is detected that the user adds a new mapping connection, a table name and a field name representing a mapping relationship are added to the corresponding set. In this example, the user may click on the page to draw the start point and the end point of the connecting line, and after detecting the start point and the end point, draw the connecting line between the start point and the end point. In this example, it is also possible to detect a slide trajectory, and draw a connection line between the start point and the end point of the slide trajectory. In another example, if it is detected that the user deletes the connection line, the table name and the field name representing the mapping relationship are deleted from the corresponding set.

Continuing with the above embodiment, as shown in fig. 10, if the user adds a connection line between C1 in the source table a and the destination table C through the mouse, the mapping relationship is increased as follows:

{

source:['A-a']

target:['C-c','B-b','C-c1']

}

and when detecting that the user drags the source end table or the target end table, redrawing the connecting line according to the mapping relation, and showing the effect that the connecting line moves along with the source end table or the target end table.

And in response to the first data and/or the second data displayed on the display device changing, updating the displayed visualization relationship to the visualization relationship between the changed first data and the changed second data.

In one embodiment, when the user drags the source table or the target table, the connecting line is redrawn according to the latest mapping relation.

The method for drawing the association mapping relation completely takes the mapping relation data as the center, realizes the decoupling of the table drawing and the mapping connection line drawing, can be applied to different front-end technical frameworks, has no additional requirement and limitation on a UI framework, and is convenient for expanding the mapping connection line drawing.

The method for drawing the association mapping relation is realized by adopting jsplimb, has good compatibility, and can support all desktop browsers, mobile equipment browsers and the like.

The method for drawing the associated mapping relation does not have strong dependence on other third-party libraries, so that class libraries which cannot be used by introducing other current projects do not exist.

For example, when a user performs data migration, the method provided by the present disclosure may be used to check the mapping relationship between tables. For example, when an enterprise migrates local data to the cloud, part of the data is migrated to the cloud in consideration of the security of core data. In this case, the present disclosure may be utilized to show a mapping relationship between the local data table and the table to be migrated to the cloud. The data needing to be visually displayed are obtained, the data needing to be visually displayed have a mapping relation, a mapping connecting line is drawn between the data with the mapping relation, and a user can visually see the mapping relation between the local data table and the table to be migrated. By adopting the method provided by the embodiment of the disclosure, the effect as shown in fig. 11 is obtained.

Based on the same conception, the embodiment of the disclosure also provides a device for mapping the data association relationship.

It is understood that, in order to implement the above functions, the apparatus for mapping data association provided in the embodiments of the present disclosure includes a hardware structure and/or a software module for performing each function. The disclosed embodiments can be implemented in hardware or a combination of hardware and computer software, in combination with the exemplary elements and algorithm steps disclosed in the disclosed embodiments. Whether a function is performed as hardware or computer software drives hardware depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present disclosure.

FIG. 12 is a block diagram illustrating an apparatus for mapping data associations, according to an example embodiment. Referring to fig. 12, the apparatus 400 comprises a determination unit 401, a parsing unit 402 and a visualization unit 403.

A determining unit 401, configured to determine a first data set and a second data set displayed on a page, where the first data set includes one or more first data, the second data set includes one or more second data, and the first data and the second data have a mapping relationship; an analyzing unit 402, configured to analyze the first data set and the second data set to obtain one or more data combinations, where each data combination includes first data and second data having a mapping relationship; a visualization unit 403, configured to establish a visualization relationship between the first data and the second data for each data combination of the one or more data combinations, and display the visualization relationship on the page.

By means of the device provided by the disclosure, one or more data combinations with mapping relations are obtained by analyzing the first data set and the second data set, a visualization relation is established between the first data and the second data in each data combination, and the established visualization relation is displayed on a page. According to the method and the device, a third-party database does not need to be loaded, and the loading speed of the displayed visual relation page is increased.

In one embodiment, the first data includes a first table and a first field name, and the second data includes a second table and a second field name;

a visualization unit 403 for: traversing the first table, determining a first anchor point corresponding to the first field name in the first table, traversing the second table, and determining a second anchor point corresponding to the second field name in the second table; and establishing a visual relation between the first anchor point and the second anchor point.

In one embodiment, the first anchor point and the second anchor point are determined as follows:

traversing a target table, wherein the target table comprises a first table or a second table; in the target table, determining a row where target data are located, wherein the target data are first field names or second field names; and determining that the first column or the last column of the row where the target data is located is a target anchor point, wherein the target anchor point comprises a first anchor point or a second anchor point.

In an embodiment, the visualization unit 403 is further configured to:

establishing a first coordinate system by taking a first preset point in a first table as an origin, wherein the first preset point is each vertex in the first table, and establishing a second coordinate system by taking a second preset point in a second table as the origin, wherein the second preset point is each vertex in the second table; determining the relative position of the first table and the second table in a target coordinate system, wherein the target coordinate system is the first coordinate system or the second coordinate system; and determining the first column or the last column of the row where the target data is located as the target anchor point according to the relative positions of the first table and the second table.

In one embodiment, the first preset point is the top left vertex of the first table, and the second preset point is the top left vertex of the second table; a visualization unit 403, further configured to:

if the first table is located in the fourth quadrant and the second table is located in the first quadrant or the fourth quadrant in the first coordinate system, the last column of the row where the first field name is located is a first anchor point; if the first table is located in the fourth quadrant and the second table is located in the second quadrant or the third quadrant in the first coordinate system, the first column of the row where the first field name is located is taken as a first anchor point; if the second table is located in the fourth quadrant and the first table is located in the first quadrant or the fourth quadrant in the second coordinate system, the last column of the row where the second field name is located is a second anchor point; if the second table is located in the fourth quadrant and the first table is located in the second quadrant or the third quadrant in the second coordinate system, the first column of the row with the second field name is the second anchor point.

In an embodiment, the visualization unit 403 is further configured to:

and drawing a connecting line by taking the first anchor point as a starting point and the second anchor point as an end point, wherein the connecting line has a custom style configuration parameter.

In one embodiment, the apparatus 400 further comprises: an updating unit 404, configured to, when a mapping relationship changing instruction is detected, determine to change a mapping relationship indicated by the mapping relationship changing instruction, and update, in the first data set and/or the second data set, first data and second data corresponding to the changed mapping relationship.

In one embodiment, a mapping relationship change instruction is detected, comprising: and detecting a mapping relation changing instruction triggered by a mouse event or a touch event.

With regard to the apparatus in the above-described embodiment, the specific manner in which each unit performs the operation has been described in detail in the embodiment related to the method, and will not be described in detail here.

In the technical scheme of the disclosure, the acquisition, storage, application and the like of the personal information of the related user all accord with the regulations of related laws and regulations, and do not violate the good customs of the public order.

The present disclosure also provides an electronic device, a readable storage medium, and a computer program product according to embodiments of the present disclosure.

FIG. 13 shows a schematic block diagram of an example electronic device 500 that may be used to implement embodiments of the present disclosure. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be examples only, and are not meant to limit implementations of the disclosure described and/or claimed herein.

As shown in fig. 13, the apparatus 500 includes a computing unit 501 that can perform various appropriate actions and processes according to a computer program stored in a Read Only Memory (ROM)502 or a computer program loaded from a storage unit 508 into a Random Access Memory (RAM) 503. In the RAM 503, various programs and data required for the operation of the device 500 can also be stored. The calculation unit 501, the ROM 502, and the RAM 503 are connected to each other by a bus 504. An input/output (I/O) interface 505 is also connected to bus 504.

A number of components in the device 500 are connected to the I/O interface 505, including: an input unit 506 such as a keyboard, a mouse, or the like; an output unit 507 such as various types of displays, speakers, and the like; a storage unit 508, such as a magnetic disk, optical disk, or the like; and a communication unit 509 such as a network card, modem, wireless communication transceiver, etc. The communication unit 509 allows the device 500 to exchange information/data with other devices through a computer network such as the internet and/or various telecommunication networks.

The computing unit 501 may be a variety of general-purpose and/or special-purpose processing components having processing and computing capabilities. Some examples of the computing unit 501 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various dedicated Artificial Intelligence (AI) computing chips, various computing units running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, and so forth. The calculation unit 501 executes the respective methods and processes described above, such as the method of mapping data association. For example, in some embodiments, method XXX may be implemented as a computer software program tangibly embodied in a machine-readable medium, such as storage unit 508. In some embodiments, part or all of the computer program may be loaded and/or installed onto the device 500 via the ROM 502 and/or the communication unit 509. When loaded into RAM 503 and executed by the computing unit 501, may perform one or more of the steps of the above described method of mapping data associations. Alternatively, in other embodiments, the computing unit 501 may be configured by any other suitable means (e.g., by means of firmware) to perform the method of mapping data associations.

Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, Field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.

Program code for implementing the methods of the present disclosure may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the program codes, when executed by the processor or controller, cause the functions/operations specified in the flowchart and/or block diagram to be performed. The program code may execute entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or server.

In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.

The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), Wide Area Networks (WANs), and the Internet.

The computer system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server may be a cloud server, a server of a distributed system, or a server with a combined blockchain.

The method comprises the steps of analyzing the first data set and the second data set through the method, obtaining one or more data combinations with mapping relations, establishing a visual relation between the first data and the second data in each data combination, and displaying the established visual relation on a page. According to the method and the device, a third-party database does not need to be loaded, and the loading speed of the displayed visual relation page is increased.

It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present disclosure may be executed in parallel, sequentially, or in different orders, as long as the desired results of the technical solutions disclosed in the present disclosure can be achieved, and the present disclosure is not limited herein.

The above detailed description should not be construed as limiting the scope of the disclosure. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present disclosure should be included in the scope of protection of the present disclosure.

Claims

1. A method of mapping data associations, comprising:

determining a first data set and a second data set displayed on a page, wherein the first data set comprises one or more first data, the second data set comprises one or more second data, and the first data and the second data have a mapping relation;

analyzing the first data set and the second data set to obtain one or more data combinations, wherein each data combination comprises first data and second data with a mapping relation;

and establishing a visual relationship between the first data and the second data for each data combination in the one or more data combinations, and displaying the visual relationship on the page.

2. The method of claim 1, wherein the first data comprises a first table and a first field name, and the second data comprises a second table and a second field name;

the establishing of the visual relationship between the first data and the second data comprises:

traversing the first table, determining a first anchor point corresponding to the first field name in the first table, traversing the second table, and determining a second anchor point corresponding to the second field name in the second table;

and establishing a visual relation between the first anchor point and the second anchor point.

3. The method of claim 2, the first anchor point and the second anchor point determined as follows:

traversing a target table, the target table including the first table or the second table;

in the target table, determining a row where target data is located, wherein the target data is the first field name or the second field name;

determining that a first column or a last column of a row where the target data is located is a target anchor point, wherein the target anchor point comprises the first anchor point or the second anchor point.

4. The method of claim 3, wherein the determining to target the target anchor point in a first column or a last column of a row in which the target data is located comprises:

establishing a first coordinate system by taking a first preset point in the first table as an origin, wherein the first preset point is each vertex in the first table, and establishing a second coordinate system by taking a second preset point in a second table as the origin, wherein the second preset point is each vertex in the second table;

determining a relative position of the first table and the second table in a target coordinate system, the target coordinate system being either the first coordinate system or the second coordinate system;

and determining the first column or the last column of the row where the target data is located as a target anchor point according to the relative positions of the first table and the second table.

5. The method of claim 4, wherein the first preset point is an upper left vertex of a first table and the second preset point is an upper left vertex of a second table;

the determining that the first column or the last column of the row where the target data is located is the target anchor point according to the relative positions of the first table and the second table includes:

if the first table is located in the fourth quadrant and the second table is located in the first quadrant or the fourth quadrant in the first coordinate system, taking the last column of the row where the first field name is located as a first anchor point;

if the first table is located in the fourth quadrant and the second table is located in the second quadrant or the third quadrant in the first coordinate system, taking the first column of the row where the first field name is located as a first anchor point;

if the second table is located in the fourth quadrant and the first table is located in the first quadrant or the fourth quadrant in the second coordinate system, taking the last column of the row where the second field name is located as the second anchor point;

if the second table is located in the fourth quadrant and the first table is located in the second quadrant or the third quadrant in the second coordinate system, the first column of the row in which the second field name is located is the second anchor point.

6. The method of any of claims 2-5, wherein the establishing a visual relationship between the first anchor point and the second anchor point comprises:

and drawing a connecting line by taking the first anchor point as a starting point and the second anchor point as an end point, wherein the connecting line has custom style configuration parameters.

7. The method of any of claims 1-5, further comprising:

if a mapping relation changing instruction is detected, determining to change the mapping relation indicated by the mapping relation changing instruction, and updating first data and second data corresponding to the changed mapping relation in the first data set and/or the second data set.

8. The method of claim 7, the detecting a mapping relationship change instruction, comprising:

and detecting a mapping relation changing instruction triggered by a mouse event or a touch event.

9. An apparatus for mapping data associations, comprising:

the device comprises a determining unit, a display unit and a display unit, wherein the determining unit is used for determining a first data set and a second data set displayed on a page, the first data set comprises one or more first data, the second data set comprises one or more second data, and the first data and the second data have a mapping relation;

the analysis unit is used for analyzing the first data set and the second data set to obtain one or more data combinations, and each data combination comprises first data and second data with a mapping relation;

and the visualization unit is used for establishing a visualization relation between the first data and the second data aiming at each data combination in the one or more data combinations and displaying the visualization relation on the page.

10. The apparatus of claim 9, wherein the first data comprises a first table and a first field name, and the second data comprises a second table and a second field name;

the visualization unit is configured to:

11. The apparatus of claim 10, the first anchor point and the second anchor point determined by:

12. The apparatus of claim 11, wherein the visualization unit is further configured to:

13. The apparatus of claim 12, wherein the first preset point is an upper left vertex of a first table, and the second preset point is an upper left vertex of a second table;

the visualization unit is further configured to:

14. The apparatus according to any one of claims 10-13, wherein the visualization unit is further configured to:

15. The apparatus of any of claims 9-13, further comprising:

and the updating unit is used for determining the changed mapping relation indicated by the mapping relation changing instruction under the condition that the mapping relation changing instruction is detected, and updating the first data and the second data corresponding to the changed mapping relation in the first data set and/or the second data set.

16. The apparatus of claim 15, the detecting a mapping relationship change instruction comprising:

17. An electronic device, comprising:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein,

the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-8.

18. A non-transitory computer readable storage medium having stored thereon computer instructions for causing the computer to perform the method of any one of claims 1-8.

19. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1-8.