US 12,001,433 B2
ETL-less zero-redundancy system and method for reporting OLTP data
Hasso Plattner, Schriesheim (DE); Anja Bog, Potsdam (DE); Jan Schaffner, Berlin (DE); Jens Krueger, Berlin (DE); and Alexander Zeier, Berlin (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Aug. 23, 2022, as Appl. No. 17/893,916.
Application 17/893,916 is a continuation of application No. 16/867,377, filed on May 5, 2020, granted, now 11,461,331.
Application 16/867,377 is a continuation of application No. 15/424,639, filed on Feb. 3, 2017, granted, now 10,713,253, issued on Jul. 14, 2020.
Application 15/424,639 is a continuation of application No. 12/234,497, filed on Sep. 19, 2008, granted, now 9,626,421, issued on Apr. 18, 2017.
Claims priority of provisional application 60/994,893, filed on Sep. 21, 2007.
Prior Publication US 2022/0405276 A1, Dec. 22, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/20 (2019.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/2455 (2019.01); G06F 16/27 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/2455 (2019.01) [G06F 16/221 (2019.01); G06F 16/2379 (2019.01); G06F 16/27 (2019.01); G06F 16/283 (2019.01); G06F 16/284 (2019.01); G06F 16/278 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method of processing database information for both transacting and reporting, comprising the steps of:
storing, by a computer system that includes a processor and a memory, said database information in a row format;
storing, by said computer system, said database information in a column format using vertical fragmentation;
in response to a database update request, updating said database information stored in said row format;
in response to said database update request, updating said database information stored in said column format, wherein said database information stored in said row format and said database information stored in said column format are updated concurrently and share a consistent view of said database information; and
in response to a query request to retrieve data, generating a query response based on said database information stored in said column format, wherein generating said query response accesses only one or more columns needed directly for generating said query response.