A data processing method and related apparatus

Abstract

This application discloses a data processing method and related apparatus, applicable to the fields of big data or finance. It uses common system data found in the system data of multiple business systems as key data. Then, it establishes a data link table between the system data of multiple business systems by utilizing the key data and its relationships with the system data of each of the multiple business systems. Since the key data consists of common system data found in the system data of multiple business systems, it serves as the basis for establishing the data link table. By utilizing the key data and its relationships, the system data of multiple business systems can be integrated to obtain a data link table that reflects the relationships between the system data of multiple business systems. This allows the data link table to be used to determine other data affected by changes in the system data of one business system, thereby saving labor costs.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to a data processing method and related apparatus. Background Technology

[0002] A data warehouse is a subject-oriented, integrated collection of data that reflects historical changes; it is a data management technology used to support management decision-making processes. A bank's data warehouse includes system data from various business systems within the bank, and it plays a crucial role in the development of banking operations.

[0003] As banking operations continue to develop, the number of business systems in bank data warehouses is increasing, and data interaction between these systems is inevitable. Specifically, when data in one business system within a bank's data warehouse is changed, it will affect other business systems and the changes to their data. For business data statistical analysis such as report compilation, it is necessary to identify the other business systems affected by the data change and the affected system data within those systems before performing such statistical analysis.

[0004] In related technologies, manual analysis is used to determine the impact of data changes in one business system on other business systems and the affected system data within those systems. However, this method is inefficient, costly, and prone to errors. Summary of the Invention

[0005] To address the aforementioned technical problems, this application provides a data processing method and related apparatus. By establishing a data link table, when the system data of a certain business system changes, the data link table can be used to determine other data affected by the change, thereby saving labor costs.

[0006] The embodiments of this application disclose the following technical solutions: On one hand, embodiments of this application provide a data processing method, the method comprising: Acquire system data from multiple business systems; Identify the common system data existing in the system data of the multiple business systems as key data; Obtain the correlation between the key data and the system data of each of the multiple business systems; Using the key data and the relationships, a data link table is established between the system data of the multiple business systems.

[0007] Optionally, the system data includes table data and field data; Therefore, obtaining the association between the key data and the system data of each of the multiple business systems includes: Obtain the first association relationship between the key data and the table data of each of the multiple business systems, and obtain the second association relationship between the key data and the field data of each of the multiple business systems; The step of establishing a data link table between the system data of the multiple business systems using the key data and the correlation relationships includes: A first mapping relationship is established between the table data of the multiple business systems using the key data and the first association relationship, and a second mapping relationship is established between the field data of the multiple business systems using the key data and the second association relationship; The data link table is determined based on the first mapping relationship and the second mapping relationship.

[0008] Optionally, the method further includes: Based on the data link table, perform business data statistical analysis; the business data statistical analysis includes one or more of the following: data analysis, lineage analysis, difference analysis, and importance analysis.

[0009] Optionally, the step of performing business data statistical analysis based on the data link table includes: When the first data in the system data changes, the scope of impact corresponding to the first data is determined according to the data link table; Use the system data within the scope of influence as the second data; Based on the changes to the first data and the relationship between the first data and the second data, the second data is updated to obtain the updated system data. The updated system data is used to perform statistical analysis of the business data.

[0010] Optionally, if the system data includes a data dictionary, the method further includes: Record the version update logs of the data dictionaries corresponding to the first data and the second data respectively.

[0011] Optionally, determining the common system data existing in the system data of the multiple business systems as key data includes: According to the data management rules of the metadata management system, the system data of the multiple business systems are integrated to obtain the integration result; Based on the integration results, the common data existing in the system data of the multiple business systems is identified as the key data.

[0012] Optionally, the integration of system data from the multiple business systems according to the data management rules of the metadata management system to obtain an integration result includes: Based on the standard data format of the metadata management system, the system data of the multiple business systems are converted to obtain the converted system data. The integration result is determined based on the converted system data.

[0013] Optionally, the method further includes: The data link table is displayed through the metadata management system.

[0014] On the other hand, embodiments of this application provide a data processing apparatus, the apparatus including an acquisition unit, a determination unit, and an establishment unit: The acquisition unit is used to acquire system data from multiple business systems; The determining unit is used to determine the same system data existing in the system data of the multiple business systems as key data. The acquisition unit is also used to acquire the association relationship between the key data and the system data of each of the multiple business systems; The establishment unit is used to establish a data link table between the system data of the multiple business systems using the key data and the correlation relationship.

[0015] Optionally, the system data includes table data and field data; The acquisition unit is further configured to acquire the first association relationship between the key data and the table data of each of the multiple business systems, and to acquire the second association relationship between the key data and the field data of each of the multiple business systems. The establishment unit is further configured to: A first mapping relationship is established between the table data of the multiple business systems using the key data and the first association relationship, and a second mapping relationship is established between the field data of the multiple business systems using the key data and the second association relationship; The data link table is determined based on the first mapping relationship and the second mapping relationship.

[0016] Optionally, the device further includes an analysis unit: The analysis unit is used to perform business data statistical analysis based on the data link table; the business data statistical analysis includes one or more of the following: data analysis, lineage analysis, difference analysis, and importance analysis.

[0017] Optionally, the analysis unit is further configured to: When the first data in the system data changes, the scope of impact corresponding to the first data is determined according to the data link table; Use the system data within the scope of influence as the second data; Based on the changes to the first data and the relationship between the first data and the second data, the second data is updated to obtain the updated system data. The updated system data is used to perform statistical analysis of the business data.

[0018] Optionally, if the system data includes a data dictionary, the device further includes a recording unit: The recording unit is used to record the version update logs of the data dictionaries corresponding to the first data and the second data, respectively.

[0019] Optionally, the determining unit is further configured to: According to the data management rules of the metadata management system, the system data of the multiple business systems are integrated to obtain the integration result; Based on the integration results, the common data existing in the system data of the multiple business systems is identified as the key data.

[0020] Optionally, the determining unit is further configured to: Based on the standard data format of the metadata management system, the system data of the multiple business systems are converted to obtain the converted system data. The integration result is determined based on the converted system data.

[0021] Optionally, the device further includes a display unit: The display unit is used to display the data link table through the metadata management system.

[0022] In another aspect, embodiments of this application provide a computer device, the computer device including a processor and a memory: The memory is used to store program code and transmit the program code to the processor; The processor is used to execute the data processing method described above according to the instructions in the program code.

[0023] As can be seen from the above technical solution, the system data of multiple business systems is first acquired, and the common system data existing in the system data of multiple business systems is used as key data. Then, using the key data and the relationships, a data link table is established between the system data of multiple business systems. Here, the relationship refers to the relationship between the key data and the system data of each of the multiple business systems. Since the key data is the common system data existing in the system data of multiple business systems, it is used as the basis for establishing the data link table. By using the relationship between the key data and the system data of each of the multiple business systems, the system data of multiple business systems can be integrated to obtain the data link table. This data link table can reflect the relationship between the system data of multiple business systems. Therefore, when the system data of a certain business system changes, the data link table can be used to determine the other data affected by the change, thereby saving labor costs. Attached Figure Description

[0024] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0025] Figure 1 A flowchart illustrating a data processing method provided in an embodiment of this application; Figure 2 This is a structural diagram of a data processing apparatus provided in an embodiment of this application. Detailed Implementation

[0026] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present application, and not all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative effort are within the scope of protection of the present application.

[0027] A data warehouse is a subject-oriented, integrated collection of data that reflects historical changes; it is a data management technology used to support management decision-making processes. A bank's data warehouse includes data from various internal business systems and plays a crucial role in the development of banking operations.

[0028] As banking operations continue to develop, the number of business systems in the bank's data warehouse is increasing, and data interaction between these systems is inevitable. For example, data interaction can cause changes in data in one business system within the bank's data warehouse to other business systems and their corresponding data.

[0029] For business personnel in various departments of a bank, statistical analysis of business data, such as report compilation, is a routine type of analytical work. Before conducting such statistical analysis, it is necessary to identify the other business systems affected by the changed system data, as well as the affected system data within those systems.

[0030] In related technologies, manual analysis is used to determine the impact of data changes in one business system on other business systems and the affected system data within those systems. However, this method is inefficient, costly, and prone to errors.

[0031] To address the aforementioned technical problems, this application provides a data processing method and related apparatus. By establishing a data link table, when the system data of a certain business system changes, the data link table can be used to determine other data affected by the change, thereby saving labor costs.

[0032] The data processing method provided in this application can be implemented using a computer device, which can be a terminal device or a server. The server can be an independent physical server, a server cluster or distributed system composed of multiple physical servers, or a cloud server providing cloud computing services. Terminal devices include, but are not limited to, mobile phones, computers, smart voice interaction devices, smart home appliances, and in-vehicle terminals. Terminal devices and servers can be directly or indirectly connected via wired or wireless communication, and this application does not impose any limitations in this regard.

[0033] It should be noted that the data processing method and related apparatus provided in this application can be used in the fields of big data or finance. The above is merely an example and does not limit the application areas of the data processing method and related apparatus provided in this application.

[0034] The following examples illustrate this in detail: Figure 1 A flowchart of a data processing method provided in this application embodiment. In this embodiment, a server is used as an example of the aforementioned computer device for description. The method includes S101-S104: S101: Obtain system data from multiple business systems.

[0035] A bank data warehouse comprises multiple business systems, each storing its own system data. To achieve unified management of this data, the system data from multiple business systems can be acquired first, followed by subsequent operations. The method for acquiring system data from multiple business systems can be selected based on the actual situation, and this application does not impose any limitations on this. Specifically, the embodiments of this application provide the following acquisition methods as examples: To facilitate business personnel in viewing system data, the system data of business systems is usually stored locally in the form of data files. Therefore, in one possible implementation, the system data of multiple business systems can be obtained by importing data files from multiple business systems and parsing the data files of each business system separately.

[0036] It is understandable that the format of the data file can be selected according to the actual situation, and this application does not impose any restrictions on it. For example, the data file format can be EXCEL, PDF, SQL, etc. Specifically, when each business system saves system data locally, it can choose the data file format to save according to its local storage conditions.

[0037] In some cases, the system data of a business system can be the data generated by the corresponding business in a pre-production environment. Generally, the data generated in the pre-production environment is stored in the pre-production environment database. Therefore, in one possible implementation, the data in the pre-production environment database can be extracted as system data by connecting the pre-production environments of multiple business systems.

[0038] Since the acquired system data from multiple business systems is used to establish data link tables in subsequent steps, supporting business personnel in performing specific business data statistical analysis such as report compilation, the specific content of the system data can be set according to actual business needs, and this application does not impose any restrictions on this. For example, the system data of a business system may include data categories such as table data, field data, data processing rules, business system name data, and business system version data. It is understandable that the more data categories included in the system data of a business system, the more computer resources are required. Therefore, setting the specific content of the system data of the business system according to actual business needs can make higher efficiency in utilizing computer resources.

[0039] S102: Identify the common system data that exists in the system data of multiple business systems as key data.

[0040] Business systems are generally categorized based on banking business types. Specifically, a business system can be used to store and manage data generated by a particular type of business, and this data can be considered the system data of that business system. However, in banking, business overlap between different types of business is common. Consequently, this overlap means that the data generated by these different types of business will also have common components, and these common components can reflect the relationships between the data generated by different types of business. That is, there will be identical system data in the system data of multiple business systems. The existence of identical system data can demonstrate the relationships between the system data of different business systems. Therefore, the identical system data existing in the system data of multiple business systems can be identified as key data for subsequent steps.

[0041] Because the system data of different business systems differs, in order to achieve unified and standardized management of system data from multiple business systems, one possible implementation is to integrate the system data of multiple business systems according to the data management rules of the metadata management system, obtain the integration result, and then determine the common data existing in the system data of multiple business systems as key data based on the integration result. Based on this, the system data of multiple business systems is integrated using the data management rules of the metadata management system, thereby achieving unified and standardized management of system data from multiple business systems. It should be noted that the metadata management system can be deployed on the aforementioned computer equipment; that is, the aforementioned computer equipment used to implement the data processing method provided in the embodiments of this application can be a computer equipment with a metadata management system deployed on it.

[0042] It is understandable that, since the data categories included in the system data of a business system can be set according to business needs, that is, the system data of a business system can include multiple data categories (such as table data, field data, and business system name data, etc.), in one possible implementation, the integration of system data of multiple business systems can be carried out by integrating each data category included in the system data, thereby determining the integration result.

[0043] Different business systems may have different data processing rules, leading to variations in the data formats of their system data. This can affect the unified and standardized management of system data from multiple business systems. Therefore, one possible approach is to convert the system data of each business system according to the standard data format of the metadata management system, obtaining converted system data. The integration result is then determined based on this converted system data. In this way, integrating the system data from different business systems into a standard data format conforming to the metadata management system facilitates unified and standardized management of system data from multiple business systems and also improves the utilization of system data.

[0044] S103: Obtain the correlation between key data and the system data of each of the multiple business systems.

[0045] Once the key data is identified, the correlation between the key data and the system data of each of the multiple business systems can be obtained to facilitate subsequent steps.

[0046] It should be noted that since the key data is the same system data existing in the system data of multiple business systems, that is, the key data can be system data A stored in the system data of every business system in multiple business systems, or it can be system data A stored only in the system data of some business systems in multiple business systems. Correspondingly, after taking system data A as the key data, in the former case, the association relationship between the key data and the system data of each business system in multiple business systems can be obtained. In the latter case, for those business systems that do not store system data A, the obtained association relationship can be empty.

[0047] S104: Utilize key data and relationships to establish a data link table between system data of multiple business systems.

[0048] After identifying key data and obtaining correlations, a data link table can be established to connect the system data of multiple business systems. This data link table reflects the relationships between the system data of multiple business systems. Specifically, key data can be used as the basis for establishing the data link table, and the system data of multiple business systems can be integrated using the correlations to obtain the data link table.

[0049] Since the data link table can reflect the relationships between system data of multiple business systems, in order to facilitate business personnel to view it, one possible implementation is to display the data link table through a metadata management system, so that business personnel can easily understand the relationships between system data of multiple business systems by viewing the data link table.

[0050] Generally, the table data and field data in the system data categories are records of data generated by the relevant business operations of the business system. They represent the relevant business situation of the business system; that is, statistical analysis of the relevant business situation of the business system can be performed using the table data and field data of the business system. Therefore, in one possible implementation, the system data may include table data and field data, and S103 may include the following steps: Obtain the first association between key data and the table data of each business system in multiple business systems, and obtain the second association between key data and the field data of each business system in multiple business systems; S104 may include the following steps: Establish a first mapping relationship between table data of multiple business systems using key data and first association relationship, and establish a second mapping relationship between field data of multiple business systems using key data and second association relationship; The data link table is determined based on the first and second mapping relationships.

[0051] As can be seen, if the system data includes table data and field data, the association between the key data and the system data of each of the multiple business systems can be subdivided into two parts: a first association between the key data and the table data of each of the multiple business systems, and a second association between the key data and the field data of each of the multiple business systems. Correspondingly, based on the first and second associations, a first mapping relationship between the table data of the multiple business systems and a second mapping relationship between the field data of the multiple business systems are established. Finally, the data link table is determined according to the first and second mapping relationships. It should be noted that the method of determining the data link table based on the first and second mapping relationships can be set according to the actual situation, and this application does not impose any limitations on it. Specifically, the following method is provided as an example in the embodiments of this application: Since the first mapping relationship between table data and the second mapping relationship between field data can reflect the association between system data at different granular levels, in one possible implementation, the first mapping relationship can be defined as a first data link table, and the second mapping relationship as a second data link table. Therefore, the aforementioned data link tables include both the first and second data link tables. Ultimately, the first and second data link tables can be displayed separately through a metadata management system, allowing business personnel to obtain the association between system data from multiple business systems at different granular levels.

[0052] Generally, field data can be data from table data. Therefore, in one possible implementation, the first and second mapping relationships can be integrated to obtain an integrated mapping relationship, which is then used as the data link table. Based on this, business personnel only need to view the integrated data link table to obtain the relationships between system data from multiple business systems.

[0053] For business personnel, statistical analysis, such as report generation, often requires data from multiple business systems. Since a data link table can demonstrate the relationships between system data from multiple business systems, one possible implementation involves establishing this table and then using it for statistical analysis. This analysis can include one or more of the following: data analysis, lineage analysis, variance analysis, and importance analysis. Therefore, the data link table displays the relationships between system data from multiple business systems to business personnel, allowing them to quickly determine the data range needed for report generation. Clearly, the data link table supports business personnel in their work and helps improve their efficiency.

[0054] As business operations evolve, system data within business systems also undergoes changes, such as additions, deletions, modifications, and queries. Due to overlapping business operations, a change in data within one business system may affect the data in other business systems. In such cases, to ensure the accuracy of report statistics, business personnel often need to first determine the scope of the change's impact and then apply the appropriate changes to the affected system data before compiling reports. However, manually determining the scope of impact of system data changes is inefficient, error-prone, and requires significant labor costs.

[0055] Because data link tables can reflect the relationships between system data from multiple business systems, they can be used to assist in specific data statistical analysis tasks such as report compilation when system data changes. In one possible implementation, when the first piece of system data changes, the data link table can be used to determine the scope of impact of the first piece of data. System data within this scope is then used as the second piece of data. Based on the changes to the first piece of data and the relationship between the first and second pieces of data, the second piece of data is updated to obtain the updated system data. Finally, the updated system data is used for business data statistical analysis. This improves data processing efficiency and reduces labor costs.

[0056] Generally, the set of all data elements in a business system's system data can be defined as a data dictionary. Therefore, when a piece of system data in the business system changes, the business system's data dictionary also changes; this can be considered a version iteration of the data dictionary. To enable business personnel to better understand the data dictionary's iteration process, in one possible implementation, if the system data includes a data dictionary, version update logs can be recorded separately for the first and second pieces of data. Based on this, version management of the business system's data dictionary is achieved, allowing business personnel to trace the data dictionary's version by viewing the version update logs, and then perform business tasks such as change analysis based on specific business needs.

[0057] As can be seen from the above technical solution, the system data of multiple business systems is first acquired, and the common system data existing in the system data of multiple business systems is used as key data. Then, using the key data and the relationships, a data link table is established between the system data of multiple business systems. Here, the relationship refers to the relationship between the key data and the system data of each of the multiple business systems. Since the key data is the common system data existing in the system data of multiple business systems, it is used as the basis for establishing the data link table. By using the relationship between the key data and the system data of each of the multiple business systems, the system data of multiple business systems can be integrated to obtain the data link table. This data link table can reflect the relationship between the system data of multiple business systems. Therefore, when the system data of a certain business system changes, the data link table can be used to determine the other data affected by the change, thereby saving labor costs.

[0058] Figure 2 This is a structural diagram of a data processing apparatus provided in an embodiment of this application. The apparatus includes an acquisition unit 201, a determination unit 202, and a creation unit 203. The acquisition unit 201 is used to acquire system data from multiple business systems; The determining unit 202 is used to determine the same system data existing in the system data of the multiple business systems as key data; The acquisition unit 201 is also used to acquire the association relationship between the key data and the system data of each of the multiple business systems; The establishment unit 203 is used to establish a data link table between the system data of the multiple business systems using the key data and the correlation relationship.

[0059] Optionally, the system data includes table data and field data; The acquisition unit is further configured to acquire the first association relationship between the key data and the table data of each of the multiple business systems, and to acquire the second association relationship between the key data and the field data of each of the multiple business systems. The establishment unit is further configured to: A first mapping relationship is established between the table data of the multiple business systems using the key data and the first association relationship, and a second mapping relationship is established between the field data of the multiple business systems using the key data and the second association relationship; The data link table is determined based on the first mapping relationship and the second mapping relationship.

[0060] Optionally, the device further includes an analysis unit: The analysis unit is used to perform business data statistical analysis based on the data link table; the business data statistical analysis includes one or more of the following: data analysis, lineage analysis, difference analysis, and importance analysis.

[0061] Optionally, the analysis unit is further configured to: When the first data in the system data changes, the scope of impact corresponding to the first data is determined according to the data link table; Use the system data within the scope of influence as the second data; Based on the changes to the first data and the relationship between the first data and the second data, the second data is updated to obtain the updated system data. The updated system data is used to perform statistical analysis of the business data.

[0062] Optionally, if the system data includes a data dictionary, the device further includes a recording unit: The recording unit is used to record the version update logs of the data dictionaries corresponding to the first data and the second data, respectively.

[0063] Optionally, the determining unit is further configured to: According to the data management rules of the metadata management system, the system data of the multiple business systems are integrated to obtain the integration result; Based on the integration results, the common data existing in the system data of the multiple business systems is identified as the key data.

[0064] Optionally, the determining unit is further configured to: Based on the standard data format of the metadata management system, the system data of the multiple business systems are converted to obtain the converted system data. The integration result is determined based on the converted system data.

[0065] Optionally, the device further includes a display unit: The display unit is used to display the data link table through the metadata management system.

[0066] As can be seen from the above technical solution, the system data of multiple business systems is first acquired, and the common system data existing in the system data of multiple business systems is used as key data. Then, using the key data and the relationships, a data link table is established between the system data of multiple business systems. Here, the relationship refers to the relationship between the key data and the system data of each of the multiple business systems. Since the key data is the common system data existing in the system data of multiple business systems, it is used as the basis for establishing the data link table. By using the relationship between the key data and the system data of each of the multiple business systems, the system data of multiple business systems can be integrated to obtain the data link table. This data link table can reflect the relationship between the system data of multiple business systems. Therefore, when the system data of a certain business system changes, the data link table can be used to determine the other data affected by the change, thereby saving labor costs.

[0067] In another aspect, embodiments of this application provide a computer device, the computer device including a processor and a memory: The memory is used to store program code and transmit the program code to the processor; The processor is used to execute the data processing method provided in the above embodiments according to the instructions in the program code.

[0068] The computer device may include a terminal device or a server, and the aforementioned data processing device may be configured in the computer device.

[0069] Those skilled in the art will understand that all or part of the steps of the above method embodiments can be implemented by program instructions in hardware. The aforementioned program can be stored in a computer-readable storage medium. When the program is executed, it performs the steps of the above method embodiments. The aforementioned storage medium can be at least one of the following media: read-only memory (ROM), RAM, magnetic disk, or optical disk, etc., and other media capable of storing program code.

[0070] For the device embodiments, since they basically correspond to the method embodiments, the relevant parts can be referred to in the description of the method embodiments. The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without creative effort.

[0071] It should be noted that, in this document, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element.

[0072] The data processing method and related apparatus provided in the embodiments of this application have been described in detail above. Specific examples have been used to illustrate the principles and implementation methods of this application. The descriptions of the embodiments above are only for the purpose of helping to understand the method of this application. At the same time, those skilled in the art will recognize that there will be changes in the specific implementation methods and application scope based on the method of this application.

[0073] In summary, the content of this specification should not be construed as limiting this application. Any variations or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in this application should be included within the protection scope of this application. Furthermore, based on the implementation methods provided in the above aspects, this application can be further combined to provide more implementation methods.

Claims

1. A data processing method, characterized by, The method includes: Acquire system data from multiple business systems; the system data of the business systems includes table data, field data, data processing rules, business system name data, and business system version data of the business systems, the multiple business systems correspond to different business types, and there is business overlap between different business types; Identify the common system data existing in the system data of the multiple business systems as key data; Obtain the correlation between the key data and the system data of each of the multiple business systems; Using the key data and the relationships, establish a data link table between the system data of the multiple business systems; When the first data in the system data changes, the scope of impact corresponding to the first data is determined according to the data link table; Use the system data within the scope of influence as the second data; Based on the changes to the first data and the relationship between the first data and the second data, the second data is updated to obtain the updated system data. Utilize the updated system data for business data statistical analysis; The system data includes table data and field data; therefore, obtaining the association between the key data and the system data of each of the multiple business systems includes: Obtain the first association relationship between the key data and the table data of each of the multiple business systems, and obtain the second association relationship between the key data and the field data of each of the multiple business systems; The step of establishing a data link table between the system data of the multiple business systems using the key data and the correlation relationships includes: A first mapping relationship is established between the table data of the multiple business systems using the key data and the first association relationship, and a second mapping relationship is established between the field data of the multiple business systems using the key data and the second association relationship; The data link table is determined based on the first mapping relationship and the second mapping relationship.

2. The method according to claim 1, characterized in that, The business data statistical analysis includes one or more of the following: data analysis, lineage analysis, difference analysis, and importance analysis.

3. The method according to claim 1, characterized in that, If the system data includes a data dictionary, the method further includes: Record the version update logs of the data dictionaries corresponding to the first data and the second data respectively.

4. The method according to any one of claims 1-3, characterized in that, The step of identifying identical system data existing in the system data of the multiple business systems as key data includes: According to the data management rules of the metadata management system, the system data of the multiple business systems are integrated to obtain the integration result; Based on the integration results, the common data existing in the system data of the multiple business systems is identified as the key data.

5. The method according to claim 4, characterized in that, The process involves integrating the system data of the multiple business systems according to the data management rules of the metadata management system to obtain the integration result, including: Based on the standard data format of the metadata management system, the system data of the multiple business systems are converted to obtain the converted system data. The integration result is determined based on the converted system data.

6. The method according to claim 4, characterized in that, The method further includes: The data link table is displayed through the metadata management system.

7. A data processing apparatus, characterized in that, The device includes an acquisition unit, a determination unit, an establishment unit, and an analysis unit: The acquisition unit is used to acquire system data from multiple business systems. The system data of the business systems includes table data, field data, data processing rules, business system name data, and business system version data. The multiple business systems correspond to different business types, and there is business overlap between different business types. The determining unit is used to determine the same system data existing in the system data of the multiple business systems as key data. The acquisition unit is also used to acquire the association relationship between the key data and the system data of each of the multiple business systems; The establishment unit is used to establish a data link table between the system data of the multiple business systems using the key data and the correlation relationship; The analysis unit is also used for: When the first data in the system data changes, the scope of impact corresponding to the first data is determined according to the data link table; Use the system data within the scope of influence as the second data; Based on the changes to the first data and the relationship between the first data and the second data, the second data is updated to obtain the updated system data. Utilize the updated system data for business data statistical analysis; The system data includes table data and field data; therefore, the acquisition unit is further used for: Obtain the first association relationship between the key data and the table data of each of the multiple business systems, and obtain the second association relationship between the key data and the field data of each of the multiple business systems; The establishment unit is also used for: A first mapping relationship is established between the table data of the multiple business systems using the key data and the first association relationship, and a second mapping relationship is established between the field data of the multiple business systems using the key data and the second association relationship; The data link table is determined based on the first mapping relationship and the second mapping relationship.

8. A computer device, characterized in that, The computer device includes a processor and memory: The memory is used to store program code and transmit the program code to the processor; The processor is configured to execute the method described in any one of claims 1-6 according to the instructions in the program code.

Images