Method, apparatus, and computer device for determining data table association information

Abstract

The present application relates to a method, apparatus, and computer device for determining data table association information, and relates to the field of big data technology. The method includes: obtaining a data table information set and identification information of each data table corresponding to a target application system; the data table information set includes a plurality of data table information; selecting target data table information from the data table information set according to the identification information of each data table and the data table index order in the target application system; determining each association chain of the target data table and the association strength corresponding to each association chain according to the target data table information and the data table information set, and using each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system. Using this method can improve the efficiency of determining data table association information.

Description

Technical Field

[0001] The present application relates to the field of big data technology, and particularly to a method, apparatus, and computer device for determining data table association information. Background Art

[0002] With the development of big data technology, data tables corresponding to different application systems are derived from different data tables in a database or from derivative tables of different data tables in the database, making it a major challenge to determine the data table association information corresponding to an application system. The data table association information includes the association chain of the data table and the association strength of the association chain.

[0003] In traditional technologies, the association information of a data table and its derivative tables is usually determined by manual retrieval. However, this method has a large workload, takes a long time, and cannot completely obtain all implicitly related tables, resulting in low efficiency in determining data table association information. Summary of the Invention

[0004] Based on this, it is necessary to provide a method, apparatus, computer device, computer-readable storage medium, and computer program product for determining data table association information to solve the above technical problems.

[0005] In a first aspect, the present application provides a method for determining data table association information. The method includes:

[0006] Obtain a data table information set and identification information of each data table corresponding to a target application system; the data table information set includes multiple data table information;

[0007] Select target data table information from the data table information set according to the identification information of each data table and the data table index order in the target application system;

[0008] Determine each association chain of the target data table and the association strength corresponding to each association chain through a data table association algorithm according to the target data table information and the data table information set, and use each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system.

[0009] Optionally, the data table information includes identification information of the data table. The step of selecting target data table information from the data table information set according to the identification information of each data table and the data table index order in the target application system includes:

[0010] Determine a target data table ranked first in the index sequence according to the data table index order in the target application system;

[0011] In the set of data table information, determine the target data table information corresponding to the identification information of the target data table.

[0012] Optionally, the data table information includes the identification information of the data table, the identification information of each data table indexed by the data table, and the operation information between the data table and each data table indexed by the data table. The data table association algorithm includes a data table positioning algorithm and an association strength algorithm. The determining of each association chain of the target data table and the corresponding association strength of each association chain according to the target data table information and the set of data table information includes:

[0013] Determine each association chain of the target data table according to the identification information of each data table indexed by the target data table, the identification information of each data table in the set of data table information, the identification information of the data tables indexed by each data table in the set of data table information, and the data table positioning algorithm; the identification information of each data table in the association chain is arranged in index order.

[0014] For each association chain, determine the corresponding association strength of the association chain according to the operation information of each adjacent data table in the association chain and the association strength algorithm.

[0015] Optionally, the determining of each association chain of the target data table according to the identification information of each data table indexed by the target data table, the identification information of each data table in the set of data table information, the identification information of the data tables indexed by each data table in the set of data table information, and the data table positioning algorithm includes:

[0016] Determine each initial data table association chain according to the identification information of the target data table, the identification information of each data table indexed by the target data table, the identification information of each data table in the set of data table information, the identification information of the data tables indexed by each data table in the set of data table information, and the data table positioning algorithm.

[0017] Perform duplicate removal processing on each of the initial data table association chains to obtain each association chain of the target data table.

[0018] Optionally, the determining of the corresponding association strength of the association chain according to the operation information of each adjacent data table information in the association chain and the association strength algorithm includes:

[0019] Determine the corresponding association strength of each pair of adjacent data table information according to the operation information of each pair of adjacent data table information in the association chain and the association strength algorithm.

[0020] Determine the corresponding association strength of the association chain according to the association strengths corresponding to each of the adjacent data table information.

[0021] Optionally, the method further includes:

[0022] Sorting each of the association chains in the data table association information of the target application system in descending order according to the association strength corresponding to each association chain, to obtain the sorted data table association information of the target application system.

[0023] In a second aspect, the present application further provides a device for determining data table association information. The device includes:

[0024] An acquisition module, configured to acquire a data table information set and identification information of each data table corresponding to a target application system; the data table information set includes a plurality of data table information;

[0025] A selection module, configured to select target data table information from the data table information set according to the identification information of each data table and in the index order in the target application system;

[0026] A determination module, configured to determine each association chain of the target data table and the association strength corresponding to each association chain through a data table association algorithm according to the target data table information and the data table information set, and use each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system.

[0027] Optionally, the data table information includes identification information of the data table, and the selection module is specifically configured to:

[0028] Determine a target data table arranged at the first position in the index sequence according to the data table index order in the target application system;

[0029] In the data table information set, determine the target data table information corresponding to the identification information of the target data table.

[0030] Optionally, the data table information includes identification information of the data table, identification information of each data table in the data table index, and operation information between the data table and each data table in the data table index, and the data table association algorithm includes a data table positioning algorithm and an association strength algorithm; the determination module is specifically configured to:

[0031] Determine each association chain of the target data table according to the identification information of each data table in the target data table index, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm; the association chain includes the identification information of each data table arranged in index order;

[0032] For each associated chain, determine the association strength corresponding to the associated chain according to the operation information of each adjacent data table in the associated chain and the association strength algorithm.

[0033] Optionally, the determining module is specifically configured to:

[0034] Determine each initial data table association chain according to the identification information of the target data table, the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data table indexed by each data table in the data table information set, and the data table positioning algorithm;

[0035] Perform deduplication processing on each of the initial data table association chains to obtain each association chain of the target data table.

[0036] Optionally, the determining module is specifically configured to:

[0037] Determine the association strength corresponding to each pair of adjacent data table information according to the operation information and the association strength algorithm of each pair of adjacent data table information in the associated chain;

[0038] Determine the association strength corresponding to the associated chain according to the association strength corresponding to each of the adjacent data table information.

[0039] Optionally, the device further includes:

[0040] A sorting module, configured to sort each of the associated chains in the data table association information of the target application system in descending order according to the association strength corresponding to each of the associated chains, to obtain the sorted data table association information of the target application system.

[0041] In a third aspect, the present application provides a computer device. The computer device includes a memory and a processor, the memory stores a computer program, and when the processor executes the computer program, the steps of the method described in any one of the first aspect are implemented.

[0042] In a fourth aspect, the present application provides a computer-readable storage medium. A computer program is stored thereon, and when the computer program is executed by a processor, the steps of the method described in any one of the first aspect are implemented.

[0043] In a fifth aspect, the present application provides a computer program product. The computer program product includes a computer program, and when the computer program is executed by a processor, the steps of the method described in any one of the first aspect are implemented.

[0044] The method, apparatus, and computer device for determining the above data table association information obtain a data table information set and the identification information of each data table corresponding to the target application system; the data table information set includes multiple data table information; according to the identification information of each data table, in the order of the index in the target application system, select the target data table information from the data table information set; according to the target data table information and the data table information set, determine each association chain of the target data table and the association strength corresponding to each association chain through a data table association algorithm, and use each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system. According to the identification information of each data table, through a data table association algorithm, automatically find each association chain of the target data table and the association strength of each association chain in each data table information to obtain the data table association information of the current application system, thereby improving the efficiency of determining the data table association information. Brief Description of the Drawings

[0045] Figure 1 It is a schematic flowchart of a method for determining data table association information in an embodiment;

[0046] Figure 2 It is a schematic flowchart of a method for determining each association chain of a target data table and the association strength corresponding to each association chain in an embodiment;

[0047] Figure 3 It is a schematic flowchart of an example of a method for determining data table association information in an embodiment;

[0048] Figure 4 It is a structural block diagram of a device for determining data table association information in an embodiment;

[0049] Figure 5 It is an internal structure diagram of a computer device in an embodiment. Detailed Description of the Embodiment

[0050] In order to make the purpose, technical solution, and advantages of the present application clearer, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0051] The method for determining data table association information provided by the embodiments of the present application can be applied to a terminal, a server, or a system including a terminal and a server, and is implemented through the interaction between the terminal and the server. Among them, the terminal can include, but is not limited to, various personal computers, laptop computers, tablet computers, etc. The terminal is used to obtain a data table information set and the identification information of each data table corresponding to the target application system, and according to the identification information of each data table, through a data table association algorithm, automatically find each association chain of the target data table and the association strength of each association chain in the data table information, so as to obtain the data table association information of the current application system, thereby improving the efficiency of determining data table association information.

[0052] In one embodiment, as Figure 1 shown, a method for determining data table association information is provided. Taking the application of this method to a terminal as an example, the method includes the following steps:

[0053] Step S101, obtain a data table information set and the identification information of each data table corresponding to the target application system.

[0054] Among them, the data table information set includes multiple data table information.

[0055] In this embodiment, the terminal obtains the current version and the previous version of each data processing-related statement in the infrastructure architecture based on data storage technology, such as a data warehouse or a data lake, parses the current version and the previous version of each data processing-related statement to obtain each data table information, and uses each data table information as the data table information set. The terminal obtains the current data table reference statement corresponding to the target application system, and parses the current data table reference statement to obtain the identification information of each data table corresponding to the target application system. The data table information includes the identification information of the data table, the identification information of the data table indexed by the data table, and the operation information between the data table and the data table indexed by the data table. Each data table corresponding to the target application system includes the data tables directly referenced by the target application system and the data tables indexed by the data tables directly referenced by the target application system.

[0056] The data reference statement is the code information for the target application system to reference a data table for data processing. The data reference statement includes the identification information of the data table directly referenced by the target application system, the identification information of the indirectly referenced data table, and the index order relationship between the directly referenced data table and the indirectly referenced data table. For example, the data processing statement of the target application system includes: the directly referenced data table is Table A, and the indirectly referenced data tables are Table B, Table C, and Table D. The index order relationship between Table A and Table B, Table C, and Table B is: Table A references Table B, Table A references Table C, and Table A references Table D.

[0057] The data table information includes the data table identification information, the identification information of each data table in the data table index, and the operation information between the data table and each data table in the data table index. The data processing related statements are the code information for the database to process the data in each data table.

[0058] Step S102, select the target data table information from the data table information set according to the identification information of each data table and the data table index order in the target application system.

[0059] In this embodiment, the terminal determines the identification information of the target data table according to the index order relationship between the directly referenced data table and the indirectly referenced data table in the current data table reference statement of the target application system, and selects the data table information corresponding to the identification information of the target data table from the data table information set, so as to obtain the target data table information. The specific selection process will be described in detail later.

[0060] The index order is the order of precedence between the data table and the data table indexed by the data table when the target application system calls the data in the data table. For example, if table A indexes table B, table B indexes table C, and table C indexes table D, then the index order is table A → table B → table C → table D.

[0061] The data tables indexed by the data table may not be unique, and the index order between two data tables may also not be unique (i.e., different data tables are referenced). For example, the data tables referenced by table A may be table B, table C, and table D, i.e., table A → table B, table A → table C, table A → table D. In another embodiment, the index order between table A and table B is table A → table X → table Y → table B, table A → table C → table B.

[0062] Step S103, determine each association chain of the target data table and the association strength corresponding to each association chain according to the target data table information and the data table information set, and use each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system.

[0063] In this embodiment, the terminal queries each association chain of the target data table from the identification information of each data table in the data table information set through the data table association algorithm according to the identification information of the target data table, and determines the association strength corresponding to the association chain for the operation information of each data table in each association chain. The terminal obtains the data table association information corresponding to the target application system according to each association chain of the target data table and the association strength corresponding to each association chain. The specific steps for determining the data table association information will be described in detail later. The association chain of the data table is the arrangement of each data table in an index order.

[0064] Based on the above solution, through the data table association algorithm, in the information of each data table, the association chains of the target data table and the association strength of each of the association chains are automatically found, and the data table association information of the current application system is obtained, thereby improving the efficiency of determining the data table association information.

[0065] Optionally, the data table information includes the identification information of the data table. Selecting the target data table information from the data table information set according to the identification information of each data table and the data table index order in the target application system includes: determining the target data table ranked first in the index sequence according to the data table index order in the target application system; in the data table information set, determining the target data table information corresponding to the identification information of the target data table.

[0066] In this embodiment, the terminal selects the identification information of the data table ranked first in the index sequence according to the index order relationship between each directly referenced data table and each indirectly referenced data table in the current data table reference statement of the target application system, and uses the identification information of the data table ranked first in the index sequence as the identification information of the target data table. The terminal selects the data table information corresponding to the same identification information as the identification information of the target data table from the data table information set as the target data table information.

[0067] Based on the above solution, by the identification information of each data table in the target application system, the target data table information is selected from the data table information set, thereby determining the data table for which the association information needs to be obtained, and improving the accuracy of determining the data table association information corresponding to the target application system.

[0068] Optionally, the data table information may specifically include the identification information of the data table, the identification information of each data table indexed by the data table, the operation information between the data table and each data table indexed by the data table, and the data table association algorithm may specifically include a data table positioning algorithm and an association strength algorithm; correspondingly, as Figure 2 shown, according to the target data table information and the data table information set, determining the association chains of the target data table and the association strength corresponding to each association chain through the data table association algorithm includes:

[0069] Step S201, according to the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm, determine the association chains of the target data table.

[0070] Among them, the identification information of each data table included in the association chain is arranged in index order.

[0071] In this embodiment, the terminal uses the data table association algorithm to find the data tables corresponding to the target data table index among the identification information of each data table in the data table information set according to the identification information of the target data table, and sorts them in the index order to obtain each association chain of the target data table.

[0072] The method of finding each association chain of the target data table in the data table information set through the identification information of the target data table is as follows: taking the target data table as the initial node and each data table in the data table information set as the process nodes. Through the graph connectivity algorithm, starting from the initial node, randomly select a process node among the process nodes indexed by the initial node, and use this process node as the new node. Randomly select a process node among the process nodes indexed by the new node, and use this process node as the new node, and repeat the above steps until there are no process nodes indexed by the new node. Then, form a path from the initial node to the new node of the process node without an index as an association chain of the target data table.

[0073] The terminal returns to the previous process node of the new node of the process node without an index, and randomly selects a process node among the other process nodes except this new node again, using this process node as the new node, and repeat the steps of randomly selecting a process node among the process nodes indexed by the new node and using this process node as the new node until all the association chains of the target data table are determined.

[0074] Step S202: For each association chain, determine the association strength corresponding to the association chain according to the operation information of each adjacent data table in the association chain and the association strength algorithm.

[0075] In this embodiment, the terminal inputs the operation information of each pair of adjacent data table information into the association strength algorithm to obtain the association strength of each pair of adjacent data table information, and sums up the association strengths to obtain the association strength of this association chain. The association strength algorithm can be, but is not limited to, Dijkstra's algorithm or Floyd's algorithm.

[0076] Based on the above solution, according to the target data table information and the data table information set, through the data table association algorithm, each association chain of the target data table and the association strength of each association chain are determined, thereby improving the efficiency of obtaining data table association information.

[0077] Optionally, based on the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table index in the data table information set, and the data table positioning algorithm, determine each associated link of the target data table, including: determining each initial data table associated link based on the identification information of the target data table, the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table index in the data table information set, and the data table positioning algorithm; performing duplicate removal processing on each initial data table associated link to obtain each associated link of the target data table.

[0078] In this embodiment, the terminal may, but is not limited to, start from the identification information of the target data table through a graph connectivity algorithm (Depth First Search, DFS) (i.e., the data table positioning algorithm), and query the identification information of each data table indexed by the target data table and the identification information of each data table indexed by the indexed data table in the identification information of each data table in the data table information set according to the identification information of the target data table and the identification information of each data table indexed by the target data table, and sort them in the index order to obtain each initial associated link of the target data table.

[0079] In each initial associated link of the target data table, the terminal randomly performs duplicate removal on the associated links with different index orders but the same included data tables, and uses the de-duplicated initial associated links as each associated link of the target data table. For example, if the initial associated links are A→B→C→D and A→C→B→D, the terminal performs a de-duplication operation on the two associated links, removes one initial associated link, and uses the other initial associated link as the associated link of the target data table.

[0080] Based on the above solution, by determining each initial data table associated link according to the identification information of the target data table, the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table index in the data table information set, and the data table positioning algorithm, the accuracy of the target data table associated link is improved.

[0081] Optionally, based on the operation information of each adjacent data table information in the associated link and the association strength algorithm, determine the association strength corresponding to the associated link, including: determining the association strength corresponding to each pair of adjacent data table information according to the operation information of each pair of adjacent data table information in the associated link and the association strength algorithm; determining the association strength corresponding to the associated link according to the association strength corresponding to each adjacent data table information.

[0082] In this embodiment, for each associated chain of the target data table, the terminal calculates the association strength between each data table in the associated chain and the data table adjacent to it by inputting the operation information of each adjacent data table into the association strength algorithm, and sums up the association strengths to obtain the association strength corresponding to the associated chain. For example, the target data table is Table A, and an associated chain of the target data table is A→B→C→D. The operation information of A→B is query, the operation information of B→C is operation, and the operation information of C→D is merge. The terminal inputs the operation information of A→B, B→C, and C→D into the association strength algorithm respectively, and obtains that the association strength corresponding to A→B is 3, the association strength corresponding to B→C is 2, and the association strength corresponding to C→D is 4. Then the association strength corresponding to A→B→C is 5, and the association strength corresponding to A→B→C→D is 9.

[0083] Based on the above solution, the terminal calculates the association strength of each adjacent data table information in the associated chain, and sums up the association strengths of each adjacent data table information to obtain the association strength of the associated chain, thereby improving the accuracy of the association strength of the obtained associated chain.

[0084] Optionally, the method further includes:

[0085] Sort each associated chain in the data table association information of the target application system in descending order according to the association strength corresponding to each associated chain to obtain the sorted data table association information of the target application system.

[0086] In this embodiment, the terminal sorts each associated chain of the target application system in descending order according to the association strength corresponding to each associated chain to obtain the sorted data table association information. For example, the target application system has 3 associated chains, which are respectively. The association strength of associated chain 1 is 10, the association strength of associated chain 2 is 15, and the association strength of associated chain 3 is 20. Then the sorting of each associated chain is associated chain 3, associated chain 2, and associated chain 1.

[0087] Based on the above solution, by sorting each associated chain, different degrees of maintenance can be performed on each data table included in the associated chains with different sorts during subsequent data table maintenance, thereby reducing the cost of data table maintenance and improving the efficiency of data table maintenance.

[0088] This application also provides an example of determining data table association information, as Figure 3 shown. The specific processing process includes the following steps:

[0089] Step S301, obtain the data table information set and the identification information of each data table corresponding to the target application system.

[0090] Among them, the data table information set includes multiple data table information.

[0091] Step S302: Determine the target data table ranked first in the index sequence according to the index order of the data tables in the target application system.

[0092] Step S303: In the data table information set, determine the target data table information corresponding to the identification information of the target data table.

[0093] Step S304: Determine each initial data table association chain according to the identification information of the data tables indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm.

[0094] Step S305: Perform duplicate removal processing on each initial data table association chain to obtain each association chain of the target data table.

[0095] Step S306: Determine the association strength corresponding to each pair of adjacent data table information according to the operation information and the association strength algorithm of each pair of adjacent data table information in the association chain.

[0096] Step S307: Determine the association strength corresponding to the association chain according to the association strength corresponding to each pair of adjacent data table information.

[0097] Step S308: Take each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system.

[0098] Step S309: Sort each association chain in the data table association information of the target application system in descending order according to the association strength corresponding to each association chain to obtain the sorted data table association information of the target application system.

[0099] It should be understood that although each step in the flowcharts involved in the above-described embodiments is displayed in sequence according to the indication of the arrows, these steps do not necessarily have to be executed in the order indicated by the arrows. Unless there is a clear indication in this article, there is no strict order restriction for the execution of these steps, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-described embodiments may include multiple steps or multiple stages. These steps or stages do not necessarily have to be executed at the same moment, but can be executed at different moments. The execution order of these steps or stages does not necessarily have to be sequential, but can be executed alternately or in turn with at least a part of other steps or steps or stages in other steps.

[0100] Based on the same inventive concept, an embodiment of the present application further provides an apparatus for determining data table association information for implementing the method for determining data table association information involved above. The implementation solutions provided by this apparatus for solving problems are similar to the implementation solutions described in the above method. Therefore, the specific limitations in one or more embodiments of the apparatus for determining data table association information provided below can refer to the limitations on the method for determining data table association information in the foregoing, and will not be elaborated here.

[0101] In one embodiment, as Figure 4 shown, an apparatus for determining data table association information is provided, including: an acquisition module 410, a selection module 420, and a determination module 430, where:

[0102] The acquisition module 410 is configured to acquire a data table information set and identification information of each data table corresponding to a target application system; the data table information set includes a plurality of data table information;

[0103] The selection module 420 is configured to select target data table information from the data table information set according to the identification information of each data table in the index order in the target application system;

[0104] The determination module 430 is configured to determine each association chain of the target data table and the association strength corresponding to each association chain according to the target data table information and the data table information set through a data table association algorithm, and use each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system.

[0105] Optionally, the data table information includes identification information of the data table. The selection module 420 is specifically configured to:

[0106] Determine the target data table ranked first in the index sequence according to the data table index order in the target application system;

[0107] In the data table information set, determine the target data table information corresponding to the identification information of the target data table.

[0108] Optionally, the data table information includes identification information of the data table, identification information of each data table in the data table index, and operation information between the data table and each data table in the data table index. The data table association algorithm includes a data table positioning algorithm and an association strength algorithm; the determination module 430 is specifically configured to:

[0109] Determine each association chain of the target data table according to the identification information of each data table in the target data table index, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm; the identification information of each data table in the association chain is arranged in the index order;

[0110] For each associated chain, determine the association strength corresponding to the associated chain according to the operation information of each adjacent data table in the associated chain and the association strength algorithm.

[0111] Optionally, the determining module 430 is specifically configured to:

[0112] Determine each initial data table association chain according to the identification information of the target data table, the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data table indexed by each data table in the data table information set, and the data table positioning algorithm;

[0113] Perform deduplication processing on each initial data table association chain to obtain each association chain of the target data table.

[0114] Optionally, the determining module 430 is specifically configured to:

[0115] Determine the association strength corresponding to each pair of adjacent data table information according to the operation information and the association strength algorithm of each pair of adjacent data table information in the associated chain;

[0116] Determine the association strength corresponding to the associated chain according to the association strength corresponding to each adjacent data table information.

[0117] Optionally, the apparatus further includes:

[0118] A sorting module, configured to sort each associated chain in the data table association information of the target application system in descending order according to the association strength corresponding to each associated chain, to obtain the sorted data table association information of the target application system.

[0119] Each module in the above apparatus for determining data table association information can be implemented in whole or in part by software, hardware, and their combination. Each of the above modules can be embedded in the processor in the computer device in hardware form or be independent of it, or can be stored in the memory in the computer device in software form, so that the processor can call and execute the operations corresponding to each of the above modules.

[0120] In one embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as Figure 5As shown in the figure. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage medium. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be implemented through WIFI, a mobile cellular network, NFC (Near Field Communication), or other technologies. When the computer program is executed by the processor, it implements a method for determining data table association information. The display screen of the computer device can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, a trackball, or a touchpad provided on the computer device housing, or an external keyboard, touchpad, or mouse, etc.

[0121] Those skilled in the art can understand that Figure 5 the structure shown in the figure is only a block diagram of some structures related to the solution of this application, and does not constitute a limitation on the computer device to which the solution of this application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine some components, or have different component arrangements.

[0122] In one embodiment, a computer device is provided, including a memory and a processor. A computer program is stored in the memory. When the processor executes the computer program, the following steps are implemented:

[0123] Obtain a data table information set and the identification information of each data table corresponding to the target application system; the data table information set includes multiple data table information;

[0124] According to the identification information of each data table and the data table index order in the target application system, select target data table information from the data table information set;

[0125] According to the target data table information and the data table information set, determine each association chain of the target data table and the association strength corresponding to each association chain through a data table association algorithm, and use each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system.

[0126] Optionally, the data table information includes the identification information of the data table. The step of selecting target data table information from the data table information set according to the identification information of each data table and the data table index order in the target application system includes:

[0127] Determine the target data table arranged at the top of the index sequence according to the index order of the data tables in the target application system;

[0128] In the data table information set, determine the target data table information corresponding to the identification information of the target data table.

[0129] Optionally, the data table information includes the identification information of the data table, the identification information of each data table indexed by the data table, and the operation information between the data table and each data table indexed by the data table. The data table association algorithm includes a data table positioning algorithm and an association strength algorithm; the determining of each association chain of the target data table and the association strength corresponding to each association chain through the data table association algorithm according to the target data table information and the data table information set includes:

[0130] Determine each association chain of the target data table according to the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm; the identification information of each data table in the association chain is arranged in index order;

[0131] For each association chain, determine the association strength corresponding to the association chain according to the operation information of each adjacent data table in the association chain and the association strength algorithm.

[0132] Optionally, the determining of each association chain of the target data table according to the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm includes:

[0133] Determine each initial data table association chain according to the identification information of the target data table, the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm;

[0134] Perform duplicate removal processing on each of the initial data table association chains to obtain each association chain of the target data table.

[0135] Optionally, the determining of the association strength corresponding to the association chain according to the operation information of each adjacent data table information in the association chain and the association strength algorithm includes:

[0136] Determine the association strength corresponding to each pair of adjacent data table information according to the operation information of each pair of adjacent data table information in the association chain and the association strength algorithm;

[0137] Determine the association strength corresponding to the association chain according to the association strength corresponding to each of the adjacent data table information.

[0138] Optionally, the method further includes:

[0139] Sort each of the association chains in the data table association information of the target application system in descending order according to the association strength corresponding to each association chain, to obtain the sorted data table association information of the target application system.

[0140] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the following steps are implemented:

[0141] Obtain a data table information set and identification information of each data table corresponding to a target application system; the data table information set includes a plurality of data table information.

[0142] Select target data table information from the data table information set according to the identification information of each data table and the data table index order in the target application system.

[0143] According to the target data table information and the data table information set, determine each association chain of the target data table and the association strength corresponding to each association chain through a data table association algorithm, and use each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system.

[0144] Optionally, the data table information includes identification information of the data table. The step of selecting target data table information from the data table information set according to the identification information of each data table and the data table index order in the target application system includes:

[0145] Determine a target data table arranged at the head of the index sequence according to the data table index order in the target application system.

[0146] In the data table information set, determine the target data table information corresponding to the identification information of the target data table.

[0147] Optionally, the data table information includes identification information of the data table, identification information of each data table in the data table index, and operation information between the data table and each data table in the data table index. The data table association algorithm includes a data table positioning algorithm and an association strength algorithm; the step of determining each association chain of the target data table and the association strength corresponding to each association chain according to the target data table information and the data table information set includes:

[0148] Determine each associated link of the target data table according to the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm; the identification information of each data table in the associated link is arranged in index order;

[0149] For each associated link, determine the associated strength corresponding to the associated link according to the operation information of each adjacent data table in the associated link and the associated strength algorithm.

[0150] Optionally, the determining each associated link of the target data table according to the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm includes:

[0151] Determine each initial data table associated link according to the identification information of the target data table, the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm;

[0152] Perform deduplication processing on each of the initial data table associated links to obtain each associated link of the target data table.

[0153] Optionally, the determining the associated strength corresponding to the associated link according to the operation information of each adjacent data table information in the associated link and the associated strength algorithm includes:

[0154] Determine the associated strength corresponding to each pair of adjacent data table information according to the operation information of each pair of adjacent data table information in the associated link and the associated strength algorithm;

[0155] Determine the associated strength corresponding to the associated link according to the associated strengths corresponding to each of the adjacent data table information.

[0156] Optionally, the method further includes:

[0157] Sort each of the associated links in the data table association information of the target application system in descending order according to the associated strength corresponding to each of the associated links to obtain the sorted data table association information of the target application system.

[0158] In one embodiment, a computer program product is provided, including a computer program, which when executed by a processor implements the following steps:

[0159] Obtain a set of data table information and identification information of each data table corresponding to the target application system; the set of data table information includes multiple data table information;

[0160] Select target data table information from the set of data table information according to the identification information of each data table and the data table index order in the target application system;

[0161] According to the target data table information and the set of data table information, determine each association chain of the target data table and the corresponding association strength of each association chain through a data table association algorithm, and use each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system.

[0162] Optionally, the data table information includes the identification information of the data table. The selecting target data table information from the set of data table information according to the identification information of each data table and the data table index order in the target application system includes:

[0163] Determine the target data table ranked first in the index sequence according to the data table index order in the target application system;

[0164] In the set of data table information, determine the target data table information corresponding to the identification information of the target data table.

[0165] Optionally, the data table information includes the identification information of the data table, the identification information of each data table indexed by the data table, and the operation information between the data table and each data table indexed by the data table. The data table association algorithm includes a data table positioning algorithm and an association strength algorithm; the determining each association chain of the target data table and the corresponding association strength of each association chain through a data table association algorithm according to the target data table information and the set of data table information includes:

[0166] Determine each association chain of the target data table according to the identification information of each data table indexed by the target data table, the identification information of each data table in the set of data table information, the identification information of the data tables indexed by each data table in the set of data table information, and the data table positioning algorithm; the identification information of each data table in the association chain is arranged in index order;

[0167] For each association chain, determine the corresponding association strength of the association chain according to the operation information of each adjacent data table in the association chain and the association strength algorithm.

[0168] Optionally, determining each associated link of the target data table based on the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm includes:

[0169] Determining each initial data table associated link based on the identification information of the target data table, the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm;

[0170] Performing deduplication processing on each of the initial data table associated links to obtain each associated link of the target data table.

[0171] Optionally, determining the associated strength corresponding to the associated link based on the operation information of each adjacent data table information in the associated link and the associated strength algorithm includes:

[0172] Determining the associated strength corresponding to each pair of adjacent data table information according to the operation information of each pair of adjacent data table information in the associated link and the associated strength algorithm;

[0173] Determining the associated strength corresponding to the associated link according to the associated strengths corresponding to each of the adjacent data table information.

[0174] Optionally, the method further includes:

[0175] Sorting each of the associated links in the data table association information of the target application system in descending order according to the associated strength corresponding to each of the associated links to obtain the sorted data table association information of the target application system.

[0176] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties.

[0177] Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be completed by instructing relevant hardware through a computer program. The computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above methods. Among them, any reference to a memory, database, or other medium used in the embodiments provided in the present application can include at least one of non-volatile and volatile memories. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM), etc. The databases involved in the embodiments provided in the present application can include at least one of relational databases and non-relational databases. Non-relational databases can include distributed databases based on blockchain, etc., without limitation. The processors involved in the embodiments provided in the present application can be general-purpose processors, central processors, graphics processors, digital signal processors, programmable logic devices, data processing logics based on quantum computing, etc., without limitation.

[0178] The technical features of the above embodiments can be combined arbitrarily. For the sake of concise description, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, it should be considered as the scope described in this specification.

[0179] The above-described embodiments merely represent several implementation manners of the present application. The description is relatively specific and detailed, but it should not be construed as a limitation on the patent scope of the present application. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present application, several modifications and improvements can still be made, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the appended claims.

Claims

1. A method for determining data table association information, characterized in that, The method includes: Obtaining a data table information set and identification information of each data table corresponding to a target application system; the data table information set includes a plurality of data table information; The step of obtaining the identification information of each data table corresponding to the target application system includes: obtaining the current data table reference statement corresponding to the target application system; parsing the current data table reference statement to obtain the identification information of each data table corresponding to the target application system; wherein, the data table reference statement is code information for the target application system to reference a data table for data processing, and the data table reference statement includes: the identification information of the data table directly referenced by the target application system, the identification information of the indirectly referenced data table, and the index order relationship between the directly referenced data table and the indirectly referenced data table; Selecting target data table information from the data table information set according to the identification information of each data table and the data table index order in the target application system; The data table information includes the identification information of the data table. The step of selecting target data table information from the data table information set according to the identification information of each data table and the data table index order in the target application system includes: determining the target data table arranged at the head of the index sequence according to the data table index order in the target application system; in the data table information set, determining the target data table information corresponding to the identification information of the target data table; According to the target data table information and the data table information set, determining each association chain of the target data table and the corresponding association strength of each association chain through a data table association algorithm, and taking each association chain of the target data table and the association strength of each association chain as the data table association information of the target application system; The data table information includes the identification information of the data table, the identification information of each data table indexed by the data table, and the operation information between the data table and each data table indexed by the data table. The data table association algorithm includes a data table positioning algorithm and an association strength algorithm, and the operation information includes: query, merge, and operation; The step of determining each association chain of the target data table and the corresponding association strength of each association chain through a data table association algorithm according to the target data table information and the data table information set includes: determining each association chain of the target data table according to the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data table indexed by each data table in the data table information set, and the data table positioning algorithm; the identification information of each data table in the association chain is arranged in index order; for each association chain, determining the corresponding association strength of the association chain according to the operation information of each adjacent data table in the association chain and the association strength algorithm.

2. The method according to claim 1, wherein Determining each associated chain of the target data table based on the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm, includes: Determining each initial data table associated chain based on the identification information of each data table indexed by the target data table, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm; Performing a duplicate removal process on each of the initial data table associated chains to obtain each associated chain of the target data table.

3. The method according to claim 1, wherein Determining the associated strength corresponding to the associated chain based on the operation information of each adjacent data table information in the associated chain and the associated strength algorithm, includes: Determining the associated strength corresponding to each pair of adjacent data table information according to the operation information of each pair of adjacent data table information in the associated chain and the associated strength algorithm; Determining the associated strength corresponding to the associated chain according to the associated strength corresponding to each of the adjacent data table information.

4. The method according to claim 1, wherein The method further includes: Sorting each of the associated chains in the data table association information of the target application system in descending order of the associated strength corresponding to each associated chain to obtain the sorted data table association information of the target application system.

5. An apparatus for determining data table association information, characterized in that The apparatus includes: An acquisition module, configured to acquire a data table information set and the identification information of each data table corresponding to the target application system; the data table information set includes multiple data table information; The acquisition module includes: an acquisition sub-module, configured to acquire the currently corresponding data table reference statement of the target application system; a parsing sub-module, configured to parse the currently acquired data table reference statement to obtain the identification information of each data table corresponding to the target application system; wherein, the data table reference statement is the code information for the target application system to reference a data table for data processing, and the data table reference statement includes: the identification information of the data table directly referenced by the target application system, the identification information of the indirectly referenced data table, and the index sequence relationship between the directly referenced data table and the indirectly referenced data table; A selection module, configured to select target data table information in the data table information set according to the identification information of each data table in the index order in the target application system; The data table information includes the identification information of the data table. The selection module is specifically configured to: determine the target data table ranked first in the index sequence according to the data table index order in the target application system; and determine the target data table information corresponding to the identification information of the target data table in the data table information set; A determination module, configured to determine each associated chain of the target data table and the associated strength corresponding to each associated chain through a data table association algorithm according to the target data table information and the data table information set, and use each associated chain of the target data table and the associated strength of each associated chain as the data table association information of the target application system; The data table information includes the identification information of the data table, the identification information of each data table in the data table index, and the operation information between the data table and each data table in the data table index. The data table association algorithm includes a data table positioning algorithm and an association strength algorithm. The operation information includes: query, merge, and operation; The determining module is specifically configured to: determine each association chain of the target data table according to the identification information of each data table in the target data table index, the identification information of each data table in the data table information set, the identification information of the data tables indexed by each data table in the data table information set, and the data table positioning algorithm; the identification information of each data table in the association chain is arranged in the index order; for each association chain, determine the association strength corresponding to the association chain according to the operation information of each adjacent data table in the association chain and the association strength algorithm.

6. A computer device, comprising a memory and a processor, the memory storing a computer program, characterized in that, When the processor executes the computer program, the steps of the method according to any one of claims 1 to 4 are implemented.

7. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, the steps of the method according to any one of claims 1 to 4 are implemented.

8. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by the processor, the steps of the method according to any one of claims 1 to 4 are implemented.

Images