Parallel Multidimensional Data Extraction via Permutation Segmentation

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing data extraction methods from multidimensional data structures, such as OLAP cubes, face inefficiencies due to exponential processing time and resource consumption, especially when using nested loops and sequential processing, which do not significantly benefit from parallel processing.

Innovation Solution

The system identifies unique values for multiple dimensions, processes subsets of permutations in parallel, and uses modulo operations to directly access data for each permutation, reducing the need for computing preceding values and conserving resources.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If nested loops and sequential processing are used to extract data from multidimensional data structures, then complete data extraction is achieved, but processing time increases exponentially and resource consumption increases

Engineering Contradiction:
Improvedata extraction speedVSAvoidprocessing time
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The patent segments the permutation processing into multiple independent subsets that can be processed in parallel. Each subset contains specific permutations that can be handled separately without affecting other subsets, enabling concurrent execution across multiple processing units and dramatically reducing overall processing time.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent introduces parallel processing as a new dimension for data extraction. By organizing permutations into subsets that can be processed simultaneously across multiple processing units, the system transitions from sequential single-dimensional processing to parallel multi-dimensional processing, exponentially improving extraction speed.

Inventive Principle:
Principle #17Another dimension (Dimensionality change)

2Productivity

If nested loops and sequential processing are used to extract data from multidimensional data structures, then complete data extraction is achieved, but memory usage and resource consumption increase

Engineering Contradiction:
Improvedata extraction completenessVSAvoidmemory usage
Core Design Contradiction:
ProductivityVSQuantity of substance

Solution Approach 1:

The patent segments both the data extraction task and memory allocation into discrete subsets. Each processing unit handles a specific subset of permutations with dedicated memory allocation, preventing memory overflow and reducing overall memory consumption through efficient resource partitioning.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent creates independent copies of processing logic for each subset rather than maintaining large sequential data structures in memory. This allows multiple processing units to work with smaller, replicated data structures simultaneously, reducing total memory usage while maintaining extraction completeness.

Inventive Principle:
Principle #26Copying

3Speed

If parallel processing is attempted with traditional methods, then processing speed may improve, but the methods do not significantly benefit from parallel processing due to sequential dependencies

Engineering Contradiction:
Improveprocessing speedVSAvoidparallel processing complexity
Core Design Contradiction:
SpeedVSDevice complexity

Solution Approach 1:

The patent segments permutations into independent subsets with clear boundaries and no inter-subset dependencies. This segmentation eliminates sequential bottlenecks and allows straightforward parallel implementation without complex synchronization mechanisms, achieving high speedup with minimal added complexity.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent performs preliminary organization of permutations into subsets before parallel processing begins. This pre-processing step establishes independent processing paths that can execute concurrently without requiring complex coordination during execution, simplifying the parallel processing architecture.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS12164544B2Data extraction from a multidimensional data structure
Publication Date: 2024.12.10 CAPITAL ONE SERVICES LLC
  • US12164544B2 patent drawing
  • US12164544B2 patent drawing
  • US12164544B2 patent drawing

AI summary

In some implementations, a device may identify respective sets of unique values for multiple dimensions of a multidimensional data structure. The device may identify a plurality of subsets of permutations of a set of permutations of the unique values. The plurality of subsets of permutations are to be processed in parallel. The device may obtain, based on processing the plurality of subsets of permutations in parallel, respective data associated with each permutation of the plurality of subsets of permutations. The data for a permutation, of the plurality of subsets of permutations, is obtained based on respective unique values for the permutation that are determined independently of another permutation of the plurality of subsets of permutations.