Stored Routine Execution Across Duplicate Structured Data Blocks

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Standardised stored routines struggle to efficiently execute on dynamically updated structured data objects due to changes in the number, names, and types of variables, leading to challenges in handling duplicate blocks and variables.

Innovation Solution

A method and system that identify innermost nested blocks with matching variables, recursively search for matches if needed, and assign values to execution variables, allowing execution of stored routines on dynamically updated structured data objects with duplicate blocks.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If standardised stored routines are used to query structured data objects, then data processing efficiency is improved, but the system cannot handle dynamically updated data objects with changing variables and duplicate blocks

Engineering Contradiction:

Improvedata processing efficiencyVSAvoidability to handle dynamic updates

Core Design Contradiction:

ProductivityVSAdaptability or versatility

Solution Approach 1:

The system dynamically adapts stored routines to match variables in structured data objects by automatically identifying corresponding variables between the routine and the data object, allowing the same stored routine to work correctly whether there is one block or multiple duplicate blocks in the data object

Inventive Principle:

Principle #15Dynamics

Solution Approach 2:

The variable matching mechanism enables a single stored routine to serve multiple purposes - it can query structured data objects regardless of whether they contain one block or multiple duplicate blocks, making the routine universally applicable to dynamically changing data structures

Inventive Principle:

Principle #6Universality (Multi-functionality)

2Adaptability or versatility

If the structured data object is updated to include duplicate blocks with similar variables, then the system becomes more adaptable to dynamic data, but standardised stored routines struggle to execute efficiently due to variable matching challenges

Engineering Contradiction:

Improveability to accommodate duplicate blocksVSAvoidstored routine execution efficiency

Core Design Contradiction:

Adaptability or versatilityVSProductivity

Solution Approach 1:

The system segments the variable matching process by identifying corresponding variables between the stored routine and each block in the structured data object, allowing efficient processing even when multiple duplicate blocks are present

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The system creates a mapping between the variables in the stored routine and the corresponding variables in the structured data object blocks, enabling the routine to correctly access data from duplicate blocks through variable correspondence rather than direct block reference

Inventive Principle:

Principle #26Copying

3Adaptability or versatility

If variables in the structured data object are added, altered or deleted during dynamic updates, then the data object remains flexible, but stored routines that rely on standardised variable names and formats fail to execute

Engineering Contradiction:

Improvedata object modifiabilityVSAvoidstored routine execution reliability

Core Design Contradiction:

Adaptability or versatilityVSReliability

Solution Approach 1:

The system dynamically determines variable correspondence between stored routines and structured data objects at runtime, allowing the routine to adapt to added, altered, or deleted variables rather than failing due to rigid pre-defined variable requirements

Inventive Principle:

Principle #15Dynamics

Data Source

PatentUS20250363102A1Methods and systems for applying a stored routine to a plurality of blocks of a structured data object

Publication Date: 2025.11.27 LEO REGTECH LTD

AI summary

An improved method is disclosed for applying a (standardised) stored routine to a plurality of blocks of a structured data object. In particular, where the number of blocks of the structured data object, and their associated data, is changeable/modifiable such that the structured data object may comprise duplicate blocks and/or variables