Real-Time Enterprise Data Integration Service

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current enterprise application integration methods operate in batch mode, leading to inefficiencies such as repetitive data handling and delayed access to data across different applications, failing to provide real-time data integration.

Innovation Solution

The development of methods and systems for real-time data integration that process requests from multiple data sources, integrate data in real-time, and expose the results as a service, allowing access through a graphical user interface without additional coding, supporting both real-time and batch modes.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If batch mode data integration is used, then data integration can be performed across multiple applications, but data availability is delayed and not real-time

Engineering Contradiction:
Improvedata integration consistencyVSAvoiddata availability speed
Core Design Contradiction:
ReliabilityVSSpeed

Solution Approach 1:

The system transitions from static batch processing to dynamic real-time processing. The data integration service continuously processes data requests as they arrive, adapting to changing data needs in real-time rather than following a fixed batch schedule. This allows the system to maintain data consistency while providing immediate data availability when needed.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The patent implements continuous data integration processing where the service remains active and processes data requests continuously rather than in periodic batches. This continuous operation ensures that data is integrated and made available in real-time while maintaining consistency across applications, eliminating the waiting period inherent in batch processing.

Inventive Principle:
Principle #20Continuity of useful action

2Productivity

If specialized computer applications are used for different business processes, then each process can be optimized, but data integration becomes complex and requires repetitive handling

Engineering Contradiction:
Improvebusiness process efficiencyVSAvoidintegration system complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The patent creates a universal data integration service that can handle multiple data sources and target applications through a single interface. This service performs extraction, transformation, and loading operations for various business processes without requiring separate integration systems for each application, thereby maintaining process efficiency while reducing overall integration complexity.

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

Solution Approach 2:

The data integration service acts as an intermediary layer between specialized business applications and underlying data sources. This mediator handles all data integration operations centrally, eliminating the need for each application to have its own integration logic and reducing repetitive data handling across the enterprise.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Quantity of substance

If batch mode data extraction and loading is used, then large amounts of data can be processed, but the process takes time and is not available in real-time

Engineering Contradiction:
Improvedata processing volumeVSAvoiddata processing time
Core Design Contradiction:
Quantity of substanceVSLoss of time

Solution Approach 1:

The system implements periodic data processing where large volumes of data are extracted and loaded in structured intervals or triggers rather than continuous streams. This allows the system to handle substantial data quantities while reducing overall processing time by organizing operations efficiently, providing real-time availability without sacrificing processing capacity.

Inventive Principle:
Principle #19Periodic action

Data Source

PatentUS8307109B2Methods and systems for real time integration services
Publication Date: 2012.11.06 INTERNATIONAL BUSINESS MACHINE CORPORATION
  • US8307109B2 patent drawing
  • US8307109B2 patent drawing
  • US8307109B2 patent drawing

AI summary

Methods and systems for enterprise data integration are described. The methods and systems take elements of a data integration process typically operating in a batch-mode, transform the elements in real time, and expose the results as a service that can be accessed by a business enterprise in real time, and optionally also in batch mode. The service can be accessed through a graphical user interface, providing automatic data integration in real time without additional coding. The service can also operate with mobile devices.