Method and system for tracing source data based on enterprise business application software interface data

Abstract

The invention discloses a method and a system for tracing source data based on enterprise business application software interface data. The method for tracing source data based on enterprise business application software interface data comprises the following steps: acquiring a data search demand of a user; obtaining interface data of the enterprise business application software; simulating a process of calling and acquiring data in the enterprise business application software by a user; tracking, recording and analyzing the calling process of the enterprise business application software on the data in the database of the enterprise business application software; obtaining a database source table of the enterprise business application software; aI comprehensive analysis is carried out, the accurate meaning of enterprise data and the source position of data storage are constructed, and the data are matched with the data searching requirement of the user; and constructing a direct calling method of the data required by the user. According to the method and system for tracing source data based on enterprise business application software interface data provided by the invention, data can be quickly found and a use method can be provided, and compared with a mode of constructing a data middle table, the efficiency is greatly improved, and the cost is greatly reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of source data tracing, and in particular to a method and system for tracing source data based on enterprise business application software interface data. Background Art

[0002] As modern enterprises develop, they utilize various types of application software to build their information and digital systems, ultimately improving operational efficiency. This process generates a vast amount of data, and at different stages of business operations, they also generate numerous and diverse business requirements for the purchased application software, further generating even more data. Furthermore, the application users and information management personnel of enterprises may change during the certification process, leading to the loss of data sources, meanings, and relationships between business data during personnel and business changes. Ultimately, this prevents enterprises from accurately and effectively locating and retrieving data within their business application systems.

[0003] Furthermore, the vast majority of enterprise informatization efforts progress from building a single system to integrating multiple systems and ultimately building an enterprise informatization middle platform. Digitalization, on the other hand, involves integrating data capabilities with business development through data mining and analysis after informatization is complete, using data capabilities to drive and propel enterprise growth. Currently, most enterprises are in the transition from a single system to integrating multiple systems.

[0004] Most traditional manufacturing and B2B companies are currently in the process of transitioning from a single system to multiple systems in series. This process typically takes more than a year for companies to achieve system integration. The core reasons are: The construction of siloed business systems has led to the fragmentation of system data, forming data silos. When connecting multiple businesses, a lot of manpower and material resources are required to sort out the data, which delays the process of digital transformation of the enterprise.

[0005] Currently, this problem is primarily addressed through the construction of a data center. However, building a data center is a systematic and complex process that requires integrating various organizational units and coordinating with ISVs (Independent Software Vendors) who specialize in software development, production, sales, and services. This requires significant investment of manpower and material resources and takes more than a year to implement.

[0006] The main disadvantages of building a data center are: 1. Data standardization is difficult, time-consuming and labor-intensive; enterprise data comes from different ISVs, and the standards and formats of business applications provided by different ISVs are not unified.

[0007] 2. People who know how to build a middle platform don't understand the business, and those who know the business don't know how to build a middle platform. It's difficult to integrate technology and business.

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

[0009] 4. There is a great trust risk during the construction process.

[0010] 5. The construction of the data middle platform is based on the construction of data standards based on the company's recent development, and it is not flexible enough to adapt to the company's long-term business changes. Summary of the Invention

[0011] In order to solve the technical problems of the shortcomings in the construction of the above-mentioned data middle platform, the present invention provides a method and system for tracing source data based on the data of the enterprise business application software interface, which can quickly help enterprise personnel find data and provide usage methods. Compared with the current method of building a data middle platform, the efficiency is greatly improved and the cost is greatly reduced.

[0012] The present invention provides a method for tracing source data based on enterprise business application software interface data, comprising the following steps: Obtain and analyze users' data search needs; 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; Simulate the process of users calling and obtaining data in the enterprise business application software to obtain the process of the enterprise business application software calling the data in its database; Tracking, recording, and analyzing the process of the enterprise business application software accessing data in its database to obtain the process of the enterprise business application software accessing its database, as well as the database, field, and basic calling method corresponding to the current data call; Acquire and analyze the database source tables of the enterprise business application software to obtain the basic structure, association relationships, data basic structure and attributes of the database source tables; Perform AI-powered comprehensive analysis on the data currently presented by the enterprise business application software and its corresponding meaning, the process by which the enterprise business application software calls data in its database, the process by which the enterprise business application software accesses its database, the database, fields, and basic calling methods corresponding to the current data call, and the basic structure, associations, data infrastructure, and attributes of the database source tables. This analysis constructs the precise meaning of the enterprise data and the source location where the data is stored, matches this with the user's data search needs, obtains matching results, and makes recommendations. Based on the matching results, a direct calling method for the data required by the user is constructed.

[0013] In a preferred embodiment of the method for tracing source data based on the interface data of enterprise business application software provided by the present invention, 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: Simulating a user's way of opening the enterprise business application software, and performing opening, scanning, and saving operations on the interface of the enterprise business application software; The scanned result is identified and analyzed to extract the data in the interface and its corresponding meaning.

[0014] 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 obtaining and analyzing the user's data search requirements includes: extracting the fields that the user wants to search according to the user's data search requirements.

[0015] In a preferred embodiment of the method for tracing source data based on enterprise business application software interface data provided by the present invention, matching with the user's data search requirements to obtain a matching result includes: Performing semantic analysis on the field that the user wants to search for to obtain a semantic analysis result; The semantic analysis result is matched with the constructed accurate meaning of the enterprise data in terms of similarity, and multiple accurate meanings of the enterprise data are selected from high to low according to the similarity as matching results and recommended.

[0016] 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, a data table source, and a data sample.

[0017] 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 results and making recommendations, the matching results are fed back and subjected to AI comprehensive analysis.

[0018] In a preferred embodiment of the method for tracing source data based on enterprise business application software interface data provided by the present invention, when performing the AI ​​comprehensive analysis, it also includes: customizing the meaning of the field.

[0019] The present invention also provides a system for tracing source data based on enterprise business application software interface data, comprising: User demand analysis module, used to obtain and analyze users' data search needs; An application interface scanning module is used to 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; An application data call simulation module is used to simulate the process of a user calling and obtaining data in the enterprise business application software, and obtain the process of the enterprise business application software calling the data in its database; A call tracking module is used to track, record and analyze the process of the enterprise business application software calling data in its database, and obtain the process of the enterprise business application software accessing its database, as well as the database, field and basic calling method corresponding to the current data call; The data source table analysis module is used to obtain and analyze the database source table of the enterprise business application software to obtain the basic structure, association relationship, data basic structure and attributes of the database source table; An AI analysis module is used to perform AI comprehensive 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 data source table analysis module, to construct the precise meaning of enterprise data and the source location of data storage, and to match these with the user's data search requirements to obtain matching results and make recommendations; The calling method construction module is used to construct a direct calling method for the data required by the user based on the matching results.

[0020] In a preferred embodiment of the system for tracing source data based on enterprise business application software interface data provided by the present invention, the application interface scanning module includes: A real-time / scheduled scanning submodule is used to simulate the way a user opens the enterprise business application software and perform opening, scanning, and saving operations on the interface of the enterprise business application software; The scanning and identifying submodule is used to identify and analyze the scanning results and extract the data in the interface and its corresponding meaning.

[0021] In a preferred embodiment of the system for tracing source data based on enterprise business application software interface data provided by the present invention, the system further includes: An enterprise enhanced think tank module is used to feed back the obtained matching results to the AI ​​analysis module and perform AI comprehensive analysis; A custom module is used to customize the meaning of the fields.

[0022] Compared with the existing technology, the method and system for tracing source data based on enterprise business application software interface data provided by the present invention have the following beneficial effects: The method and system for tracing source data based on the interface data of enterprise business application software provided by the present invention can scan and learn the interface of the enterprise business application software provided by ISV and the data in the interface, simulate the process of enterprise business application software calling data, and track its process. At the same time, combined with the AI ​​analysis module, the logs and data packets in the process of enterprise business application software calling are analyzed to accurately obtain 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 put forward their requests, such as: sales data is needed. The method and system for tracing source data based on the interface data of enterprise business application software provided by the present invention can quickly help enterprise personnel find this data and provide methods of use. Compared with the current method of building a data middle platform, efficiency is greatly improved and cost is greatly reduced. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for describing the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. Those skilled in the art can also derive other drawings based on these drawings without inventive work, among which: Figure 1 It is a flow chart of a method for tracing source data based on enterprise business application software interface data provided by the present invention; Figure 2 It is a structural block diagram of a system for tracing source data based on enterprise business application software interface data provided by the present invention. DETAILED DESCRIPTION

[0024] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0025] See also Figure 1 , Figure 1 The flowchart of the method for tracing source data based on enterprise business application software interface data provided by the present invention includes the following steps: Step S1: Obtain and analyze the user's data search needs; Specifically, according to the data search requirement of the user, the fields that the user wants to search are extracted.

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

[0027] Step S2: 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; Specifically, they include: Simulating a user's way of opening the enterprise business application software, and performing opening, scanning, and saving operations on the interface of the enterprise business application software; The scanned result is identified and analyzed to extract the data in the interface and its corresponding meaning.

[0028] Step S3: Simulate the process of a user calling and obtaining data in the enterprise business application software to obtain the process of the enterprise business application software calling the data in its database; Step S4: Track, record, and analyze the process of the enterprise business application software accessing the data in its database to obtain the process of the enterprise business application software accessing the database, as well as the database, field, and basic calling method corresponding to the current data call; Step S5: Acquire and analyze the database source table of the enterprise business application software to obtain the basic structure, association relationship, data basic structure and attributes of the database source table; Step S6: Perform an AI-based comprehensive analysis of the data currently presented by the enterprise business application software and its corresponding meaning, the process by which the enterprise business application software calls data in its database, the process by which the enterprise business application software accesses its database, the database, fields, and basic calling methods corresponding to the current data call, and the basic structure, associations, data infrastructure, and attributes of the database source tables. This analysis establishes the precise meaning of the enterprise data and the source location where the data is stored, matches this information with the user's data search requirements, obtains matching results, and makes recommendations. Specifically, the matching with the user's data search requirements to obtain a matching result includes: Performing semantic analysis on the field that the user wants to search for to obtain a semantic analysis result; The semantic analysis result is matched with the constructed accurate meaning of the enterprise data in terms of similarity, and multiple accurate meanings of the enterprise data are selected from high to low according to the similarity as matching results and recommended.

[0029] Taking the field "sales amount" that the user wants to find as an example, when the field cannot be matched in the exact meaning of the constructed enterprise data, similar "contract amount" and "performance amount" are recommended, and it is prompted that the similarity between these two data and the field "sales amount" is extremely high.

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

[0031] Furthermore, after obtaining the matching results and making recommendations, the matching results are fed back and subjected to AI comprehensive analysis; Furthermore, when performing the AI ​​comprehensive analysis, it also includes: customizing the meaning of the field.

[0032] Step S7: Construct a direct calling method for the data required by the user based on the matching result.

[0033] See also Figure 2 , Figure 2 It is a structural block diagram of a system for tracing source data based on enterprise business application software interface data provided by the present invention.

[0034] The system for tracing source data based on enterprise business application software interface data is used to execute the above-mentioned method for tracing source data based on enterprise business application software interface data, including: User demand analysis module, used to obtain and analyze users' data search needs; An application interface scanning module is used to 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; An application data call simulation module is used to simulate the process of a user calling and obtaining data in the enterprise business application software, and obtain the process of the enterprise business application software calling the data in its database; A call tracking module is used to track, record and analyze the process of the enterprise business application software calling data in its database, and obtain the process of the enterprise business application software accessing its database, as well as the database, field and basic calling method corresponding to the current data call; The data source table analysis module is used to obtain and analyze the database source table of the enterprise business application software to obtain the basic structure, association relationship, data basic structure and attributes of the database source table; An AI analysis module is used to perform AI comprehensive 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 data source table analysis module, to construct the precise meaning of enterprise data and the source location of data storage, and to match these with the user's data search requirements to obtain matching results and make recommendations; The calling method construction module is used to construct a direct calling method for the data required by the user based on the matching results, so that the user can not only quickly find the data when making a data request, but also be provided with a method for calling the data, which greatly improves efficiency.

[0035] Furthermore, the application interface scanning module includes: A real-time / scheduled scanning submodule is used to simulate the way a user opens the enterprise business application software and perform opening, scanning, and saving operations on the interface of the enterprise business application software; The scanning and identifying submodule is used to identify and analyze the scanning results and extract the data in the interface and its corresponding meaning.

[0036] Furthermore, the system based on enterprise business application software interface data tracing source data also includes: An enterprise enhanced think tank module is used to feed back the obtained matching results to the AI ​​analysis module and perform AI comprehensive analysis, which can effectively enhance the analytical capabilities of the AI ​​analysis module; The customization module is used to customize the meaning of the field, so as to make the meaning of the field more accurate.

[0037] The method and system for tracing source data based on the interface data of enterprise business application software provided by the present invention can scan and learn the interface of the enterprise business application software provided by the ISV and the data in the interface, simulate the process of the enterprise business application software calling data, and track its 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 obtain 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 put forward their requests, such as: sales data is needed. The method and system for tracing source data based on the interface data of enterprise business application software provided by the present invention can quickly help enterprise personnel find this data and provide methods of use. Compared with the current method of building a data middle platform, efficiency is greatly improved and costs are greatly reduced.

[0038] The above descriptions are merely embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention description and drawings, or directly or indirectly applied in other related technical fields, are also included in 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: The following steps are involved: Obtain and analyze users' data search needs; 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; Simulate the process of users calling and obtaining data in the enterprise business application software to obtain the process of the enterprise business application software calling the data in its database; Tracking, recording, and analyzing the process of the enterprise business application software accessing data in its database to obtain the process of the enterprise business application software accessing its database, as well as the database, field, and basic calling method corresponding to the current data call; Acquire and analyze the database source tables of the enterprise business application software to obtain the basic structure, association relationships, data basic structure and attributes of the database source tables; Perform AI-powered comprehensive analysis on the data currently presented by the enterprise business application software and its corresponding meaning, the process by which the enterprise business application software calls data in its database, the process by which the enterprise business application software accesses its database, the database, fields, and basic calling methods corresponding to the current data call, and the basic structure, associations, data infrastructure, and attributes of the database source tables. This analysis constructs the precise meaning of the enterprise data and the source location where the data is stored, matches this with the user's data search needs, obtains matching results, and makes recommendations. Based on the matching results, a direct calling method for the data required by the user is constructed.

2. The method for tracing source data based on enterprise business application software interface data according to claim 1, characterized in that: The 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: Simulating a user's way of opening the enterprise business application software, and performing opening, scanning, and saving operations on the interface of the enterprise business application software; The scanned result is 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 acquiring and analyzing the user's data search requirements includes: extracting the fields that the user wants to search for according to the user's data search requirements.

4. The method for tracing source data based on enterprise business application software interface data according to claim 3, characterized in that: The matching result obtained by matching the data search requirement of the user includes: Performing semantic analysis on the field that the user wants to search for to obtain a semantic analysis result; The semantic analysis result is matched with the constructed accurate meaning of the enterprise data in terms of similarity, and multiple accurate meanings of the enterprise data are selected from high to low according to the similarity as matching results and recommended.

5. The method for tracing source data based on enterprise business application software interface data according to claim 4 is characterized in that: Each matching result includes a field name, a data table source, and a 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 AI comprehensive 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 field.

8. A system for tracing source data based on enterprise business application software interface data, characterized in that: include: User demand analysis module, used to obtain and analyze users' data search needs; An application interface scanning module is used to 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; An application data call simulation module is used to simulate the process of a user calling and obtaining data in the enterprise business application software, and obtain the process of the enterprise business application software calling the data in its database; A call tracking module is used to track, record and analyze the process of the enterprise business application software calling data in its database, and obtain the process of the enterprise business application software accessing its database, as well as the database, field and basic calling method corresponding to the current data call; The data source table analysis module is used to obtain and analyze the database source table of the enterprise business application software to obtain the basic structure, association relationship, data basic structure and attributes of the database source table; An AI analysis module is used to perform AI comprehensive 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 data source table analysis module, to construct the precise meaning of enterprise data and the source location of data storage, and to match these with the user's data search requirements to obtain matching results and make recommendations; The calling method construction module is used to construct a direct calling method for the data required by the user according to 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: A real-time / scheduled scanning submodule is used to simulate the way a user opens the enterprise business application software and perform opening, scanning, and saving operations on the interface of the enterprise business application software; The scanning and identifying 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: An enterprise enhanced think tank module is used to feed back the obtained matching results to the AI ​​analysis module and perform AI comprehensive analysis; A custom module is used to customize the meaning of the fields.

Images