CN113282678A - Data blood relationship display method and device - Google Patents
Data blood relationship display method and device Download PDFInfo
- Publication number
- CN113282678A CN113282678A CN202110343323.0A CN202110343323A CN113282678A CN 113282678 A CN113282678 A CN 113282678A CN 202110343323 A CN202110343323 A CN 202110343323A CN 113282678 A CN113282678 A CN 113282678A
- Authority
- CN
- China
- Prior art keywords
- information
- node
- blood relationship
- nodes
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 239000008280 blood Substances 0.000 title claims abstract description 155
- 210000004369 blood Anatomy 0.000 title claims abstract description 155
- 238000000034 method Methods 0.000 title claims abstract description 39
- 230000002776 aggregation Effects 0.000 claims description 24
- 238000004220 aggregation Methods 0.000 claims description 24
- 238000010586 diagram Methods 0.000 description 17
- 230000008569 process Effects 0.000 description 8
- 230000036765 blood level Effects 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 238000013499 data model Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000011144 upstream manufacturing Methods 0.000 description 2
- 239000008186 active pharmaceutical agent Substances 0.000 description 1
- 230000006978 adaptation Effects 0.000 description 1
- 230000004931 aggregating effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000011176 pooling Methods 0.000 description 1
- 238000013441 quality evaluation Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
Abstract
The embodiment of the invention provides a method and a device for displaying data blood relationship. The embodiment of the invention obtains the blood relationship among the data tables on the processing link according to the processing information of the data table processing link, each data table in the blood relationship is a node, the level information and the attribute information of the node are determined according to the metadata information corresponding to each node in the blood relationship, each node in the blood relationship is gathered according to the level information and the attribute information of the node to obtain the gathered blood relationship information, the gathered blood relationship information comprises the connection relationship between a gathering point and a gathering point, the nodes gathered in the gathering point have the same level and the same attribute, the blood relationship is displayed based on the level information of the node and the gathered blood relationship information, and the data blood relationship can be displayed more clearly and intuitively by processing the blood relationship information in a layering and attribute gathering way, providing convenience to the user.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for displaying data blood relationship.
Background
In the field of big data, the data is generated, processed, fused, circulated and circulated, and naturally forms a relationship between the data until the data is finally lost. The relationship between data is expressed by referring to a similar relationship in human society, which is called data relationship.
The data blood relationship plays an important role in data traceability, data quality evaluation, data value evaluation and the like. Therefore, in application, the data relationship is often required to be displayed.
Disclosure of Invention
In order to overcome the problems in the related art, the invention provides a data blood relationship display method and device, which can clearly display the hierarchy of each data table in the data blood relationship.
According to a first aspect of the embodiments of the present invention, there is provided a data relationship display method, the method including:
acquiring a blood relationship among data tables on a processing link according to processing information of the processing link of the data tables, wherein each data table in the blood relationship is a node;
determining the level information and attribute information of the nodes according to the metadata information corresponding to each node in the blood relationship; the layer information is used for indicating the layer of the node, and the attribute information is used for indicating the attribute of the node;
according to the level information and the attribute information of the nodes, carrying out aggregation processing on all the nodes in the blood relationship to obtain summarized blood relationship information; the summarized blood relationship information comprises a convergent point and a connection relation between the convergent points, and all nodes converged in the convergent point have the same level and the same attribute;
and displaying the blood relationship based on the level information of the nodes and the summary blood relationship information.
According to a second aspect of the embodiments of the present invention, there is provided a data relationship displaying apparatus, the apparatus including:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring the blood relationship among data tables on a processing link according to processing information of the processing link of the data tables, and each data table in the blood relationship is a node;
the determining module is used for determining the level information and the attribute information of the nodes according to the metadata information corresponding to each node in the blood relationship; the layer information is used for indicating the layer of the node, and the attribute information is used for indicating the attribute of the node;
the aggregation module is used for carrying out aggregation processing on each node in the blood relationship according to the level information and the attribute information of the node to obtain summarized blood relationship information; the summarized blood relationship information comprises a convergent point and a connection relation between the convergent points, and all nodes converged in the convergent point have the same level and the same attribute;
and the display module is used for displaying the blood relationship based on the level information of the nodes and the collected blood relationship information.
The technical scheme provided by the embodiment of the invention has the following beneficial effects:
according to the embodiment of the invention, a blood-related relationship between data tables on a processing link is obtained according to processing information of the data tables processing link, each data table in the blood-related relationship is a node, hierarchical information and attribute information of the node are determined according to metadata information corresponding to each node in the blood-related relationship, the hierarchical information is used for indicating the level of the node, the attribute information is used for indicating the attribute of the node, each node in the blood-related relationship is converged according to the hierarchical information and the attribute information of the node to obtain summarized blood-related information, the summarized blood-related information comprises a connection relationship between a convergent point and a convergent point, the nodes converged in the convergent point have the same hierarchy and attribute, the blood-related relationship is displayed based on the hierarchical information and the summarized blood-related information of the node, and the blood-related information is layered, distributed and distributed according to the blood-related information, The processing of attribute convergence can show the relationship of data blood relationship more clearly and intuitively, and provides convenience for users.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the specification.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present specification and together with the description, serve to explain the principles of the specification.
Fig. 1 is a diagram illustrating an example of data relationship provided by an embodiment of the present invention.
Fig. 2 is a flowchart illustrating a data relationship display method according to an embodiment of the present invention.
Fig. 3 is an exemplary diagram of a node aggregation result provided in the embodiment of the present invention.
Fig. 4 is an exemplary diagram of a summary blood relationship provided by an embodiment of the invention.
FIG. 5 is an exemplary illustration of a display interface at a local perspective of a blood-related relationship provided by an embodiment of the invention.
Fig. 6 is a diagram illustrating an example of displaying hierarchical statistical information according to an embodiment of the present invention.
Fig. 7 is a diagram illustrating an example of viewing a result of a node according to an embodiment of the present invention.
Fig. 8 is a diagram illustrating an example of the result of unfolding a rendezvous point according to an embodiment of the invention.
FIG. 9 is a block diagram of a data relationship display apparatus according to an embodiment of the present invention.
Fig. 10 is a hardware configuration diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present invention. Rather, they are merely examples of apparatus and methods consistent with certain aspects of embodiments of the invention, as detailed in the following claims.
The terminology used in the embodiments of the invention is for the purpose of describing particular embodiments only and is not intended to be limiting of embodiments of the invention. As used in the examples of the present invention and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It should also be understood that the term "and/or" as used herein refers to and encompasses any and all possible combinations of one or more of the associated listed items.
It should be understood that although the terms first, second, third, etc. may be used to describe various information in embodiments of the present invention, the information should not be limited by these terms. These terms are only used to distinguish one type of information from another. For example, the first information may also be referred to as second information, and similarly, the second information may also be referred to as first information, without departing from the scope of embodiments of the present invention. The word "if" as used herein may be interpreted as "at … …" or "when … …" or "in response to a determination", depending on the context.
A plurality of links are involved in the data warehouse construction process: data access, data cleaning, data modeling and data release are required, data are required to be processed in different systems, data warehouse construction is finished under the cooperation of a plurality of systems, data values are mined, and the data are used for application such as business intelligence.
In order to enable data to be orderly circulated and avoid data dependence confusion, an effective data organization and management method is required, so a data warehouse is usually constructed hierarchically. Generally, the Data storage device is divided into an ODS (Operational Data Store) layer, an STD (adjacency list) layer, a DW (Data Warehouse) layer, a DM (Data Mart) layer, and a DS (Data Service) layer. The table of ODS layer stores data accessed from data source, the table of STD layer stores data in conformity with standard specification, the DW layer stores various basic data model tables established according to theme, the DM layer stores complex data model table based on subject, and the table stored in DS layer provides data for various applications directly.
The data relationship display method provided by the invention is explained in detail by the following embodiments.
Fig. 1 is a diagram illustrating an example of data relationship provided by an embodiment of the present invention. As shown in fig. 1, in the present embodiment, the data blood relationship is shown by a tree structure, and each node in the tree structure is a data table.
As can be seen from fig. 1, the source data table of the data table dm _ a includes a data table a, a data table B, and a data table C, and the data table a, the data table B, and the data table C are all original service tables. The data table A is converted into a data table ods _ a, a data table std _ a, a data table tmp _ a1, a data table tmp _ a2, a data table dw _ a and a data table dm _ a in sequence through the processing link where the data table A is located; the data table B is sequentially converted into a data table ods _ B, a data table std _ B and a data table dm _ a through the processing link where the data table B is located; the data table C is converted into a data table ods _ C, a data table std _ d, a data table dw _ C and a data table dm _ a in sequence through the processing link where the data table C is located.
The data tables ODS _ a, ODS _ b and ODS _ c are data tables of an ODS layer, the data tables STD _ a, STD _ b, STD _ c and STD _ d are data tables of an STD (adjacent table) layer, the data tables TMP _ a1 and TMP _ a2 are data tables of a TMP (temporary table) layer, the data tables DW _ a and DW _ c are data tables of a DW layer, and the data tables DM _ a are data tables of a DM layer.
The tree structure shown in fig. 1 records the relationship between nodes in the data lineage.
The embodiment of the invention also provides another data relationship display mode.
Fig. 2 is a flowchart illustrating a data relationship display method according to an embodiment of the present invention.
As shown in fig. 2, the data relationship display method may include:
s201, according to the processing information of the data table processing link, obtaining the blood relationship among the data tables on the processing link, wherein each data table in the blood relationship is a node.
S202, determining the level information and the attribute information of the nodes according to the metadata information corresponding to each node in the blood relationship; the layer information is used for indicating the layer of the node, and the attribute information is used for indicating the attribute of the node.
S203, according to the level information and the attribute information of the nodes, carrying out aggregation processing on all the nodes in the blood relationship to obtain summarized blood relationship information; the blood-related information comprises a convergent point and a connection relation between the convergent points, and all nodes converged in the convergent point have the same level and the same attribute.
S204, displaying the blood relationship based on the level information of the nodes and the summary blood relationship information.
In application, the processing information of each processing service can be received through a special blood-related service, and the upstream data table and the downstream data table of each data table are found through analyzing the processing information of each processing link, so that a blood-related relationship of a full link is formed. The relationship of the blood relationship includes the blood relationship of table level and field level.
Taking the processing links of the data sources (ODS) -STD-DW) -DS as an example, after analyzing each processing information, finding out the data tables at each layer, and connecting the data tables according to the processing links to form the blood-related relationship of one link.
In actual processing, intermediate temporary tables, cross-level blooding borders, and data table inter-processing relationships in the same layer may occur.
For example, the data consanguinity of the process link of data table ods _ a in FIG. 1 is as follows:
source data Table A- - -ods _ a- - -std _ a- - -tmp _ a1- - -tmp _ a2- - -dw _ a- - -dm _ a
In the data context, the data tables tmp _ a1 and tmp _ a2 are intermediate temporary tables.
The data blooding relationships of the process links of data table ods _ b in FIG. 1 are as follows:
source data Table B- -ods _ B- -std _ B- -dm _ a
In the data context, the data table std _ b and the data table dm _ a are in a cross-layer context.
The data blooding relationships of the process links of data table ods _ c in FIG. 1 are as follows:
source data table C-ods _ C-std _ d-dw _ C-dm _ a
In the data context, the data table std _ c and the data table std _ d are in a data table processing relationship in the same layer.
If a common tree diagram (for example, fig. 1) is used to show the relationship of blood relationship, the relationship of blood relationship is relatively disordered and the specific hierarchical relationship cannot be identified. In order to make the display of the whole blood relationship clearer, the embodiment further processes the blood relationship obtained in step S201.
The data table at each node has corresponding metadata information, and the metadata information comprises a table name of the data table and data table attribute information, so that the hierarchy information and the attribute information of the node can be determined.
The hierarchy information may be, for example, an ODS layer (corresponding aggregation layer), an STD layer (corresponding department gate layer), a DW layer (corresponding topic layer), a DM layer (corresponding topic layer), a DS layer (corresponding application layer), a TMP layer (temporary layer), or the like.
The attribute information may include department information, subject information, application information, and the like.
In one example, the determining the hierarchy information and the attribute information of the node according to the metadata information corresponding to each node in the blood relationship may include:
determining the level information of the nodes according to the table names of the data tables corresponding to the nodes in the blood relationship;
and determining attribute information of the nodes according to the attribute information of the data table corresponding to each node in the blood relationship.
In one example, determining the hierarchical information of the node according to the table name of the data table corresponding to each node in the blood relationship may include:
searching a naming rule matched with the table name of the data table corresponding to the node;
extracting a layer identifier from the table name according to the naming rule;
and determining the level information of the node according to the level identification.
Wherein the naming convention for the table names of the data tables is known. When the naming convention for the table name is such that the table name includes the hierarchical identifier, the hierarchical identifier may be extracted from the table name, thereby determining the hierarchical information of the node where the data table is located.
For example, the naming rule for the table name of the data table is: the hierarchy identifies + connector + table name of the source data table. At this time, the table names of the data tables of the respective layers are as follows:
ODS layer: ods _
STD layer: std _
DW layer: dw _
And (3) a DM layer: dm
Temporary layer: tmp _
Wherein "", denotes a table name of the source data table, and "_" is a connector. The hierarchical identifier is obtained by stripping the table name and the connector of the source data table from the table name of the data table. The extraction rules may be set in a rule system of the data repository.
For example, in fig. 1, in the data table std _ b, b is the table name of the source data table, and "_" is the connector, the table name b and the connector "_" of the source data table are removed from the table name "std _ b" to obtain the hierarchical identifier "ods". Therefore, it can be determined that the hierarchy information of the node corresponding to the data table std _ b is: and an STD layer.
In the system, the corresponding relationship between the hierarchy identifier and the hierarchy may be stored in advance, so that the hierarchy corresponding to the hierarchy identifier may be obtained according to the corresponding relationship.
For example, the corresponding relationship between the hierarchy identifier and the hierarchy can be as shown in table 1.
TABLE 1
After the hierarchical information and the attribute information of the nodes are obtained, the present embodiment further performs aggregation processing on the nodes to obtain summarized blood-related information. The blood-level information comprises a convergent point and a connection relation between the convergent points, and all nodes converged in the convergent point have the same level and the same attribute.
In the aggregation process, the hierarchy of the nodes is further corresponding to the displayed hierarchy. The correspondence between the hierarchy of nodes (e.g., ODS layer) and the displayed hierarchy (e.g., aggregation layer) can be preset in the system, as shown in table 1, for example.
The process of aggregating the nodes of each hierarchy according to the attribute information may be as follows:
a) and the ODS layer corresponds to the convergence layer and does not perform convergence.
b) And the STD layer corresponds to the department door layer and gathers according to the department information of the table. Multiple std tables may be contained under each department.
c) And the DW layer corresponds to the theme layer and performs convergence according to the theme information. Each topic may contain a table of multiple DW layers.
d) And the DM layer corresponds to the thematic layer and gathers according to the thematic information. Each theme may contain a table of multiple DM layers.
e) And the DS layer corresponds to the application layer and converges according to the application of the external service. Each application may contain a table of multiple DS layers.
f) The TMP layer, which is temporary data, does not converge.
Fig. 3 is an exemplary diagram of a node aggregation result provided in the embodiment of the present invention. As shown in fig. 3, in the same layer, nodes are aggregated according to node attributes, so that a user can more intuitively know information included in the relationship of the blood relationship. After nodes (i.e., data tables) at a certain level are aggregated according to attributes, the blood-border links are merged to form aggregated blood borders, as shown by the solid lines added in fig. 4 with respect to fig. 3.
Fig. 4 is an exemplary diagram of a summary blood relationship provided by an embodiment of the invention. As shown in FIG. 4, ods _ a and ods _ b form a summary bloodline with department A; a summary blood margin is formed between the department A and the subjects B and C; subject B forms a summary bloodline with application 1 when DM layer is not shown; subject C formed a summary blood margin with application 1.
After the summary blood relationship is obtained, the blood relationship is displayed according to the hierarchy of the nodes and the summary blood relationship.
In one example, exposing the blood relationship based on the hierarchical information of the nodes and the aggregated blood relationship information may include:
setting a corresponding display area for each layer;
according to the level information of the nodes, the nodes are distributed to display areas corresponding to the levels of the nodes;
in each display area, if the node belongs to the convergent point, the convergent point to which the node belongs is displayed in the display area, and if the node does not belong to any convergent point, the node is displayed in the display area.
Wherein, the display area can be a lane, a ring area, etc. When the display area is an annular area, the display area may be a circular ring, but may also be an annular ring with other shapes, such as a polygon.
In the embodiment, the nodes of different levels are displayed in different display areas, and the nodes of the same level are displayed in the same display area, so that a user can conveniently and quickly understand the hierarchical relationship of the nodes.
FIG. 5 is an exemplary illustration of a display interface at a local perspective of a blood-related relationship provided by an embodiment of the invention. As shown in fig. 5, fig. 5 shows the relationship of blood margins after pooling according to attributes. The blood relationship information of 4 levels of the collection layer, the department door bin, the theme layer and the application layer is displayed in a circular display area respectively. The blood relationship after the summary according to the attributes can be displayed among the layers, and the blood relationship is connected through a dotted line to display the whole blood relationship information. Meanwhile, the right side of the display interface of fig. 5 also provides summary display information of each layer. The information shown in fig. 5 is a part of the whole circle, the circle of each level is a part of the whole circle, and the circle can be flexibly dragged to search the designated node.
The display level can be controlled in the background according to the scene. For inter-level temporary tables, the presentation may be omitted.
In one example, the method may further comprise:
and displaying the statistical information of the layer corresponding to the selected display area according to the received selection operation information of the display area.
Fig. 6 is a diagram illustrating an example of displaying hierarchical statistical information according to an embodiment of the present invention. As shown in fig. 6, when the department store is selected, statistical information of the department store is displayed on the presentation interface.
The statistical information may include the number of attributes, the number of data tables, and the number of records included in the hierarchy corresponding to the selected presentation area.
In one example, the method may further comprise:
displaying the blood margin link information and/or statistical information corresponding to the selected convergent point according to the received selective operation information of the convergent point; and/or the presence of a gas in the gas,
and displaying the information of the blood relationship link corresponding to the selected node according to the received information of the selection operation of the node.
The selection operation information may be, for example, an operation of clicking a node name.
The present embodiments provide a way to view the node or aggregation point blood margin.
Fig. 7 is a diagram illustrating an example of viewing a result of a node according to an embodiment of the present invention. As shown in fig. 7, taking the "provincial broadcasting office" in the department store as an example, the upstream and downstream link information of the blood margin may be at different positions of the circle under the panoramic view or the partial view. When a department node of the provincial, broadcast and television bureau is selected by clicking, the information of the blood margin nodes of the upper and lower streams can be quickly acquired according to the department node, and the information is optimally displayed in the center of the circular ring. From the display result of fig. 7, it can be seen that the data tables of which aggregation layers are used by the provincial broadcasting and television bureau, and the data tables of the broadcasting and television bureau form which subjects, and each subject supports which applications of the application layer. Therefore, the display mode is closer to the service and is easier to understand by the user.
In one example, the method may further comprise:
and displaying a data table corresponding to each node converged by the convergent point and the information of the blood relationship link corresponding to the data table according to the received expansion operation information of the convergent point.
In application, a drop-down arrow may be set for each aggregation point, where the expansion operation information may be an operation of clicking the drop-down arrow corresponding to the aggregation point.
Fig. 8 is a diagram illustrating an example of the result of unfolding a rendezvous point according to an embodiment of the invention. As shown in fig. 8, when the drop-down arrow of the aggregation point "provincial broadcasting and television bureau" is clicked, the specific data table list under the "provincial broadcasting and television bureau" is expanded, and the blooding border link where the specific data table is located is displayed.
In one example, the method may further comprise:
and displaying the clicked node or the clicked convergence point in the central position of the display area according to the received clicking operation on the node or the received convergence point.
For example, the convergent point "provincial and electric power bureau" shown in fig. 7 may be located above or below the display area before being clicked, and when being clicked, the "provincial and electric power bureau" is displayed centrally, so that the user can conveniently view the information.
In one example, the method may further comprise:
under the condition that a display area corresponding to a target level is selected, searching a node or an aggregation point corresponding to search information in the display area corresponding to the target level according to the received search information;
and rotating the display area corresponding to the target hierarchy, and displaying the searched node or convergence point at the central position of the display area.
For example, in the case where the display area of the department store shown in fig. 6 is selected, when the search information "provincial hall" is input, the display area of the department store is rotated so that the convergence point of "provincial hall" is displayed at the center of the display area.
The method for displaying the data consanguinity relationship provided by the embodiment of the invention acquires the consanguinity relationship among the data tables on a processing link according to the processing information of the processing link of the data tables, wherein each data table in the consanguinity relationship is a node, the level information and the attribute information of the node are determined according to the metadata information corresponding to each node in the consanguinity relationship, the level information is used for indicating the level of the node, the attribute information is used for indicating the attribute of the node, the nodes in the consanguinity relationship are converged according to the level information and the attribute information of the node to obtain the summarized consanguinity information, the summarized consanguinity information comprises the connection relationship between a convergent point and a convergent point, the nodes converged in the convergent point have the same level and the same attribute, and the consanguinity relationship is displayed based on the level information of the node and the summarized consanguinity information, by processing the blood relationship information in a layering and attribute convergence manner, the data blood relationship can be displayed more clearly and intuitively, and convenience is provided for users.
Based on the above method embodiment, the embodiment of the present invention further provides corresponding apparatus, device, and storage medium embodiments. For detailed implementation of the embodiments of the apparatus, device and storage medium of the embodiments of the present invention, please refer to the corresponding descriptions in the foregoing method embodiments.
FIG. 9 is a block diagram of a data relationship display apparatus according to an embodiment of the present invention. As shown in fig. 9, in this embodiment, the data relationship display device may include:
an obtaining module 910, configured to obtain a blood-level relationship between data tables on a processing link according to processing information of the processing link of the data tables, where each data table in the blood-level relationship is a node;
a determining module 920, configured to determine level information and attribute information of a node according to metadata information corresponding to each node in the blood relationship; the layer information is used for indicating the layer of the node, and the attribute information is used for indicating the attribute of the node;
a convergence module 930, configured to perform convergence processing on each node in the blood relationship according to the level information and the attribute information of the node, to obtain summarized blood relationship information; the summarized blood relationship information comprises a convergent point and a connection relation between the convergent points, and all nodes converged in the convergent point have the same level and the same attribute;
a display module 940, configured to display the blood relationship based on the hierarchical information of the nodes and the collected blood relationship information.
In one example, the presentation module 940 may be specifically configured to:
setting a corresponding display area for each layer;
according to the level information of the nodes, the nodes are distributed to display areas corresponding to the levels of the nodes;
in each display area, if the node belongs to the convergent point, the convergent point to which the node belongs is displayed in the display area, and if the node does not belong to any convergent point, the node is displayed in the display area.
In one example, further comprising:
and the display area display module is used for displaying the statistical information of the layers corresponding to the selected display areas according to the received selection operation information of the display areas.
In one example, the statistical information includes the number of attributes, the number of data tables, and the number of records included in the hierarchy corresponding to the selected presentation area.
In one example, further comprising:
the convergent point display module is used for displaying the blood relationship link information and/or statistical information corresponding to the selected convergent point according to the received selective operation information of the convergent point;
and the node display module is used for displaying the information of the blood relationship link corresponding to the selected node according to the received selection operation information of the node.
In one example, further comprising:
and the convergent point expansion module is used for displaying a data table corresponding to each node converged by the convergent point and the blood relationship link information corresponding to the data table according to the received expansion operation information of the convergent point.
In one example, further comprising:
and the centering display module is used for displaying the clicked node or the clicked convergence point in the central position of the display area according to the received clicking operation on the node or the convergence point.
In one example, further comprising:
the searching module is used for searching a node or a convergent point corresponding to the searching information in the display area corresponding to the target level according to the received searching information under the condition that the display area corresponding to the target level is selected; and the display area is used for rotating the display area corresponding to the target hierarchy and displaying the searched node or the searched convergent point in the central position of the display area.
In an example, the metadata information includes a table name of the data table and data table attribute information, and the determining module 920 may be specifically configured to:
determining the level information of the nodes according to the table names of the data tables corresponding to the nodes in the blood relationship;
and determining attribute information of the nodes according to the attribute information of the data table corresponding to each node in the blood relationship.
The embodiment of the invention also provides the electronic equipment. Fig. 10 is a hardware configuration diagram of an electronic device according to an embodiment of the present invention. As shown in fig. 10, the electronic apparatus includes: an internal bus 1001, and a memory 1002, a processor 1003, and an external interface 1004 connected through the internal bus.
The processor 1003 is configured to read the machine-readable instructions on the memory 1002, and execute the instructions to implement the following operations:
acquiring a blood relationship among data tables on a processing link according to processing information of the processing link of the data tables, wherein each data table in the blood relationship is a node;
determining the level information and attribute information of the nodes according to the metadata information corresponding to each node in the blood relationship; the layer information is used for indicating the layer of the node, and the attribute information is used for indicating the attribute of the node;
according to the level information and the attribute information of the nodes, carrying out aggregation processing on all the nodes in the blood relationship to obtain summarized blood relationship information; the summarized blood relationship information comprises a convergent point and a connection relation between the convergent points, and all nodes converged in the convergent point have the same level and the same attribute;
and displaying the blood relationship based on the level information of the nodes and the summary blood relationship information.
In one example, the kindred relationship is exposed based on hierarchical information of nodes and the aggregated kindred information, including:
setting a corresponding display area for each layer;
according to the level information of the nodes, the nodes are distributed to display areas corresponding to the levels of the nodes;
in each display area, if the node belongs to the convergent point, the convergent point to which the node belongs is displayed in the display area, and if the node does not belong to any convergent point, the node is displayed in the display area.
In one example, further comprising:
and displaying the statistical information of the layer corresponding to the selected display area according to the received selection operation information of the display area.
In one example, the statistical information includes the number of attributes, the number of data tables, and the number of records included in the hierarchy corresponding to the selected presentation area.
In one example, further comprising:
displaying the blood margin link information and/or statistical information corresponding to the selected convergent point according to the received selective operation information of the convergent point; and/or the presence of a gas in the gas,
and displaying the information of the blood relationship link corresponding to the selected node according to the received information of the selection operation of the node.
In one example, further comprising:
and displaying a data table corresponding to each node converged by the convergent point and the information of the blood relationship link corresponding to the data table according to the received expansion operation information of the convergent point.
In one example, further comprising:
and displaying the clicked node or the clicked convergence point in the central position of the display area according to the received clicking operation on the node or the received convergence point.
In one example, further comprising:
under the condition that a display area corresponding to a target level is selected, searching a node or an aggregation point corresponding to search information in the display area corresponding to the target level according to the received search information;
and rotating the display area corresponding to the target hierarchy, and displaying the searched node or convergence point at the central position of the display area.
In one example, the metadata information includes a table name and data table attribute information of a data table, and determining hierarchy information and attribute information of a node according to the metadata information corresponding to each node in the blood relationship includes:
determining the level information of the nodes according to the table names of the data tables corresponding to the nodes in the blood relationship;
and determining attribute information of the nodes according to the attribute information of the data table corresponding to each node in the blood relationship.
An embodiment of the present invention further provides a computer-readable storage medium, where a plurality of computer instructions are stored on the computer-readable storage medium, and when executed, the computer instructions perform the following processing:
acquiring a blood relationship among data tables on a processing link according to processing information of the processing link of the data tables, wherein each data table in the blood relationship is a node;
determining the level information and attribute information of the nodes according to the metadata information corresponding to each node in the blood relationship; the layer information is used for indicating the layer of the node, and the attribute information is used for indicating the attribute of the node;
according to the level information and the attribute information of the nodes, carrying out aggregation processing on all the nodes in the blood relationship to obtain summarized blood relationship information; the summarized blood relationship information comprises a convergent point and a connection relation between the convergent points, and all nodes converged in the convergent point have the same level and the same attribute;
and displaying the blood relationship based on the level information of the nodes and the summary blood relationship information.
In one example, the kindred relationship is exposed based on hierarchical information of nodes and the aggregated kindred information, including:
setting a corresponding display area for each layer;
according to the level information of the nodes, the nodes are distributed to display areas corresponding to the levels of the nodes;
in each display area, if the node belongs to the convergent point, the convergent point to which the node belongs is displayed in the display area, and if the node does not belong to any convergent point, the node is displayed in the display area.
In one example, further comprising:
and displaying the statistical information of the layer corresponding to the selected display area according to the received selection operation information of the display area.
In one example, the statistical information includes the number of attributes, the number of data tables, and the number of records included in the hierarchy corresponding to the selected presentation area.
In one example, further comprising:
displaying the blood margin link information and/or statistical information corresponding to the selected convergent point according to the received selective operation information of the convergent point; and/or the presence of a gas in the gas,
and displaying the information of the blood relationship link corresponding to the selected node according to the received information of the selection operation of the node.
In one example, further comprising:
and displaying a data table corresponding to each node converged by the convergent point and the information of the blood relationship link corresponding to the data table according to the received expansion operation information of the convergent point.
In one example, further comprising:
and displaying the clicked node or the clicked convergence point in the central position of the display area according to the received clicking operation on the node or the received convergence point.
In one example, further comprising:
under the condition that a display area corresponding to a target level is selected, searching a node or an aggregation point corresponding to search information in the display area corresponding to the target level according to the received search information;
and rotating the display area corresponding to the target hierarchy, and displaying the searched node or convergence point at the central position of the display area.
In one example, the metadata information includes a table name and data table attribute information of a data table, and determining hierarchy information and attribute information of a node according to the metadata information corresponding to each node in the blood relationship includes:
determining the level information of the nodes according to the table names of the data tables corresponding to the nodes in the blood relationship;
and determining attribute information of the nodes according to the attribute information of the data table corresponding to each node in the blood relationship.
For the device and apparatus embodiments, as they correspond substantially to the method embodiments, reference may be made to the partial description of the method embodiments for relevant points. The above-described embodiments of the apparatus are merely illustrative, wherein the modules described as separate parts may or may not be physically separate, and the parts displayed as modules may or may not be physical modules, may be located in one place, or may be distributed on a plurality of network modules. Some or all of the modules can be selected according to actual needs to achieve the purpose of the solution in the specification. One of ordinary skill in the art can understand and implement it without inventive effort.
The foregoing description has been directed to specific embodiments of this disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may also be possible or may be advantageous.
Other embodiments of the present description will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This specification is intended to cover any variations, uses, or adaptations of the specification following, in general, the principles of the specification and including such departures from the present disclosure as come within known or customary practice within the art to which the specification pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the specification being indicated by the following claims.
It will be understood that the present description is not limited to the precise arrangements described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present description is limited only by the appended claims.
The above description is only a preferred embodiment of the present disclosure, and should not be taken as limiting the present disclosure, and any modifications, equivalents, improvements, etc. made within the spirit and principle of the present disclosure should be included in the scope of the present disclosure.
Claims (10)
1. A data blood relationship display method is characterized by comprising the following steps:
acquiring a blood relationship among data tables on a processing link according to processing information of the processing link of the data tables, wherein each data table in the blood relationship is a node;
determining the level information and attribute information of the nodes according to the metadata information corresponding to each node in the blood relationship; the layer information is used for indicating the layer of the node, and the attribute information is used for indicating the attribute of the node;
according to the level information and the attribute information of the nodes, carrying out aggregation processing on all the nodes in the blood relationship to obtain summarized blood relationship information; the summarized blood relationship information comprises a convergent point and a connection relation between the convergent points, and all nodes converged in the convergent point have the same level and the same attribute;
and displaying the blood relationship based on the level information of the nodes and the summary blood relationship information.
2. The method of claim 1, wherein presenting the consanguinity relationship based on hierarchical information of nodes and the aggregated consanguinity information comprises:
setting a corresponding display area for each layer;
according to the level information of the nodes, the nodes are distributed to display areas corresponding to the levels of the nodes;
in each display area, if the node belongs to the convergent point, the convergent point to which the node belongs is displayed in the display area, and if the node does not belong to any convergent point, the node is displayed in the display area.
3. The method of claim 2, further comprising:
and displaying the statistical information of the layer corresponding to the selected display area according to the received selection operation information of the display area.
4. The method of claim 3, wherein the statistical information comprises the number of attributes, the number of data tables, and the number of records included in the hierarchy corresponding to the selected presentation area.
5. The method of claim 2, further comprising:
displaying the blood margin link information and/or statistical information corresponding to the selected convergent point according to the received selective operation information of the convergent point; and/or the presence of a gas in the gas,
and displaying the information of the blood relationship link corresponding to the selected node according to the received information of the selection operation of the node.
6. The method of claim 2, further comprising:
and displaying a data table corresponding to each node converged by the convergent point and the information of the blood relationship link corresponding to the data table according to the received expansion operation information of the convergent point.
7. The method of claim 2, further comprising:
and displaying the clicked node or the clicked convergence point in the central position of the display area according to the received clicking operation on the node or the received convergence point.
8. The method of claim 2, further comprising:
under the condition that a display area corresponding to a target level is selected, searching a node or an aggregation point corresponding to search information in the display area corresponding to the target level according to the received search information;
and rotating the display area corresponding to the target hierarchy, and displaying the searched node or convergence point at the central position of the display area.
9. The method of claim 1, wherein the metadata information includes a table name and data table attribute information of a data table, and determining hierarchy information and attribute information of a node according to the metadata information corresponding to each node in the blood relationship comprises:
determining the level information of the nodes according to the table names of the data tables corresponding to the nodes in the blood relationship;
and determining attribute information of the nodes according to the attribute information of the data table corresponding to each node in the blood relationship.
10. A data relationship display device, the device comprising:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring the blood relationship among data tables on a processing link according to processing information of the processing link of the data tables, and each data table in the blood relationship is a node;
the determining module is used for determining the level information and the attribute information of the nodes according to the metadata information corresponding to each node in the blood relationship; the layer information is used for indicating the layer of the node, and the attribute information is used for indicating the attribute of the node;
the aggregation module is used for carrying out aggregation processing on each node in the blood relationship according to the level information and the attribute information of the node to obtain summarized blood relationship information; the summarized blood relationship information comprises a convergent point and a connection relation between the convergent points, and all nodes converged in the convergent point have the same level and the same attribute;
and the display module is used for displaying the blood relationship based on the level information of the nodes and the collected blood relationship information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110343323.0A CN113282678B (en) | 2021-03-30 | 2021-03-30 | Data blood relationship display method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110343323.0A CN113282678B (en) | 2021-03-30 | 2021-03-30 | Data blood relationship display method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113282678A true CN113282678A (en) | 2021-08-20 |
| CN113282678B CN113282678B (en) | 2024-01-02 |
Family
ID=77276106
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110343323.0A Active CN113282678B (en) | 2021-03-30 | 2021-03-30 | Data blood relationship display method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113282678B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113760866A (en) * | 2021-08-30 | 2021-12-07 | 中国铁道科学研究院集团有限公司电子计算技术研究所 | Modeling assistance device and method |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20020008084A (en) * | 2000-07-19 | 2002-01-29 | 김성수 | Biological Blood-Relation Retrieving System Using Genome Information and Method the same |
| US6965903B1 (en) * | 2002-05-07 | 2005-11-15 | Oracle International Corporation | Techniques for managing hierarchical data with link attributes in a relational database |
| KR20090022519A (en) * | 2007-08-30 | 2009-03-04 | 김정태 | Service system of genealogical table using internet and method thereof |
| US9613086B1 (en) * | 2014-08-15 | 2017-04-04 | Tableau Software, Inc. | Graphical user interface for generating and displaying data visualizations that use relationships |
| CN107463555A (en) * | 2016-06-01 | 2017-12-12 | 北京京东尚科信息技术有限公司 | The mthods, systems and devices of layer data among deleting |
| US20190340272A1 (en) * | 2018-05-02 | 2019-11-07 | doTERRA Holdings, LLC | Systems and related methods for updating attributes of nodes and links in a hierarchical data structure |
| CN110807026A (en) * | 2019-10-24 | 2020-02-18 | 北京中科捷信信息技术有限公司 | Automatic capture system for analyzing financial big data blood relationship |
| CN111639143A (en) * | 2020-06-05 | 2020-09-08 | 广州市玄武无线科技股份有限公司 | Data blood relationship display method and device of data warehouse and electronic equipment |
| CN111767320A (en) * | 2020-06-29 | 2020-10-13 | 中国银行股份有限公司 | Data blood relationship determination method and device |
| CN112328575A (en) * | 2020-11-12 | 2021-02-05 | 杭州数梦工场科技有限公司 | Data asset blood margin generation method and device and electronic equipment |
| CN112487045A (en) * | 2020-10-20 | 2021-03-12 | 广西盛源行大数据科技有限公司 | Management platform based on big data |
-
2021
- 2021-03-30 CN CN202110343323.0A patent/CN113282678B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20020008084A (en) * | 2000-07-19 | 2002-01-29 | 김성수 | Biological Blood-Relation Retrieving System Using Genome Information and Method the same |
| US6965903B1 (en) * | 2002-05-07 | 2005-11-15 | Oracle International Corporation | Techniques for managing hierarchical data with link attributes in a relational database |
| KR20090022519A (en) * | 2007-08-30 | 2009-03-04 | 김정태 | Service system of genealogical table using internet and method thereof |
| US9613086B1 (en) * | 2014-08-15 | 2017-04-04 | Tableau Software, Inc. | Graphical user interface for generating and displaying data visualizations that use relationships |
| CN107463555A (en) * | 2016-06-01 | 2017-12-12 | 北京京东尚科信息技术有限公司 | The mthods, systems and devices of layer data among deleting |
| US20190340272A1 (en) * | 2018-05-02 | 2019-11-07 | doTERRA Holdings, LLC | Systems and related methods for updating attributes of nodes and links in a hierarchical data structure |
| CN110807026A (en) * | 2019-10-24 | 2020-02-18 | 北京中科捷信信息技术有限公司 | Automatic capture system for analyzing financial big data blood relationship |
| CN111639143A (en) * | 2020-06-05 | 2020-09-08 | 广州市玄武无线科技股份有限公司 | Data blood relationship display method and device of data warehouse and electronic equipment |
| CN111767320A (en) * | 2020-06-29 | 2020-10-13 | 中国银行股份有限公司 | Data blood relationship determination method and device |
| CN112487045A (en) * | 2020-10-20 | 2021-03-12 | 广西盛源行大数据科技有限公司 | Management platform based on big data |
| CN112328575A (en) * | 2020-11-12 | 2021-02-05 | 杭州数梦工场科技有限公司 | Data asset blood margin generation method and device and electronic equipment |
Non-Patent Citations (2)
| Title |
|---|
| E.SUTJIREDJEKI ET AL.: "Blood Vessel Age Prediction Using Photoplethysmography Signal Analysis Method", 2018 INTERNATIONAL CONFERENCE ON APPLIED SCIENCE AND TECHNOLOGY (ICAST), pages 744 - 749 * |
| 李旭风;罗强;: "面向数据字段的血缘关系分析", 中国金融电脑, no. 07, pages 14 - 21 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113760866A (en) * | 2021-08-30 | 2021-12-07 | 中国铁道科学研究院集团有限公司电子计算技术研究所 | Modeling assistance device and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113282678B (en) | 2024-01-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9323855B2 (en) | Processing media items in location-based groups | |
| KR100371513B1 (en) | Method and apparatus of summerizing and browsing video sequences using fidelity values of key frame stored in its edge of key frame hierarchy | |
| CN101510205B (en) | Method for implementing automatically clustering photographs, apparatus and system | |
| US20100169326A1 (en) | Method, apparatus and computer program product for providing analysis and visualization of content items association | |
| CN111931097B (en) | Information display method and device, electronic equipment and storage medium | |
| CN103827852B (en) | Assemble WEB page on search engine results page | |
| CN106294481B (en) | A kind of air navigation aid and device based on map | |
| CN108563792B (en) | Image retrieval processing method, server, client and storage medium | |
| CN108287889B (en) | A kind of multi-source heterogeneous date storage method and system based on elastic table model | |
| EP3098726A1 (en) | Method for extracting useful content from setup files of mobile applications | |
| CN101322122A (en) | System and method for presenting content to a user | |
| EP3249557B1 (en) | Computer implemented and computer controlled method, computer program product and platform for arranging data for processing and storage at a data storage engine | |
| JP2002259410A (en) | Object classification and management method, object classification and management system, object classification and management program and recording medium | |
| CN110442585B (en) | Data updating method, data updating device, computer equipment and storage medium | |
| CN113779416B (en) | Information recommendation method and device, electronic equipment and computer-readable storage medium | |
| CN113282678B (en) | Data blood relationship display method and device | |
| CN112559913B (en) | Data processing method, device, computing equipment and readable storage medium | |
| CN109612465A (en) | A kind of method, apparatus and its application creating personal scene various dimensions characteristic spectrum | |
| CN101339568A (en) | Method and device for constructing data tree | |
| CN107291875B (en) | Metadata organization management method and system based on metadata graph | |
| CN111160699A (en) | Expert recommendation method and system | |
| JP6263870B2 (en) | Method for determining order relation of teaching materials, learning support system, apparatus for determining order relation of teaching materials, terminal device, and program | |
| CN109597942B (en) | Method, device and equipment for pushing showcase information and storage medium | |
| CN112860725A (en) | SQL automatic generation method and device, storage medium and electronic equipment | |
| Alamdar et al. | Effective browsing of image search results via diversified visual summarization by clustering and refining clusters |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |