AI Framework for Real-Time ORM Mapping Validation

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current Object-Relational Mapping (ORM) frameworks do not effectively identify mapping issues between objects and relational databases until runtime, leading to inefficiencies in code development due to manual overhead and time delays.

Innovation Solution

The implementation of an AI-based method that uses natural language processing (NLP) and machine learning algorithms to validate ORM metadata during source code compilation, comparing it with database attributes to identify and correct mapping issues before runtime.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If ORM validation is performed only at runtime, then the system maintains simplicity in the compilation process, but mapping issues are detected too late causing development inefficiencies and manual overhead

Engineering Contradiction:
ImproveORM mapping accuracyVSAvoidcode development time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The patent applies preliminary action by performing ORM metadata validation during the compilation phase rather than at runtime. The system generates ORM metadata from ORM files, determines database attributes, and validates their correspondence before the code is executed. This early detection mechanism identifies mapping issues during development, eliminating the need for runtime error handling and reducing manual review overhead.

Inventive Principle:
Principle #10Preliminary action

2Reliability

If manual review of ORM framework is performed, then mapping issues can be identified, but additional manual overhead and time delays are introduced

Engineering Contradiction:
Improvemapping issue detectionVSAvoidcode development efficiency
Core Design Contradiction:
ReliabilityVSProductivity

Solution Approach 1:

The patent implements self-service by creating an automated validation system that performs ORM metadata verification without requiring manual intervention. The system automatically generates ORM metadata, extracts database attributes, compares them for consistency, and provides validation indications during compilation. This automated approach replaces manual review processes, eliminating human overhead while maintaining high detection accuracy.

Inventive Principle:
Principle #25Self-service

3Loss of time

If ORM validation is integrated during compilation, then mapping issues are detected early improving efficiency, but the compilation process becomes more complex

Engineering Contradiction:
Improvedevelopment timeVSAvoidcompilation process complexity
Core Design Contradiction:
Loss of timeVSDevice complexity

Solution Approach 1:

The patent applies segmentation by dividing the validation process into distinct modular components: ORM metadata generation from ORM files, database attribute determination from deployment logs or database catalogs, correspondence validation between metadata and attributes, and validation indication output. This modular architecture integrates validation into the existing compilation workflow without creating a monolithic complex system, allowing each component to be developed and maintained independently.

Inventive Principle:
Principle #1Segmentation

4Measurement precision

If AI-based validation is implemented, then mapping issues are detected with higher precision, but the system requires additional processing resources

Engineering Contradiction:
Improvemapping issue detection accuracyVSAvoidprocessing resources
Core Design Contradiction:
Measurement precisionVSUse of energy by moving object

Solution Approach 1:

The patent uses an intermediary approach by introducing an AI-based natural language processing model that acts as a mediator between the ORM metadata and database attributes. The NLP model analyzes the semantic correspondence between ORM mappings and database schemas, providing high-precision validation. The model is trained on database attributes and deployed as a separate service that can be invoked during compilation, distributing processing requirements rather than embedding complex AI logic directly in the compiler.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS11829735B2Artificial intelligence (AI) framework to identify object-relational mapping issues in real-time
Publication Date: 2023.11.28 BANK OF AMERICA CORP
  • US11829735B2 patent drawing
  • US11829735B2 patent drawing
  • US11829735B2 patent drawing

AI summary

Various aspects of this disclosure relate to determining mapping issues in object relational mapping (ORM). An artificial intelligence (AI) model may be trained to identify errors in mapping between relational databases and objects during code compilation. Multiple AI models may be used, with different models being associated with different programming frameworks, thereby making this technique framework agnostic.