# US 2025/0061126 A1 · Processor, Computer Program Product, System and Method for Data Transformation

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2025/0061126 A1
- Document ID: US20250061126A1
- Status: Published application
- Kind: A1
- Application number: 18/721,484
- Filed: 2022-12-14
- Published: 2025-02-20
- Earliest claimed: 2021-12-21
- Assignees: Siemens Aktiengesellschaft
- Applicants: Siemens Aktiengesellschaft
- Inventors: Swathi Shyam Sunder; Tobias Aigner; Janaki Joshi
- Web page: https://patentgrep.com/patent/US20250061126A1

## CPC

- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F 16/258: {Data format conversion from or to a database}
- G06F 16/2452: Query translation
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

The teachings of the present disclosure relates to data transformation from source data in RDB format to result data in RDF format. Various embodiments of these teachings make source data from e.g., sensors and/or monitoring devices machine readable by transforming datasets in RDB format to datasets in graph dataset format as RDF datasets are.

## Claims

### Claim 1

A processor for generating RDF dataset(s) from RDB source data by R2RML text file mappings, the processor programmed to: extract from at least one graph structure by a mapping query within the R2RML mapping process at least one triple map for the RDF dataset.

### Claim 2 (depends on 1)

A processor as claimed in claim 1, the processor including at least one storage unit configurated to store intermediate R2RML mappings as a graph.

### Claim 3 (depends on 1)

A processor as claimed in claim 1, the processor configured to execute SPARQL queries as part of its workflow.

### Claim 4

A method for producing a graph dataset from source data in RDB format by R2RML mapping, the method comprising:
a) storing suitable R2RML text mapping file(s) in a first memory unit;
b) reading at least one R2RML text mapping file;
c) parsing text of the R2RML text mapping file;
d) receiving, from physical data generation device(s), source data as RDBs;
d) storing source data in a third memory unit;
e) preprocessing the source data;
f) storing mapped SPARQL queries to second memory unit;
g) extracting by SPARQL query all prefixes and namespaces of the R2RML text mapping file;
h) extracting triple map(s) from the R2RML text mapping file;
i) for each triples map extracted in h),
ia) —extracting a logical table name or a SQL query,
ib) —extracting subject IRI template and subject class, and
ic) —extracting all predicates and associated objects;
j) running SQL queries extracted under ia) against the underlying database to fetch relevant data; and
k) transforming source data into result data and thereby generating graph database and/or RDF file(s) by R2RML specification.

### Claim 5 (depends on 4)

The method according to claim 4, wherein the source data represent an industrial environment.

### Claim 6 (depends on 4)

The method according to claim 4, wherein the source data represent an urban environment.

### Claim 7 (depends on 4)

The method according to claim 4, further comprising using the result data to train an artificial intelligence.

### Claim 8 (depends on 4)

The method according to claim 4, further comprising transferring the result data to a cloud application.

### Claim 9

A system for transformation of relational source data into result data suitable to build up a knowledge graph the system being executed by R2RML mapping rule execution, the system comprising:
several recording devices, monitoring devices and/or sensors to generate source data; and
a R2RML processor;
a first memory unit storing mapping file (s);
a second memory unit storing mapping queries;
a third memory unit storing source data;
wherein the first memory unit is communicatively coupled to a first processing unit reading the mapping file(s) and communicatively coupled to a second processing unit executing the R2RML text parser;
the second processing unit communicatively coupled to a
third processing unit executing the mapping by exploiting the well-defined graph structure of the R2RML mappings,
the third processing unit communicatively coupled to
the second processing unit and
the second memory unit and
the third memory unit,
the third processing unit communicatively coupled to transfer the resulting data to the a fourth memory unit storing the result data as graph database or RDF file.

### Claim 10 (depends on 9)

The system according to claim 9 wherein the fourth memory unit is communicatively coupled to an artificial intelligence.

### Claim at position 11

11-12. (canceled)
