CICS ICE Chain Cache for Mainframe Data Latency

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Legacy mainframe computing systems, such as those using COBOL and CICS, struggle to provide near-real-time data availability and efficiency due to high CPU consumption and complex transformation logic, leading to increased costs and response time issues when accessing multiple database tables.

Innovation Solution

The CICS ICE Chain Processing system leverages a cache architecture to store consumption-ready data, allowing for real-time data access by extracting, transforming, and loading data using a reusable COBOL-based transformation logic, reducing CPU costs and response time through a highly available cache system with 99.99% data availability.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If legacy mainframe systems access multiple database tables to provide data, then data availability is achieved, but response time increases and CPU consumption increases

Engineering Contradiction:
Improvedata availabilityVSAvoidresponse time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The patent implements a cache system that pre-loads and stores data from multiple database tables before they are requested. The ICE Chain processing system proactively extracts, transforms, and loads data into cache memory in advance, so that when users request information, the data is already available in the cache rather than needing to query multiple tables in real-time. This preliminary action eliminates the time penalty of accessing multiple tables while maintaining data availability.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent introduces a cache memory system as an intermediary layer between the legacy mainframe database tables and the users/application. This cache acts as a mediator that holds copies of frequently accessed data, allowing users to retrieve information from the fast cache memory instead of directly querying multiple slow database tables. The ICE Chain system manages this intermediary cache, automatically updating it with fresh data from the tables while presenting rapid access to users.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Reliability

If legacy mainframe systems access multiple database tables to provide data, then data availability is achieved, but CPU consumption increases

Engineering Contradiction:
Improvedata availabilityVSAvoidCPU consumption
Core Design Contradiction:
ReliabilityVSUse of energy by moving object

Solution Approach 1:

The ICE Chain processing system performs data extraction, transformation, and loading into cache memory in advance, before user requests arrive. By pre-processing and staging data in the cache during off-peak or background periods, the system eliminates the need for intensive CPU operations on multiple database tables during peak user access times. This preliminary action shifts CPU consumption to when it is less critical while maintaining data availability during high-demand periods.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The cache memory system serves as an intermediary that absorbs the CPU-intensive operations of data processing. Instead of users triggering multiple table queries that consume CPU cycles, the system pre-loads data into the cache with minimal CPU overhead. Subsequent user requests are served from the cache with negligible CPU consumption, effectively using the intermediary cache to decouple data availability from high CPU usage.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Manufacturing precision

If complex transformation logic is used to extract and transform data from database tables, then data transformation accuracy is improved, but system complexity increases

Engineering Contradiction:
Improvedata transformation accuracyVSAvoidsystem complexity
Core Design Contradiction:
Manufacturing precisionVSDevice complexity

Solution Approach 1:

The patent extracts the complex transformation logic from the main COBOL application code and places it into separate, reusable transformation modules or services that are invoked by the ICE Chain system. This extraction allows the transformation logic to be developed, tested, and maintained independently from the core application. The logic remains complex and accurate for data transformation, but it is isolated into discrete units that reduce overall system complexity and improve maintainability.

Inventive Principle:
Principle #2Taking out (Extraction)

Solution Approach 2:

The patent creates universal transformation modules that can be reused across multiple different data extraction and loading scenarios. Instead of embedding complex transformation logic in every individual COBOL program, the system develops generic transformation services that handle various data formats and transformations. These multi-functional modules reduce system complexity by eliminating duplication while maintaining transformation accuracy through centralized, well-tested logic.

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

Data Source

PatentUS9805103B2Callable change record data
Publication Date: 2017.10.31 AMERICAN EXPRESS TRAVEL RELATED SERVICES CO INC
  • US9805103B2 patent drawing
  • US9805103B2 patent drawing
  • US9805103B2 patent drawing

AI summary

A system is disclosed for improving the efficiency and quality of real-time extracting, transforming, and/or loading data using customer information control system (CICS) interval control element (ICE) chain processing.