RAG Retrieval Pipeline for Structured and Unstructured Data

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Retrieval-Augmented Generation (RAG) frameworks struggle to efficiently and accurately process both unstructured and structured data, particularly failing to utilize structured data effectively for context-aware responses.

Innovation Solution

An RAG framework that includes an RAG pre-processing platform for vector embedding of unstructured data and summary/metadata creation for structured data, combined with an RAG retriever and reader platform to retrieve and combine context-relevant information for both data types, enhancing the LLM prompt for accurate responses.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If RAG uses typical embedding process and vector search for structured data, then unstructured data retrieval is successful, but structured data understanding and usage is poor

Engineering Contradiction:
Improveretrieval accuracy for unstructured dataVSAvoidstructured data understanding capability
Core Design Contradiction:
Measurement precisionVSReliability

Solution Approach 1:

The patent segments the data processing pipeline into distinct pathways: unstructured data undergoes traditional embedding and vector search, while structured data is transformed into natural language summaries and metadata that are then embedded. This segmentation allows each data type to be processed according to its characteristics, resolving the contradiction between maintaining unstructured data retrieval accuracy and improving structured data understanding.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent changes the parameters of structured data by transforming tabular data into natural language summaries and extracting metadata, then applying embedding to these transformed representations. This parameter change enables structured data to be processed using the same vector search mechanism as unstructured data, improving reliability without sacrificing the established unstructured data retrieval accuracy.

Inventive Principle:
Principle #35Parameter changes

2Device complexity

If RAG stores only unstructured data in vector data store, then implementation is simple, but structured data cannot be utilized

Engineering Contradiction:
Improvesystem implementation complexityVSAvoiddata type support capability
Core Design Contradiction:
Device complexityVSAdaptability or versatility

Solution Approach 1:

The patent makes the vector data store universal by enabling it to store both traditional embedded unstructured data and embedded natural language summaries of structured data. The same embedding and retrieval infrastructure serves both data types, achieving multi-functionality without significantly increasing implementation complexity.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Solution Approach 2:

The patent introduces natural language summaries and metadata as intermediaries that bridge structured data and the vector search system. These intermediaries transform structured data into a format compatible with embedding, allowing the existing vector data store infrastructure to handle structured data without major modifications.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Reliability

If RAG retraining LLM with new data, then model has current information, but cost and time increase

Engineering Contradiction:
Improveinformation currencyVSAvoidmodel update time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The patent performs preliminary action by pre-computing natural language summaries and metadata from structured data sources, and pre-applying embedding to these summaries. This preparation work is done in advance, allowing the system to quickly retrieve current information without requiring time-consuming LLM retraining when new data becomes available.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent extracts only the essential information from structured data sources into natural language summaries and metadata, separating this extracted information from the full data sources. This extraction allows the system to work with condensed, essential information that can be quickly embedded and retrieved without retraining the entire model on complete data sets.

Inventive Principle:
Principle #2Taking out (Extraction)

Data Source

PatentUS12619588B2System and methods for retrieval-augmented generation searches of unstructured and structured information
Publication Date: 2026.05.05 SAP SE
  • US12619588B2 patent drawing
  • US12619588B2 patent drawing
  • US12619588B2 patent drawing

AI summary

A Retrieval-Augmented Generation (“RAG”) framework may include an RAG vector data store with information about vector embeddings. An RAG pre-processing platform may access unstructured data and perform vector embedding to generate a vector embedding for unstructured data to be stored in the RAG vector data store. The RAG pre-processing platform may also access structured data from the knowledge base and create a summary and metadata about the structured data to be stored in the RAG vector data store. An RAG retriever platform may receive a user prompt from a user, perform vector embedding, and retrieve context-relevant information for unstructured and structured data by searching for similar embeddings in the RAG vector data store. An RAG reader platform may combine the context-relevant information with the user prompt and an RAG prompt to create a LLM prompt. A context-aware response is then output to the user.