Dynamic Workflow Indexing for Data Retrieval Bottlenecks

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current workflow activity and data retrieval processes are hindered by extensive database usage, requiring multiple database calls and high processing power, especially in applications with multiple stages where data dependency is not properly indexed.

Innovation Solution

The system employs machine-enabled methods and devices for workflow instance execution, including index controllers, search logic controllers, match controllers, and ordered result determiners to efficiently index and retrieve data by determining unique IDs based on core data elements, reducing the need for multiple database calls through dynamic indexing and parallel processing.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If multiple database calls are used for workflow data retrieval, then data can be accessed from multiple stages, but processing power consumption increases significantly

Engineering Contradiction:

Improvedata access capabilityVSAvoidprocessing power consumption

Core Design Contradiction:

Adaptability or versatilityVSUse of energy by moving object

Solution Approach 1:

The patent applies preliminary action by pre-indexing workflow activities and their associated data before actual workflow execution. The indexing system creates a structured map of data locations and dependencies in advance, allowing the workflow engine to retrieve data efficiently without requiring multiple sequential database calls during runtime. This pre-processing of data organization resolves the contradiction by enabling versatile data access while minimizing processing power consumption during workflow execution.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The patent introduces an intermediary indexing layer between the workflow engine and the database. This indexing system acts as a mediator that translates workflow data requirements into optimized database queries. Instead of the workflow engine making multiple direct database calls, the intermediary index structure guides and consolidates data retrieval operations, reducing the number of database calls and associated processing power consumption while maintaining full data access capability.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Reliability

If data is passed sequentially between workflow stages, then data dependency is maintained, but retrieval speed decreases

Engineering Contradiction:

Improvedata dependency managementVSAvoiddata retrieval speed

Core Design Contradiction:

ReliabilityVSSpeed

Solution Approach 1:

The patent applies segmentation by dividing the workflow data retrieval process into independent, parallelizable segments based on the indexing structure. Instead of sequential data passing between stages, the index allows multiple workflow stages to simultaneously retrieve their required data from pre-organized index structures. This segmentation maintains data dependency integrity through the index's structural relationships while enabling parallel retrieval operations that significantly increase data retrieval speed.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent transitions from a one-dimensional sequential data passing model to a multi-dimensional index-based retrieval model. The indexing system creates additional dimensions for data access through hierarchical and associative relationships, allowing workflow stages to retrieve data through multiple paths simultaneously. This dimensional transformation maintains data dependency through index structure relationships while enabling concurrent access that dramatically improves retrieval speed compared to sequential passing.

Inventive Principle:

Principle #17Another dimension (Dimensionality change)

3Adaptability or versatility

If extensive database usage is employed for workflow management, then comprehensive data retrieval is achieved, but system complexity increases

Engineering Contradiction:

Improvedata retrieval comprehensivenessVSAvoidsystem complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent extracts the complexity of data organization and relationship management from the workflow engine and database interaction layer, consolidating it into a dedicated indexing system. This extracted indexing layer handles all the complex operations of organizing, structuring, and relationship-mapping data, while the workflow engine and database can operate with simpler, more direct interfaces. The indexing system absorbs the complexity, allowing comprehensive data retrieval without proportionally increasing overall system complexity.

Inventive Principle:

Principle #2Taking out (Extraction)

Data Source

PatentUS10042957B2Devices and methods for implementing dynamic collaborative workflow systems

Publication Date: 2018.08.07 DESHPANDE RAJENDRA V

AI summary

Systems, devices, and methods for executing workflow instances of management of continuously changing data and queries. In one embodiment, a computing device may be configured to determine a set of related structured data comprising a key and associated value, where an associated ID and name for each related structured data of the set of related structured data may be determined. Additionally, a unique ID may be determined based on the determined associated ID and name. A match may then be determined for the set of core data elements based on a received message and an ordered list of results retrieved based on at least one of: the matched ID, the matched name, and the matched ID and name.