- Patent Title: ETL-less zero-redundancy system and method for reporting OLTP data
-
Application No.: US15424639Application Date: 2017-02-03
-
Publication No.: US10713253B2Publication Date: 2020-07-14
- Inventor: Hasso Plattner , Anja Bog , Jan Schaffner , Jens Krueger , Alexander Zeier
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fountainhead Law Group P.C.
- Main IPC: G06F16/20
- IPC: G06F16/20 ; G06F16/2455 ; G06F16/22 ; G06F16/28 ; G06F16/23 ; G06F16/27

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.
Public/Granted literature
- US20170212934A1 ETL-Less Zero-Redundancy System and Method for Reporting OLTP Data Public/Granted day:2017-07-27
Information query