LLM-Generated Application Integration Paths for Schema Mapping
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The integration of two computer software programs is a complex and time-consuming process, requiring transformation of information between different formats and schemas, which is difficult for development teams to manage efficiently.
Innovation Solution
A method and system utilizing a large language model (LLM) to generate software code for integration paths by formulating mapping guides and templates, and automatically initiating prompts to the LLM for generating software code based on these guides and templates, thereby creating a complete integration path.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If manual creation of integration paths is used, then accuracy and control over transformation rules are maintained, but development time and resource requirements increase significantly
Solution Approach 1:
The patent introduces an LLM-based intermediary system that automatically generates integration paths by receiving technical specification documents and transforming them into executable integration code. This mediator handles the complexity of mapping between different application schemas and formats, reducing the burden on development teams while maintaining transformation accuracy through automated processing of complex integration scenarios
Solution Approach 2:
The patent replaces manual mechanical processes of creating integration paths with an automated AI-based system. Instead of developers manually writing transformation rules and mapping configurations, the system uses LLMs to automatically generate integration code based on input documents, substituting human expertise with automated intelligent processing that scales efficiently
2Loss of time
If automated LLM-based integration generation is used, then development time is reduced significantly, but reliability and validation of transformation rules become more challenging
Solution Approach 1:
The patent implements feedback mechanisms where the generated integration paths can be validated against the original technical specification documents. The system allows for review and verification of the LLM-generated code, enabling feedback loops that ensure the transformation rules accurately reflect the requirements while maintaining the time-saving benefits of automation
Solution Approach 2:
The patent performs preliminary processing by having the LLM generate complete integration paths based on pre-processed technical specification documents. The system prepares and validates transformation rules in advance through automated processing, ensuring reliability before deployment while significantly reducing the overall development timeline compared to manual creation
Data Source
AI summary
A method of producing an integration path for the communication of information from a first application to a second application includes formulating a mapping guide, an origin information field template, and a destination information field template dependent upon the first application, the second application, and the information that is to be communicated. The method can further include initiating the generation of a prompt for a large language model with the prompt having a system portion that includes a generic instruction and a user portion that includes specific instructions dependent upon the mapping guide, origin information field template, and destination information field template; receiving the software code that, when executed, provides for a partial integration path; and associating, with the software code, connection information that links an origin to the first application and connection information that links a destination to the second application to generate a complete integration path.