Data relation analysis method, device, equipment, medium and program

By configuring the database log system and analyzing data operation records, and identifying the logical data entities of business objects, the efficiency and accuracy problems of enterprises when identifying and sorting out old system data resource directories are solved, and more efficient data management and reuse are achieved.

CN119903097APending Publication Date: 2025-04-29HUAWEI CLOUD COMPUTING TECHNOLOGIES CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410370117.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Priority Date
2023-10-26
Filing Date
2024-03-28
Publication Date
2025-04-29

AI Technical Summary

Technical Problem

During the process of data resource processing, it is difficult for enterprises to effectively identify and sort out the logical data entities of old systems, resulting in inaccuracy and inefficiency of data resource catalogs, which in turn affects data management and reuse.

Method used

By configuring the log system of the business system's database for the data resource directory, monitoring and parsing the database's data operation records, and determining the logical data entity corresponding to the business object. The method includes obtaining data operation records from the log system of the database, parsing the logs to identify data table operations, and constructing a logical data entity based on the operation records.

Benefits of technology

It improves the efficiency and accuracy of logical data entity identification in old systems, helps enterprises to accurately sort out the data resource catalog, enhances the use of data source systems and data reuse, eliminates data silos, and improves data quality.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119903097A_ABST
    Figure CN119903097A_ABST
Patent Text Reader

Abstract

The invention provides a data relation analysis method and device, equipment, a medium and a program, and relates to the technical field of data resource processing. The method comprises the steps that a log system of a database of a service system is configured for a data resource directory, the database is used for recording data of the service system, and the log system of the database is used for recording data operation records of the database. The method further includes if a service function in the service system corresponding to the service object in the data resource directory is operated, acquiring a corresponding data operation record of the database from a log system of the configured database, the corresponding data operation record of the database corresponding to the operation. The method further includes determining a logical data entity corresponding to the business object according to a data operation record of the database, wherein the logical data entity is a set of attributes describing business features of the business object. According to the embodiment of the invention, the identification efficiency and accuracy of the logic data entity of the system are improved, the reuse of the data is enhanced, and the data quality is improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The embodiments of the present application mainly relate to the field of data resource processing. More specifically, the embodiments of the present application relate to a data relationship analysis method, apparatus, device, medium and program. Background Art

[0002] As the amount of enterprise data grows, the management of data resources becomes increasingly important. Data resource management involves data storage, backup, recovery, sharing, security, etc., which requires a complete processing system and technical support. Due to the large and complex amount of data, in order to help enterprises effectively utilize and manage their huge data resources and support business processes, decision-making and compliance requirements, enterprises need to design data resource directories and sort out data distribution when processing data.

[0003] The purpose of designing a data resource directory is to provide a comprehensive list of data resources, including information such as the source, type, quality, storage location, and usage permissions of the data. This directory should list the attributes of each data resource in detail so that users and managers within the enterprise can understand and find the required data. In addition, the data resource directory can also serve as the infrastructure of enterprise data management, providing enterprises with functions such as data resource management, monitoring, and optimization. However, there are still many problems that need to be solved in the process of data source processing. Summary of the invention

[0004] The embodiments of the present application provide a data relationship analysis solution.

[0005] According to the first aspect of the present application, a data relationship analysis method is provided. The method includes configuring a log system of a database of a business system for a data resource directory, the database is used to record data of the business system, and the log system of the database is used to record data operation records of the database; if a business function in the business system corresponding to a business object in the data resource directory is operated, the corresponding data operation record of the database is obtained from the configured log system of the database, and the corresponding data operation record of the database corresponds to the operation; according to the data operation record of the database, the logical data entity corresponding to the business object is determined, and the logical data entity is a collection of attributes that describe the business characteristics of the business object.

[0006] In this way, by monitoring the log system of the business system's database, it is possible to determine what operations have been performed on the database, and thus determine the logical data entities corresponding to the business objects. This improves the efficiency and accuracy of logical data entity identification in legacy systems, thereby helping enterprises accurately sort out the data resource catalog of legacy systems, enhancing users' use of data source systems and reuse of data, eliminating data silos, and improving data quality.

[0007] In some embodiments, obtaining the corresponding data operation record of the database from the configured database log system includes: parsing the database log in the database log system; and obtaining the corresponding data operation record of the database from the parsed database log. In this way, the data operation record corresponding to the business function can be quickly found.

[0008] In some embodiments, the method further includes: if the connection with the database fails, recording the location of the parsed database log; and if the connection with the database is restored, parsing the re-acquired database log based on the location. In this way, the parsing of the log can be quickly restored when the parsing of the log fails, and the accuracy of the parsing is guaranteed.

[0009] In some embodiments, determining the logical data entity corresponding to the business object according to the data operation record of the database includes: determining a group of data tables in the database on which the adjustment operation is performed based on the data operation record of the database; and determining the logical data entity based on the group of data tables. In this way, the logical data entity corresponding to the business object can be quickly determined from the data table.

[0010] In some embodiments, determining the logical data entity based on a set of data tables includes: determining a data table in a set of data tables as the logical data entity; or determining a new data table generated based on a set of data tables as the logical data entity. In this way, the logical data entity corresponding to the business object can be quickly determined from the data table.

[0011] In some embodiments, determining a new data table generated based on a set of data tables as a logical data entity includes: obtaining a new data table by combining multiple fields in a set of data tables; or obtaining a new data table by splitting a data table in a set of data tables. In this way, the logical data entity corresponding to the business object can be adjusted as needed, thereby improving the usability of data assets.

[0012] In some embodiments, the method further includes: determining a target data table to be inserted from a set of data tables; and determining the target data table as a data source table for the attribute of the business feature. In this way, the data source table of the attribute can be determined quickly and accurately.

[0013] In some embodiments, obtaining the corresponding data operation record of the database from the log system of the configured database includes: determining a start time for obtaining the data operation record in the log system of the database, the operation is performed after the start time; and obtaining the data operation record after the start time. In this way, the data operation record associated with the operation can be obtained quickly and accurately.

[0014] In some embodiments, obtaining the corresponding data operation record of the database from the configured log system of the database includes: detecting whether there is a new log file in the log system of the database; and if there is a new log file in the log system of the database, obtaining the corresponding data operation record of the database from the new log file. In this way, a complete data operation record can be obtained, ensuring the accuracy of the data operation record.

[0015] In some embodiments, the operation causes the business system to send a data operation instruction to the database, and the data operation instruction is used to instruct the database to perform at least one operation of adding, deleting, modifying, and searching. In this way, various adjustment operations can be performed on the database.

[0016] According to the second aspect of the present application, a data relationship analysis device is provided. The device includes a log system configuration unit, configured to configure a log system of a database of a business system for a data resource directory, the database is used to record data of the business system, and the log system of the database is used to record data operation records of the database; a data operation record acquisition unit, configured to acquire corresponding data operation records of the database from the log system of the configured database if a business function in the business system corresponding to a business object in the data resource directory is operated, the corresponding data operation record of the database corresponds to the operation; a logical data entity determination unit, configured to determine the logical data entity corresponding to the business object according to the data operation record of the database, the logical data entity being a collection of attributes describing the business characteristics of the business object.

[0017] In some embodiments, the data operation record acquisition unit includes: a parsing unit configured to parse the database log in the log system of the database; and a record acquisition unit configured to acquire the corresponding data operation record of the database from the parsed database log.

[0018] In some embodiments, the device also includes: a location recording unit configured to record the location of the parsed database log if the connection with the database fails; and a retrieval unit configured to parse the re-retrieved database log based on the location if the connection with the database is restored.

[0019] In some embodiments, the logical data entity determination unit includes: a data table determination unit, configured to determine a group of data tables in the database on which adjustment operations are performed based on data operation records of the database; and a first logical data entity unit, configured to determine the logical data entity based on a group of data tables.

[0020] In some embodiments, the first logical data entity unit includes: a second logical entity determination unit, configured to determine a data table among the set of data tables as a logical data entity; or a third logical entity determination unit, configured to determine a new data table generated based on a set of data tables as a logical data entity.

[0021] In some embodiments, the third logical entity determination unit includes: a combination unit, configured to obtain a new data table by combining multiple fields in a set of data tables; or a splitting unit, configured to obtain a new data table by splitting one data table in a set of data tables.

[0022] In some embodiments, the device also includes: a target data table determination unit, configured to determine the target data table on which the insert operation is performed from a group of data tables; and a data source table determination unit, configured to determine the target data table as a data source table for attributes of the business feature.

[0023] In some embodiments, the data operation record acquisition unit includes: a start time determination unit, configured to determine the start time of the data operation record in the log system for acquiring the database, the operation being performed after the start time; and an acquisition unit, configured to acquire the data operation record after the start time.

[0024] In some embodiments, the data operation record acquisition unit includes: a detection unit configured to detect whether there is a new log file in the log system of the database; and a log acquisition unit configured to obtain the corresponding data operation record of the database from the new log file if there is a new log file in the log system of the database.

[0025] In some embodiments, the operation causes the business system to send a data operation instruction to the database, and the data operation instruction is used to instruct the database to perform at least one operation of adding, deleting, modifying, and searching.

[0026] According to the third aspect of the present application, an electronic device is also provided, comprising: at least one computing unit; and at least one memory, wherein the at least one memory is coupled to the at least one computing unit and stores instructions for execution by the at least one computing unit, wherein when the instructions are executed by the at least one computing unit, the device executes the method described in the first aspect of the present application.

[0027] According to a fourth aspect of the present application, a computer-readable storage medium is further provided, on which a computer program is stored, and when the program is executed by a processor, the method described in the first aspect of the present application is implemented.

[0028] According to a fifth aspect of the present application, a computer program product is also provided, comprising computer executable instructions, wherein the computer executable instructions, when executed by a processor, implement the method according to the first aspect of the present application.

[0029] It can be understood that the device of the second aspect, the electronic device of the third aspect, the computer storage medium of the fourth aspect, or the computer program product of the fifth aspect provided above is used to execute the method provided in the first aspect. Therefore, the explanation or description of the first aspect is also applicable to the second aspect, the third aspect, the fourth aspect, and the fifth aspect. In addition, the beneficial effects that can be achieved in the second aspect, the third aspect, the fourth aspect, and the fifth aspect can refer to the beneficial effects in the corresponding method, which will not be repeated here. BRIEF DESCRIPTION OF THE DRAWINGS

[0030] The above and other features, advantages and aspects of the embodiments of the present application will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings.

[0031] In the accompanying drawings, the same or similar reference numerals represent the same or similar elements, wherein:

[0032] Figure 1 A schematic diagram showing an example environment in which various embodiments of the present application can be implemented;

[0033] Figure 2 A flowchart of a data relationship analysis method according to some embodiments of the present application is shown;

[0034] Figure 3 A schematic diagram showing an example of establishing a mapping between a business object and a logical data entity according to some embodiments of the present application;

[0035] Figure 4 A schematic diagram showing an example of a process of establishing a mapping between a business object and a logical data entity according to some embodiments of the present application;

[0036] Figure 5 A schematic diagram showing an example of business functions of a business object according to some embodiments of the present application;

[0037] Figure 6 A schematic diagram showing an example of the working process of the log collection and analysis system according to some embodiments of the present application;

[0038] Figure 7A schematic diagram showing an example of a log collection and analysis process according to some embodiments of the present application;

[0039] Figure 8 A schematic diagram showing an example of a process for establishing a mapping between a business object and a logical data entity according to some embodiments of the present application;

[0040] Fig. 9 A schematic diagram showing an example of a data resource directory according to some embodiments of the present application;

[0041] Fig.10 A block diagram showing an apparatus according to some embodiments of the present application; and

[0042] Fig.11 A block diagram of a computing device capable of implementing various embodiments of the present application is shown. DETAILED DESCRIPTION

[0043] The embodiments of the present application will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present application are shown in the accompanying drawings, it should be understood that the present application can be implemented in various forms and should not be construed as being limited to the embodiments described herein. Instead, these embodiments are provided to provide a more thorough and complete understanding of the present application. It should be understood that the drawings and embodiments of the present application are only for exemplary purposes and are not intended to limit the scope of protection of the present application.

[0044] In the description of the embodiments of the present application, the term "including" and similar terms should be understood as open inclusion, that is, "including but not limited to". The term "based on" should be understood as "based at least in part on". The term "one embodiment" or "the embodiment" should be understood as "at least one embodiment". The terms "first", "second", etc. may refer to different or the same objects. Other explicit and implicit definitions may also be included below.

[0045] As mentioned above, there are still many problems to be solved in the process of data source processing. For example, the data resource directory is a list of data resources of the company, which is displayed in a hierarchical data directory and is mainly used to clarify and describe the data resources of the company. When designing the data resource directory, it is necessary to sort out the business objects and define the logical data entities under each business object. For example, the data resource directory can be divided into five levels L1-L5. L1 is the subject domain grouping, which is the top-level data classification of the company, reflecting the business field of the highest level of the company through the data perspective. L2 is the subject domain, which is a high-level classification of non-overlapping data, used to manage the business objects at the next level. L3 is the business object, which is an important person, thing, and thing in the business field, carrying important data involved in business operation and management. L4 is a logical data entity, which is a set of attributes that describe a certain business feature of the business object. L5 is an attribute, which describes the nature and characteristics of the business object to which it belongs. The business object can be a function or a set of functions in the business system. A business object can represent a relatively independent business event. For example, in the airport management system, the two events of aircraft release and aircraft storage can constitute two relatively independent business objects. The business object is carried by a function or a series of functions in the business system. For example, in the process of aircraft release, it is necessary to enter the aircraft code of the aircraft to be released, the time when the aircraft release instruction is issued, and the exact time when the aircraft actually takes off, etc. The logical data entity is the specific data embodiment of the business object in the IT system. For example, all aircraft release data can be recorded in the same database table, and the table name of the database table is "aircraft release". In this case, the table name of the table can represent the logical data entity. Of course, the data can also be recorded in multiple tables, or the data of multiple business objects can also be recorded in the same table. The present invention does not limit this.

[0046] When constructing a data resource directory, a combination of top-down and bottom-up approaches is usually used. Top-down means that based on inputs such as business fields, management boundaries, process architecture, and business development, the subject domain design is completed after extensive discussions with business personnel through information communication, and then the people, things, and objects involved in the business within the enterprise or field are identified and abstracted as business objects at a higher level. According to business relevance, they are assigned to the corresponding subject domain to complete the design of the data resource directory L1-L3. Bottom-up means studying the current status of all information systems of the enterprise, determining what data there is and where it is stored; then uniformly collecting and storing information system data; and finally organizing the collected system data items, including field names, types, lengths, constraints, etc., to output a complete database table list. The data items organized from the bottom up are mapped with the L1-L3 output from the top down, cross-validated, and complemented with each other to complete the identification of logical data entities and the connection with business objects, thereby completing the compilation of the data resource directory.

[0047] The traditional method of identifying logical data entities is to sort out the information of the business function modules and the database table information under each module based on the full understanding of the enterprise information technology personnel and business personnel, and complete the connection with the business object by relying on personal experience or viewing the source code. For systems that have been online for a long time and have undergone multiple changes in development and maintenance personnel, enterprise information technology personnel and business personnel cannot clearly understand the function modules of the system and the database table information under each function module, resulting in the inability to complete the identification of logical data entities and data source tables. In addition, for new systems, business personnel and information technology personnel generally cannot accurately understand which business function all the fields in a database table correspond to without looking through the source code, and thus cannot accurately complete the identification of logical data entities and the association with business objects. Therefore, the accuracy and efficiency of the above method in identifying logical data entities are relatively low.

[0048] In order to solve at least some of the above problems and other potential problems, in an embodiment of the present application, when analyzing data relationships, the computing device configures a log system of a database of a business system for the data resource directory, wherein the database is used to record data of the business system, and the log system of the database is used to record data operation records of the database. If a business function in the business system corresponding to a business object in the data resource directory is operated, the computing device can obtain the corresponding data operation record in the database from the log system of the configured database, because the corresponding data operation record of the database corresponds to the operation. Next, the computing device further uses the data operation record of the database to determine the logical data entity corresponding to the business object, wherein the logical data entity is a collection of attributes describing the business characteristics of the business object. In this way, by using the data operation record obtained when operating the business function on the operation interface of the business function, it is determined which data tables are operated, so that the logical data entity corresponding to the business object can be determined, which improves the efficiency and accuracy of the recognition of the logical data entity of the old system, thereby helping enterprises to accurately sort out the data resource directory of the old system, enhance the user's use of the data source system and the reuse of data, eliminate data islands, and improve data quality.

[0049] The embodiments of the present application are further described below in conjunction with the accompanying drawings. Figure 1 1 is a schematic diagram of an example environment 100 in which various embodiments of the present application can be implemented. Figure 1 As shown, example environment 100 includes computing device 102. Computing device 102 includes, but is not limited to, vehicle-mounted computing devices, personal computers, handheld or laptop devices, mobile devices, multiprocessor systems, consumer electronics, minicomputers, mainframe computers, and the like.

[0050] The computing device 102 can be used to provide users with various applications and network services. For example, a user can access the company's business system interface or the webpage of the business system through the computing device 102, and can perform business function operations on the operation interface corresponding to certain business functions in the business system. In one example, an administrator of an airline company performs a flight release implementation business function through an operation interface corresponding to the flight release implementation business function in its website.

[0051] The computing device 102 is connected to a group of databases 106 via a network 104. The network 104 may be an intranet of an enterprise, or a local area network or the Internet. A group of databases 106 is used to store data to be stored generated by the business function operation on the computing device 102. For the operation of the data in the database, the log system of the database in the group of databases 106 will generate corresponding log information to record the corresponding data operation record. In some embodiments, a group of databases 106 includes one database. In some embodiments, a group of databases includes multiple databases. In some embodiments, a group of databases 106 may be a local database of the computing device 102. In some embodiments, a group of databases 106 is a database located on the cloud. In some embodiments, a part of the databases in a group of databases are local databases of the computing device 102, and another part of the databases are databases connected to the computing device 102 via a network. The above examples are only used to describe the present disclosure, and are not specific limitations of the present disclosure.

[0052] The example environment 100 also includes a computing device 108, which may be a personal computer, a handheld or laptop device, a mobile device, a multiprocessor system, a consumer electronic product, a minicomputer, a mainframe computer, a server, such as a cloud server providing cloud services, or a distributed computing device. The computing device 108 may obtain database logs generated by a user performing operations on the computing device 102 in the operation interface of the business function from a set of databases 106. The computing device 108 may determine the logical data entity table corresponding to the business function operation by analyzing the data operation records recorded in the database log, thereby helping the business personnel to complete the establishment of the data resource directory. Figure 1 102 is shown to be connected to computing device 108 via a network, which is only an example and not a specific limitation of the present disclosure. In some embodiments, computing device 102 and computing device 108 can be the same device, or two devices directly connected via wired or wireless.

[0053] As described above, the computing device 102 provides an operation interface corresponding to certain business functions. When the user operates it, it will cause changes in the database, thereby generating a corresponding database log to record data operation records. At this time, the computing device 108 can obtain the database log associated with the operation from the log system of one or more databases in a group of databases 106. The database log records which operations the business function operation has performed on the database. Therefore, the computing device 108 can determine the adjustment operations that have been performed on a group of data tables in a group of databases from the obtained database log. Then the computing device 108 determines the logical data entity associated with the business object based on these operations. The logical data entity is a collection of attributes that describe the business characteristics of the business object. Thus, a mapping relationship can be established between the L3-level business objects in the data resource directory and the L4-level logical data entities.

[0054] In some embodiments, the computing device 108 can analyze the logs obtained from the log system of the database, wherein the log analysis is implemented by the database log collection and analysis system. The database log collection and analysis system includes: a database log collection and storage module. The module is used to collect the incremental log data generated by the system database in real time, and the log data is locally saved, so that after the database log file is deleted by mistake or discarded by the system, the locally saved log file can be restored to the database for log analysis. The database log collection and analysis system also includes a database log analysis processing module, which is used to parse and convert the log data collected by the database log collection and storage module into a standard log format, and at the same time, according to the order of the log records, extract the database name, mode (SCHEMA) name, table name, change field name, operation type and other database table information recorded in the incremental log, which can also be called the description information for describing the adjustment operation performed on the data table in the database. In addition, the system can further use the extracted database table information to determine the logical data entity corresponding to the business function.

[0055] In some embodiments, the database log collection and analysis system supports multiple types of databases, such as various types of relational databases. As long as the database can record operation logs, the above method of the present application can be used. Database log extraction can support various log mining and extraction tools. When analyzing the logs after data collection, any suitable method can be used, such as processing through artificial intelligence technology to improve analysis efficiency.

[0056] In some embodiments, the accuracy of database log collection and analysis and the accuracy of logical data entity recognition are verified by checking whether the database table information obtained by parsing the database log contains the flag data entered during the front-end business function operation. Figure 5The alternate airport information shown in ; the marking data is usually the enterprise master data, which can be inserted into the database normally and will not be processed by the system code logic and cannot be identified in the database log.

[0057] In some embodiments, the business system and the database log collection and analysis system can be located on the computing device 108 at the same time. For example, when the computing device is a server, the business system and the database log collection and analysis system can be set up on the server as cloud services. Additionally, the computing device 108 can be implemented by multiple distributed servers in the network.

[0058] In some embodiments, when the business function modules corresponding to the business objects span multiple business systems, the database log collection and analysis system supports concurrent connection to multiple business databases, can parse the log files in multiple databases according to the recording time, and then combine them to output database table information. In some embodiments, when the front-end business function operations related to multiple business objects act on the same table, the logical data entity can be identified and connected to the business object according to the business meaning and the order of the business function operations.

[0059] In this way, the logs obtained when operating business functions on the business function operation interface are used to determine which data tables have been operated, so that the logical data entities corresponding to the business objects can be determined. This improves the efficiency and accuracy of logical data entity identification in legacy systems, thereby helping enterprises to accurately sort out the data resource directory of legacy systems, enhance users' use of data source systems and reuse of data, eliminate data silos, and improve data quality.

[0060] Combined with the above Figure 1 A schematic diagram of an example environment 100 in which embodiments of the present application can be implemented is described below. Figure 2 A schematic flow chart 200 is provided to describe a method for processing data in a database according to some embodiments of the present application, wherein Figure 2 The method shown can be Figure 1 The computing device 108 or any suitable computing device in the system may be executed.

[0061] At block 202, a log system of a database of a business system is configured for the data resource directory. The database is used to record the data of the business system, and the log system of the database is used to record the data operation records of the database. Figure 1The log system of the database 106 in the business system is configured. Configuration means reasonable organization, arrangement, deployment or setting according to the needs to achieve the expected functions and performance. "Configuring" the log system allows users to monitor changes in the database log. Therefore, when generating a data resource directory, corresponding log information or data operation records can be obtained from the log system of the database of the business system. Furthermore, by configuring the log system, the database log collection and analysis system can be associated with the log system of the database to obtain log information.

[0062] At block 204, if a business function in the business system corresponding to a business object in the data resource directory is operated, the computing device obtains a corresponding data operation record of the database from the configured log system of the database, and the corresponding data operation record of the database corresponds to the operation. When the corresponding business function in the business system is operated, the computing device 108 obtains the corresponding data operation record of the database from the configured log system of the database.

[0063] For example, in Figure 1 The operation interface of the business function corresponding to the business object in the data resource directory is displayed in the computing device 102 in the data resource directory. For example, in an airline, when constructing a data resource directory, its L3 business object is flight release implementation, so the operation interface of the business function corresponding to the business object can be presented on the computing device 102. When the user performs an operation on the operation interface of the business function corresponding to the business object displayed on the computing device 102, it will cause changes in the data in the corresponding database. Therefore, the database log associated with the operation can be obtained for analysis.

[0064] In some embodiments, when the business function is operated to perform adjustment operations on a set of data tables in a database, different databases may have different log formats, so the computing device needs to parse the database log. Then, the computing device obtains the corresponding data operation record of the database from the parsed database log. For example, the description information of the operation performed on a set of data tables in the database is obtained. In some embodiments, the description information may include at least one of the database name, the data table name, the field name to be adjusted, and the operation type for the data table.

[0065] In some embodiments, in the process of obtaining the corresponding data operation record of the database from the log system of the configured database, the computing device may first determine the start time for obtaining the log or data operation record in the log system of the database, and the operation is performed after the start time. For example, the user may first set the time for obtaining the log or data operation record, and then perform the operation after the time to obtain the database log or data operation record corresponding to the operation from the database.

[0066] In some embodiments, in the process of obtaining the corresponding data operation records of the database from the log system of the configured database, the computing device will also detect whether there are new log files in the log system in the database, such as newly added log files. Since the database will also generate new log files to store the newly added logs when storing log data. Therefore, it is also necessary to detect whether there are new log files to avoid the loss of log data. If there are new log files in the log system of the target database, the computing device obtains the database log from the new log file for analysis to obtain the corresponding data operation records for the database. For example, a thread is created to detect whether there are new log files in the database in real time. When a new log file is generated, the log analysis task can be switched to the new log file to ensure the continuity and timeliness of the database log analysis.

[0067] In some embodiments, when the computing device obtains logs from a database, if the connection with the database fails, the computing device will record the location of the parsed database log, for example, the location can be identified by time or by the identifier of the log. When the connection with a database in a group of databases is restored, the computing device can further parse the re-acquired database log from the location. This operation can realize continuous reading and parsing of data logs, ensuring accurate determination of log information.

[0068] In some embodiments, the operation of the business function may cause the business system to send a data operation instruction to the database to operate the database. The data operation instruction is used to instruct the database to perform at least one operation of adding, deleting, modifying, and searching.

[0069] At block 206, the computing device determines the logical data entity corresponding to the business object according to the data operation record of the database, wherein the logical data entity is a collection of attributes describing the business characteristics of the business object. The computing device 108 can use the data operation record to generate the logical data entity associated with the business object, and display these logical data entities to the user for the user to determine the logical data entity in the data resource directory for the user to use.

[0070] In some embodiments, after obtaining the data operation record, the computing device can directly obtain a set of data tables that have undergone data adjustment from the data operation record. At this time, the computing device can directly determine the data table in the set of data tables as a logical data entity. In some embodiments, after obtaining the data operation record, the computing device can determine a set of data tables that have undergone data adjustment from the data operation record. Then, the computing device can adjust the set of data tables to generate a new data table. In one example, the computing device can combine two or more data tables in a set of data tables to generate a new data table. In another example, the computing device combines some fields in two or more data tables in a set of data tables to generate a new data table. In another example column, the computing device splits a data table in a set of data tables to generate a new data table. Then the computing device can determine the new data table as a logical data entity.

[0071] In some embodiments, the computing device may also determine the target data table on which the insert operation is to be performed from a set of data tables based on the description information. Then, the target data table is determined as the data source table for the attributes of the business feature. At this time, in the interface displaying the logical data entity or its attributes, the attributes with the data source table may be identified, and the data source table may also be identified. By parsing the changed field information recorded in the database log, the attributes contained in the logical data entity may be accurately identified, while improving the efficiency of logical data entity identification.

[0072] Combined with the above Figure 2 A schematic flow chart of a method for processing data in a database according to some embodiments of the present application is described. Figure 3 and Figure 4 Describes an example of establishing a mapping between business objects and logical data entities. Figure 3 The following is a schematic diagram of an example of establishing a mapping between a business object and a logical data entity according to some embodiments of the present application. Figure 3As shown, example 300 includes a business system module 302. The business system module 302 is a system module corresponding to the company's business, which is used to handle various businesses in the company. The business system module may include an operation interface corresponding to each business function of the company. After performing an operation on the operation interface corresponding to the business function, the log collection module 304 can collect logs corresponding to the business operation from the database. The log collection module 304 transmits the collected log data corresponding to the business operation to the log analysis module 306. The log analysis module 306 parses the log information and can determine the description information of the operation adjusted for the data table in the database. Each information item in the description information describes the operation performed on a data table in a database, such as an insert operation or an update operation performed on a data table in a database. Then, the description information adjusted for the data table is transmitted to the business object and entity mapping module 308 for processing, and the logical data entity is determined from the description information. Then, a mapping between the logical data entity and the business object is established.

[0073] under Figure 4 The process is described in detail, Figure 4 A schematic diagram of an example of a process for establishing a mapping between a business object and a logical data entity according to some embodiments of the present application is described. Figure 4 In example 400, at box 402, the user performs a business function operation corresponding to the L3 business object on the front-end page of the business function module. The operation should be performed according to the actual business activity scenario, and the system database will record relevant logs for the business operation. At box 404, the computing device can collect all incremental log data of the system database. The analysis of the log can be implemented by the database log collection and analysis system. The database log collection and analysis system establishes a connection with the business database, and there is no need to deploy the program on the business database node. When an exception occurs in the connection to the business database, the system will automatically retry until the task is restored. At box 406, the computing device parses all incremental log data of the system database. When an exception occurs in the connection between the system and the business database, the current log parsing site can be automatically recorded, and after the fault is repaired, the parsing can be automatically continued from the last site to ensure that the parsed log data is free of redundancy and missing. The system only needs the business database to grant log data reading permissions, and does not require business data operation permissions, to ensure that the business database is minimized. Authorization.

[0074] At box 408, the computing device completes the identification of the logical data entity and the data source table. In the database table information processed and output by the database log collection and analysis system, all data items related to the business function are combined into corresponding L4 logical data entities according to the business meaning, or each physical table recorded in the output database table information can be directly used as a logical data entity. In some embodiments, after finding the data table associated with the business function module through the database log, further combined with the primary and foreign key information of the data table, other database tables associated with the business function module can be found from the database. Then, all the relevant database table information found is combined with the business meaning to identify and define the logical data entity, which can increase the accuracy of logical data entity identification.

[0075] In some embodiments, after finding all database tables associated with the business function module through the database log, they can be matched with the system front-end function module based on the Chinese and English names of the fields in the database table and the business meaning, thereby improving the accuracy of logical data entity recognition through this reverse verification method.

[0076] In some embodiments, the database log collection and analysis system parses the database table information and database operation types corresponding to the front-end business function operations in the order of log records, and defines the data table with the database operation type of insert (INSERT) as the data source table of the relevant attributes under the business function according to the business meaning.

[0077] Combined with the above Figure 3 and Figure 4 The following describes an example of establishing a mapping between business objects and logical data entities according to some embodiments of the present application. Figure 5 , Figure 6 and Figure 7 Another example of establishing a mapping between business objects and logical data entities is described. Figure 5 A schematic diagram of an example of a business function of a business object according to some embodiments of the present application is described, wherein Figure 6 A schematic diagram describing an example of the working process of a log collection and analysis system according to some embodiments of the present application. Figure 7 A schematic diagram of an example of a log collection and analysis process according to some embodiments of the present application is described.

[0078] In aviation enterprises, ensuring aircraft operation safety is the core business concern of the enterprise. Through communication with business personnel, the operation domain is designed as an L1 subject domain grouping in the enterprise data resource directory; in the operation domain, dispatch and release is an important business link, and dispatch and release is designed as an L2 subject domain under the operation domain; in the dispatch and release business link, flight release implementation is designed as an L3 business object as a key business activity; through the above business analysis, a L1-L3 architecture is designed for the enterprise's data resource directory as shown in Table 1.

[0079] Table 1: Example of a data resource directory

[0080] L1 Subject Domain Grouping L2 Subject Domain L3 Business Objects Operational domain Dispatch Flight release implementation

[0081] In order to complete the logical data entity identification under the flight release implementation business object, log in to the system that carries the business activity and complete the flight release implementation business function operation. The main operation steps of the system front end are as follows Figure 5 As shown in example 500. At box 502, enter the flight release monitoring page and select the released flight. Then, at box 504, confirm the route information. After confirming the route information, at box 506, further confirm the weather and set the flight alternate airport. Next, at box 508, issue a navigation notice to inform the airport flight information. The operation also includes confirming the fault retention list at box 510 and confirming the dispatch notice at box 512. At box 514, generate a release message and send it.

[0082] The database log collection and analysis system of the present application can establish a connection with the underlying database of the above-mentioned business system. The system collects the incremental log data generated by the system database in real time and stores the log data locally. In addition, the system can also parse the collected incremental log data online. After converting the incremental log data into a standard log format, the database table information such as the database name, SCHEMA name, table name, field data, operation type, etc. contained in the incremental log is extracted in sequence according to the sequence of log records.

[0083] The main workflow of the database log collection and analysis system is as follows Figure 6 As shown in example 600. The system database 602 stores data corresponding to the operations of the business functions in the business system, as well as database logs corresponding to the operations. At box 604, incremental log data is collected from the database 602. For example, the database log collection and analysis system establishes a connection with the database 602 to collect incremental log data of the database 602. When the connection to the database is abnormal, it will automatically retry until the task is restored. The acquired incremental log data can be saved locally in box 610, thereby realizing log data backup. When the system database fails, the locally saved log data can be used to perform database recovery.

[0084] For the incremental log data collected, in frame 606, the incremental log data is parsed. During parsing, a log mining tool is first used to create a data dictionary of the database, so that the log information parsed by the log mining tool is the actual data table name, field name and other information in the internal data dictionary, rather than the hexadecimal system inside the system. Then, it is also necessary to detect the redo log currently in the online state in real time, and add the log file currently in use to the analysis list. By setting the redo log start time parameter, it is realized that only the newly added logs in the database after the front-end function operation of the system are analyzed, which can narrow the scope of the log file to be analyzed. In some embodiments, when an abnormality occurs in the connection between the database log collection and analysis system and the business database, it can automatically record the current log parsing site. After the fault is repaired, it can automatically continue parsing from the last site to ensure that the parsed log data is free of redundancy and missing. In this process, log mining is then used to perform log parsing, and the parsing results are stored in the dynamic performance view. Figure 7 The process is further described. In example 700, there is a database 702 for storing data corresponding to business objects. At box 704, a connection with database 702 is established. After the connection with database 702 is established, at box 706, the log that is currently online is detected and confirmed in real time. At box 708, the log start time parameter is set. For example, the start time for obtaining the log is set, which is usually set before the execution of the business function. Then at box 710, log mining is used to perform log parsing. At box 712, the current log parsing site can also be recorded to facilitate the determination of the parsing position and facilitate the continued execution of subsequent parsing operations.

[0085] return Figure 6 Continuing the description, at box 608, data table extraction is performed. After parsing the log in the system database, the data change occurrence time, data operation type, data operation SQL statement, etc. recorded in the redo log can be obtained. According to the order of log records, the database name, SCHEMA name, table name, change field name, operation type and other database table information recorded in the incremental log are extracted in sequence. After implementing the business function operation for the above flight release, the database table information example obtained by analyzing the system database log is shown in Table 2:

[0086] Table 2: Database table information

[0087]

[0088] Based on the database table information obtained by the database log collection and analysis system, combined with the business meaning, TABLE_NAME1 and TABLE_NAME2 can be directly used as the L4 logical data entity under the flight release implementation business object. Through business analysis, some fields in TABLE_NAME1 and TABLE_NAME2 can be combined with business meaning to form a new logical data entity TABLE_NAME3. According to the physical primary and foreign key information in TABLE_NAME1 and TABLE_NAME2, TABLE_NAME4 associated with the flight release implementation business object can be found as a logical data entity. Based on the above method, the logical data entity and attribute example information under the flight release implementation business object is shown in Table 3:

[0089] Table 3: Data resource directory

[0090]

[0091] Based on the database table information obtained by the database log collection and analysis system, the data table TABLE_NAME1 with the database operation type INSERT is defined as the data source table generated by the attributes such as FIELD1, FIELD2, and FIELD3 under the flight release implementation business function.

[0092] Combined with the above Figure 5 , Figure 6 and Figure 7 Describe another example of establishing a mapping between business objects and logical data entities. Figure 8 A schematic diagram describing an example of a process for establishing a mapping between a business object and a logical data entity according to some embodiments of the present application.

[0093] like Figure 8As shown, the process 800 is mainly divided into three parts, the first part is the business system part 802. In this part, at box 808, the business function operation corresponding to the L3 business object is performed on the front-end page. For example, "business keywords" can be entered in the page. Then, the corresponding data will be stored in the system database 810. The second part of the process is the log parsing part 804, which is used to parse the log information obtained from the database. In this part, at box 812, log data is collected in real time. Before collecting log data, it is necessary to configure the connection with the database. For example, the preset function in the database can be enabled so that the changes in the data in the database can be obtained. Then, by configuring the operator connected to the database, connect to the business system database. After the configuration is completed, the data changes in the table can be obtained in real time. Then, a mapping relationship is configured at box 814 to map the obtained log to the target address. Then, the log is parsed at box 816. By analyzing the operator, combined with the configuration information, the log data is analyzed to obtain the table and field corresponding to the page operation. For example, the database table and field containing the "business keyword" are extracted according to the configuration information. The process also includes a third part, information architecture part 806, because the business object 818 is predetermined. Then, the logical data entity can be determined at box 820 according to the extracted database table information, and the attribute of the logical data entity can be further obtained at box 822. After the logical data entity and the attribute of the entity are obtained, a mapping relationship between the L3 business object and the L4 logical data entity and the L5 attribute can be established.

[0094] Combine the following Fig. 9 A schematic diagram describing an example of a data resource directory according to some embodiments of the present application. When using the method and system for identifying logical data entities and data source header tables of the present application, the user needs to manually create a new L1-L3 architecture on the front-end page of the tool, which can be presented in the form of a tree directory, as shown in box 902 in the figure. On the L3 business object details page, you can create new database connection information associated with the business object. When used to identify the logical data entity under the business object, establish a connection with the business system source database for log collection. The information items in the database connection information may include business objects, database names, database types, versions, database IPs, port numbers, database accounts, database passwords and other information.

[0095] After entering the database connection information on the business object details page, you can click the "Test Connection" button to test whether the tool can successfully connect to the source database. After the test connection is successful, you can save the connection information and click the "Start" button to start the collection and analysis of database logs. After the tool is started normally, you can go to the business system front-end page to perform business function operations. The tool will automatically collect the new database logs of the business system and complete the analysis. After the analysis is completed, the preliminary identified database table information will be output under the L3 business object. The database table information can be shown in the previous Table 2.

[0096] The user can reference the output database table information under the L3 business object to create a new logical data entity and attribute, thereby completing the identification of the logical data entity and the connection with the business object, as shown in block 904. On the L4 logical data entity creation page, the L4 logical data entity can be marked as a data source header table, thereby completing the identification of the data source header table.

[0097] Fig.10 The block diagram of the data relationship analysis device 1000 according to the embodiment of the present application is further shown. The device 1000 is applied to a computing device, which may include multiple modules for performing the following steps: Figure 2 The corresponding steps in the process 200 discussed in Fig.10 As shown, the device 1000 includes: a log system configuration unit 1002, which is configured to configure the log system of the database of the business system for the data resource directory, the database is used to record the data of the business system, and the log system of the database is used to record the data operation records of the database; a data operation record acquisition unit 1004, which is configured to obtain the corresponding data operation record of the database from the log system of the configured database if the business function corresponding to the business object in the data resource directory in the business system is operated, and the corresponding data operation record of the database corresponds to the operation; a logical data entity determination unit 1006, which is configured to determine the logical data entity corresponding to the business object according to the data operation record of the database, and the logical data entity is a collection of attributes that describe the business characteristics of the business object.

[0098] In some embodiments, the data operation record acquisition unit 1004 includes: a parsing unit configured to parse the database log in the log system of the database; and a record acquisition unit configured to acquire the corresponding data operation record of the database from the parsed database log.

[0099] In some embodiments, the device also includes: a location recording unit configured to record the location of the parsed database log if the connection with the database fails; and a retrieval unit configured to parse the re-retrieved database log based on the location if the connection with the database is restored.

[0100] In some embodiments, the logical data entity determination unit 1006 includes: a data table determination unit, configured to determine a group of data tables in the database on which adjustment operations are performed based on data operation records of the database; and a first logical data entity unit, configured to determine the logical data entity based on a group of data tables.

[0101] In some embodiments, the first logical data entity unit includes: a second logical entity determination unit, configured to determine a data table in a set of data tables as a logical data entity; or a third logical entity determination unit, configured to determine a new data table generated based on a set of data tables as a logical data entity.

[0102] In some embodiments, the third logical entity determination unit includes: a combination unit, configured to obtain a new data table by combining multiple fields in a set of data tables; or a splitting unit, configured to obtain a new data table by splitting one data table in a set of data tables.

[0103] In some embodiments, the device 1000 also includes: a target data table determination unit, configured to determine the target data table on which the insert operation is performed from a group of data tables; and a data source table determination unit, configured to determine the target data table as a data source table for attributes of the business feature.

[0104] In some embodiments, the data operation record acquisition unit 1004 includes: a start time determination unit, configured to determine the start time of the data operation record in the log system for acquiring the database, and the operation is performed after the start time; and an acquisition unit, configured to acquire the data operation record after the start time.

[0105] In some embodiments, the data operation record acquisition unit 1004 includes: a detection unit, configured to detect whether there is a new log file in the log system of the database; and a log acquisition unit, configured to obtain the corresponding data operation record of the database from the new log file if there is a new log file in the log system of the database.

[0106] In some embodiments, the operation causes the business system to send a data operation instruction to the database, and the data operation instruction is used to instruct the database to perform at least one operation of adding, deleting, modifying, and searching.

[0107] Fig.11 1 shows a schematic block diagram of an example device 1100 that can be used to implement an embodiment of the present application. Figure 1The computing devices 102 and 108 in the example device 1100 can be implemented by the example device 1100. As shown, the device 1100 includes a central processing unit (CPU) 1101, which can perform various appropriate actions and processes according to computer program instructions stored in a read-only memory (ROM) 1102 or loaded from a storage unit 1108 to a random access memory (RAM) 1103. In the RAM 1103, various programs and data required for the operation of the device 1100 can also be stored. The CPU 1101, the ROM 1102, and the RAM 1103 are connected to each other via a bus 1104. An input / output (I / O) interface 1105 is also connected to the bus 1104.

[0108] A number of components in the device 1100 are connected to the I / O interface 1105, including: an input unit 1106, such as a keyboard, a mouse, etc.; an output unit 1107, such as various types of displays, speakers, etc.; a storage unit 1108, such as a disk, an optical disk, etc.; and a communication unit 1109, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 1109 allows the device 1100 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0109] The various processes and processing described above, such as methods 200 and 400, may be performed by the processing unit 1101. For example, in some embodiments, methods 200 and 400 may be implemented as a computer software program, which is tangibly contained in a machine-readable medium, such as a storage unit 1108. In some embodiments, part or all of the computer program may be loaded and / or installed on the device 1100 via the ROM 1102 and / or the communication unit 1109. When the computer program is loaded into the RAM 1103 and executed by the CPU 1101, one or more actions of the methods 200 and 400 described above may be performed.

[0110] The present application may be a method, an apparatus, a system, a chip and / or a computer program product. The chip may include a processing unit and a communication interface, and the processing unit may process program instructions received from the communication interface. The computer program product may include a computer-readable storage medium on which computer-readable program instructions for executing various aspects of the present application are loaded.

[0111] A computer-readable storage medium may be a tangible device that can hold and store instructions used by an instruction execution device. A computer-readable storage medium may be, for example, but not limited to, an electrical storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any suitable combination of the foregoing. More specific examples of computer-readable storage media (a non-exhaustive list) include: a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a static random access memory (SRAM), a portable compact disk read-only memory (CD-ROM), a digital versatile disk (DVD), a memory stick, a floppy disk, a mechanical encoding device, such as a punch card or a raised structure in a groove on which instructions are stored, and any suitable combination of the foregoing. As used herein, a computer-readable storage medium is not to be interpreted as a transient signal per se, such as a radio wave or other freely propagating electromagnetic wave, an electromagnetic wave propagating through a waveguide or other transmission medium (e.g., a light pulse through a fiber optic cable), or an electrical signal transmitted through a wire.

[0112] The computer-readable program instructions described herein can be downloaded from a computer-readable storage medium to each computing / processing device, or downloaded to an external computer or external storage device via a network, such as the Internet, a local area network, a wide area network, and / or a wireless network. The network can include copper transmission cables, optical fiber transmissions, wireless transmissions, routers, firewalls, switches, gateway computers, and / or edge servers. The network adapter card or network interface in each computing / processing device receives the computer-readable program instructions from the network and forwards the computer-readable program instructions for storage in the computer-readable storage medium in each computing / processing device.

[0113] The computer program instructions for performing the operation of the present application can be assembler instructions, instruction set architecture (ISA) instructions, machine instructions, machine-related instructions, microcode, firmware instructions, state setting data, or source code or object code written in any combination of one or more programming languages, including object-oriented programming languages, such as Smalltalk, C++, etc., and conventional procedural programming languages, such as "C" language or similar programming languages. Computer-readable program instructions can be executed completely on a user's computer, partially on a user's computer, executed as an independent software package, partially on a user's computer, partially on a remote computer, or completely on a remote computer or server. In the case of a remote computer, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computer (for example, using an Internet service provider to connect through the Internet). In some embodiments, by using the state information of a computer-readable program instruction to personalize an electronic circuit, such as a programmable logic circuit, a field programmable gate array (FPGA) or a programmable logic array (PLA), the electronic circuit can execute a computer-readable program instruction, thereby realizing various aspects of the present application.

[0114] Various aspects of the present application are described herein with reference to the flowcharts and / or block diagrams of the methods, devices (systems) and computer program products according to the embodiments of the present application. It should be understood that each box in the flowchart and / or block diagram and the combination of each box in the flowchart and / or block diagram can be implemented by computer-readable program instructions.

[0115] These computer-readable program instructions can be provided to a processing unit of a general-purpose computer, a special-purpose computer, or other programmable data processing device, thereby producing a machine, so that when these instructions are executed by the processing unit of the computer or other programmable data processing device, a device that implements the functions / actions specified in one or more boxes in the flowchart and / or block diagram is generated. These computer-readable program instructions can also be stored in a computer-readable storage medium, and these instructions cause the computer, programmable data processing device, and / or other equipment to work in a specific manner, so that the computer-readable medium storing the instructions includes a manufactured product, which includes instructions for implementing various aspects of the functions / actions specified in one or more boxes in the flowchart and / or block diagram.

[0116] Computer-readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other device so that a series of operating steps are performed on the computer, other programmable data processing apparatus, or other device to produce a computer-implemented process, thereby causing the instructions executed on the computer, other programmable data processing apparatus, or other device to implement the functions / actions specified in one or more boxes in the flowchart and / or block diagram.

[0117] The flow chart and block diagram in the accompanying drawings show the possible architecture, function and operation of the system, method and computer program product according to multiple embodiments of the present application. In this regard, each square box in the flow chart or block diagram can represent a part of a module, program segment or instruction, and a part of the module, program segment or instruction includes one or more executable instructions for realizing the logical function of the specification. In some alternative implementations, the function marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two continuous square boxes can actually be executed substantially in parallel, and they can also be executed in the opposite order sometimes, depending on the function involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be realized by a dedicated hardware-based system that performs the function or action of the specification, or can be realized by a combination of special-purpose hardware and computer instructions.

[0118] The embodiments of the present application have been described above, and the above description is exemplary, not exhaustive, and is not limited to the disclosed embodiments. Many modifications and changes are obvious to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments. The selection of terms used herein is intended to best explain the principles of the embodiments, practical applications, or improvements to the technology in the market, or to enable other persons of ordinary skill in the art to understand the embodiments disclosed herein.

Claims

1. A data relationship analysis method, characterized in that: The method comprises: A log system of a database of a business system is configured for the data resource directory, wherein the database is used to record data of the business system, and the log system of the database is used to record data operation records of the database; If a business function in the business system corresponding to a business object in the data resource directory is operated, obtaining a corresponding data operation record of the database from a configured log system of the database, the corresponding data operation record of the database corresponding to the operation; The logical data entity corresponding to the business object is determined according to the data operation record of the database, and the logical data entity is a collection of attributes that describe the business characteristics of the business object.

2. The method according to claim 1, characterized in that Wherein obtaining the corresponding data operation record of the database from the configured log system of the database includes: Parsing the database logs in the log system of the database; and The corresponding data operation record of the database is obtained from the parsed database log.

3. The method according to claim 2, characterized in that The method further comprises: If the connection to the database fails, recording the location of the parsed database log; and If the connection with the database is restored, the re-acquired database log is parsed based on the position.

4. The method according to claim 1, characterized in that: Wherein determining the logical data entity corresponding to the business object according to the data operation record of the database comprises: Based on the data operation records of the database, determining a group of data tables in the database on which adjustment operations are performed; and The logical data entity is determined based on the set of data tables.

5. The method according to claim 4, characterized in that Wherein determining the logical data entity based on the set of data tables comprises: determining a data table in the set of data tables as the logical data entity; or A new data table generated based on the set of data tables is determined as the logical data entity.

6. The method according to claim 5, characterized in that Wherein determining the new data table generated based on the set of data tables as the logical data entity comprises: Obtaining the new data table by combining multiple fields in the set of data tables; or The new data table is obtained by splitting a data table in the group of data tables.

7. The method according to claim 4, characterized in that The method further comprises: Determine a target data table on which the insert operation is to be performed from the set of data tables; and The target data table is determined as a data source table for the attributes of the business feature.

8. The method according to claim 1, characterized in that Wherein obtaining the corresponding data operation record of the database from the configured log system of the database includes: determining a start time for acquiring a data operation record in a log system of the database, the operation being performed after the start time; and Acquire data operation records after the start time.

9. The method according to claim 1, characterized in that: Wherein obtaining the corresponding data operation record of the database from the configured log system of the database includes: Detecting whether there is a new log file in the log system of the database; and If the new log file exists in the log system of the database, the corresponding data operation record of the database is obtained from the new log file.

10. The method according to claim 1, characterized in that The operation causes the business system to send a data operation instruction to the database, and the data operation instruction is used to instruct the database to perform at least one operation of adding, deleting, modifying, and searching.

11. A data relationship analysis device, characterized in that: The device comprises: A log system configuration unit, configured to configure a log system of a database of a business system for a data resource directory, wherein the database is used to record data of the business system, and the log system of the database is used to record data operation records of the database; a data operation record acquisition unit configured to acquire a corresponding data operation record of the database from a configured log system of the database if a business function in the business system corresponding to a business object in the data resource directory is operated, the corresponding data operation record of the database corresponding to the operation; The logical data entity determination unit is configured to determine the logical data entity corresponding to the business object according to the data operation record of the database, wherein the logical data entity is a set of attributes describing the business characteristics of the business object.

12. An electronic device comprising: at least one computing unit; At least one memory, the at least one memory being coupled to the at least one computing unit and storing instructions for execution by the at least one computing unit, the instructions, when executed by the at least one computing unit, causing the device to perform the method according to any one of claims 1-10.

13. A computer-readable storage medium having a computer program stored thereon, wherein the program, when executed by a processor, implements the method according to any one of claims 1 to 10.

14. A computer program product comprising computer executable instructions, wherein the computer executable instructions, when executed by a processor, implement the method according to any one of claims 1 to 10.