US 9,811,845 B2
System for accelerated price master database lookup
Prajesh K, Mattanur (IN); and Baris Yalcin, Muehlhausen (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by Prajesh K, Mattanur (IN); and Baris Yalcin, Muehlhausen (DE)
Filed on Jun. 11, 2013, as Appl. No. 13/915,122.
Prior Publication US 2014/0365401 A1, Dec. 11, 2014
Int. Cl. G06Q 30/00 (2012.01); G06Q 30/02 (2012.01); G06F 17/30 (2006.01)
CPC G06Q 30/0283 (2013.01) [G06F 17/30442 (2013.01); G06F 17/30528 (2013.01)] 17 Claims
OG exemplary drawing
 
1. A system comprising:
one or more user interface processors;
an application server coupled to the one or more user interface processors; and
an in-memory system coupled to the application server;
wherein the application server comprises a sub-procedure generator processor for generating a plurality of price master data lookup procedures that are capable of being executed in parallel and for storing the plurality of price master data lookup procedures in a repository in the in-memory system;
wherein the application server comprises a pricing processor;
wherein the in-memory system comprises a stored procedure processor and a parallel processor;
wherein the pricing processor is operable to request a price calculation from the in-memory system;
wherein the stored procedure processor is operable to receive the request for a price calculation from the pricing processor, to access the repository of price master data lookup procedures, and to provide the price master data lookup procedures to the parallel processor;
wherein the parallel processor is operable to retrieve price master data in parallel using the price master data lookup procedures to access a price master database without use of a cache memory;
wherein the stored procedure processor is operable to transmit the price master data to the pricing processor;
wherein the pricing processor is operable to calculate a price using the price master data retrieved from the price master database in the in-system memory; and
wherein the generation of the plurality of price master data lookup procedures that are capable of being executed in parallel comprises:
retrieving pricing customization data from a customization database in the in-memory system:
analyzing the pricing customization data;
translating the plurality of price master data lookup procedures into a data flow graph based on the pricing customization data;
identifying independent paths in the data flow graph; and
marking one or more price master data lookup procedures as capable of parallel execution based on the identified independent paths.