CN-122019658-A - Method, device, computer equipment and storage medium for displaying data blood relationship

Abstract

The application relates to a method, a device, a computer device, a storage medium and a computer program product for displaying data blood relationship. The method comprises the steps of displaying a table level blood-edge relation diagram of a target data table, displaying data table fields associated with table nodes at positions corresponding to the table nodes of the table level blood-edge relation diagram in response to display mode switching operation, displaying a field level blood-edge relation diagram corresponding to a target field in the data table fields in response to triggering operation of the target field, and connecting edges among field nodes in the field level blood-edge relation diagram are used for representing blood-edge relations among fields. By adopting the method, the analysis efficiency of the data blood relationship can be improved.

Inventors

• KONG WEIZHONG

Assignees

• 腾讯科技（深圳）有限公司

Dates

Publication Date

20260512

Application Date

20260126

Claims (20)

1. 1. A method for displaying a data blood-lineage relationship, the method comprising: Displaying a table-level blood relationship graph of the target data table; in response to a display mode switching operation, displaying data table fields associated with the table nodes at the positions corresponding to the table nodes of the table-level blood-edge relationship diagram; and responding to the triggering operation of the target field in the data table field, displaying a field-level blood-edge relation graph corresponding to the target field, wherein connecting edges between field nodes in the field-level blood-edge relation graph are used for representing the blood-edge relation between the fields.
2. 2. The method of claim 1, wherein displaying the data table field associated with the table node at the table node corresponding location of the table level blood relationship graph comprises: displaying a first information viewing area at a position corresponding to a table node of the table-level blood-edge relationship diagram, wherein the first information viewing area comprises a first field sub-area and a first search sub-area; Displaying a data table field associated with the table node in the first field subarea; and responding to the search operation triggered in the first search sub-area, and displaying the searched result field, wherein the result field belongs to the data table field.
3. 3. The method of claim 2, wherein displaying the first information viewing area at the table node correspondence location of the table level blood relationship graph comprises: Acquiring a data table field corresponding to a table node; Determining a field sub-region size based on the number of data table fields; And displaying a first information viewing area at a position corresponding to a table node of the table-level blood-edge relation diagram based on the field sub-area size and the preset search sub-area size.
4. 4. The method of claim 1, wherein the field level blood relationship graph comprises field nodes and field level connection edges, and wherein displaying the field level blood relationship graph corresponding to the target field comprises: displaying a second information viewing area at a position corresponding to a table node of the table level blood-edge relationship diagram, wherein the second information viewing area comprises a node sub-area; Displaying field nodes in the node subareas; a field level connection edge is displayed between the field nodes of different blood-edge levels.
5. 5. The method of claim 4, wherein displaying a second information viewing area at a table node correspondence location of the table level blood relationship graph comprises: determining an associated field with a field-level dependency relationship with the target field in a data table field of the table node; determining the size of a node subarea based on the field number of the associated fields; And displaying a second information viewing area at a position corresponding to the table node of the table-level blood-edge relation diagram according to the node position configuration information and the node subarea size.
6. 6. The method of claim 5, wherein displaying field level connection edges between the field nodes of different blood edge levels comprises: Determining a node connection pile position of the field node based on the node sub-region size and the node position configuration information; Displaying the node connection piles corresponding to the field nodes based on the node connection pile positions; determining a starting point connecting pile and an ending point connecting pile in the node connecting piles of adjacent blood-edge levels based on the field-level dependency relationship; And drawing a field-level connection edge between the starting point connection pile and the end point connection pile.
7. 7. The method of claim 5, wherein displaying a second information viewing area at a table node correspondence location of the table level blood relationship graph according to node location configuration information and the node sub-region size, comprises: Acquiring a data table field corresponding to a table node; Determining a field sub-region size based on the number of data table fields; determining a second information viewing area size according to the node position configuration information, the node sub-area size, the field sub-area size and the preset search sub-area size; And displaying a second information viewing area at a position corresponding to a table node of the table level blood-edge relation diagram based on the node position configuration information and the second information viewing area size, wherein the second information viewing area further comprises a second field sub-area and a second search input area, the second field sub-area is used for displaying data table fields, and the second search input area is used for carrying out field search.
8. 8. The method of claim 7, wherein displaying field nodes in the node sub-area comprises: displaying field nodes in the node subareas according to a first display style; the method further comprises the steps of: And displaying the data table field associated with the table node according to a second display style in the second field subarea.
9. 9. The method of claim 1, wherein the table-level blood-edge relationship graph comprises table nodes and table-level connecting edges, and wherein displaying the table-level blood-edge relationship graph of the target data table comprises: Determining a data table for participating in relation graph generation and a table-level dependency relationship between the data tables in response to a blood-relationship display operation for a target data table; Determining the blood margin level of each data table based on the table level dependency relationship; Determining the position of a table node area corresponding to each data table based on the preset table node area size and the blood margin level to which the data table belongs; Displaying data table nodes corresponding to each data table respectively based on the preset table node area size and the table node area position; and displaying the table-level connection edges between the table nodes of different blood-edge levels based on the table-level dependency relationship.
10. 10. The method of claim 9, wherein determining the table node area location corresponding to each data table based on the preset table node area size and the blood-source hierarchy to which the data table belongs comprises: determining a target blood-edge level to be ranked; sorting the data tables belonging to the target blood edge levels according to a target sorting mode to obtain a data table sorting result corresponding to the target blood edge levels; And determining the position of a table node area corresponding to each data table in the target blood-edge hierarchy based on a preset table node area size, the target blood-edge hierarchy to which the data table belongs and a data table sorting result of the target blood-edge hierarchy.
11. 11. The method according to claim 10, wherein the sorting the data tables belonging to the target blood-edge levels according to the target sorting mode to obtain the sorting result of the data tables corresponding to the blood-edge levels includes: determining a sorting dimension and a sorting direction corresponding to the target sorting mode; based on the sorting dimension, obtaining a data table corresponding sorting index value belonging to the target blood edge level; And in the sorting direction, sorting the data tables belonging to the target blood edge level based on the sorting index value to obtain a data table sorting result corresponding to the target blood edge level.
12. 12. The method according to claim 10, wherein the method further comprises: when the number of the target blood edge levels reaches a preset number threshold, at least two working threads are started; respectively distributing sequencing tasks corresponding to the target blood edge level to the at least two working threads; And processing the sequencing tasks corresponding to the at least two working threads in parallel.
13. 13. The method of claim 10, wherein the table node region location comprises a table node abscissa and a table node ordinate, wherein the determining the table node region location corresponding to each data table based on the preset table node region size, the blood edge level to which the data table belongs, and the data table ordering result of each blood edge level comprises: determining a table node abscissa corresponding to the data table based on a preset table node area size and a blood margin level to which the data table belongs; And determining the ordinate of the table node corresponding to the data table based on the preset table node area size and the data table sorting result of each blood edge level.
14. 14. The method of claim 13, wherein determining the table node ordinate corresponding to the data table based on the data table ordering results of the preset table node area size and each blood edge level comprises: Determining a blood margin level to be adjusted; Generating initial ordinate of each table node in the blood margin level to be adjusted; Traversing initial ordinate coordinates of each data table in the blood-edge level to be adjusted in sequence according to the data table ordering result of the blood-edge level to be adjusted until traversing all the data tables in the blood-edge level to be adjusted; In the traversing process, determining the coordinate difference value between the initial ordinate of the traversed data table and the table node ordinate of the previous data table in real time; And adjusting the initial ordinate of the traversed data table based on the preset table node area size and the coordinate difference value to obtain the table node ordinate of the traversed data table.
15. 15. The method of any one of claims 1 to 14, wherein the target blood edge level in the table level blood edge relationship graph corresponds to at least two table nodes, the at least two table nodes being displayed in a first ordering mode, the method further comprising: And responding to the sorting mode switching operation, and displaying the at least two table nodes according to a second sorting mode appointed by the sorting mode switching operation.
16. 16. The method according to any one of claims 1 to 14, further comprising: responding to node screening operation triggered based on node screening conditions, and determining table nodes meeting the node screening conditions in the table level blood-edge relation diagram; and updating and displaying the table-level blood-edge relation graph based on the selected table node.
17. 17. A display device for data blood relationship, the device comprising: The table-level blood-edge relation display module is used for displaying a table-level blood-edge relation graph of the target data table; The field display module is used for responding to the display mode switching operation and displaying data table fields associated with the table nodes at the positions corresponding to the table nodes of the table-level blood-edge relationship diagram; the field-level blood-edge relation display module is used for responding to the triggering operation of a target field in the data table field and displaying a field-level blood-edge relation graph corresponding to the target field, wherein connecting edges between field nodes in the field-level blood-edge relation graph are used for representing blood-edge relations among fields.
18. 18. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any one of claims 1 to 16 when the computer program is executed.
19. 19. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 16.
20. 20. A computer program product comprising a computer program, characterized in that the computer program, when executed by a processor, implements the steps of the method of any one of claims 1 to 16.

Description

Method, device, computer equipment and storage medium for displaying data blood relationship Technical Field The present application relates to the field of data processing technologies, and in particular, to a method and apparatus for displaying a data blood relationship, a computer device, and a storage medium. Background Along with the development of processing technology, enterprises display data sources, processing flows and dependency relations among different data tables through a data blood relationship display technology so as to assist data management, influence analysis and problem investigation to become common technical means. In the existing data blood-edge display mode, a blood-edge relation diagram is generally constructed by taking a data table as a node and taking a dependency relation between tables as a connecting edge, so that the integral presentation of a data flow path is realized. Along with the continuous improvement of the complexity and the data size of the data model, the simple support of the table-level blood-edge display mode is difficult to meet the requirements of refined data management and deep influence analysis, for example, when the field-level data sources or the transfer relations among fields need to be analyzed, the prior art often relies on manual reference of data processing scripts, data processing logic or metadata description documents, so that the analysis efficiency of the data blood-edge relation is lower. Disclosure of Invention In view of the foregoing, it is desirable to provide a data blood-edge relationship display method, apparatus, computer device, and storage medium that can improve the analysis efficiency of the data blood-edge relationship. In a first aspect, the present application provides a method for displaying a data blood-lineage relationship. The method comprises the following steps: Displaying a table-level blood relationship graph of the target data table; in response to a display mode switching operation, displaying data table fields associated with the table nodes at the positions corresponding to the table nodes of the table-level blood-edge relationship diagram; and responding to the triggering operation of the target field in the data table field, displaying a field-level blood-edge relation graph corresponding to the target field, wherein connecting edges between field nodes in the field-level blood-edge relation graph are used for representing the blood-edge relation between the fields. In a second aspect, the application further provides a display device for the data blood relationship. The device comprises: The table-level blood-edge relation display module is used for displaying a table-level blood-edge relation graph of the target data table; The field display module is used for responding to the display mode switching operation and displaying data table fields associated with the table nodes at the positions corresponding to the table nodes of the table-level blood-edge relationship diagram; the field-level blood-edge relation display module is used for responding to the triggering operation of a target field in the data table field and displaying a field-level blood-edge relation graph corresponding to the target field, wherein connecting edges between field nodes in the field-level blood-edge relation graph are used for representing blood-edge relations among fields. In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the steps of the method described above when the processor executes the computer program. In a fourth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the steps of the method described above. In a fifth aspect, the present application also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the steps of the method described above. The method, the device, the computer equipment, the storage medium and the computer program product for displaying the data blood edge relation diagram of the target data table display, display the data table fields associated with the table nodes at the corresponding positions of the table nodes of the table level blood edge relation diagram in response to the display mode switching operation, so that a user can intuitively see the fields in each data table and quickly know the roles and interrelationships of the fields in the data table through the view, and display the field level blood edge relation diagram corresponding to the target fields in response to the triggering operation of the target fields in the data table fields, wherein the connecting edges between the field nodes in the field level blood edge relation diag