Nested Block Routine Execution for Dynamic Structured Data
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Standardised stored routines face challenges when applied to dynamically updated structured data objects with changing block structures, including duplicate blocks and variables, leading to execution errors and inconsistent output.
Innovation Solution
A method and system that identifies innermost nested blocks with matching execution variables, recursively searches for variable matches, and assigns values to execution variables, handling duplicate blocks and dynamic updates through a template-based approach.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If a standardised stored routine is applied to a dynamically updated structured data object with changing block structures, then the routine can process data according to standard rules, but execution errors and inconsistent output occur due to duplicate blocks and variables
Solution Approach 1:
The patent segments the structured data object into distinct blocks, each representing a specific target entity. The stored routine processes each block independently by identifying execution variables within that block and recursively searching for variable matches. This segmentation allows the routine to handle dynamic additions, modifications, and deletions of blocks without affecting the entire data object, thereby maintaining execution consistency while adapting to structural changes.
Solution Approach 2:
The patent implements dynamic adaptation by allowing the structured data object to be modified (added, modified, deleted) without requiring changes to the stored routine itself. The routine dynamically identifies blocks containing execution variables and recursively searches for variable matches, enabling it to adapt to changing block structures, duplicate blocks, and variable names while maintaining reliable execution.
2Adaptability or versatility
If the structured data object is dynamically updated to add, modify or delete data, then the object remains flexible and adaptable, but the standardised stored routine may encounter execution errors due to changing variable names, formats, locations
Solution Approach 1:
The patent performs preliminary identification of blocks containing execution variables before executing the stored routine. By pre-identifying which blocks contain the required execution variables and recursively searching for variable matches in advance, the system ensures that the routine can reliably execute even when the data object structure changes, avoiding execution errors caused by changing variable names, formats, or locations.
Solution Approach 2:
The patent implements a feedback mechanism where the system continuously monitors and identifies blocks containing execution variables. When the data object is dynamically updated, the system re-identifies relevant blocks and adjusts the execution process accordingly. This feedback loop ensures that the stored routine maintains reliability by adapting to changes in variable names, formats, and locations without requiring manual intervention.
3Productivity
If a stored routine processes multiple blocks with similar variables, then comprehensive data processing is achieved, but duplicate variables and blocks cause confusion and inconsistent results
Solution Approach 1:
The patent segments the processing of multiple blocks by treating each block as a distinct unit with its own execution variables. The stored routine processes each block independently by identifying execution variables within that specific block and recursively searching for variable matches only within that block's context. This segmentation prevents confusion from duplicate variables across different blocks and ensures consistent output for each block while maintaining overall processing efficiency.
Data Source
Figure 1
Figure 2
Figure 3
AI summary
There is provided a method and related systems for applying a stored routine to a plurality of blocks of a structured data object, wherein the blocks comprise one or more block variable instances, wherein the blocks are configured as one or more block nests, and wherein the stored routine, when executed, implements the processing of one or more execution variables, the method comprising: identifying one or more first nested blocks, each first nested block comprising a block variable match for an execution variable; executing the stored routine, wherein the executing comprises for each first nested block: assigning a respective value to the execution variables, wherein the assigning comprises, for each respective one of the execution variables: in response to a block variable match for the respective execution variable in the first nested block, assigning a value of that matched block variable to the respective execution variable; and in response to there being no block variable match for the respective execution variable in the first nested block, recursively searching outwards from the first nested block for a block variable match for the respective execution variable.