US 12,147,450 B2
Efficient real-time hierarchy using change events
Wei Chen, Shanghai (CN)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jan. 4, 2023, as Appl. No. 18/093,265.
Application 18/093,265 is a continuation of application No. 17/121,364, filed on Dec. 14, 2020, granted, now 11,573,982.
Prior Publication US 2023/0146894 A1, May 11, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/28 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 16/248 (2019.01)
CPC G06F 16/282 (2019.01) [G06F 16/2246 (2019.01); G06F 16/2282 (2019.01); G06F 16/2455 (2019.01); G06F 16/248 (2019.01); G06F 16/288 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method performed by a computer system having a memory and at least one hardware processor, the computer-implemented method comprising:
storing a first hierarchy table in a database, the first hierarchy table comprising first hierarchy data that represents a snapshot state of a hierarchy tree of entities at a first point in time, the first hierarchy table having been last updated at the first point in time;
storing a second hierarchy table in the database, the second hierarchy table being different from the first hierarchy table and comprising second hierarchy data that represents an updated state of the hierarchy tree of entities at a second point in time subsequent to the first point in time, one of the first hierarchy table and the second hierarchy table being an active hierarchy table and the other one of the first hierarchy table and the second hierarchy table being an offline hierarchy table;
subsequent to the first point in time, receiving one or more user requests to change entity data stored in a data storage structure, the entity data stored in the data storage structure representing entities of the hierarchy tree;
updating the stored second hierarchy table based on the one or more user requests to change entity data;
subsequent to the updating of the stored second hierarchy table, receiving a first query request for the hierarchy tree;
in response to the receiving of the first query request, determining that the first hierarchy table is the active hierarchy table;
based on the determining that the first hierarchy table is the active hierarchy table, generating a first query result based on the first hierarchy table stored in the database without using the second hierarchy table;
performing a function of an enterprise application platform using the generated first query result;
subsequent to the generating of the first query result, receiving a second query request for the hierarchy tree;
in response to the receiving of the second query request, determining that the second hierarchy table is the active hierarchy table;
based on the determining that the second hierarchy table is the active hierarchy table, generating a second query result based on the second hierarchy table without using the first hierarchy table; and
performing the function of the enterprise application platform using the generated second query result.