Visual display method and device for data processing logic, equipment, medium and product

Abstract

The invention discloses a visual display method and device for data processing logic, equipment, a medium and a product. The method comprises the steps of obtaining a data processing logic request query instruction; according to the data processing logic request query instruction, determining a processing logic relationship of the queried target table; generating a data processing logic link diagram according to the processing logic relationship and a preset table node object attribute; in response to an operation of highlighting a processing link of any target field in the processing logic link diagram, recursively searching a field having data correlation with the target field, and for a data correlation field outside a table node visual area, adjusting the data correlation field into the table node visual area in a window sliding mode, and dynamically displaying the data processing logic relationship of the target field. According to the visual display method, a user can know the source and the destination of the data more clearly and conveniently, and the monitoring of the data stream is enhanced.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method, device, equipment, medium and product for visually displaying data processing logic. Background Art

[0002] In the information age, enterprises generate massive amounts of data constantly. This source data is cleansed, converted, processed, and combined to form derivative data for business departments to analyze and process. When analyzing derived data, if data quality issues arise, it's crucial to quickly clarify the source system, processing process, and flow system of the derived data, and establish a logical data processing chain. This allows for rapid tracking and location of the cause of the anomaly, enabling timely response and resolution.

[0003] Currently, general data table processing logic is only displayed at the table level, not at the field level, and cannot display the interdependencies between field levels. However, for data table processing logic displayed at the field level, the height of the data table node depends on the number of fields in the data table, resulting in uneven heights of data table nodes on the page, insufficient interface aesthetics, and a less than friendly user experience. Generally, the number of fields in a data table is related to specific business needs. In some complex business scenarios, the number of fields in a data table may reach dozens or even hundreds. The more fields there are, the higher the height of the data table node, and the fewer table nodes that can be displayed in the browser viewport. The visualization effect of the data processing logic link is not ideal, and the data asset visualization efficiency is not high. Summary of the Invention

[0004] The present invention provides a method, device, equipment, medium and product for visual display of data processing logic to realize visualization of processing logic links.

[0005] According to a first aspect of the present invention, a method for visually displaying data processing logic is provided, comprising:

[0006] Get data processing logic request query instructions;

[0007] Determining the processing logic relationship of the queried target table according to the data processing logic request query instruction;

[0008] Generate a data processing logic link diagram based on the processing logic relationship and preset table node object attributes;

[0009] In response to the operation of highlighting any target field processing link in the processing logic link diagram, recursively search for fields that have data correlation with the target field, and for data correlation fields that are outside the visible area of ​​the table node, adjust the data correlation fields to the visible area of ​​the table node through window sliding.

[0010] According to a second aspect of the present invention, there is provided a device for visually displaying data processing logic, comprising:

[0011] Instruction acquisition module, used to obtain data processing logic request query instructions;

[0012] A relationship determination module, configured to determine the processing logic relationship of the queried target table according to the data processing logic request query instruction;

[0013] A link diagram generation module, configured to generate a data processing logic link diagram based on the processing logic relationship and the preset table node object attributes;

[0014] A display adjustment module is used to respond to the operation of highlighting any target field processing link in the processing logic link diagram, recursively search for fields that have data correlation with the target field, and adjust the data correlation fields outside the visible area of ​​the table node into the visible area of ​​the table node through window sliding.

[0015] According to a third aspect of the present invention, there is provided an electronic device, comprising:

[0016] at least one processor; and

[0017] a memory communicatively connected to the at least one processor; wherein,

[0018] The memory stores a computer program that can be executed by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the method for visual display of data processing logic described in any embodiment of the present invention.

[0019] According to a fourth aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the visual display method of the data processing logic described in any embodiment of the present invention when executed.

[0020] According to the fifth aspect of the present invention, an embodiment of the present invention further provides a computer program product, which includes a computer program. When the computer program is executed by a processor, it implements the visual display method of the data processing logic of any embodiment of the present invention.

[0021] The technical solution of the embodiment of the present invention is to obtain a data processing logic request query instruction; determine the processing logic relationship of the queried target table according to the data processing logic request query instruction; generate a data processing logic link diagram according to the processing logic relationship and the preset table node object attributes; in response to the operation of highlighting the processing link of any target field in the processing logic link diagram, recursively search for fields that have data correlation with the target field, and adjust the data correlation fields outside the visible area of ​​the table node to the visible area of ​​the table node by sliding the window. The present invention converts the processing logic relationship of the target table obtained by the data processing logic request query instruction into a dependency relationship between table node objects, and provides a visual display for the fields of the table node objects by designing the visible area of ​​the table node objects, thereby limiting the fields of the table node objects to scroll within the visible area of ​​the table node, solving the problems of uneven height of the table node objects and insufficient interface aesthetics, and intuitively displaying the data processing logic relationship of the selected fields. On the one hand, it is convenient for users to more clearly understand the source and destination of the data and strengthen their monitoring of the data flow. On the other hand, it is convenient for users to quickly track and locate the cause of the abnormality and respond in time to solve the problem.

[0022] It should be understood that the content described in this section is not intended to identify the key or important features of the embodiments of the present invention, nor is it intended to limit the scope of the present invention. Other features of the present invention will become readily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0024] Figure 1 This is a flowchart of a method for visually displaying data processing logic according to the first embodiment of the present invention;

[0025] Figure 2 This is an example diagram of a table node object including a status attribute icon according to a method for visually displaying data processing logic provided in the first embodiment of the present invention;

[0026] Figure 3 This is an example diagram of a table node object in a method for visually displaying data processing logic provided in the first embodiment of the present invention;

[0027] Figure 4 This is a schematic diagram of a data processing logic link diagram before highlighting in a method for visually displaying data processing logic provided in Embodiment 1 of the present invention;

[0028] Figure 5 This is a schematic diagram of a highlighted data processing logic link diagram in a method for visually displaying data processing logic provided in Example 1 of the present invention;

[0029] Figure 6 This is a structural diagram of a visual display device for data processing logic provided according to the second embodiment of the present invention;

[0030] Figure 7 It is a schematic structural diagram of an electronic device implementing an embodiment of the present invention. DETAILED DESCRIPTION

[0031] In order to enable those skilled in the art to better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the embodiments described are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts should fall within the scope of protection of the present invention.

[0032] It should be noted that the terms "first", "second", etc. in the description and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that the numbers used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions. For example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0033] Example 1

[0034] Figure 1 A flowchart of a method for visually displaying data processing logic is provided for the first embodiment of the present invention. This embodiment is applicable to visual display of data processing logic. The method can be executed by a visual display device for data processing logic. The visual display device for data processing logic can be implemented in the form of hardware and / or software. The visual display device for data processing logic can be configured in an electronic device. Figure 1 As shown, the method includes:

[0035] S110: Obtain a data processing logic request query instruction.

[0036] In this embodiment, the data processing logic request query instruction can be understood as a request for querying the processing logic of a derived data table. In actual business scenarios, the processing logic of derived data tables is very complex. For example, in a simple scenario, data table A is processed to generate data table B, which is then combined with another data table C to form data table D. Table D mentioned in the above process is the derived data table described in this invention, and the data processing logic request query instruction queries the processing logic of the derived table.

[0037] Specifically, the processor can obtain the data processing logic request query instruction input by relevant personnel, and achieve the purpose of data query by providing certain query conditions, where the query conditions can be table name, database name, field name and data date, etc.

[0038] S120: Determine the processing logic relationship of the queried target table according to the data processing logic request query instruction.

[0039] In this embodiment, the processing logic relationship includes the source table and intermediate table required to generate the target table, as well as the data dependency relationship formed between the tables.

[0040] In this embodiment, the target table can be understood as the data table to be queried. The processing logic relationship can be understood as the logical relationship that characterizes how the target table is constructed, including the data dependency relationship between the target table and other tables. Among them, other tables can be understood as the data tables required to jointly constitute the target table, such as data table A, data table B, and data table C described in the above scenario. The data dependency relationship represents the relationship between different data generated due to business processing needs during the data circulation life cycle, such as the data tables A, B, C, and D in the above scenario.

[0041] Specifically, the processor can filter the data processing logic relationship of the target table that meets the query conditions according to the query conditions in the data processing logic request query instruction, for example, by filtering by the table name, database name, field name and data date of the target table.

[0042] For example, in the logical relationship of data processing, the information to be displayed is based on a table node object (i.e., a table) as a unit, and its attribute information mainly includes the node name (i.e., the table name) and node attributes (i.e., the field name, field type, and field description). The relationship between different table node attributes is indicated by arrows to indicate the direction of the data.

[0043] S130: Generate a data processing logic link diagram based on the processing logic relationship and preset table node object attributes.

[0044] In this embodiment, the data processing logic link diagram includes table node objects generated by each table and the dependency relationships between table node objects. The table node objects include the table node status and the visible area of ​​the table node objects determined by the table node width and height.

[0045] In this embodiment, the preset table node object properties can be understood as providing the viewport size of the table node object. The viewport represents the currently visible computer graphics area. In a web browser, it is usually the same as the browser window, that is, the part of the document that the user is browsing. A web browser contains two viewports, a layout viewport and a visual viewport. The visual viewport refers to the part that is currently visible in the browser and can change. The visual viewport does not include the on-screen keyboard and the area outside the zoom. It is the currently visible part of the layout viewport. If you scroll down, the content of the visual viewport will change, and the bottom of the layout viewport will scroll to the visible area. The table node object can be understood as a data table node, and the dependency relationship between table node objects can be understood as the dependency relationship between the various fields in different table node objects. The table node visible area can be understood as a viewport determined by the width of the table node object and the height of the node object, which is used to display a certain number of table node object fields.

[0046] Specifically, the processor can generate table node objects for each data table based on the processing logic relationship and preset table node object properties, and connect the fields of each table node object according to the dependency relationship between the table node objects to obtain a data processing logic link diagram.

[0047] S140. In response to the operation of highlighting any target field processing link in the processing logic link diagram, recursively search for fields that have data correlation with the target field, and for data correlation fields that are outside the visible area of ​​the table node, adjust the data correlation fields to the visible area of ​​the table node through window sliding.

[0048] In this embodiment, the target field can be understood as the field selected for the highlighted processing link operation. In the processing logic link diagram, not all fields of the table node object can be fully displayed within the visible area of ​​the table node object. For fields outside the visible area of ​​the table node object, a vertical scroll bar must be set for the table node object to support triggering scrolling through all fields. The viewport formed by the node visible area is called the window described in the present invention, and the window size is determined by the width and height of the table node object.

[0049] The vertical scroll bar allows for scrolling fields, which can be understood as updating the starting index of the visible field array to create a sliding effect within the visible area window, thus updating the visible fields within the table node object. Data dependency fields are fields that have a dependency relationship with the target field.

[0050] Specifically, in response to an operation to highlight any target field processing link in the processing logic link diagram, the dependency processor can recursively search for table node objects, fields, and edges with data dependencies, and set highlight attributes for each of the data-dependent table node objects, data-dependent fields, and data-dependent edges. For data-dependent fields outside the visible area of ​​the table node, the window is slid to adjust the data-dependent fields into the visible area of ​​the table node, and the entire link with data dependencies to the target field is highlighted, thereby dynamically displaying the data processing logic relationship of the target field.

[0051] The technical solution of the embodiment of the present invention limits the scrolling display of all fields of the table node object to the visible area, solving the problems of uneven heights of table node objects and insufficient interface aesthetics, and intuitively displays the data processing logical relationship of the target field. On the one hand, it is convenient for users to clearly understand the source and destination of the data and strengthen their monitoring of the data flow. On the other hand, it is convenient for users to quickly track and locate the cause of the abnormality and respond in time to solve the problem.

[0052] As a first optional embodiment of the first embodiment, based on the above embodiment, it further includes:

[0053] Obtain a version comparison request for the data processing logic, obtain table node object status information and edge status information based on the version comparison request, and generate a version comparison graph.

[0054] In this embodiment, the version comparison request can be understood as a request issued to obtain changes in the processing logic of the query table within a specified time range. The table node object state information can be understood as information about changes in the processing logic of the table node object within a specified time range, for example, it can include the state of the table node object (table) and the state of the attributes (fields). The edge state information can be understood as the state of the dependency relationship between the specified table node objects within a specified time range. The state value corresponding to the state information can include: added, deleted, modified, or unchanged. For example, in the data processing logic version comparison, the table node state is modified, which can indicate that the basic attribute information of the table (the Chinese name, description, etc. of the table) has been modified. It may also indicate that the fields of the table have been added, modified, or deleted. The table node state is added, indicating that the data table has been added to the data processing logic link, and the states of its fields are all added. The table node state is deleted, indicating that the data table has been deleted from the data processing logic link, and the states of its fields are all deleted. Similarly, an edge status value of Modified indicates that the edge's basic attributes (such as location, width, and description) have been modified. An edge status value of Added or Deleted indicates a new or deleted dependency, respectively. An Unchanged state for a table node or edge indicates that the dependencies between the table node and its fields or table node objects have not changed within the specified timeframe. A version comparison chart can be understood as a version comparison display composed of status attribute icons.

[0055] Specifically, the processor can determine the table node state information and edge state information to be queried based on the version comparison request, where both the table node state information and the edge state information are represented by state values. Based on the table node state information and the edge state information, the processor can determine the state attribute icon corresponding to the state value, such as using a plus sign to represent addition and a minus sign to represent deletion, and add the state attribute icon to the corresponding position in the corresponding table node object. The processor then establishes a display association between the detailed content of the change and the state attribute icon to obtain a version comparison chart.

[0056] For example, a specific example is used as an example. Figure 2 This is an example diagram of a table node object containing a status attribute icon in a method for visually displaying data processing logic provided by the first embodiment of the present invention, such as Figure 2 As shown in the figure, in a table node object, column0-column5 are the six fields displayed in the visible area of ​​the table node. The status attribute icon after column1 indicates addition, the status attribute icon after column2 indicates modification, and the status attribute icon after column3 indicates deletion.

[0057] Furthermore, after generating the version comparison chart, the following steps are also included:

[0058] In response to a click operation on a table node object or a field status attribute icon in the table node object in the version comparison diagram, all change records of the object corresponding to the status attribute icon are displayed.

[0059] In this embodiment, the status attribute icon can be understood as an icon used to represent the change method. The change record can be understood as a record used to describe how the modification was performed, for example, including information such as the change time, the changer, and the change content.

[0060] Specifically, in response to a click operation on a table node object or a field status attribute icon of a table node object in a version comparison diagram, the processor can determine all change records associated with the status attribute icon and display all change records of the object corresponding to the status attribute icon in a visual manner.

[0061] In a first optional embodiment of the first embodiment, by visually displaying the version comparison of the data processing logic and directly marking the status attributes of the table nodes, fields and edges on the visualization diagram, the user can intuitively understand the changes and differences in the data processing logic.

[0062] Furthermore, based on the above embodiment, the steps of generating a data processing logic link diagram according to the processing logic relationship and the preset table node object attributes can be refined as follows:

[0063] Generate an initial table node object according to the preset table node object properties; for each table node object in the processing logic relationship, if the total number of fields of the table node object exceeds the total number of fields that can be displayed in the table node's visible area, set a vertical scroll bar for the table node object to support triggering scrolling through all fields; otherwise, no vertical scroll bar is set, and all fields are displayed directly; the fields displayed in the visible area of ​​the table node object constitute a visible field array; for table node objects that do not have a vertical scroll bar set, the subscript interval of their visible field array is [0, the length of the table node object's field array - 1]; for table node objects that have a vertical scroll bar set, the subscript interval of their visible field array is initially [0, the length of the table node object's field array - 1]. Number of fields - 1], when the scrolling of the fields of the table node object is triggered, the subscript interval of the visible field array is updated; the visible field array is a subset of the field array in the table node object, and the visible fields in the visible interval of the table node object are updated based on the viewport size of the table node object and the window scrolling method; according to the above rules, the field information is filled into the node visible area of ​​the initial table node object, and the table information is filled into the specified position of the initial table node object to obtain the table node object; according to the processing logic relationship, the dependency relationship between the table node object and other table node objects is determined; according to the dependency relationship between the table node object and other table node objects, a data processing logic link diagram is generated.

[0064] In this embodiment, the viewport determined by the width and height of the table node object is called the visible area of ​​the table node object. The table node object includes the table node width w node And table node height h node , table node title height h head , table node bottom height h foot , the height of a single field in the table node h column and the overall field height h body And the columns attribute of the field array contained in the table node (such as field names, etc.). The initial table node object can be understood as a table node object that has not been filled with content. The total number of displayable fields can be understood as the total number of fields displayed in the table node object. Due to the size limit of the table node object, it may not be possible to display all fields. The total number of displayable fields is the maximum number of fields that can be displayed at one time, for example, 6. The total number of fields can be understood as the total number of fields contained in a table, for example, 20. Different tables have the same or different total number of fields. The specified position can be understood as the corresponding position, for example, the table name is filled in the table node title position, and the field name in the field attribute is filled in the field position. The visible field array can be understood as the fields displayed in the visible area of ​​the table node. Initially, the starting subscript of the visible field array, that is, the subscript of the first field in the visible area of ​​the table node, is 0. After the fields of the table node object are scrolled vertically using the vertical scroll bar, the starting subscript of the visible field array changes accordingly.

[0065] Specifically, the processor can generate an initial table node object based on the viewport size information of the preset table node object. node For each table in the processing logic relationship, the processor can compare the total number of displayable fields and the total number of fields in the preset table node object properties. When the total number of fields does not exceed the total number of displayable fields (using the above expression n view =(h node -h head -h foot ) / h column , the total number of fields is n total , that is, n total <=n view When , the display mode of the table node object is determined to be the display mode of all fields; when the total number of fields of the table node is n total Exceeds the number of fields that can be displayed in the table node object (n view =(h node -h head -h foot ) / h column , that is, n total >nview ), the processor can set a vertical scroll bar for the table node object to support triggering scrolling through all fields in the table node object. The fields displayed in the visible area of ​​the table node constitute a visible field array; for a table node object without a vertical scroll bar, the subscript interval of its visible field array is [0, the length of the field array of the table node object - 1]; for a table node object with a vertical scroll bar, the subscript interval of its visible field array is initially [0, the number of visible fields - 1]. When the field of the table node object is triggered to scroll through, the subscript interval of the visible field array is updated; the visible field array is a subset of the field array in the table node object. Based on the viewport size of the table node object and the window scrolling method, the visible fields within the visible interval of the table node object are updated; according to the above rules, the processor can fill the field information into the visible area of ​​the initial table node object, and fill the content of the data table information into the specified position of the initial table node object to obtain a table node object; based on the data dependency relationship, determine the table node status and the dependency relationship with other table nodes; based on each table node object and the dependency relationship between each table node object, generate a data processing logic link diagram.

[0066] For example, calculate the starting subscript startIndex, and then extract the specified number n starting from the startIndex subscript in the field array columns view The subarray is then displayed in the table node's visible area. This subarray is called the visible field array. Initially, the visible field array displays the columns with subscripts [0 to n view -1], where the initial value of startIndex is 0. After the scroll bar slides, the subscript range of the visible field array columns is [startIndex~startIndex+n view -1], where startIndex>=0.

[0067] Among them, it can also include the expansion / collapse function of the table node. When the table node field is expanded, the field-level data processing logical relationship is displayed; when the table node field is collapsed, the table-level data processing logical relationship is displayed.

[0068] For example, using a specific example as a demonstration, Figure 3 This is an example diagram of a table node object in a method for visually displaying data processing logic provided in the second embodiment of the present invention, such as Figure 3 As shown, the table node width is W node And the table node height is h node , the table node title height is h head , table node bottom height h foot , the height of a single field in the table node hcolumn and the overall field height h body As well as the field array columns attribute (such as field names, etc.) contained in the table node. The tableName at the top of the figure is the table name corresponding to the table node. The middle part of the table node object is the table node visual area, which displays the field attributes column0-column5, a total of 6 items.

[0069] Furthermore, based on the above embodiment, in response to the operation of highlighting any target field processing link in the processing logic link diagram, the steps of recursively searching for fields that have data correlation with the target field and adjusting the data correlation fields outside the visible area of ​​the table node to the visible area of ​​the table node by window sliding can be refined as follows:

[0070] Obtain the unique identifier of the target field and the target table node object to which the target field belongs, and set the highlight attribute for the target field and the target table node object to which the target field belongs; determine the table node array object that has data correlation with the target field based on the dependency relationship between the table node object and other table node objects; traverse the table node array object that has data correlation, recursively search for table node objects, fields, and edges that have data correlation with it, and set the highlight attribute for each table node object that has data correlation, data correlation field, and each data correlation edge; when highlighting the processing link of the target field, determine the visible field array within the visible area of ​​the table node object based on the table node object that has data correlation, and obtain the index of the data correlation field in the field array of the corresponding table node object; if the data correlation field index is within the subscript range of the visible field array, no processing is performed; if the data correlation field index is outside the subscript range of the visible field array, update the starting subscript of the visible field array to adjust the data correlation field to the visible area of ​​the table node; redraw the target object with the highlight attribute to achieve highlighted display of the target field processing link.

[0071] In this embodiment, the highlight operation can be understood as an operation for highlighting, such as the selection of a field triggered by moving the mouse in or clicking the mouse, and the selected field is called the target field. The existence of a data dependency field can be understood as a field that has a dependency relationship with the target field. The unique identifier of the target field can be understood as the unique identifier set for each field when generating the data processing logical link diagram. The target table node object can be understood as the table node object to which the target field belongs. The existence of a data dependency edge can be understood as a line used to connect data dependency fields and data dependency table nodes. The highlight attribute is used to indicate whether to perform highlighting when drawing the data processing logical link diagram.

[0072] In this paper, data dependency refers to the dependency relationship between data. For example, if field col1 in table A is derived from field col2 in table B, a data dependency relationship exists between the two tables. Table B, which is dependent on field col1 in table A, is called a data dependency table. Field col2, which is dependent on field col1 in table A, is called a data dependency field. The edge between field col1 and field col2 is called a data dependency edge.

[0073] Specifically, in response to the highlighting operation of the relative data processing logic link diagram, the processor can obtain the unique identifier of the target field and the target table node object to which the target field belongs, and set the highlight attribute of the target field and the target table node object to which the target field belongs; determine the table node array object that has data correlation with the target field based on the dependency relationship between the table node object and other table node objects; traverse the table node array object that has data correlation, recursively search for the table node objects, fields and edges that have data correlation with it, and highlight the attributes of each table node object that has data correlation, data correlation field and each data correlation edge. Property setting; when highlighting the processing link of the target field, determine the visible field array in the visible area of ​​the table node object according to the table node object with data correlation, and obtain the index of the data correlation field in the field array of the corresponding table node object. If the data correlation field index is within the subscript range of the visible field array, no processing is performed; if the data correlation field index is outside the subscript range of the visible field array, the data correlation field is adjusted to the visible area of ​​the table node by updating the starting subscript in the visible field array; redraw the target object with the highlight attribute to realize the highlighting of the target field processing link.

[0074] The present invention adjusts the data-related fields to the visible area of ​​the table node by sliding the window. Exemplarily, (1) the user selects the target field, and the processor can obtain the unique identifier key of the selected current field (i.e., the target field) and the target table node object node to which it belongs, and add the current field unique identifier key to the array keys to be highlighted; (2) according to the target table node object node, the unique identifier id of the target table node object, the highlight attribute array lightKeyArr, and the edge set edges of the table node are obtained, and then the array keys to be highlighted are merged into the table node highlight attribute array lightKeyArr; define the data-related table node array object neighbors of the field, which is used to store the table nodes related to the field data and the field array to be highlighted of the table node; (3) calculate the index index of the first element in lightKeyArr in the field array columns, and obtain the starting subscript startIndex of the visible area of ​​the current table node; (4) determine whether the current field is in the visible area of ​​the table node, that is, determine whether the index index of the current field meets the condition index>=startIndex and index<=startIndex+n view -1; (5) If the above conditions are met, it means that the field is in the visible area of ​​the table node and there is no need to update the start index startIndex; otherwise, it means that the field is not in the table node object and the start index needs to be updated. If index>startIndex+n view -1, the starting index is updated to startIndex←index-(n view-1); if index<startIndex, then update the starting subscript to startIndex←index; (6) redraw the current table node, realize the highlighting of data-related fields according to the highlight attribute array lightKeyArr of the table node, and optimize the display of the fields in the visible area according to startIndex; (7) traverse the edge set edges of the table node, obtain its highlight attribute light, source table node source, source field sourceKey and target table node target, target field targetKey through edge edge; if the highlight attribute light value of edge edge is false, find the target node with the unique identifier id of the current table node object and the unique identifier key of the field as the source table node and source field Table node, target field, add the found target table node and target field to the array object neighbors, set the edge highlight attribute light to true, and then redraw this edge; or, find the source table node and source field with the unique identifier id of the current table node object and the unique identifier key of the field as the target table node and target field, add the found source table node and source field to the array object neighbors, set the edge highlight attribute light to true, and then redraw this edge; (8) traverse the data dependency field array object neighbors, obtain the associated table node and its highlight attribute array lightKeyArr, and then repeat steps (2)-(7), recursively find the data dependency table node and edge and highlight them.

[0075] In the window sliding method described above, the various data-related fields of the target field can be adjusted to the visible area of ​​each table node object to which they belong without the user manually triggering the scrolling display of the various table node object fields in the data processing logic link diagram. The calculation method is based on the viewport size of the table node object, and automatically calculates the minimum distance that the visual window of each table node object needs to slide before its related fields can be adjusted to the visible area of ​​the table node object. Depending on actual needs, the sliding direction of the visual window can be upward or downward. When implementing the actual solution, considering the sliding direction of the visual window will increase the difficulty of implementing the solution.

[0076] In order to more simply implement the method described in the present invention, we achieve the visual window sliding effect by updating the visible field array subscript method. Without considering the sliding direction of the visual window, the fields in the visible area can be updated, thereby achieving the goal of adjusting the various data-related fields of the target field to the visible area of ​​each corresponding table node object.

[0077] It should be noted that in the above step (3), the index index of the first element in lightKeyArr in the field array columns is chosen to be calculated because the present invention takes into account the limited visible area of ​​the table node. All fields that need to be highlighted may not be displayed in the visible area at the same time due to the large difference in the interval between the subscripts. For example: suppose there is a data table A with 3 fields and a data table B with 18 fields. The number of fields that can be displayed in the table node object is n. view =6, where the columnsA[0] field of table A has data dependencies with the columnsB[1], columnsB[8], and columnsB

[15] fields of table B. The numbers in the [] symbol represent the index of the field in the field array of the table node. When highlighting the data processing logic link of columnsA[0] of table A, the indexes of the three fields of table B, columnsB[1], columnsB[8], and columnsB

[15] , in the field array are 1, 8, and 15, respectively. The subscript intervals between them are too large and exceed the number of fields n that can be displayed in the table node object. view . When the table node object remains unchanged and the order of the table node field array remains unchanged, these three fields cannot be displayed in the visible area of ​​the table node object at the same time. Therefore, the present invention optimizes the display of the table node fields in the table node object. It is a solution that optimizes the display of the fields that need to be highlighted in the visible area, rather than displaying all the highlighted fields in the table node object. In the above step (7), the target table node, target field or source table node, source field found is added to the array object neighbors. If the table node already exists in neighbors, it is only necessary to add the target field or source field to the highlight attribute array lightKeyArr of the table node.

[0078] Furthermore, after the table node field attributes are optimized and displayed in the table node visual area, the coordinates of the field connection point will also change accordingly. The implementation process of this step is described as follows: using absolute layout, the vertical distance of the field connection point relative to the upper left corner of the table node is defined as y offset , at this time y offest =h head +h column *(index+0.5), where index is the index of the current field in columns; when index>=n view , the vertical distance y of the field connection point that is not in the table node object relative to the upper left corner of the table node offset is a fixed value, i.e. y offset =h head +h body +h foot*0.5. When the fields of the selected table node are optimized in the visible area, the start index of the subarray displayed in the visible area will change. If index-startIndex<0, the vertical distance y between the connection point of the field columns[index] and the upper left corner of the table node offset =h head *0.5; if index-startIndex≥0 and index-startIndex<n view When the column[index] connection point is at a vertical distance y from the upper left corner of the table node offset =h head +h column *(index-startIndex+0.5); if index-startIndex≥n view When the column[index] connection point is at a vertical distance y from the upper left corner of the table node offset =h head +h body +h foot *0.5.

[0079] For example, a specific example is used to illustrate the data processing logic link diagram. Figure 4 This is a schematic diagram of a data processing logic link diagram before highlighting in a method for visually displaying data processing logic provided in the first embodiment of the present invention, such as Figure 4 As shown in the figure, green represents the source table, yellow represents the intermediate table, and blue represents the derived table. The connecting lines with arrows in the figure are the dependencies between table node objects, and the arrows indicate the generation direction. For example, column 0 in table1 can be processed in different ways to generate column 3, column 4, and column 5 in table3. Table1 and table2 are processed according to certain rules to form intermediate tables table3 and table4, and finally generate derived table table5. Figure 4 As shown, the default display fields of each table node object are the fields with indexes between [0,5] in the table field array.

[0080] In the figure, the target field selected by the user is column 5 in table 1. The data-dependent fields of this field are column 8 in table 3, column 12 in table 5, column 4 in table 4, and column 7 in table 2. Since column 8 in table 3, column 12 in table 5, and column 7 in table 2 are not within the visible area of ​​their respective table node objects, when highlighting column 5 in table 1, the method described in the present invention is used to adjust column 8 in table 3, column 12 in table 5, and column 7 in table 2, which are outside the visible area, to the visible area of ​​the corresponding table node object. Since column 4 in table 4 is within the visible area of ​​the table node object, no adjustment is required. Figure 5 This is a schematic diagram of a highlighted data processing logic link diagram in a method for visually displaying data processing logic provided in the first embodiment of the present invention, such as Figure 5 As shown, after adjustment, from Figure 5 The red part in the middle can intuitively display the data processing logic relationship of the selected target field. On the one hand, it helps users clearly understand the source and destination of the data and strengthen the monitoring of data flow. On the other hand, it helps users quickly track and locate the cause of the anomaly and respond in time to solve the problem.

[0081] The technical solution of the embodiment of the present invention solves the problems of uneven height of table nodes and insufficient aesthetics of the interface by designing the visible area of ​​the table node and limiting the fields of the table node to the visible area for scrolling display. The window sliding method is used to adjust the data correlation fields to the visible area of ​​the table node, and the data processing logic relationship of the target field is dynamically and intuitively displayed, which makes it convenient for users to clearly understand the source and destination of the data, strengthen the monitoring of the data flow, and facilitate users to quickly track and locate the cause of the abnormality and respond in time to solve the problem. By providing the table node expansion and table node collapse functions, it is convenient to provide users with table-level data processing logic relationships, and also to provide users with field-level data processing logic. It meets both the query needs of fine intensity and the query needs of coarse intensity.

[0082] Example 2

[0083] Figure 6 This is a schematic diagram of the structure of a visual display device for data processing logic provided by the second embodiment of the present invention. Figure 6 As shown, the device includes:

[0084] Instruction acquisition module 51, used to obtain data processing logic request query instructions;

[0085] a relationship determination module 52 for determining the processing logic relationship of the queried target table according to the data processing logic request query instruction;

[0086] A link diagram generating module 53 is used to generate a data processing logic link diagram according to the processing logic relationship and the preset table node object attributes;

[0087] The display adjustment module 54 is used to respond to the operation of highlighting the processing link of any target field in the processing logic link diagram, recursively search for fields that have data correlation with the target field, and adjust the data correlation fields outside the visible area of ​​the table node to the visible area of ​​the table node through window sliding.

[0088] The technical solution of the embodiment of the present invention obtains a data processing logic request query instruction; determines the processing logic relationship of the queried target table according to the data processing logic request query instruction; generates a data processing logic link diagram according to the processing logic relationship and preset table node object attributes; in response to the operation of highlighting the processing link of any target field in the processing logic link diagram, recursively searches for fields that have data correlation with the target field, and adjusts the data correlation fields outside the visible area of ​​the table node to the visible area of ​​the table node through a window sliding method, and dynamically displays the data processing logic relationship of the target field. The visual display method of the present invention facilitates users to more clearly understand the source and destination of data and strengthen their monitoring of data flow.

[0089] Furthermore, the link graph generation module 53 is specifically configured to:

[0090] Generate an initial table node object according to the preset table node object attributes;

[0091] For each table node object in the processing logic relationship, if the total number of fields of the table node object exceeds the total number of fields that can be displayed in the visible area of ​​the table node, a vertical scroll bar is set for the table node object to support triggering scrolling through all fields;

[0092] Otherwise, the vertical scroll bar is not set and all fields are displayed directly;

[0093] The fields displayed in the visible area of ​​the table node object constitute a visible field array;

[0094] For the table node object without a vertical scroll bar, the subscript interval of its visible field array is [0, the field array length of the table node object - 1];

[0095] For the table node object with a vertical scroll bar set, initially, the subscript interval of its visible field array is [0, number of visible fields - 1]. When scrolling through the fields of the table node object is triggered, the subscript interval of the visible field array is updated;

[0096] The visible field array is a subset of the field array in the table node object, and the visible fields in the visible range of the table node object are updated based on the viewport size of the table node object and the window scrolling mode;

[0097] According to the above rules, the field information is filled into the visible area of ​​the initial table node object, and the table information is filled into the specified position of the initial table node object to obtain the table node object;

[0098] Determining the dependency relationship between the table node object and other table node objects according to the processing logic relationship;

[0099] A data processing logic link diagram is generated based on the dependency relationship between the table node object and other table node objects.

[0100] Furthermore, the display adjustment module 54 includes:

[0101] Obtain the target field unique identifier and the target table node object to which the target field belongs, and set highlight attributes for the target field and the target table node object to which the target field belongs;

[0102] Determine, based on the dependency relationship between the table node object and other table node objects, a table node array having data relevance with the target field;

[0103] Traversing the array of table nodes with data correlation, recursively searching for table node objects, fields, and edges with data correlation, and setting highlight attributes for each of the table node objects with data correlation, data correlation fields, and each data correlation edge;

[0104] When highlighting the processing link of the target field, determine the visible field array within the visible area of ​​the table node object based on the table node object with data correlation, and obtain the index of the data correlation field in the field array of the corresponding table node object. If the data correlation field index is within the subscript range of the visible field array, no processing is performed;

[0105] If the data dependency field index is outside the subscript range of the visible field array, then updating the starting subscript of the visible field array to adjust the data dependency field to the visible area of ​​the table node;

[0106] The target object with the highlight attribute is redrawn to achieve highlighting of the target field processing link.

[0107] Optionally, the device further comprises:

[0108] A version comparison request of the data processing logic is obtained, table node object status information and edge status information are obtained based on the version comparison request, and a version comparison graph is generated.

[0109] Optionally, the device further comprises:

[0110] The record display module is used after the version comparison chart is generated, and further includes:

[0111] In response to a click operation on a table node object or a field status attribute icon in the table node object in the version comparison diagram, all change records of the object corresponding to the status attribute icon are displayed.

[0112] The visual display device for data processing logic provided in the embodiment of the present invention can execute the visual display method for data processing logic provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0113] Example 3

[0114] Figure 7 A schematic diagram of the structure of an electronic device 60 that can be used to implement an embodiment of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or claimed herein.

[0115] like Figure 7As shown, the electronic device 60 includes at least one processor 61 and a memory, such as a read-only memory (ROM) 62, a random access memory (RAM) 63, etc., which is communicatively connected to the at least one processor 61. The memory stores a computer program that can be executed by the at least one processor. The processor 61 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 62 or the computer program loaded from the storage unit 68 into the random access memory (RAM) 63. Various programs and data required for the operation of the electronic device 60 can also be stored in the RAM 63. The processor 61, ROM 62, and RAM 63 are connected to each other via a bus 64. An input / output (I / O) interface 65 is also connected to the bus 64.

[0116] Multiple components in the electronic device 60 are connected to the I / O interface 65, including an input unit 66, such as a keyboard, a mouse, etc.; an output unit 67, such as various types of displays, speakers, etc.; a storage unit 68, such as a magnetic disk, an optical disk, etc.; and a communication unit 69, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 69 allows the electronic device 60 to exchange information / data with other devices via a computer network such as the Internet and / or various telecommunication networks.

[0117] Processor 61 can be any general-purpose and / or specialized processing component with processing and computing capabilities. Some examples of processor 61 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various specialized artificial intelligence (AI) computing chips, various processors that run machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. Processor 61 executes the various methods and processes described above, such as the method for visually displaying data processing logic.

[0118] In some embodiments, the method for visually displaying data processing logic may be implemented as a computer program tangibly contained in a computer-readable storage medium, such as storage unit 68. In some embodiments, part or all of the computer program may be loaded and / or installed on electronic device 60 via ROM 62 and / or communication unit 69. When the computer program is loaded into RAM 63 and executed by processor 61, one or more steps of the method for visually displaying data processing logic described above may be performed. Alternatively, in other embodiments, processor 61 may be configured to perform the method for visually displaying data processing logic in any other appropriate manner (e.g., via firmware).

[0119] Various embodiments of the systems and techniques described herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), system-on-chip systems (SOCs), programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments can include being implemented in one or more computer programs that are executable and / or interpreted on a programmable system comprising at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0120] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, such that when the computer program is executed by the processor, the functions / operations specified in the flowcharts and / or block diagrams are implemented. The computer program may be executed entirely on the machine, partially on the machine, as a stand-alone software package, partially on the machine and partially on a remote machine, or entirely on a remote machine or server.

[0121] In the context of the present invention, computer-readable storage media can be tangible media that can contain or store a computer program for use with an instruction execution system, device or equipment or used in combination with an instruction execution system, device or equipment. Computer-readable storage media can include but are not limited to electronic, magnetic, optical, electromagnetic, infrared or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, computer-readable storage media can be machine-readable signal media. More specific examples of machine-readable storage media can include electrical connections based on one or more lines, portable computer disks, hard disks, random access memories (RAM), read-only memories (ROM), erasable programmable read-only memories (EPROM or flash memory), optical fibers, portable compact disk read-only memories (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0122] To provide interaction with a user, the systems and techniques described herein can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices can also be used to provide interaction with the user; for example, the 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 can be received in any form (including acoustic input, voice input, or tactile input).

[0123] The systems and techniques described herein can be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., a user computer with a graphical user interface or web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, 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: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0124] A computing system may include clients and servers. The clients and servers are typically remote from each other and typically interact via a communication network. This client-server relationship arises through computer programs running on the respective computers, creating a client-server relationship. The server may be a cloud server, also known as a cloud computing server or cloud host. This server is a hosting product within the cloud computing service ecosystem that addresses the management difficulties and limited scalability of traditional physical hosting and VPS services.

[0125] In one embodiment, the present invention further includes a computer program product, which includes a computer program. When the computer program is executed by a processor, it implements the method for visually displaying the data processing logic of any embodiment of the present invention.

[0126] The program code may execute entirely on the user's computer, partially on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer, or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., through the Internet using an Internet service provider).

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

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

Claims

1. A method for visualizing data processing logic, characterized in that: include: Get data processing logic request query instructions; Determining the processing logic relationship of the queried target table according to the data processing logic request query instruction; Generate a data processing logic link diagram based on the processing logic relationship and preset table node object attributes; In response to the operation of highlighting any target field processing link in the processing logic link diagram, recursively search for fields that have data correlation with the target field, and for data correlation fields that are outside the visible area of ​​the table node, adjust the data correlation fields to the visible area of ​​the table node through window sliding.

2. The method according to claim 1, characterized in that Generating a data processing logic link diagram according to the processing logic relationship and the preset table node object attributes includes: Generate an initial table node object according to the preset table node object attributes; For each table node object in the processing logic relationship, if the total number of fields of the table node object exceeds the total number of fields that can be displayed in the visible area of ​​the table node, a vertical scroll bar is set for the table node object to support triggering scrolling through all fields; Otherwise, the vertical scroll bar is not set and all fields are displayed directly; The fields displayed in the visible area of ​​the table node object constitute a visible field array; For the table node object without a vertical scroll bar, the subscript interval of its visible field array is [0, the field array length of the table node object - 1]; For the table node object with a vertical scroll bar set, initially, the subscript interval of its visible field array is [0, number of visible fields - 1]. When scrolling through the fields of the table node object is triggered, the subscript interval of the visible field array is updated; The visible field array is a subset of the field array in the table node object, and the visible fields in the visible range of the table node object are updated based on the viewport size of the table node object and the window scrolling mode; According to the above rules, the field information is filled into the visible area of ​​the initial table node object, and the table information is filled into the specified position of the initial table node object to obtain the table node object; Determining the dependency relationship between the table node object and other table node objects according to the processing logic relationship; A data processing logic link diagram is generated based on the dependency relationship between the table node object and other table node objects.

3. The method according to claim 1, characterized in that The recursive search for fields having data dependencies with the target field, and adjusting the data dependencies fields outside the visible area of ​​the table node to the visible area of ​​the table node by means of a window sliding method, includes: Obtain the target field unique identifier and the target table node object to which the target field belongs, and set highlight attributes for the target field and the target table node object to which the target field belongs; Determine, based on the dependency relationship between the table node object and other table node objects, a table node array having data relevance with the target field; Traversing the array of table nodes with data correlation, recursively searching for table node objects, fields, and edges with data correlation, and setting highlight attributes for each of the table node objects with data correlation, data correlation fields, and each data correlation edge; When highlighting the processing link of the target field, determine the visible field array within the visible area of ​​the table node object based on the table node object with data correlation, and obtain the index of the data correlation field in the field array of the corresponding table node object. If the data correlation field index is within the subscript range of the visible field array, no processing is performed; If the data dependency field index is outside the subscript range of the visible field array, then updating the starting subscript of the visible field array to adjust the data dependency field to the visible area of ​​the table node; The target object with the highlight attribute is redrawn to achieve highlighting of the target field processing link.

4. The method according to claim 1, wherein Also includes: A version comparison request of the data processing logic is obtained, table node object status information and edge status information are obtained based on the version comparison request, and a version comparison graph is generated.

5. The method according to claim 4, characterized in that After generating the version comparison chart, the method further includes: In response to a click operation on a table node object or a field status attribute icon in the table node object in the version comparison diagram, all change records of the object corresponding to the status attribute icon are displayed.

6. A visual display device for data processing logic, characterized in that: include: Instruction acquisition module, used to obtain data processing logic request query instructions; A relationship determination module, configured to determine the processing logic relationship of the queried target table according to the data processing logic request query instruction; A link diagram generation module, configured to generate a data processing logic link diagram based on the processing logic relationship and the preset table node object attributes; A display adjustment module is used to respond to the operation of highlighting any target field processing link in the processing logic link diagram, recursively search for fields that have data correlation with the target field, and adjust the data correlation fields outside the visible area of ​​the table node into the visible area of ​​the table node through window sliding.

7. The device according to claim 6, characterized in that The device further comprises: The comparison graph generation module is used to obtain a version comparison request of the data processing logic, obtain table node object status information and edge status information based on the version comparison request, and generate a version comparison graph.

8. An electronic device, characterized in that: The electronic device comprises: at least one processor; and a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program that can be executed by the at least one processor, and the computer program is executed by the at least one processor to enable the at least one processor to execute the method for visual display of data processing logic according to any one of claims 1 to 5.

9. A computer-readable storage medium, characterized in that The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the visual display method of data processing logic according to any one of claims 1 to 5 when executed.

10. A computer program product, characterized in that The computer program product comprises a computer program, which, when executed by a processor, implements the method for visually displaying data processing logic according to any one of claims 1 to 5.

Images