US 12,229,143 B2
Query refactoring framework
Joerg Weller, Wieblingen (DE); Helmut Holthoff, Heidelberg (DE); Dimitrij Raev, Biebesheim am Rhein (DE); Julian Frank, Muehlhausen (DE); and Hari Venkatesh Subramanian, Wiesloch (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jul. 22, 2022, as Appl. No. 17/870,888.
Prior Publication US 2024/0028594 A1, Jan. 25, 2024
Int. Cl. G06F 16/22 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/2456 (2019.01) [G06F 16/2272 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computing system comprising:
at least one memory;
at least one hardware processor coupled to the at least one memory; and
one or more computer-readable storage media storing computer-executable instructions that, when executed, cause the computing system to perform operations comprising:
receiving a query request specifying at least one data artifact of a virtual data model, wherein the at least one data artifact of the virtual data model comprises a plurality of instructions that are useable to generate a plurality of database operations that, when executed, retrieve and process data stored in a database;
refactoring at least a portion of the plurality of instructions to provide a plurality of operations, at least a portion of the plurality of operations corresponding to refactored instructions of the plurality of instructions;
executing a first operation of the plurality of operations, the executing the first operation comprising retrieving a first set of data from the database and storing at least a portion of the first set of data in a data structure of the virtual data model, external from the database;
executing a second operation of the plurality of operations, the executing the second operation comprising retrieving a second set of data from the database and joining at least a portion of the second set of data with at least a portion of the at least a portion of the first set of data in the data structure and storing at least a portion of joined data in the data structure external from the database, wherein the second operation corresponds to a refactored version of a first instruction of the plurality of instructions, and wherein the first instruction of the plurality of operations is associated with at least one database operation of the plurality of database operations specified to be performed in the database and the second operation is performed outside of the database using the virtual data model; and
returning query execution results comprising data of the at least a portion of the joined data in the data structure or data derived therefrom.