Numerical Data Catalog Service for Sequence Matching

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Conventional systems lack the ability to search for specific sequences of values within numerical data, hindering the identification of data origin, storage location, and redundancy, especially across disparate systems and locations.

Innovation Solution

A numerical data catalog service is implemented to centrally store and search for sequences of values, allowing users to determine the origin and storage location of data sequences, identify data assets, and detect redundancies by storing and ranking matching sequences based on their similarity.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If conventional systems store and search numerical data using traditional metadata methods, then basic data retrieval is possible, but sequence-specific searching capability is lost

Engineering Contradiction:
Improvesequence matching precisionVSAvoidsearch capability versatility
Core Design Contradiction:
Measurement precisionVSAdaptability or versatility

Solution Approach 1:

The patent segments numerical data into discrete sequences of values that can be independently stored and searched. Each sequence is treated as a distinct searchable entity with its own metadata, allowing precise sequence matching while maintaining the ability to search across multiple sequences. This segmentation enables the system to handle specific sequence patterns (like 10, 5, 35, 245, 214) that conventional row-by-row metadata approaches cannot capture.

Inventive Principle:
Principle #1Segmentation

2Ease of operation

If data is stored in disparate systems and locations, then data distribution and accessibility are improved, but unified sequence searching across sources becomes difficult

Engineering Contradiction:
Improvedata accessibilityVSAvoidsearch system complexity
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The patent introduces a catalog service as an intermediary layer between users and disparate data sources. This catalog service maintains metadata about numerical sequences stored across multiple systems and locations, enabling unified searching without requiring direct access to each individual data source. The intermediary abstracts the complexity of distributed storage while preserving easy access to sequence data across the entire system landscape.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Loss of information

If conventional metadata structures are used, then basic data description is achieved, but sequence pattern recognition and redundancy detection are hindered

Engineering Contradiction:
Improvedata origin informationVSAvoidsequence pattern detection
Core Design Contradiction:
Loss of informationVSDifficulty of detecting and measuring

Solution Approach 1:

The patent applies preliminary action by pre-processing numerical data into sequence structures with associated metadata before storage. Sequences are organized with explicit start positions, lengths, and descriptive metadata that capture their origin and characteristics. This preliminary structuring enables efficient later detection of sequence patterns, origins, and redundancies without requiring complex analysis during query execution.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS20240054119A1Searchable catalog of columnar numerical data
Publication Date: 2024.02.15 SAP SE
  • US20240054119A1 patent drawing
  • US20240054119A1 patent drawing
  • US20240054119A1 patent drawing

AI summary

Systems and methods provide identification of a first configuration specifying a first column of a first data source, acquisition, based on the first configuration, of a first sequence of values stored in consecutive rows of the first column, and storage of the first sequence of values in a storage device in association with an identifier of the first data source and the first column.