A method and system for tracing source data based on enterprise business application software interface data.

Abstract

This invention discloses a method and system for tracing source data based on enterprise business application software interface data. The method includes: obtaining user data search requirements; obtaining interface data from the enterprise business application software; simulating the process of users calling and retrieving data within the enterprise business application software; tracking, recording, and analyzing the process of the enterprise business application software calling data from its database; obtaining the database source tables of the enterprise business application software; conducting AI comprehensive analysis to construct the accurate meaning of the enterprise data and the source location of the data storage, and matching it with the user's data search requirements; and constructing a direct method for users to retrieve the required data. The method and system provided by this invention can quickly find data and provide usage methods, significantly improving efficiency and reducing costs compared to building a data platform.

Description

Technical Field

[0001] This invention relates to the field of source data tracing technology, specifically to a method and system for tracing source data based on enterprise business application software interface data. Background Technology

[0002] In the development of modern enterprises, companies utilize various types of application software to construct their information and digital systems, thereby improving operational efficiency. This process generates a large amount of data, and at different stages of operation, companies raise numerous and diverse business demands regarding the purchased application software, resulting in even more data. Simultaneously, changes occur among the application users and IT management personnel during the company's operations, leading to the loss of data sources, meanings, and relationships between data. Ultimately, this prevents the company from accurately and effectively locating and correcting data within its business application systems.

[0003] Furthermore, most enterprise IT infrastructure development progresses from building a single system to connecting multiple systems and then to building an enterprise IT platform. Digitalization, however, involves deeply integrating data capabilities with business development after IT infrastructure is completed, through data mining and analysis, using data capabilities to drive and propel enterprise growth. Currently, most enterprises are in the stage of transitioning from a single system to connecting multiple systems.

[0004] Traditional manufacturing and B2B companies are currently mostly in the process of transitioning from a single system to a multi-system interconnected system. This process typically takes companies more than a year to achieve system interconnection. The core reason is:

[0005] The construction of siloed business systems leads to fragmented data, creating data islands. When connecting multiple business processes, a lot of manpower and resources are needed to sort out the data, which delays the process of enterprise digital transformation.

[0006] Currently, this problem is mainly solved by building a data platform. However, building a data platform is a systematic and complex process that requires connecting various organizational units within the enterprise, coordinating the applications of ISVs (Independent Software Vendors, which specifically refer to companies that specialize in the development, production, sales, and service of software), and requires the enterprise to invest significant human and material resources and spend more than a year to achieve.

[0007] The main disadvantages of building a data middle platform are:

[0008] 1. Data standardization is difficult, time-consuming and labor-intensive; enterprise data comes from different ISVs, and the standards and formats of the business applications provided by different ISVs are not uniform.

[0009] 2. Those who understand how to build a middle platform don't understand the business, and those who understand the business don't know how to build a middle platform. This makes integrating technology and business difficult.

[0010] 3. The investment is large and the return is difficult to measure.

[0011] 4. There are significant trust risks during the construction process.

[0012] 5. The construction of the data platform is based on the enterprise's recent development and the data standards are built accordingly. It is not flexible enough to adapt to the enterprise's long-term business changes. Summary of the Invention

[0013] To address the aforementioned technical shortcomings of building a data platform, this invention provides a method and system for tracing source data based on enterprise business application software interfaces. This method can quickly help enterprise personnel find data and provide usage methods. Compared to the current approach of building a data platform, it significantly improves efficiency and reduces costs.

[0014] This invention provides a method for tracing source data based on enterprise business application software interface data, comprising the following steps:

[0015] Acquire and analyze users' data search needs;

[0016] Acquire and analyze the interface data of the enterprise business application software to obtain the data currently displayed by the enterprise business application software and its corresponding meaning;

[0017] Simulate the process of a user calling and retrieving data in the enterprise business application software to obtain the process of the enterprise business application software calling data in its database;

[0018] The process of the enterprise business application software calling data in its database is tracked, recorded and analyzed to obtain the access process of the enterprise business application software to its database, as well as the database, field and basic calling method corresponding to the current data call;

[0019] Obtain and analyze the database source tables of the enterprise business application software to obtain the basic structure, relationships, data infrastructure, and attributes of the database source tables;

[0020] AI comprehensively analyzes the data currently presented by the enterprise business application software and its corresponding meaning, the process of the enterprise business application software calling data in its database, the process of the enterprise business application software accessing its database, and the database, fields, and basic calling methods corresponding to the current data call, as well as the basic structure, relationships, data infrastructure, and attributes of the database source table. It constructs the accurate meaning of the enterprise data and the source location of the data storage, and matches it with the user's data search needs to obtain matching results and make recommendations.

[0021] Based on the matching results, construct a direct method for invoking the data required by the user.

[0022] In a preferred embodiment of the method for tracing source data based on enterprise business application software interface data provided by the present invention, the step of acquiring and analyzing the interface data of the enterprise business application software to obtain the data currently presented by the enterprise business application software and its corresponding meaning includes:

[0023] Simulates the way a user opens the enterprise business application software, and performs operations such as opening, scanning, and saving the interface of the enterprise business application software;

[0024] The scan results are identified and analyzed to extract the data in the interface and its corresponding meaning.

[0025] In a preferred embodiment of the method for tracing source data based on enterprise business application software interface data provided by the present invention, the step of acquiring and analyzing the user's data search needs includes: extracting the fields that the user wants to search for based on the user's data search needs.

[0026] In a preferred embodiment of the method for tracing source data based on enterprise business application software interface data provided by the present invention, the step of matching with the user's data search needs to obtain a matching result includes:

[0027] Perform semantic analysis on the fields that the user wants to search for, and obtain the semantic analysis results;

[0028] The semantic analysis results are matched with the accurate meanings of the constructed enterprise data based on similarity. Multiple accurate meanings of the enterprise data are selected as matching results from high to low similarity and then recommended.

[0029] In a preferred embodiment of the method for tracing source data based on enterprise business application software interface data provided by the present invention, each matching result includes a field name, data table source, and data sample.

[0030] In a preferred embodiment of the method for tracing source data based on enterprise business application software interface data provided by the present invention, after obtaining the matching result and making a recommendation, the obtained matching result is fed back and subjected to AI comprehensive analysis.

[0031] In a preferred embodiment of the method for tracing source data based on enterprise business application software interface data provided by the present invention, the AI ​​comprehensive analysis further includes: customizing the meaning of the fields.

[0032] This invention also provides a system for tracing source data based on enterprise business application software interface data, comprising:

[0033] The user needs analysis module is used to acquire and analyze users' data search needs;

[0034] The application interface scanning module is used to acquire and analyze the interface data of the enterprise business application software to obtain the data currently presented by the enterprise business application software and its corresponding meaning.

[0035] The application data call simulation module is used to simulate the process of a user calling and retrieving data in the enterprise business application software, and to obtain the process of the enterprise business application software calling data in its database.

[0036] The call tracking module is used to track, record, and analyze the process of the enterprise business application software calling data in its database, so as to obtain the access process of the enterprise business application software to its database, as well as the database, field, and basic calling method corresponding to the current data call;

[0037] The source table analysis module is used to acquire and analyze the source tables of the enterprise business application software database to obtain the basic structure, relationships, data structure and attributes of the source tables.

[0038] The AI ​​analysis module is used to perform comprehensive AI analysis on the results obtained from the user demand analysis module, the application interface scanning module, the application data call simulation module, the call tracking module, and the original data table analysis module to construct the accurate meaning of enterprise data, the source location of data storage, and match it with the user's data search needs to obtain matching results and make recommendations.

[0039] The method invocation module is used to construct a direct invocation method for the user's required data based on the matching results.

[0040] In a preferred embodiment of the system for tracing source data of enterprise business application software interface data provided by the present invention, the application interface scanning module includes:

[0041] The real-time / timed scanning submodule is used to simulate the way a user opens the enterprise business application software and to open, scan, and save the interface of the enterprise business application software.

[0042] The scanning and recognition submodule is used to identify and analyze the scanning results, and extract the data in the interface and its corresponding meaning.

[0043] In a preferred embodiment of the system for tracing source data based on enterprise business application software interface data provided by the present invention, it further includes:

[0044] The enterprise-enhanced think tank module is used to feed back the obtained matching results to the AI ​​analysis module and perform comprehensive AI analysis.

[0045] A custom module is used to customize the meaning of the fields.

[0046] Compared with existing technologies, the method and system for tracing source data based on enterprise business application software interface data provided by this invention have the following beneficial effects:

[0047] The method and system for tracing source data based on enterprise business application software interface data provided by this invention can scan and learn the interface and data of enterprise business application software provided by ISVs, simulate the data calling process of enterprise business application software, and track the process. At the same time, combined with the AI ​​analysis module, the logs and data packets in the enterprise business application software calling process are analyzed to accurately determine the location, format, and calling method of the data required by the enterprise. In this way, when enterprise personnel need to use enterprise data, they only need to make their request, such as needing sales data. The method and system provided by this invention can quickly help enterprise personnel find the data and provide the usage method. Compared with the current method of building a data middle platform, the efficiency is greatly improved and the cost is greatly reduced. Attached Figure Description

[0048] To more clearly illustrate the technical solutions in the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort, wherein:

[0049] Figure 1 This is a flowchart of the method for tracing source data based on enterprise business application software interface data provided by the present invention;

[0050] Figure 2This is a structural block diagram of a system based on enterprise business application software interface data tracing source data, provided by the present invention. Detailed Implementation

[0051] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of the present invention, and not all of them. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0052] Please see Figure 1 , Figure 1 This is a flowchart of a method for tracing source data based on enterprise business application software interface data, provided by the present invention. The method for tracing source data based on enterprise business application software interface data includes the following steps:

[0053] Step S1: Obtain and analyze the user's data search needs;

[0054] Specifically, based on the user's data search requirements, the fields that the user wishes to search for are extracted.

[0055] The fields that the user wants to search for can be name, city, purchased product, product amount, sales amount, etc.

[0056] Step S2: Obtain and analyze the interface data of the enterprise business application software to obtain the data currently presented by the enterprise business application software and its corresponding meaning;

[0057] Specifically, including:

[0058] Simulates the way a user opens the enterprise business application software, and performs operations such as opening, scanning, and saving the interface of the enterprise business application software;

[0059] The scan results are identified and analyzed to extract the data in the interface and its corresponding meaning.

[0060] Step S3: Simulate the process of a user calling and retrieving data in the enterprise business application software to obtain the process of the enterprise business application software calling data in its database;

[0061] Step S4: Track, record and analyze the process of the enterprise business application software calling data in its database to obtain the access process of the enterprise business application software to its database, as well as the database, field and basic calling method corresponding to the current data call;

[0062] Step S5: Obtain and analyze the database source tables of the enterprise business application software to obtain the basic structure, relationships, data infrastructure, and attributes of the database source tables;

[0063] Step S6: Perform AI comprehensive analysis on the data currently presented by the enterprise business application software and its corresponding meaning, the process of the enterprise business application software calling data in its database, the process of the enterprise business application software accessing its database, and the database, fields and basic calling methods corresponding to the current data call, as well as the basic structure, relationship, data basic structure and attributes of the database source table, to construct the accurate meaning of the enterprise data and the source location of the data storage, and match it with the user's data search needs to obtain matching results and make recommendations.

[0064] Specifically, the matching with the user's data search needs to obtain matching results includes:

[0065] Perform semantic analysis on the fields that the user wants to search for, and obtain the semantic analysis results;

[0066] The semantic analysis results are matched with the accurate meanings of the constructed enterprise data based on similarity. Multiple accurate meanings of the enterprise data are selected as matching results from high to low similarity and then recommended.

[0067] Taking the field "sales amount" that the user wants to find as an example, if the field cannot be matched in the accurate meaning of the constructed enterprise data, then the similar fields "contract amount" and "performance amount" are recommended, and it is indicated that these two data are highly similar to the field "sales amount".

[0068] Furthermore, each matching result includes a field name, data table source, and data sample.

[0069] Furthermore, after obtaining the matching results and making recommendations, the obtained matching results are fed back and subjected to comprehensive AI analysis;

[0070] Furthermore, the AI ​​comprehensive analysis also includes: customizing the meaning of the fields.

[0071] Step S7: Based on the matching results, construct a direct method for calling the data required by the user.

[0072] Please see Figure 2 , Figure 2 This is a structural block diagram of a system based on enterprise business application software interface data tracing source data, provided by the present invention.

[0073] The system for tracing source data based on enterprise business application software interface data is used to execute the aforementioned method for tracing source data based on enterprise business application software interface data, including:

[0074] The user needs analysis module is used to acquire and analyze users' data search needs;

[0075] The application interface scanning module is used to acquire and analyze the interface data of the enterprise business application software to obtain the data currently presented by the enterprise business application software and its corresponding meaning.

[0076] The application data call simulation module is used to simulate the process of a user calling and retrieving data in the enterprise business application software, and to obtain the process of the enterprise business application software calling data in its database.

[0077] The call tracking module is used to track, record, and analyze the process of the enterprise business application software calling data in its database, so as to obtain the access process of the enterprise business application software to its database, as well as the database, field, and basic calling method corresponding to the current data call;

[0078] The source table analysis module is used to acquire and analyze the source tables of the enterprise business application software database to obtain the basic structure, relationships, data structure and attributes of the source tables.

[0079] The AI ​​analysis module is used to perform comprehensive AI analysis on the results obtained from the user demand analysis module, the application interface scanning module, the application data call simulation module, the call tracking module, and the original data table analysis module to construct the accurate meaning of enterprise data, the source location of data storage, and match it with the user's data search needs to obtain matching results and make recommendations.

[0080] The method of invocation module is used to construct a direct invocation method for the data required by the user based on the matching results. This allows users to not only quickly find the data when they make a data request, but also to be provided with a method to invoke the data, which greatly improves efficiency.

[0081] Furthermore, the application interface scanning module includes:

[0082] The real-time / timed scanning submodule is used to simulate the way a user opens the enterprise business application software and to open, scan, and save the interface of the enterprise business application software.

[0083] The scanning and recognition submodule is used to identify and analyze the scanning results, and extract the data in the interface and its corresponding meaning.

[0084] Furthermore, the system for tracing source data based on enterprise business application software interface data also includes:

[0085] The enterprise-enhanced think tank module is used to feed back the obtained matching results to the AI ​​analysis module and perform comprehensive AI analysis, which can effectively enhance the analytical capabilities of the AI ​​analysis module.

[0086] The custom module is used to customize the meaning of the field, making the meaning of the field more accurate.

[0087] The method and system for tracing source data based on enterprise business application software interface data provided by this invention can scan and learn the interface and data of the enterprise business application software provided by ISVs, simulate the data calling process of the enterprise business application software, and track the process. At the same time, combined with the AI ​​analysis module, the logs and data packets in the calling process of the enterprise business application software are analyzed to accurately determine the location, format, and calling method of the data required by the enterprise. In this way, when enterprise personnel need to use enterprise data, they only need to make their request, such as needing sales data. The method and system provided by this invention can quickly help enterprise personnel find the data and provide the usage method. Compared with the current method of building a data middle platform, the efficiency is greatly improved and the cost is greatly reduced.

[0088] The above description is merely an embodiment of the present invention and does not limit the patent scope of the present invention. Any equivalent structural or procedural transformations made based on the content of the present invention specification and drawings, or direct or indirect applications in other related technical fields, are similarly included within the patent protection scope of the present invention.

Claims

1. A method for tracing source data based on enterprise business application software interface data, characterized in that, Includes the following steps: Acquire and analyze users' data search needs; Acquire and analyze the interface data of the enterprise business application software to obtain the data currently displayed by the enterprise business application software and its corresponding meaning; Simulate the process of a user calling and retrieving data in the enterprise business application software to obtain the process of the enterprise business application software calling data in its database; The process of the enterprise business application software calling data in its database is tracked, recorded and analyzed to obtain the access process of the enterprise business application software to its database, as well as the database, field and basic calling method corresponding to the current data call; Obtain and analyze the database source tables of the enterprise business application software to obtain the basic structure, relationships, data infrastructure, and attributes of the database source tables; AI comprehensively analyzes the data currently presented by the enterprise business application software and its corresponding meaning, the process of the enterprise business application software calling data in its database, the process of the enterprise business application software accessing its database, and the database, fields, and basic calling methods corresponding to the current data call, as well as the basic structure, relationships, data infrastructure, and attributes of the database source table. It constructs the accurate meaning of the enterprise data and the source location of the data storage, and matches it with the user's data search needs to obtain matching results and make recommendations. Based on the matching results, construct a direct method for invoking the data required by the user.

2. The method for tracing source data based on enterprise business application software interface data according to claim 1, characterized in that, The acquisition and analysis of the interface data of the enterprise business application software to obtain the data currently presented by the enterprise business application software and its corresponding meaning includes: Simulates the way a user opens the enterprise business application software, and performs operations such as opening, scanning, and saving the interface of the enterprise business application software; The scan results are identified and analyzed to extract the data in the interface and its corresponding meaning.

3. The method for tracing source data based on enterprise business application software interface data according to claim 1, characterized in that, The process of acquiring and analyzing user data search needs includes: extracting the fields that the user wishes to search for based on the user's data search needs.

4. The method for tracing source data based on enterprise business application software interface data according to claim 3, characterized in that, The matching process with the user's data search request to obtain matching results includes: Perform semantic analysis on the fields that the user wants to search for, and obtain the semantic analysis results; The semantic analysis results are matched with the accurate meanings of the constructed enterprise data based on similarity. Multiple accurate meanings of the enterprise data are selected as matching results from high to low similarity and then recommended.

5. The method for tracing source data based on enterprise business application software interface data according to claim 4, characterized in that, Each matching result includes a field name, data table source, and data sample.

6. The method for tracing source data based on enterprise business application software interface data according to claim 1, characterized in that, After obtaining the matching results and making recommendations, the matching results are fed back and subjected to comprehensive AI analysis.

7. The method for tracing source data based on enterprise business application software interface data according to claim 1, characterized in that, The AI ​​comprehensive analysis also includes: customizing the meaning of the fields.

8. A system for tracing source data based on enterprise business application software interface data, characterized in that, include: The user needs analysis module is used to acquire and analyze users' data search needs; The application interface scanning module is used to acquire and analyze the interface data of the enterprise business application software to obtain the data currently presented by the enterprise business application software and its corresponding meaning. The application data call simulation module is used to simulate the process of a user calling and retrieving data in the enterprise business application software, and to obtain the process of the enterprise business application software calling data in its database. The call tracking module is used to track, record, and analyze the process of the enterprise business application software calling data in its database, so as to obtain the access process of the enterprise business application software to its database, as well as the database, field, and basic calling method corresponding to the current data call; The source table analysis module is used to acquire and analyze the source tables of the enterprise business application software database to obtain the basic structure, relationships, data structure and attributes of the source tables. The AI ​​analysis module is used to perform comprehensive AI analysis on the results obtained from the user demand analysis module, the application interface scanning module, the application data call simulation module, the call tracking module, and the original data table analysis module to construct the accurate meaning of enterprise data, the source location of data storage, and match it with the user's data search needs to obtain matching results and make recommendations. The method invocation module is used to construct a direct invocation method for the user's required data based on the matching results.

9. The system for tracing source data based on enterprise business application software interface data according to claim 8, characterized in that, The application interface scanning module includes: The real-time / timed scanning submodule is used to simulate the way a user opens the enterprise business application software and to open, scan, and save the interface of the enterprise business application software. The scanning and recognition submodule is used to identify and analyze the scanning results, and extract the data in the interface and its corresponding meaning.

10. The system for tracing source data based on enterprise business application software interface data according to claim 8, characterized in that, Also includes: The enterprise-enhanced think tank module is used to feed back the obtained matching results to the AI ​​analysis module and perform comprehensive AI analysis. A custom module is used to customize the meaning of the fields.

Images