Patent · US Active

ETL-less zero-redundancy system and method for reporting OLTP data

US12001433B2 · kind B2 · utility

1Cited by

12References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Hasso Plattner · Schriesheim, DE
Anja Bog · Potsdam, DE
Jan Schaffner · Berlin, DE
Jens Krueger · Heidenheim, DE
Alexander Zeier · Berlin, DE

Key dates

Filing date	Aug 23, 2022
Grant date	Jun 4, 2024
Priority date	—
Expiry date	Aug 23, 2042

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/278
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A system includes a relational database management system component and a column-oriented data processing component. The relational database system component stores database information in a row format. The column-oriented data processing component stores the database information in a column format. In response to a database update request, the relational database management system component updates the database information stored in the row format; the relational database management system component notifies the column-oriented data processing component of the database update request; and the column-oriented data processing component updates the database information stored in said column format. In response to a query request, the column-oriented data processing component generates a query response based on the database information stored in said column format. In this manner, the system is able to generate up-to-date reports without the need for extraction, translation and loading procedures.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.