Automated Data Integration File Conversion Across Operating Systems

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Converting data integration system files between systems executing or using different operating systems is difficult, costly, and time-consuming, as files associated with the same application may not be usable without conversion, especially when upgrading servers with different operating systems.

Innovation Solution

A system comprising a processor and memory that identifies differences between data integration systems using different operating systems, determines transformation rules, and creates a conversion algorithm to automatically convert files between them, enabling bulk conversion in a short period.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Manufacturing precision

If files are converted manually between data integration systems using different operating systems, then conversion accuracy can be maintained, but the process becomes difficult, costly, and time-consuming

Engineering Contradiction:
Improveconversion accuracyVSAvoidconversion time
Core Design Contradiction:
Manufacturing precisionVSLoss of time

Solution Approach 1:

The patent changes the fundamental parameter of the conversion process from manual file-by-file operations to automated bulk processing. By implementing a conversion algorithm that automatically detects and transforms files between different operating system formats, the system maintains conversion accuracy while dramatically reducing the time and labor required for migration between data integration systems.

Inventive Principle:
Principle #35Parameter changes

Solution Approach 2:

The conversion system performs self-service by automatically identifying files that need conversion, determining the appropriate transformation rules based on source and target operating systems, and executing the conversion without human intervention. This eliminates the need for manual analysis and processing of each file while maintaining high conversion accuracy through systematic algorithmic approaches.

Inventive Principle:
Principle #25Self-service

2Measurement precision

If files are converted one-by-one between data integration systems, then thorough analysis can be performed, but the conversion process becomes extremely time-consuming and costly

Engineering Contradiction:
Improveanalysis thoroughnessVSAvoidconversion speed
Core Design Contradiction:
Measurement precisionVSProductivity

Solution Approach 1:

The system performs preliminary analysis to identify all files requiring conversion and determines the appropriate transformation rules before executing bulk conversion. This preliminary action ensures thorough analysis of conversion requirements while enabling subsequent rapid bulk processing, thus maintaining analysis thoroughness while dramatically improving conversion speed.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent merges multiple individual conversion operations into a single bulk conversion process. By combining the analysis and execution phases for multiple files into an automated workflow, the system maintains thorough analysis capabilities while achieving high productivity through parallel or sequential batch processing of numerous files simultaneously.

Inventive Principle:
Principle #5Merging (Combining)

3Adaptability or versatility

If data integration systems are upgraded to new servers with different operating systems, then system performance and capabilities are improved, but file compatibility and usability are lost without conversion

Engineering Contradiction:
Improvesystem upgrade flexibilityVSAvoidfile usability
Core Design Contradiction:
Adaptability or versatilityVSReliability

Solution Approach 1:

The conversion algorithm acts as an intermediary between the old and new data integration systems. It transforms files from the source operating system format into the target operating system format, enabling seamless migration and ensuring file usability in the upgraded system while maintaining adaptability to different operating system environments.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The conversion system provides universal functionality by supporting migration between multiple different operating systems. The automated algorithm can handle various file formats and operating system types, making the upgrade process flexible and adaptable while ensuring reliable file usability across different target environments through systematic format transformation.

Inventive Principle:
Principle #6Universality (Multi-functionality)

4Ease of operation

If manual conversion processes are used for data integration system upgrades, then detailed control over each file can be maintained, but the cost and effort required increase significantly

Engineering Contradiction:
Improveconversion controlVSAvoidconversion cost
Core Design Contradiction:
Ease of operationVSEase of manufacture

Solution Approach 1:

The conversion system performs self-service by automatically identifying conversion requirements, selecting appropriate transformation rules, and executing file conversions without human intervention. This maintains operational control through systematic automated processes while dramatically reducing the labor cost and effort associated with manual conversion operations.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent changes the operational parameter from manual file-by-file control to automated bulk processing with configurable parameters. The system maintains control through programmable conversion rules and parameters while reducing costs by eliminating repetitive manual operations, achieving both ease of operation and reduced manufacturing cost through automation.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS10089313B2Conversion of data integration system files
Publication Date: 2018.10.02 BANK OF AMERICA CORP
  • US10089313B2 patent drawing
  • US10089313B2 patent drawing
  • US10089313B2 patent drawing

AI summary

According to one embodiment, a system for converting data integration system (“DIS”) files comprises a memory operable to store data associated with at least one DIS and a processor communicatively coupled to the memory and operable to convert files associated with a first DIS to files associated with a second DIS. The operating system used by the first DIS is different from the operating system used by the second DIS. The processor converts the files by being operable to determine differences between the first DIS and the second DIS, determine a set of transformation rules based on the differences, create a conversion algorithm based on the set of transformation rules, and execute the conversion algorithm to convert the files. The system is further operable to execute the second DIS such that the second DIS uses the converted data integration files.