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

US9626421B2 · kind B2 · utility

Assignee

• Hasso-Plattner Institut fuer Softwaresystemtechnik GmbH · 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: Sep 19, 2008
• Grant date: Apr 18, 2017
• Expiry date: Oct 9, 2030

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/278
• WIPO field: Computer technology
• WIPO sector: Electrical 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.