Dataset Enrichment Pipeline Using System Knowledge Data

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing data analytics systems face challenges in automatically enriching datasets with system knowledge data, leading to inefficient data extraction and transformation processes, particularly in enterprise software applications and cloud environments, which are time and resource-intensive.

Innovation Solution

A system and method for automatically enriching datasets with system knowledge data, utilizing a data pipeline and transformation layer to extract, transform, and load data from enterprise software applications into a data warehouse, incorporating a semantic model and presentation layer to provide customizable data analytics.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of information

If manual data extraction and transformation processes are used, then data can be enriched with system knowledge data, but the process becomes time and resource-intensive

Engineering Contradiction:
Improvedata enrichmentVSAvoidtime and resource requirements
Core Design Contradiction:
Loss of informationVSLoss of time

Solution Approach 1:

The system performs automatic data enrichment by self-service mechanisms. The data pipeline automatically extracts data from enterprise software applications, transforms it using transformation layers, and loads it into data warehouses without requiring manual intervention. The system autonomously identifies relevant system knowledge data and integrates it with user datasets, eliminating the need for users to manually perform time-consuming data enrichment tasks.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system performs preliminary data extraction and transformation actions before users need the enriched data. The data pipeline continuously extracts data from enterprise applications and pre-transforms it into usable formats, storing it in data warehouses ready for integration. This preliminary preparation ensures that when users need enriched datasets, the enrichment process has already been completed or is readily available.

Inventive Principle:
Principle #10Preliminary action

2Productivity

If automatic data enrichment is implemented, then time and resource requirements are reduced, but system complexity increases

Engineering Contradiction:
Improvedata enrichment efficiencyVSAvoidsystem complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The automatic data enrichment system is segmented into distinct modular components: data extraction modules that connect to specific enterprise applications, transformation layers that handle different data types, and loading mechanisms that integrate with various data warehouses. Each component operates independently and can be configured separately, allowing the complex automatic enrichment process to be managed through simple, isolated functional units.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent introduces intermediary components such as transformation layers and data pipelines that mediate between enterprise software applications and data warehouses. These intermediaries handle the complexity of data extraction, transformation, and loading processes, shielding users from the underlying system complexity while enabling automatic data enrichment. The intermediaries act as buffers that manage the complex operations transparently.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Loss of information

If users are provided with access to additional system knowledge data, then data visualizations can be improved, but users may be overwhelmed by unavailable awareness of data options

Engineering Contradiction:
Improveavailability of system knowledge dataVSAvoiduser awareness and selection
Core Design Contradiction:
Loss of informationVSEase of operation

Solution Approach 1:

The system extracts and presents only the most relevant system knowledge data automatically, rather than exposing all available data options to users. The transformation layer intelligently filters and selects pertinent data elements based on the user's dataset and analysis needs, extracting only the necessary enrichments. This selective extraction prevents overwhelming users with excessive data options while still providing meaningful improvements to data visualizations.

Inventive Principle:
Principle #2Taking out (Extraction)

Data Source

PatentUS20250355895A1System and method for automatically enriching datasets with system knowledge data
Publication Date: 2025.11.20 ORACLE INT CORP
  • US20250355895A1 patent drawing
  • US20250355895A1 patent drawing
  • US20250355895A1 patent drawing

AI summary

Described herein are systems and methods for automatically enriching datasets in a data analytics environment, with system knowledge data. The system can operate, upon an analysis of a data set, to automatically enrich the data set. Users of data analytics environments, such as business users preparing data visualizations, may be unaware of additional data and system knowledge data that could be utilized to improve the data visualizations. The systems and methods described herein can provide an automatic enrichment of data from, for example, a knowledge repository, which can be delivered to a data analytics customer using various delivery means.